Somebody asked me about how they could convert an XML file to a CSV file to upload into MySQL. They were asking the question based on an old Convert XML to CSV blog post from 2008. Amazing though that is, I had to explain the process no longer requires manual tasks, like calling Java files from the Apache XML Project. All they needed to do was use the Oxygen XML Editor, which is why I wrote this blog post.
For example, I had them use the same sample XML file from the old
blog post (shown below) with one change. The
encoding value needs to change from
latin1 (ISO-8859-1) to unicode
(UTF-8). Then, they should put it into a local
Windows directory (mine went into the …