Ctrlk
Web PortalContact Support
For the complete documentation index, see llms.txt. This page is also available as Markdown.

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

1

Navigate to [ Settings > Import Format ]

2

Click on [ + New Format ]

3

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

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.

4

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

1

Navigate to [ Tickets > Ticket Import ]

2

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

3

Click [ Upload ]

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

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

Click the [ Save ] Button

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

References

Ticket Import

Last updated