Page 1 of 3
Magic Node tempo script
Posted: Thu Sep 08, 2005 4:30 am
by trixmoto
I am looking for a magic node which categorises tracks based on their BPM. I which to group them into four speed groups. Does anyone know how to do this with Magic Node?
Posted: Thu Sep 08, 2005 4:31 am
by trixmoto
Apparenly it might only be possible with four seperate nodes, one for each tempo. Still, I don't know SQL. Can someone please suggest what queries would do this?
Solution
Posted: Thu Sep 08, 2005 5:37 am
by trixmoto
Actually, normal filters work!
Unknown|filter:bpm<1\<artist>
Largo|filter:bpm<56 and bpm>0\<artist>
Andante|filter:bpm<84 and bpm>55\<artist>
Allegro|filter:bpm<145 and bpm>83\<artist>
Presto|filter:bpm>144\<artist>
Posted: Thu Sep 08, 2005 9:26 am
by agapeincognito
Just for good measure, the SQL equivalent would be:
Unknown|SQL filter:Songs.BPM < 1\<artist>
Largo|SQL filter:Songs.BPM BETWEEN 0 AND 56\<artist>
Andante|SQL filter:Songs.BPM BETWEEN 55 AND 84\<artist>
Allegro|SQL filter:Songs.BPM BETWEEN 83 AND 145\<artist>
Presto|SQL filter:Songs.BPM > 144\<artist>
Interestingly enough, using AND here doesn't work (although it should):
Largo|SQL filter:Songs.BPM > 0 AND Songs.BMP < 56\<artist>
will yield errors. I have no idea why. Normally works fine in SQL and Access.
Posted: Fri Sep 16, 2005 2:07 am
by Philby
The MN code above does not work at all. No errors, and no filtering.
Code: Select all
Largo|SQL filter:Songs.BPM > 0 AND Songs.BMP < 56\<artist>
will yield errors. I have no idea why. Normally works fine in SQL and Access.
also does not work, and on my system gives no error !
Posted: Fri Sep 16, 2005 2:54 am
by trixmoto
Then I would imagine you don't have the BPM tags flled in!
Posted: Fri Sep 16, 2005 3:04 am
by Philby
I have my BPM tag field displayed as one of my list columns.
It is in view all the time. Approx 80% of my tracks have BPM values. The column sort works file. Any other ideas ?
Posted: Fri Sep 16, 2005 3:08 am
by trixmoto
Are you using normal filters or SQL filters?
What are the ranges of your songs BPM values?
Posted: Fri Sep 16, 2005 10:09 am
by agapeincognito
Very odd, indeed! I have installed on a few different computers to test (all Win XP), and can't get it to NOT work. Consistently works for me...
Posted: Sat Sep 17, 2005 6:02 am
by Philby
My BPM values range from 60 to 180, with a few not defined at all.
I have tried both normal AND SQL filters - both give exactly the same result - ALL tracks are selected.
Posted: Sat Sep 17, 2005 10:16 am
by trixmoto
Philby wrote:ALL tracks are selected.
You don't select the tracks. You just go to the Magic Nodes, click on the +, then you get the different headings (Unknown, Largo ...) and click on the +. This should list all the songs. No tracks need to be selected at any time.
Have you got any other Magic Nodes?
Posted: Sat Sep 17, 2005 7:25 pm
by Philby
"All tracks are selected" means that when I click on my "Tempo" Magic Node, ALL my tracks are shown in the resulting list. In other words, the Magic Node has determined (incorrectly) that ALL my tracks meet the filter criteria - ie it selects them all !
I have some other Magic Nodes which work fine.
Posted: Sun Sep 18, 2005 11:06 am
by trixmoto
Well the only thing I can think is that your BPM values not set right. However, if you're certain they are, then I have absolutely no idea. Really sorry I can't help!
Posted: Sun Sep 18, 2005 6:54 pm
by Philby
To set each BPM, I open up the Properties of the track, go to the Tab page that has the BPM tag field, and enter 120 (for example). Then "OK". It couldn't be more straightforward than that.
Posted: Mon Sep 19, 2005 3:12 am
by trixmoto
What type of files are you using, and what type of tags?
FYI: MixMeister do a very good FREE piece of software that automatically tags your mp3s with BPM values (possibly other filetypes as well, I'm not sure)