[mythtv-users] Schedules Direct DataDirect replacement service testing

[Robert Eden]

On 10/6/2014 11:05 PM, Bill Meek wrote:
> On 10/06/2014 08:49 PM, Tom Dexter wrote:
> ...
>
> >>When I go into the listings in MythWeb for last night, none of the
> >>shows I recorded are showing as having been recorded.
> ...
> > It looks like the seriesid being returned by the replacement server is
>> different from the one I was getting from the real DD server.  As a
>> result, mythweb isn't finding them properly...which may be a related
>> bug in mythweb.  However, that aside, I'm not even sure which is
>> correct.  Here's the data where I found this:
>>
>> --------------
>> select chanid, seriesid, starttime, subtitle from oldrecorded where
>> title='madam secretary' and chanid=1021 and recstatus=-3 order by
>> starttime
>> --------------
>>
>> +--------+------------+---------------------+------------------+
>> | chanid | seriesid   | starttime           | subtitle         |
>> +--------+------------+---------------------+------------------+
>> |   1021 | EP01922294 | 2014-09-22 00:30:00 | Pilot            |
>> |   1021 | EP01922294 | 2014-09-29 00:01:00 | Another Benghazi |
>> |   1021 | EP01922294 | 2014-10-06 00:30:00 | The Operative    |
>> +--------+------------+---------------------+------------------+
>>
>> --------------
>> select chanid, seriesid, starttime, subtitle from program where
>> title='madam secretary' and chanid=1021 order by starttime
>> --------------
>>
>> +--------+------------+---------------------+-------------------------+
>> | chanid | seriesid   | starttime           | subtitle                |
>> +--------+------------+---------------------+-------------------------+
>> |   1021 | EP01922294 | 2014-09-22 00:30:00 | Pilot                   |
>> |   1021 | EP01922294 | 2014-09-22 02:30:00 | Pilot                   |
>> |   1021 | EP01922294 | 2014-09-28 00:00:00 | Pilot                   |
>> |   1021 | EP01922294 | 2014-09-29 00:01:00 | Another Benghazi        |
>> |   1021 | SH01922294 | 2014-10-06 00:30:00 | The Operative           |
>> |   1021 | SH01922294 | 2014-10-13 00:01:00 | Just Another Normal Day |
>> +--------+------------+---------------------+-------------------------+
>>
>> As you can see, my recording history in oldrecorded as well as the
>> programs from the DD server (older ones that were not overwritten by
>> the replacement server last night) have the seriesid of EP01922294
>> while the new programs have SH01922294.
>>
>> Can anyone verify which is actually correct?
>
> I see that too. But noticed that the programids
> all started with EP, even for those with seriesid
> starting with SH.
>
> Here's my raw data from TMS-DD for just one episode:
>
> <program id='EP019222940004'>
> <title>Madam Secretary</title>
> <subtitle>Just Another Normal Day</subtitle>
> ...
>
> No <series> line. Looking closer, there are no lines with:
> SH01922294 in the entire download.
>
> And this is from SD-DD for the same episode:
>
> <program id='EP019222940004'>
> <series>SH01922294</series>
> <title>Madam Secretary</title>
> <subtitle>Just Another Normal Day</subtitle>
> ...
>
> grep '<series>' mythtv_dd_cache_sd-dd |grep EP returned
> no lines. The same test in the 'old' raw data returned
> 9K lines and 0 when replacing SH for EP.
>
> Robert, does this mean the vendor is sending incorrect data
> e.g. an SD lineup issue?
>
Here's what Tribune's documentation has to say on the subject of "series":

     Field length, maximum 14 (e.g. SH00016827 for an episode for program EP000168270054).
     Optional: For an episode program (begins with EP), designates the series id.

So that's what my code does.. takes a subset of the program_id and changes EP to SH.

But you guys are right, TMS-DD isn't following their own rules! I'll change the output to match TMS-DD.

Robert