Import the Records

Start The Import

It’s time to send our imported records to their final homes in Salesforce by creating or updating new contacts, accounts, and opportunities.

Start on the NPSP Data Imports page again, on the Dry Run - Validated list view. (Remember you can always find NPSP Data Imports through the App Launcher.) Don’t worry that you don’t see the record that we fixed on the last step in this list view. It will still be processed without any problems because we fixed the error.

  1. Click Start Data Import.

    The Dry Run - Validated list view with the Start Data Import button highlighted

  2. Verify that your Configuration Options are the same as for our dry run in step 4. They should be:
    1. Batch Process Size is “50”
    2. Contact Matching Rule is “Firstname,Lastname,Email”
    3. Donation Matching Behavior is “Do Not Match - No matching is attempted; new records are created.”
  3. Click Begin Data Import Process.

Just like with the dry run, you’ll see a status screen to show you how many records are imported and if there are any errors.

The NPSP Data Import status indicating completed with 10 records processed, 10 records imported, and 0 records failed.

You should have imported 10 records with 0 errors. If not, go back and make sure you followed the instructions in this step, and previous steps, correctly. 

Click Close, and let’s check out some of the records we imported.

Review The Imported Records

Let’s look at the contact we created back in step 2 to see how NPSP Data Importer updated the records.

Go to Global Search and search for Haley Brown. Click on her contact to open her record.

Haley Brown’s contact record.

The utility has updated her contact information with an affiliation to her employer, a home address, phone numbers, and email preference.

Click on the Brown Household account from Haley’s contact record to see that NPSP Data Importer created contact records for her husband (Jake) and kids (Penny and Bennett) and associated them to the household account.

The members of the Brown household on their account page.

The importer also associated Haley with her employer, Acme Corporation, and set it as her primary affiliation.

Acme Corporation listed as Haley Brown’s primary affiliation.

Don’t forget about the donation record that was created, as well.

A closed won opportunity connected to Haley Brown for $300

Now check out the record for Amer Shakil—the record with the error—by searching for it in Global Search.

You’ll notice that it created a new contact for Amer and associated it to his company, Edge Communications, with a primary affiliation. It also imported his donation.

Amer Shakil’s related organization, Edge Communications, and opportunity, for a $110 donation

Take a minute to open the CSV in another window, then use global search to find a few of the records in Salesforce to see how NPSP Data Importer brought that information in to your org. Understanding how the template translates to records in Salesforce is key to taking on more complicated imports.

Time to Celebrate!

If you followed along with all five steps of this project, you’ve laid the foundation you need to get contact, account, and donation data from other systems into Salesforce and NPSP. This is just the beginning of what you can do with NPSP Data Importer, but key to unlocking Advanced Mapping and other features. Check out the Resources below if you’d like to learn more.

Now all that’s left to do is select the Trailhead Playground in which you followed along with the steps and click Verify to finish this project and earn your badge!

Resources