At minimum, the Truck Table import file must contain the following columns: truck_id.
If you supply row_id, make sure each value is unique. Here is an example:
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.
"row_id","truck_id","owner","driver","description","vehicle_type","tare","tare_date","manual_tare","rgw","agw","allowed","allow_overloads","vehicle_licence","vehicle_licence_expiry","vehicle_registration","trailer_1","trailer_1_tare","trailer_2","trailer_2_tare","total_tare"
1,"169 3YM","DICRETE #1369","JEFF","WESTERN STAR TRI-AXLE","NS",15420,2020-11-20 7:05:30 AM,0,36900,36900,36900,1,"1343YM",,"","",0,"",0,14520
2,"134 3YM","DICRETE #1315","DAVID","WESTERN STAR TRI-AXLE","NS",14520,2020-11-20 7:05:30 AM,0,36900,36900,36900,1,"1343YM",,"","",0,"",0,14520
3,"136 5TD","ABD HAULAGE LTD. #7","","MACK TRI-AXLE","NS",12550,2021-07-05 11:17:57 AM,0,36300,36300,36300,1,"1365TD",,"","",0,"",0,12550
4,"138 7TD","PAVEMAR PAVING LTD. #1","DARRYL","MACK TRI-AXLE","NS",13580,2024-06-13 10:04:46 AM,0,35900,35900,35900,1,"138 7TD",,"","",0,"",0,13580
5,"139 8ZA","ELIA ASPHALT LTD. #02","ALI","MACK TRI-AXLE","NS",12780,2020-11-03 7:38:37 AM,0,36300,36300,36300,1,"1398ZA",,"","",0,"",0,12780
6,"145 2VP","TRANS POWER #319","","GMC 7500 SINGLE-AXLE","NS",7390,2019-10-15 8:49:26 AM,0,15900,15900,15900,1,"145 2VP",,"","",0,"",0,7390
8,"150 1XN","VBN #DT10","JOE","MACK TRI-AXLE","NS",14090,2020-10-24 9:27:56 AM,0,36300,36300,36300,1,"150 1XN",,"","",0,"",0,14090
9,"153 3TD","PAVEMAR PAVING LTD. #3","DARRYL","MACK TRI-AXLE","NS",13570,2024-06-13 10:22:29 AM,0,35900,35900,35900,1,"153 3TD",,"","",0,"",0,13570
10,"153 4TD","PAVEMAR PAVING LTD. #2","DARRYL","MACK TRI-AXLE","NS",13540,2021-04-30 8:10:11 AM,0,35900,35900,35900,1,"153 4TD",,"","",0,"",0,13540