XML Formatter / parser
I am looking for a tool to open an XML file and convert it to a database or spreadsheet. The XML file is well formed and follows this basic idea:
<database name='Data' date='2/2/2021 939 PM'>
<Field3>6/12/2012 1200 AM</Field3>
... repeat for all "Table1"
... repeat for all "Table2"
... many more tables
This file is generated from an online service I use and is a "Database Backup" of my data. Right now this XML file has almost 5 million lines of text. I can view it and such easily in BBEdit but I am hoping something to convert it to a SQLlite database or a spreadsheet where each sheet is a different table.
Anyone have any thoughts?
Hi Scott! I know I probably sound like a broken record, but FileMaker would be my first attempt here.
Otherwise you're building an XML Parser engine from scratch-ish (you could, for example, use PHP's XML library to slurp in the XML, but then you still need to populate the database from the resulting array, and that's a ... job. 🙂
I have tried FileMaker and a number of database import tools. They all seam to expect the XML has data for a single table and not multiple tables. So, basically a fail across the board. I guess I am going to have to write code if I can find some spare time.