ID #1039
I want to mess around with the database backend, e.g. move entries from one field to another in one step.
first and most important of all, make a backup of your Database.pediadata file and keep it somewhere safe. The data becomes easy to delete once you start to mess around with SQL commands. Now run Terminal (you'll find it in Applications/Utilities) and enter the command: sqlite3
Then drag your Database.pediadata file straight into the Terminal window (that saves you the step of having to enter the path yourself). That'll start the SQL command line. Now you can enter the actual command:
update zEntry set zdiscID = zcollectionID where zcollectionID is null;
This command will move all the Disc ID information into the Collection ID field but ONLY where the Collection ID field is empty; i.e. it won't overwrite any information already present. If you'd prefer to overwrite the information you already entered into Collection ID, use this command:
update zEntry set zdiscID = zcollectionID;
(Note that field names are always prefixed by z.)
Take a look at these forum threads for some additional information: http://www.bruji.com/forum/viewtopic.php?p=7035
http://www.bruji.com/forum/viewtopic.php?t=1878
You'll also find directions in those threads about what to do if you don't have the latest version of sqlite (3.4.0).
Tags: -
Related entries:
- Is there a dedicated function for marking books that I have borrowed from someone, as opposed to someone borrowing from me?
- Is there a box-set feature in DVDpedia?
- The iPod export doesn't include all the entries from a user's database. (iPod Classic, not Touch. If you have a Touch or an iPhone, use Pocketpedia.)
- Can iTunes import into CDpedia be automated, i.e. do it every week or month for all the new entries from iTunes.
- Can I sort my DVDs by the date I purchased them?
You cannot comment on this entry