I'm guessing one of the two files in:
\Data\Databases\
contains the list of all the games I have. Does anyone know what I can open and edit these files in? I'm trying to rename 400 or so games, and the HTTP option, while awesome, is horribly unrealible right now, and renaming them all from the Dash its self takes to long.
Full Version: Database File?
QUOTE(FrostyWolf @ Mar 23 2011, 09:06 AM) 
I'm guessing one of the two files in:
\Data\Databases\
contains the list of all the games I have. Does anyone know what I can open and edit these files in? I'm trying to rename 400 or so games, and the HTTP option, while awesome, is horribly unrealible right now, and renaming them all from the Dash its self takes to long.
Yes. It's going to be the bigger file.
The database we are using is SQLite. You can find many free SQLite browsers via google. Open the database file, and you should be able to find the "Content" table easily. Be careful in there...you could *easily* change something that will force you to have to delete the db file and start over.
The sole reason there are two database files are so that you *CAN* delete the one with the content in it, and keep the other one with all of your preferences and settings...
-node21
Hi
I'm just coding a new app for fsd2data/settings and xm360 reports.
Never thought about an option to export a list with game names in order to
edit them, but if its useful, shouldnt be a great deal.
Check this video out in my blog, it contains the progress so far.
If you want to edit the database file yourself you could use
SQLite admin
I use the commandline app from SQLite's homepage
A batch file like this will export all data in csv format:
"[PATH TO SQLITE]\sqlite3.exe" -csv -separator ; -header fsd2data.db "select * from Favorites;" >Favorites.csv
"[PATH TO SQLITE]\sqlite3.exe" -csv -separator ; -header fsd2data.db "select * from Assets;" >Assets.csv
"[PATH TO SQLITE]\sqlite3.exe" -csv -separator "|" -header fsd2data.db "select * from ContentItems;" >ContentItems.csv
"[PATH TO SQLITE]\sqlite3.exe" -csv -separator ; -header fsd2data.db "select * from UserRatings;" >UserRatings.csv
"[PATH TO SQLITE]\sqlite3.exe" -csv -separator ; -header fsd2settings.db "select * from Tabs;" >Tabs.csv
"[PATH TO SQLITE]\sqlite3.exe" -csv -separator ; -header fsd2settings.db "select * from GlobalSettings;" >GlobalSettings.csv
"[PATH TO SQLITE]\sqlite3.exe" -csv -separator ; -header fsd2settings.db "select * from UserSettings;" >UserSettings.csv
The names are stored in ContentItems. I used | as separator as I ran into problems when importing to Access.
I'm just coding a new app for fsd2data/settings and xm360 reports.
Never thought about an option to export a list with game names in order to
edit them, but if its useful, shouldnt be a great deal.
Check this video out in my blog, it contains the progress so far.
If you want to edit the database file yourself you could use
SQLite admin
I use the commandline app from SQLite's homepage
A batch file like this will export all data in csv format:
"[PATH TO SQLITE]\sqlite3.exe" -csv -separator ; -header fsd2data.db "select * from Favorites;" >Favorites.csv
"[PATH TO SQLITE]\sqlite3.exe" -csv -separator ; -header fsd2data.db "select * from Assets;" >Assets.csv
"[PATH TO SQLITE]\sqlite3.exe" -csv -separator "|" -header fsd2data.db "select * from ContentItems;" >ContentItems.csv
"[PATH TO SQLITE]\sqlite3.exe" -csv -separator ; -header fsd2data.db "select * from UserRatings;" >UserRatings.csv
"[PATH TO SQLITE]\sqlite3.exe" -csv -separator ; -header fsd2settings.db "select * from Tabs;" >Tabs.csv
"[PATH TO SQLITE]\sqlite3.exe" -csv -separator ; -header fsd2settings.db "select * from GlobalSettings;" >GlobalSettings.csv
"[PATH TO SQLITE]\sqlite3.exe" -csv -separator ; -header fsd2settings.db "select * from UserSettings;" >UserSettings.csv
The names are stored in ContentItems. I used | as separator as I ran into problems when importing to Access.
QUOTE(GoodfellaKeyser @ Mar 24 2011, 03:37 AM)
I'm just coding a new app for fsd2data/settings and xm360 reports.
A bit off-topic, but...
If you'd like to also process the xm360 contents.dat file, I'd happily share the format/c++ code to process it.
-node21
400 games? That is a lot..
looks good Cant wait for it.
Cant wait for it.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.