How to import submissions?

  • Profile Image
    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

  • Profile Image
    BJoanna
    Answered on October 29, 2020 at 03: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.

  • Profile Image
    Alm3820
    Answered on October 29, 2020 at 04: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_

    When it should look like this

    1603960802_5f9a7fe219b56_

  • Profile Image
    Basil_A
    Answered on October 29, 2020 at 06: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.

  • Profile Image
    Alm3820
    Answered on October 29, 2020 at 09:28 AM

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


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

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

    1603980768_5f9acde07630a_3.png

    1603980821_5f9ace1522766_3.png

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

  • Profile Image
    Alm3820
    Answered 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_

    1604030881_5f9b91a1d8290_

    1604030888_5f9b91a8f2ae8_

    1604030910_5f9b91be83142_

  • Profile Image
    Alm3820
    Answered 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_

  • Profile Image
    Alm3820
    Answered 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_

  • Profile Image
    Mianala
    Answered on October 30, 2020 at 03: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.

  • Profile Image
    Richie_P
    Answered on October 30, 2020 at 04: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.png

    Sample output:

    1604047471_5f9bd26f53e1c_3.png

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

  • Profile Image
    Alm3820
    Answered on October 30, 2020 at 04:58 AM

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

  • Profile Image
    Richie_P
    Answered on October 30, 2020 at 06: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.png