SQL = Seeming Quite Lost

[isnorden]

I used SQLite Spy on Civ5DebugDatabase.db today, but can't understand why my attempts at saving tables to a Notepad++ compatible file have all given me 0 KB, blank documents coded to be in SQL. (What happened to the data tables I selected before I told SQLite Spy to save?) Please tell me what I did wrong!

 

[whoward69]

Unless you're using a different version to me, SQLiteSpy has no save table. It has "Save SQL As..." which saves the SQL statement in the top part of the right hand side of the UI ...

 

[isnorden]

So how can I extract a Civ5 database table, if a way exists? (Nexus repeatedly fails when I try running it.)

 

[whoward69]

You can't (at least not without a bespoke program like the one I wrote to get the unit, building, etc data). All the data in the table is in the associated Civ5Xyz.xml file(s) anyway.

 

[isnorden]

Hmmm...I don't know which .xml files (of several resource-related ones in two expansions) have the artdefines I need to copy. I'm pretty sure the .fxsxml models mentioned in those defines are hidden someplace, too...was I wrong to think the database would point to that location?

EDIT: Eek! Not a single <ArtDefine_Landmarks> tag in the XML files inside Civ5 folder or its subfolders; I do need to comb the SQL to find which resources use which models.

 

[isnorden]

This just in: I successfully extracted several tables from the database with Mythicsoft's SQLite Browser. The term "successful" is fairly loose here, though: the program exported an unformatted Great Wall of Code, with no tabs or white space to help me follow the data. Could one of you please see whether the attached files include the data I mentioned in the "copycat resources" thread? (The MainData.fpk package has the graphics but not all the written definitions.)

 

[Nutty]

I started to respond here about exporting from SQL, but it turned into a tutorial: Dealing with lots of data. Hopefully you'll find it useful.