Import App: XLS format does not show an example after selecting a form

  • Profile Image
    vfxbro
    Asked on November 03, 2017 at 10:07 PM
    Copy 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:
    https://www.jotform.com/submissions/41518176495967
    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
    tips?
  • Profile Image
    EltonCris
    Answered 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.

    Thanks

  • Profile Image
    EltonCris
    Answered 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.

    Example:

    I tried it and it worked without any error.

  • Profile Image
    vfxbro
    Answered on November 03, 2017 at 10:43 PM
    Thanks 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.
    ...
  • Profile Image
    vfxbro
    Answered on November 03, 2017 at 10:43 PM
    I got it to work with a simple form but it wouldn't work with this
    complicated form (attached).
    ...
  • Profile Image
    vfxbro
    Answered on November 03, 2017 at 10:43 PM
    Sorry this is the correct file:
    ...
  • Profile Image
    vfxbro
    Answered on November 03, 2017 at 10:43 PM
    Sorry agian, here is the correct one:
    https://docs.google.com/spreadsheets/d/1zu9RlqEpSh5xNMU2JbQEpes-PMyF-QCrDkaibzbSUT4/edit?usp=sharing
    ...
  • Profile Image
    EltonCris
    Answered 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.

    Result:

    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.

    Example:


  • Profile Image
    vfxbro
    Answered on November 04, 2017 at 04:43 PM
    I'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.
    https://docs.google.com/spreadsheets/d/1zu9RlqEpSh5xNMU2JbQEpes-PMyF-QCrDkaibzbSUT4/edit#gid=541708668
    ...
  • Profile Image
    TREVON
    Answered 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.

  • Profile Image
    Helen
    Answered on November 07, 2017 at 09:11 AM

    Hello @vfxbro,

    Thank you for reporting this issue to us.

    Your issue has been fixed now. XLS format shows an example after selecting a form.

    Thanks,