<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><br class=""><div><blockquote type="cite" class=""><div class="">On Dec 9, 2018, at 10:10 AM, James Abernathy <<a href="mailto:jfabernathy@gmail.com" class="">jfabernathy@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="moz-cite-prefix" style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration: none;"><br class="Apple-interchange-newline">On 12/8/18 11:20 PM, William Jacoby wrote:<br class=""></div><blockquote type="cite" cite="mid:CAPzYDeoso403iYfHfHXcAPfEUL+ObbdPriSde6Rnqmaouf5vsw@mail.gmail.com" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration: none;" class=""><div dir="ltr" class=""><div class=""><div class="gmail_quote"><div dir="ltr" class="">On Sat, Dec 8, 2018 at 11:26 AM James Abernathy <<a href="mailto:jfabernathy@gmail.com" moz-do-not-send="true" style="color: rgb(0, 0, 255);" class="">jfabernathy@gmail.com</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;"><div bgcolor="#FFFFFF" class=""><p style="margin-bottom: 0.1in; direction: ltr; line-height: 13.800000190734863px; text-align: left;" class="">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="direction: ltr; text-align: start; font-family: monospace, Courier; 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-indent: 0px; text-transform: none; word-spacing: 0px;" class="">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 style="margin-bottom: 0.1in; direction: ltr; line-height: 13.800000190734863px; text-align: left;" class="">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 style="margin-bottom: 0.1in; direction: ltr; line-height: 13.800000190734863px; text-align: left;" class="">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" style="color: rgb(0, 0, 255);">https://drive.google.com/file/d/19wChqgPjPtt5tw7seUl-zySe-HrH6cJV/view?usp=sharing</a></p><p style="margin-bottom: 0.1in; direction: ltr; line-height: 13.800000190734863px; text-align: left;" class="">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 style="margin-bottom: 0.1in; direction: ltr; line-height: 13.800000190734863px; text-align: left;" class="">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 style="margin-bottom: 0.1in; direction: ltr; line-height: 13.800000190734863px; text-align: left;" class="">Jim A</p></div></blockquote><div class=""> </div><div class=""><div class="">You can install dbrowswer in order to edit/view the SQLite:<span class="Apple-converted-space"> </span><br class=""></div><div class=""><pre style="direction: ltr; text-align: left;" class="">sudo apt-get install sqlitebrowser</pre></div><div class="">Then change the value for the channel to either 0 or 1 depending on whether you want to disable it.</div><br class=""></div></div></div></div></blockquote><p style="margin-bottom: 0.1in; direction: ltr; line-height: 13.800000190734863px; text-align: left; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration: none;" class="">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 style="margin-bottom: 0.1in; direction: ltr; line-height: 13.800000190734863px; text-align: left; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration: none;" class="">1. Using mythtv-setup > Channel Editor and marking a station/channel as invisible has nothing to do with what XMLTV > mythfilldatabase pull data for.<span class="Apple-converted-space"> </span><font size="+1" class=""><br class=""></font></p><p style="margin-bottom: 0.1in; direction: ltr; line-height: 13.800000190734863px; text-align: left; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration: none;" class="">2. running tv_grab_zz_sdjson_sqlite --manage-lineups --config-file $HOME/.mythtv/SD.xmltv<font size="+1" class=""><span class="Apple-converted-space"> </span>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 style="margin-bottom: 0.1in; direction: ltr; line-height: 13.800000190734863px; text-align: left; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration: none;" class=""><font size="+1" class="">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 style="margin-bottom: 0.1in; direction: ltr; line-height: 13.800000190734863px; text-align: left; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration: none;" class=""><font size="+1" class="">Jim A</font></p><p style="margin-bottom: 0.1in; direction: ltr; line-height: 13.800000190734863px; text-align: left; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration: none;" class=""><font size="+1" class=""><br class=""></font></p></div></blockquote>Since it was snowing this weekend, I had plenty of time to play with a test system using mythhdhrrecorder external recorder. I can solve my problem of getting 20 extra channels in the mythtv EPG that I don’t really want or can't receive with my tuners by doing an extra tv_grab_zz_sdjson_sqlite —manage-lineups after the —download-only step and before the "adjust the video source for the new grabber" step in the .PDF above.</div><div><br class=""></div><div>My understanding of the mythhdhrrecorder is that it’s will use the lock mechanism to select any available HDHR tuner on the network. I have a need to make sure my old 2 tuner Connect is used for channel 11-1 because it works and the Quadro does not on that channel. So I think I have a solution. I setup up all my tuners as external recorder blackboxes with the command /usr/bin/mythhdhrrecorder —hdhr 1043ECAB —devicename 0. I did 2 tuners for the 1043ECAB and 4 for the 1074C841. I made sure the devicenames were all unique.</div><div><br class=""></div><div>The way I think this works is when Mythtv-backend selects a tuner it will only pick an available HDHR tuner on the tuner box given by the --hdhr <id>. So only 4 of the backend tuner entries identify with 1074C841 Quatro’s 4 tuners, assuming no other app on the network has grabbed one fo the tuners using a iPad or something. The 2 additional backend tuner entries use the —hdhr 1043ECAB and have a LiveTV priority lower than the priorities for the 1074C841 tuners. This make sure my Livetv using Mythfrontend has a good chance of only running on the old Connect. So far that seems to be the case in testing. Also using a custom record priority clause that gives Duo% and channel 11-1 a high priority makes sure the recordings don’t end up on a Quatro.</div><div><br class=""></div><div>Once SiliconDust comes up with the promised patch I can just make my 2 HDHR boxes a collection of 6 channels it will be a lot easier.</div><div><br class=""></div><div>Jim A</div><div><br class=""></div><div><br class=""></div><div><br class=""></div><br class=""></body></html>