At minimum, a Ticket Table import file must contain at least one column.
Here is an that an example that contains more typical data:
You can open Notepad or Excel and copy and paste the sample below to create your own import file. At you discretion, Include or exclude any of the columns and values that are not required.
"ticket_number","ticket_date","truck_id","owner","driver","customer_id","contract_id","purchase_order","item","material_code","source","zone","vehicle_type","placed_at","station","gross","tare","net","ticket_unit","note","company_id"
623701,2024-02-06 8:07:24 AM,"BB 46169",,,"PAVING","20-459",,"GR A","GR A","1",,"NS","HURONTARIO ST & CENTRAL PKWY",,34660,14370,20290,"kg",,"1"
623702,2024-02-06 8:14:54 AM,"BA 33435",,,"PAVING","20-459",,"GR A","GR A","1",,"NS","HURONTARIO ST & CENTRAL PKWY",,33140,14620,18520,"kg",,"1"
623703,2024-02-06 8:18:28 AM,"BP 42643",,,"PAVING","20-459",,"GR A","GR A","1",,"NS","HURONTARIO ST & CENTRAL PKWY",,31950,14430,17520,"kg",,"1"
623704,2024-02-06 9:27:15 AM,"BA 33435",,,"PAVING","20-459",,"GR A","GR A","1",,"NS","HURONTARIO ST & CENTRAL PKWY",,32390,14620,17770,"kg",,"1"
623705,2024-02-06 9:30:44 AM,"BP 42643",,,"PAVING","20-459",,"GR A","GR A","1",,"NS","HURONTARIO ST & CENTRAL PKWY",,32430,14430,18000,"kg",,"1"
Using import to create blanks tickets
If you wanted to create 10 new Tickets you could import a file containing the following:
truck_id
""
""
""
""
""
""
""
""
""
""
You can use any column name except serial_number and ticket_number. There's nothing special about using truck_id.
If you imported that file into an empty Ticket Table, you would end up with this result:
You could import the file multiple times adding 10 new rows each time the file was imported.
The double quotes are important. Without them Dispatch will assume the file contained the header row and no data.