Update EPG batch file

[sub]

Not sure if this helps but I checked the data base - by dumping to a text file using sqlite. The extra listings are in the PROGRAMME table. There are many listings that are in the file even after doing an empty EPG. Are they marked as old or something? or should they actually be removed from the sql file?

There some special cases. It wont remove programs that are linked to a recording, meaning it'll leave:
1) programmes that were in the past, and currently have an entry in the 'ready' list.
2) future programmes that have been scheduled as a one-off recordings. ie not part of a season recording.
3) the very first programme in a season recording. ie the master show used to create that season recording.

Are there any programmes still listed in your database after the empty epg that arent one of these situations?

The reason for 2 & 3 above is because there is no guarantee GB-PVR will be able to find the programme if it removed the entry -like multiple shows with same name at approximately the same time, and no show identifiers to tell GB-PVR which one, so safer to just leave the recording as originally scheduled by user.

My sql file is 6MB is that normal?

Yes.

[fluffykeith]

There some special cases. It wont remove programs that are linked to a recording, meaning it'll leave:
1) programmes that were in the past, and currently have an entry in the 'ready' list.
2) future programmes that have been scheduled as a one-off recordings. ie not part of a season recording.
3) the very first programme in a season recording. ie the master show used to create that season recording.

Are there any programmes still listed in your database after the empty epg that arent one of these situations?

Ah - I understand a bit more - All the programmes correspond to one of the 3 situations.

I can recreate the effect by changing an entry in the XML EPG so that it shifts by 5 mins the go to update EPG in config (this just uses the XML file rather than calling updateEPG.bat, and only adds entries not remove them, right?). I then get the overlapping entries / scheduled recordings.

These are my observations:
Starting with a TV guide showing overlapping scheduled entries.

If I then empty the EPG completely and then do update from the system, its fixed.

If I only do an update from the system that doesn't fix it, I get more entries.

If I empty EPG for one souce in the config - I can go back to the TV guide and I see some entries in the TV guide that are scheduled for recording are still there (not all, some have gone, I guess those relating to the source selected at the time of scheduling), If I then update the EPG I get the overlapping recordings where any EPG times have changed for those entries that were not in the source I emptied.

If I empty EPG for each source, ie all are emptied, then do an update EPG, everything is OK. (what I did first of all, completely empty)

It would seem that when a change occurs to the EPG that shifts the recording then we get extra listings when those items are not in the source that the EPG is emptied.

This implies that when performing an update of the EPG from the system or by the nightly update (I assume both use the same mechanism) then only one source EPG is removed (probably the top source in the list as it works for most recordings but shows up for back to back ones which are recorded from different sources due to padding).

By clearing EPGs for specific sources I can determine that I get 80 scheduled recordings on the first source and 103 on all sources.

I can also create an empty EPG, ie no programs and do an update but still end up with pending recordings.

Can you verify that the EPG is emptied for all sources, not just the first one, when a system update occurs?

Also as an aside if I cancel a pending recording will it re-appear when I update the EPG? I would expect they are marked as don't record.

thanks

Keith

[HtV]

When you do a update-epg from the tray icon it does empty the epg first, i.e. if you have "compete reload" selected in config. iow it does the same routine the scheduled epg update does.

Hans

[fluffykeith]

Hi Hans

I've not used the tray icon update in my experiments, I've used the update in the config tool. However it seems that the config tool does the empty and update per source, as I guess it should as its in a source specific dialog box, but the tray and pvrx2 updates should do empty and update for each source.

I beleive from what I've seen that it either does an empty for just the first source and then an update for all sources or possibly, empty then update for each source rather than empty for all sources followed by update for all sources.

Hope that makes sense.

I think the extra batch file does not fix this problem as it saves the scheduled recordings and then re-imports.

cheers

Keith

[fluffykeith]

The reason for 2 & 3 above is because there is no guarantee GB-PVR will be able to find the programme if it removed the entry -like multiple shows with same name at approximately the same time, and no show identifiers to tell GB-PVR which one, so safer to just leave the recording as originally scheduled by user.

I guess the answer here is really no, as when I do an emptyEPG (one one source), or indeed an update, there are old entries remaining of scheduled recordings that were generated by the system from the original recurring recording.

Maybe there is a magic setting in the config to set.

cheers

Keith

[Nomad101]

Hi Keith

A few of us have had this problem for quite a while. There are a few workarounds. Have a read through the posts listed below.

Sub, you mentioned before that with "complete EPG reload" ticked it does basically the same as the 3 step commandline method (using -deletependingrecurring) but I've found that "complete EPG reload" definitely still leaves some entries in the EPG and they don't fall into the 3 categories you mentioned earlier. These are recurring recordings that were scheduled months ago and show every week. I always wondered why it only happened to some and not all of the recordings but Keith mentioned back to back recordings and of course that's the common denominator. Only back to back recordings are affected. I have 2 (sometimes 3) shows on a Saturday that are back to back on the same channel and most weeks their scheduled time gets shifted slightly a few days before the recordings. I'm currently using the "complete EPG reload" and every week those shows get duplicated unless I remember to manually clear the EPG using -deletependingrecurring and reload it.

Keith, have a look at these posts:
http://forums.nextpvr.com/showthread.php?t=29357
http://forums.nextpvr.com/showthread.php?t=32666

Cheers
Tony

[fluffykeith]

Thanks for the info Tony. I'm glad I'm not the only one with this problem.

When you had this problem did you try and emptyEPG from each of the sources in the config? I am convinced that pending recordings for sources other than the first are left in.


Can these commands be run when there is an instance of PVRX2 running?

PVRX2.exe -EmptyEPGOnly (empties the EPG without running the GUI)
PVRX2.EXE -deletependingrecurring (deletes any remaining recurring entries)
PVRX2.exe -UpdateEPGOnly (updates the EPG without running the GUI)

looks like this command line option is duplicated !!
"C:\Program Files\devnz\gbpvr\pvrx2.exe" -OnlyUpdateEPG

If these have to be run when PVRX2 is closed then it may be neater to use sqlite to edit the database directly.

Sub mentioned in the other thread that step 2 is not performed by PVRX2 in case the EPG is empty or unavailable but I still see no listings if it is unavailable! My EPG is the same for each source. I wonder if this is a threading issue - eg, the first source updates and blocks the others because the file used is the same.


cheers

Keith

[sub]

When you had this problem did you try and emptyEPG from each of the sources in the config? I am convinced that pending recordings for sources other than the first are left in.

I double checked this when you posted the other day. It deletes all programmes not referenced by a recording, regardless of capture source.

[fluffykeith]

Thanks for checking sub.

Must be some strange thing happening.

I'll keep an eye on it. It's looking good at the moment.

cheers

Keith

[Nomad101]

Hi Keith

When you had this problem did you try and emptyEPG from each of the sources in the config? I am convinced that pending recordings for sources other than the first are left in.

I haven't tried that but will do next time it happens (probably later this week)

Can these commands be run when there is an instance of PVRX2 running?

PVRX2.exe -EmptyEPGOnly (empties the EPG without running the GUI)
PVRX2.EXE -deletependingrecurring (deletes any remaining recurring entries)
PVRX2.exe -UpdateEPGOnly (updates the EPG without running the GUI)

They can be run while an instance of PVRX2 is running. They start another process in the background.

looks like this command line option is duplicated !!
"C:\Program Files\devnz\gbpvr\pvrx2.exe" -OnlyUpdateEPG

Yes, there seemed to be a bit of a change between GBPVR.exe and PVRX2.exe. The ones I found worked are listed here:
http://forums.gbpvr.com/showpost.php?p=2...ostcount=8
-deletependingrecurring doesn't work with GBPVR.exe

Sub mentioned in the other thread that step 2 is not performed by PVRX2 in case the EPG is empty or unavailable but I still see no listings if it is unavailable! My EPG is the same for each source. I wonder if this is a threading issue - eg, the first source updates and blocks the others because the file used is the same.

I assume you're talking about Sub's post here:
http://forums.gbpvr.com/showpost.php?p=2...ostcount=7
I think he's saying that step 2 is done but only after checking to see if new listings are available. For example if your xml data file was missing it probably wouldn't do those steps. I think that only applies to the automatic scheduled EPG update (not manually emptying the EPG).

Cheers
Tony