Difference between revisions of "Importing Organizations or Contacts Association"
(→Import User/Contact to User/Contact Relationship) |
|||
| Line 55: | Line 55: | ||
|- | |- | ||
|Column 1: Role | |Column 1: Role | ||
| − | ||Column 2: Unique ID | + | ||Column 2: Unique ID (Custom Field) |
i.e. Organization_ID of the first company | i.e. Organization_ID of the first company | ||
| − | ||Column 3: Unique ID | + | ||Column 3: Unique ID (Custom Field) |
i.e. Organization_ID of the second company | i.e. Organization_ID of the second company | ||
|- | |- | ||
| Line 69: | Line 69: | ||
|- | |- | ||
|Column 1: Role | |Column 1: Role | ||
| − | ||Column 2: Company ID | + | ||Column 2: [[Database_Field_Names|Company ID (Standard Field)]] |
i.e. The unique identifier created by SmartSimple | i.e. The unique identifier created by SmartSimple | ||
||Column 3: Unique ID | ||Column 3: Unique ID | ||
Revision as of 09:58, 19 July 2016
Contents
Three Types of Associations between Organizations and Contacts
There are three (3) types of associations between organizations and contacts that can be imported using FIle Import Wizard.
- 1. Company Relationship
- relationships between companies
- 2. Contact Relationship
- relationships between contacts
- 3. Company-Contact Association
- associations between organizations and contacts
- custom fields can also be added and imported in this section
Prerequisites
- Relationship should be enabled
- Roles have been created
- Organizations or Contacts should be existing on the instance
File Import Wizard Tool
To access the Import Wizard Tool for Organizations and Contacts:
- Under the Configuration menu, click on Global Settings
- Click on the Organizations & Users tab
- The Import Wizard Tools are found under the Association Settings section
Three Import Wizard Tool:
- Import User/Contact to User/Contact Relationship - Contact Relationship
- Import Company/Account to Company/Account Relationship - Company Relationship
- Import Company/Account to User/Contact Associations - Company-Contact Association
Import Process Overview
The import process consists of five steps:
1. Copy the information to be imported to the Windows Clipboard.
2. Paste the information into the SmartSimple Import Window from the Clipboard.
3. Map the fields in the pasted data to the fields in the organisation, contact or activity record.
4. Validate the information mapping before uploading.
5. Upload the data to SmartSimple.
Currently, there is no way to delete associations imported using the Import Wizard Tool.
Each step of this process is described in detail below.
Import User/Contact to User/Contact Relationship
1. Prepare data to be imported A. With unique identifiers of the organization
Column 1: Role Column 2: Unique ID (Custom Field) i.e. Organization_ID of the first company
Column 3: Unique ID (Custom Field) i.e. Organization_ID of the second company
"Collaborator" 1001 3000 "Partner" 1001 4000
B. With a Company ID and a unique identifier of the organization
Column 1: Role Column 2: Company ID (Standard Field) i.e. The unique identifier created by SmartSimple
Column 3: Unique ID i.e. Organization_ID of the second company
"Collaborator" 12432123 3000 "Partner" 12432123 4000
2. Click Import User/Contact to User/Contact Relationship 3.
