Uploading to the FTP server
To upload files via FTP, go to the 'Load' directory and drop the file within the following directories based on the service (please request if you would like an alternative directory setup to this).
Service | File location |
Load Companies | Load/Companies |
Load Product Master Updates | Load/Product_Master_Updates |
Load Product Masters | Load/Product_Masters |
Load Receipts | Load/Receipts |
Load Release Sales Order from Hold | Load/Release_from_Hold |
Load Sales Order Cancellations | Load/Sales_Order_Cancellations |
Load Sales Orders | Load/Sales_Orders |
Load Web Sales Orders | Load/Web_Sales_Orders |
Files will be loaded from the FTP server based on the recurrence setup on the scheduler. By default this is every 15 minutes.
Automatic file archiving
The hub will make a call to the FTP to upload any files you have put in the FTP folder. Once the file is processed, the hub will archive the file into an "Archive" folder. If the file has the same naming convention as another file as an existing file in archive, the new file will be given a date/time stamp. For example, the following file name 'LWSO_Load_Web_Sales_Orders.csv' would be renamed into the following format: 'LWSO_Load_Web_Sales_Orders06-10-17-161011.csv. This shows the date it was processed (06-10-17 (dd-mm-yy)) and then the time (16:10:11).
XML response files
For each XML file that is processed, you will also receive a file to the FTP folder with the following example format: LWSO_Load_Web_Sales_Orders.xml_06-10-17-161029_response.xml
The response file will tell you whether the upload was successful. The response data will be structured in the order in which the uploaded file was given, per entity.
Examples of the success and failure response messages for each service can be found in the service details.
To find out if a FTP CSV upload was successful, you will need to login to the hub directly and view the Activity Monitor or through email notifications.