Consignment CSV Import

Consignment CSV Import

Consignment CSV Import

When creating a CSV EDI import, you are required to ensure your import file is a csv not an Excel file and that it is mapped with the correct information.
For this example, we will be doing a simple two line consignment import.




Creating the EDI Rule

First step is to create an EDI rule, you can do this by going to EDI > Data Import > Consignments
Here you can add the rule and begin tweaking.



Adjusting the Rule

Now there are six types of import framework available:
- Remote FTP Server
- TransVirtual Hosted FTP Server
- TransVirtual Email Account 
- Manual 
- 2D Barcode Scan

For this example will select Email and then select update (Required whenever a change is made to the rule).



This will allow us to send an email to a generated receiver address that imports the file to TransVirtual.
You will now need to move down to the Import File Type.
This import file type will be a csv file.

Mapping and File Adjustment

Select the setting button next to Import File Type.



This will bring up a page where you can adjust the columns required.


As per above, if you have a first row (headings), you will be required to ignore it.
Then you will need to adjust the column mapping to match your file.



These are the columns in this case, however there is not a selection for everything.
In this case you can use the "xignore" column to ignore the required column.

Generate Email and Enable

Now after updating/saving the mapping, we need to generate an email address to send our file to.
You will need to go to import framework settings.



What you can do here is generate an email address, copy it, add it to your emails.
After this, will need to enable the rule.


Conclusion

Now that you have an email address generated, you can use this when required to send your file into TransVirtual.
If you have any issues or queries you can contact support@transvirtual.com and we will be happy to help.









    • Related Articles

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

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

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

    • Import Monitor/Alerts

      Import Monitor/Alerts Under EDI > Other EDI Tools > Import Monitor/Alerts; you will find the Import Monitor page in TransVirtual. This page does as the name suggests, it allows you to monitor your imports and setup alerts should imports not 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 ...