Print

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

[bklynboy70]

I have a Database app (Movie Collector) to keep track of my movies. The app has a title field and a title sort field. This is useful for movies like:

The Fast and the Furious
2 Fast 2 Furious.

The two movies will be separated during a normal alphabetic search. I would like to keep them together, so, in Movie Collector, I just update the Title Sort fields for the movies as follows:

Title Field : The Fast and the Furious --- Title Sort Field : The Fast and the Furious
Title Field: 2 Fast 2 Furious --- Title Sort Field : The Fast and the Furious 2

The name displayed for the movie the second movie is: 2 Fast 2 Furious, but is sorted as: The Fast and the Furious 2.

Is this possible with JRiver?

Thank you and take care,

Rob

[JimH]

You could add a custom tag.

[bklynboy70]

If I make a Title Sort field and leave it blank (for most titles the title sort will be blank, only a hundred out of 3000 would have to be populated), would JRiver default to the title field for the sorting?

[JimH]

You can make it sort by any tag.

You can copy one tag to another.

[blgentry]

I have a field called [Movie Sort].  [Movie Sort] is an expression which uses several fields to calculate it's value, including [Series] and [Name].  For movie series, I fill out the [Series] field with the series name.  Like "The Fast and the Furious" for example.  Then I fill out the [Episode] field with the number of that movie.  So The Fast and the Furious would be episode #1.  2 Fast 2 Furious is episode #2, etc.

I've also been experimenting with using [Season] to group Extras together with the relevant movie.  You can just omit the [Season] part of the expression, or don't fill out the Season tag on your Movies.  Either way the sorting should still work as I've described it.

[Movie Sort] figures all of this out for me with the following expression:

Code: [Select]

if(isempty([Series]),[Name],[Series] [Season] [Episode])
Of course you need to tell your Views to sort by [Movie Sort] when you're done.

This is just one way of doing it; you could adapt this or change it to suit your needs.

Brian.

[blgentry]

I forgot to add a few details to my post above.

[Movie Sort] optionally uses [Series] as a sorting element.  If [Series] is blank (empty), then it just uses [Name].  This way, you can sort by Series by filling out that tag, but it just sorts normally for everything else.  So you don't have to do any maintenance or setup to make it work.  Just fill out [Series] (and optionally [Episode]) for the ones you want to sort by Series name and it does it.

My logic for [Season] is not fully thought out yet, so you might just ignore that part for now.

Brian.

[bklynboy70]

Sweet. Thank you both for your help.

Now for some experimenting!

[bklynboy70]

OK. Made a new field called "Name Sort". Copied "Name" field values to "Name Sort". Then set the sort to custom by "Name Sort". All updates work perfectly. Then I realized... every time I add new movies in, I will have to copy the "Name" field over to "Name Sort" for the newly added movies...

Is there a way to have JRiver do that automatically, when new movies are added to the library?

Thanx for all the help.

Take care,

Rob

You can make it sort by any tag.

You can copy one tag to another.

[ferday]

In the import rules

[name]=[name sort]

That should do it

[blgentry]

What you want is a 3 field system:

1.  The stock [Name] field.
2.  An "override" field that let's you sort some files differently as you've discussed.  Let's call it [Name Alternate] for discussion.
3.  A third field that you actually sort with.  This field takes the value of either of the above fields as necessary.  Let's call it [Name Sort] .  Now, to make [Name Sort] take either 2 or 1 above, make it a calculated data field with this value:

Code: [Select]

firstnotempty([Name Alternate],[Name])
That should do it.

Brian.

[bklynboy70]

Cool!

Again, thanx for the help.

Take care,

Rob