Export CSV: Unique ID from the first ROW is deleted when Exporting as CSV

  • Profile Image
    MarilynLitt
    Asked on February 28, 2013 at 11:35 PM

    I have two different forms that I save as .csv files.  JotForm is stripping the Uniique ID from the first record on both of these forms.  I tried deleting the first record and JotForm deleted it from the second record.

    This is a problem as we are trying to share data and they are using that ID.

    Thank you.

    Marilyn (Lost Dogs of Texas)

  • Profile Image
    Welvin
    Answered on March 01, 2013 at 02:07 AM

    Hi Marilyn,

    I was able to replicate the issue so I have this thread forwarded to our Level 2 Support for further checking about this matter.

    While waiting for an update from them, I would suggest you to export or save the files as Excel and Save the file again in your computer as CSV before sending them it out or simply use the Excel.

     

    Thanks

  • Profile Image
    NeilVicente
    Answered on March 05, 2013 at 04:40 PM

    I can't recreate this problem. May I ask if you still experience this issue on your end?

  • Profile Image
    MarilynLitt
    Answered on March 07, 2013 at 04:39 AM
    It is still cutting off the unique number and the date. Make a CSV
    report. Save it and open it and you will see the last record missing this
    data. This was bumped to second level because they did recreate the
    problem.
    I attach a file I just downloaded. Record 7 is missing this info. As a
    result, it cannot be processed. What is really needed is the ability to
    send a group of forms in csv via ftp! Since I cannot, I have to download
    to my harddrive and send from there, but even that will not work without
    the missing data.
    Thank you
    Marilyn
  • Profile Image
    NeilVicente
    Answered on March 07, 2013 at 02:51 PM

    Sorry about that. I am now able to see the problem. I'll look into it and have a fix available as soon as possible.

  • Profile Image
    NeilVicente
    Answered on March 07, 2013 at 04:11 PM

    Marilyn,

    Problem has been fixed.

    Best regards