Ecommere application provides customer/sales data in XML format. Need specific information from the XML pulled out and put into a predefined CSV format that we can import into our Access Customer Management application. I would prefer to have this information all in a CSV instead of bringing directly into Access.? The XML data file contains a significant amount of information we don't need or want.? As an example, the customer has 12 different choices for delivery date.? All dates are listed in the XML file as a BoolianAnswerList, with 1 choice being set to true, and all other date choices set to False.? I need the one True selection put into the CSV file, with the 11 False dates ignored.? There are several other fields similiar to this example.? The CSV file requires 30 pieces of information, all which is included in the XML data file.? I have an example of what the CSV needs to look like, and can also provide an example of the XML data file that contains all the information.? Timing is very important. This project needs to be included by midnight on Sunday, October 26.?
If needed, I can provide a example of both the XML data file along with an example of what the final CSV file needs to look like.