The purpose of this article is to run you through how you can import historic Northpass Learner data into your Salesforce organization. How do you get the data out of Northpass? Time to check out our documentation on exporting Northpass data for use in Salesforce.
⛑Heads Up ⛑
- The CSV has older data than what already exists on the Contact, that data will be ignored, but the error report on Bulk Data Load Jobs page will show the following for each of the lines of old data (as shown in Step 8 below):
"FIELD_CUSTOM_VALIDATION_EXCEPTION:Cannot update record due to old timestamp.:--"
*You can import up to 50,000 records at a time. To import more than 50k entries, you can either split the CSV file, or use the Salesforce DataLoader
There are two ways to access the import wizard:
Enter & select Data Import Wizard in the Quick Find Box
Click the Import button on the Enrollments tab list view
Click the Launch Wizard button
Select the Custom Objects tab & click the Enrollments custom object
Choose to Add new and update existing records & select External id (External ID) as the Match by field
Click CSV & then click Choose File & select the CSV you would like to upload & click Next
Note: The CSV file used here should be the CSV obtained from your data export.
To automatically map the CSV field to the Salesforce custom fields, the CSV column headers will need to be named exactly as the custom fields. If not, manual mapping will be required. After mapping, click Next.
Click Start Import
You will see the total number of records that were created as a result of the import