search

tcesni / crossepg

Automatically exported from code.google.com/p/crossepg
GNU Lesser General Public License v2.1
0 stars 0 forks source link

Rytek UK epg shifted by plus one day #40

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1.import Rytec UK xmltv
2.show epg
3.

What is the expected output? What do you see instead?
all events are one day plus missmatch - sunday are shown as monday etc...

What version of crossepg are you using? On what box and on what image?
0.5.2

Please provide any additional information below.
not sure if Rytec data are the problem or something in the process. Opentv data 
for Sky IT is OK

Original issue reported on code.google.com by et3...@atlas.cz on 3 Oct 2010 at 5:18

GoogleCodeExporter commented 8 years ago 
Just forgot: Dreambox 500HD + esata, Gemini 5.1.

Anyone else with same problem?
Thx.

Original comment by et3...@atlas.cz on 3 Oct 2010 at 5:55

GoogleCodeExporter commented 8 years ago 
Hi,
could you download this file http://www.xmltvepg.be/rytec.channels.xml.gz and 
check with an editor if the events start time is correct?

Original comment by skama...@gmail.com on 5 Oct 2010 at 9:19

GoogleCodeExporter commented 8 years ago 
Hi, looking at the file, but see no actual events there - only a list of all 
approx 4000 channels. Sorry, maybe i misunderstood something ...

Original comment by et3...@atlas.cz on 5 Oct 2010 at 3:29

GoogleCodeExporter commented 8 years ago 
sorry man.. wrong link
try this http://www.xmltvepg.be/rytecxmltvuk.gz

Original comment by skama...@gmail.com on 5 Oct 2010 at 3:36

GoogleCodeExporter commented 8 years ago 
Ye, realize that already too :)

And yes, times in the file are correct - i just compared rytecxmltv_uk file 
with the reality:

<programme start="20101005164500 +0100" stop="20101005190000 +0100" 
channel="SkyArts1.uk">
<title lang="en">Dear Mr Fantasy</title>
<desc>A Tribute to Jim Capaldi: A 2007 concert celebrating the life and work of 
the former drummer of 1960s rock band Traffic, featuring artists including Paul 
Weller, Yusuf Islam and Steve Winwood\n\nCategory: Rock</desc>
</programme>

As you can see, it is on today - 5.10.2010.

Now trying the crossepg download once more ... bb soon

Original comment by et3...@atlas.cz on 5 Oct 2010 at 3:48

GoogleCodeExporter commented 8 years ago 
Back: after download it shows as on 6.10.2010, same time... So it is really 
shiffting events +1 day, at least here :)

Maybe I should try enigma2-plugin-extensions-xmltvimport_1.0-r22_mipsel just to 
see if the problems lies elsewhere? But I am not sure if it works at all.

Also, maybe fresh image? But I am bit pessimistic this can help ...

Original comment by et3...@atlas.cz on 5 Oct 2010 at 3:53

GoogleCodeExporter commented 8 years ago 
I tried to reproduce the issue without success.

These are my steps:
root@dm800:/usr/crossepg# rm /hdd/crossepg/*
root@dm800:/usr/crossepg# ./crossepg_downloader -p rytec_uk_xmltv 
05/10/2010 19:39:18 SIFTeam CrossEPG Downloader 0.5.9999 (svn 113) (c) 
2009-2010 Sandro Cavazzoni (http://www.crossepg.com)
05/10/2010 19:39:18 This software is distributed under the terms of the GNU 
General Public License v2
05/10/2010 19:39:18 EPGDB opened (root=/hdd/crossepg)
05/10/2010 19:39:18 Clearing old aliases...
05/10/2010 19:39:18 Loaded 0 aliases
05/10/2010 19:39:18 Adding new aliases...
05/10/2010 19:39:18 Completed
05/10/2010 19:39:18 Provider rytec_uk_xmltv indentified as xmltv
05/10/2010 19:39:18 Channels url: http://www.xmltvepg.be/rytec.channels.xml.gz
05/10/2010 19:39:18 Events url: http://www.xmltvepg.be/rytecxmltvuk.gz
05/10/2010 19:39:18 Preferred language: eng
05/10/2010 19:39:18 HTTP Get (host:www.xmltvepg.be, port:80, 
page:rytec.channels.xml.gz)
05/10/2010 19:39:19 Downloaded 49273 bytes
05/10/2010 19:39:19 Deflating rytec.channels.xml.gz
05/10/2010 19:39:19 File deflated
05/10/2010 19:39:19 Reading channels from /hdd/crossepg/crossepg.tmp.Fna2sD
05/10/2010 19:39:21 Read 3957 channels
05/10/2010 19:39:21 HTTP Get (host:www.xmltvepg.be, port:80, 
page:rytecxmltvuk.gz)
05/10/2010 19:39:32 Downloaded 1701769 bytes
05/10/2010 19:39:32 Deflating rytecxmltvuk.gz
05/10/2010 19:39:34 File deflated
05/10/2010 19:39:34 Parsing /hdd/crossepg/crossepg.tmp.2U0PxP
05/10/2010 17:46:13 Read 49977 events
05/10/2010 17:46:17 Data saved
05/10/2010 17:46:17 EPGDB closed
root@dm800:/usr/crossepg# ./crossepg_exporter /hdd/test.csv
05/10/2010 19:46:58 SIFTeam CrossEPG Exporter 0.5.9999 (svn 113) (c) 2009-2010 
Sandro Cavazzoni (http://www.crossepg.com)
05/10/2010 19:46:58 This software is distributed under the terms of the GNU 
General Public License v2
05/10/2010 19:46:58 EPGDB opened (root=/hdd/crossepg)
05/10/2010 19:47:00 Exporting data into /hdd/test.csv
05/10/2010 19:48:02 Exported 88300 events

After that i opened the csv and the xmltv and i compared some events:

<programme start="20101005060000 +0100" stop="20101005061000 +0100" 
channel="Five.uk">
<title lang="en">Thomas Friends (R) (T)</title>
<desc>Thomas sees a rainbow while taking workmen to fix damaged telephone 
lines.</desc>
</programme>
<programme start="20101005061000 +0100" stop="20101005062000 +0100" 
channel="Five.uk">
<title lang="en">Roary the Racing Car (R) (T)</title>
<desc>Flash grows tired of the constant roar of engines and decides to divert 
the cars off the track.</desc>
</programme>
<programme start="20101005062000 +0100" stop="20101005063500 +0100" 
channel="Five.uk">
<title lang="en">The Adventures of Bottle Top Bill and His Best Friend Corky 
(R) (T)</title>
<desc>Cedric's latest invention turns out to be a handful for Bill and 
Corky.</desc>
</programme>

2, 2045, 6335, 1286254800, 600, "Thomas Friends (R) (T)", "Thomas sees a 
rainbow while taking workmen to fix damaged telephone lines.", "eng", 1, 55475, 
0, 1, 0
2, 2045, 6335, 1286255400, 600, "Roary the Racing Car (R) (T)", "Flash grows 
tired of the constant roar of engines and decides to divert the cars off the 
track.", "eng", 2, 55475, 0, 1, 0
2, 2045, 6335, 1286256000, 900, "The Adventures of Bottle Top Bill and His Best 
Friend Corky (R) (T)", "Cedric's latest invention turns out to be a handful for 
Bill and Corky.", "eng", 3, 55475, 0, 1, 0

The three timestamps are:
1286254800 -> Tue, 05 Oct 2010 05:00:00 GMT
1286255400 -> Tue, 05 Oct 2010 05:10:00 GMT
1286256000 -> Tue, 05 Oct 2010 05:20:00 GMT

Crossepg and enigma2 internally work always on gmt+0 without daylight saving.
So.. taking xmltv times less one hour of daylight we have the same values.

Could you test again with the same procedure used by me?

Original comment by skama...@gmail.com on 5 Oct 2010 at 6:08

GoogleCodeExporter commented 8 years ago 
The exporter exist only on latest svn 113

Original comment by skama...@gmail.com on 5 Oct 2010 at 6:10

GoogleCodeExporter commented 8 years ago 
Thx. Will try some of it tommorow. Not sure how to get 113 though.
My box might be just drinking too much :) Maybe I will try clean Gemini 5.1 
when not succesful with your procedure...

Original comment by et3...@atlas.cz on 5 Oct 2010 at 6:45

GoogleCodeExporter commented 8 years ago 
I attach here packages for svn 113

Original comment by skama...@gmail.com on 5 Oct 2010 at 6:49

Attachments:

GoogleCodeExporter commented 8 years ago 
Using IPBOX 9000HD E2, and get the same problem of 24 hours out, even using the 
openTV option.

Original comment by ia...@surfeu.ch on 5 Oct 2010 at 7:03

GoogleCodeExporter commented 8 years ago 
could you post your db after a fresh xmltv import?

rm /hdd/crossepg/*
/usr/crossepg/crossepg_downloader -p rytec_uk_xmltv

after that compress the db in /hdd/crossepg and post it to me.

could you also tell me your timezone and daylight saving?

Original comment by skama...@gmail.com on 5 Oct 2010 at 7:14

GoogleCodeExporter commented 8 years ago 
File attached.

time zone is gmt+1 and daylight saving is +1 hour

Original comment by ia...@surfeu.ch on 5 Oct 2010 at 7:31

Attachments:

GoogleCodeExporter commented 8 years ago 
i used crossepg_exporter on your db and events seem to have the exact date and 
time

could you do the same test?

/usr/crossepg/crossepg_exporter /hdd/test.csv

and check the timestamp of events in test.csv ... see some posts above for an 
example

Original comment by skama...@gmail.com on 5 Oct 2010 at 7:57

GoogleCodeExporter commented 8 years ago 
I also attach svn 113 for sh4

Original comment by skama...@gmail.com on 5 Oct 2010 at 7:58

Attachments:

GoogleCodeExporter commented 8 years ago 
Sorry, but I don't have the crossepg_exporter file in my /var/crossepg folder

Original comment by ia...@surfeu.ch on 5 Oct 2010 at 8:13

GoogleCodeExporter commented 8 years ago 
OK, I have just installed 113, will recheck.

Original comment by ia...@surfeu.ch on 5 Oct 2010 at 8:15

GoogleCodeExporter commented 8 years ago 
OK, this is what I get:

<programme start="20101005060000 +0100" stop="20101005061000 +0100" 
channel="Five.uk">
<title lang="en">Thomas Friends (R) (T)</title>
<desc>Thomas sees a rainbow while taking workmen to fix damaged telephone 
lines.</desc>
</programme>
<programme start="20101005061000 +0100" stop="20101005062000 +0100" 
channel="Five.uk">
<title lang="en">Roary the Racing Car (R) (T)</title>
<desc>Flash grows tired of the constant roar of engines and decides to divert 
the cars off the track.</desc>

test.csv:
2, 2045, 6335, 1286254800, 600, "Thomas Friends (R) (T)", "Thomas sees a 
rainbow while taking workmen to fix damaged telephone lines.", "eng", 1, 55475, 
0, 1, 0
2, 2045, 6335, 1286255400, 600, "Roary the Racing Car (R) (T)", "Flash grows 
tired of the constant roar of engines and decides to divert the cars off the 
track.", "eng", 2, 55475, 0, 1, 0
2, 2045, 6335, 1286256000, 900, "The Adventures of Bottle Top Bill and His Best 
Friend Corky (R) (T)", "Cedric's latest invention turns out to be a handful for 
Bill and Corky.", "eng", 3, 55475, 0, 1, 0

But I dont know how to interpret the time date stamp code.

Original comment by ia...@surfeu.ch on 5 Oct 2010 at 8:34

GoogleCodeExporter commented 8 years ago 
You can use this service http://www.onlineconversion.com/unix_time.htm

But they seem corrects. As i told crossepg and enigma2 use the time always in 
gmt+0 without daylight.

I suppose you already did the fix for unpatched images as described here 
http://code.google.com/p/crossepg/wiki/Installation
right?

Original comment by skama...@gmail.com on 5 Oct 2010 at 8:41

GoogleCodeExporter commented 8 years ago 
This is strange, I did the edit the file /etc/init.d/rcS, always have from the 
very beginning.

I have gone back to 0.5.2 svn 99 and everything works fine!!

Original comment by ia...@surfeu.ch on 5 Oct 2010 at 8:46

GoogleCodeExporter commented 8 years ago 
So with 0.5.2 work fine but with latest 0.5.9999 you have events shifted of 24 
hours? Could you confirm that?

Original comment by skama...@gmail.com on 5 Oct 2010 at 8:49

GoogleCodeExporter commented 8 years ago 
Hi, so my results are as follows with the Rytek UK file:

0.5.2 shifted by 24 hours
0.5.9999 OK, no shifting

Well, i just installed 0.5.9999 and it is back to normal as it was with 0.5.0.

Original comment by et3...@atlas.cz on 6 Oct 2010 at 9:16

GoogleCodeExporter commented 8 years ago 
Update: Sorry, stil shifted in 113. I was just confused, that there are some 
events for to days (likely events from yesterday) - with 99 today epg was emty.

Everything simply shifted by one day.

Original comment by et3...@atlas.cz on 6 Oct 2010 at 11:50

GoogleCodeExporter commented 8 years ago 
yes with 0.5.2 OK, 0.5.9999 everything shifted by 24 hours, also on opentv 
import as well.

Original comment by ia...@surfeu.ch on 6 Oct 2010 at 5:13

GoogleCodeExporter commented 8 years ago 
[deleted comment]
GoogleCodeExporter commented 8 years ago 
[deleted comment]
GoogleCodeExporter commented 8 years ago 
[deleted comment]
GoogleCodeExporter commented 8 years ago 
Hi and good evening everybody. I also have this problem with 0.5.9999 svn 113. 
I have both IpBox 9000HD and 900HD. I use PKT 0.9.9 and swedish Rytec epg 
files. Since updating to 0.5.9999 113, I mostly epg info from yesterday, e.g 
today-1. Anyone got a solution for this at the moment? If I would like to 
downgrade to 0.5.2, how do I do this. Also sheduled download gives me some 
problem, if I set download to 06.00 am the automated download starts like at 
10.55 pm! I have set time to GTM+1 and time shows correct on info banner and 
also on display. Nothing changes if I update time, still epg info from 
yesterday is shown, as soon as I switch channel the actual program name changes 
within a second to correct name, also the next program will be corrected but 
all others are still faulty. This never happened with earlier crossepg versions.

Original comment by jannek...@gmail.com on 18 Oct 2010 at 4:39

GoogleCodeExporter commented 8 years ago 
hi guys

has anyone tryed the new version in the source folder ??
can anone complie this version for me , please ???

greetz

Original comment by DaDude...@googlemail.com on 19 Oct 2010 at 1:29

GoogleCodeExporter commented 8 years ago 
ok.. i don't understand if the problem is on data import or in db conversion. I 
checked the code many times without success... it seem all fine.

could you check again if epgdb is valid? I made a diagnostic utility to load db 
from a pc and check easly his content.

http://code.google.com/p/crossepg/downloads/detail?name=CrossEPG%20Explorer%201.
0.0%20Setup.exe

could you tell me if data showed with this utility are corrects?

Original comment by skama...@gmail.com on 19 Oct 2010 at 11:58

GoogleCodeExporter commented 8 years ago 
I retain it fixed in svn 125
http://code.google.com/p/crossepg/downloads/list

Let me know please

Original comment by skama...@gmail.com on 31 Oct 2010 at 1:22

GoogleCodeExporter commented 8 years ago 
[deleted comment]
GoogleCodeExporter commented 8 years ago 
OK, got it installed and seems to now be working, using the Rytec download

Original comment by ia...@surfeu.ch on 31 Oct 2010 at 8:01

GoogleCodeExporter commented 8 years ago 
good.. i mark the issue as fixed

Original comment by skama...@gmail.com on 31 Oct 2010 at 8:25

GoogleCodeExporter commented 8 years ago 
Hi, indeed, fixed.

Thx.

Original comment by et3...@atlas.cz on 31 Oct 2010 at 11:08