<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">On 05/09/2021 08:54, UB40D via
      mythtv-users wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAJ=aGtHaR_HZ8=pAzkwXwBryVVjwn2qdsp+peVU2sCM01uaBTQ@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div dir="ltr"><br>
        </div>
        <br>
        <div class="gmail_quote">
          <blockquote class="gmail_quote" style="margin:0px 0px 0px
            0.8ex;border-left:1px solid
            rgb(204,204,204);padding-left:1ex">
            <div dir="ltr">
              <div class="gmail_quote">
                <div>mysql> select
                  chanid,channum,sourceid,callsign,name from channel
                  where xmltvid='<a href="http://hd.channel4.com"
                    target="_blank" moz-do-not-send="true">hd.channel4.com</a>';<br>
+--------+---------+----------+--------------+--------------+<br>
                  | chanid | channum | sourceid | callsign     | name  
                        |<br>
+--------+---------+----------+--------------+--------------+<br>
                  |  22200 | 21200   |        1 | Channel 4 HD | Channel
                  4 HD |<br>
+--------+---------+----------+--------------+--------------+<br>
                </div>
                <div><br>
                </div>
              </div>
            </div>
          </blockquote>
          <div><br>
          </div>
          <div>BTW is there any significance to the fact that chanid and
            channum are not the same? Should they be? What's the
            difference between the two? <br>
          </div>
        </div>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <pre class="moz-quote-pre" wrap="">_______________________________________________
mythtv-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://lists.mythtv.org/mailman/listinfo/mythtv-users">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a>
<a class="moz-txt-link-freetext" href="http://wiki.mythtv.org/Mailing_List_etiquette">http://wiki.mythtv.org/Mailing_List_etiquette</a>
MythTV Forums: <a class="moz-txt-link-freetext" href="https://forum.mythtv.org">https://forum.mythtv.org</a>
</pre>
    </blockquote>
    <p>I too converted cross-eit to use Python 3 and it is currently
      working fine for me.</p>
    <p>I have to edit the file when the clocks change as the line</p>
    <p>date = dateobj + datetime.timedelta(seconds=time.altzone)</p>
    <p>doesn't cope with the time change, do you have a fix?</p>
    <p>As to your problem .</p>
    <p>The 'chanid' value changes after every scan so i use something
      like.</p>
    <p>select serviceid,chanid,channum,sourceid,callsign from channel
      where callsign like("%Channel 4 HD%") ;</p>
    <p>to get the correct value, however you have a valid xml file so
      that should not be the issue.</p>
    <p>I use the same mythfilldatabase command</p>
    <p><span class="gmail-im">/usr/bin/mythfilldatabase --refresh-all
        --verbose xmltv --file --sourceid 1 --xmlfile /tmp/export.xml</span></p>
    <p><span class="gmail-im">So presuming sourceid is correct it should
        work.</span></p>
    <p><span class="gmail-im">What has changed recently on your system?</span></p>
    <p><span class="gmail-im">Have you recently scanned?<br>
      </span></p>
  </body>
</html>