Embedded Files
This document describes the process to run the the WSX Standard docket export (also known as the ‘Generic’ docket export) and its output.
For dockets to be written to the Generic export file the following criteria must first be met,
Docket LogOrg in GenericExportLogOrgs setting (check with TFL Support if unsure)
Delivery date within the selected range (date range selected when export is run)
Docket LogOrg in the selected list (Log Orgs selected when export is run)
Docket Not Yet Sent
Net weight > 0
If 'Include Export Customers?' is checked then JAS and Pieces must be present for Export Customers
Must have M-Check (E-Check not required)
Cannot have E-Error or M-Error
Running an Export
Running an Export
To run the docket export, access the function from the menu: Dockets > Export Dockets > Export to CSV. From the Docket Export screen that presents, make the following selections,
Start Date - Select the first date from which you want to include dockets
End Date - Select the final date up to which you want to include dockets
Send Un-Validated? - If selected this will export all dockets that are not set as ‘Error’. CAUTION: ticking this option will include non-validated docket data in the export.
Include Export Customers? - Includes dockets for customers marked as ‘Export Customer’ in the database.
Log Org - Select the Log Org(s) for which you want to export docket data
Data Exported to CSV
Data Exported to CSV
The table below describes the data output in the docket export file. This data is exported in a CSV format to the location specified in the DB Setting DocketExportPath_LogOrg, with a file naming convention of ‘GenericExport_LogOrg(s)_Supplier(s)_DateTime(when run).CSV’
Key to the Table Columns,
Field = Describes data in field
Origin = WSX or External Data Record
Data Source Field = Describes the source of data from within WSX
Translation = Translation available with associated Translation Entity Type
Required for Export? = Data must be present in these fields for docket to be written to FLITS export file. Note those marked as 'System' will always be present.
Field Origin Data Source Field Translation Required for Export?
Docket WSX Docket Number --- Yes
Uplift WSX Uplift Date --- System
Delivery WSX Delivery Date --- System
Truck WSX Truck Code TRUCK Yes (if Truck or Full Load)
Trailer WSX Trailer Code TRAILER Yes (if Trailer or Full Load)
Cartage WSX Trucking Contractor Code TRUCKCON System
Driver WSX Truck Drivers associated Contact (first & last name) --- System
Type WSX Truck Type --- System
CTI WSX Truck CTI status --- System
Crew WSX Gang Code (Not Gang No.) CREW System
Loader WSX Loader Code (Not Loader No.) --- System
Forest WSX Forest Code (full code incl Supplier/Short Code) FOREST System
Cmpt WSX Compartment Code --- System
Setting WSX Setting Code --- System
Cut_As WSX WoodType Code (Uplift) WOODTYPE System
Sold_As WSX WoodGroup Code (Delivery) WOODTYPE System
Customer WSX Customer Code CUSTOMER System
Net_Weight WSX Net Weight --- Yes
Tare_Weight WSX Tare Weight --- No
Gross_Weight WSX Gross Weight --- No
Load_Length WSX WoodType (Cut_As) Length --- System
Fell_Date WSX Fell Date --- No
Pcs WSX Pieces --- Export Customers Only
JAS WSX JAS (Volume) --- Export Customers Only
Qty WSX Load Quantity --- System
Contract WSX Compartment Contract --- No
Trip_Type WSX Trip Type --- System
Log_Org WSX Logging Organisation (assoc to Gang Locn assoc to Uplift) --- System
M_Chk WSX Manual Check Status --- Yes
M_Chk_Date WSX Manual Check Date --- Yes
E_Chk WSX Electronic Check Status --- No
E_Chk_Date WSX Electronic Check Date --- No
Status WSX Docket Sent Status --- System
Sent_Date WSX Docket Sent Date --- System
PDkt WSX Purchase Docket --- No
Species WSX Species (from Sold As WoodGroup) --- System
MajorGrade WSX MajorGrade (from Sold As WoodGroup) --- System
MasterGrade WSX MasterGrade (from Sold As WoodGroup) --- System
Permits WSX Permits --- Optional
Backload WSX Backload Type --- System
LoadType WSX Units assoc with uplift, e.g. Truck, Trailer or Truck+Trailer --- System
Journey WSX Journey No. --- System
ForestGate WSX Forest Gate (from Base Distance Route assoc to Journey) --- Optional
JourneyWeight WSX Sum of Net Weight for all Uplifts assoc to Journey --- Yes
StartTime WSX Journey Start Time --- System
AtCrewTime WSX Journey At Crew Time --- System
LoadedTime WSX Journey Loaded Time --- System
AtCustomerTime WSX Journey At Customer Time --- System
EmptyTime WSX Journey Empty Time --- System
JourneyTruck WSX Truck assoc to Journey (used for info for split loads) --- System
JourneyTrailer WSX Trailer assoc to Journey (used for info for split loads) --- System
CustomerLocation WSX Location assoc to Customer in Database --- System
Page updated
Report abuse