Mailing List Archive

where is grabber local database?
The XMLTV setup nightmare continues. Thanks to advice from this list I
switched to the sqlite grabber, and I was able to do a channel scan (even
though the documentation says a cable card can't do a channel scan).

Now I still can't successfully run mythfilldatabase. I don't know the name
of the local database created by tv_grab_zz_sdjson_sqlite
--manage-lineups. I don't know if I already created one or not. Where
would it be if it already exists? What would it look like?

Lloyd
Re: where is grabber local database? [ In reply to ]
I think I found it. Nevermind. Making more progress.


On Mon, Jul 5, 2021 at 2:18 PM Lloyd Chittenden <lloydc23@gmail.com> wrote:

> The XMLTV setup nightmare continues. Thanks to advice from this list I
> switched to the sqlite grabber, and I was able to do a channel scan (even
> though the documentation says a cable card can't do a channel scan).
>
> Now I still can't successfully run mythfilldatabase. I don't know the
> name of the local database created by tv_grab_zz_sdjson_sqlite
> --manage-lineups. I don't know if I already created one or not. Where
> would it be if it already exists? What would it look like?
>
> Lloyd
>
Re: where is grabber local database? [ In reply to ]
On 05/07/2021 21:18, Lloyd Chittenden wrote:

> The XMLTV setup nightmare continues.  Thanks to advice from this list
> I switched to the sqlite grabber, and I was able to do a channel scan
> (even though the documentation says a cable card can't do a channel scan).
>
> Now I still can't successfully run mythfilldatabase.  I don't know the
> name of the local database created by tv_grab_zz_sdjson_sqlite
> --manage-lineups.  I don't know if I already created one or not. 
> Where would it be if it already exists?  What would it look like?
>
> Lloyd
>
>

Normally it's a file called  SchedulesDirect.DB in the hidden .xmltv
directory in the home directory of the user that ran
tv_grab_zz_sdjson_sqlite --manage-lineups.

So if you used the mythtv user it will be in
/home/mythtv/.xmltv/SchedulesDirect.DB


The actual location of the database can be set in the .xmltv config file
for the source. This is mine for a source called FreeviewHD

$ cat FreeviewHD.xmltv

database=/home/mythtv/.xmltv/SchedulesDirect.DB
lineup=GBR-1000040-DEFAULT
mythtv-categories=enabled

Paul H.

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: where is grabber local database? [ In reply to ]
On 7/5/21 3:36 PM, Paul Harrison wrote:
> On 05/07/2021 21:18, Lloyd Chittenden wrote:
>
>> The XMLTV setup nightmare continues.  Thanks to advice from this list I switched to the sqlite grabber, and I was able to do a channel scan
>> (even though the documentation says a cable card can't do a channel scan).
>>
>> Now I still can't successfully run mythfilldatabase.  I don't know the name of the local database created by tv_grab_zz_sdjson_sqlite
>> --manage-lineups.  I don't know if I already created one or not.  Where would it be if it already exists?  What would it look like?
>>
>> Lloyd
>>
>>
>
> Normally it's a file called  SchedulesDirect.DB in the hidden .xmltv directory in the home directory of the user that ran
> tv_grab_zz_sdjson_sqlite --manage-lineups.
>
> So if you used the mythtv user it will be in /home/mythtv/.xmltv/SchedulesDirect.DB
>
>
> The actual location of the database can be set in the .xmltv config file for the source. This is mine for a source called FreeviewHD
>
> $ cat FreeviewHD.xmltv
>
> database=/home/mythtv/.xmltv/SchedulesDirect.DB
> lineup=GBR-1000040-DEFAULT
> mythtv-categories=enabled
>
> Paul H.

There's some ASCII art here with just the additions for XMLTV (the SQLite version):

https://forum.mythtv.org/viewtopic.php?f=36&t=3480&start=15#p19508

--
Bill
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org