INTERACT FORUM

More => Old Versions => JRiver Media Center 19 for Windows => Topic started by: muzicman0 on November 10, 2013, 05:18:05 pm

Title: Help with an expression
Post by: muzicman0 on November 10, 2013, 05:18:05 pm: I have this close, but not perfect...I need help with an expression that will do the following:

(note: I have a custom library field that will be a value of 1 if the program is over 90% watched...it is 'Watched')

If Watched is 1 and Number plays is >0 then Output 1 (Video is watched)
If Number Plays is 0 (or empty) and Watched is 0 then Output 2 (Unwatched)
If Watched is 1 and Number Plays 'isempty' then Output 1 (Video is Watched - special case...this happens when I convert format)
If Watched is 0 and Number Plays is > 0 then Output 3 (Video is started, but not finished)

This will be going in the 'Video' Name expression field so that I can control how the Recent Shows field looks (bold white for new, different color for started, and grey for watched, plus some special symbols)

If anyone can help, I would appreciate it...here is what I have so far, but this only works on the 1st, 2nd, and 4th scenario.

if(!isempty([Number Plays]), if([watched], √ [Series] [SeasonEpisode]-[Name], ! [Series] [SeasonEpisode]-[Name] <//font>), >[Series] [SeasonEpisode] - [Name])
Title: Re: Help with an expression
Post by: RJC on November 11, 2013, 06:45:13 am: It's a tricky one but this might help:

IfElse(
Math(Compare([Watched], =, 1) & Compare([Number Plays], >, 0)), Watched,
Math(Compare([Watched], =, 0) & Compare([Number Plays], =, 0)), Unwatched,
Math(Compare([Watched], =, 1) & Compare([Number Plays], =, 0)), Special Case,
Math(Compare([Watched], =, 0) & Compare([Number Plays], >, 0)), Started
)

I'll leave you to do the formatting.
Title: Re: Help with an expression
Post by: muzicman0 on November 11, 2013, 11:50:30 am: This seems to work, so thanks!

But, I have noticed that sometimes (I'm guessing when a show is recorded back to back) my watched library field is showing as 1, even though I haven't watched it (so number of plays is 0, which marks is as watched)...so I guess I have to figure that out. If you have any suggestions, that would be great...I actually am using the following, which I got from another thread:

Math(!formatnumber([Bookmark]) | above(formatnumber([Bookmark]) / [Duration,0], 900))

The problem is, I really don't know what it is doing...ultimately, I want to set this up so that is it is <20% watched, it is considered unwatched, but >90% watched, it is considered watched.
Title: Re: Help with an expression
Post by: muzicman0 on November 11, 2013, 12:27:01 pm: so why won't this work...I'm trying to create an expression that will determine the percentage watched...what I have is this:

Library Field "Test Duration": Math(formatnumber([duration,0], 2)) <-this converts the duration to seconds...so instead of 2:12, it would be 132.31.
Library Field "Test Bookmark":math(formatnumber([Bookmark], 2)/1000) <-this converts the bookmark to seconds (I am assuming the bookmark is in milliseconds)
Library Field "Test Calculated Position": Math([Test Bookmark]/[Test Duration]) <-this should return a percentage of how far it has been watched, but instead it returns an expression error.

If I replace the '[[Test Duration]' in the 'Test Calculated Position' with a real number, then it works, which leads me to believe that the problem lies in the Test Duration output not being a number, but a string or something...but I don't know where to go from here...if I could get this working, then I could make my original goal much easier.
Title: Re: Help with an expression
Post by: RJC on November 11, 2013, 12:48:52 pm: You could make it even simpler by using this in a 'Watched' Expression Column.

IfElse(
Compare(Watched(1), =, 0), Not Watched,
Compare(Watched(1), =, 1), Partly Watched,
Compare(Watched(1), =, 2), Watched
)
Title: Re: Help with an expression
Post by: muzicman0 on November 11, 2013, 12:53:15 pm: not sure I follow that...my 'Watched' field only currently returns 0 or 1.
Title: Re: Help with an expression
Post by: muzicman0 on November 11, 2013, 01:31:21 pm: Quote from: muzicman0 on November 11, 2013, 12:27:01 pm
so why won't this work...I'm trying to create an expression that will determine the percentage watched...what I have is this:

Library Field "Test Duration": Math(formatnumber([duration,0], 2)) <-this converts the duration to seconds...so instead of 2:12, it would be 132.31.
Library Field "Test Bookmark":math(formatnumber([Bookmark], 2)/1000) <-this converts the bookmark to seconds (I am assuming the bookmark is in milliseconds)
Library Field "Test Calculated Position": Math([Test Bookmark]/[Test Duration]) <-this should return a percentage of how far it has been watched, but instead it returns an expression error.

If I replace the '[[Test Duration]' in the 'Test Calculated Position' with a real number, then it works, which leads me to believe that the problem lies in the Test Duration output not being a number, but a string or something...but I don't know where to go from here...if I could get this working, then I could make my original goal much easier.

Got it...it needed a space around the '/'.
Title: Re: Help with an expression
Post by: RJC on November 11, 2013, 02:50:04 pm: Watched() is a built-in MC Function which does most of what you want.
Title: Re: Help with an expression
Post by: muzicman0 on November 11, 2013, 03:01:52 pm: Thanks...I will play around with it, but my feeling is I will want more control over it, so this is what I came up with. It appears that the only thing it doesn't do that I would like it to do is if I convert a video, and import it, it is marked as unwatched...which it technically is (but I only convert format once I have watched a TV show and I am archiving)...I just can't seem to come up with a way to reliably detect that scenario without screwing up other scenarios...but here it is...if anyone has suggestions, please let me know!

Custom Library Fields:
SeasonEpisode = if([Episode], S[Season]EPadNumber([Episode], 2), )
SCW Bookmark = math(formatnumber([Bookmark], 2)/1000)
SCW Calculated = Math([SCW Bookmark] / [SCW Duration])
SCW Duration = formatnumber([duration,0], 2)&datatype=[number]

The expression in the 'Custom File Info Panel|TV Show":
Code: [Select]
IfElse(Math(Compare([SCW Calculated], >=, .92)), √ [Series] [SeasonEpisode]-[Name], Math(Compare([SCW Calculated], >=, .07) & Compare([SCW Calculated], <, .92)), ! [Series] [SeasonEpisode]-[Name] , Math(Compare([SCW Calculated], >=, 0) & Compare([SCW Calculated], <, .07)), [Series] [SeasonEpisode] - [Name])Broken out, it is:
Code: [Select]
IfElse( Math(Compare([SCW Calculated], >=, .92)), √ [Series] [SeasonEpisode]-[Name], Math(Compare([SCW Calculated], >=, .07) & Compare([SCW Calculated], <, .92)), ! [Series] [SeasonEpisode]-[Name] , Math(Compare([SCW Calculated], <, .07)), [Series] [SeasonEpisode] - [Name] )The nice thing, is if I manually set the file back to the beginning (rewind), then it marks it as not watched, which is what I want.

I've only done limited testing, but it appears to work fine.
Title: Re: Help with an expression
Post by: MrC on November 11, 2013, 04:27:20 pm: The first Math() function in your expression is a no-op, and can be removed.

The < .07 case can be tested second in the IfElse, thereby leaving the final "everything else" case.

Be sure to escape forward slashes, as in the <//font> closing tags.

IfElse(
 Compare([SCW Calculated], >=, .92), √ [Series] [SeasonEpisode]-[Name]<//font>,
 Compare([SCW Calculated], <, .07), ;[Series] [SeasonEpisode] - [Name]<//font><//b>
 1, ! [Series] [SeasonEpisode]-[Name] <//font>
 )