<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sun, 5 Sept 2021 at 09:23, John <<a href="mailto:jksjdevelop@gmail.com">jksjdevelop@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
  
    
  
  <div>
    <div>I too converted cross-eit to use Python 3 and it is currently
      working fine for me.<br></div>
    <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></div></blockquote><div><br></div><div>I remember having to do the same change manually, probably following your advice here on the list.</div><div><br></div><div>I have not fixed it so that it would do the change by itself. If I get it to work again, I probably should. (Writing an if statement with last Sunday in March / last Sunday in October---seems dumb but ought to work.)</div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div>
    <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></div></blockquote><div><br></div><div>In any case, your query gives the following on my system right now:</div><div><br></div><div><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">mysql> select serviceid,chanid,channum,sourceid,callsign from channel where callsign like("%Channel 4 HD%") ;</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+-----------+--------+---------+----------+--------------+</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">| serviceid | chanid | channum | sourceid | callsign <span class="gmail-Apple-converted-space">    </span>|</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+-----------+--------+---------+----------+--------------+</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">| <span class="gmail-Apple-converted-space">    </span>21200 |<span class="gmail-Apple-converted-space">  </span>22200 | 21200 <span class="gmail-Apple-converted-space">  </span>|<span class="gmail-Apple-converted-space">        </span>1 | Channel 4 HD |</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">| <span class="gmail-Apple-converted-space">    </span>21200 |<span class="gmail-Apple-converted-space">  </span>31200 | 21200 <span class="gmail-Apple-converted-space">  </span>|<span class="gmail-Apple-converted-space">        </span>1 | Channel 4 HD |</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">+-----------+--------+---------+----------+--------------+</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">2 rows in set (0.01 sec)</span></p>
<br class="gmail-Apple-interchange-newline"></div><div>I am not sure why I get two. Maybe a relic of multiple scans? No clue which is the "correct" one (if either is).</div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div>
    <p>I use the same mythfilldatabase command</p>
    <p><span>/usr/bin/mythfilldatabase --refresh-all
        --verbose xmltv --file --sourceid 1 --xmlfile /tmp/export.xml</span></p>
    <p><span>So presuming sourceid is correct it should
        work.</span></p>
    <p><span>What has changed recently on your system?</span></p>
    <p><span>Have you recently scanned?<br></span></p></div></blockquote><div>For some definition of recently, yes (a few months ago).</div><div><br></div><div>I hate rescanning because it always messes up so much stuff. I did it because I thought I was missing some channels that might have moved around.</div><div><br></div><div>Certainly the Channel 4 HD was no longer working after that; but I forget if it was still working just before.</div></div></div>