@moonbase, Thank you for creating that code for mp3tag!
2 Duets - 1 for upstairs and 1 for downstairs
Rock Solid with LMS 7.8.0 and WHS 2011
w3wilkes's Profile: http://forums.slimdevices.com/member.php?userid=22973
View
After so many years, it's great to see that my very old code (for
MP3Tag) is still being used and still works!
Sorry for waking the old thread, but I ran across this thread and just
had to say thanks for checking it out and using it :-)
Moonbase: 'The Problem Solver'
Interesting... I went out to the MP3Tag forum to see about rounding the
TBPM to the nearest integer and believe it or not this is the most
recent topic!
http://forums.mp3tag.de/index.php?showtopic=17760
In that thread there's a link to a older thread that has action code
from Moonbase that seems
I tested MoonBase action in MP3Tag against a couple of albums and then
did a clear and full rescan. With the BPM in the tags now being full
integers with no decimal places it populates in the SQ database just
fine! So now it's time to go to work on the SQL playlist that will
filter on Genre and
This should be my last entry on this... Using the SQL Playlist plugin I
created a Advanced Playlist with Genre=Rock and Year =1990 and Year
=1970 to get a template. Then I edited the SQL to change the year
criteria to bpm values...
-- PlaylistName:TestBPM
-- PlaylistGroups:
select tracks.url
And one last thing...
Thanks to all those who replied, especially;
JJZolx for the SQLite Expert info for DB browsing and providing the info
on what the BPM column had to contain.
and
Erland for the great SQL and Dynamic Playlist plugins that give me the
power to put my idea together.
2 Duets
w3wilkes,
You expressed interest in how I use sqlite together with batch files to
extract the tables (which I then import into Access). You might no
longer be interested after JJZolx's recommendation [thanks from me too,
JJZolx] but, as it would be a bit too long winded to post here so I have
JohnB,
Thanks. I did grab your zip file just to look through it, I may find
pieces useful. And you're correct that with the JJZolx reply I no longer
needed it. Thanks again.
Wilkes
2 Duets - 1 for upstairs and 1 for downstairs
Rock Solid with LMS 7.7.3 and WHS 2011
I took a look at some of the code and it appears that TBPM is
recognized. What kind of values do you have in these tags? I came across
a check in the code that makes sure the value is numeric. I believe the
following requires that the value be a plain non-zero integer.
So something like 120.0 or
Yes, I do have TBPM populated using MixMeister BPM Analyzer.
http://www.mixmeister.com/download-bpmanalyzer.php
It does do numbers (like 133.56). Looks like all TBPM values are taken
to 2 decimal points and there's no ability to tell it to round to the
nearest whole number.
2 Duets - 1 for
I was looking for a GUI SQLite browser to view the library.db file. I
tried SQLiteman and it says the file isn't a recognized database. I also
tried SQLite Browser and it just presents a blank view. Anybody know of
a GUI tool to browse the library.db table?
2 Duets - 1 for upstairs and 1 for
Thanks! I would be interested in your batch file. I'll also give the
Firefox thing a shot, I'll have to get Firefox installed too. I do have
Access and Excel so I can import to either. On the Clear and rescan, I
seem to always do this when I add music or do tagging work. On my
~20,000 track
Firstly I suggest that you copy the library.db to a different folder and
then use the copy of library.db instead of the file in use by LMS (it
avoids the risk of inadvertently changing the database)
I don't use GUI but use a batch file to extract the tables which I then
import into Access (or
Many years ago -- during the slimserver 6.x days, before Squeezebox's
temporary detour into MySQL land -- I used SQLite Database Browser
(http://sourceforge.net/projects/sqlitebrowser/) successfully to examine
the database. It was very easy to use.
@aubuti, I did try that and even though it doesn't give a error when I
attempt to open library.db it shows nothing in the database structure
tab and the browse data tab shows 0 records. library.db that it's a
little over 26MB.
2 Duets - 1 for upstairs and 1 for downstairs
Rock Solid with LMS
I've been using 'SQLite Expert' (http://www.sqliteexpert.com/) for a
couple of years with good results. The Personal Edition is free.
JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10
View this thread:
@JJZolx, THANKS! Exactly what I was looking for! This works perfectly.
Now the big question in the Tracks table is... Since it has a BPM
column, why isn't it populated if it exists in the TBPM tag of MP3
files? I was thinking this would be a very useful filter if you were
building a SQL/Dynamic
17 matches
Mail list logo