<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
On 12/12/2021 8:41 PM, Kevin Johnson wrote:<br>
<blockquote type="cite"
cite="mid:%3CCAJ1bLP2f_mY2kOea9xnSc3xeyydv82Kpm-UMH=xUaPU58_A_Aw@mail.gmail.com%3E">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr"><br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Sun, Dec 12, 2021 at 6:57
PM Peter Bennett <<a href="mailto:pb.mythtv@gmail.com"
moz-do-not-send="true" class="moz-txt-link-freetext">pb.mythtv@gmail.com</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><br>
</p>
<div>On 12/12/21 4:28 PM, Kevin Johnson wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hi All.
<div><br>
</div>
<div>Running Ubuntu 20.01 and Mythtv 31</div>
<div>I have cable using a hdhr prime. I only get the
basic channels.</div>
<div>Setting up the guide.xmltv is not for the faint
of heart. But I got it.</div>
<div>Only thing is I am setup to get all the
channels. 900 or more.</div>
<div>Going through and selecting each one individually
is obviously time consuming.</div>
<div>So my guide is filled with data not useful to me.</div>
<div>I have come across some suggestions such as using
a python script, <a href="http://chedit.pl"
target="_blank" moz-do-not-send="true">chedit.pl</a>
and other ways.</div>
<div>But to be honest I am not savvy enough to use the
found methods effectively.</div>
<div>Can I use the channel-editor in mythtv
WebFrontend? I can do it while watching tv from my
couch which would be nice. But when I tried that it
did not seem to update the channels as expected. I
deleted the channels but they still are seen in the
guide data on the frontends. Do I need to run
mythfilldatabase afterwards? Maybe wait a few
hours?</div>
<div><br>
</div>
<div>Or should I do it directly on the backend using
channel editor? Does soing so actually edit the
xmltv file? My backend is in the basement and I
would prefer to be able to do this from the comfort
of my couch.</div>
<div><br>
</div>
<div>Or?</div>
<div><br>
</div>
<div>Thank you.</div>
</div>
<br>
<fieldset></fieldset>
</blockquote>
<p>If you just delete the channels in MythTV, they will be
added back the next time you run mythfilldatabase, so
that is not helpful (unless you specify
--only-update-guide in mythfilldatabase, in which case
it is downloading them anyway and just not adding them)<br>
</p>
<p>You need to update them in the sqlite database. If you
are using tv_grab_zz_sdjson_sqlite, set up something
like this in a file. Set selected=1 for the channels you
want and selected=0 for those you don't want.<br>
</p>
<p>update channels set selected = 1 where channum = 2;<br>
update channels set selected = 1 where channum = 3;<br>
...<br>
update channels set selected = 1 where channum = 983;<br>
update channels set selected = 1 where channum = 986;<br>
</p>
<p>Update them with a command like this:<br>
sqlite3 $HOME/.xmltv/SchedulesDirect.DB <
selected.sql<br>
</p>
<p>Then you will no longer get listings for those channels
you don't want, and it won't download them. You can
delete the channels from MythTV if you like, or just
leave them and after two or three weeks they will show
no guide data.</p>
<p>Peter<br>
</p>
</div>
</blockquote>
<div><br>
</div>
<div>I am using tv_grab_zz_sdjson_sqlite</div>
<div><br>
</div>
<div>Thank you for the suggestion. Do I need to do this for
each and every channel?</div>
<div>That would be kind of time consuming doing it for 900
channels. Maybe I am not understanding?</div>
<div><br>
</div>
<div>Command line editing a database is just not something I
am familiar with.</div>
<div><br>
</div>
<br>
</div>
</div>
</blockquote>
Yeah, managing channels on mythtv has gotten more difficult over the
years. If you're not comfortable using a text editor and the command
line, there is a GUI browser for sqlite3 called sqlitebrowser.
Documentation is here:<br>
<a class="moz-txt-link-freetext" href="https://sqlitebrowser.org/">https://sqlitebrowser.org/</a><br>
You can install it like any other package on Ubuntu 20.04, e.g.:<br>
sudo apt install sqlitebrowser<br>
<br>
Assuming your backend with the sqlite3 database, is running a
desktop like gnome or lxqt, etc., this browser might be easier for
you to use. But you will need to check off the 'selected' value for
each channel you don't get. That's where a little command line fu
can come in handy to generate a file with the hundreds of update
statements Peter outlined.<br>
</body>
</html>