Title: Error with import Last modified: December 10, 2017 --- # Error with import * Resolved [sherwin_flight](https://wordpress.org/support/users/sherwin_flight/) * (@sherwin_flight) * [8 years, 4 months ago](https://wordpress.org/support/topic/error-with-import/) * I am trying to import some donations using the built-in importer. * I upload the CSV, map the fields, and it tells me the donations were imported. But the donation doesn’t show up in the system, no Donor record is created, and no WP User is created either. * Test mode is not enabled. No cache plugins are being used either. * Any ideas why it’s not properly importing the data? Viewing 7 replies - 1 through 7 (of 7 total) * [Deepak Gupta](https://wordpress.org/support/users/raftaar1191/) * (@raftaar1191) * [8 years, 4 months ago](https://wordpress.org/support/topic/error-with-import/#post-9769708) * Hi [@sherwin_flight](https://wordpress.org/support/users/sherwin_flight/), * Can you please share the Demo CSV format that you are trying to import. So that we can tell you the reason. * Thanks Raftaar * Thread Starter [sherwin_flight](https://wordpress.org/support/users/sherwin_flight/) * (@sherwin_flight) * [8 years, 4 months ago](https://wordpress.org/support/topic/error-with-import/#post-9771312) * I was just trying with one donation for now, so my CSV file is pretty simple. * The file has 5 columns: * firstname,lastname,email,donationamount,donationformid * At first I was missing the Donation Form ID, and the importer showed a message. So I added that, and the importer no longer shows any errors, and says that the 1 donation WAS successfully imported. * [Deepak Gupta](https://wordpress.org/support/users/raftaar1191/) * (@raftaar1191) * [8 years, 4 months ago](https://wordpress.org/support/topic/error-with-import/#post-9772685) * Hi * I have just now created a CSV and try to import the CSV it’s working fine. * Here is link of the CSV: [https://docs.google.com/a/wordimpress.com/spreadsheets/d/1sKrSI7wSTdt6EZMcgBwVDIbW8qLhMzU3P8T0jHnzMzE/edit?usp=sharing](https://docs.google.com/a/wordimpress.com/spreadsheets/d/1sKrSI7wSTdt6EZMcgBwVDIbW8qLhMzU3P8T0jHnzMzE/edit?usp=sharing) * One Question are you sure the Form ID which you mention is already existed, If not then you can copy it from Dashboard > Donations > All Form > Donation ID [http://nimb.ws/oz4SKF](http://nimb.ws/oz4SKF) * Or else write the From Title and select the option from the drop-down as `Donation Form Title` * Regard Raftaar * Thread Starter [sherwin_flight](https://wordpress.org/support/users/sherwin_flight/) * (@sherwin_flight) * [8 years, 4 months ago](https://wordpress.org/support/topic/error-with-import/#post-9772981) * The shortcode for the form is [give_form id=”7″] and I was using 7 in my CSV. * My CSV looks like this: * John,Doe,johndoe@hotmail.com,10,7 * The 10 is the donation amount, and 7 is the donation form id. * Thread Starter [sherwin_flight](https://wordpress.org/support/users/sherwin_flight/) * (@sherwin_flight) * [8 years, 4 months ago](https://wordpress.org/support/topic/error-with-import/#post-9772991) * I also tried using the form title, instead of the id, like you suggested and the same thing happens. It says it was imported, but it doesn’t actually get imported. * I did request access to the sample CSV file you linked above. * Thread Starter [sherwin_flight](https://wordpress.org/support/users/sherwin_flight/) * (@sherwin_flight) * [8 years, 4 months ago](https://wordpress.org/support/topic/error-with-import/#post-9773728) * I figured out the problem. My CSV file just had one row, which had the data I wanted to import. * The import tool ignores the first row as it expects it to contain the column names. Since my CSV just had one row of data the importer was ignoring it. When I added column names to the first row, and moved my data to the second row, it imported the data as expected. * It may be a good idea to add a note to the import page letting people know that the first row needs to contain column names, and will be ignored by the import tool. * Also, it’s a little confusing because the import tool still says the first row was imported as well. * So when my CSV only had one row the tool was ignoring the first row, but still saying that 1 record was imported, when no records were imported. When I added the column names to my CSV file, the import tool said 2 records were imported, when only 1 record was imported. * When it shows the number of records imported it should NOT include the first row, with column names, in the count since that row doesn’t get imported. So when it shows the total number of records that are imported it should be 1 less than the number it shows now. * [Deepak Gupta](https://wordpress.org/support/users/raftaar1191/) * (@raftaar1191) * [8 years, 3 months ago](https://wordpress.org/support/topic/error-with-import/#post-9780386) * Hi [@sherwin](https://wordpress.org/support/users/sherwin/) * I did request access to the sample CSV file you linked above. -> Given * Thanks for your suggestions we are soon going to add a Sample of Donation Import Form within the Import Tab of the Donations here is the link of the [Github issues](https://github.com/WordImpress/Give/issues/2065) * When it shows the number of records imported it should NOT include the first row, with column names, in the count since that row doesn’t get imported. -> I try to regenerate the issues at my end but not successfully I guess this may be because of the empty fields that are being passed with the CSV. * I am adding the link of the Google Sheet that I am using it [https://docs.google.com/spreadsheets/d/1sKrSI7wSTdt6EZMcgBwVDIbW8qLhMzU3P8T0jHnzMzE/edit#gid=0](https://docs.google.com/spreadsheets/d/1sKrSI7wSTdt6EZMcgBwVDIbW8qLhMzU3P8T0jHnzMzE/edit#gid=0) * Regard Raftaar Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘Error with import’ is closed to new replies. * ![](https://ps.w.org/give/assets/icon-256x256.jpg?rev=2873287) * [GiveWP - Donation Plugin and Fundraising Platform](https://wordpress.org/plugins/give/) * [Frequently Asked Questions](https://wordpress.org/plugins/give/#faq) * [Support Threads](https://wordpress.org/support/plugin/give/) * [Active Topics](https://wordpress.org/support/plugin/give/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/give/unresolved/) * [Reviews](https://wordpress.org/support/plugin/give/reviews/) ## Tags * [Import](https://wordpress.org/support/topic-tag/import/) * 7 replies * 2 participants * Last reply from: [Deepak Gupta](https://wordpress.org/support/users/raftaar1191/) * Last activity: [8 years, 3 months ago](https://wordpress.org/support/topic/error-with-import/#post-9780386) * Status: resolved