Update EPG for a channel group

[spe109]

Hi,
I've got a script which pulls tv listings out of digiguide (UK) and when this is complete I want to update the EPG.

I am using v5 and have the nscripthelper.dll tagged onto the end of my script and all seems to be working, except I realise it is trying to update all of the channels including the ones which aren't mapped to my xml file.

The channels I am interested in are in a channel group and so I was wondering is it possible to limit the update to just that group of channels?

I realise I can also set the other channels EPG source to none which would also work for me, but is there a way to bulk update 500 ish channels EPG source to none? A bit like"Update Channels Set EPGSource = 'None' Where EPGSource = 'DVB/ATSC EPG'

Thanks
Paul.

[mvallevand]

The question might be why add channels you are not interested in.  You could change them in bulk in sqlite3 something like when the service is stopped.

Code:

update channel
set epg_source = 'None', epg_mapping = ''
where oid not in (select channel_oid from channel_group where group_oid = ##)

Martin

[sub]

Sorry, not currently possible to update the EPG for a subset of channel.

[spe109]

The question might be why add channels you are not interested in.  You could change them in bulk in sqlite3 something like when the service is stopped.

Code:

update channel
set epg_source = 'None', epg_mapping = ''
where oid not in (select channel_oid from channel_group where group_oid = ##)

Martin

Thanks, I was hoping this might be possible.

For info, the other channels are just the ones picked up from the auto tune, I'm not really interested in most, but thought I'd just leave them on the off chance an interesting program came up, otherwise I'd have to try and tune again.

[spe109]

Sorry, not currently possible to update the EPG for a subset of channel.

Thanks anyway, I will do the bulk update in SQL as suggested above.