How to import submissions?

  • Alm3820
    Asked on October 28, 2020 at 10:50 PM

    Hi I am considering upgrading from a free account however the cost in USD makes it quite pricey in AUD. So there's a fee things I want to check first.


    As my free account has limited space I have been downloading my submissions and then deleting. If I upgrade, is there a way to then upload these submissions again so they can be seen and recorded in the tables/reports?


    I have image uploads as part of my forms and this takes up a lot of space. Is there a way to limit the size of the file that is attached so it takes up less of my storage space?


    Are there any specials or discounts at the moment for membership?


    Thanks

  • BJoanna
    Replied on October 29, 2020 at 3:25 AM

    You can import your data back to JotForm with JotForm Tables. Please check the following guide:

    How to Import Data in JotForm Tables

    You can also check our Import Data app.

    Import App: Easily Import Your Excel or CSV Data into JotForm

    You can limit the size of the files in the file upload field.

    Changing the File Upload Size Limit

    We currently do not have any discounts at the moment.

  • Alm3820
    Replied on October 29, 2020 at 4:40 AM

    I have tried importing, but it is putting the answers for the questions which have multiple selections, all as one colour/answer,

    1603960764 5f9a7fbc24fc9  Screenshot 10

    When it should look like this

    1603960802 5f9a7fe219b56  Screenshot 21

  • Basil JotForm Support
    Replied on October 29, 2020 at 6:19 AM

    Hi,

    Can you please tell us which form are you trying to upload the submissions into?

    Could you also provide a screenshot of the submissions file that you have downloaded?

    Looking forward to your reply.

  • Alm3820
    Replied on October 29, 2020 at 9:28 AM

    Hi I provided 2 screenshots in my post. It’s the child restraint form.


  • Richie JotForm Support
    Replied on October 29, 2020 at 10:14 AM

    I have tested a cloned version of your form and imported some sample submission and I can't seem to replicate the issue.

    1603980694 5f9acd96063a0 2 Screenshot 10

    Please make sure you have followed the template format in the import app in your excel file headers.

    1603980768 5f9acde07630a 3 Screenshot 21

    1603980821 5f9ace1522766 3 Screenshot 32

    Please give it a try again and let us know how it goes.

  • Alm3820
    Replied on October 30, 2020 at 12:08 AM

    I have tried again and it's still doing it. The spreadsheet I am importing from is just an export from my Jotform data so it shouldnt be doing this.

    1604030817 5f9b916168fd3  Screenshot 10

    1604030881 5f9b91a1d8290  Screenshot 21

    1604030888 5f9b91a8f2ae8  Screenshot 32

    1604030910 5f9b91be83142  Screenshot 43

  • Alm3820
    Replied on October 30, 2020 at 12:10 AM

    I have tried Unwrapping the text in the column and it is showing up as now spaces in between selections, even though when it is wrapped it is on the next line. This is directly exported from Jotform. How do I fix this? Is that what is causing the issue? EDIT: I tried adding spaces between a few but it still didn't work

    1604031006 5f9b921e662a2  Screenshot 10

  • Alm3820
    Replied on October 30, 2020 at 12:15 AM

    I have tried using the import app but it is saying to only use One Column for name whereas I have 2.


    1604033224 5f9b9ac81095e  Screenshot 10

  • Mianala Jotform Support
    Replied on October 30, 2020 at 3:12 AM

    Kindly share the excel file which you wish to import. You can do so by sharing a Google Drive link of the file.

    This will help us greatly while investigating the issue and in providing you a solution.

  • Alm3820
    Replied on October 30, 2020 at 3:21 AM
  • Richie JotForm Support
    Replied on October 30, 2020 at 4:45 AM

    You would have to combine your name field values manually in your excel file as the format only shows 1 field in the import app.

    1604047518 5f9bd29edc467 2 Screenshot 10

    Sample output:

    1604047471 5f9bd26f53e1c 3 Screenshot 21

    Please give it a try and let us know how it goes.

  • Alm3820
    Replied on October 30, 2020 at 4:58 AM

    Thanks but how do I make the multiple entries work? Under the issue is corrected etc

  • Richie JotForm Support
    Replied on October 30, 2020 at 6:21 AM

    I'm not sure I understood your inquiry correctly. However, using the import app seems to work at my end.

    https://www.jotform.com/help/308-import-app:-easily-import-your-excel-or-csv-data-into-jotform

    1604053263 5f9be90f12a2d 3 Screenshot 10