What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Downloaded CSV report does not display any submission record.

    Asked by snaplash on April 13, 2015 at 02:32 AM

    When I download the csv file manually all is well, however when I use applescript

     

    do shell script "curl -o /Users/xxxxxx/Dropbox/DATA_DO_NOT_DELETE/SnaplashData.csv 'http://www.jotform.com/csv/41137896486064'"

     

    it produces a blank file, any idea why?

     

    Also if I just use http://www.jotform.com/csv/41137896486064 in the brower it auto downloads but is blank, whats the reason?

     

    Thank you so much in advance

     

    Mark

    CSV no data in JotForm dropbox www
  • Profile Image
    JotForm Support

    Answered by ashwin_d on April 13, 2015 at 09:57 AM

    Hello Mark,

    I'm sorry for the trouble caused to you. 

    I am able to replicate the issue with the csv report you have created. There seems to be some technical glitch where the csv report does not display any submission record.

    I am reporting it to our back end team. We will get back to you as soon as this issue is fixed.

    Thank you!

  • Profile Image

    Answered by snaplash on April 13, 2015 at 12:15 PM

    Thank you!

    I have also noticed over the last few months that the way the data is populated in the downloaded csv keeps changing.

     

    The sort order was different a week ago and I had to alter my code

    The way the address locator was displayed changed a week ago also.

     

    Just Noticed none of the Address Map Locator info is in the manually downloaded csv

     

    Please keep me updated, my business replies on this service, thank you again.

     

    Mark

  • Profile Image
    JotForm Support

    Answered by alp_deniz on April 13, 2015 at 04:25 PM

    Hello,

    The problem is resolved thanks to your post. 

    We had some improvements that unintentionally created some issues, now almost all of them cleared. I will also keep working on Address Map Locator widget output.

    Kind regards

  • Profile Image

    Answered by snaplash on April 13, 2015 at 05:58 PM

    Thank you!

    Has my form ID been changed at all? The form listed above doesnt seem to exist anymore, or is that because I made it public....? 

    The address locator is now showing data, but will this format be consistent?

    The locator address used to be formatted differently and the parsing code I use has to keep on changing to accomodate this. 

     

    Once again, great turnaround Jotform!

  • Profile Image
    JotForm Support

    Answered by KadeJM on April 13, 2015 at 07:21 PM

    So you mean that you are now unable to access your csv file " http://www.jotform.com/csv/41137896486064 "?

    I tried your CSV File and I can confirm it's not working. I could be wrong but I think perhaps our dev may have reset your CSV File due to the previous issue since you said you are unable to access it now except before. We do apologize about any inconveniences that this may have caused you.

    Anyhow yes the Form ID will stay the same. That does not change unless you create and use a clone of the original form then the clone would change and the original would still be the same.

    Can you try creating a new csv report to use and see if that works with it now then with your parsing code?

    Our developer has sorted out most of the problems as he stated but I believe the widget fix may possibly take a little more time if it still an issue on top of this.

  • Profile Image

    Answered by snaplash on April 13, 2015 at 07:27 PM

    its not a problem at all and in no way am I upset :-)

    the url seems to have changed to http://www.jotform.com/csv/51025743815048

    while its not an issue(I just have to change it in my code), I just wanted to confirm it will remain that specific url.

    If you could ask your dev to drop me a line when all is completed and the format wont change.

     

    Thank you Jotform and keep up the good work!

  • Profile Image

    Answered by snaplash on April 13, 2015 at 11:19 PM

    Hi, I am afraid we have a problem again...

     

    There is nothing listed in the csv in both the manual download and also the the url download

     

    http://www.jotform.com/csv/51025743815048 which used to be  http://www.jotform.com/csv/41137896486064

     

    The only thing that shows now is just a few quotation marks and a comma

     

    I am very confused, I tested it a few hours ago and all was fine, but now even less than before. 

     

    Please advise, this is hindering me largely.

    thank you

  • Profile Image
    JotForm Support

    Answered by alp_deniz on April 13, 2015 at 11:35 PM

    Hello,

    Please hold on. I will update in a few minutes.

    Thank you

  • Profile Image
    JotForm Support

    Answered by alp_deniz on April 14, 2015 at 12:02 AM

    Hello,

    The issue is fixed now.

    Thank you for your understanding

    Best

  • Profile Image

    Answered by snaplash on April 14, 2015 at 12:28 AM

    Thank you again so much.

    There is a problem though, even though "IP","Submission Date" are not selected in the fields for output they show up in the url download but not in the manual download.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on April 14, 2015 at 12:36 AM

    Thank you!

    Shown fields are defined while creating the report, so it does not get affected from submissions page. You can create a new report to accomplish this.

    All the best

  • Profile Image

    Answered by snaplash on April 15, 2015 at 01:51 AM

    OK, I am afraid my patience is wearing a little thin.

    The format of the CSV URL download has changed!!!!!! 

    There are now line returns as attached and a few hours ago there were not! All the data was in one line. This is due to the formatting of the address map locator.

    Do I need to keep re-writing my code on a daily basis? My system is fully automated and when your devs change the way the form is outputted, MY system cannot parse the data.

    Please let me know what is going on immediately. I am unable to function like this.

     

  • Profile Image
    JotForm Support

    Answered by alp_deniz on April 15, 2015 at 02:03 AM

    Hello,

    CSV format is being finalized around the clock, and it wont change after it stabilizes for all cases.

     

    Do you find this format useful? It does represent Address Map Locator fields correctly I presume.

    Apologies for the troubles.

  • Profile Image

    Answered by snaplash on April 15, 2015 at 02:14 AM

    Hi, I have attached an image of my job csv and the way that I manipulate the data to suit my needs.

    Personally, my preference would be in one continuous line with no line breaks with only the user inputted data included and not such things as Province: Country: etc

    ie presuming we have to use the existing fields, the output would be:

    11556 Shell Creek Road, Sand Springs, OK 74063, USA ,36.1803951,-96.1465574,Oklahoma,UNITED STATES

     

    Hope that helps, I feel that the majority of users would prefer to have their data on a single line for ease of reading in a spreadsheet.

  • Profile Image
    JotForm Support

    Answered by ashwin_d on April 15, 2015 at 09:31 AM

    Hello snaplash,

    Unfortunately we are unable to see any image you have shared. I would suggest you to please upload the image again and we will take a look. The following guide should help you on how to upload image in forum post:  http://www.jotform.com/answers/277033 

    We will wait for your response.

    Thank you!