Mapping Fields
To map fields:
1. From the Mapping menu, open the relevant table mapping.
2. Click Add mapping items.
The Map a Field creation page appears.
3. Enter the ServiceNow item and the Hopex field of your choice.
Click
Show list to display all the fields and their characteristics. You can filter the results via the column headers
.
4. (Optional) Click Use a static value as source to configure a specific value into the target system.
Examples of static value as source when synchronizing:
• "To be processed" in the Application Status field
• @CurrentDate to set the date of the synchronization
5. According to the fields you selected, Transformation (data conversion) is either automatic or requires further settings.
Data conversion is automatic when mapping fields of the same type, except for specific cases such as enumerations and complex links. See the specific mappings below for further information.
Field type | Description |
|---|
GUID | Used for absolute identifiers |
String | Used for single line and multiple line text. Formatting is not supported. Strings can be limited in size |
Integer | Used for numbers without a comma |
Float | Used with decimal numbers and percentages |
Boolean | Used with decimal numbers and percentages |
Date | Used to identify date and time |
Enum | Used when a field can hold a predefined list of values. Note that enums in ServiceNow have the "Choice" type. |
Link | Used when the field is a reference to another object. Note that links in ServiceNow have the "Reference" type. |
Mapping the name
To map the name:
1. In the ServiceNow item field, enter "Name" and select the adequate value.
Objects should have unique names. If objects have the same short name (Software Technologies for example), it is recommended that you use "Display Name" rather than "Name".
2. In the Hopex field, enter "**NAME**".
It is mandatory to use **NAME** - which is a generic local name - so that the adequate value is automatically selected.
3. Click Save.
Mapping the description
To map the description:
1. In the ServiceNow item field, enter "Description".
2. In the Hopex field, enter "Comment".
3. Click Save.
Bear in mind that the ServiceNow description field is not available for all tables and that it has a maximum length of about 1000 characters.
Mapping a string to a date
To map a String type field to a Date type field:
Select the relevant date format of the Transformation field.
Mapping a string to a float
To map a String type field to a Float type field:
Select the relevant format of the Transformation field (number or percentage).
Mapping a string to a link
To map a String type field to a Link type field:
Select the relevant way to identify the link between its name or its ID.
It is advised to select the name, unless you know precisely the object. The ID is referring to Hopex Absolute Identifier "IdAbs" or ServiceNow Identifier "sys_id".
Mapping enumerations
To map fields containing multiple values, you must specify further the correspondence of the values between Hopex and ServiceNow.
To map enumerations:
1. Access the Map a Field creation page.
2. Enter the relevant ServiceNow and Hopex fields.
Note that enumerations in ServiceNow have the "Choice" type.
3. Click Save.
4. Click Define mappings for enums.
Multiple values of both ServiceNow and Hopex fields are displayed in separate tables.
5. Select a value in the table on the right first.
6. Select the matching value in the table on the left.
Click
Switch direction if you prefer to reverse tables.
The correspondence of these values is displayed in a matrix (at the bottom part of the screen).
7. Click Back and Save.
