Rule-based TvScheduler service

[jake78]

They are missing in the DB as well, so you're right it's the import.

I have attached my XML file.

[The_Stig]

Originally Posted by dvdfreak

Thanks, this was very helpful as I'm pretty sure it's this that gives the error on your SQL:

CAST('2007/09/25' AS DATETIME)

Must be a locale thing, I'm going to look for a more correct locale-independant way of converting this date.

To confirm this, can you try to execute the following in your SQL Management Studio:

SELECT CAST('2007/09/25' AS DATETIME)

SELECT CAST('2007/25/09' AS DATETIME)

I wouldn't be surprised if the first one fails, and the second one works...

EDIT

Does the following work?

SELECT CONVERT(DATETIME, '2007.09.25', 102)

SELECT CAST('2007/09/25' AS DATETIME) -> not working. Message is:

"Meldung 242, Ebene 16, Status 3, Zeile 1
Bei der Konvertierung eines char-Datentyps in einen datetime-Datentyp liegt der datetime-Wert außerhalb des gültigen Bereichs."

SELECT CAST('2007/25/09' AS DATETIME) -> working

SELECT CONVERT(DATETIME, '2007.09.25', 102) -> working too

[dvdfreak]

Originally Posted by jake78

They are missing in the DB as well, so you're right it's the import.

I have attached my XML file.

Thanks! Seems I have some XMLTV fixing to do Will definitely fix this by the next release.

Originally Posted by The_Stig

SELECT CONVERT(DATETIME, '2007.09.25', 102) -> working too

OK, that's the one I'm gonna use then since this is totally independant of the locale settings. Thanks for the help.

[ocram]

I just installed your scheduler, this has to be integrated with mediaportal. 1 feature request: on adding a schedule
and when using "contains" for the title, make it possible to give muliple keywords.

example:

that AND 70 AND show

will record: That '70s Show



groeten uit België

[dvdfreak]

Originally Posted by ocram

I just installed your scheduler, this has to be integrated with mediaportal. 1 feature request: on adding a schedule
and when using "contains" for the title, make it possible to give muliple keywords.

example:

that AND 70 AND show

will record: That '70s Show

Well, this is actually already possible, but unfortunately not (yet) from the user interface. If a schedule is added with several "TitleContains" rules you will get the effect you ask for.

[MoPhat]

Does this work with DVB-EPG or only with XMLTV?

Thanks
MoPhat

[dvdfreak]

Originally Posted by MoPhat

Does this work with DVB-EPG or only with XMLTV?

Thanks
MoPhat

Both are possible, even a combination of both (you can configure which source you consider the most important, and the other source will then simply enrich the guide if possible).

So to give a pratical example, say you get "The Simpsons" from DVB-EPG but it lacks the description, when you import XMLTV and that one does have the description the guide data will be updated with this new information.

All that being said, the test-version I uploaded only imports XMLTV, since DVB-EPG will have to be provided by MediaPortal (and passed on to TvScheduler through its ImportProgram() service method).

[dvdfreak]

Just a quick status update. I broke my laptop last weekend, so I'm trying to get back up and running to continue development (new machine is on its way ), but here's what's already done:

• Implemented caching for calculating upcoming programs -- this enormously speeds up repeated calls.
• TvScheduler.WindowsService will now delete old guide data every day (everything before yesterday).
• Added Settings panel, with e.g. global pre- and post-record settings.
• Added "Edit Schedule" item to popup in TV Guide.
• Added new and more icons.
• Added icons to upcoming programs grids.
• Implemented preferred guide source and pre- and post-record settings.
• Added "IsCancelled" to UpcomingProgram and UpcomingGuideProgram (always false for now).
• Bug fix: Fixed problem with datetime casting in SQL Express for OnDate rule.
• Bug fix: time in Upcoming Programs grid is now also displayed for midnight (00:00).
• Bug fix: XMLTV import was broken when two programmes with the same title were right after one another.

What I'd like to do before I upload a new test-version is implement the logic to cancel/uncancel specific programs for a schedule. So you can simply right-click on a program that is scheduled and "remove" just that one, while leaving the rest of the schedule intact.

Another thing I'd like to start looking at, is what patches/changes would be required to the core code of TVE3 to make it query TvScheduler about what needs to be recorded, instead of only the internal TVE3 database. This would be the first big step for integration, since that would mean program would really be recorded, and not just appear on your screen for fun

[The_Stig]

Sounds nice! Keep it coming :-)

[jake78]

I'm looking forward to the next test version.

Keep up the good work!