To register for the forums, please contact your Digital-Clay representative.
Importing full records
Importing full records
Can ClayIntegrator import full records that belong to different tables?
-
DavidSofer
- Posts: 69
- Joined: Wed May 13, 2009 6:47 pm
Re: Importing full records
I'm not sure I understand what you mean. But if you mean you have data split over several tables then yes, you can import each table in a different session while still maintaining the links between the records.
You do this by importing the linked ID field into the Digital-Clay table, and then refer to this ID field when importing a linked table. For example, say you are importing Customers and Contacts: You import the Customers with the CustomerID, then when you import the Contacts, you map the CustomerID field to the Digital-Clay Customer:CustomerID field and define this field as the unique identifying field for the Customer table.
You do this by importing the linked ID field into the Digital-Clay table, and then refer to this ID field when importing a linked table. For example, say you are importing Customers and Contacts: You import the Customers with the CustomerID, then when you import the Contacts, you map the CustomerID field to the Digital-Clay Customer:CustomerID field and define this field as the unique identifying field for the Customer table.