Magic Node tempo script

trixmoto · Post by **trixmoto** » Thu Sep 08, 2005 4:30 am

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?

trixmoto · Post by **trixmoto** » Thu Sep 08, 2005 4:31 am

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?

trixmoto · Post by **trixmoto** » Thu Sep 08, 2005 5:37 am

agapeincognito · Post by **agapeincognito** » Thu Sep 08, 2005 9:26 am

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.

Philby · Post by **Philby** » Fri Sep 16, 2005 2:07 am

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 !

trixmoto · Post by **trixmoto** » Fri Sep 16, 2005 2:54 am

Then I would imagine you don't have the BPM tags flled in!

Philby · Post by **Philby** » Fri Sep 16, 2005 3:04 am

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 ?

trixmoto · Post by **trixmoto** » Fri Sep 16, 2005 3:08 am

Are you using normal filters or SQL filters?
What are the ranges of your songs BPM values?

agapeincognito · Post by **agapeincognito** » Fri Sep 16, 2005 10:09 am

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...

Philby · Post by **Philby** » Sat Sep 17, 2005 6:02 am

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.

trixmoto · Post by **trixmoto** » Sat Sep 17, 2005 10:16 am

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?

Philby · Post by **Philby** » Sat Sep 17, 2005 7:25 pm

"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.

trixmoto · Post by **trixmoto** » Sun Sep 18, 2005 11:06 am

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!

Philby · Post by **Philby** » Sun Sep 18, 2005 6:54 pm

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.

trixmoto · Post by **trixmoto** » Mon Sep 19, 2005 3:12 am

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)

Magic Node tempo script

Magic Node tempo script

Solution