- vfxbroAsked on November 03, 2017 at 10:07 PMCopy that. I was able to get the import feature to work and trigger the zap
with a super simple form (1 field entry) however when trying to import an
exported csv or xls on this form
I'm constantly getting
errors when trying to import:
For some reason the headers on the exported csv and xml out of jotform are
significantly different than the required headers on the import page. Any
- JotForm SupportEltonCrisAnswered on November 03, 2017 at 10:10 PM
Looks like there's a bug with the provided sample in the import app. Are you getting this kind of result after selecting a form in the import app? The CSV is fine but the XLS format is different.
It should suppose to give this kind of format for XLS.
I will forward this to our developers as a bug and we'll inform you once this is fixed.
With regards to your question about the headers, exported submissions have different headers compared to the import app. You will still have to follow the same format provided by the import app. However, at the moment, it seems the XLS isn't working so I'd suggest using the CSV format for now.
- JotForm SupportEltonCrisAnswered on November 03, 2017 at 10:27 PM
You can actually still use the XLS format but you will have to use the same headers provided in the CSV format.
I tried it and it worked without any error.
- vfxbroAnswered on November 03, 2017 at 10:43 PMThanks for reporting the bug! I wasn't able to get it to work with the CSV
either. The csv file exported from jotform has more and differently named
headers than what's listed in the ".csv template format" box.
- vfxbroAnswered on November 03, 2017 at 10:43 PMI got it to work with a simple form but it wouldn't work with this
complicated form (attached).
- vfxbroAnswered on November 03, 2017 at 10:43 PMSorry this is the correct file:
- vfxbroAnswered on November 03, 2017 at 10:43 PMSorry agian, here is the correct one:
- JotForm SupportEltonCrisAnswered on November 04, 2017 at 03:43 AM
I think some of your field labels that contain comma are treated as separate labels when opened in Excel.
You can try this file: https://shots.jotform.com/elton/wedding_report.xlsx
This has working columns that match your form. I added 1 sample submission data in it. You can remove it and then add yours.
Another solution is to temporarily remove the comma in your field labels before using the import app so it won't create conflicts with the generated data. Unfortunately, this is the only wat to overcome it.
- vfxbroAnswered on November 04, 2017 at 04:43 PMI'm Having an issue copying over submissions from the Jotform Export
because it's diving certain values into multiple rows (First and Last Name
for example). You can see here when I tried to paste the value in they got
thrown off with the separated rows.
- JotForm SupportTREVONAnswered on November 04, 2017 at 06:06 PM
I have looked at your excel sheet and actually you have additional content like date and submission ID which changes the arrangement of the excel document also. You can use the sample records my colleague shared earlier. A
Also you need to check the location of some columns like the column for emails does not match to the sample xls shared.
For the "Full Name" issue of having two names in one column that is supposed to be like that if you are using Name element
Kindly note the columns must match exactly to what you have in you original form so as when exporting you do not have misplaced content in different columns.
- JotForm DeveloperHelenAnswered on November 07, 2017 at 09:11 AM
Thank you for reporting this issue to us.
Your issue has been fixed now. XLS format shows an example after selecting a form.