VoxCommando
Help and Support (Using VoxCommando) => MediaMonkey => Topic started by: pomozki on April 01, 2012, 03:18:33 PM
-
Hi folks, I'm new to this and MM - I'd love some advice about doing searches in MM. sorry, haven't any files to attach but I'll explain...
I'm using MM Gold.
I'm doing Ctrl-F (Search) ... then going to the advanced tab
It then asks you to add search criteria.
I can do easy searches (e.g. show me only genre = ROCK and date = 1975 ... and I get heaps of songs showing up
but how do I ask for music from, say, 1975 that's either ROCK or POP?
It's the genre filter I'm having trouble with and it's really important to me: I've tried genre "equals" - but as soon as you do that, it only allows you to pick from a dropdown list of genres you already have in your library - so for me it allows songs whose genre is rock...or whose genre is pop ... or whose songs are rock AND pop
but so far I haven't worked out how to filter songs whose genre is either rock or pop or something else
I've tried
genre contains rock or pop
and
genre contains "rock" or "pop"
and
genre contains 'rock' or 'pop'
but none of them works
hope someone can put me right, many thanks Alan
-
Hi folks, I'm new to this and MM - I'd love some advice about doing searches in MM. sorry, haven't any files to attach but I'll explain...
I'm using MM Gold.
I'm doing Ctrl-F (Search) ... then going to the advanced tab
It then asks you to add search criteria.
I can do easy searches (e.g. show me only genre = ROCK and date = 1975 ... and I get heaps of songs showing up
but how do I ask for music from, say, 1975 that's either ROCK or POP?
It's the genre filter I'm having trouble with and it's really important to me: I've tried genre "equals" - but as soon as you do that, it only allows you to pick from a dropdown list of genres you already have in your library - so for me it allows songs whose genre is rock...or whose genre is pop ... or whose songs are rock AND pop
but so far I haven't worked out how to filter songs whose genre is either rock or pop or something else
I've tried
genre contains rock or pop
and
genre contains "rock" or "pop"
and
genre contains 'rock' or 'pop'
but none of them works
hope someone can put me right, many thanks Alan
Hi Alan, welcome in VoxCommando-Forum. I'm not sure If I understand you right, you will do a search in MM for "genre" from "year"?
like - "play rock from year 1990"
Important for us is: What version of VoxCommando do you use?
Kalle
-
Hi Alan,
please don't take this the wrong way, but... what does this have to do with VoxCommando?
-
also, I'm not sure but it might help to know if you are using MM3 or MM4
-
anyway on MM4 this is how you do it. I don't have MM3 installed any more but hopefully it works about the same.
You just have to put checkboxes in all the genres that are acceptable and it will "or" them since it usually doesn't make much sense to "and" genres.
-
Hi Alan,
please don't take this the wrong way, but... what does this have to do with VoxCommando?
Hi James, I think it has nothing to do with VC ::club
But it is a nice question, how can do it "play genre from year" with VC? ::hmm (MM4)
Kalle
-
actually I don't even know how to search by year in MediaMonkey because there seems to be confusion between Date and Year. Most of my songs have only a year as the date but some have a bull date with date, month and year. Mediamonkey stores this as a long number. If the date is set to 2000 then the database will store it as 20000000. If the date is set to February 13th 1996 is it is stored as the number 19960213.
If they used a string it would be easier since we could use LIKE in our SQL:
Year like '1996%'
would work fine.
as it is though, because it is a number, we need to be trickier and use this:
Year>=19960000 and Year<19969999
(note that we use >= so we will get all the songs marked as 1996 with no full date, because they are stored as 19960000
Now to use payloads you can change this to
Year>={1}0000 and Year<{1}9999
or in the case of your example Kallle using genre as the first payload:
genre like '%{1}%' and Year>={2}0000 and Year<{2}9999
and that works, but if you ask for genre "rock" you will also get "folk rock" etc... getting the exact genre is another difficulty which has already been discussed I think.
-
actually I don't even know how to search by year in MediaMonkey because there seems to be confusion between Date and Year. Most of my songs have only a year as the date but some have a bull date with date, month and year. Mediamonkey stores this as a long number. If they date is set to 2000 then the database will store it as 20000000. If the date February 13th 1996 is it is stored as the number 19960213.
If they used a string it would be easier since we could use like. Year like '1996%' would work.
as it is we need to be trickier and use this:
Year>=19960000 and Year<19969999
(note that we use >= so we will get all the songs marked as 1996 with no full date.
now to use payloads you can change this to
Year>={1}0000 and Year<{1}9999
or in the case of your example Kallle using genre as the first payload:
genre like '%{1}%' and Year>={2}0000 and Year<{2}9999
and that works, but if you ask for genre "rock" you will also get "folk rock" etc... getting the exact genre is another difficulty which has already been discussed I think.
Wow, your are real one and only "Voxinator" ::bow
I will test a bit with this command ;)
Big THANKS
Kalle
-
Here's the killer SQL for 1996 songs that are either 'acapella' or 'acid jazz'
(Songs.Year>=19960000 and Songs.Year<=19969999) AND
Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (21,65)))
:biglaugh
but you need to know the id for the genres you want. :P
-
Here's the killer SQL for 1996 songs that are either 'acapella' or 'acid jazz'
(Songs.Year>=19960000 and Songs.Year<=19969999) AND
Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.IDGenre in (21,65)))
:biglaugh
but you need to know the id for the genres you want. :P
??? Haha, I think I'm too tired to understand something about that ;)
-
I don't blame you. I finally figured out how to do it with Genre Names instead of ID, but you have to get the capitalization (of the genre name) correct:
[edit: actually it seems like the capitalization doesn't matter :)]
this will play anything from either Rock and Jazz genres.
Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.genrename in ("Rock","Jazz") )) Order by random()
and now my brain is melting...
-
I don't blame you. I finally figured out how to do it with Genre Names instead of ID, but you have to get the capitalization (of the genre name) correct:
[edit: actually it seems like the capitalization doesn't matter :)]
this will play anything from either Rock and Jazz genres.
Songs.ID IN (SELECT IDSong FROM GenresSongs WHERE GenresSongs.IDGenre IN ( SELECT Genres.IDGenre FROM Genres WHERE Genres.genrename in ("Rock","Jazz") )) Order by random()
and now my brain is melting...
Haha, oh no, I still need your brain :biglaugh
Kalle
-
Walking Dead, Kalle... :biglaugh :biglaugh :biglaugh
-
oh I'm so sorry - I ended up in the wrong forum!! My question has nothing to do with VC - in fact, I don't even know what it is :bonk
I just googled MediaMonkey or iTunes forums - and yours appeared so I joined and posted my question
thanks to everyone for their replies ... in particular thanks to James for solving my puzzle with this reply
anyway on MM4 this is how you do it. I don't have MM3 installed any more but hopefully it works about the same.
You just have to put checkboxes in all the genres that are acceptable and it will "or" them since it usually doesn't make much sense to "and" genres.
now I should go off and see what your program is all about ;D
-
:biglaugh
No problem. $©√t happens
-
Wow, your are real one and only "Voxinator" ::bow
I will test a bit with this command ;)
Big THANKS
Kalle
James, the command works perfect - MM.LoadBySQL - genre like '%{1}%' and Year>={2}0000 and Year<{2}9999
I will figured out how can I say - for example: "play all songs from genre at the 80's" and it shows a playlist with songs from genre rock from 1980 to 1989 ( I know I can edit the ID-tag for each song with a custom entry), but maybe there's an easier way ;)
Kalle
OK- I have found a way to do this, see attached pics. It would be more comfortable if I could say "play some roch from the 80's" and the value is a range between 80 and 89, but I have found no way to do that.
-
You can just put all the year stuff into the value field of your payloadXML like this:
(I'm attaching the group, the payload file, and a couple of images)
-
You can just put all the year stuff into the value field of your payloadXML like this:
(I'm attaching the group, the payload file, and a couple of images)
Haha, cool! Why did not I find it out :bonk
Thanks again
-
I'll bet pomoski would never get this level of support on any of the forums he was trying to reach. Good job, James, Kalle. ;D
-
I'll bet pomoski would never get this level of support on any of the forums he was trying to reach. Good job, James, Kalle. ;D
Thanks mclough6, I think he found no other forum that give a solution within two hour. ;D
-
not to mention support for someone else's product. and then going on to answer other hypothetical questions that he never asked, but might have asked if he used VoxCommando... :biglaugh :biglaugh
It almost seems like we have nothing better to do ::hmm
-
It almost seems like we have nothing better to do ::hmm
Haha, don't say it to Karola, she kill me ::club
-
"what happens on the forum, stays on the forum". You secret is safe with me, as long as she doesn't browse the site.
-
You can just put all the year stuff into the value field of your payloadXML like this:
(I'm attaching the group, the payload file, and a couple of images)
I think you can merge this command in the next release of VC. It works perfect and is a new feature to search for songs ::bow
Kalle