Configuration: X Import Translations

The translation table, tblXImportTranslations, can also be found in the Operations App under X Stream > Route Mappings. It is used for looking up a RouteID based on import data. Usually, this functionality is used to assign a RouteID to imported route stops based on a Route and Stop ID set within the import file.

Translation Table Structure

  • PKID: automatically generated

  • CustID: Customer

  • TranslationType: Standard Route Translation (or ID = 1)

  • Reference1: First lookup (CustRouteID)

  • Reference2: Secondary lookup (CustSecondaryLookup)

  • Translation: RouteID to use when the lookups match

Make sure that RouteID is not specified in the configuration file and that CustRouteID (and optionally CustSecondaryLookup) are filled in correctly when using route translation.

  • CustRouteID maps to Reference1 in the translation table, tblXImportTranslations.

  • CustSecondaryLookup maps to Reference2 in the translation table, tblXImportTranslations.

How the translation is determined

  • Find the translation where the value of CustRouteID is equal to Reference1 in the translation table, and CustSecondaryLookup is equal to Reference2.

  • If CustSecondaryLookup is not specified, or there are no matches for the specified CustRouteIDm and CustSecondaryLookup, then the translation falls back to a match on CustRouteID only (tblXImportTranslations.Reference1).

  • If there are no matches for CustRouteID and CustSecondaryLookup, the translation will fall back based on the Customer ID.

Example

tblXImportTranslations

PKID

CustID

TranslationType

Reference1

Reference2

Translation

1

1218

1

123

456

101

2

1218

1

123

NULL

100

3

1218

1

NULL

NULL

400

Example Translations

CustID

CustRouteID

CustSecondaryLookup

RouteID

1218

123

456

101

1218

123

789

100

1218

9999

NULL

400

9999

123

456

UNASSIGNED



Related Articles:

 

Search related import documentation

Search