[mythtv-users] Listings for Masterpiece Mystery and Classic

[Peter Bennett (cats22)]

On 09/07/2014 05:29 PM, Hika van den Hoven wrote:
> Hoi Peter,
>
> Sunday, September 7, 2014, 11:10:36 PM, you wrote:
>
>> On 09/07/2014 02:45 PM, Hika van den Hoven wrote:
>>> Hoi Peter,
>>>
>>> Sunday, September 7, 2014, 7:54:39 PM, you wrote:
>>>
>>>> PBS stations group a whole bunch of British shows under the titles
>>>> Masterpiece Mystery! and Masterpiece Classic. This  causes the problems:
>>>> 1. Need to set custom recording rules with a selection on subtitle
>>>> 2. Metadata is not retrieved
>>>> 3. When using mythlinks the file names are not set in the best way.
>>>> Here are some examples of subtitles currently in the listings for me for
>>>> these titles
>>>> Endeavour, Series 1: Rocket
>>>> Downton Abbey
>>>> Breathless, Part 1
>>>> Sherlock: A Study in Pink
>>>> Sherlock, Series III: His Last Vow
>>>> I am considering running a simple SQL script after mythfilldatabase to
>>>> update titles and subtitles of all shows called "Masterpiece Mystery!"
>>>> or "Masterpiece Classic"
>>>> Update program Set title =
>>>> SUBSTRING_INDEX(SUBSTRING_INDEX(subtitle,':',1),',',1),
>>>> subtitle =  
>>>> REPLACE(TRIM(SUBSTRING_INDEX(SUBSTRING_INDEX(subtitle,':',-1),',',-1)),'Part
>>>> ','Episode ')
>>>> where title in ('Masterpiece Mystery!','Masterpiece Classic')
>>>> This changes the titles and subtitles as follows (items currently in my
>>>> listings)
>>>> Endeavour    Rocket
>>>> South Riding    South Riding
>>>> Downton Abbey    Downton Abbey
>>>> Breathless    Episode 1
>>>> Sherlock    A Study in Pink
>>>> Sherlock    His Last Vow
>>>> Endeavour    Home
>>>> Breathless    Episode 2
>>>> Sherlock    The Blind Banker
>>>> Breathless    Episode 3
>>>> Sherlock    The Great Game
>>>> Sherlock    A Scandal in Belgravia
>>>> Miss Marple    A Caribbean Mystery
>>>> Miss Marple    Greenshaw's Folly
>>>> Then use mythutil to reschedule
>>>> This caters for most of the formats I see.
>>>> Will this cause any problems? I will have to alter recording rules
>>>> obviously. Will any other tables need to be changed? Will it still know
>>>> which episodes I have previously recorded? I think it should since it
>>>> checks dups using program ids which I am not changing.
>>>> Peter
>>>> _______________________________________________
>>> Here in the Netherlands we have a similar thing with "KRO detectives",
>>> but you at least have also episode information more then just the
>>> description. I have only the series name as subtitle. So previous
>>> recorded checking is not working here anyhow.
>>> I have done some research but I don't think I have it complete.
>>> I think you have to update the recorded, the recordedprogram amd the
>>> oldrecorded table. You can match them on the basename, although as I
>>> have understood, the Index is on the combination of chanid and
>>> starttime (which together form the basename)
>>> Maybe you also have to update the programguide info, but I haven't yet
>>> looked into that.
>>>
>>> Tot mails,
>>>   Hika                            mailto:hikavdh at gmail.com
>>>
>>> "Zonder hoop kun je niet leven
>>> Zonder leven is er geen hoop
>>> Het eeuwige dilemma
>>> Zeker als je hoop moet vernietigen om te kunnen overleven!"
>>>
>>> De lerende Mens
>>>
>>>
>> What I am trying to do is only update the guide information. That way
>> the recorded, recordedprogram and oldrecorded will all be correct after
>> it has done a recording because it bases the names on what it found in
>> the guide. I am not trying to update recordings that are already on my
>> system, I will live with them as they are, just updating for new ones in
>> the future.
>> Peter
>> _______________________________________________
> There I haven't looked, although I think there are no other tables
> involved. I can only think of two things.
> 1. Every change you make will be reverted on any next run of
>    mythfilldatabase.
>    And does mithfilldatabase also affect records in the past? I don't
>    think so, but I don't know.
> 2. Is it needed to run some kind of schedule run after manually
>    updating the info? I can imagine that something like that is
>    started from mythfilldatabase. In the options from mythfilldatabase
>    I see an option --only-update-guide which suggests it normally does
>    more.
>
> Tot mails,
>   Hika                            mailto:hikavdh at gmail.com
>
>
Hi Hika

1. Yes - I will have to run it after every mythfilldatabase.
2. The command is "mythutil --resched". I will run that after the sql
update. I have used this before after doing sql updates.

Peter