<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, 9 Sept 2021 at 18:29, 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"><br>
Ok I have done some testing.<br>
<br>
The EPG is certainly being stored in the database as UTC so the News <br>
which is shown at 19:00 BST is stored as starting at 18:00.<br>
<br>
The old version of cross-eit with date = dateobj + <br>
datetime.timedelta(seconds=time.altzone) writes the correct times to the <br>
database during BST.<br>
<br>
JSW version with start="20210915190000 +0000" writes incorrect times to <br>
the database.<br>
<br>
Nemo version with start="20210915180000 +0000" writes correct times to <br>
the database during BST.<br></blockquote><div><br></div><div><br></div><div>I am still getting off-by-one-hour failures, though only for SOME channel 4 HD recordings, not all, and this is all very confusing. I have also been doing some debugging but I can't figure out where this extra hour difference comes from. Here is what I've got to so far.</div><div><br></div><div>Ground truth: Karate Kid II was broadcast on Channel 4 HD today (2021-09-12) starting at 1350 UTC+1. </div><div>Indeed the channel 4 website says, at <a href="https://www.channel4.com/programmes/the-karate-kid-part-ii">https://www.channel4.com/programmes/the-karate-kid-part-ii</a> , "<span style="color:rgb(179,179,179);font-family:"4text.regular.punctuation","4text.regular.currency","4text.regular.maths","4text.regular.lowercase","4text.regular.uppercase","4text.regular.numbers","Trebuchet MS","Lucida Sans Unicode","Lucida Grande","Lucida Sans",Arial,sans-serif;font-size:14px;white-space:nowrap;background-color:rgb(30,30,30)">Sun 12 Sep, 1.50pm</span>"</div><div><br></div><div>It appeared in my Myth schedule (using the old cross-eit at <a href="https://pastebin.com/d51VUASq" target="_blank">https://pastebin.com/d51VUASq</a> ) as starting at 1450, hence still with the error. The recording scheduled from the myth GUI would have missed the first hour.</div><div><br></div><div>The above "old" cross-eit produced</div><div><br></div><div><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(157,32,111)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)"><</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(74,0,255)">programme</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)"> </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(193,101,28)">channel</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)">=</span><span style="font-variant-ligatures:no-common-ligatures">"<a href="http://hd.channel4.com">hd.channel4.com</a>"</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)"> </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(193,101,28)">star</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(193,101,28)">t</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)">=</span><span style="font-variant-ligatures:no-common-ligatures">"20210912135000"</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)"> </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(193,101,28)">stop</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)">=</span><span style="font-variant-ligatures:no-common-ligatures">"20210912160000"</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)">><</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(74,0,255)">title</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)">>The </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(160,205,255);background-color:rgb(161,0,163)">Karate Kid </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)">Part II</</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(74,0,255)">title</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)">></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13"><font color="#000000"><span style="caret-color: rgb(0, 0, 0);">(start time correct IFF you assume UTC+1; incorrect in UTC+0)</span></font></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13"><font color="#000000"><span style="caret-color: rgb(0, 0, 0);"><br></span></font></p><p style="margin:0px;font-stretch:normal;line-height:normal"><font color="#9d206f" face="fixedX6x13"><span style="caret-color: rgb(157, 32, 111);">T</span></font><span style="color:rgb(34,34,34);font-family:Arial,Helvetica,sans-serif;font-size:small">he JSW 2.0 cross-eit produced</span><br></p></div><div><br></div><div><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(157,32,111)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)"><span class="gmail-Apple-converted-space"> </span><</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(74,0,255)">programme</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)"> </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(193,101,28)">channel</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)">=</span><span style="font-variant-ligatures:no-common-ligatures">"<a href="http://hd.channel4.com">hd.channel4.com</a>"</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)"> </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(193,101,28)">start</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)">=</span><span style="font-variant-ligatures:no-common-ligatures">"20210912135000"</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)"> </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(193,101,28)">stop</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)">=</span><span style="font-variant-ligatures:no-common-ligatures">"20210912160</span><span style="font-variant-ligatures:no-common-ligatures">000"</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,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"><span class="gmail-Apple-converted-space"> </span><</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(74,0,255)">title</span><span style="font-variant-ligatures:no-common-ligatures">>The Karate Kid Part II</</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(74,0,255)">title</span><span style="font-variant-ligatures:no-common-ligatures">></span></p><p style="font-size:13px;margin:0px;font-stretch:normal;line-height:normal;font-family:fixedX6x13"><font color="#000000">(start time correct IFF you assume UTC+1; incorrect in UTC+0)</font></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"><br class="gmail-Apple-interchange-newline"></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">The JSW 2.1 cross-eit produced</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"><br></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(157,32,111)"><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)"><span class="gmail-Apple-converted-space"> </span><</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(74,0,255)">programme</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)"> </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(193,101,28)">channel</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)">=</span><span style="font-variant-ligatures:no-common-ligatures">"<a href="http://hd.channel4.com">hd.channel4.com</a>"</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)"> </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(193,101,28)">start</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)">=</span><span style="font-variant-ligatures:no-common-ligatures">"20210912135000 +0000"</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)"> </span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(193,101,28)">stop</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,0)">=</span><span style="font-variant-ligatures:no-common-ligatures">"20210</span><span style="font-variant-ligatures:no-common-ligatures">912160000 +0000"</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(0,0,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"><span class="gmail-Apple-converted-space"> </span><</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(74,0,255)">title</span><span style="font-variant-ligatures:no-common-ligatures">>The Karate Kid Part II</</span><span style="font-variant-ligatures:no-common-ligatures;color:rgb(74,0,255)">title</span><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">
(start time in UTC+0 that's definitely incorrect: if anything it ought to be 1250)</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 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);min-height:13px">Last night, a cron job ran these two commands:</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"><br></p><p style="font-size:13px;margin:0px;font-stretch:normal;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">/home/tv/bin/cross-eit.py -o /tmp/export.xml 19211,"<a href="http://hd.channel4.com">hd.channel4.com</a>"</span></p><p style="font-size:13px;margin:0px;font-stretch:normal;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures">/usr/bin/mythfilldatabase --refresh-all --verbose xmltv --file --sourceid 1 --xmlfile /tmp/export.xml</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"><br class="gmail-Apple-interchange-newline"></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">and the first of them produced this file (still untouched)...</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"><br></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">-rw-rw-r-- 1 tv tv 216039 Sep 12 04:30 /tmp/export.xml</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">
</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">and the following database content:</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"><br></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">mysql> select p.chanid, <a href="http://c.name">c.name</a>, p.starttime, p.endtime, p.title from program as p, channel as c where p.chanid=c.chanid and p.title like("%karate kid part ii");</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">| chanid | name <span class="gmail-Apple-converted-space"> </span>| starttime <span class="gmail-Apple-converted-space"> </span>| endtime <span class="gmail-Apple-converted-space"> </span>| title<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>18320 | Channel 4<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 12:50:00 | 2021-09-12 15:00:00 | The Karate Kid Part II |</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>19211 | Channel 4<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 12:50:00 | 2021-09-12 15:00:00 | The Karate Kid Part II |</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>19212 | Channel 4<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 12:50:00 | 2021-09-12 15:00:00 | The Karate Kid Part II |</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>19213 | Channel 4<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 12:50:00 | 2021-09-12 15:00:00 | The Karate Kid Part II |</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>19214 | Channel 4<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 12:50:00 | 2021-09-12 15:00:00 | The Karate Kid Part II |</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>19216 | Channel 4<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 12:50:00 | 2021-09-12 15:00:00 | The Karate Kid Part II |</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>18311 | Channel 4+1<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 13:50:00 | 2021-09-12 16:00:00 | The Karate Kid Part II |</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>18312 | Channel 4+1<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 13:50:00 | 2021-09-12 16:00:00 | The Karate Kid Part II |</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>18314 | Channel 4+1<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 13:50:00 | 2021-09-12 16:00:00 | The Karate Kid Part II |</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>18316 | Channel 4+1<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 13:50:00 | 2021-09-12 16:00:00 | The Karate Kid Part II |</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>31200 | Channel 4 HD | 2021-09-12 12:50:00 | 2021-09-12 15:00:00 | The Karate Kid Part II |</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">11 rows in set (0.29 sec)</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">
<br class="gmail-Apple-interchange-newline"></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)">Here the start time on channels 19211 and 31200 is 1250 rather than 1350, but if it's true that the database always contains UTC+0 then that's fine, that would be equivalent to 1350 UTC+1, hence still the correct time. Yet the GUI showed a start time of 1450. Why??</p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><br></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><br></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)">Further experimentation: I then imported the xml produced by JSW 2.1 (the one with a start time of 1350 UTC+0, which is INCORRECT) with the following command:</p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><br></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>/usr/bin/mythfilldatabase --refresh-all --verbose xmltv --file --sourceid 1 --xmlfile export-jsw21.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"><span class="gmail-Apple-converted-space"><br></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 class="gmail-Apple-converted-space">and, after that, the same query resulted in</span></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)">
<br class="gmail-Apple-interchange-newline"></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">mysql> select p.chanid, <a href="http://c.name">c.name</a>, p.starttime, p.endtime, p.title from program as p, channel as c where p.chanid=c.chanid and p.title like("%karate kid part ii");</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">| chanid | name <span class="gmail-Apple-converted-space"> </span>| starttime <span class="gmail-Apple-converted-space"> </span>| endtime <span class="gmail-Apple-converted-space"> </span>| title<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>31200 | Channel 4 HD | 2021-09-12 13:50:00 | 2021-09-12 16:00:00 | The Karate Kid Part II |</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>18320 | Channel 4<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 12:50:00 | 2021-09-12 15:00:00 | The Karate Kid Part II |</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>19211 | Channel 4<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 12:50:00 | 2021-09-12 15:00:00 | The Karate Kid Part II |</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>19212 | Channel 4<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 12:50:00 | 2021-09-12 15:00:00 | The Karate Kid Part II |</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>19213 | Channel 4<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 12:50:00 | 2021-09-12 15:00:00 | The Karate Kid Part II |</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>19214 | Channel 4<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 12:50:00 | 2021-09-12 15:00:00 | The Karate Kid Part II |</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>19216 | Channel 4<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 12:50:00 | 2021-09-12 15:00:00 | The Karate Kid Part II |</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>18311 | Channel 4+1<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 13:50:00 | 2021-09-12 16:00:00 | The Karate Kid Part II |</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>18312 | Channel 4+1<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 13:50:00 | 2021-09-12 16:00:00 | The Karate Kid Part II |</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>18314 | Channel 4+1<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 13:50:00 | 2021-09-12 16:00:00 | The Karate Kid Part II |</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>18316 | Channel 4+1<span class="gmail-Apple-converted-space"> </span>| 2021-09-12 13:50:00 | 2021-09-12 16:00:00 | The Karate Kid Part II |</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">11 rows in set (0.29 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><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)">You will note that now 19211 stays at 1250 (correct in UTC+0) but 31200 has gone to 1350 (incorrect in UTC+0, although unsurprising as that's what the xml said). Now what does the GUI say? The program guide still says the start time is 1450 local time (incorrect).</p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><br></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)">My unanswered questions:</p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><br></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)">1) why, if the imported XML says 1350 (not qualified with a time zone), mythfilldatabase translates that to 1250 UTC+0?</p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)">(Educated guess: because myth assumes that an unqualified date is in local time, which would make a lot of sense. But then, if myth is smart enough to translate from local time to UTC, why do we ever have off-by-one errors? By this logic, these should never occur.)</p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><br></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)">2) why does cross-eit JSW 2.1 output 1350 UTC+0 into the XML if the EIT stored in the database (already in UTC+0) says 1250? Shouldn't cross-eit just repeat 1250 and just add UTC+0?</p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><br></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)">3) what's the proper way to fix all this? I can add and subtract 1 hour as well as anyone else, but by now it's totally unclear under which circumstances it should be done.</p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)"><br></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:fixedX6x13;color:rgb(0,0,0)">4) is there a way to see (and possibly even log) what the on-air EIT originally said, before being imported in the database as UTC+0? Did the EIT mention a time zone or was it in local time?</p></div></div></div>