The route import process allows users to add new routes, with or without runs associated them, via an XLSX file.
Creating Your XLSX File
An excel file template is provided at the end of this document as an attached file. The fields in the XLSX file are detailed below.
The value in the 'action' column drives the import functionality as follows:
- ‘Add’ – System will add the corresponding record. If a record already exists with the same ‘Route identifier’ value as the record being imported, system will display an error.
- ‘Delete’ – System will find an existing record with the same ‘Route identifier’ value as the record in the import file and delete the record. If no match is found among the existing records in the system, an error message will be displayed.
Field | Accepted Values | Description | Is Required? |
Action | Add Delete | Define the import functionality | Yes |
Route identifier | Alphanumeric | Name of route | Yes |
Dispatch type | AM PM MD FP FT CH | Specify dispatch type | Yes |
Effective start date | MM/DD/YYYY | Route start date (note that the date can not be set to anything earlier than the current date) | Yes |
Effective end date | MM/DD/YYYY | Route end date | Yes |
Days of the week | M T W R F S U | Day(s) of the week the route is active | Yes |
Depot departure time | HH:MM:SS AM/PM | Scheduled depot departure time | Yes |
Depot return time | HH:MM:SS AM/PM | Scheduled depot return time | Yes |
Monitor Count | Numeric | The number of monitors to assign to the route. | No |
Importing Your Excel File
To import routes, follow the steps below:
- Navigate to Operations > Routes.
- Select Import Routes (see screenshot below).
3. The pop-out screen for “Import Routes” will appear. Specify whether the file to upload includes runs or not, as well as which customer the routes should be imported for before selecting your xlsx file and choosing upload.
4. After selecting upload, you will get confirmation that the data has been successfully uploaded. If any errors are encountered, please take a screenshot, and send the screenshot, as well as your XLSX file to support@bytecurve.com for further assistance. Do not try uploading the file again.