Mapping Fields
Mapping process
To map fields:
1. From the Mapping menu, open the relevant table mapping.
2. Click Add new mapped item.
The Map a Field creation page appears.
3. Enter the ServiceNow field 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.
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.Supported Field Types
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 the 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 destination field.
Mapping a String to a Float
To map a String type field to a Float type field:
Select the relevant format of the destination 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 into 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 sceen).
7. Click Back and Save.
Mapping Links
You can map links between ServiceNow and Hopex.
There are two types of links.
• Simple links (i.e. direct link between two objects) are easy to map in the Map a Field creation page.
Note that simple links in ServiceNow have the "Reference" type.
• Complex links (i.e. links using intermediate objects) require further configuration as presented below.
You must map both the source object and the target object of a link. If not, the link will not be created.
Mapping complex links
By default, complex links are not available in the list of fields to map.
Therefore, you need to define a complex link in order to be able to map it.
Defining a complex link in Hopex
To define a complex link in Hopex:
1. From the Mapping menu, select Define complex links.
2. Click the Add new HX button.
3. Select a Source MetaClass and a Destination MetaClass.
4. Click Search Links.
Complex links between the two MetaClasses appear in a table.
You can filter the results via the column headers
.
5. Click
to select the complex link of your choice.
6. Enter a name for this complex link.
7. (Optional) Enter the standard links to hide.
The links from the MetaClasses to the intermediate object will be hidden in the list of
Hopex fields.
8. Click Save.
Defining a complex link in ServiceNow
To define a complex link in ServiceNow:
1. From the Mapping menu, select Define complex links.
2. Click the Add new SN button.
3. Select the type of complex link between:
• Relationship link
• Many-to-many link
4. Enter the relevant fields and click Save.
