I was short of time this morning so when I had something working - which was surprisingly quickly, once I'd realised that one of my other foobar components was causing a conflict that caused foobar to crash every time I ran the sql - I just posted it thinking no one would really be interested in going down this route. Well I was not expecting that :-) Most people shy away from it as it's not particularly 'ready to go'. As a bit of a gadget geek this will be a nice little project to investigate so thanks for the pointers. (27-02-2022 12:45)entdgc Wrote: Never used foobar though I have heard of it. I use mp3tag on my PC and noticed it does have an export feature which I was going to investigate to see if I could export track timings to a csv file for Excel and go from there. That is remarkably interesting Never used foobar though I have heard of it. I doubt you want to go to these lengths, but I can't think of another way of doing it. There is another line that creates the PlaylistUpdateable virtual table, but it's causing the post to fail, so I'll leave it out for now just to keep it formatted nicely. Where playlist_index = active_playlist() Set album_duration=(select cast(floor(sum(length_seconds)/60) as varchar) || ':' || cast(printf('%02.0f',floor(sum(length_seconds)%60)) as varchar)Īnd PlaylistUpdatable.album = Playlist.album I've only run this against a small sample of albums so I have no idea how this would scale, but all you'd need to run is: I've used the plugin for various purposes before including to pull data for use in MinimServer tagUpdate scripts, but I hadn't tried updating tags before. The plugin allows you to run SQL against your music collection (it stores all the tags internally during indexing) which is amazingly useful. If you have a Windows PC then there is a way to do it with foobar2000 and the foo_sqlite plugin. I guess it depends how bad you want it -) Anyone know of a meta editor that can do this AUTOMATICALLY - I don't fancy doing this on hundreds of albums manually! I suspect this is beyond MinimServer which leaves option 1. within my metadata editor (normally Metadatics on IOS) or 2. Can anyone think of a way of doing this? As far as I can tell this would require summing all the track timings either 1. It would be perfect if I could somehow add the total album duration in the same way as I do for each track. Album duration possible? - entdgc - 26-02-2022 17:02Īlbum.displayFormat=
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |