An essential part of the integration framework is mapping Transport Expresso fields to the equivalent fields on any external system.
This is achieved using the table /BTI/TE_INT_MAPP. Ideally, this process will need to be undertaken before the framework can be used. For general fields the TE field should be entered complete with table name into field TEFIELDREF and the external fieldname must be entered in the EXTERNAL_REF field.
There is also the functionality to be able to reference any TE Custom fields the custom field ID’s would need to be added to TECUSTFIELD_REF, also multiple line itemed fields are able to be handled here such as text fields. Finally, on the mapping table there is a KEY_FIELD field this is used to hold the external system record key in general use a specific non display custom field on the task would be created for this purpose.
/BTI/TE_INT_MAPP – Integration Mapping
| Field | Description |
| EXTSYS_NO | Main external system identifier, this is the identifier of the system that you wish to integrate with we can have as many systems as we want. An example of this could be: 1 – Remedy 2 – Solution Manager 3 – Service Desk |
| EXTSYS_NAME | Full description of external system |
| TEFIELDREF | This is the TE Field that needs to be mapped to a field on the external system. This table name is required in the field as well. I.e. /BTI/TE_TASK-PRIORITY |
| EXTERNAL_REF | This is the fieldname that the frameworks calling web service needs to reference to map across the data. |
| KEY_FIELD | This field is the link between the TE record, in our task record we have set up a custom field which is hidden from view and in here we store the ID of the created record on the integrated system. |
| TECUSTFLD_REF | ID of TE Custom field to be mapped. |
| DEFAULT_VAL | Defaulted Value to be mapped over to the integrated system field. |
Post your comment on this topic.