ifelse( isrange([Critic Rating],0.0-2.9),☆, isrange([Critic Rating],3.0-3.9),★, isrange([Critic Rating],4.0-4.9),★☆, isrange([Critic Rating],5.0-5.9),★★, isrange([Critic Rating],6.0-6.4),★★☆, isrange([Critic Rating],6.5-6.9),★★★, isrange([Critic Rating],7.0-7.4),★★★☆, isrange([Critic Rating],7.5-7.9),★★★★, isrange([Critic Rating],8.0-8.9),★★★★☆, isrange([Critic Rating],9.0-10),★★★★★)
if(!isempty([Web Media Info]), [Name], IfElse(IsEqual([Media Sub Type], Movie), IfElse(!isempty([Number Plays]), if(Math(!formatnumber([Bookmark]) | above(formatnumber([Bookmark]) / [Duration,0], 900)), <font color="C3FFB3">√ <font color="888888">, <font color="FF6E6E"> ! <//font>))[Name] <font color="C3FFB3">[Critic Rating Stars], IsEqual([Media Sub Type], Music Video), [Name] <font color="C3FFB3">/ IfElse((isequal([rating],1,2),★, isequal([rating],2,2),★★, isequal([rating],3,2),★★★, isequal([rating],4,2),★★★★, isequal([rating],5,2),★★★★★), IsEqual([Media Sub Type], TV Show), If(!isempty([Number Plays]), if(Math(!formatnumber([Bookmark]) | above(formatnumber([Bookmark]) / [Duration,0], 900)), <font color="C3FFB3">√ <//font><font color="888888">S[Season]EPadNumber([Episode], 2) [Name] <font color=" C3FFB3"> [Critic Rating Stars]<//font>, <font color="FF6E6E"> ! <//font><font color="888888">S[Season]EPadNumber([Episode], 2)<//font> [Name] <font color=" C3FFB3"> [Critic Rating Stars]), <font color="888888">S[Season]EPadNumber([Episode], 2)<//font> [Name] <font color="C3FFB3"> [Critic Rating Stars]), IsEqual([Media Sub Type], Trailer), If(!isempty([Number plays]), <font color="C3FFB3">√ <font color="888888"> [Name], [Name]), IsEqual([Media Type], Audio),[Name] <font color="888888">by<//font> [Artist] <font color="C3FFB3">ifelse(isequal([rating],1,2),★, isequal([rating],2,2),★★, isequal([rating],3,2),★★★,isequal([rating],4,2),★★★★,isequal([rating],5,2),★★★★★)<//font>,[Name], 1, [Name]))
Comment: This caption will change the caption for: Movies, TV Shows, Trailers, Music Videos and Audio. It will add Watched/Not Watched icons and text color changes, Season/Episode text and ratings based on Critic Rating and Rating. It leaves out web media from the caption, only applying the [Name] tag.If(IsEqual([Media Sub Type], Movie), If(IsEqual([Number Plays], ),[Name] ,<font color="888888">[Name] ) <//font>,[Name] )<font color="FFD987"> ifelse(isrange([Critic Rating],0.0-2.9),☆, isrange([Critic Rating],3.0-4.9),★, isrange([Critic Rating],5.0-5.9),★☆, isrange([Critic Rating],6.0-6.9),★★, isrange([Critic Rating],7.0-7.4),★★☆,isrange([Critic Rating],7.5-7.9),★★★,isrange([Critic Rating],8.0-8.4),★★★☆,isrange([Critic Rating],8.5-8.9),★★★★,isrange([Critic Rating],9.0-9.4),★★★★☆,isrange([Critic Rating],9.5-10),★★★★★ )<//font>
If(IsEqual([Media Sub Type], TV Show), If(IsEqual([Number Plays], ), <font color="888888">S[Season]E[Episode] - [Name] <//font>, S[Season]E[Episode] - [Name] ), S[Season]E[Episode] - [Name] ) <font color="FFD987"> ifelse(isrange([Critic Rating],0.0-2.9),☆, isrange([Critic Rating],3.0-4.9),★, isrange([Critic Rating],5.0-5.9),★☆, isrange([Critic Rating],6.0-6.9),★★, isrange([Critic Rating],7.0-7.4),★★☆,isrange([Critic Rating],7.5-7.9),★★★,isrange([Critic Rating],8.0-8.4),★★★☆,isrange([Critic Rating],8.5-8.9),★★★★,isrange([Critic Rating],9.0-9.4),★★★★☆,isrange([Critic Rating],9.5-10),★★★★★ )<//font>
[Name] <font color="888888">by<//font> [Artist] <font color="FFD987">ifelse(isequal([rating],1,2),★, isequal([rating],2,2),★★, isequal([rating],3,2),★★★,isequal([rating],4,2),★★★★,isequal([rating],5,2),★★★★★ ) <//font>
Hmmm. I tried to copy those stars directly to the Caption option now, and it worked. This is on my PC at work. I'm wondering if the new build did the trick?
My first question is regarding graphical representation of ratings using text stars. I've seen examples such as this one: Name] ifelse(isequal([rating],1,2),★, isequal([rating],2,2),★★, isequal([rating],3,2),★★★, isequal([rating],4,2),★★★★,isequal([rating],5,2),★★★★★)
The problem is that the stars disappear the moment I copy and paste them into the caption field or textpad/notepad. Does this have something with the font being used perhaps? Or do I need to use some kind of code for the stars to be presented the right way?
If(IsEqual([Media Sub Type], Movie),If(!isempty([Number Plays]),if(Compare(Math([Bookmark] / 1000 / [Duration,0]), >, 0.90) | isempty([Bookmark]),<font color="888888">[Name], <font color="FFD987">[Name] ),[Name] ) <font color="FFD987">ifelse(isrange([Critic Rating],0.0-2.9),☆, isrange([Critic Rating],3.0-4.9),★, isrange([Critic Rating],5.0-5.9),★☆, isrange([Critic Rating],6.0-6.9),★★, isrange([Critic Rating],7.0-7.4),★★☆,isrange([Critic Rating],7.5-7.9),★★★,isrange([Critic Rating],8.0-8.4),★★★☆,isrange([Critic Rating],8.5-8.9),★★★★,isrange([Critic Rating],9.0-9.4),★★★★☆,isrange([Critic Rating],9.5-10),★★★★★),[Name])
If(IsEqual([Media Sub Type], TV Show), If(!isempty([Number Plays]),if(Compare(Math([Bookmark] / 1000 / [Duration,0]), >, 0.90) | isempty([Bookmark]),<font color="888888">S[Season]EPadNumber([Episode], 2) - [Name], <font color="FFD987">S[Season]EPadNumber([Episode], 2) - [Name] ), S[Season]EPadNumber([Episode], 2) - [Name] ) <font color="FFD987"> ifelse(isrange([Critic Rating],0.0-2.9),☆, isrange([Critic Rating],3.0-4.9),★, isrange([Critic Rating],5.0-5.9),★☆, isrange([Critic Rating],6.0-6.9),★★, isrange([Critic Rating],7.0-7.4),★★☆,isrange([Critic Rating],7.5-7.9),★★★,isrange([Critic Rating],8.0-8.4),★★★☆,isrange([Critic Rating],8.5-8.9),★★★★,isrange([Critic Rating],9.0-9.4),★★★★☆,isrange([Critic Rating],9.5-10),★★★★★ ),[Name])
If(IsEqual([Media Sub Type], Movie),If(!isempty([Number Plays]),if(Math(above([Bookmark] / 10 / [Duration,0], 90)),<font color="888888">[Name], <font color="FFD987">[Name] ),[Name] ) <font color="FFD987">[Critic Rating Stars],[Name] )
If(IsEqual([Media Sub Type], Movie),If(!isempty([Number Plays]),If(!isempty([Bookmark]),If(Compare(Math([Bookmark] / 1000 / [Duration,0]), >, 0.90),<font color="888888">[Name] ,<font color="FFD987">[Name] ),<font color="888888">[Name] ),[Name] )<font color="FFD987">[Critic Rating Stars],[Name] )
Not Viewed | | Partially Viewed | | Fully Viewed |
# Plays = 0 and no Bookmark | 0 < Bookmark < 90% | # Plays > 0, or # Plays = 0 and Bookmark > 90% |
Not Viewed | | Partially Viewed | | Fully Viewed |
#Plays="" and Bookmarks = what ever | #Plays > 0 and BookMark < 90% | #Plays > 0 and BookMark = "" or #Plays > 0 and BookMark > 90% |
My last code seems to do exactly what I want. It contains more IF sentences than I would like, but it does not matter. The critic ratings are supposed to be shown on all files, just for the symetry of it. In the end there will be some different ratings for different media. Critic Rating vs Rating as an example.
ifelse( isrange([Critic Rating],0.0-2.9),☆, isrange([Critic Rating],3.0-3.9),★, isrange([Critic Rating],4.0-4.9),★☆, isrange([Critic Rating],5.0-5.9),★★, isrange([Critic Rating],6.0-6.4),★★☆, isrange([Critic Rating],6.5-6.9),★★★, isrange([Critic Rating],7.0-7.4),★★★☆, isrange([Critic Rating],7.5-7.9),★★★★, isrange([Critic Rating],8.0-8.9),★★★★☆, isrange([Critic Rating],9.0-10),★★★★★)
If(IsEqual([Media Sub Type], Movie), IfElse(!isempty([Number plays]), if(Math(!formatnumber([Bookmark]) | above(formatnumber([Bookmark]) / [Duration,0], 900)), <font color="888888">, <font color="FFE8B5">))[Name] <font color="FFE8B5">[Critic Rating Stars], [Name])
This was the first one I created. With 3 different text colors to separate between watched, not watched as well as not finished watching. I do not think it looks that great with the third color for the "not finished watching" items. I like the icon approach beneath better..If(IsEqual([Media Sub Type], Movie), IfElse(!isempty([Number plays]), if(Math(!formatnumber([Bookmark]) | above(formatnumber([Bookmark]) / [Duration,0], 900)), <font color="C3FFB3">√<font color="888888">, <font color="FF6E6E">! <//font>))[Name]<font color="FFE8B5"> [Critic Rating Stars], [Name])
This gives you a √ and ! to indicate watched, and not fully watched, as well as a gray text if it's completely watched. You might say it's a bit redundant with √ as well as gray text to mark things as watched, but I like it :) Visual indicators often beats beats text. I think the stars could very well be the same green color as the √ character. But this is highly subjective anyway. No way we all will agree on one single color.If(IsEqual([Media Sub Type], TV Show), <font color="888888">S[Season]EPadNumber([Episode], 2)<//font> IfElse(!isempty([Number plays]), if(Math(!formatnumber([Bookmark]) | above(formatnumber([Bookmark]) / [Duration,0], 900)), <font color="C3FFB3">√<font color="888888">, <font color="FF6E6E">! <//font>)) [Name]<font color="FFE8B5"> [Critic Rating Stars], [Name])
Using the same system as above, but graying out the Season and Episode text, so it's not so in-your-face.First create a field called Days w-Suffix
Enter the following as the expression:
NA;1st;2nd;3rd;4th;5th;6th;7th;8th;9th;10th;11th;12th;13th;14th;15th;16th;17th;18th;19th;20th;21st;22nd;23rd;24th;25th;26th;27th;28th;29th;30th;31st
This works straight away as an image display caption but will probably need tweaked for theater view.
if(isempty(formatdate([date,0],dddd)),,formatdate([date,0],dddd)) if(isempty(formatdate([date,0],d)),,listitem([Days w-Suffix], formatdate([date,0],d), ;)) if(isempty(formatdate([date,0],MMMM)),,formatdate([date,0],MMMM)) if(isempty(formatdate([date,0],YYYY)),,formatdate([date,0],yyyy))
Either way, none of the caption fields produce ANY caption for Images in theater View. I do not know what's going on. Image support is active, images are imported, I have the image root view with child items. I'm out of ideas. Only thing I can think of is that Image captions for Theater View are disabled, or that this is a bug.
TVShow2What am I doing wrong...I am new to JRiver, but when I put the above code, instead of getting the star image, I just get text that reads "[Critic Rating Stars]"...thanks for any help...Code: [Select]If(IsEqual([Media Sub Type], TV Show), <font color="888888">S[Season]EPadNumber([Episode], 2)<//font> IfElse(!isempty([Number plays]), if(Math(!formatnumber([Bookmark]) | above(formatnumber([Bookmark]) / [Duration,0], 900)), <font color="C3FFB3">√<font color="888888">, <font color="FF6E6E">! <//font>)) [Name]<font color="FFE8B5"> [Critic Rating Stars], [Name])
Using the same system as above, but graying out the Season and Episode text, so it's not so in-your-face.
What am I doing wrong...I am new to JRiver, but when I put the above code, instead of getting the star image, I just get text that reads "[Critic Rating Stars]"...thanks for any help...
See Matt's reponses in the beta thread "Re: Theater View "File Caption" for images?".Will do!
thanks...not sure how I missed that...one question...where do I create a user expression...like I said...totally new to this, but love it!
See Reply #9 (http://yabb.jriver.com/interact/index.php?topic=74635.msg506249#msg506249) above.
If(IsEqual([Media Sub Type], Movie), IfElse(!isempty([Number plays]), if(Math(!formatnumber([Bookmark]) | above(formatnumber([Bookmark]) / [Duration,0], 900)), <font color="888888">, <font color="FFE8B5">))[Name] <font color="FFE8B5">[Critic Rating Stars], [Name])
If(IsEqual([Media Sub Type], Music Video),[Name] <font color="FFE8B5">ifelse((isequal([rating],1,2),★, isequal([rating],2,2),★★, isequal([rating],3,2),★★★,isequal([rating],4,2),★★★★,isequal([rating],5,2),★★★★★),[Name])
If(IsEqual([Media Sub Type], Movie), IfElse(!isempty([Number plays]), if(Math(!formatnumber([Bookmark]) | above(formatnumber([Bookmark]) / [Duration,0], 900)), <font color="C3FFB3">√<font color="888888">, <font color="FF6E6E">! <//font>))[Name]<font color="C3FFB3"> [Critic Rating Stars], If(IsEqual([Media Sub Type], Music Video),[Name] <font color="C3FFB3">ifelse((isequal([rating],1,2),★, isequal([rating],2,2),★★, isequal([rating],3,2),★★★,isequal([rating],4,2),★★★★,isequal([rating],5,2),★★★★★),[Name]))
I noticed that. It works well on my computer at work. But i only get rectangles instead of stars in the caption field in MC. Before I updated to the latest build, it was just empty spaces instead. This is the same for both my server and client at home. My home server shows the correct characters after a updating to the latest build, but my client (library server client) is still acting strange, and only shows rectangles. Copying those back from MC caption options gives me this: ★★★☆
What's wrong with my client? Could it still be a problem with fonts in MC?
To convert your sequence If() statements, which all test Media Sub Type, into an IfElse chain, you take the current form:Muchas gracias! I think I'll be able to patch it together now.
I had the same problem on my work computer, I had to change the font to "Segoe UI Symbol" to get it to work.
I've tried that. It was set to "Segoe UI". Changing it to "Segoe UI Symbol" or two dusin other fonts does not change the characters to the correct stars.
so this works for anything that I had prior to using jriver, but not on anything that I have recorded via TV...any idea why?I can add that. I only need to know what Media Sub Type that is used for Recorded video. I have no clue as it's been a long time since I've had a tuner that works with MC.
Going to have to steal some of this for my captions. Only thing I don't think will work for me is the critic rating, but I love what you have going there. The big issue around critic data is that there doesn't seem to be any consistency in the rating scheme of the various sites that have for that data. I am really partial to rotten tomatoes ratings that have both critic and audience data, and they are expressed from 0-100%. Other sites do 1-10 and others do 1-5.That's a problem. Personally I only use theMovieDB as a source. But on a short time, I will be looking at ways to incorporate other meta scraper sources like Personal Video Database. That will probably make it easier to get other critic ratings as well. I know I can do manual lookups from MC to get torren tomatoes rating, but anyting but automatic is a no-go in my book. And this code is created mainly as an option for those that use defualts in MC. Other things have to be adapted to their setup.
Currently I seem to have a mix of % for movies (example '84% Critic, 61% Audience'), and numeric ratings for TV shows. I'm sure there is a way to rework the logic for that, but I really don't care about having the critic rating in the caption since it shows up in the description area.
This is no longer necessary with the Dayordinal keyword in FormatDate(). See below.
I see no difference between the expression above, and the simpler version here:
formatdate([date,0], Dayname Dayordinal Month Year)
How would I go about integrating IsRemovable(...) and IsMissing(...) to this caption?
Because some of my media is located on external hard drives that aren't switched on all the time.
It would be nice if the following logic could be incorporated
If
Media is removable
Check If is Missing
If is missing font colour=Red (Of a Symbol Could work well too)
If not Default font colour.
Do you think it is a bug?
Maybe I should open a request thread to allow assignment of removable media to specific drive letters in Configure Auto Import, what do you think?
Oh. So, there is a hidden custom caption for recorded video, that we can not alter. Either need to remove the Recorded Date or just settle with it then. That's a shame. Luckily I never record, so I don't have this problem :PI must still be missing something...I tried removing the recorded date, but it still didn't work for recorded TV...is there any other info you can provide?
I believe I had [name] everywhere in my example. Did I miss one, or was it just missing in your own caption?For me, [name] rendered out only the episode name, so it would look something like this:
I made a change to add the series name to the caption. it is:
IfElse(isequal(IsRemovable():IsMissing(), 1:1), <font color="FF0000">◙ <//font>)IfElse(!isempty([Web Media Info]), [Name], IsEqual([Media Sub Type], Movie), IfElse(!isempty([Number Plays]), if([Watched], <font color="C3FFB3">√ <font color="888888">, <font color="FF6E6E">! <//font> ) ) [Name] [Critic Rating Stars], IsEqual([Media Sub Type], TV Show), if(!isempty([Number Plays]), if([Watched], <font color="C3FFB3">√ [SeasonEpisode]: [Series], <font color="FF6E6E">! [SeasonEpisode]: [Series] <//font>), [SeasonEpisode]: [Series]<//font>/ ) - [Name] [Critic Rating Stars], IsEqual([Media Sub Type], Music Video), - [Name] [Rating Stars], IsEqual([Media Sub Type], Trailer), IfElse(!isempty([Number plays]), <font color="C3FFB3">√ <font color="888888">) - [Name], IsEqual([Media Type], Audio), - [Name]<font color="888888"> by <//font>[Artist] [Rating Stars], 1, - [Name] )<//font>
If anyone wants it.
I am trying to get to the root of this Expressions and where to paste them: