[mythtv-users] scheduling ...
johnpilk222 at gmail.com
Tue Feb 26 18:17:26 UTC 2019
On 26/02/2019 13:55, Stephen Worthington wrote:
> On Tue, 26 Feb 2019 13:19:49 +0000, you wrote:
>> On Tue, 26 Feb 2019 at 10:53, John Pilkington <johnpilk222 at gmail.com> wrote:
>>> On 26/02/2019 10:25, Stephen Worthington wrote:
>>>> Without having a copy of the EPG data it is hard to tell exactly what
>>>> the problem is, but my guess is that it is the usual problem - bad EPG
>>>> data. Ideally, the EPG data will be like this example from New
>>>> Zealand's Choice TV channel:
>>>> <programme channel="choice.freeviewnz.tv"
>>>> start="20190305153000 +1300" stop="20190305163000 +1300">
>>>> <title>Birds of Paradise: The Ultimate Quest</title>
>>>> <desc>Frank Gardner has always dreamed of seeing birds
>>>> of paradise. Frank and Benedict Allen journey across some of Earth’s
>>>> most inhospitable terrain, both haunted by brutal memories from their
>>>> <rating system="Freeview">
>>> Stephen: I haven't seen this sort of data before. Just haven't looked
>>> hard enough, I suppose. How?
>> If I am correct in thinking that this is mapped to ProgramId, then you can
>> get this information for any episode from the database via the MythTV
>> services API.
> Yes, that XML data gets mapped to program.programid in MythTV:
> MariaDB [mythconverg]> select * from program where title like 'Birds
> Of Paradise%'\G
> 1 row in set (0.00 sec)
Thank you to Ian and Stephen, and I hope it helps James.
I'm amazed that, given the size of Stephen's database, any query using
'like' has produced only one response :-)
More information about the mythtv-users