Mappings

The Mappings tab provides the capability to set what fields to be included and used as keys in creating the mapping.

tip

Notice that there are two mappings provided by default — user-properties.map and user-to-groups.map. These are the most common mapping files used in data processing. To modify these files, see the Editing a Mapping section.

Creating a Mapping

1. Click Create Mapping. A panel will appear on the right side of the page.

2. Provide a descriptive name for the mapping to be created.

3. In the Create Mapping from Source(s) panel, select among the list of available sources. It is allowed to select multiple sources.

4. Once a source or sources is/are selected, a table for each of the selected sources will appear at the bottom of the panel, containing the following columns:

   a. Field - The field name. All fields selected to be included when creating the source.

   b. Default - The default name of the field.

   c. Key - The identifier field of the record.

   d. Include - This determines if the field should be included in the mapping.

5. Once all is set, click Save. The mapping will be added in the list under the Create Mapping button and selected.

Example Mapping Output

Format

MAP: <include_value> (include_default_name)
<key_value>
<key_value>

If samAccountName is selected as key, and department, division, and location are selected as include:

Example Output

MAP: department1 (department)
user1
user2
user3

MAP: division1 (division)
user1
user2
user3

MAP: location1 (location)
user1
user3
user5

If samAccountName and mail are selected as key, and displayName and employeeType are selected as include:

Example Output

MAP: John Smith (displayName)
jsmith
jsmith@company.com 

MAP: Developer (employeeType)
jsmith
jsmith@company.com
slarren
slarren@company.com 

If samAccountName is selected as key, and department, division, and location are selected as include with Track History enabled:

Example Output

MAP: department1 (department)
user1:1970-01-01:*
user2:1970-01-01:*
user3:1970-01-01:*

MAP: division1 (division)
user1:1970-01-01:*
user2:1970-01-01:*
user3:1970-01-01:*

MAP: location1 (location)
user1:1970-01-01:*
user3:1970-01-01:*
user5:1970-01-01:*

Editing a Mapping

1. In the list of mappings under the Create Mapping button, click the desired item to modify. The edit panel will appear on the right side of the page.

2. Update the desired details to modify.

3. Remove a source by clicking the remove icon beside the source name, or add a new source by selecting from the list.

4. Edit the existing source field configuration and configure the newly added source using the tables displayed.

   a. Field - The field name. All fields selected to be included when creating the source.

   b. Default - The default name of the field.

   c. Key - The identifier field of the record.

   d. Include - This determines if the field should be included in the mapping.

   warning

   You cannot deselect fields selected in Include when being referenced or mapped in the Destination Fields. A warning will appear.

   To do this, unselect it first in the Destination Fields then deselect it in the Mapping.

5. Click Save.

Delete a Mapping

1. In the list of mappings under the Create Mapping button, click the delete icon associated with the item desired to remove.
2. In the confirmation, click Delete.