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.
Database format changed
Moderators: Gurus, Addon Administrators
Re: Database format changed
Cogito cogito ergo cogito sum. (Ambrose Bierce)
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies
Re: Database format changed
Thanks, Owyn!
An update of that script is actually in the workshop right now. We'll see when it gets released.
An update of that script is actually in the workshop right now. We'll see when it gets released.
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!
All My Scripts
Re: Database format changed
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.
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.
Cogito cogito ergo cogito sum. (Ambrose Bierce)
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies