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

    Having trouble with import app

    Asked by RainbowChorale on April 26, 2017 at 06:21 AM

    By some reason, I have two forms collecting donation data, and I need to delete one form and keep the other. So I'm trying to import the submissions of the form I'm going to delete into the form I'm going to keep.

     

    I followed the directions to use the import app. Both forms have identical fields. But when I open the csv template to make sure it matches what the app sets up, the fields don't match because I have:

    a) Name Field -- which includes First Name & Last Name

    b) Address -- which includes Address 1, Address 2, City, State, ZIP

     

    My CSV file separates ALL the sub fields out as regular fields -- First Name, Last Name, Address1, Address2, City, etc Plus it appears incapable of matching up the payment info

     

    So, I don't know what to do. The import app does not match the output data.  I used Jotform to export the data. Why doesn't the CSV match how the import app separates the fields? I'm confused why they don't match. When searching forums, I can't find anything older than 2014. I

    Please help me combine the data of my two forms. Please tell me how to do it manually

    I want to import data from RCD Donation Form to RCD Donation Form 2016-2017

    Page URL:
    http://therainbowchorale.org/rcd-donate

    Screenshot
  • Profile Image

    Answered by Sven on April 26, 2017 at 07:45 AM

    You will have to manually change the headers to match the format. For example, the address field is imported with just one header, but your file has several fields for the address data, this would require you to change the headers in your file to match the app format and then you'll be able to import without issues.

     

    Please refer to the guide below, as the notes above are explained in more details:

    Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm

     

    Thank you.

  • Profile Image

    Answered by RainbowChorale on April 26, 2017 at 12:57 PM

    Thank you Sven,

    I read the instructions you sent. But I don't understand how I am supposed to alter my data to fit the import tools interpretation of my data. Why don't your import/export functions match each other. They are both your mechanisms. I'm very frustrated.

    I understand how to match the headers, but I don't know how to alter the actual data.

    1. How do I get my 2 name fields into 1 new name field

    2. How do I get my five address fields into 1 new address field

    3. Why did the import app add "Country"? It was not in the original form.

    4. The import tool does not read my payment data. How do I get this data into the combined form. I can't lose it.

     

    In your link that you attached in your response above, I have the exact same issue as: Kailash108  (January 24, 2016 at 03:22 PM).  Please provide more assistance. Thank you.

     

    Dave

  • Profile Image
    JotForm Support

    Answered by EltonCris on April 26, 2017 at 03:14 PM

    We understand your frustration and we apologize for the inconveniences caused. Unfortunately, most users prefer to have the address data separated when exported for reporting and analytics purposes. However, I think it would be a good addition to have an option where end users can toggle an option that would combine grouped fields data during export so it is easier to import them into the import app.

    Anyway, for now, here are some tips that would help you in combining the data. This is so far the easiest way around.

    First, you must open your submissions data in MS Excel or any similar app. Then merge or combine the data by copying it to notepad and then pasting it back to Excel.

    Here's a short video tutorial which I've created for you.

    https://www.screencast.com/t/6z4tbcFDPSB

    If you want, here are other ways to combine the data on Excel. https://www.ablebits.com/office-addins-blog/2013/10/13/merge-columns-excel-without-losing-data/

    With regards to the "country" shown in the import app, it was just an example. You can always remove it.

    Unfortunately, the import app does support payment fields for security reasons. Payment submissions should always pass through the form.

    Thanks!