Reply to thread

Message

<blockquote data-quote="GSteele" data-source="post: 189724" data-attributes="member: 19552">XMLTV Timezone ImportHi, The xmltv importer seems to try to do the right thing but it's logic has the signs the wrong way round.eg&lt;programme start=&quot;20071010093000 +0000&quot; stop=&quot;20071010103000 +0000&quot; channel=&quot;Nine&quot;&gt;&nbsp; &lt;title&gt;McLeod's Daughters&lt;/title&gt; This program is on at 1930 on the 10/10 in my local timezone of +10 GMT. 0930 GMT (+0000) is 1930 (+10 GMT). What the importer is doing is actually doing the conversion the wrong way round. It's subtracting 10 hours from the +0000 timezone rather than adding 10 hours. The program ends up in the guide at 23:30 on the 9/10 which is simply taking the 10 hours I'm ahead and subracting them rather than adding the 10 hours. To get the GMT time (or any other guide timezone) to the local timezone you need to add to the base time what ever my regional timeoffset is minus the base guide timezone. Sorry if I'm telling you something you already know but I'm not sure why your import works for 2 different Timezones but mine doesn't.eg GuideTime = 0930&nbsp; &nbsp;&nbsp; GuideDate = 10/10/2007&nbsp; &nbsp;&nbsp; GuideTimeZoneOffset= +0000&nbsp; &nbsp;&nbsp; LocalTimeZoneOffset = +1000GuideTime +(LocalTimeZoneOffset - GuideTimeZoneOffet) = LocalTime0930 + (1000 - 0000) = 0930 + 1000 = 1930 (+1000)2nd eg GuideTime = 0930&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GuideDate = 10/10/2007&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GuideTimeZoneOffset= +0100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LocalTimeZoneOffset = -0400GuideTime +(LocalTimeZoneOffset - GuideTimeZoneOffet) = LocalTime0930 + (-0400 - +0100) = 0930 - 0500 = 0430 (-0400)OK I conceed that I can't figure out any formula to explain how you can import GMT &amp; GMT +0100 guides and get the right times when I get the wrong. As, if your guide data had a Program 0930 +0000 (which should display at 1030 (+0100) in belgium). If your's behaves the same way as mine it should import 0930 +0000 to 0830 in belgium. Unless your guide data has it's timezone localised when it's generated rather than when it's imported?Thanks for any assistance you can give.</blockquote>

[QUOTE="GSteele, post: 189724, member: 19552"] [b]XMLTV Timezone Import[/b] Hi, The xmltv importer seems to try to do the right thing but it's logic has the signs the wrong way round. eg <programme start="20071010093000 +0000" stop="20071010103000 +0000" channel="Nine"> <title>McLeod's Daughters</title> This program is on at 1930 on the 10/10 in my local timezone of +10 GMT. 0930 GMT (+0000) is 1930 (+10 GMT). What the importer is doing is actually doing the conversion the wrong way round. It's subtracting 10 hours from the +0000 timezone rather than adding 10 hours. The program ends up in the guide at 23:30 on the 9/10 which is simply taking the 10 hours I'm ahead and subracting them rather than adding the 10 hours. To get the GMT time (or any other guide timezone) to the local timezone you need to add to the base time what ever my regional timeoffset is minus the base guide timezone. Sorry if I'm telling you something you already know but I'm not sure why your import works for 2 different Timezones but mine doesn't. eg GuideTime = 0930 GuideDate = 10/10/2007 GuideTimeZoneOffset= +0000 LocalTimeZoneOffset = +1000 GuideTime +(LocalTimeZoneOffset - GuideTimeZoneOffet) = LocalTime 0930 + (1000 - 0000) = 0930 + 1000 = 1930 (+1000) 2nd eg GuideTime = 0930 GuideDate = 10/10/2007 GuideTimeZoneOffset= +0100 LocalTimeZoneOffset = -0400 GuideTime +(LocalTimeZoneOffset - GuideTimeZoneOffet) = LocalTime 0930 + (-0400 - +0100) = 0930 - 0500 = 0430 (-0400) OK I conceed that I can't figure out any formula to explain how you can import GMT & GMT +0100 guides and get the right times when I get the wrong. As, if your guide data had a Program 0930 +0000 (which should display at 1030 (+0100) in belgium). If your's behaves the same way as mine it should import 0930 +0000 to 0830 in belgium. Unless your guide data has it's timezone localised when it's generated rather than when it's imported? Thanks for any assistance you can give. [/QUOTE]

Verification