The Keys import process allows users to add new keys in bulk, from a CSV file. 



Creating Your CSV File


A CSV file template is provided at the end of this document as an attached file.  This should be opened with Microsoft Excel and each new Key you wish to add should be included on a new line in the file under the headings provided.   All fields are required to be filled.


Field

Accepted Values

Description

Required

Key ID

Alphanumeric

The name of the route, usually containing the vehicle number, description, and time of day

Yes

To-School/From-School

One of "To-School" or "From-School"

Indicates whether the run is "To" (AM) or "From" (PM) school


Yes


Frequency Days

Characters: MTWRFUS

Any combination of the following day of week abbreviations MTWRFUS.    Example:  MWF for a Monday, Wednesday, Friday frequency.

Yes


 

An example of a CSV file ready for bulk load might look something like this.  This example will create 8 new Keys (4 To-school, and 4 From-school) with a frequency of every weekday.


Graphical user interface, application, table, Excel

Description automatically generated

 

 

Potential Conflicts

 

The upload process contains some duplication checks which prevent “day of week” overlap between keys.  For example, if a user attempts to upload a key file like the one below, an error will occur because of the overlap in the “Frequency Days” column for “W” (Wednesday) in the CSV file.

 

In order for this CSV file to be uploaded, the “W” must be removed from one of the rows for “ROUTE # 27 PM FREEDOM ES” to remove the overlap.


 

Importing Your CSV File

To Import Keys in bulk from your CSV file created in the previous step, follow the steps given below:

1. Navigate to Set-up > Keys

2. Select Import Keys (see screenshot below)


3. The "Import Keys" pop out screen will appear. Select your CSV file and select the “Upload” button that appears. 



4. After selecting upload, you will get confirmation that the data has successfully been uploaded. You can see the results of the upload on the Manage Keys view.  If any errors are encountered, please take a screenshot, and send the screenshot, and your CSV file to support@bytecurve.com for further assistance.  Do not try uploading the file again.