I have a library of approximately 68,000 tracks. A large number have various and sundry tags missing but the data is a part of the filename.
Is there a way to access / edit the database using MS Access, or SQL?
For example I have the following that I could parse and then update the tags.
"F:\Music\Joan Jett Full Discography with Lives\1983 - Album\01 - Joan Jett And The Blackhearts - Fake Friends.mp3"
Thanks!
Edit tags via SQL
Moderator: Gurus
Re: Edit tags via SQL
You can use Tools > Auto-Tag from Filename to get tag info from filename: https://www.mediamonkey.com/wiki/index. ... lename/4.0 and I assume RegExp can also help with this: https://www.mediamonkey.com/forum/viewt ... lit=regexp
The database is SQLite and there are topics on using this.
The database is SQLite and there are topics on using this.
Download MediaMonkey | License
Help: Knowledge Base | MediaMonkey for Windows 5 | MediaMonkey for Android
Lowlander (MediaMonkey user since 2003)
Help: Knowledge Base | MediaMonkey for Windows 5 | MediaMonkey for Android
Lowlander (MediaMonkey user since 2003)
-
- Posts: 9
- Joined: Fri Aug 28, 2009 1:42 pm
Re: Edit tags via SQL
ok if I screw up royally can I just restore a copy of the mm.db file?
Re: Edit tags via SQL
Depends, if you're just modifying tags they will be saved to the files too (default setting), but you could re-save (current values) with backup copy of database.
Note that Auto-Tag from Filename will show the changes it will make before applying them.
Note that Auto-Tag from Filename will show the changes it will make before applying them.
Download MediaMonkey | License
Help: Knowledge Base | MediaMonkey for Windows 5 | MediaMonkey for Android
Lowlander (MediaMonkey user since 2003)
Help: Knowledge Base | MediaMonkey for Windows 5 | MediaMonkey for Android
Lowlander (MediaMonkey user since 2003)