Difference between revisions of "Import multiple contact/companies to uta objects"

From SmartWiki
Jump to: navigation, search
(→‎Import Process Overview)
(updating categories)
 
(23 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
The main [[UTA Settings - Settings|UTA Settings]] page includes sections specific to the level one, two and three records. Each of these sections includes options for importing contact and company records using an import wizard.
 
  
−
* '''Import Organizations''' - Associate existing organizations in your system with existing Level 1 objects.
+
The main [[UTA Settings - Settings|UTA Settings]] page includes sections specific to the {{l1}}, {{l2}} and {{l3}} records. Each of these sections includes options for importing contact and company records using an import wizard.
−
* '''Import Contacts''' - Associate existing contacts in your system with existing Level 1 objects.
 
  
 
[[Image:ImportUTA.png|link=]]
 
[[Image:ImportUTA.png|link=]]
Line 13: Line 11:
 
1. Navigate into the Import option for the UTA level you are interested in.
 
1. Navigate into the Import option for the UTA level you are interested in.
  
−
2. Copy the information to be imported to the '''Windows Clipboard'''.
+
2. Copy / format the data to be imported.  
  
−
3. Paste the information into the [[SmartSimple]] '''Import Window''' from the '''Clipboard'''.
+
3. Paste the information into the [[SmartSimple]] '''Import Window'''.
  
 
4. Map the fields in the pasted data to the system data. This must include mappings to  
 
4. Map the fields in the pasted data to the system data. This must include mappings to  
−
*'''identify the contact or organization to be imported
+
*identify the contact or organization to be imported
−
*'''the role or category they are to be imported as  
+
*the role or category they are to be imported as
−
*'''mappings to identify the individual record (level 1, 2, or 3) that the data is to be imported against.  
+
*mappings to identify the individual record (level 1, 2, or 3) that the data is to be imported against.  
  
 
5. Validate the information mapping before uploading.
 
5. Validate the information mapping before uploading.
  
 
6. Upload the data to [[SmartSimple]].
 
6. Upload the data to [[SmartSimple]].
−
 
−
If you need to split contact information this technique is repeated – once for the organisation data, and once for the contact data.
 
−
 
−
If you have made a mistake you can use the undo feature to delete all the records of a previous upload.
 
  
 
Each step of this process is described in detail below.
 
Each step of this process is described in detail below.
  
−
==Importing Organisation Records==
+
==Navigate to the Import option==
  
−
This exercise will use an '''MS-Excel''' spreadsheet containing additional head office employees and the associated department.  Since there is both “organisation” and “people” information in this data, this exercise will demonstrate the technique required to split this type of file.
+
1. Go to the Settings page for the UTA that the data will be imported against.
  
−
At the end of the process there will be five new departments and twenty new people.
+
2. Scroll down to the Settings section for the level you wish to import the data against.
  
−
1. Launch '''Microsoft Excel'''.
+
3. Click on the import option for the type of data you intend to import
−
 
+
* '''Import Organizations''' - Associate existing organizations in your system with existing Level 1 objects.
−
2. Open the file '''Accounts and Contacts.xls'''.
+
* '''Import Contacts''' - Associate existing contacts in your system with existing Level 1 objects.
−
 
 
−
[[Image:User12.png]]
 
−
 
−
3. Select the cells '''A2''' to '''D22'''.
 
  
−
4. Select the '''Edit Copy''' [[Menu|menu]] or press '''Control + C'''.
 
  
−
5. Switch back to [[SmartSimple]].
+
==Copy/format the data==
  
−
Since this is an [[Internal|internal]] organisation list, you will use the '''Organisation Chart'''.
+
If you wish to '''import contact''' details then ensure . . .
 +
* You have selected at least one field from the Users and one field from the entity (level 1, 2 or 3) for matching
 +
* You have included the user role name you want to import contacts as
 +
* '''ALL''' standard fields are set before the custom fields and in the same order as the field selection list
  
−
6. Click the '''Organisation''', '''Internal People''' [[Menu|menu]].
+
If you wish to '''import organization''' details then ensure . . .
 +
* You have selected at least one field from the Companies and one field from the entity (level 1, 2 or 3) for matching
 +
* You have included the company role name you want to import companies as
 +
* '''ALL''' standard fields are set before the custom fields and in the same order as the field selection list
  
−
These departments will be inserted under the root organisation.
+
==Paste information into Import Window==
  
−
7. Click the '''Root Organisation''' link.
+
Once you click on the import option then you will be presented with the relevant Import Wizard for the type of data to be imported.  
  
−
The root organisation details are displayed. The import buttons are displayed on the '''New''' [[Menu|menu]].
+
[[Image:ImportOrgtoUTA.png|900px]]
  
−
[[Image:User13.png]]
+
1. Click the mouse in the '''import''' text box.
−
 
−
From the root of the organisation, you can import [[Internal|internal]] branches or [[External|external]] accounts.
 
  
−
8. Choose the '''Branches''' [[Menu|menu]].
+
2. Select the '''Edit Paste''' [[Menu|menu]] or press '''Control + V'''.  
−
* If you clicked the '''Import Accounts''' button you will load this information as a set of external accounts.
 
−
* '''Step 1''' of the Import Wizard is displayed.
 
−
 
 
−
[[Image:User14.png]]
 
−
 
−
As there are no company categories established in this instance you cannot select a company category.
 
−
 
 
−
9. Click the mouse in the '''import''' text box.
 
−
 
 
−
10. Select the '''Edit Paste''' [[Menu|menu]] or press '''Control + V'''.  
 
  
 
The data is added to the text box.
 
The data is added to the text box.
  
−
[[Image:User15.png]]
+
[[Image:ImportOrgtoUTA2.png]]
−
 
−
11. Press '''Control + Home''' to see the start of the pasted data.
 
−
 
 
−
This data contains the field names and is delimited by tab.
 
−
 
 
−
12. Set the '''Column delimiter''' to '''Tab'''.
 
−
 
 
−
13. Click the '''First row contains field names''' check box.
 
−
 
 
−
14. Click the '''Analyze''' button.
 
−
 
 
−
The analyzed data is displayed.
 
−
 
 
−
[[Image:User16.png]]
 
−
 
−
* In this instance only the branch name can be set.
 
−
 
 
−
15. Map the '''first field''' to the '''Organisation Name''' field.
 
−
 
 
−
[[Image:User17.png]]
 
−
 
−
If you were importing [[External|external]] accounts you would also need to set the account owner to the correct manager.
 
  
−
16. Click the '''Parse Branch''' button.
+
3. Set the '''Column delimiter''' as required.
  
−
[[Image:User18.png]]
+
4. Click the '''First row contains field names''' check box if the first row is column headers rather than real data.
−
 
−
You are prompted to continue with the current owner and category.
 
  
−
[[Image:User19.png]]
+
5. Click the '''Analyze''' button.
−
 
−
17. Click the '''OK''' button.
 
  
−
The analyzed data is displayed.
 
  
−
[[Image:User20.png]]
+
==Validate the information ==
−
 
−
Many of these branch records appear as duplicates because the department is repeated for each person.
 
−
* The duplicate departments are not marked for uploading, so only one of each department will be created.
 
−
* When you upload the same data into the contact table, the contacts will be associated with the correct department.
 
  
−
18. Click the '''Upload''' button.
+
1. Map the fields, ensuring that . . .
 +
* You have selected at least one field from the Company / Contact and one field from the entity (level 1, 2 or 3) for matching
 +
* You have included the company / contact role name you want to import companies as
 +
* '''ALL''' standard fields are set before the custom fields and in the same order as the field selection list
 +
[[Image:ImportOrgtoUTA3.png]]
  
−
The department records are uploaded.
+
2. Click the '''Parse Branch''' button.
  
−
[[Image:User21.png]]
+
[[Image:ImportOrgtoUTAParse.png]]
 
   
 
   
−
19. Click the link to view the uploaded branches.
+
3. The analyzed data is displayed.
  
−
[[Image:User22.png]]
+
[[Image:ImportOrgtoUTA4.png]]
 
   
 
   
−
==Undoing an Upload==
+
4. Click the '''Upload''' button. The records are uploaded.
−
 
 
−
Note the '''arrow''' icon to the left of each department name.  
 
−
 
 
−
This icon indicates that these are the most recently uploaded organisation records. If these records were uploaded in error you can undo the upload by clicking the '''Undo Branch Upload''' tab.
 
  
−
[[Image:User23.png]]
+
[[Image:ImportOrgtoUTA5.png]]
 
   
 
   
−
When you click this link all the organisation records last uploaded will be removed.
+
[[Category:Data Import]]
−
 
+
[[Category:System Management]]
−
==Importing User Data==
+
[[Category:Organizations]]
−
 
 
−
Next you will use the same data but this time use the data to create the [[User|users]]. The system will use the department name in this data to determine the correct department to associate with each user. Since these are [[Internal|internal]] people you need to use the '''Organisation Internal''' [[Menu|menu]].
 
−
 
 
−
1. If you are not in the [[Organisation Hierarchy]] view – click the '''Organisation''', [[Internal]] People [[Menu|menu]].
 
−
 
 
−
2. Click the '''root organisation''' name.
 
−
 
 
−
The root organisation details are displayed.
 
−
 
 
−
3. Choose the '''Import''', [[User|Users]] [[Menu|menu]].
 
−
 
 
−
'''Step 1''' of the User Import Wizard is displayed.
 
−
 
 
−
[[Image:User24.png]]
 
−
 
−
Unless you have copied some other data to the clipboard, the same data is available to be pasted.
 
−
 
 
−
If there are no [[User|user]] roles displayed in the '''User Roles''' section then you are not in a [[Role|role]] that can set any roles.
 
−
 
 
−
4. Paste the data into the '''Import Wizard'''.
 
−
 
 
−
[[Image:User25.png]]
 
−
 
−
5. Set the [[Role]] to '''Employee'''.
 
−
 
 
−
6. Set the '''Column Delimiter''' to '''Tab'''.
 
−
 
 
−
[[Image:User26.png]]
 
−
 
 
−
[[Category:System Management]][[Category:Organizations]]
 

Latest revision as of 16:17, 20 July 2017

The main UTA Settings page includes sections specific to the Level 1, Level 2 and Level 3 records. Each of these sections includes options for importing contact and company records using an import wizard.

ImportUTA.png

Import Process Overview

The import process consists of six steps:

1. Navigate into the Import option for the UTA level you are interested in.

2. Copy / format the data to be imported.

3. Paste the information into the SmartSimple Import Window.

4. Map the fields in the pasted data to the system data. This must include mappings to

  • identify the contact or organization to be imported
  • the role or category they are to be imported as
  • mappings to identify the individual record (level 1, 2, or 3) that the data is to be imported against.

5. Validate the information mapping before uploading.

6. Upload the data to SmartSimple.

Each step of this process is described in detail below.

Navigate to the Import option

1. Go to the Settings page for the UTA that the data will be imported against.

2. Scroll down to the Settings section for the level you wish to import the data against.

3. Click on the import option for the type of data you intend to import

  • Import Organizations - Associate existing organizations in your system with existing Level 1 objects.
  • Import Contacts - Associate existing contacts in your system with existing Level 1 objects.


Copy/format the data

If you wish to import contact details then ensure . . .

  • You have selected at least one field from the Users and one field from the entity (level 1, 2 or 3) for matching
  • You have included the user role name you want to import contacts as
  • ALL standard fields are set before the custom fields and in the same order as the field selection list

If you wish to import organization details then ensure . . .

  • You have selected at least one field from the Companies and one field from the entity (level 1, 2 or 3) for matching
  • You have included the company role name you want to import companies as
  • ALL standard fields are set before the custom fields and in the same order as the field selection list

Paste information into Import Window

Once you click on the import option then you will be presented with the relevant Import Wizard for the type of data to be imported.

ImportOrgtoUTA.png

1. Click the mouse in the import text box.

2. Select the Edit Paste menu or press Control + V.

The data is added to the text box.

ImportOrgtoUTA2.png

3. Set the Column delimiter as required.

4. Click the First row contains field names check box if the first row is column headers rather than real data.

5. Click the Analyze button.


Validate the information

1. Map the fields, ensuring that . . .

  • You have selected at least one field from the Company / Contact and one field from the entity (level 1, 2 or 3) for matching
  • You have included the company / contact role name you want to import companies as
  • ALL standard fields are set before the custom fields and in the same order as the field selection list

ImportOrgtoUTA3.png

2. Click the Parse Branch button.

ImportOrgtoUTAParse.png

3. The analyzed data is displayed.

ImportOrgtoUTA4.png

4. Click the Upload button. The records are uploaded.

ImportOrgtoUTA5.png

Retrieved from ‘https://wiki.smartsimple.com/index.php?title=Import_multiple_contact/companies_to_uta_objects&oldid=30680’