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.