Placeholder

Customer Forum

How do I relate/link imported records to existing records?

Workbooks Support Posted: 2011-04-13 15:23

How do I relate/link imported records to existing records?

I want to import activities and link them to existing Cases.

Workbooks Support Posted: Wed, 13.04.2011 - 15:47

You link to existing records by using the "Extend" functionality of the Import feature.  This creates the relevant links and Related Item records.

 

Here's a worked example with a basic 1 line CSV file:

The "Case" column is important.  It contains the Case number, which is also the Object Reference, and will be used to "lookup" / link to the activity to CASE-3243:

1) Save the file as a CSV and create a new import job.  StartImport > Activities - Tasks > Select the CSV file > Next > Next again > Map the Activity fields > Extend - Related Case:

2) Click Case in the Field section > Set File Field to Case > Set Matching Field to Object Reference (this is the mapping that ensures the records are linked and related item records are created):

3) Run the import.  It will import the record(s) and create the related item Activity Link record(s):

4) Approve the import if you're happy with the Import Job results (displayed on the Summary and various other tabs of the import).

5) The records will be correctly linked.  A new Activity has been created and it has been linked to the existing Case: