<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>This browser certainly gives you a good view into what's
happening. Below are some assumptions I'd like confirmed from the
experts.</p>
<p>1. Using mythtv-setup > Channel Editor and marking a
station/channel as invisible has nothing to do with what XMLTV
> mythfilldatabase pull data for. <font size="+1"><br>
</font></p>
<p>2. running tv_grab_zz_sdjson_sqlite --manage-lineups
--config-file $HOME/.mythtv/SD.xmltv<font size="+1"> interactively
lets you pick your channels and that sets the 0 or 1 in the
Select field of the channel table you can view with
sqlitebrowser on SchedulesDirect.DB</font></p>
<p><font size="+1">3. mythfilldatabase using xmltv grabber pulls
data from SD for only the channels that the Select field is 1?
So NOT pruning the channel list to a realistic list makes
mythfilldatabase run longer and pull a lot more data than you
actual need?</font></p>
<p><font size="+1">Jim A</font></p>
<p><font size="+1"><br>
</font></p>
<p><font size="+1"><br>
</font></p>
<br>
<p>
<style type="text/css">pre { direction: ltr; text-align: left; }p { margin-bottom: 0.1in; direction: ltr; line-height: 115%; text-align: left; }a:link { color: rgb(0, 0, 255); }</style></p>
</body>
</html>