• Resolved sherwin_flight

    (@sherwin_flight)


    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)
  • 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
    http://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,johndoe@hotmail.com,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

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Error with import’ is closed to new replies.