CSV File Creation

[scotrodg]

Good afternoon All

We are moving to DPD for carrier services from our warehouse. The DPD system works online and polls from a CSV folder to add to their manifest and print a label.
Apparently when we dispatch we should be able to set up Sage to send a CSV file to a specific location which DPD's system polls every 3 seconds and adds the info to their manifest, then prints a label.

DPD have not been too helpful, Sage support has been worse!!

Can anyone tell me how this is set up on Sage?

[brucedenney]

It is not as simple as you think.

You need to have a method to decide when you create the file then you need a method to make sure you don't create the file multiple times.

A sophisticated method might only export orders where the stock has been fully allocated to the order and then flag the order to prevent it being exported again.

To do this you need to use 3rd party tools to integrate properly with sage.

The alternative is to print a report to CSV having selected the orders to report manually

[scotrodg]

Bruce

You are wise as ever, it is most certainly not straightforward. However after discussing the options with the optimistically named Sage Support Centre, I managed to get a report created in the required format.

Frustratingly I have found that this report is only available on my computer, when I could do with it being accessed across the network.

Any ideas on how to share the report?

[brucedenney]

You can select the option use data path for reports.

Personally, I would be inclined not to use a report, but to extract the data using a batch file and odbc, this way you hit the button and get the data without even opening Sage.