Try each of the following steps in order until the issue is resolved:
- Open the import file
- Remove the header record from the import file
- Open import file in Excel, search the whole worksheet for commas and remove any found
- Add the DDI Source fields after the gift schedule End On date
- While the ID field can be blank, the field is required in the import file. Therefore insert a column for the gift import ID prior to the gift fields if it is not already present. Gift ID should be located between the fields Credit Card Name and Gift Amount on the Recurring Gifts Import File Layout, column BG if the file is opened in Excel.
- Change Gift Amount column format to Number instead of currency, any amounts over 1000 will have a comma added automatically when the type is currency
For more information, refer to: