A client from Italy has reached us for the following job:
Objective: generate a simple program that generates XML files from
combining a constant part with values from Excel. These files are
invoices for Amazon.
Process: if you think you have the right experience, please read the ToR
carefully. Please contact me with an offer of what fee you would like
to generate the xml for me from a similar Excel file.
A) First Part of xml
- The first part of each xml is unchanging: FatturaElettronicaHeader
- To this I need to append additional xml: Fattura ElettronicaBody
- One xml file is needed for each Amazon Order - each IdDocumento
B) Rest of xml - items ordered (DettaglioLinee)
- An Amazon order might include 1 item (DettaglioLinee) or 2 items or many items.
- If an order has 2 items in it, then the third item (DettaglioLinee,
NumeroLinea=3) is always Shipping cost. If the order had 3 items, then this would have NumeroLinea=4, followed by the same Shipping Cost info. If the order had 4 items then the Last NumeroLinea would be 5, etc.
- Then you need to add the rest of the xml.
C) Please try to recreate XML and send it to me to check with you offer of the fee
you would need to generate additional XML files for me from the complete
Excel.
This is how the Excel file was structured:
And this is print-screen from the Windows Explorer, where you can see files generated:
