I have a supplier that has product information which is stored at 2 separate links, which they update on a daily basis. One is a csv file that has product category information. The other is an xml file that has descriptions, and references to the other file.
What I need is something that can download that information from the xml file and convert it into a simple csv file, with the data listed in rows next to one another. It then needs to reference the other file, and replace the code, with the actual information. The following is an example of the code for the xml file.
<part> <warehouseloc>1-55-AL-1 </warehouseloc>
<name>Sample Item Name</name>
<Shipping_Method>Ground Or Air Service</Shipping_Method>
<catalog_desc>2001 CATALOG # 35</catalog_desc>
<Description>A lovely sample item to wear around the home </Description> </part>
Where it say "<web_category1>7</web_category1> " it needs to reference the first column of the csv category file, and print out the #7 response.
In addition, I will need a master file, which will allow me to append additional information, or change information about a specific product, without having to worry about an update over riding my information about that product on a daily basis.
It will have to do this automatically, on a daily basis. If you have any questions please let me know.