This is a quick bit of code to transform XML to CSV. This code was used to migrate an InMagic database to an Atom database. The database has over 5,000 records.
I had to do a bit of 'pre-cleaning' on the XML to remove some InMagic noise. I used a text editor to find and replace all instances of inm: in the XML tags. I also removed the root (or very first) tag, which looked like this:
<inm:Results productTitle="Inmagic DB/TextWorks" productVersion="14.00" xmlns:inm="http://www.inmagic.com/webpublisher/query">
Don't for get to also delete the closing tag at the end of the file, otherwise you'll get an error. In this case, the closing tag was <Results>.
I know it's possible to read the XML and print to CSV (see PeelXML) for that, but this makes everything way faster and requires much less unnecessary cleaning.
All of the code is described in the Jupyter Notebook file, both here in this repository or in NBViewer.
The first step transforms the XML to JSON using the xmltodict module. It really just reads the XML to json and saves it to a new file.
This code was entirely written by GitHub user Vinay. I didn't have to change this code at all. I did need to make a minor change to the json file, and that's described in the Jupyter notebook.