2007-04-21, 09:14 PM
So now I'd like to do something, and just want to walk through the steps...
I want to backup recurring shows (status 4, type 5), completely purge the schedule, insert the recurring shows records, have GB-PVR check the schedule and populate the db with the status 0, type 0 shows...
1. backup the reoccurring shows.
Using this thread I'm able to create a couple of text files, with the reoccuring shows listed. Also captured was the related Recording_Extras table.
http://forums.nextpvr.com/showthread.php?t=20995&
2. Wipe out the database entries. I removed all records from Recording_Schedule, Channels, Source Channel Mapping, Recording_Extras
3. In GB-PVR config, from each of my two tuners I update the EPG
The Channels and Source Channels are populated
The TV Guide is repopulated
*** Is there a way to automate the update of EPG on each of the tuners?
4. I will take an entry I saved and insert it into the Recording Schedule...
(I have used double pipes as a separator)
First field, the OID is a autonumber, so I will replace this with next highest (currently '0')
Since this will be the first Recording Group, I will autonumber the Recording_Group field too, and make sure I create an entry in the Recording_Group table
The rest of the data inserts properly.
5. I must look up what previously stored Channels and Source Channels match the newly updated EPG. Some channels have changed, added or deleted from the Cable provider. I will end up using the Channel name and Call sign as a reference to update the channel ID with the newly adjusted channels...
at the end, the recording schedule will have one entry
6. I create an entry in the Recording_Group table to match the 'Recording Group' field in Recording_Schedule
7. The big question. How do I tell GB-PVR to look for shows that match the Reoccurring scheduled show? On a two week EPG it should give me a couple of status 0 entries for each status 4 Reoccuring Show (assuming no reruns)
I mocked up everything to step 7 but wasn't able to get GB-PVR to look for new shows...
Have I missed something?
I want to backup recurring shows (status 4, type 5), completely purge the schedule, insert the recurring shows records, have GB-PVR check the schedule and populate the db with the status 0, type 0 shows...
1. backup the reoccurring shows.
Using this thread I'm able to create a couple of text files, with the reoccuring shows listed. Also captured was the related Recording_Extras table.
http://forums.nextpvr.com/showthread.php?t=20995&
2. Wipe out the database entries. I removed all records from Recording_Schedule, Channels, Source Channel Mapping, Recording_Extras
3. In GB-PVR config, from each of my two tuners I update the EPG
The Channels and Source Channels are populated
The TV Guide is repopulated
*** Is there a way to automate the update of EPG on each of the tuners?
4. I will take an entry I saved and insert it into the Recording Schedule...
(I have used double pipes as a separator)
Code:
1678||402629||1||4||Grey's Anatomy *||5||5||0001-01-01 00:00:00.0000000||0001-01-01 00:00:00.0000000||65||1||2||2||1||
First field, the OID is a autonumber, so I will replace this with next highest (currently '0')
Since this will be the first Recording Group, I will autonumber the Recording_Group field too, and make sure I create an entry in the Recording_Group table
The rest of the data inserts properly.
5. I must look up what previously stored Channels and Source Channels match the newly updated EPG. Some channels have changed, added or deleted from the Cable provider. I will end up using the Channel name and Call sign as a reference to update the channel ID with the newly adjusted channels...
at the end, the recording schedule will have one entry
6. I create an entry in the Recording_Group table to match the 'Recording Group' field in Recording_Schedule
7. The big question. How do I tell GB-PVR to look for shows that match the Reoccurring scheduled show? On a two week EPG it should give me a couple of status 0 entries for each status 4 Reoccuring Show (assuming no reruns)
I mocked up everything to step 7 but wasn't able to get GB-PVR to look for new shows...
Have I missed something?
Frank Z
[COLOR="Gray"]
I used to ask 'why?' Now I just reinstall...
[SIZE="1"]______________________________________________
Author: ZTools: ZProcess, MVPServerChecker; UltraXMLTV Enhancer, Renamer, Manager; [/SIZE]
[/COLOR]
[COLOR="Gray"]
I used to ask 'why?' Now I just reinstall...
[SIZE="1"]______________________________________________
Author: ZTools: ZProcess, MVPServerChecker; UltraXMLTV Enhancer, Renamer, Manager; [/SIZE]
[/COLOR]