Error with import

Hi @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

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.

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

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
https://nimb.ws/oz4SKF

Or else write the From Title and select the option from the drop-down as Donation Form Title

Regard
Raftaar

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,[email protected],10,7

The 10 is the donation amount, and 7 is the donation form id.

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.

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.

Hi @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

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

Regard
Raftaar