<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:21, Stephen Worthington <<a href="mailto:stephen_agent@jsw.gen.nz">stephen_agent@jsw.gen.nz</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"><br>
The list archive site is now here:<br>
<br>
<a href="https://lists.archive.carbon60.com/mythtv/" rel="noreferrer" target="_blank">https://lists.archive.carbon60.com/mythtv/</a><br>
<br>
but it does not seem to have your Python 3 version of cross-eit.py,<br>
and Google does not find it either. So please repost it, and I will<br>
have a go running it and see if I can see anything.<br></blockquote><div><br></div><div>Thanks. I reposted it now (with headers from the original message, showing that the new list archive is missing at least that post and probably others).</div><div><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">The mythfilldatabase output you posted is quite explicit in the error<br>
it is finding: "Unknown xmltv channel identifier: Channel - Skipping<br>
channel." Is that still the error you are getting?</blockquote><div><br></div><div>Yes: that's as far as I got in my debugging---narrowing it down to that, so I posted just the relevant line after figuring it out. But I could not discover why.</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"> If so, the<br>
xmltvid in the .xml file you are importing is not matching anything in<br>
the database. What is the output of:<br>
<br>
head /tmp/export.xml<br></blockquote><div><br></div><div>It appears that the data is all in one line so it's monstruously long, but the first few screen lines go like this:</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">$ head /tmp/export.xml<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"><?xml version="1.0" ?></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"><!DOCTYPE tv SYSTEM "xmltv.dtd"></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"><tv><programme channel="<a href="http://hd.channel4.com">hd.channel4.com</a>" start="20210821015000" stop="20210821022000"><title>Come Dine with Me</title><sub-title>Yeovil</sub-title><desc>PR manager Emmy hopes to impress her guests with locally sourced Somerset produce. But she has a disaster with her hollandaise sauce. (Ep1/5)</desc><category>Entertainment</category></programme><programme channel="<a href="http://hd.channel4.com">hd.channel4.com</a>" start="20210821022000" stop="20210821024500"><title>Come Dine with Me</title><sub-title>Yeovil</sub-title><desc>Radio DJ Steve serves up a cross between comfort food and fine dining. But he feels the pressure, and an unwanted ingredient ends up on one guest's plate. (Ep2/5)</desc><category>Entertainment</category></programme><program</span></p></div><div> </div><div>I can see the "<a href="http://hd.channel4.com">hd.channel4.com</a>" in there, which I assume has been generated by the command line parameter I supplied to cross-eit.</div><div><br></div><div>I copied from stuff I did years ago, based on advice from kind people on the list, and which worked then. I am not sure where this particular identifier came from in the first place. When I looked at the table of all channels in mythweb, this channel seemed to be the only one with an xmltvid.</div><div><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">
<br>
Is there only one channel showing in the headers at the top of the<br>
file?</blockquote><div><br></div><div>yes</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"> If you cut and paste the xmltvid from there into this query, is<br>
that xmltvid found in the database?<br></blockquote><div><br></div><div>yes</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">
<br>
select sourceid,chanid,channum,name,callsign,xmltvid from channel<br>
where xmltvid='<paste here>';<br></blockquote><div><br></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 sourceid,chanid,channum,name,callsign,xmltvid from channel</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>-> where xmltvid='<a href="http://hd.channel4.com">hd.channel4.com</a>';</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">| sourceid | chanid | channum | name <span class="gmail-Apple-converted-space"> </span>| callsign <span class="gmail-Apple-converted-space"> </span>| xmltvid <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>1 |<span class="gmail-Apple-converted-space"> </span>22200 | 21200 <span class="gmail-Apple-converted-space"> </span>| Channel 4 HD | Channel 4 HD | <a href="http://hd.channel4.com">hd.channel4.com</a> |</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">1 row in set (0.00 sec)</span></p>
<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0);min-height:13px"><span style="font-variant-ligatures:no-common-ligatures"></span><br></p>
<br class="gmail-Apple-interchange-newline"><div><br></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">
<br>
If found, does the sourceid for the channel match the sourceid you are<br>
using in the mythfilldatabase command?<br></blockquote><div><br></div><div>yes: the command used was</div><div><br></div><div><span style="color:rgb(80,0,80)">/usr/bin/mythfilldatabase --refresh-all --verbose xmltv --file --sourceid 1 --xmlfile /tmp/export.xml</span></div></div></div>