[mythtv] db schema, metadata and season/episode numbering

[Karl Dietz]

On 01.05.2012 17:56, Stuart Morgan wrote:
> On Tuesday 01 May 2012 12:40:36 Karl Dietz wrote:
>> On 01.05.2012 09:22, Torbjörn Jansson wrote:
>>> As you can see the episode and season is put into the
>>> syndicatedepisodenumber and in my case the only guide data I have is
>>> from xmltv (eit doesn’t count since it is not so good)
>>>
>>> A proper fix is of course much better than my hack.
>>
>> The proper fix is super simple. Just find a metadatabase with episode
>> data that matches your title/subtitle data and a liberal license. Then
>> write a grabber for that and you're done.
>
> In this case our respective xmltv grabbers already return that information.
> There's no need to disregard what our guide data says and go to another
> metadata source.

Sorry, the summary would have been way better with more details. I've 
been talking that through for my own guide with Robert back when he
added the metadata grabbers.

I'm assuming we are talking about the episode number of recordings? For
the program guide it could make sense to store the episode number in its
own dedicated fields.

The episode number of a recording belongs to the metadata grabbers, so
you must have a guide source that uses the same numbering system and
episode order that your series grabber uses.
As your series grabber is likely the thetvdb grabber you must match
their episodes, which most guide sources don't.

The hint at the shared metadatabase is related to importing the unique
content id from the xmltv data, once there is one agreed upon id space.
At that point in time the metadata grabbers can let go of the episode
number fields, but you will likely use a feed of that database in your
guide creation process, too :-)

Regards,
Karl