315627 XML to CSV and CSV to XML

In Progress

Description

We have a three part project.

1. Convert a large XML file to a csv file

2. Create a script that will convert a daily csv file into an xml file

3. Create a script that will take a daily xml file with inventory qty information and update the corresponding product code qty's on a csv file.

Basically, we are an internet store with a new supplier who will only exchange data in xml, and our internet store only uploads and exports csv files. We need to get the new supplier's inventory data converted into our csv file format so that we can upload it into our store. Then we need to take our store's daily orders that we download in a csv format and convert the orders to xml so that we can upload them in a daily batch to our supplier. Lastly, we need to update inventory qty's from the daily xml file we get from the supplier with our internet store. We are very adept with manipulating csv and Excel files - we just don't know about xml files.

Skills: Anything Goes, XML

See more: adept with, xml supplier, xml excel, need to get excel, exports, excel-to-csv, Excel to CSV, csv to excel, adept, inventory excel format, large xml csv, excel create xml, xml excel format, csv update, batch batch excel file, create csv file inventory, csv convert, inventory supplier csv, update data excel script, xml file excel, xml product script, create inventory excel, inventory daily, excel create xml file, script convert xml csv

Project ID: #2061426