- RainbowChoraleAsked 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-2017Page URL:
- SvenAnswered 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:
- RainbowChoraleAnswered 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.
- JotForm SupportEltonCrisAnswered 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.
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.