Page 4 of 4

Re: Database format changed

Posted: Mon Nov 09, 2009 2:24 pm
by Owyn
Yep. The SQL Viewer is an invaluable tool.

I use it almost daily and at times extensively. Just about every SELECT I have written for a script has been unit-tested in the viewer. And, a lot of scripts are not required because I just need to see the llibrary data in a way that MM can't show me via the UI.

PS: Remember, you can't break anything with a SELECT, it just reads the data. UPDATE and DELETE however are for experienced use only, and preferably with a recent backup. :)

Re: Database format changed

Posted: Mon Nov 09, 2009 2:28 pm
by Bex
Thanks, Owyn!

An update of that script is actually in the workshop right now. We'll see when it gets released.

Re: Database format changed

Posted: Tue Nov 10, 2009 7:13 am
by Owyn
FYI: I just now had a need to do some Genre cleanups myself.

I used Bex's Tagging Inconsistencies script to find low usage genres.

Navigate to Library->Files to Edit
Expand Tagging Inconsistencies node
Expand Genres node
Expand Few Tracks node

Bob's your uncle.
Now you have a review list and can edit track data/genres completely within MM.

Sort of off topic, but, it is best to look for a native or integrated (e.g. the Tagging Inconsistencies script) solution to an update problem.

If the list is a bit long, I just pick an arbritary point to stop cleaning up for a while and go back to the "node" later.