<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sun, 29 Dec 2019 at 16:37, 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:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p> </p>
<div>On Freesat Channel 4 HD does indeed have no EIT
</div></div></blockquote><div><br></div><div>Argh! Weird and unexpected, but this explains things!<br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div><p>One solution is to copy the EIT from channel 4 using <a href="https://www.mythtv.org/wiki/Cross-eit.py" target="_blank">https://www.mythtv.org/wiki/Cross-eit.py</a></p>
<p>I run this once a day using cron<br></p></div></div></blockquote><div><br></div><div>Thanks very much for this tip.</div><div><br></div><div>I have managed to extract a channel number for channel 4 as follows:</div><div><br></div><div>mysql -u tv -p mythconverg -e "SELECT chanid,callsign from channel WHERE callsign='Channel 4'"<br>Enter password: <br>+--------+-----------+<br>| chanid | callsign |<br>+--------+-----------+<br>| 10211 | Channel 4 |<br>| 10212 | Channel 4 |<br>| 10213 | Channel 4 |<br>| 10214 | Channel 4 |<br>| 10216 | Channel 4 |<br>| 9320 | Channel 4 |<br>+--------+-----------+</div><div><br></div><div>(I have no idea why I have so many; this happens with several other channels too, even when I restart from a clean scan)</div><div><br></div><div>Anyway, I plugged the first of these numbers into a command line for cross-eit, as follows, and I managed to produce an xml file:</div><div><br></div><div> ./cross-eit.py -o /tmp/export.xml "10211,Channel 4 HD" <br></div><div><br></div><div>...and I confirm the file had stuff that looked sensible; however I was not able to import it into the database. What I tried was</div><div><br></div><div>mythfilldatabase --refresh-all --verbose xmltv --file --sourceid 1 --xmlfile /tmp/export.xml <br>****************************************************<br> WARNING: --refresh-all has been deprecated<br> use --refresh instead<br>****************************************************<br><br>2019-12-29 18:02:24.010591 C mythfilldatabase version: fixes/29 [v29.1-40-g951f1fe] <a href="http://www.mythtv.org">www.mythtv.org</a><br>2019-12-29 18:02:24.010611 C Qt version: compile: 5.5.1, runtime: 5.9.5<br>2019-12-29 18:02:24.010615 N Enabled verbose msgs: general xmltv<br>2019-12-29 18:02:24.010627 N Setting Log Level to LOG_INFO<br>2019-12-29 18:02:24.021071 I Bypassing grabbers, reading directly from file<br>2019-12-29 18:02:24.021656 I Setup Interrupt handler<br>2019-12-29 18:02:24.021671 I Setup Terminated handler<br>2019-12-29 18:02:24.021679 I Setup Segmentation fault handler<br>2019-12-29 18:02:24.021689 I Setup Aborted handler<br>2019-12-29 18:02:24.021713 I Setup Bus error handler<br>2019-12-29 18:02:24.021723 I Setup Floating point exception handler<br>2019-12-29 18:02:24.021731 I Setup Illegal instruction handler<br>2019-12-29 18:02:24.021743 I Setup Real-time signal 0 handler<br>2019-12-29 18:02:24.021754 I Setup Hangup handler<br>2019-12-29 18:02:24.021801 I Added logging to the console<br>2019-12-29 18:02:24.021877 N Using runtime prefix = /usr<br>2019-12-29 18:02:24.021881 N Using configuration directory = /home/tv/.mythtv<br>2019-12-29 18:02:24.021959 I Assumed character encoding: en_GB.UTF-8<br>2019-12-29 18:02:24.022298 N Empty LocalHostName.<br>2019-12-29 18:02:24.022304 I Using localhost value of sgrizzo<br>2019-12-29 18:02:24.022350 I Start up testing connections. DB localhost, BE , attempt 0, status dbAwake<br>2019-12-29 18:02:25.039701 N Setting QT default locale to en_US<br>2019-12-29 18:02:25.039709 I Current locale en_US<br>2019-12-29 18:02:25.039766 N Reading locale defaults from /usr/share/mythtv//locales/en_us.xml<br>2019-12-29 18:02:25.043599 I Loading en_gb translation for module mythfrontend<br>2019-12-29 18:02:25.044414 I Current MythTV Schema Version (DBSchemaVer): 1348<br>2019-12-29 18:02:25.046092 I MythCoreContext::ConnectCommandSocket(): Connecting to backend server: <a href="http://127.0.0.1:6543">127.0.0.1:6543</a> (try 1 of 1)<br>2019-12-29 18:02:25.046909 I MythCoreContext::CheckProtoVersion(): Using protocol version 91 BuzzOff<br>2019-12-29 18:02:25.047055 I Opening blocking connection to master backend<br>2019-12-29 18:02:25.049521 I Starting process manager<br>2019-12-29 18:02:25.049530 I Starting process signal handler<br>2019-12-29 18:02:25.050315 I Starting IO manager (write)<br>2019-12-29 18:02:25.050524 I Starting IO manager (read)<br>2019-12-29 18:02:25.559565 W No explicit time zone found, guessing implicit UTC! Please consider enhancing the guide source to provide explicit UTC or local time instead.<br>2019-12-29 18:02:25.618284 N Unknown xmltv channel identifier: Channel - Skipping channel.<br>2019-12-29 18:02:25.618303 I Updated programs: 0 Unchanged programs: 0<br>2019-12-29 18:02:25.619910 I Adjusting program database end times.<br>2019-12-29 18:02:25.620058 I 0 replacements made<br>2019-12-29 18:02:25.620061 I Marking generic episodes.<br>2019-12-29 18:02:26.047229 I Found 0<br>2019-12-29 18:02:26.047235 I Extending non-unique programids with multiple parts.<br>2019-12-29 18:02:26.115452 I Found 0<br>2019-12-29 18:02:26.115458 I Fixing missing original airdates.<br>2019-12-29 18:02:26.381737 I Found 0 with programids<br>2019-12-29 18:02:26.558699 I Found 0 without programids<br>2019-12-29 18:02:26.558707 I Marking repeats.<br>2019-12-29 18:02:26.937490 I Found 0<br>2019-12-29 18:02:26.937497 I Unmarking new episode rebroadcast repeats.<br>2019-12-29 18:02:26.959418 I Found 0<br>2019-12-29 18:02:28.289978 I Marking episode first showings.<br>2019-12-29 18:02:32.714980 I Found 75686<br>2019-12-29 18:02:32.714987 I Marking episode last showings.<br>2019-12-29 18:02:37.053638 I Found 60974<br>2019-12-29 18:02:37.063622 I <br>===============================================================<br>| Attempting to contact the master backend for rescheduling. |<br>| If the master is not running, rescheduling will happen when |<br>| the master backend is restarted. |<br>===============================================================<br>2019-12-29 18:02:37.064193 N mythfilldatabase run complete.<br>2019-12-29 18:02:37.064245 I Waiting for threads to exit.</div><div><br></div><div><br></div><div>...but at the end of that I did not find data for Channel 4 HD in the database. What I did was</div><div><br></div><div>manage recordings / schedule recordings / search lists / channels / Channel 4 HD</div><div><br></div><div>and it came up with just the current programme, nothing else.</div><div><br></div><div>Interestingly, in the box with the names of the channels, it appeared as</div><div>21200 Channel 4 HD</div><div><br></div><div>So I tried the whole rigmarole again but with that number in, as in</div><div><br></div><div><br></div><div> ./cross-eit.py -o /tmp/export.xml "10211,21200 Channel 4 HD" <br><br> mythfilldatabase --refresh-all --verbose xmltv --file --sourceid 1 --xmlfile /tmp/export.xml <br></div><div><br></div><div>but it still didn't do me any good.</div><div>What am I missing?<br></div><div><br></div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div><p>
</p>
<p>I vaguely remember the result being one hour offset, presumably
it doesn't handle the clocks changing correctly.</p>
<p>This line may need attention</p>
<p>date = dateobj # + datetime.timedelta(seconds=time.altzone)<br>
</p></div></div></blockquote><div>Thanks. I' ll look into that once I manage to import some schedule data...<br></div><div> </div></div></div>