Scan Import

Scan Import

Scan 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 an example setup that could be used to receive scan information from a cubic scanning machine (a machine that measures/weighs your freight as it arrives in your depot).

There are likely many different types of cubic scanning machines available for purchase. This article only runs through the setup on the TransVirtual end - it is up to you and your team to configure the cubic scanner machine and enable it to send the data across to TransVirtual in the required format.

To Create/Add a Rule

1. To create/add an Import rule, go to Import/Export > Data Import > Scan Events, the Scan Event Import Settings page will display as shown below.

                                                                  

2. Now click on Add import rule as shown above, create a new import pop-up will display as shown below.

                                                                                    

3. Manually enter the Rule Name, select the Import Framework with the help of Drop and Down button and then click on Create button as shown above.
In this example, set Import Framework to be TransVirtual Hosted FTP.
                                   
4. Once rule has been created, then the rule will appear in the list and will be coloured orange indicating that it is not yet active/enabled as shown below.

                                                      

5.  Now, click on the Rule, the rule detail will appear on the right-hand side as shown below. 


Update the Rule Details


1. Rule Name: Name given to rule. Can be changed at any point but should be reflective of what the rule will be used for/does. This example will leave rule name as was set on initial creation.
2. Trigger Period:  How often the import will look to import new files. This example will be set to the default Every 2 mins value. 
3. Import Framework: Used to determine how TransVirtual will receive the data from the cubic scanning machine. Here you can update the import framework setting by clicking on setting button as shown below. 
      
                        

      A. As per above, when you click on Settings button, a popup for Edit the FTP Settings appear, where fill the required details as describe below. 
            i. First generate the FTP server by clicking on Generate FTP Server button, then the FTP server, Username and password details will automatically fill.
      These details are the FTP location that you need to configure to send files where TransVirtual will import into your account from there.
            ii. After generating FTP Server details, click on Update button to save the changes.
            iii. If required, you can view the FTP details again by clicking the Settings button at any time.

4. Import file Type: The file type that will be sent containing this scan data.
    In this example we are using file type CSV.
                                                                           

a. If required you can update the settings of import file type by clicking on setting button, a popup of edit the CSV setting will open as shown below.

                                    

b. As per the above screenshot you can adjust the column mapping to include the data you will receive from your scanner machine and then click on Update button.
1. You are able to use any of the available fields but should ensure to include Scan Barcode (as this is how TransVirtual knows which connote to attach the scans to), dimensions, scan type (machine likely would send depot type scans as likely these scans would be done on freight arriving at depot), scan time and Location Scan Base (refers to location scan was performed/headport location etc.).

6. Customer (Optional) = Allows you to nominate a default customer these scans would apply to but for this example we are leaving blank as scans will be for consignments across all customers.
7. Agent/Supplier (Optional) = Allows you set a default agent for imported scan values - typically not needed and this example will be left blank.
8. Date Format String (Optional) = Allows you to determine how TransVirtual will read Dates in the imported CSV files.
However, exact configuration will be dependent on what your cubic scanner machine can send (what format it puts the dates in).

9. DateTime Format String (Optional) = Allows you to determine how TransVirtual will read Date Time fields in the imported CSV files.
However, exact configuration will be dependent on what your cubic scanner machine can send (what format it puts the date times in).
Below screenshot gives you an idea about how to utilize the steps 8 and 9 as below.
                                                      


10. Time Zone: The import rule for Time zone should be set, if the scanner machine is located in Sydney, then the Time Zone should be Sydney time and vice versa.
11. Enable Import: Allows you to activate the rule when configured by clicking on toggle button in Yes position.
12. The remainder of the settings are typically not required, and this example will leave them blank.
13. After step 11, click on Update button, you can see the import rule is in white color which means it is activated now.
14. You are now able to send CSV files to the FTP location attached to this import rule and providing all setup is correct, the scan values will import and attach to the intended consignments.

Note: Dimensions imported from these types of import rules will only update the applicable consignments IF they are greater than what is currently listed against the consignment.
For example, if importing dimensions of 1.25m L x 1.25m W x 1.25m H for a pallet on a consignment where the current dimensions are 1.3m L x 1.3m W x 1.3m H, the new imported dimension values would not update the consignment details because the current dimensions are larger than the new values.

Delete the Rule


1. If you want to delete the rule, simply click on the delete icon, a confirm dialog will pop-up, click on Yes button, the rule will be deleted from database as shown below.

                                                                  ​

    • Related Articles

    • Freight Scan Types

      Freight Scan Types Freight Scan Types in TransVirtual are different types of scans that can be applied to a consignment. The main reason that scans are used is to provide visibility to consignments. For example, when a Depot In Scan is done on a ...

    • Consignment Import

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

    • Scan

      Scan In the TransVirtual mobile app, you can create scan events for freight as it move the Consignment cycle. Scanning 1. To see the scan page, on mobile home screen, tap on the Scan icon, you will be presented with the below screen. 2. From here you ...

    • General Import Information

      Introduction to Imports The import framework within TransVirtual allows you to import your data in a number of ways. This framework will expand as technology develops. There are 6 import frameworks as below. Remote FTP TransVirtual Hosted FTP Server ...

    • Manual Import

      Manual Import In TransVirtual you have the ability to manually upload a file for import, to do this go to Import/Export > Administration > Manual Import, you will be presented with the below screen, either drag and drop your file or click and select ...