search
Web PortalContact Support

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.

hashtag
Setting up your Import

circle-exclamation

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

1

hashtag
Navigate to [ Settings > Import Format ]

2

hashtag
Click on [ + New Format ]

3

hashtag
Fill the Required Fields

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

If you are importing Orderless Tickets, fields with a * are also required

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

circle-info

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

circle-info

"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.

4

hashtag
Click [ ✓ Update ]

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

hashtag
Importing Ticket Data

1

hashtag
Navigate to [ Tickets > Ticket Import ]

2

hashtag
Fill the required fields

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

circle-info

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

3

hashtag
Click [ Upload ]

• Go over the import and the CSV to correct any errors if present

circle-info

Errors are shown in the right most column. This error is stating that the order being applied is not valid

• Once all errors are cleared, the tickets will have green check marks next to them

4

hashtag
Click the [ Save ] Button

The tickets should now be imported and viewable from the Ticket Query

hashtag
References

Ticket Importchevron-right

Last updated