Importing Locations

To import Locations into Content Manager using Content Manager DataPort:

General

1. Start DataPort from the Content Manager client, on the Administration ribbon, in the Other group, click Import/Export. Alternatively, from the Content Manager install path, open the TRIMDataPortConfig application.

   The Content Manager DataPort - New Project dialog box appears.

2. Type the name of the project in the Project Name field.
3. Type a description of the project if required.
4. Select the Authentication Method to use. From the drop-down list, select from:
   • Active Directory Federated Services
   • Explicit Windows Authentication
   • Google Apps
   • Integrated Windows Authentication

   CAUTION: If anything other than Integrated Windows Authentication is used then DataPort will not run in an unattended fashion, a user name and password will be required.

5. Select the Content Manager Database the Locations are to be imported into by selecting the dataset name from the recently used drop-down list or use the KwikSelect to select the database from the list of available databases.
6. From the drop-down list, select Import as the Data Direction.
7. From the drop-down list, select Location as the Content Manager Object Type.
8. From the drop-down list, select the File Format. By default, Tab Delimited is selected.
9. Browse to, or use the drop-down list to select, the location of the Import File Path.
10. From the drop-down list, select Yes or No to Show Progress Window.
11. From the drop-down list, select Yes or No to Update on Duplicate. If Yes is selected, then if a duplicate Location is found during the import process it's metadata will be updated to match that in the import file.

Settings

12. From the drop-down list, select Yes or No to Use Bulk Loader when importing Locations. If Yes is selected, a Warning is displayed:
    
    Warning. When running an importing using Bulk Loader import mode a number of features are disabled. Records may be numbered according to the special bulk loader sequence and some expensive integrity checks will be bypassed and no audit trail is created.

13. From the drop-down list, select Yes or No to Relax Business Rules for Conversion. If Yes is selected then checks on Location interdependent properties are not done during the import process.
14. From the drop-down list, select Yes or No to Relax Business Rules for Performance.

    NOTE: Duplicate Locations will not be created if this option is selected due to  CM DataPort duplicate checking, secondary internal checks are being bypassed during the import process which can improve performance.

15. From the drop-down list, select the Location Match Type. Select from:
    
    • Matches must be unique
    • Must match - never create new Location
    • Never match - always create new
    • Use first match

See Location Match Type Behaviors for how these options behave.

16. From the drop-down list, select the Property to use to uniquely identify a location. Select from:
    
    • Email Address
    • ID Number
    • Name
    • Unique Identifier
    • Unique Name

When matching imported data to existing Locations this property will be used. Once this property is selected it still must be added to the Field Map to enable the data in the import file to be mapped to the data in Content Manager.

Field Map

17. Map the fields/items to be imported.  

• Target Properties - these are the fields/items available in the Content Manager database.
• Source Fields - these are the fields/items that are available in the Import file.
18. To map all matching items, click Map All Matching Pairs. This automatically selects all items with the same caption and adds it to the Mapped Items section.

To map individual fields/items, select the Target Properties item and then select the matching item in the from the listed Source Fields, click Map Pair. The pair will be added to the Mapped Items section.

19. Click Save. Type the name of the Import DataPort Project file, click Save.
20. Click Execute to run the project.

If Show Progress Window is set to Yes, the Content Manager DataPort Engine will be displayed to show the progress of the Import. If it's set to No, the Import will run in the background. The Content Manager DataPort Engine can be accessed from the System Tray/ Notifications bar.