Troubleshoot NPSP Data Importer Errors

Create and Subscribe to a Failed NPSP Data Import Records Report

While you can view NPSP Data Import records individually and with list views, there's no built-in method for receiving notifications from NPSP when there are failed NPSP Data Import records. To receive notifications, create and subscribe to a custom report.

1. Click the Reports tab.

2. Click New Report.

3. Search for and select NPSP Data Imports.

4. Click Continue.

5. Click Filters.

6. Click Show me, select All npsp data imports, then click Apply.

7. In Add filter, search for and select Status.

8. Select Failed and click Apply.

9. Click Outline.

10. In Add column, search for and select Failure Information.

11. Add additional columns to include in the report.

12. Click Save & Run.

13. Enter a Report Name such as Failed Data Imports.

14. Choose a Folder where you'd like to store the report and click Save.

15. Next to Edit, click the arrow and select Subscribe.

16. Choose a Frequency (we recommend Daily) and a Time.

17. Save the report.

According to the frequency you chose, Salesforce sends an email with a report summary and a link to view the report.

Analyze Failed NPSP Data Import Records

Let's look at a failed NPSP Data Import record in detail. In this example, a validation rule on the Payment object prevented NPSP Data Importer from creating or updating one or more records. But how can you tell which records?

Within an NPSP Data Import record, you'll see Imported and Import Status fields for each record NPSP Data Importer tried to create or update. When NPSP Data Importer can't create or update a record, the Imported field is blank and the Import Status describes what happened.

Let's look at the Imported and Import Status fields to understand which records the NPSP Data Importer successfully processed.

From this field data we can see that the donor's Contact, Household Account, and Opportunity records were created, but not the Payment record.

Resolve a Failed NPSP Data Import

For this example, you could resolve the issue by disabling or adjusting the validation rule so that it doesn't execute when using Gift Entry or during data import. For more information see Managing Validation Rules.

Important Once the validation rule no longer prevents NPSP Data Importer from processing successfully, you must reprocess the previously failed NPSP Data Import records.

To reprocess failed NPSP Data Import records:

1. Open the App Launcher and click NPSP Data Imports.

2. Select the Failed Data Imports list view.

3. Click Import All Data Import Records. If you selected some records to import, click Import Selected Data Import Records.

   

   Note Start Data Import reprocesses all failed Data Import records.

4. Click Begin Data Import Process.

5. When the data import process completes, you'll see the results including the number of records processed, imported, and failed. Click Close to return to the NPSP Data Import tab.