Now that the import process has finally finished for the XML, it's time to think about how to proceed.
I am admittedly beginning to wonder if the mage DPS/gear "spreadsheet" is a separate project from the gear database. I may come back and decide to split it off.
The first items of business would seem to be:
- Investigate the tooltip XML documents further.
- Create the schema for storing items in the database.
- Implement code to transform the item info and tooltip XML into actual items.
- Verify success by ensuring that the XML generated by the item objects matches the tooltip XML. (Since the item info XML is only going to be used to extract the item level, I'm not worried about making sure the XML matches.)
Funny how easy this seems when written down.