Consignment Note Number¶

At the moment we can set an automated task to import the consignment not number (tracking number) from two different csv files.
We have had requests to be able to import two more different import layouts.
To do this, we have added some more flexibility to this functionality, in a similar way that we did for exporting carrier files at the despatch stage.
There is a system table called ‘Carrier/Freight Feedback Layout’.
It is similar to ‘Carrier File Layout’, in that the user is able to enter Layout Name (unique) and select Layout Type (XML or CSV).
The following changes were made on the Parameters form.
There is a tab in Administration > Parameters called ‘Carrier/Freight Feedback’.
The grid has have two columns: ‘Carrier/Freight Feedback Layout’ and ‘Location’; it has been moved to the ‘Carrier/Freight Feedback’ tab

Archive Location and Broken Location will remain common for all Layouts so far.
One user (and only one) should be st up with the following advanced permission switched on.

Please note that the 'Operator' which was configured on the 'Parameters > Carrier / Freight Feedback' form should be in Blindata during the import/update the consignment note number.

After Layout type is selected user will be able to define file structure.

For CSV files only three fields are available:

Order No Identifier (alphanumeric) – this is the column name in CSV file where Order No from Blindata will be found;
Consignment Note No Identifier (alphanumeric) – this is the column name in CSV file where Consignment Note No will be found;
Find Order By (drop-down list with 2 available choices: Order No, Cust. Ref.).

For XML files only three fields will be available:

Order No Node Name (alphanumeric) – this is the node name in XML file where Order No from Blindata will be found;
Consignment Note No Node Name (alphanumeric) – this is the node name in XML file where Consignment Note No will be found;
Find Order By (drop-down list with 2 available choices: Order No, Cust. Ref.).

When the Automated Task is run it will go through all records from the new grid, take all files from ‘Location’ for each Layout and try to process each file according to rules specified in System Tables.
If the file doesn’t match rules then it will be moved to the Broken folder, otherwise – to Archive if these paths are specified.

Once the consignment note number is saved in the order record, an order history record will be created.

There is now functionality to import more than one line at a time or more than one file at a time.
This is only applicable to CSV files.
If one of the records does not update the consignment note number to an order, then the file goes into the broken folder.