EPG Utility: YApi2XML (discontinued)

[whurlston]

As far as I know, all XMLTv grabbers output the start and stop times in GMT format. The application using the data then converts it to local time. I'm surprised that that application does not.

You can try changing the offset in the files. I don't believe that Oz has anything implemented that will do that but you can open the file in something like Notepad++ and run a search/replace on all " +0000" and adjust it to your timezone. If you are on Eastern Standard Time, you would change it to " -0500". You may have to use the opposite +/- symbol from your timezone. I can't remember offhand.

[bryanbelt]

I know that the program uses XMLTV to do the grabbing and the offset is set in that configuration. The problem is, I don't know how to force Yapi2XML to do the same. . .I took your advice about editing the offset in the XML itself, all to know avail. . .still off by 6 hours. . .any ideas?

Bryan

[bryanbelt]

Okay. Here's what I've found. . .changing the information in the UTC offset does nothing to correct the issue. I HAVE located what is causing my dilemma, however. The issue's not so much in the chosen time zone as much as it's in the start and stop times. The start and stop times are formatted this way in a sample SchedulesDirect XML, which works fine for me:

20080108030000

You'll note that this start time is for January 8, 2008 beginning at 3AM.

20080108033000

The end time is for January 8, 2008 ending at 3:30AM.

Conversely, the XML output from Yapi2XML looks identical to the SchedulesDirect, except that the same program start time looks like this:

20080108090000

Likewise, the end time is as follows:

20080108093000

Herein lies my challenge. I suppose what I will ultimately need is a "custom" Yapi2XML formatted for my timezone or at least directions on what I would need to change using a VB6 disassembler.

Any thoughts?

[whurlston]

If you can wait a few days on this, the code that I am working on will read and write xmltv files. With some minor additions, I can put together an app that will read the file, adjust the dates and then spit out a new file with the corrected dates. Once I have the code that I'm already working on done, it would probably take me about an hour to do a customized app for what you need.

[bryanbelt]

If you can wait a few days on this, the code that I am working on will read and write xmltv files. With some minor additions, I can put together an app that will read the file, adjust the dates and then spit out a new file with the corrected dates. Once I have the code that I'm already working on done, it would probably take me about an hour to do a customized app for what you need.

Whurlston,
I would be DELIGHTED to wait! I would be ecstatic to wait! One thing you may bear in mind in making the "customized" app is daylight savings time. If you're going to hard-code the time zone in, you may want to make one for daylight savings time and another for standard time. I don't know as much about coding as I would like, so I'm not sure what kind of effort would need to be put in to do a "drop-down" where you could choose your timezone or a radio button to switch between daylight savings time and standard time. I will gladly be your guinea pig in this endeavor, however. Let me know and keep me posted on the progress. . .

Bryan

[zehd]

Whurlston,
to be put in to do a "drop-down" where you could choose your timezone or a Bryan

HAHA. Whurlston don't do 'dropdowns'. If you want a dropdown, talk to me!

Actually, My own enhancer would also be a candidate for changing the info you want changed, and it has a GUI with lots of dropdowns. But, I'd like to see what whurlston is doing.

My tool is working well, but it is slow. I wanna see how fast whurlston can get a wad of info processed...

[whurlston]

I wanna see how fast whurlston can get a wad of info processed...

I'm converting the MCE guide with pretty much everything but the video and audio tags in under a minute now.

That includes the import from MCE, conversion and writing the file.

[zehd]

I'm converting the MCE guide with pretty much everything but the video and audio tags in under a minute now.

That includes the import from MCE, conversion and writing the file.

But are you shuffling data around?

[zehd]

Whurlston,
I would be DELIGHTED to wait! I would be ecstatic to wait! One thing you may bear in mind in making the "customized" app is daylight savings time. If you're going to hard-code the time zone in, you may want to make one for daylight savings time and another for standard time. I don't know as much about coding as I would like, so I'm not sure what kind of effort would need to be put in to do a "drop-down" where you could choose your timezone or a radio button to switch between daylight savings time and standard time. I will gladly be your guinea pig in this endeavor, however. Let me know and keep me posted on the progress. . .

Bryan

Here is what you want...

Double click on it and it shows the command line switches...

[whurlston]

The app I'm proposing for Bryan will only change the start/stop times though. The new MCE converter will not include any data enhancements like the new show marker in the titles. You've already done a solid app to do that so I don't see the point in me doing it too. You should be able to use my dlls to import and export the xmltv files quickly though. You can handle all the enhancements inbetween.

Edit: I just saw the "TimeOffset" attachment. That should do it.