TransVirtual Simple CSV Import V1.0

TransVirtual Simple CSV Import V1.0

This simple CSV import is designed for customers sending simple consignment data, Sender, Receiver and Item information, but using the consignment numbers for the respective account.

There are 2 files attached to this article, they are as follows;

  1. CSV Import-Simple_Explained-v1.0.xlsx - This contains some sample data and a description of how to layout consignments with multiple item rows.
  2. CSV Import-Simple_Template-V1.0.csv - This is a template CSV file to use as a template for manual creation


Key points to consider;
  1. By default Weight is in KG's. Notify if the dimensions are in a different unit of measure
  2. By default Dimensions are in Meters. Notify if the dimensions are in a different unit of measure
  3. The address suburb state and postcode MUST be to Australia Post standards.
  4. If there are multiple Item Rows, the consignment information MUST be repeated, if its not the same it will create a seperate consignment for each row. 


    • Related Articles

    • Scan EDI Import

      In TransVirtual there is the ability to setup Scan EDI (Electronic Data Interchange) Import rules that can import scan data relating to consignments. These imports can be setup to receive information via FTP, Email, etc. This article will run through ...

    • Consignment EDI Import

      Consignment EDI Import In TransVirtual there is the ability to create EDI (Electronic Data Interchange) Import rules that allow you to create consignments without the need to use the consignment creation page in the TransVirtual Web Portal. This is ...

    • TransVirtual Detailed CSV Import V1.0

      This Detailed CSV import is designed for customers sending detailed consignment data, Sender, Receiver and Item information where additional information may be required. There are 2 files attached to this article, they are as follows; CSV ...

    • Import Types with Examples

      In TransVirtual there is the ability to import different kinds of lists into different pages or sections of TransVirtual. These imports are achieved by uploading a list of data in csv format - the purpose of the import process is to allow you to be ...

    • Proof of Delivery EDI Import

      Proof of Delivery EDI Import In TransVirtual there is the ability to create EDI (Electronic Data Interchange) Import rules that allow you to upload PODs and attach them to a consignment. This process would typically be used where an outside system is ...