Python script to import and export audit tags to an SQLite DB - If you're looking to do an extensive cleanup/standardisation of your tags in order to leverage some of the changes being made in LMS 7.9, or just want to get consistency of artist names across a large collection this script may prove useful to you. Run it from the root folder containing your music files and it'll read all tags other than artwork and write it to a SQLite database. You can then edit the database using sqlitestudio or another SQLite editor. When done the script can write the data held in the database back to the underlying files, giving effect to your changes. You must have puddletag installed to be able to use this script as it leverages the puddletag codebase to read and write tag metadata to the underlying files. File date and timestamps are preserved. I've run it against 3800 files without any issues, however, use at your own risk (you have backups, right...?)
https://github.com/keith-g/audiodb Examples of SQL updates to remove unwanted crud from tags: Code: -------------------- UPDATE audio SET composer = REPLACE( composer, ' / ', '\\' ), albumartist = REPLACE( albumartist, ' / ', '\\' ), comment = NULL, totaltracks = NULL, discid = NULL, tracktotal = NULL, ensemble = NULL, [album artist] = NULL, totaldiscs = NULL, disctotal = NULL, replaygain_track_peak = NULL, replaygain_album_gain = NULL, replaygain_track_gain = NULL, replaygain_album_peak = NULL, isrc = NULL; -------------------- SqueezeWand | 'Vivere DAC MKI' (http://vivereaudio.com/post/2013/08/16/DAC-I-is-Born!.aspx) | 'ATC SCA2' (http://www.atcloudspeakers.co.uk/hi-fi/electronics/source-pre-amplifiers/sca2/) | 'ATC SCM100ASLT' (http://www.atcloudspeakers.co.uk/hi-fi/loudspeakers/tower-series/scm100aslt/) *'Linux finally gets a great audio tagger' (http://www.ubuntugeek.com/linux-finally-gets-a-great-audio-tagger.html): 'puddletag' (http://puddletag.sourceforge.net/)* - now packaged in most Linux distributions. ------------------------------------------------------------------------ audiomuze's Profile: http://forums.slimdevices.com/member.php?userid=33613 View this thread: http://forums.slimdevices.com/showthread.php?t=79733 _______________________________________________ ripping mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/ripping
