Our ERP system stores shipment information for every customer order.
If we ship this order using DHL, we write a line containing 'DHL' to a shipment table (MSSQL 2008R2).
This is rather complicated, see the attached trace file for details.
The assignment is to pickup these lines (using a trigger or otherwise) and then generating a file in DHL format so we can read that particular shipment into our DHL software automatically.
To provide some more info, i've attached:
- DHL file format
- DHL import functionality
- trace of the input that's written into the MSSQL database.
Your bid includes retrieving the shipment information from the database, marking it as processed and then writing it to the DHL file format.
Other:
- payment will be put in escrow and released upon a working environment (prompt payer)
- RDP desktop is available for testing
- please make sure you speak decent English and have the necessary communication skills
PLEASE MAKE SURE YOU UNDERSTAND THE TRACE FILE BEFORE YOU BID!
By the look of the sample files, this is a fairly straightforward and common task. I assume that marking the data as processed is just another entry in the database.