Importing submissions results 0 submissions created

  • Profile Image
    GCHS
    Asked on August 14, 2018 at 08:31 PM

    I want to add submissions to one of my jotforms using an excel spreadsheet.  Essentially, I saved the data by having the jotform create an excel form, edited the data (change date of service in the excel form and wanted to import that into a clone of the form.  when i use your import link, the outcome is 0 submissions and 28 fields (which is the amount of fields I have).  Please advise.

    Screenshot
  • Profile Image
    EltonCris
    Answered on August 15, 2018 at 02:32 AM

    Did you copy the same format provided by the import app?

    The first row in your Excel file must be the field names from the given format.

    The 2nd row and up must be your submissions data.

  • Profile Image
    GCHS
    Answered on August 15, 2018 at 06:53 AM

    As I stated above (to expedite time for getting clarification like this) I exported the submissions from the original form, then selected that xls file to import to the clone. Do u need the fxls file sent to u?  This is time sensitive and it took a while for me to get any response which turns out to be a question for clarification. So i’m still at square #1 waiting for help. Is there a means to talk by phone or chat as I am pressed for time. 

     

    Also, the xls sample part of the import app does not scroll so that I can see all the headers in the first row.  See attached annotates screen shot.

     

    1534331221NOTES FOR JOTFORM QUESTION.png1534331283NOTES FOR JOTFORM QUESTION.png

  • Profile Image
    DonaldHag
    Answered on August 15, 2018 at 09:27 AM

    Apologies for the inconvenience, you have to make sure the fields match exactly as the format provided in the import app. Please refer to this guide: https://www.jotform.com/help/308-Import-App-Easily-Import-Your-Excel-or-CSV-Data-into-JotForm

    To provide assistance, as you mentioned, please provide the following:

    1. The link to the original form from which you cloned the submissions.

    2. The link to the new form you wish to import the submissions.

    Using this information, we can match the fields on our end and show you how to import the forms correctly.