This article will cover a standard approach to importing project data to Inspire Planner. There are data templates available for download which will help you format your data correctly and easily map it during the import process.
There are 3 data tables (objects) that make up a standard project:
Step 1 - Preparing Your Data
Step 2 - Import Your Data
In this article, we will use the Salesforce Data Loader to import your data. If you do not already have the tool, you can download here: https://help.salesforce.com/articleView?id=000239784&type=1
Importing Project Data
The first step is to import your Project data.
Importing Project Task Data
Once your Project data has been successfully imported, now it is time to import your Project Task data. Since we need to use the External Project ID to match Project Tasks to Projects, we must use the 'Upsert' function instead of 'Insert'.
Importing Tasks (Salesforce) - Optional
If you would like to import Project Task assignment detail (Assigned To column), then you will need to import Salesforce Tasks. These records will assign Project Tasks to Users in Salesforce. Since we need to use the External Project Task ID to match Salesforce Tasks to Project Tasks, we must use the 'Upsert' function instead of 'Insert'.