Appearance
Importing Contact Locations
Contact Locations is a join table that controls which contacts are assigned to locations.
To import contact locations, you must provide a CSV file containing the required information.
The available columns for this table are:
| Column | Description |
|---|---|
contact_id | Required. The database ID (UUID) of an existing contact. |
location_id | Optional. The database ID (UUID) of an existing location. |
location_code | Optional. The code of an existing location. Bridge Column. |
Contact
A contact is required for every contact location assignment.
Currently, there is no bridge column available for contacts.
This is because contacts do not have a single unique value that can reliably identify them. For example, two different customer records could have contacts with the same email address.
We hope to support contact bridge column in the future. For now, you will need to map the Quick Docket contact IDs to your existing data before importing.
Location
A location is required for every contact location assignment.
You can specify the location using either:
location_idlocation_code
If both columns are provided, location_id takes precedence.
The location_code column acts as a bridge column, allowing you to import data without needing to know the database IDs generated by Quick Docket in advance.
Example CSV
All columns
csv
contact_id,location_id,location_code
550e8400-e29b-41d4-a716-446655440000,660e8400-e29b-41d4-a716-446655440000,LOC001Required columns and location_code
csv
contact_id,location_code
550e8400-e29b-41d4-a716-446655440000,LOC001