How to Export Grid Consignment Status via Consignment Status Dashboard

How to Export Grid Consignment Status via Consignment Status Dashboard

What is the Export Grid:

The Export Grid function allows the user to extract a data file containing a snapshot of the data contained on that data grid.

How to Export the Consignment Status Grid via Consignment Status Dashboard:

Navigate to Dashboard then Consignment Status:




Note: If you do not have access as Administrator or Organization User, you will not be able to access the above links.

On the Consignment Status page, click Adjust Filter Preferences button to adjust the date depending on the dispatch date of the consignments you wanted to export. Hit Apply and then Update Filters.


Once the filter has been applied, click the Exceptions button, then scroll down to the bottom of the page and you will see the Active Consignments grid.




Ensure the grid contains all the data you wish to export by clicking Show More Results at the bottom of the grid.



Once that's done, head to the Actions button, and select Export Grid.



The file will be downloaded in a .csv format containing all the Exceptions consignments. These are Canceled, Damaged, Delayed, Partial Delivery, and Delivery Attempted.

The spreadsheet file can now be opened in your preferred program for further analysis and manipulation. Checking on the exported file, the following data or fields include:

Tracking Status
Consignment Number
Carrier Consignment ID
Company
Company Account Code
Customer Reference
Customer Reference 2
Pickup
Delivery
Service
Total
Created Date
Despatch Date

ETA

Completed Date

Attachment Count

Example:



    • Related Articles

    • How to Export Grid - Consignment Search

      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, ...

    • How to run the Consignment Export Report

      The Consignment Export Report will provide users with a CSV extract of all consignments created over a set period of time. This report will allow users to run a large-scale analysis of your freight movements. How to Run the Consignment Export Report ...

    • How to Export Grid on the View Consignment Page and the Pending Consignments Page

      What is the Export Grid: The Export Grid function provides the user with the ability to extract a data file which contains a snapshot of the data which is contained on that data grid. The Export Grid can be used under the All, Completed, Active and ...

    • How to Export Grid on the Generate Invoices Page

      What is the Export Grid: The Export Grid function allows the user to extract a data file containing a snapshot of the data contained on that data grid. How to Export the Generate Invoices Grid: Note: If you do not have access as an Administrator or ...

    • How to Export Grid on the Held Consignments

      What is the Export Grid: The Export Grid function allows the user to extract a data file containing a snapshot of the data contained on that data grid. How to Export the Held Consignments Grid: Note: If you do not have access as an Administrator or ...