Embedded Files
This document describes the process to run the the WSX LIMS docket export.
For dockets to be written to the LIMS export file the following criteria must first be met,
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 or E-Check, or both depending on rules set in DB Setting LIMSCheckReq_LogOrg
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 > LIMS > Export to LIMS. 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 LIMSEXportPath_LogOrg, with a file naming convention of ‘LIMSExport_LogOrg(s)_DD_MM_YY.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
JourneyNumber WSX Journey No. --- System
UpliftNumber WSX Uplift No. --- System
LogOrg WSX Logging Organisation (assoc to Gang Locn assoc to Uplift) --- System
UpliftDate WSX Uplift Date --- System
DeliveryDate 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)
TruckRego WSX Truck Registration --- System
TrailerRego WSX Trailer Registration --- System
Unit WSX Truck, Trailer or Truck + Trailer --- System
JourneyTruck WSX Truck assoc to Journey (used for info for split loads) No? System
JourneyTrailer WSX Trailer assoc to Journey (used for info for split loads) No? System
CartageContractor WSX Trucking Contractor Code TRUCKCON System
Driver WSX Truck Drivers associated Contact (first & last name) --- System
TruckType WSX Truck Type --- System
CTI WSX Truck CTI status --- System
GangCode WSX Gang Code CREW System
GangNumber WSX Gang Number --- System
GangContractor WSX Logging Contractor Code (assoc to Gang) LOGGER System
Loader WSX Loader Code (Not Loader No.) --- System
LoaderContractor WSX Loader Owner (assoc to Loader) --- System
ForestCode WSX Forest Code (full code incl Supplier/Short Code) --- System
SupplierCode WSX Supplier ID Yes ? System
ForestShortCode WSX Forest Short Code FOREST System
Compartment WSX Compartment Code --- System
Setting WSX Setting Code --- System
Customer WSX Customer Code CUSTOMER System
CutAs WSX WoodType Code (Uplift) WOODTYPE System
SoldAs WSX WoodGroup Code (Delivery) WOODTYPE System
Species WSX Species (from Sold As WoodGroup) --- System
MajorGrade WSX MajorGrade (from Sold As WoodGroup) --- System
MasterGrade WSX MasterGrade (from Sold As WoodGroup) --- System
ExportLength WSX Export Length (from Sold As WoodGroup) --- System
CutLength WSX WoodType (Cut_As) Length --- System
GrossWeight WSX Gross Weight --- No
TareWeight WSX Tare Weight --- No
NetWeight WSX Net Weight --- Yes
JourneyNetWeight WSX Sum of Net Weight for all Uplifts assoc to Journey --- Yes
FellDate WSX Fell Date --- No
Pcs WSX Pieces --- Export Customers Only
JAS WSX JAS (Volume) --- Export Customers Only
PDkt WSX Purchase Docket --- No
Permits WSX Permits --- Optional
Backload WSX Backload Type --- System
TripType WSX Trip Type --- System
ForestGate WSX Forest Gate (from Base Distance Route assoc to Journey) --- Optional
MChk WSX Manual Check Status --- Yes
MChkDate WSX Manual Check Date --- Yes
EChk WSX Electronic Check Status --- No
EChkDate WSX Electronic Check Date --- No
Status WSX Docket Sent Status --- System
SentDate WSX Docket Sent Date --- System
StartTime WSX Journey Start Time --- System
AtGangTime 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
Page updated
Report abuse