[mythtv-users] XMLTV json sqlite setup vs. what's needed for mythhdhrrecorder?
James Abernathy
jfabernathy at gmail.com
Sun Dec 9 12:04:17 UTC 2018
On 12/8/18 11:20 PM, William Jacoby wrote:
> On Sat, Dec 8, 2018 at 11:26 AM James Abernathy <jfabernathy at gmail.com
> <mailto:jfabernathy at gmail.com>> wrote:
>
> On my production system I've been using XMLTV json sqlite for a
> long time. I used the mythtv XMLTV wiki for that setup:
>
> 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
>
> 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.
>
> When I went through Gary's PDF (Use of the HDHR Premium TV service
> with MythTV.pdf)
> https://drive.google.com/file/d/19wChqgPjPtt5tw7seUl-zySe-HrH6cJV/view?usp=sharing
>
> 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.
>
> 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 :-)
>
> Jim A
>
> You can install dbrowswer in order to edit/view the SQLite:
> sudo apt-get install sqlitebrowser
> Then change the value for the channel to either 0 or 1 depending on
> whether you want to disable it.
>
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??
Jim A
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20181209/78e6c298/attachment.html>
More information about the mythtv-users
mailing list