[mythtv-users] Fwd: Re: channel4 hd has no eit - cross-eit

Mon Dec 30 12:38:58 UTC 2019

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

There are more than one instance of Channel 4 due to the regional 
versions, you can look up yours on

https://en.kingofsat.net/freqs.php?&pos=28.2E&standard=All&ordre=freq&filtre=Clear

Did you follow this step as described in cross-eit

If you want to import the EPG data from the xml file using 
mythfilldatabase, you must add the appropriate xmltvid for each channel 
you want to import EPG to in mythweb [2] as well as uncheck the 
useonairguide for these channels.

Using the mythweb settings - TV - Channel Info

Set the xmltvid  to  Channel 4 HD

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20191230/d89b34da/attachment.htm>