Episode sort (1 Viewer)

[ScoopD]

I had meant to update this post....
I just populated the Sort Name field and for the series prepended with "The...", I removed the prefix and now they all appear in the correct order

I am assuming you did this with a SQL query? Can you supply the string? Don't really know enough SQL myself and internet search may not be necessary if you have already done the work.
The thing I was worried about this was that the next time I do a scan/update I will lose that data and have to execute the SQL query again - as this can happen automatically when you go into tv series in MP this kind of defeats the purpose.

Update: OK I can "copy" the data into the SortName field using -

UPDATE online_Series SET SortName = online_Series.Pretty_Name

but I have no idea how to do a "begins with" type search

EDIT: Also the option for sort by "Sort Name" must be checked in TV Series configuration - no need to mess with the views in database setup.

Where is this option? I would have thought it would have been in the Import Settings tab, but I cannot see it in any option. I may have looked straight through it though.

 

[mortstar]

I am assuming you did this with a SQL query? Can you supply the string? Don't really know enough SQL myself and internet search may not be necessary if you have already done the work.
The thing I was worried about this was that the next time I do a scan/update I will lose that data and have to execute the SQL query again - as this can happen automatically when you go into tv series in MP this kind of defeats the purpose.

Nope, in TV Series configuration, select the series - you can double click on the "Sort Name" field and fill it in yourself

Not as clever as an SQL query - and a little more effort - but I can confirm that later updates don't overwrite your personal changes with the 'original' null values

Where is this option? I would have thought it would have been in the Import Settings tab, but I cannot see it in any option. I may have looked straight through it though.

Not near my HTPC at the moment, it is on the tab which configures the quality of the images, the logo templates etc... It's about half way down this screen and is difficult to spot. It's a simple tickbox affair though.

 

[bobrap]

Tried your idea of changing sort name in the config. Didn't work for me.

 

[Insomnic]

Tried to manually edit the Sort Name field as well and it accepted the changes but the series are still sorted by pretty name (and I did checkmark the "sort series by sort name instead of pretty name).

 

[Inker]

Let me explain how sorting (of series) is done:

- If the view definition itself defines the sorting, this will override whatever you set in the config (sort instead of pretty). Note: earlier versions of the plugin had the views hardcoded to a specific sorting (prettyname), and depending on how and from which version you upgraded, those view definitions may still be in place. You can resolve this either in config clicking reset under views, or by manually removing the sort def. in the views in the db (be careful with this)
- If the view does not explicitally set a sort order, the default is to sort by pretty name, unless you tick the option to sort by sortname in the config.
- This is all useless because thetvdb.com does not currently return sortnames

 

[ScoopD]

Thanks for the info Inker. There was sort name data from the previous way of getting data.

So, if the sort name field is filled in then it will be used. What happens if there is sort name data in some records but not all. I am thinking that I should just copy the pretty name data across to the sort name field, then manually change the ones that I want (ones that start with THE). I would do this through the SQL Lite interface.

I'll report back to tell if this has worked.


Yep that worked. Don't know if it was the Reset of views as suggested by Inker or the copying of all Pretty names to the sort name field by SQL query, then changing the ones that I wanted to ... or the combination of both.

 

[mortstar]

Thanks for the info Inker. There was sort name data from the previous way of getting data.

So, if the sort name field is filled in then it will be used. What happens if there is sort name data in some records but not all. I am thinking that I should just copy the pretty name data across to the sort name field, then manually change the ones that I want (ones that start with THE). I would do this through the SQL Lite interface.

I'll report back to tell if this has worked.

This is exactly what I said - all data in the Sort Name field must be filled in, for all Series!?!

 

[Insomnic]

This doesn't do anything for me.
All of my "Sort (original) name" fields are filled in, but the odd thing is that "Smurfs" works but it never had "the" in the sort name field though "the" is in the pretty name field. All other series that I manually changed the sort name from "The Title" to just "title" still sort by "the". I'd rather not play around in the SQL. Not a huge issue.

 

[ScoopD]

I found that a lot of info appeared in the sort name field in the GUI, but in the actual database the data was not there.