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.
Exported Excel Submissions - missing data due to unknown contentAsked by qcrespo on April 01, 2014 at 07:09 PM
The function of exporting submissions to XLS or CSV fails again, and I need it now, please :-((
XLS can't be opened and CSV looses data, giving the headings but with the data empties (only for some questions).
(Note: I have verified that all the questions are marked before proceeding).
Thank you !!
Hi, I have reported this to our second level on this thread, you will be notified of any update on that thread, thanks for your patience.
Please, some of the data appear as blank in the CSV table (in PDF ok).
I need it ASAP, please.
Sorry and thanks.
I could replicate the same situation. I've set this thread to private so I can let you the download link:
Please check if this file contains the requested data.
Let us know if we can be of more assistance.
Thank you very much but unfortunatelly your CSV results are as mine: empty in some parts.
Please have a look to the PDF generated: For example the first 3 respondants (identified by MUNICIPIO, that is Abades, Adrados and Aguilafuente) clicked the mark for the question
"3.- ¿De quién depende? >> 3.2.- Servicio de ayuda a domicilio >> Junta o Diputación",
but the total amount of clicks in the CSV are zero (for ALL the survey).
I am so sad and so nervous, because the deadline for my presentation is almost over, really :-(
Thank you in advance for all you can do
I have now forwarded this to our developers so they can check it again. They will respond to you here once this is resolved.
Our apologies for this inconvenience.
Once again, please please please try to mend it. I am in a terrible hurry. Thanks
I honestly said to you "no urgent" when it was (in another post), or I said, "ok, if export to XLS fails but CSV works I go ahead, so forget", but now it is very uegent. Very much :-(( Sorry and thanks
JotForm Support Manager
We know and can relate to your concern, but we cannot give you an ETA for the resolution. But you should be informed on this thread.
A part of Excel and CSV download problems are fixed. Could you please try once again?
Please let me know about it, I will be trying to do my best to assist you.
Done, but unfortunatelly it continues wrong: XLS is corrupt (no matter since exporting to CSV works) but CSV is empty for some answers.
I enclose the copy of the generated PDF: https://www.dropbox.com/s/l0p0jn0ylmlclkf/121%20encuestas.pdf
And also the XLS as well (transformed from CSV): https://www.dropbox.com/s/bz04i2di41cms4h/ENCUESTA-SITUACI-N-MUNICIPIOS-SEGOVIANOS-1.csv.xls
Please observ that in the PDF for the 1st respondant "001-Abades", in questions "3.2.- Servicio de ayuda a domicilio" tha answer is "Junta o Diputación" and for the question "3.6.- Ayuda a los inmigrantes" it is also tha same answer "Junta o Diputación". However in XLS the columns U (3.2 results) and AO (3.6 results) are empty for ALL the respondants !!
Could it be that the heading "Junta o Diputación" has a strange letter, not standarized? (ó = o with an accent in the Spanish letters)
I am getting fool and desperated. Thanks
Our developer was able to received your latest message. He will provide response here also as soon as available.
I was able to see the mentioned problem in the submission with the column header "Junta o Diputación" -- BUT can you also try editing that column header?
You can change the column heade to a simpler one like "Junta" only... the data will not be lost as you are only changing the header name.
Try changing the text and check the submission data again in Excel. Check if the issue persist even after doing this procedure already.
Update us of the results.
There is a issue regarding matrix fields with unicode characters. I am working on it now, however, please consider filling them manually if you are in danger of passing the due date. Meanwhile, I will let you know when it is ready.
Hello and thanks again for concerning about my worries.
I have created a small new test form to check it with rare characters and normal characters. And well, regarding rare characters (á é í ó ú ñ) it does not fail in a matrix of radio buttons, but it fails with a matrix of checkboxes, as it is my case.
Also I have changed the name of that dammed column (Diputación to Diputacion), but it seems that as the data were entered already with accent, those data still don't appear. Could I access to the full table online and substitute together all "Diputación" for "Diputacion" instead?
Thank you for any effort ;-)
Thanks for your input our developer was able to receive your response and will let you know once the issue with matrix fields with unicode characters has been fixed. Thank you for your patience.
This issue is fixed now. Thank you very much for your help and patience.