[mythtv-users] DVB Channel Setup - Start of a solution

[Malcolm Smith]

Sorry for the slow reply

> Hi Malc,

>i used another approach to add my dvb channels (DVB-S Astra in Germany)
>to my dvb_channel table.


Just what I was thinking of doing.... if my PERL  skills were as good as
this!


>1. run xmltv and mythfilldatabase to insert information about channels
>in channel table
>2. get a channels.conf (eg with scan)

Your script hardcodes the channels.conf to come from ~/.szap. (It would be
.tzap in my case)

>3. run the attached script (configure it in the script itself first),
>which does the following:

Had a quick look at your script. The only addition I would make that is my
SQL is that
you need to establish which source-id you are working with. I have 2 cards
and there different source id's, but with the same channels (e.g. BBC 1). I
also use SQL wildcards "%" to make the channel lookup fuzzy as the xmltv
channel name doesn't exactly match the channels.conf


>a: iterate through channel table and look for corresponding rows in
>dvb_channel
>b: if no row is found look for the channel description in channels.conf
>c: ask the user about the missing data for the channel (mostly
>serviceid, networkid, transportid - don't know if i really need this to
>use mythtv, but looks like it works - i got this information from
>http://www.satcodx2.com/0192/deu/)

It doesn't seem to be necessary for DVB-T... at least in the UK.

>d: insert the data to dvb_channel and dvb_pids



>If you send me your channels.conf and a dump of the corresponding
>dvb_channel and dvb_pids and channel, I would try to enhance the script
>so that it is usable for you and others, too.

Attached....
-------------- next part --------------
A non-text attachment was scrubbed...
Name: channels.conf
Type: application/octet-stream
Size: 8182 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20031229/32a2d1ac/channels.obj