Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[locust]

HOWTO: Generate album ratings using variables (+ track count)

After using this wonderful code, I opted to using it to create my album rating panes, the only problem was that I would have to invoke the var_rating smartlist before the panes would populate. So I popped the following code into a user field and created another rating field, so that I could periodically copy the auto generated album ratings over to the one that stores permanently and which is now the field that my panes are based upon..

if(compare(load(v_albumratingsum[album artist (auto)][album]),>,0),formatnumber(math( load(v_albumratingsum[album artist (auto)][album]) / load(v_tracks[album artist (auto)][album]) ),2),0)

I was looking at the scheduler, and saw that you can use the command line, can I use the core command MCC_MOVE_COPY_FIELDS to copy the auto generated field to the permanent one? The command has no parameters on the wiki and I am a little apprehensive of blindly trying it in case I screw something up..

Thanks

[MrC]

I believe that MCC will work on the selection, so it is not what you want.

You don't need to use a smartlist to have the ratings updated.  You can enter part 1 of the 2 expressions into the Set rules for file display section of the view.  This will force the variables to be updated as soon as the view is invoked.

[locust]

Never knew that, thanks..
Do you mean this part?

[Media Type]=[Audio] [=save(0,v_tracks[album artist (auto)][album])1]=1 [=save(math(1+load(v_tracks[album artist (auto)][album])),v_tracks[album artist (auto)][album])1]=1 [=save(0,v_albumratingsum[album artist (auto)][album])1]=1 [=if(compare([rating],=,0),save(-1,v_albumratingsum[album artist (auto)][album]),)1]=1 [=if(compare(load(v_albumratingsum[album artist (auto)][album]),>,-1),save(math([rating]+load(v_albumratingsum[album artist (auto)][album])),v_albumratingsum[album artist (auto)][album]),)1]=1 ~sort=[Album Artist (auto)],[Album],[Track #],[Media Type],[Disc #],[Name]

[MrC]

Right.  That is just a humongous expression, expressed in the form of a query.  Paste it into a view's Import/Export button under Set rules for file display.