Episode sort (1 Viewer)

[bobrap]

Is the sort by sort name instead of pretty name working correctly? I have that set and it seems to sort correctly in configuration, but not when running the plugin. Any ideas what I might be doing wrong?

 

[daquint]

I have noticed the same thing.

I just rename all the pretty names to the sort order i want, to avoid 18 shows sorted by "the.."

I think its a bug.

 

[mortstar]

Great plugin - the above mentioned issue is 1 minor bugbear.

Could the plug-in use 'Sort Name' instead of 'Pretty Name' for alphabetising?

Cheers!

 

[ScoopD]

I had exactly the same requirement as all of the above, and this is how I fixed it.

I manually changed this is the database using the SQLite Database Browser.exe which hides in <PATH TO MEDIAPORTAL>MediaPortal\Docs.

Make sure you have exited MP and then launch the exe and open TVSeriesDatabase4.db3 from the database folder. Go to the Browse Data tab, then choose the Views table. These are all the available views. If you don't want to lose the default ones then create a new one (New Record) Call it what you want - the important stuff is - ID field is unique, so one more than the previous one; enabled field should be 1; viewConfig is the important one. This is what I use for the ALL view.

series<;><;><Series.SortName>;asc<;><nextStep>season<;><;><Season.seasonIndex>;asc<;><nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>

The only variance to the standard is that <Series.Pretty_Name> is replaced by <Series.SortName>. I did the same change in my Genre view. Don't forget to save the database when you exit, then go back into MP and see your changes in action.

 

[mortstar]

I had exactly the same requirement as all of the above, and this is how I fixed it.

I manually changed this is the database using the SQLite Database Browser.exe which hides in <PATH TO MEDIAPORTAL>MediaPortal\Docs.

Make sure you have exited MP and then launch the exe and open TVSeriesDatabase4.db3 from the database folder. Go to the Browse Data tab, then choose the Views table. These are all the available views. If you don't want to lose the default ones then create a new one (New Record) Call it what you want - the important stuff is - ID field is unique, so one more than the previous one; enabled field should be 1; viewConfig is the important one. This is what I use for the ALL view.

series<;><;><Series.SortName>;asc<;><nextStep>season<;><;><Season.seasonIndex>;asc<;><nextStep>episode<;><;><Episode.EpisodeIndex>;asc<;>

The only variance to the standard is that <Series.Pretty_Name> is replaced by <Series.SortName>. I did the same change in my Genre view. Don't forget to save the database when you exit, then go back into MP and see your changes in action.

Worked perfectly, cheers!

 

[daquint]

I will try this - thanks!

 

[mortstar]

Since upgrading to version 2.0 (and also the svn before that), this expression now completely messes up the episode sort.

I'd like to get the series prefixed with "the" back into 'Sort Name' order - anybody have any ideas for the new version?

 

[mortstar]

Cheeky bump

:sorry:

 

[ScoopD]

Well there you go. I finally updated to plugin 2.0 on my main machine and, as reported, the order of series (using sortname instead of pretty_name) is all stuffed.

Had a look in the database and in my backed up pre-upgrade database for comparison. What I found was that the sortname field is almost completely blank - almost every series does not have an entry in sortname. Compare this to my pre-update database where every single series has an entry in sortname.

So one of the following has happened depending on how that field is populated.
1. the change at thetvdb has wiped out a field of info (nothing we can do about that)
2. the updated plugin is not grabbing that info and populating the field (this should be able to be fixed fairly easily)
3. that field was always populated by some operation of the plugin which has been removed (again, this should be able to be fixed).

I'll put this in the main "use the new plug-in" thread as well & see if any of the coding guys understand what we are talking about.

 

[mortstar]

I had meant to update this post....


This is what I found too - the Sort Name field is not being populated, so the random order was caused by sorting by this field and most values being null.

to rectify the problem 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

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.