I am trying to import form from a csv file.

  • RefillMyBottle
    Asked on September 7, 2017 at 2:31 AM

    Hi, I am trying to import form from a csv file. Right now, I am just testing the process so I litteraly did:

    - paste the top row as indicated in the import tool in a csv file

    - paste the example that was given in the import tool

    - select the file and launch the importation

    It did created the submission but only created 1 field ( the first one "your name")

    Ex:

    -> header

    "5_Your Name", "6_Are you...", "7_What's the name of the Refill Station?", "9_What kind of water do you offer?", "10_Is the water free?", "8_If not free, how much do you charge for a 1 litre refill?", "11_When are you open? ", "12_You are open from", "13_You close at", "14_Phone Number", "15_E-mail", "16_Website", "25_Facebook page", "26_Instagram", "27_Twitter ", "24_Description of your place", "28_Where are you/Which local Refill community are you part of?", "29_If no established community is suitable, please tell us where you are", "17_Take a photo of your business", "22_Please use the map below to find the correct location of your business/the fountain. Please drag the red pin to the right location if needed", "20_if the tool above is not precise enough, paste a link to your location"

    -> first line

    "Smith, John", "updating an existing listing?", "sample input text", "Tap,Gallon", "Yes, but a donation is appreciated,No", "sample input text", "Wednesday,Daily,Thursday", "07:30am-10:30pm", "07:30am-10:30pm", "01562, 8918929", "sample@example.com", "sample input text", "sample input text", "sample input text", "sample input text", "sample input text", "Bali", "sample input text", "sample widget", "sample widget", "sample input text"

  • Chriistian Jotform Support
    Replied on September 7, 2017 at 5:43 AM

    Please note that the top rows of your CSV file should match the format as indicated in the Import Tool. If you ensured that you have done this and the issue still persists, could you please provide us a screenshot image of your CSV file and the issue on Import Tool so that we can investigate the issue further? 

    Here's the guide on How to Post Screenshots to Our Support Forum.

    We'll wait for your response.

  • RefillMyBottle
    Replied on September 7, 2017 at 11:48 PM

    Hi,

    So this is what I get from the import tool:

    I am trying to import form from a csv file Screenshot 40

    1) First try, where I pasted:

    I am trying to import form from a csv file Screenshot 51

    the import does not work and I get this message:

    Error: Unrecognised Field ""5_Your Name", "6_Are you...", "7_What's the name of the Refill Station?", "9_What kind of water do you offer?", "10_Is the water free?", "8_If not free, how much do you charge for a 1 litre refill?", "11_When are you open? ", "12_You are open from", "13_You close at", "14_Phone Number", "15_E-mail", "16_Website", "25_Facebook page", "26_Instagram", "27_Twitter ", "24_Description of your place", "28_Where are you/Which local Refill community are you part of?", "29_If no established community is suitable, please tell us where you are", "17_Take a photo of your business", "22_Please use the map below to find the correct location of your business/the fountain. Please drag the red pin to the right location if needed", "20_if the tool above is not precise enough, paste a link to your location"". Please check the template. The top row must match the template.

    No submission imported.

    2) Second try, I pasted (taking out the "" of the first field):

    I am trying to import form from a csv file Screenshot 62

    the import does work and creates a submission but only one field is filled:

    Results

    1 Submissions Created.

    1 Fields per Submission.

     

    How can I get the import to fill all the field of the submission.

     

    Thanks

  • Ashwin JotForm Support
    Replied on September 8, 2017 at 2:50 AM

    Please let us know in which form you want want to import the data. I would also request you to please share the csv file which you want to use to import data in form?

    Please send and email with the csv at support@jotform.com with the subject line as "Thread #1241701" and we will take a look.

    We will wait for your response.

  • RefillMyBottle
    Replied on September 10, 2017 at 9:42 PM

    Hi,

    I just sent the mail.

    Thanks,

  • Ashwin JotForm Support
    Replied on September 10, 2017 at 10:51 PM

    I did check our email inbox and we have received your email.

    We will check it and get back to you soon.

     

  • Ashwin JotForm Support
    Replied on September 14, 2017 at 3:09 AM

    I did check the csv file you have shared and it seems the column does not match the form question. Example:

    Your second question in form is "What's the name of the Refill Station?" and third question is "Which kind of business are you?" but in the csv file, the questions are different. Please check the screenshot below:

    I am trying to import form from a csv file Screenshot 20

    Please note the header in csv file should be exactly same as displayed in the "Import" app. Here is the correct csv format which you should have to import the data in form:

    "created_at", "5_Your Name", "7_What's the name of the Refill Station?", "31_Which kind of business are you?", "32_If "other" type of business, please describe here.", "9_What kind of water do you offer?", "10_Is the water free?", "8_If not free, how much do you charge for a 1 litre refill?", "11_When are you open? ", "12_You are open from", "13_You close at", "14_Phone Number", "15_E-mail", "16_Website", "25_Facebook page", "26_Instagram", "27_Twitter  ", "24_Description of your place", "28_Where are you/Which local Refill community are you part of?", "29_If no established community is suitable, please tell us where you are", "17_Take a photo of your business", "22_Please use the map below to find the correct location of your business/the fountain. Please drag the red pin to the right location if needed", "20_if the tool above is not precise enough, paste a link to your location"

    "2015-04-24 16:13:08", "Smith, John", "sample input text", "Hotel/Resort", "sample input text", "Filtered Water,Gallon", "Yes, but a donation is appreciated,No", "sample input text", "Wednesday,Daily", "07:30am-10:30pm", "07:30am-10:30pm", "01562, 8918929", "sample@example.com", "sample input text", "sample input text", "sample input text", "sample input text", "sample input text", "Lembongan", "sample input text", "sample widget", "sample widget", "sample input text"

    Hope this helps.

    Do get back to us if you have any questions.