For The Record - The rule-based scheduling suite (2 Viewers)

[dvdfreak]

I've attached an image of my current Web Access screen, but would really love to see something like : http://www.yourtv.com.au/guide/index.cfm?action=tonight without the advertisements around it of course !

There's still something wrong for some reason as you seem to have a horizontal scroll-bar that shouldn't be there (compare it to my screenshot). I wonder what makes it appear... Damn, this web stuff is great for "reach", but it can really suck to get things right sometimes

What happens if you scroll that scrollbar to the right? What (if anything) appears there?

Is there any chance of using the IE scroll bar instead of creating new ones within the Window for the new TV Guide ? The reason being that if you're using a fairly high resolution on your screen, it would be nice to see more information than what's currently shown. Also, is there a way of making the fonts a little smaller ?

I could indeed play with the font size somewhat, but using the IE scrollbars is not exactly easy (understatement of the year). It's really a pain-in-the-... to get this EPG grid to display correctly in HTML, I'm already glad I got it to do what it does now

 

[vertiger]

I have seen that it is possible to use channel groups in the tv scheduler, but they seperate from the groups in the tv server. I'm a little bit lazy, so is it possible to get the channel groups from the tv server in the tv scheduler (groupping over 200 channels is no fun)?

and thanks for this new version - it works great.

 

[ddj147]

What happens if you scroll that scrollbar to the right? What (if anything) appears there?

It gets interesting....

There is basically grey area, but when I scroll down, well, there appears to be extra information for some channels...

I'm wondering whether that's a mis-configuration on my part. The EPG provider that I'm using (IceTV) doesn't currently have EPG data for the HD channels in their tvguide.xml. For those channels, I was trying to use the DVB-T information (as the TV networks are now occasionally starting to broadcast it). Since I'm still stuggling a bit with understanding MediaPortal I may have things configured wrongly as it appears like there is duplicate information trying to be displayed, once from tvguide.xml and once from DVB perhaps ?

 

[dvdfreak]

I have seen that it is possible to use channel groups in the tv scheduler, but they seperate from the groups in the tv server. I'm a little bit lazy, so is it possible to get the channel groups from the tv server in the tv scheduler (groupping over 200 channels is no fun)?

I'm afraid you'll have to re-do your groups. Do one group a day and before you know it they will all be set up to your liking

and thanks for this new version - it works great.

Great to hear that!

What happens if you scroll that scrollbar to the right? What (if anything) appears there?

It gets interesting....

There is basically grey area, but when I scroll down, well, there appears to be extra information for some channels...

Very strange indeed. I do wonder how you got that information into the database. Seems there is something wrong in the scheduler's import code, since normally it should detect overlapping programs and avoid exactly these kind of "duplicate program" issues. I'll add it to my list of things to look at.

 

[Midget]

Is there any error logged in the event-log?

Only 2 errors and not related to the message box showing up in the console, I think it's related to service's start:

Error: StatementErrorUnclassified
Gentle.Common.GentleException: select top 100 GuideProgramId, GuideChannelId, Title, StartTime, StopTime, SubTitle, Description, Category, IsRepeat, IsPremiere, VideoAspect, SeriesNumber, EpisodeNumberDisplay, EpisodeNumber, EpisodeNumberTotal, EpisodePart, EpisodePartTotal, Rating, StarRating, Director, Actors, LastModifiedTime, IsDeleted, Version from GuideProgram where Title = @Title and () and IsDeleted = @IsDeleted and StopTime >= @StopTime order by StartTime; ---> System.Data.SqlClient.SqlException: Sintassi non corretta in prossimità di ')'.

Definitely time to upgrade then!

I want to be sure not to lost schedule data. Do you know any trick ? (could I dump the TvSchedule table to disk ?)

It would be interesting if you could tell me step by step how to reproduce the database error, I'd like to fix that of course.

Well, I've changed the grabber in WebEPGConf. I think the new grabber had different channel names that match same MediaPortal channels (generic example: Channel1 -> ChannelOne -> Channel-1)
When importing new tvguide.xml file in TvScheduler, the console showed duplicate channels with same names (in both TV Guide and TV Channels pages) but no error messages. To discriminate between old and new channels I've examined guide data and deleted old channels from TV Channels page. Returning in the TV Guide page I've got the "error on database: concurrent change made by another user?" message (not exactly, but the meaning is this).
With SQL server management console I've tried to clean the db from channels references. I've emptied all the tables leaving only Configuration, DbVersion and TvSchedule. Then I've tried to re-import tvguide.xml file and now in any console page I'm getting the error message "the server was unable to process the request due to an internal error..."

Thank you for support

 

[dvdfreak]

Is there any error logged in the event-log?

Only 2 errors and not related to the message box showing up in the console, I think it's related to service's start:

Error: StatementErrorUnclassified
Gentle.Common.GentleException: select top 100 GuideProgramId, GuideChannelId, Title, StartTime, StopTime, SubTitle, Description, Category, IsRepeat, IsPremiere, VideoAspect, SeriesNumber, EpisodeNumberDisplay, EpisodeNumber, EpisodeNumberTotal, EpisodePart, EpisodePartTotal, Rating, StarRating, Director, Actors, LastModifiedTime, IsDeleted, Version from GuideProgram where Title = @Title and () and IsDeleted = @IsDeleted and StopTime >= @StopTime order by StartTime; ---> System.Data.SqlClient.SqlException: Sintassi non corretta in prossimità di ')'.

Aha, this is the error I was looking for. Look at this part:

"... where Title = @Title and () and ..."

The two brackets are wrong. And the reason is that the schedule is referencing TvChannels that are no longer there. That perfectly explains it actually, since you deleted them.

Try editing your schedules one-by-one and make sure the TV channels are correctly set (you'll probably notice the list will be empty instead of showing the channels). Then save the schedules again and all will be well again.

I have to think about how I could fix this for a next release. Either I remove the brackets and make the query work again, but then all channels will be included. Or I throw an error about the schedule containing unknown TV channels. What would be the best thing to do...?

Definitely time to upgrade then!

I want to be sure not to lost schedule data. Do you know any trick ? (could I dump the TvSchedule table to disk ?)

No, that won't work for the same reason as above.

But I don't think the database has been upgraded since release 1.0.8.0, so you won't have a problem upgrading. If you really want to make sure you can still make a backup of the entire database before you upgrade, so you can always roll back to that.

 

[Midget]

The two brackets are wrong. And the reason is that the schedule is referencing TvChannels that are no longer there. That perfectly explains it actually, since you deleted them.

Try editing your schedules one-by-one and make sure the TV channels are correctly set (you'll probably notice the list will be empty instead of showing the channels). Then save the schedules again and all will be well again.

Gotcha! When I've got duplicated channels in the past I've assumed same error: so I've carefully removed any channel id (guid) reference from my schedules rules. This time I've a couple new schedules that haven't got yet the same cleaning....
To detect them I simply launched this SQL query: SELECT * FROM [TvSchedule] WHERE [RulesXml] like '%guid%'

Now things are working again

I have to think about how I could fix this for a next release. Either I remove the brackets and make the query work again, but then all channels will be included. Or I throw an error about the schedule containing unknown TV channels. What would be the best thing to do...?

Actually I'm already using schedules without channel reference and things are working well for my needs...

I want to be sure not to lost schedule data. Do you know any trick ? (could I dump the TvSchedule table to disk ?)

No, that won't work for the same reason as above.

I think that with my "channel-free" schedules it should work.

 

[ddj147]

Very strange indeed. I do wonder how you got that information into the database. Seems there is something wrong in the scheduler's import code, since normally it should detect overlapping programs and avoid exactly these kind of "duplicate program" issues. I'll add it to my list of things to look at.

Well, I've sorted my EPG data out so that I now have accurate data and no duplicates. It means there is no horizontal scrollbar and all is good. I've setup the channel logos and I'm now very happy with the solution. once again for all the effort you have gone to in writing this and providing very quick support.

 

[dvdfreak]

[size=+1]TRANSLATION HELP NEEDED[/size]

Dear users

I don't know how many people from how many countries are using TV Scheduler, but I'd like to offer Web Access in your local language. So I need some help! Who would be so kind as to translate the attached resource files into their language?

I've already done the dutch translation and have included that as an example. When making new resource files just make sure you use the correct 2-letter ISO code for your language just in front of the extension.

So: Foo.ascx.de.resx for German, Foo.ascx.es.resx for Spanish, etc... (http://en.wikipedia.org/wiki/List_of_ISO_639-1_codes).

Thanks in advance for the help! I'll include all translations I receive in version 1.0.13.0.

Comment: you only need to translate text that is already there, empty XML nodes can remain empty.

One last comment: some translations need to be kept short, e.g. the "Record", "Rec. Daily",... buttons. But I'll test what you submit, and if needed I'll ask for alternatives if I notice the layout can't handle the long text.

 

[vertiger]

german translation