<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><br>
</p>
<div class="moz-cite-prefix">On 12/8/18 11:20 PM, William Jacoby
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAPzYDeoso403iYfHfHXcAPfEUL+ObbdPriSde6Rnqmaouf5vsw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>
<div class="gmail_quote">
<div dir="ltr">On Sat, Dec 8, 2018 at 11:26 AM James
Abernathy <<a href="mailto:jfabernathy@gmail.com"
moz-do-not-send="true">jfabernathy@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 bgcolor="#FFFFFF">
<p>On my production system I've been using XMLTV json
sqlite for a long time. I used the mythtv XMLTV wiki
for that setup:</p>
<pre style="font-family:monospace,Courier;color:black;background-color:rgb(249,249,249);border:1px solid rgb(221,221,221);padding:1em;white-space:pre-wrap;line-height:1.3em;font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial">tv_grab_zz_sdjson_sqlite --configure --config-file $HOME/.mythtv/SD.xmltv
tv_grab_zz_sdjson_sqlite --days 0 --config-file $HOME/.mythtv/SD.xmltv
tv_grab_zz_sdjson_sqlite --manage-lineups --config-file $HOME/.mythtv/SD.xmltv
</pre>
<p>During the 3rd step you go through each channel in
the lineup for my zipcode and delete the ones you
don't get. That seems to make mythfilldatabase work
faster. It also makes my channel editing faster
because most of the channels are not in the list, just
a few stations that are on the fringe of my reception
area. But most of the channels I don't want are
eliminated by the 3rd step.</p>
<p>When I went through Gary's PDF (Use of the HDHR
Premium TV service with MythTV.pdf)
<a
class="gmail-m_9215716548808901291moz-txt-link-freetext"
href="https://drive.google.com/file/d/19wChqgPjPtt5tw7seUl-zySe-HrH6cJV/view?usp=sharing"
target="_blank" moz-do-not-send="true">https://drive.google.com/file/d/19wChqgPjPtt5tw7seUl-zySe-HrH6cJV/view?usp=sharing</a></p>
<p>I didn't see the opportunity to use
tv_grab_zz_sdjson_sqlite to eliminate unwanted
channels from my SD lineup. As a result my
mythfilldatabase run was longer and I had a lot more
channels to edit out using mythtv-setup.</p>
<p>I'm sure there is a way, but I'm not smart enough to
figure it out. (the script isn't in Fortran and
there's no IBM cards. Yes I'm that old :-)</p>
<p>Jim A</p>
</div>
</blockquote>
<div> </div>
<div>
<div>You can install dbrowswer in order to edit/view the
SQLite: <br>
</div>
<div>
<pre>sudo apt-get install sqlitebrowser</pre>
</div>
<div>Then change the value for the channel to either 0 or
1 depending on whether you want to disable it.</div>
<br>
</div>
</div>
</div>
</div>
</blockquote>
<p>I installed the sqlitebrowser and it's a nice tool. I see in the
channel listing that It has a remove button. I'm wondering if I
should just highlight the channel I don't want and remove it or
set the selected field to 0??</p>
<p>Jim A</p>
<p><br>
</p>
</body>
</html>