<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Dec 18, 2021 at 9:44 AM Paul Harrison <<a href="mailto:mythtv@mythqml.net">mythtv@mythqml.net</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>On 17/12/2021 01:21, Kevin Johnson wrote:<br>
</p>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr"><br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Dec 14, 2021 at 1:42
PM Simon <<a href="mailto:linux@thehobsons.co.uk" target="_blank">linux@thehobsons.co.uk</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Kevin Johnson <<a href="mailto:iitywygms@gmail.com" target="_blank">iitywygms@gmail.com</a>> wrote:<br>
<br>
> Thank you for the suggestion. Do I need to do this for
each and every channel?<br>
> That would be kind of time consuming doing it for 900
channels. Maybe I am not understanding?<br>
<br>
Yes, it is time consuming - but whatever method you use will
be time consuming with 900 channels.<br>
But, by scripting it, you put in a bit more effort up front
and save time later. I use a script which is a little
developed from <a href="https://www.mythtv.org/wiki/Database_editing_script" rel="noreferrer" target="_blank">https://www.mythtv.org/wiki/Database_editing_script</a>
The script as shown there adds 10,000 to the channel number
if it’s not 7nn (radio channels on our UK Freeview) to move
everything out of the way. Then it makes all but radio
channels non-visible.<br>
Then for each “useful*” channel it sets it back to visible,
gives it a sensible channel number, and sets the xmltv
identifier for listings.<br>
<br>
Yes, it’s a complete pita to set up the first time, then
just a minor pita to maintain each time Freeview changes
stuff.<br>
<br>
But whenever I need to re-scan, I can just “delete all
channels, scan, run the script and see all my channels reset
as they were”. Then it’s a case of looking to see what
channels are still at 10,000 upwards and not visible (they
still chow in the channel editor in MythWeb) and edit the
script to catch those I want.<br>
<br>
* For whatever value of “useful” you apply - pesonally I
don’t want to see shopping channels etc. I’m guessing that
you’ll have a lot of encrypted channels you can detect in a
scan but which aren’t usable.<br>
<br>
<br>
> Command line editing a database is just not something I
am familiar with.<br>
<br>
Yeah, it’s not the easiest thing in the world to learn.<br>
<br>
Simon<br>
</blockquote>
<div><br>
</div>
<div>So I was able to figure out <a href="http://chedit2.pl" target="_blank">chedit2.pl</a> and have been
successfully editing the database.</div>
<div>Once I get the database trimmed, what is the best way to
have the channels I have removed from the database not show
in the guide?</div>
<div>Is there an option using mythfilldatabase? Or do I now
need to delete the unused channels using mythweb or channel
editor on the backend?</div>
<div><br>
</div>
<div>Thanks for all the help</div>
</div>
</div>
<br>
</blockquote>
<p><br>
</p>
<p>Add '--only-update-guide' to the mythfilldatabase parameters and
it wont update the channels.</p>
<p><a href="https://www.mythtv.org/wiki/Mythfilldatabase#Channels" target="_blank">https://www.mythtv.org/wiki/Mythfilldatabase#Channels</a></p>
<p><br>
</p>
<p>Paul H.<br>
</p>
</div>
<br></blockquote><div>I think that is the key I personally am looking for.</div><div>I edit the database removing channels I do not want. Then add the --only-update-guide parameter to mythfilldatabase and it will not add any channels to the epg.</div><div><br></div><div>Thank you.</div><div><br></div><div>Call me crazy, but shouldn't that be the default action of mythfilldatabase? Especially if one is using sd-json format?</div><div><br></div><div><br></div></div></div>