• Replies 13 replies
  • Subscribers 342 subscribers
  • Views 125 views
  • Users 0 members are here
Options
Related

Contribution Import Utility error

T.C. Brown
$organization

Hi,

One of our consortium orgs always uses the contribution import utility for Giving Tuesday donations. Now that they have their data ready, when I try running this report, I keep getting errors.

This is the first since last year that I have tried to run this report. In May we went with Tessitura Merchant Services and the first error I got was related to PSPE. I commented out the Account Number, account Name and exp date in the xml file and deleted those columns since documentation mentioned utility would fail if Account Number and exp date fields were included. I then got the error "Expected row count is less than 1 or is undefined." I tried various things and even commented out all but the 3 minimum required fields as mentioned in the documentation, but I keep getting the 2nd error. I have confirmed that the import file and the xml file have the same three columns in each.

Has anyone had a similar issue with the contribution import utility?  If so, what have you done to make it work?

Appreciate any recommendations.

T.C.

Parents
  • $organization

    When the bulk import tool returns errors I do the following:

    1. Make a copy of the file and alter the copy so that only one row of data and headers is in the file.
    2. Run the import using this pared-down copy.
    3. If it imports successfully, then the issue lies in the data. You can eyeball the data and see if there are any glaring issues, but if you don't see any, try adding half of the data back into the pared-down copy and then try the import again. If it fails, then the data is in that section (at least), so you can keep stripping down the file contents in half until you find the offending row(s).
    4. If Step 2 did not import successfully, then the problem is most likely with your XML file. Using the same idea as Step 3, look over your header and XML contents for glaring issues. If none are found, create a new XML file with only the one half of the columns you want to import and alter your data file correspondingly. Try importing this. If it fails, then the problem is with the columns in this section of the XML, and you can keep repeating the process until you find the offending column(s). If the import is successful, then try with the other half of the columns until you find the culprit.

    I like to use NotePad++ when altering these files.

    Good luck!

Reply
  • $organization

    When the bulk import tool returns errors I do the following:

    1. Make a copy of the file and alter the copy so that only one row of data and headers is in the file.
    2. Run the import using this pared-down copy.
    3. If it imports successfully, then the issue lies in the data. You can eyeball the data and see if there are any glaring issues, but if you don't see any, try adding half of the data back into the pared-down copy and then try the import again. If it fails, then the data is in that section (at least), so you can keep stripping down the file contents in half until you find the offending row(s).
    4. If Step 2 did not import successfully, then the problem is most likely with your XML file. Using the same idea as Step 3, look over your header and XML contents for glaring issues. If none are found, create a new XML file with only the one half of the columns you want to import and alter your data file correspondingly. Try importing this. If it fails, then the problem is with the columns in this section of the XML, and you can keep repeating the process until you find the offending column(s). If the import is successful, then try with the other half of the columns until you find the culprit.

    I like to use NotePad++ when altering these files.

    Good luck!

Children