Difference between revisions of "Autoloader for Associations"
From SmartWiki
(→Auto Loader Settings) |
(→Auto Loader Settings) |
||
| Line 53: | Line 53: | ||
# Under '''New Record''' Section, click '''Create''' if new association records will be created. Unclick when you only want to update existing records. | # Under '''New Record''' Section, click '''Create''' if new association records will be created. Unclick when you only want to update existing records. | ||
# Under Column Mapping, map each column of the file to your SmartSimple Standard Fields and/or Custom Fields. | # Under Column Mapping, map each column of the file to your SmartSimple Standard Fields and/or Custom Fields. | ||
| − | # To add/update association records, the following standard fields should be included: | + | # To add/update association records, the following standard fields should be included: |
| + | |||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
| − | || | + | ||SF/CF |
| − | || | + | ||ADD |
| − | || | + | ||UPDATE |
| + | ||[[Autoloader_for_Associations#Types_of_Associations|Type of Association]] | ||
|- | |- | ||
| − | ||Association ID | + | ||Association ID |
| − | |||
|| | || | ||
| + | ||required | ||
| + | ||Types: 1-6 | ||
|- | |- | ||
| − | || | + | ||[[Determining_the_companyid|Company ID]] |
| − | || | + | ||required |
| − | || | + | ||required |
| + | ||Type 1,2,5 | ||
|- | |- | ||
| − | || | + | ||[[Determining_the_userid||Contact ID]] |
| − | || | + | ||required |
| − | || | + | ||required |
| + | ||Type 1,3,4 | ||
|- | |- | ||
| − | || | + | ||[[Determining_the_roleid|Role ID]] |
| − | || | + | ||required |
| − | || | + | ||required |
| + | ||Type 1-6 | ||
|} | |} | ||
Revision as of 14:57, 24 November 2017
Contents
Overview
Autoloader for Associations can add or update association records.
Types of Associations
There are five (6) types of associations within SmartSimple.
- 1. Company-Contact Association
- associations between organizations and contacts
- custom fields can also be added and imported in this section
- 2. Company Relationship
- relationships between companies
- 3. Contact Relationship
- relationships between contacts
- 4. UTA-Contact Relationship
- relationships between Universal Tracking Application L1/L2 and Contacts
- 5. UTA-Organization Relationship
- relationships between Universal Tracking Application L1/L2 and Organizations
- 6. Consumer-Provider Relationship
- relationships between two Universal Tracking Applications
Prerequisites
- Relationship should be enabled
- Roles have been created
- Organizations or Contacts should be existing on the instance
- Custom fields have been created
Standard Fields in Associations
- Association ID is the system's unique numerical value association with each Association record.
- Company ID is the system's unique numerical value associated with each Company record.
- Contact ID is the system's unique numerical value associated with each User record.
- Role ID is the system's unique numeral value association with each Role.
- Level 1 ID is the system's unique numerical value associated with each UTA-L1 record.
- Level 2 ID is the system's unique numerical value associated with each UTA-L2 record.
- Level 3 ID is the system's unique numerical value associated with each UTA-L3 record.
- Start Date is the effective start date of the association role. Date format should be in yyyy-mm-dd.
- End Date is the effective end date of the association role. Date format should be in yyyy-mm-dd.
Custom Fields in Associations
Custom fields should be created before mapping them in the Auto Loader settings. To add Custom fields,
- Under the Configuration menu, click on Roles & Permissions
- Click on User Roles.
- Click on Custom Fields found on the upper left of the screen.
- Select Association, then add all the custom fields by clicking the + button found in the upper left of the screen.
Auto Loader Settings
Please refer to Auto Loader Wiki on instructions on how to create an Auto Loader.
Additional Auto Loader settings for associations:
- In the drop down list for Record Type, select either Company, People, UTA-L1, UTA-L2
- In the dropdown list for Item, select Associations
- Under New Record Section, click Create if new association records will be created. Unclick when you only want to update existing records.
- Under Column Mapping, map each column of the file to your SmartSimple Standard Fields and/or Custom Fields.
- To add/update association records, the following standard fields should be included:
| SF/CF | ADD | UPDATE | Type of Association | |
| Association ID | required | Types: 1-6 | ||
| Company ID | required | required | Type 1,2,5 | |
| [[Determining_the_userid | Contact ID]] | required | required | Type 1,3,4 |
| Role ID | required | required | Type 1-6 |
