Importing the Comp Code Master records

Often during the initial setup of ClientSpace, you will need to import Comp Code master records, the individual Code, and title description pairs. This document describes how to automate that process using an import.

To automate the import process:

1. Go to System Admin > Advanced > Configure Import.

The Import Map Header Search dashboard opens.

2. Open the comp code master entry.

The Import Map Header Detail form opens.

3. Click Fields.

The Import Map Search list displays, showing the fields.

4. To configure the two text data types, select an entry and click Edit.

Import Mapping Report

IMPORTANT NOTES: Your import must conform to the following standards:

Comma-delimited files must have all values surrounded by quotation marks.
Data cannot contain crlfs (char(10) and char(13)).
File names, column headers, and column order must match the values contained in this report exactly.
The first row of the file must contain the column headers described in this report.
The column headers must also be surrounded by quotation marks.
This import is used to load the comp codes that are missing from the Comp Code Master List.

Required

Column

Data Type

XXX

Code

Text

XXX

DefaultInfoImportID

 

XXX

ImportID

 
 

Title

Text

Example Import file

"ImportID","DefaultInfoImportID","Code","Title"

"2150","1046","8810","Clerical"

"2576","1046","8742","Outside Salesperson"

DefaultInfoImportID = Identifier in the Admin Workspace URL = 1046

Be sure to set the ImportID field on the Default Info dataform to 1046.