I've been looking through the CSVs for the game in the hopes of making a tool that can fill out the bestiary for the wiki. The wiki's bestiary section is missing a huge number of monsters, a lot of the data is out of date with respect to Weekend and the English patch, and what monsters are filled out are missing a number of useful stats.
http://www.mediafire.com/?1wk4pec746eksu2This is the CSVs I have, a text file with some of my notes on trying to decode the mess, and a python script that can load the CSVs into an SQLite database. The goal is to use the database to join the related CSVs together to be able to get
everything relevant to the GoS monsters: in addition to all that is on the wiki now, I would especially like to see status resistance and which maps a monster can appear on. I think that going all out with be too much data for the wiki, but at the very least it could be populated with the important fields, and anyone that wants to know everything can query the database themselves.
Running the script will require Python 2.x and pysqlite 3. Unzip everything into a folder and start a Python shell session in there. Import the script, then do "script.init()' to load the database from the CSVs. You can then do 'script.run("sql")' to run arbitrary SQL on the database tables.
Unfortunately, the CSVs are exceedingly complex. There's a huge number of fields in each; mroutine is the worst offender, with just under 600 columns. I've managed to decode a lot of the important fields and should be able to recreate all of the data on the wiki now (with the exception of enemy skill data; right now I only get the name), but the extra bits are a mystery now. Status resistances and extra abilities are completely untouched, and it's hard to make progress since everything is hidden ingame.
This is very much a work in progress, and any help would be greatly appreciated. The biggest issue is decoding the remaining CSVs to find any useful information, and anyone with an abundance of time on their hands could help with that. People with Python or SQL experience could help out with the script, but I should be able to handle that myself. Anyone really good with wiki templates and tables could work on something to store the extra data I'm trying to extract, e.g. possibly with collapsible sections.
As a final note, it's possible that this tool will work with DoD as well, since the engines are so similar now. I haven't tried this yet, however. It would be nice, since DoD's bestiary is entirely missing right now.