[mythtv-users] vdr and mythv

[Karl Dietz]

On 17.06.2014 19:19, Angela wrote:
>> On 17/06/14 07:03, Per Jessen wrote:
>>> Some channels do broadcast in multiple languages - that's pretty
>>> common in Switzerland for instance.  However, removing channels I
>>> don't want is a hassle - I have some 4000 channels I think, most of
>>> which I don't want.
>
> I use vdr myself. Scan with w_scan, scans PMT and saves the language. Filter
> the channels.conf based on language.
>
> 3sat;upc:490000:C0M256:C:6900:336=2:337=deu at 3,338=mis at 3,339=mul at 3;347=deu at 10
> 6:366;357=deu:0:61:1:78:0
>
> egrep "=deu|=eng" channels.conf>  consolidated.channels.conf. Add missing
> ones.
>
> For mythtv:
> Update db: update channel set visible = 0;
> Use awk to get position 10 for the serviced ("61").
> cat consolidated.channels.conf | awk -F : '{ print "update channel set
> visible = 1 where serviced = " $10 ";" }'
> run generated sql script

For completeness you need to add dtv_multiplex and the 
original_network_id to your SQL. But IIRC on Astra 19.2°E service_id is 
almost (2 or 3 collisions) unique without looking at the ONID.

Regards,
Karl