[mythtv-users] XMLTV and mythfilldatabase

[R. G. Newbury]

On 2020-03-28 1:28 p.m., Jack McGee wrote:
> 
> On 3/28/20 10:51 AM, R. G. Newbury wrote:
>> On 2020-03-27 2:14 p.m., Jack McGee wrote:
>>>
>>>>> 2020-03-27 06:19:26.741158 I  Grabber has capabilities: baseline 
>>>>> manualconfig preferredmethod lineups apiconfig
>>>>> 2020-03-27 06:19:27.241881 I  Grabber prefers method: allatonce
>>>>> 2020-03-27 06:19:27.242539 I  XMLTV config file is: 
>>>>> /home/mythtv/.mythtv/SD.xmltv
>>>>> 2020-03-27 06:20:48.346124 N  Unknown xmltv channel identifier: 
>>>>> I100147.json.schedulesdirect.org - Skipping channel.
>>>>> 2020-03-27 06:20:48.346434 N  Unknown xmltv channel identifier: 
>>>>> I100561.json.schedulesdirect.org - Skipping channel.
>>>>> (snip)
>>>>>
>>>>> whole bunch of these
>>>>>
>>>>>
>>>>> 2020-03-27 06:24:21.006700 N  Unknown xmltv channel identifier: 
>>
>> My previous response seems to have been lost due to the detour into 
>> whether the grabber was running. This output shows that it is running.
>>
>> 2020-03-27 06:19:27.242539 I  XMLTV config file is: 
>> /home/mythtv/.mythtv/SD.xmltv
>> 2020-03-27 06:20:48.346124 N  Unknown xmltv channel identifier: 
>> I100147.json.schedulesdirect.org - Skipping channel.
>> 2020-03-27 06:20:48.346434 N  Unknown xmltv channel identifier: 
>> I100561.json.schedulesdirect.org - Skipping channel.
>>
>> THIS output shows where the error lies.
>>
>> Edit your SD.xmltv file and try setting the wanted channel entries to 
>> the format:
>> channel=100147
>> channel!100148 etc.
>>
>> and re-run /usr/bin/mythfilldatabase.
>> Your setup is contacting the server, and downloading updates, but does 
>> not know where to put them, as it does not recognize the channel 
>> format. So, in the end, it deletes the updates.
>>
>>
> thanks. How do I edit that?
> 
> mythuser at amethi:~/.mythtv$ cat SD.xmltv
> database=/home/mythuser/.xmltv/SchedulesDirect.DB
> lineup=USA-OTA-76111
> 3rdparty-metadata=disabled
> mythtv-categories=enabled

Wow. My OTA.xmltv file looks like this:
cache=/home/mythtv/.xmltv/tv_grab_zz_sdjson.cache
channel-id-format=default
previously-shown-format=datetime
username=xxxxxxxx
password=xxxxxxxxxx
mode=channels
channels!CAN-0005580-X
channels!CAN-OTA-L5H3J2
channels=USA-OTA-14174
channel=31507
channel=24051 etc.
and a whack of
channel!12345  lines for the 20 odd I don't get or want.

> mythuser at amethi:~/.xmltv$ ls
> SchedulesDirect.DB  tv_grab_zz_sdjson.cache tv_grab_zz_sdjson_sqlite.conf

My conf file looks like thi:
cache=/home/mythtv/.xmltv/tv_grab_zz_sdjson.cache
channel-id-format=mythtv
previously-shown-format=datetime
username=xxxxxxxxxxxxxxx
password=xxxxxxxxxx
mode=lineup
lineup=CAN-0005580-X
lineup=CAN-OTA-L5H3J2
lineup=USA-OTA-14174

Your use of the sqlite grabber makes things slightly different.

The BIG thing is that you have no channels listd in the xmltv file. 
There quick route is to run a channel scan from mythtv-setup and then 
edit the xmltv file to allow/delete the channels you do not want. Then 
run mythfilldatabase, which is supposed to fill in everything, but in my 
experience (quite likely because I didn't do things in the correct 
order) you may have to use the Channel Editor in mythtv-setup, to check 
(and enter) details for each channel you want to receive. In my case, 
the actual xmltv id was missed and some channels were set to receive EIT 
(what??).

The foregoing paragraph MAY be entirely wrong because the sqlite grabber 
puts everything in the database. I do not know as I do not use the 
sqlite version. BUT in that case, run the grabber from a console, using 
the --configure option, and follow the prompts *exactly*. It is clear 
that you have a mismatch somewhere and the setup needs to be re-done.

In my setup, all three lineup's xmltvid files use the 'channel=31507' 
format, but the format recorded in the xmltvid column of the 'channel' 
table in mythconverg depends upon the 'channel-id-format' line of the 
xmltvid file.
A 'channel-id-format=mythtv' setting has the channels listed with a bare 
31507 in the channel table, while a channel-id-format=default' uses the 
full I31507.json.schedulesdirect.org format. You MAY be able to fix 
things by editing the xmltvid file to use the default format (but I 
would not bet much on that..).

BTW, with three lineups and 72 channels, my cache file is 45MB, so it 
does take a while to run an update.

Geoff









-- 
              R. Geoffrey Newbury			
              954 Owenwood Drive
          Mississauga, Ontario, L5H 3J2

       416-854-8160 newbury at mandamus.org