xbox-scene.com - your xbox news information source
Quick Links: Main Forums | Xbox360 Forums | Xbox1 Forums | PS3 Forums
Xbox-Scene Forum Help  Search Xbox-Scene Forums   Xbox-Scene Forum Members   Xbox-Scene Calendar

Giganews Usenet Offers: +1150 days binary retention, 99%+ Completion, and Unlimited Speed/Access!

360 ODD Emulators: X360 Key $99 | Wasabi360 FAT $99 | Wasabi360 Slim $99
C4E's iXtreme Burner MAX Drive: LiteOn iHAS124 DROPPED TO JUST $17


Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Database File?
FrostyWolf
post Mar 23 2011, 03:06 PM
Post #1


X-S Young Member
*

Group: Members
Posts: 45
Joined: 26-March 10
Member No.: 435399
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.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
node21
post Mar 23 2011, 09:54 PM
Post #2


X-S X-perience
**

Group: Dev/Contributor
Posts: 470
Joined: 26-November 06
Member No.: 313949
Xbox Version: unk
360 version: unknown
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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
GoodfellaKeyser
post Mar 24 2011, 09:37 AM
Post #3


X-S Enthusiast


Group: Members
Posts: 9
Joined: 2-January 11
Member No.: 448872
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.
IPB Image

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.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
node21
post Mar 24 2011, 01:30 PM
Post #4


X-S X-perience
**

Group: Dev/Contributor
Posts: 470
Joined: 26-November 06
Member No.: 313949
Xbox Version: unk
360 version: unknown
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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
justin_ruch1180
post Apr 7 2011, 07:14 AM
Post #5


X-S Enthusiast


Group: Members
Posts: 1
Joined: 7-April 11
Member No.: 452292
400 games? That is a lot..smile.gif
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
DrWize
post Apr 9 2011, 01:48 AM
Post #6


X-S Enthusiast


Group: Members
Posts: 12
Joined: 2-July 04
From: Europe - Sweden - Kalmar
Member No.: 128480
Xbox Version: v1.1
looks good smile.gif Cant wait for it. smile.gif
User is offlineProfile CardPM
Go to the top of the page
+Quote Post




 

Reply to this topicStart new topic

 

Lo-Fi Version Time is now: 24th May 2013 - 01:05 AM
Invision Power Board v2.1.7 © 2013  IPS, Inc.
Licensed to: Scenyx