Comparing tv_grab_zz_sdjson_sqlite & tv_grab_sd_json

Nigel Jewell <[email protected]> Tue, 4 Oct 2016 21:25:37 +0100
Newsgroups gmane.comp.tv.xmltv.general
Message-ID <[email protected]>
This is a multi-part message in MIME format.
--===============1305688403152827503==
Content-Type: multipart/alternative;
	boundary="------------75289DB1ABC752ABF704D941"

This is a multi-part message in MIME format.
--------------75289DB1ABC752ABF704D941
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi,


I'm doing some comparisons between tv_grab_zz_sdjson_sqlite & 
tv_grab_sd_json and their use with MythTV.


I'm finding that with tv_grab_zz_sdjson_sqlite that the duplicate 
programs within the schedule aren't being recognised and therefore 
MythTV is planning on recording more than one showing of the same program.


Having compared the data (example below) and in MythTV program table, it 
appears that there are only a few subtle differences in the output, but 
one is that the airdate being populated in MythTV from the 
tv_grab_zz_sdjson_sqlite is 0000.  I appreciate that 
tv_grab_zz_sdjson_sqlite is only part of the nightly release at present, 
but is this something that people are aware of as an issue?  It might 
not be what is tripping MythTV up, but it doesn't look quite right.  
I've taken a look on xmltv-dev and haven't seen any mention of this.


It might be that tv_grab_zz_sdjson_sqlite is fine and tv_grab_sd_json 
has the issue, however if that's the case I now have lots of upcoming 
duplicates showing in my scheduled recordings ...


Kind Regards,

Nige.


tv_grab_sd_json output


   <programme start="20161024160000 +0000" stop="20161024170000 +0000" 
channel="I24305.json.schedulesdirect.org">
     <title>World's Most Dangerous Roads</title>
     <desc>The title says it all, so what's more to add? We'll leave 
that to the presenters as they travel the length and breadth of the 
world to uncover the most dangerous roads known to mankind. In Alaska, 
for example, Sue Perkins and Charley Boorman tackle the notorious Dalton 
Highway, a dirk track supply road that is home to hardcore truckers. 
Rhod Gilbert and Greg Davies attempt to drive through the mountainous, 
landlocked nation of Nepal, and Ben Fogle and Hugh Dennis endure remote 
and dangerous roads in South America in their travels from the Peruvian 
Andes to the Amazon.</desc>
     <credits>
       <producer>Sue Davidson</producer>
       <presenter>Sue Perkins</presenter>
       <presenter>Charley Boorman</presenter>
     </credits>
     <category>Documentary</category>
     <category>Travel</category>
     <category>Series</category>
     <category>tvshow</category>
     <episode-num system="dd_progid">SH014696720000</episode-num>
     <previously-shown start="20110904" />
   </programme>


tv_grab_zz_sdjson_sqlite output


  <programme channel="I24305.json.schedulesdirect.org" 
start="20161024160000 +0000" stop="20161024170000 +0000">
   <title>World's Most Dangerous Roads</title>
   <desc *lang="en-GB"*>The title says it all, so what's more to add? 
We'll leave that to the presenters as they travel the length and breadth 
of the world to uncover the most dangerous roads known to mankind. In 
Alaska, for example, Sue Perkins and Charley Boorman tackle the 
notorious Dalton Highway, a dirk track supply road that is home to 
hardcore truckers. Rhod Gilbert and Greg Davies attempt to drive through 
the mountainous, landlocked nation of Nepal, and Ben Fogle and Hugh 
Dennis endure remote and dangerous roads in South America in their 
travels from the Peruvian Andes to the Amazon.</desc>
   <credits>
    <producer>Sue Davidson</producer>
    <presenter>Sue Perkins</presenter>
    <presenter>Charley Boorman</presenter>
   </credits>
   <category>tvshow</category>
   <category>Documentary</category>
   <category>Travel</category>
   <category>Series</category>
   <category>*Show*</category>
   <episode-num system="dd_progid">*SH01469672.0000*</episode-num>
*<episode-num system="xmltv_ns">  / 3 .  / 16 . </episode-num>*
*<video></video>*
   <previously-shown start="*20110904 +0000*" />
  </programme>


--------------75289DB1ABC752ABF704D941
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=utf-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <p>Hi,</p>
    <p><br>
    </p>
    <p>I'm doing some comparisons between tv_grab_zz_sdjson_sqlite &amp;
      tv_grab_sd_json and their use with MythTV.</p>
    <p><br>
    </p>
    <p>I'm finding that with tv_grab_zz_sdjson_sqlite that the duplicate
      programs within the schedule aren't being recognised and therefore
      MythTV is planning on recording more than one showing of the same
      program.</p>
    <p><br>
    </p>
    <p>Having compared the data (example below) and in MythTV program
      table, it appears that there are only a few subtle differences in
      the output, but one is that the airdate being populated in MythTV
      from the tv_grab_zz_sdjson_sqlite is 0000.  I appreciate that
      tv_grab_zz_sdjson_sqlite is only part of the nightly release at
      present, but is this something that people are aware of as an
      issue?  It might not be what is tripping MythTV up, but it doesn't
      look quite right.  I've taken a look on xmltv-dev and haven't seen
      any mention of this.</p>
    <p><br>
    </p>
    <p>It might be that tv_grab_zz_sdjson_sqlite is fine and
      tv_grab_sd_json has the issue, however if that's the case I now
      have lots of upcoming duplicates showing in my scheduled
      recordings ...<br>
    </p>
    <p><br>
    </p>
    <p>Kind Regards,</p>
    <p>Nige.</p>
    <p><br>
    </p>
    <p>tv_grab_sd_json output</p>
    <p><br>
    </p>
    <p>  &lt;programme start="20161024160000 +0000" stop="20161024170000
      +0000" channel="I24305.json.schedulesdirect.org"&gt;<br>
          &lt;title&gt;World's Most Dangerous Roads&lt;/title&gt;<br>
          &lt;desc&gt;The title says it all, so what's more to add?
      We'll leave that to the presenters as they travel the length and
      breadth of the world to uncover the most dangerous roads known to
      mankind. In Alaska, for example, Sue Perkins and Charley Boorman
      tackle the notorious Dalton Highway, a dirk track supply road that
      is home to hardcore truckers. Rhod Gilbert and Greg Davies attempt
      to drive through the mountainous, landlocked nation of Nepal, and
      Ben Fogle and Hugh Dennis endure remote and dangerous roads in
      South America in their travels from the Peruvian Andes to the
      Amazon.&lt;/desc&gt;<br>
          &lt;credits&gt;<br>
            &lt;producer&gt;Sue Davidson&lt;/producer&gt;<br>
            &lt;presenter&gt;Sue Perkins&lt;/presenter&gt;<br>
            &lt;presenter&gt;Charley Boorman&lt;/presenter&gt;<br>
          &lt;/credits&gt;<br>
          &lt;category&gt;Documentary&lt;/category&gt;<br>
          &lt;category&gt;Travel&lt;/category&gt;<br>
          &lt;category&gt;Series&lt;/category&gt;<br>
          &lt;category&gt;tvshow&lt;/category&gt;<br>
          &lt;episode-num
      system="dd_progid"&gt;SH014696720000&lt;/episode-num&gt;<br>
          &lt;previously-shown start="20110904" /&gt;<br>
        &lt;/programme&gt;<br>
    </p>
    <p><br>
    </p>
    <p>tv_grab_zz_sdjson_sqlite output</p>
    <p><br>
    </p>
    <p> &lt;programme channel="I24305.json.schedulesdirect.org"
      start="20161024160000 +0000" stop="20161024170000 +0000"&gt;<br>
        &lt;title&gt;World's Most Dangerous Roads&lt;/title&gt;<br>
        &lt;desc <b>lang="en-GB"</b>&gt;The title says it all, so
      what's more to add? We'll leave that to the presenters as they
      travel the length and breadth of the world to uncover the most
      dangerous roads known to mankind. In Alaska, for example, Sue
      Perkins and Charley Boorman tackle the notorious Dalton Highway, a
      dirk track supply road that is home to hardcore truckers. Rhod
      Gilbert and Greg Davies attempt to drive through the mountainous,
      landlocked nation of Nepal, and Ben Fogle and Hugh Dennis endure
      remote and dangerous roads in South America in their travels from
      the Peruvian Andes to the Amazon.&lt;/desc&gt;<br>
        &lt;credits&gt;<br>
         &lt;producer&gt;Sue Davidson&lt;/producer&gt;<br>
         &lt;presenter&gt;Sue Perkins&lt;/presenter&gt;<br>
         &lt;presenter&gt;Charley Boorman&lt;/presenter&gt;<br>
        &lt;/credits&gt;<br>
        &lt;category&gt;tvshow&lt;/category&gt;<br>
        &lt;category&gt;Documentary&lt;/category&gt;<br>
        &lt;category&gt;Travel&lt;/category&gt;<br>
        &lt;category&gt;Series&lt;/category&gt;<br>
        &lt;category&gt;<b>Show</b>&lt;/category&gt;<br>
        &lt;episode-num system="dd_progid"&gt;<b>SH01469672.0000</b>&lt;/episode-num&gt;<br>
        <b>&lt;episode-num system="xmltv_ns"&gt;  / 3 .  / 16 . 
        &lt;/episode-num&gt;</b><br>
        <b>&lt;video&gt;&lt;/video&gt;</b><br>
        &lt;previously-shown start="<b>20110904 +0000</b>" /&gt;<br>
       &lt;/programme&gt;<br>
      <br>
    </p>
  </body>
</html>

--------------75289DB1ABC752ABF704D941--


--===============1305688403152827503==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most 
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
--===============1305688403152827503==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
xmltv-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/xmltv-users

--===============1305688403152827503==--