I am receiving XML files from a vendor which I need to import into SQL. I am using a tool called the Pervasive Data Integrator because it has a plugin for my application.
However, the XML files are not formated like I would expect and it appears to be causing problems.
The xml files has
<account timestamp="2013..." accountid="1234"><contact><email>firstname.lastname@example.org> etc
all the data is one line and I am having trouble parsing it. Is there another way to accomplish this? I noticed if I formated this properly, then extracting the data is easy.
Is there an application which will format?
Any ideas are appreciated.