XML to CSV Data Merge and Conversion
I have a supplier with product information stored in four different locations. This is a project to set up a system to merge that information into a single CSV file, on a daily basis. The first thing that we have is a link to a zip file, that has 24 xml documents, which contain the descriptions of the products in the catalog. This file is updated once a month. This file references a categories file, that has category information. This is also updated once a month. Then we have a link to a zip file containing 24 xml documents, which pertain to in stock, out of stock, and which also contains additional product information. This is updated on a weekly basis, and contains the entire catalog of products. If a product is missing from that file it means it has been discontinued. Finally we have a link to more zipped files, which are updated twice a day, with daily stock change and quantity amounts. We need a system that merges the information from all of these different files into a single csv file. We also need to be able to append information to that file, which will permanently remain affixed to individual products. Example of Descriptions XML 1-55-AL-1 435297 FW114272SM Sample Item Name FW133372 CHINA Ground Or Air Service 1.19 16.00 11.00 3.00 2001 CATALOG # 35 293 16.80 Child 4-6 7 3 4 1 555666777 A lovely sample item to wear around the home The other XML files are similar, with different informational elements. All information is delivered via static links to zipped xml files. The output CSV doesn't have to be anything fancy, just rows of information layed out in appropriate order. Let me know if you have any questions about this project. Thank you very much. Keywords: Script, MySQL, Javascript, Install, PHP, XML
| Expired |
Paul Sterling
Graphic Designer
View profile
Michael Muttiah
Sales & Marketing Consultant
View profile
Sanjeev Suri
Virtual Assistant
View profile
Betty Favor
Finance Consultant
View profile
More javascript projects
View AllMore mysql projects
View AllRelated projects
Search for freelance jobscan’t wait for more clients
and advertising. Thank you."