some db help please...

[zehd]

I'm working on a database tweaker.

In the gb-pvr db3 recording schedule, I have several Reoccurring events (5) and and also the actual recording schedules (0) themselves.

I want to be able to edit the reoccurring events, and then have GB-PVR straighten out the schedule.

I think that if I delete all the '0' and leave the '5', I should be able to tell GB-PVR to check the schedule again, and even look for conflicts and fill in the 0s...

Is that when it updates the EPG? I understand there are two types of updates, one the once a day, and the other in the config|capture sources page...

If I initiate a update of the epg, Would that fill in schedule again?

[sub]

I think that if I delete all the '0' and leave the '5', I should be able to tell GB-PVR to check the schedule again, and even look for conflicts and fill in the 0s...

Is that when it updates the EPG?

Yes, but it'll only be able to do this for recordings that were part of a season recording. If you'd deleted any one-off recordings, then these would be gone for good.

[zehd]

Yes, but it'll only be able to do this for recordings that were part of a season recording. If you'd deleted any one-off recordings, then these would be gone for good.

Yes. I mean the one offs, related to the season recording...

Oh and BTW... I wondered what Recording Group was in the Recording Schedule. I believe its related to Reoccuring extras, but I was unable to find a relation to what was each of the groups...

[zehd]

And Previous episode is in there somehow too...

[sub]

Yes. I mean the one offs, related to the season recording...

I was meaning the one-offs that werent related to a season recording. (for example, doing a 'quick record' on a show in the tv guide ...not a season recording).

[sub]

Oh and BTW... I wondered what Recording Group was in the Recording Schedule.

recording_group ties together all the episodes of a season recording.

[zehd]

recording_group ties together all the episodes of a season recording.

is the recording group oid randomly generated, (autonumber maybe, highest next number) or is it related to the different types of season recording (all epps same channel, same time etc)

[sub]

is the recording group oid randomly generated, (autonumber maybe, highest next number) or is it related to the different types of season recording (all epps same channel, same time etc)

Its incremented each time a season recording is created.

[zehd]

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)

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?

[zehd]

Hmm just thought that I might want to sync up the Program ID in PROGRAMME

But wait, is that a unique ID set by the EPG people? (Zap2it)