How to Import Tickets

The Ticket Import screen allows you to build an interface with files from a ticketing system used previously, or with an outside company’s ticketing data that needs to be recorded.

Setting up your Import

You must be logged into an Admin account the access the Import Format page

Navigate to [ Settings > Import Format ]

Click on [ + New Format ]

Fill the Required Fields

The minimum required fields are the [ Format Name ] and all fields with a [ 0 ]

Match your fields to the corresponding number of the column in your export with the column containing that information on your CSV

Numbers will replace the letter of the column in your export: A = 1, B = 2, C = 3, D = 4, etc.

"Header Row" is checked because the CSV in the above example does have a header row, this can be left unchecked if your columns do not have headers.

Click [ ✓ Update ]

The Import Format should now be created! Follow the Importing Ticket Data steps below to see how to use it.

Importing Ticket Data

Navigate to [ Tickets > Ticket Import ]

Fill the required fields

Select the ticket import Format, Import File (CSV), Region, Location and Yard

Overwrite Date: Will overwrite all dates on tickets being imported Overwrite Hauler: Will overwrite all haulers on tickets being imported Add New Trucks: Will add trucks on tickets being imported, if they are not in Fast-Weigh