HSTV Grid ignores Time zone chane

[trcobb]

Today, after time was set back one hour, HSTV remains an hour behind real time on grid display and reminders.

I tried removing the xml files and re-importing the data, no luck.

Any other pointers? Perhaps this should become a sticky subject since it happens every 6 months.

Thanks!

T

[firtha]

This may be related, or not:

Today, after the time change, all my record events are occurring one hour LATE. I don't recall seeing this problem in other DST changes.

I haven't tried to fix anything; I'm hoping tomorrow that all is OK

[huggy591]

You can re-import all days after Sunday and they should line up properly. I've done that here and had no problems.

[trcobb]

firtha, that's what I'm seeing.

Gordon, I killed the xml files, downloaded, and imported, and the grid still displays an hour behind actual programming.

Anything else to try?

[CFGuy]

To do a reimport you would need to delete the data in the tvlistings table before you start the import function. Once the data is in the database, the next import will not delete what is already there.

[huggy591]

Hmmm... I didn't have to do that here. The reimport took care of all of it. Maybe I'm running something a little different than most.

[trcobb]

Is there a way to delete the data in the tvlistings database without using msaccess?

Thanks!

[CFGuy]

Go to the admin page and selecte a date from the dropdown labeled "Delete Date and ReImport".

[firtha]

I finally got it to work correctly by hand editing my tv_grab_na_dd.conf file to change the timezone from -0600 (MDT) to -0700 (MST). Funny thing is, I ran xmltv --configure, it kept the timezone as -0600 in the file even after I typed -0700 when prompted.

Also, there are two copies of the .conf file, one in /xmltv/.xmltv folder, one in /xmltv. Both of them seemed to be required, since if I deleted one and kept the other, xmltv would not work. Both had to be hand edited for the timzone.

[trcobb]

*** UPDATED AT BOTTOM OF POST ***

firtha, CFGuy,

Modifying the two instances of tv_grab_na_dd.conf to reflect the 1 hour offset corrected the problem.

I think I'll set up an event to call a batch file to copy the file annually. Optimistic, aren't I? LOL

Thanks for your help, and this great add-on to homeseer!

UPDATE!

The zap2it labs web forums mention that xmltv's TZ setting is not actually a time zone setting per se, but an offset. xmltv does not factor changing time zones, it just adds or subtracts the offset from the UTC time that they publish the data with.

Hope this data is useful to someone!