Keyser 45 Posted March 31, 2013 This little app is intended for all those who use a SOURCE F3 install which they copy to other Xbox360's and for those swapping HDD's content from one HDD to another. Apparently each HDD/USB has it's own DeviceId. Under content.db you'll find all MountedDevicesIDs. The ScanPaths table (settings.db) uses these IDs. The ContentItems table (content.db) uses just the ScanPathsID. By copying the databases from the SOURCE F3 install you'll lose your ScanPaths as the DeviceIDs don't match. This is where this app comes into play.How-To First copy your SOURCE F3 database to your new Xbox (called DESTINATION F3). Start your DESTINATION F3. This will update your content.db with your new DeviceIDs.Open this app. Under 1) select your SOURCE F3 database and click IMPORT. You'll see all scanpaths available in that database. For the moment there is no distinction between DeviceIDs (all available Paths will be imported!). Therefore, I recommend using a SOURCE F3 database with just one DeviceId (as shown in the picture)! These scanpaths will always be present when you start the app. So in case you need always the same paths you'll just have to do 1) once.Under 2) select your DESTINATION F3. Automatically it will fill DeviceID of Hdd1. If you need another DeviceID select between Hdd1, HddX or Usb0. The DeviceId will change accordingly. You can also input another DeviceId. Hit on update and all ScanPaths of your SOURCE F3 will be inserted into your DESTINATION F3 with the new DeviceIds. Behind the scenes - SQLs 1) SOURCE F3 databaseDoes just SELECT * from ScanPaths and outputs it into scanpaths.ini2) DESTINATION F3 databaseSELECT MountedDeviceDeviceId from MountedDevices WHERE MountedDeviceMountPoint='" & ComboBox1.value and outputs it into DeviceId.iniDELETE from ScanPaths.import insertpaths.ini ScanPathsUPDATE ScanPaths SET ScanPathDeviceId='" & txtDeviceID.value Credits Keyser (DEV)Bill Stewart (TDC)Edy (idea)SQLite (sqlite.exe)TeamFSD Source files It's a simple HTA file. The contents of the executable will be extracted and placed somewhere under %appdata% I guess. If you need to change the code/scanpaths.ini file etc. search for SetPaths.hta. Additional Info This picture shows the relations between all tables related to scan paths: SetPaths.zip 2 Quote Share this post Link to post Share on other sites
JPizzle 0 Posted April 1, 2013 nice work as always keyser Quote Share this post Link to post Share on other sites
robins 5 Posted April 2, 2013 very useful app, thanks keyser! 1 Quote Share this post Link to post Share on other sites
moses_373 151 Posted July 22, 2013 I came across this by accident, excellent app, should be very handy for me! Quote Share this post Link to post Share on other sites
navid 0 Posted September 4, 2015 plz help when i want to open setting.db with this app, it give me an error: setting.db not found under "folder path" ??? Quote Share this post Link to post Share on other sites