INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: TheaterView: Sorting films by last name of director  (Read 1479 times)

akira54

  • Galactic Citizen
  • ****
  • Posts: 302
TheaterView: Sorting films by last name of director
« on: April 16, 2015, 04:01:23 pm »

Hi,

Can anyone tell me whether it is possible to sort movies by the last name of the director? I have created a director view but it sorts by first name because that is how the names are automatically entered in the Director field. However, I often don't know/remember a director's first name. I don't want Kurosawa to be listed under A or Ozon under F. Of course I could manually change al entries but that is a lot of work. Is there any way of automating this?
Logged

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: TheaterView: Sorting films by last name of director
« Reply #1 on: April 16, 2015, 11:40:31 pm »

It is possible, but challenging because [Director] might contain more than one name (it is a list type field).  MC 20 has some new tools for this, though.  If you want to get into it, read through this stuff (roughly from newest info to oldest info):

* http://yabb.jriver.com/interact/index.php?topic=94134.0
* http://yabb.jriver.com/interact/index.php?topic=80231.0
* http://yabb.jriver.com/interact/index.php?topic=78210.0
* http://yabb.jriver.com/interact/index.php?topic=89387.0
* http://yabb.jriver.com/interact/index.php?topic=92092.0

It is hard when the data source can't be controlled, like the online metadata lookup.
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/

akira54

  • Galactic Citizen
  • ****
  • Posts: 302
Re: TheaterView: Sorting films by last name of director
« Reply #2 on: April 17, 2015, 02:14:38 am »

Glynor thanks! I think your entry in 92092.0 might just do it.
Logged

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: TheaterView: Sorting films by last name of director
« Reply #3 on: April 17, 2015, 07:07:45 am »

Make sure to read down in this thread:
http://yabb.jriver.com/interact/index.php?topic=94134.0

That function that MrC helped me build and that I posted about in 92092.0 is now built into MC.  It includes a Swap() and Unswap() expression now that does exactly that for you.
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/

akira54

  • Galactic Citizen
  • ****
  • Posts: 302
Re: TheaterView: Sorting films by last name of director
« Reply #4 on: April 19, 2015, 12:40:10 pm »

Wow, that was easy. :) I just added the function (Swap(field(Director)) to my theaterview tab "Director" and that was it. I haven't gone through yet to see how consistent the results are but first impressions are good. I wonder what happens with such names as "Margarethe von Trotta"?

... I did go through ...

Pity the expression cannot deal with such cases as "Joseph L. Mankiewicz" which ends up as "L, Mankiewicz Joseph". Glynor, your own expression works better and does give me "Mankiewicz, Joseph L." so that is quite an improvement. Did you ever sort out the problem of multiple entries?

PS. What I really like is that when you add the expression in TheaterView to a particular view (as the films grouped according to director), the expression dynamically updates the view without actually changing the tag values. It is very quick too.
Logged

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: TheaterView: Sorting films by last name of director
« Reply #5 on: April 19, 2015, 04:43:01 pm »

I thought Matt had fixed Swap() and Unswap() to handle the same stuff as the expression I was using.  Bummer.  It is better, obviously, because it handles list-type fields, and mine does not.

Matt?
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 41977
  • Shoes gone again!
Re: TheaterView: Sorting films by last name of director
« Reply #6 on: April 19, 2015, 06:11:51 pm »

Pity the expression cannot deal with such cases as "Joseph L. Mankiewicz" which ends up as "L, Mankiewicz Joseph". Glynor, your own expression works better and does give me "Mankiewicz, Joseph L." so that is quite an improvement. Did you ever sort out the problem of multiple entries?

I'll take a look at that early next week.  Hopefully it can be upgraded to handle that without breaking anything else.
Logged
Matt Ashland, JRiver Media Center

akira54

  • Galactic Citizen
  • ****
  • Posts: 302
Re: TheaterView: Sorting films by last name of director
« Reply #7 on: April 19, 2015, 06:13:50 pm »

Thanks Matt, that would be great.
Logged

glynor

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 19608
Re: TheaterView: Sorting films by last name of director
« Reply #8 on: April 19, 2015, 07:06:52 pm »

Thanks Matt, that would be great.

+1
Logged
"Some cultures are defined by their relationship to cheese."

Visit me on the Interweb Thingie: http://glynor.com/

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 41977
  • Shoes gone again!
Re: TheaterView: Sorting films by last name of director
« Reply #9 on: April 20, 2015, 08:14:01 am »

Next build:
Changed: The Swap(...) expression finds the last space instead of the first space so that "My M. Name" becomes "Name, My M.".
Logged
Matt Ashland, JRiver Media Center
Pages: [1]   Go Up