Understanding the Errors in Your Transaction Import

All errors will include a row number next to them. This is to help you as the admin identify where the error occurred. An explanation regarding each error type and how to address it can be found below:

Transaction Import Errors

Invalid Transaction ID format

• The Transaction ID format must be in numerical form, and be less than 10 digits. The format cannot contain letters, special characters or be left empty.

“Invalid Profile GUID or Organization ID”

• The entered Profile GUID or Organization ID must match an already existing profile GUID or Organization ID from your portal. To find the Organization ID, go to the Profiles > Organization page in the portal. It can be found on the under the column titled Organization ID. A profile GUID can be found within a user's profile.

• It cannot be left empty.

• Only a Profile GUID or an Organization ID can be entered in each row. You can not fill in both a Profile GUID and an Organization ID in the same row.

Invalid Date format

• The Date field cannot be left empty. The format that the date must match is the ISO 8601 format, which is as follows: “YYYY-MM-DDTHH:MM+00:00”.

• If a client imports a file without the ISO 8601 format then the clients local timezone will be assigned to the imported transactions.

  • US Timezone Options:

    • EDT = -4:00

    • EST/CDT = -5:00

    • CST/MDT = -6:00

    • MST/PDT = -7:00

    • PST = -8:00

Fund ID does not exist

• The Fund ID must match an existing Fund ID. Fund ID’s can be found on the Giving > Fund page in the portal.

Amount must be at least 1.00 and less than 1,000,000.00

• The entered amount must be between 1.00 and 1,000,000.00.

Invalid Transaction Type

• Valid Transaction Types:

  • Cash, cash, CASH

  • Check, check, CHECK

  • Credit, credit, CREDIT

  • ACH, ach, Ach

• The Transaction Type column cannot be left empty upon import.

Description exceeds character limit

• A description is optional but must not be greater than 50 characters.

Comments/Notes exceeds character limit

• Comments/Notes are optional but must not exceed 500 characters.

Source file doesn't contain any records to import

• The file contains no records for import. The files must contain at least one record to complete import.

If you have any questions or need help, send us a note at support@aware3.com!