Any way to automatic refresh the tvguide? (1 Viewer)

[Hemin]

I download a tvguide every day with 10days information, but xmltv only add the new last day and don't refresh the more detailed first day.

For example, a show from the first day have a title "Cinema" and a description "bla bla bla" on the xmltv file, but on the program DB, the title is "Cinema" and the description is "unknow", i have to clear de DB with the "refresh" button and then the tvguide is updated with all the new information.

Is there any way to auto refresh the epg guide like the tvserver "refresh epg" button, or clear the program DB? A kind of batch file to put in the task scheduler that clear the DB....

 

[xurr]

I also miss this feature, which I believe is present in the MyTV Engine 0.2. Until this is implemented, is there a simple way to delete the "Programs" table using a script?

 

[Mew]

I would agree with the previous comments.

When I checked the EPG last night there were an awful lot of "To be announced" and "Film to be announced" present. This meant I had to check the TV guide in the paper to find out what was on.

The times of one of the programs my kids watch must have changed as well as the recording ended about 5-10 minutes too soon (even though there is 5 minutes as default padding after each recording).

I guess this is because the main EPG information is imported from the RadioTimes via WebEPG and can be 14 days ahead when the schedules havn't been fully agreed.

I was able to delete the details from the table and import a new EPG which resolved the TBA problems, but I will have to remember to connect a mouse once a week to do this.

A box that could be checked to do this delete automatically when a new tvguide.xml is detected before the file is imported by the XMLTV plugin would be ideal.

 

[SimonDen]

Hi,

I don't know if you already have a fix for this but if not here it is

create a textpad document in the mediaportal folder and paste in the following on 1 line:

sqlcmd -S yourservername\SQLEXPRESS -U sa -P yourpassword -Q "DELETE FROM TVLIBRARY.DBO.PROGRAM"

remember to change the "yourservername", "yourpassword" and "sa" (if you changed the standard User ID when installing MP).

Note that the -S -P -U -Q are case sensitive and must be in upper case

rename the .txt to .bat and then use XP Scheduler to run the file.

 

[Hemin]

Thank You SimonDen!!, I will try it later and let you know if it works for me.