What is the Export Grid:
The Export Grid function allows the user to extract a data file containing a snapshot of the data on that grid.
How to Export the Consignment Search Grid
Note: If you do not have access as Administrator or Organization User, you cannot access the above links. You will also need to have the following permission set to "Create / Delete" on your Role.
Navigate to Global Search
Once that's done, head to the Search field and type in the required search text
Once the search has returned, you can then select Actions and select Export Grid.
The file will be downloaded in a .csv format containing all the return consignments set on the search text field.
The spreadsheet file can now be opened in your preferred program for further analysis and manipulation.
Once you've opened the exported file, the following data or fields include:
CreatedDate - date the consignment was created
TrackingStatus - current consignment status
ConsignmentNumber - MS# of the consignnment created in MachShip
CarrierConsignmentID - Id of the carrier the consignment was booked on
Company - Owning Company of the consignment
CompanyAccountCode - Company abbreviation
FromNameAndLocation - contains the From location name and suburb details
ToNameAndLocation - contains the To location name and suburb details
CarrierAndServiceName - carrier name and service the consignment is booked
Total - consignment total
DespatchDate - consignment set despatch date
Eta - consignment set/expected ETA date
CompletedDate - date of the delivered/completed consignment
CustomerReference - consignment/customer reference field set (Ref1)
CustomerReference2 - consignment/customer reference field set (Ref2)
Attachment Count - file attachment uploaded count (i.e POD etc.)