[mythtv-users] Schedules Direct guide data for AU / NZ

Mark Perkins perkins1724 at hotmail.com
Mon Sep 12 10:12:01 UTC 2016


>> zz_sdjson_sqlite doesn't seem to have stars or originalairdate info. I
>> use both so a little bit of an issue for me.
> 
> This could be one of the open issues regarding episode and show data
> combination, or something different.  You would likely have to provide the
> the lineup and the program/show where this is the case for research.
> 

It seems to be for all of them. But one example (extract from database so
the greater than symbols don't muck with readability):
lineup=AUS-SA0081-DEFAULT

select * from program where title="Beverly Hills Cop" limit 1 \G
*************************** 1. row ***************************
                 chanid: 1090
              starttime: 2016-09-17 11:15:00
                endtime: 2016-09-17 13:15:00
                  title: Beverly Hills Cop
               subtitle:
            description: A freewheeling Detroit cop pursuing a murder
investigation finds himself dealing with the very different culture of
Beverly Hills.
               category: Comedy
          category_type: movie
                airdate: 2016
                  stars: 0
        previouslyshown: 1
        title_pronounce:
                 stereo: 0
              subtitled: 0
                   hdtv: 1
         closecaptioned: 0
             partnumber: 0
              parttotal: 0
               seriesid: 205966368
        originalairdate: NULL
               showtype:
              colorcode:
syndicatedepisodenumber:
              programid: MVAU1210291222
               manualid: 0
                generic: 0
          listingsource: 4
                  first: 1
                   last: 1
              audioprop:
          subtitletypes:
              videoprop: HDTV
                inetref:
                 season: 0
                episode: 0
          totalepisodes: 0
1 row in set (0.00 sec)

>> which is the way Shepherd does it, whereas zz_sdjson_sqlite has a
>> separate entry for each rating.
> 
> Possibly different source rating sources.  Do you happen to know where
> Shepard gets its data?

Nope, sorry no idea.



More information about the mythtv-users mailing list