Uploading TODIS Route Files and Field Mapping Guide
Transportme allows users to upload TODIS files in ZIP format to integrate routes and stops data into the Transportme system.
This article explains how to upload a TODIS Route file into the system and includes a full field mapping reference.
- Important Notes Before Uploading
- Uploading TODIS File
- Results of TODIS Upload
- TODIS Field Mapping Reference
Important Notes Before Uploading
- The following data will be uploaded into the Transportme system
- Stop list
- Route name
- Route description
- Route Name/Number
- Contract number
- Route stop list and its departing time
- The stops uploaded from the TODIS file will be associated to the same organisation of the selected route category.
- Other settings or data not included in the TODIS file will be assigned default values.
- After uploading the route, it can be reviewed and updated as needed.
- Any updates made to the route after the TODIS upload will be preserved, even if the route is later updated.
Uploading TODIS File
Step-by-Step Guide:
- Step 1: Prepare the XML File:
- Ensure the file follows the correct format and is validated.
- Once validated, compress the XML file into a
.zip
archive before proceeding.
- Step 2: Log in to the Transportme operator portal
- Step 3: Navigate to route import section
- From the top menu bar, select Routes.
- Click the Upload Route File button.
- Select the TODIS radio button to open the Add Route by TODIS form.
- Step 4: Upload TODIS Zip File
- Choose the appropriate Route Category to assign to the imported route.
- Select the TODIS
.zip
file containing the XML data.
- Step 5: Import
- Click the Import button to begin the import process.
- Wait for the Results of TODIS Import to be returned. The system will process the file and display a summary of the import results.
Results of TODIS Upload
Each valid Trip entry in the TODIS file will be converted into a corresponding TME route upon successful import.
When importing a TODIS file, the system will perform different actions depending on how the data in the TODIS file matches or differs from the existing route data in the Transportme system.
The system will display the results, including any errors encountered during the process.
TODIS Field Mapping Reference
TODIS File Field | TME Fields | Notes |
STOP | ||
Transport_Operations_Data.@SpatialReferenceSystem |
Coordinate system used for Stop data. PROJCS:
|
|
TransitStop.@FullName | Stops | Place Name or Routes | Stops | Stop Name |
|
TransitStop.@XCoord or TransitStop.@YCoord | Longitude, Latitude | |
Trip.@DataDomainId_TransitStop.@TSN | Stops | Ref. Stop ID | |
ROUTE | ||
Trip.@DataDomainId_Trip.@Id | TODIS Information |
|
Trip.@Name + Trip.@ScheduledStartTime | Route Name | Trip.@ScheduledStartTime in seconds. |
Trip.@RouteVariantContractId | Settings | Reference Data | Contract ID | |
Contract.@ContractCode | Settings | Reference Data | Contract Number or Routes | Contract Number |
|
Trip.@RouteVariantNumber | Route Name/Number | |
Trip.@RouteVariantRouteId and Route.@FullName |
Route Description for Reporting | |
ROUTE STOPS | ||
Trip.PassingTimes.PassingTime.@RouteVariantPointVariantNumber and Trip.PassingTimes.PassingTime.@RouteVariantPointSeqNumber and RouteVariantPoint.@SeqNumber and RouteVariantPoint.@RouteVariantNumber and RouteVariantPoint.@TransitStopTSN |
Route Stop | |
Trip.PassingTimes.PassingTime.@SeqNumber | Route Stop Order | |
Trip.PassingTimes.PassingTime.@Time | Route Stop Departing Time | Trip.PassingTimes.PassingTime.@Time in seconds |
Note:
Time in TODIS file is in seconds. To convert seconds into clock time:
Trip.@ScheduledStartTime = "33300" => 09:15:00