Any thoughts at all, given all of this rambling?.Where might we look to develop this process, whatever it looks like?.What might this process look like? Excel macro? Web app?.Keeping in mind that we have little to know development ability on staff, now might we achieve something along these lines? Specifically. We would need to do this on a regular basis. The question that I am looking at is how difficult would it be to convert source XML A into CSV B, with the appropriate data fields in the right places. Each column has a header and represents a given data set. They are used to ingesting lists of orders into their software by way of CSV files, setup in a particular format. The second party is setup in a similar way. Let us presume that the vendor for this software is no longer available, so the XML is what it is.
The only option for doing so is an XML export file. They need to send data - say a list of orders - to another party.
One party has an application that they are heavily invested in.
I have a question that has landed on my desk, and which way outside of my practical skill set.