[mythtv-users] Schedules Direct DataDirect replacement service testing

[R. G. Newbury]

On 07/10/14 12:47 AM, Robert Eden wrote:
> On 10/6/2014 11:05 PM, Bill Meek wrote:
>> On 10/06/2014 08:49 PM, Tom Dexter wrote:

>>
>> 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

And "should" match the output obtained with the mfdb-json grabber. I get 
this:

  select chanid,title,subtitle,seriesid,programid,season,episode from 
program where title like "Madam%";
+--------+-----------------+-------------------------+------------+----------------+--------+---------+
| chanid | title           | subtitle                | seriesid   | 
programid      | season | episode |
+--------+-----------------+-------------------------+------------+----------------+--------+---------+
|   3003 | Madam Secretary | Just Another Normal Day | EP01922294 | 
EP019222940004 |      1 |       4 |
|   3016 | Madam Secretary | Just Another Normal Day | EP01922294 | 
EP019222940004 |      1 |       4 |
|   1041 | Madam Secretary | Just Another Normal Day | EP01922294 | 
EP019222940004 |      1 |       4 |
|   1411 | Madam Secretary | Just Another Normal Day | EP01922294 | 
EP019222940004 |      1 |       4 |
+--------+-----------------+-------------------------+------------+----------------+--------+---------+


which looks to be the same as your grabber is grabbing.

Geoff

-- 
              R. Geoffrey Newbury