What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to transfer submission into a form.

    Asked by AthleteTrax2 on February 25, 2016 at 06:08 PM

    If I clone a certain registration page from my site and form another registration page with it, how can I transfer all the submissions over to the cloned page?

     

    Please advise

     

    Thank you

  • Profile Image
    JotForm Support

    Answered by BDAVID on February 25, 2016 at 06:16 PM

    If you have the submissions in CSV or Excel format, you can use the Import Data app: https://apps.jotform.com/app/import_data

    Let us know if you have more questions.

  • Profile Image

    Answered by AthleteTrax2 on February 25, 2016 at 07:18 PM

    I tried that link but when I go to import it tells me I have 59 errors it syas the template must match the form.  I am trying to import the three Teams fro Battle @ the Beach & Boardwalk to The empty Battle at the Beach & Boardwalk form

  • Profile Image
    JotForm Support

    Answered by BDAVID on February 25, 2016 at 09:28 PM
  • Profile Image

    Answered by AthleteTrax2 on February 26, 2016 at 12:26 AM

    I tried importing and it did not work

    This is what I got

    Battle at the Beach & Boardwalk
    Some of the fields have special formatting, like the address and time fields. Ensure the file's format is identical to the template.
     Include 'Submission Date' column in template file.
    .csv template format - The top line of your csv file should be identical and the remaining lines should match the format.

    nb: If there is no data for a certain column leave it empty but remember the commas. 

    .xls template format - The top line of your csv file should be identical and the remaining lines should match the format.
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    Q
    R
    S
    T
    U
    V
    W
    X
    Y
    Z
    AA
    AB
    AC
    AD
    AE
    AF
    AG
    AH
    AI
    AJ
    created_at 95_Club Name 3_Club Contact Name 6_E-Mail Address 7_Phone Number 5_Coach Address 62_How Did You Hear About Us? 93_Comments/Questions 94_HOW MANY TEAMS ARE YOU REGISTERING? 19_Team 1 Coach's Name 20_Coach's E-Mail 69_Team 1 Grade 64_Team 1 Age 65_Team 1 Gender 66_Team 1 Skill Level 67_Can You Play Up? 68_Can You Play Back to Back? 96_Comments: 23_Team 2 Coach 24_Coach's E-Mail 75_Team 2 Grade 70_Team 2 Age 71_Team 2 Gender 72_Team 2 Skill Level 73_Can You Play Up? 74_Can You Play Back to Back? 98_Comments: 44_Team 3 Coach's Name 42_Coach's E-Mail 81_Team 3 Grade 76_Team 3 Age 77_Team 3 Gender 78_Team 3 Skill Level 79_Can You Play Up? 80_Can You Play Back to Back? 99_Comments: 2015-04-24 16:13:08 sample input text Smith, John sample@example.com 01562, 8918929 356 Fifth Avenue, Manhattan, New York, New York State, 10009, United States sample input text sample input text 4 sample input text sample input text 5th Grade 13 Male Competitive (A) Yes No sample input text sample input text sample input text 11th Grade 15 Male Average (B) Yes Yes sample input text sample input text sample input text 5th Grade 11 Female National (AA) No Yes sample input text
     
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    Q
    R
    S
    T
    U
    V
    W
    X
    Y
    Z
    AA
    AB
    AC
    AD
    AE
    AF
    AG
    AH
    AI
    AJ
     
     
     
    Change Battle-at-the-Beach-amp-Boardwalk (1).csv x

    Import
    Errors
    Error: Unrecognised Field ""created_at"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""95_Club Name"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""3_Club Contact Name" ". Please check the template. The top row must match the template.
    Error: Column header not found. "" instead. Please check the template
    Error: Unrecognised Field ""6_E-Mail Address"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""7_Phone Number"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""5_Coach Address"". Please check the template. The top row must match the template.
    Error: Column header not found. "" instead. Please check the template
    Error: Column header not found. "" instead. Please check the template
    Error: Column header not found. "" instead. Please check the template
    Error: Column header not found. "" instead. Please check the template
    Error: Column header not found. "" instead. Please check the template
    Error: Unrecognised Field ""62_How Did You Hear About Us?"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""93_Comments/Questions"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""94_HOW MANY TEAMS ARE YOU REGISTERING?"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""19_Team 1 Coach's Name"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""20_Coach's E-Mail"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""69_Team 1 Grade"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""64_Team 1 Age"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""65_Team 1 Gender"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""66_Team 1 Skill Level"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""67_Can You Play Up?"". Please check the template. The top row must match the template.
    Error: Unrecognised Field " "68_Can You Play Back to Back?"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""96_Comments:"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""23_Team 2 Coach"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""24_Coach's E-Mail"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""75_Team 2 Grade"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""70_Team 2 Age"". Please check the template. The top row must match the template.
    Error: Unrecognised Field " "71_Team 2 Gender"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""72_Team 2 Skill Level"". Please check the template. The top row must match the template.
    Error: Unrecognised Field " "73_Can You Play Up?"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""74_Can You Play Back to Back?"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""98_Comments:"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""44_Team 3 Coach's Name"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""42_Coach's E-Mail"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""81_Team 3 Grade"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""76_Team 3 Age"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""77_Team 3 Gender"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""78_Team 3 Skill Level"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""79_Can You Play Up?"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""80_Can You Play Back to Back?"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""99_Comments:"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""47_Team 4 Coach's Name"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""45_Coach's E-Mail"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""87_Team 4 Grade"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""82_Team 4 Age"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""83_Team 4 Gender"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""84_Team 4 Skill Level"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""85_Can You Play Up?"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""86_Can You Play Back to Back?"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""100_Comments:"". Please check the template. The top row must match the template.
    Error: Unrecognised Field " "50_Team 5 Coach's Name"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""51_Coach's E-Mail"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""63_Team 5 Grade"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""88_Team 5 Age"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""89_Team 5 Gender"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""90_Team 5 Skill Level"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""91_Can You Play Up?"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""92_Can You Play Back to Back?"". Please check the template. The top row must match the template.
    Error: Unrecognised Field ""101_Comments:"". Please check the template. The top row must match the template.
    Results
    0 Submissions Created.
    0 Fields per Submission.
    Powered by JotForm JotForm Apps
  • Profile Image
    JotForm Support

    Answered by Chriistian on February 26, 2016 at 04:59 AM

    Please note that the csv file should be identical with the template format being shown by the import app. 

    Example (This is just a demo for a sample form, your forms will have different csv template): 

    Current import app template that you need to replicate in the csv.

    Current csv file downloaded from the original form.

    Now we need to edit the csv file so that it looks the same as template format shown in the app.

    Do the same to the rest of the fields until everything is the same.

    Template:

    CSV File:

    Now once everything is the same, save the CSV. Then click the Change button to upload the CSV file to the app. Click Import afterwards to complete the Import of the submissions.

    The import should now be successful and no error will appear when you use the import app.

    For a more detailed guide, please check out this article: How To Import CSV Data Into Jotform

    If you need further assistance, please let us know.