some db help please...

[sub]

I dont have to format the parameters myself, so I cant comment on those. The SQL I use is:

insert into RECORDING_SCHEDULE (programme_oid, capture_source_oid, filename, status, recording_group, recording_type, manual_channel_oid, manual_start_time, manual_end_time, quality_level, pre_pad_minutes, post_pad_minutes, priority, conversion_profile) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)

All the '?' parameters are later populated by .net from their C# types.

[zehd]

I dont have to format the parameters myself, so I cant comment on those. The SQL I use is:

insert into RECORDING_SCHEDULE (programme_oid, capture_source_oid, filename, status, recording_group, recording_type, manual_channel_oid, manual_start_time, manual_end_time, quality_level, pre_pad_minutes, post_pad_minutes, priority, conversion_profile) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)

All the '?' parameters are later populated by .net from their C# types.

That's awesome. I guess I'm gonna learn SQL whether I like it or not. It turns out that the single quote in Grey's Anatomy * needs to be escaped by having two single quotes.... Grey''s Anatomy *. That' what was my problem.

Thanks for the help so far...

[sub]

It turns out that the single quote in Grey's Anatomy * needs to be escaped by having two single quotes.... Grey''s Anatomy *. That' what was my problem.

Yeah, that'll do it. Glad you got it sorted.

[zehd]

Well I can backup my reoccurring schedule, purge the EPG so that the cable providers new channels show up, lookup and fix the new channel OIDs, import them back into the db and then have GB-PVR reschedule recordings.

Whew.

I have also backed up shows that have already been recorded. When I import them, it goes smoothly, except the previous entries in the PROGRAMME EPG are gone, and so the recorded programs list incorrectly. Wrong show names and description. I look in the db and there aren't listing for the previously recorded shows anymore...

During the the first EPG update which downloads the new channel list and sorts the source channels, are the entires for those recorded shows being purged, because they aren't currently in the Recording Schedule?

[zehd]

I noticed that the Export and Import Recordings on the plugins tab of the Config is exactly what I want. Any chance to get at it from command line?

[zehd]

Damn sorry. I just found it on the wiki... getting tired....must get sleep

[zehd]

Just wanted to say thanks so far. The help you gave me worked out well. First step of my DB program works well. Now I just have to user proof it...

[zehd]

Sub I'm working with the REOCCURING_EXTRAS table and can't see what a couple of columns are for.

recording_group = lined to Recording_Schedule
max_files = how many files to keep

day_mask = ? where does it show and what are the possibilities

reoccurrance_type = ? think it's type of season recording, where does it show and what are the possibilities


first_run_only=? how does this work, and where in GB-PVR (is it Zap2it only?)

Thanks

[sub]

Sub I'm working with the REOCCURING_EXTRAS table and can't see what a couple of columns are for.

day_mask = ? where does it show and what are the possibilities
reoccurrance_type = ? think it's type of season recording, where does it show and what are the possibilities
first_run_only=? how does this work, and where in GB-PVR (is it Zap2it only?)

These are reserved for future use, but do nothing today. Actually, the day_mask might have been completed - I think web admin might use it.

[zehd]

These are reserved for future use, but do nothing today. Actually, the day_mask might have been completed - I think web admin might use it.

Cheers