When a table to be imported contains the column LOC_IDENT, then the Import Column Mapping pane of the Import Details tab automatically includes all "location" columns, namely:
- LOC_IDENT
- ROUTE_ID
- LANE_DIR
- LANE_ID
- PERPENDICULAR_OFFSET
- OFFSET_FROM
- OFFSET_TO
To identify "location" there should be a mapping to each of these columns from the source data. For example, if the source data had the normal system route name and mile points, L/R for direction, no lanes, and no perpendicular offset, then the mapping would be as shown in the table below:
Source | ImportMapping Groovy Script | Target | Notes |
|---|---|---|---|
| Max loc_ident | LOC_IDENT | Always use this ImportMapping Groovy script to set LOC_IDENT. |
Route | Map by column name | ROUTE_ID |
|
Direction | Set direction for MDTPMS | LANE_DIR | R maps to 1; L maps to 2; B maps to 0; otherwise reject the record. |
0 |
| LANE_ID |
|
0 |
| PERPENDICULAR_OFFSET |
|
From | Set to column value | OFFSET_FROM |
|
To | Set to column value | OFFSET_TO |
|
