New Search/Autoplaylist Selection Script

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:
BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON
Topic review
   

Expand view Topic review: New Search/Autoplaylist Selection Script

Re: New Search/Autoplaylist Selection Script

by MoDementia » Tue Sep 09, 2008 8:20 pm

Bugger, all of the fields and tables are hard coded so its back to the original script suggestion

So the scirpt request now becomes:

I need:
The total played per album artist stored in .... field for use with autoplaylists
The maximum played per album artist stored in ... field for use with autoplaylists
etc

Re: New Search/Autoplaylist Selection Script

by MoDementia » Tue Sep 09, 2008 7:13 pm

MoDementia wrote:Hold the fort, I just saw something interesting :P

Will take a little while to test my theory out :wink:
Not yet it isn't :P

Re: New Search/Autoplaylist Selection Script

by nynaevelan » Tue Sep 09, 2008 7:12 pm

Ok, I am starting to believe this is a dead issue. I don't think it is going to be possible. Thanks for trying though.

Nyn

Re: New Search/Autoplaylist Selection Script

by MoDementia » Tue Sep 09, 2008 7:07 pm

Yes it does, but the language for autoplaylists is very structered, it needs actual fields

The same would apply to the script request examples,

I need:
The node names stored in .... field for use with autoplaylists

Re: New Search/Autoplaylist Selection Script

by MoDementia » Tue Sep 09, 2008 7:04 pm

Hold the fort, I just saw something interesting :P

Will take a little while to test my theory out :wink:

Re: New Search/Autoplaylist Selection Script

by nynaevelan » Tue Sep 09, 2008 7:02 pm

No, what I mean is, not to try to convert the nodes themselves but somehow use the name of the nodes as the criteria for the autoplaylist. So the autoplaylist will be selecting all the tracks which are in the nodes. Does that make sense?

Nyn

Re: New Search/Autoplaylist Selection Script

by MoDementia » Tue Sep 09, 2008 6:56 pm

No, the nodes you have supplied are impossible to convert as autoplaylists have no ability to Group By and or Sum

Others like the 80's node can be but it's just as easy to create them manually

There may be some others that don't use group by/sum that might be able to convert too but until I see examples I can't say for sure

Re: New Search/Autoplaylist Selection Script

by nynaevelan » Tue Sep 09, 2008 6:53 pm

You never answered my question from the other day, can we take a diffent route to the same solution?
nynaevelan wrote:Question, instead of having to convert the sql statements of the nodes, is it possible to be able to create autoplaylists based on the nodes themselves? In other words, the criteria would be node = X? That way there would be no need for conversion, but it would need to be able to select both native MM nodes and/or script created nodes. Is this possible, easier?
Nyn

Re: New Search/Autoplaylist Selection Script

by MoDementia » Tue Sep 09, 2008 6:43 pm

[The 80's]
Is possible with an auto playlist
Date has the requested between etc criteria

[Most Played Artists (10)]
[Track Counts/Minutes by Top Artists]
[Weekly Top Artists]

These all require a nested style playlist which isn't available in any playlist criteria currently
So there is no conversion criteria to compare to.

The only way to achieve it is to have a script maintain the play/track counts/track length in custom field(s) per Album Artist
i.e. There is no Group By or Sum equivelent in the current autoplaylists (I've added them to your wishlist post) so these need to be calculated and saved to a field that is available from the autoplaylist fields.

So the scirpt request now becomes:

I need:
The total played per album artist stored in .... field for use with autoplaylists
The maximum played per album artist stored in ... field for use with autoplaylists
etc

Re: New Search/Autoplaylist Selection Script

by nynaevelan » Mon Sep 08, 2008 4:16 pm

MoDementia wrote:
Sure, take Bex's advice and ignore mine :P
MoDementia wrote:Many of the fields in search/autoplaylists need tweaking as you highligt in your examples; This is a wishlist request for the developers.
Now, now... :wink: I do not ignore anyone's suggestions but I was saving the wishlist as a last resort. Besides if two scripters say it's not possible, I have to believe them. :( And who knows how long it will be if my request is granted, so I have to keep trying.

Nyn

Re: New Search/Autoplaylist Selection Script

by MoDementia » Mon Sep 08, 2008 4:09 pm

Bex wrote:I'm not sure but I don't think the dev's will let scripters access the Auto-Playlist code since it's a Gold feature.
Oops, no wonder it's cloaked in magic :P

Sure, take Bex's advice and ignore mine :P
MoDementia wrote:Many of the fields in search/autoplaylists need tweaking as you highligt in your examples; This is a wishlist request for the developers.

Re: New Search/Autoplaylist Selection Script

by nynaevelan » Mon Sep 08, 2008 2:54 pm

I added my reuqest here.

Nyn

Re: New Search/Autoplaylist Selection Script

by Bex » Mon Sep 08, 2008 2:32 pm

I'm not sure but I don't think the dev's will let scripters access the Auto-Playlist code since it's a Gold feature.
The best thing to do would be to point out for the dev's exactly what search features are missing so they become aware of it and can implement them.

I'm pretty sure such request will be implemented. After all, the math is simple here. Nicely implemented gold features makes more people to upgrade which generates more income.

Start a new thread in the wish-list forum and we can all help out to make the request to be really good! :D

Re: New Search/Autoplaylist Selection Script

by nynaevelan » Mon Sep 08, 2008 10:31 am

MoDementia wrote:
nynaevelan wrote: why can it not be used to make autoplaylists?
That was the point of my post

It maybe possible to take the information you usually enter for a custom node and convert it into an autoplaylist, or more precisely add it to an existing autoplaylist that won't allow it normally

The problem is that autoplaylists are not in plain english (SQL) and there is no conversion table available so it is quite a bit of trial and error (field by field) to convert the node sql to something an autoplaylist can use.
Because there is no conversion table, to make the trial and error process possible/meaningful requires real examples of working SQL so that we can concentrate on the fields and operators used first.

The script could only be released with limited functionallity as each conversion formula is found
i.e.
classification: "is not"
SQL = Songs.Classification NOT LIKE '%...%'
AutoPlaylist = [AdvCond1] DBField=Songs.Classification DBFieldPerType=1 Condition=301 Value=3324

Hopefully after a few examples a pattern may emerge which will make the conversion process applicable to any field.
Initially it will need to be concentrated on specific requirements until such a pattern is discovered.

So from the list of nodes you posted which are the top 2-3 (that can't be created as an autoplaylist) you would like attempted to be converted first?
Hey:

Question, instead of having to convert the sql statements of the nodes, is it possible to be able to create autoplaylists based on the nodes themselves? In other words, the criteria would be node = X? That way there would be no need for conversion, but it would need to be able to select both native MM nodes and/or script created nodes. Is this possible, easier?

Nyn

Re: New Search/Autoplaylist Selection Script

by nynaevelan » Mon Sep 08, 2008 8:33 am

I do not know all the differences between the two but the main one for me is, a node cannot be synced to my portable device as a playlist, which is the ultimate goal of all my "playing" playlists. If this script cannot go directly to a playlist, it kind of defeats the purpose, since I am familiar with a different node creation script. But I am willing to give this one a test run.

nyn

Top