<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<meta name="Generator" content="Zarafa WebAccess v7.1.9-44333">
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>RE: [mythtv-users] SD UK - "To be announced" data in listings</title>
<style type="text/css">
body
{
font-family: Arial, Verdana, Sans-Serif ! important;
font-size: 12px;
padding: 5px 5px 5px 5px;
margin: 0px;
border-style: none;
background-color: #ffffff;
}
p, ul, li
{
margin-top: 0px;
margin-bottom: 0px;
}
</style>
</head>
<body>
<blockquote style="border-left: 2px solid #325FBA; padding-left: 5px;margin-left:5px;">-----Original message-----<br /><strong>From:</strong> Mike Bibbings <mike.bibbings@gmail.com><br /><strong>Sent:</strong> Fri 23-09-2016 10:03<br /><strong>Subject:</strong> Re: [mythtv-users] SD UK - "To be announced" data in listings<br /><strong>To:</strong> Discussion about MythTV <mythtv-users@mythtv.org>; <br />On 23/09/16 08:07, Simon Hobson wrote:<br />> I definitely still have something odd going on.<br />> I have some listings data going forward for 21 days.<br />> BBC2 is showing data going about 14 days.<br />> But most of the main TV channels are down to just 7 days of data with a further week of "To Be Announced" which was in there before I started filtering it.<br />><br />> One thought is to manually remove all the TBA entries from the database - I assume this is just "delete from <some table> where title = 'To Be Ann
ounced'" ?<br />><br />> _______________________________________________<br />> mythtv-users mailing list<br />> mythtv-users@mythtv.org<br />> http://lists.mythtv.org/mailman/listinfo/mythtv-users<br />> http://wiki.mythtv.org/Mailing_List_etiquette<br />> MythTV Forums: https://forum.mythtv.org<br /><br />I am seeing similar to you on both my lineups UK Freesat and Freeview on <br />my main mythtv backend. A test backend is showing the same thing UK <br />Freeview only.<br /><br />It may just be that SchedulesDirect have not yet had an update for the <br />main channels, I am not sure how often they get updated data from their <br />supplier.<br /><br />I use the following sql to get a listing of "real" guide data remaining <br />for each channel:<br /><br />select MAX(program.endtime) AS "Last_End_Date", <br />channel.name,channel.channum, channel.chanid, channel.xmltvid, <br />DATEDIFF(MAX(program.endtime), NOW()) as <br />Guide_
Days_Remaining,channel.sourceid from program left join channel on <br />channel.chanid = program.chanid where program.title<>"To Be Announced" <br />group by chanid order by Last_End_Date;<br /><br />Mike<br /><br /><br />_______________________________________________<br />mythtv-users mailing list<br />mythtv-users@mythtv.org<br />http://lists.mythtv.org/mailman/listinfo/mythtv-users<br />http://wiki.mythtv.org/Mailing_List_etiquette<br />MythTV Forums: https://forum.mythtv.org<br /></blockquote><p>As far as I can work out, most (all?) channel schedules are only updated overnight on a Friday. So, if you run your mythfilldatabase around 02:00 AM tonight, you should find that your listings are updated up till Friday 7th October. There are some channels that seem to have a longer set of results, up to 21 days in some cases, but these are not always complete (Sky Arts is an example).</p><p> </p><p>Dave.<br /> </p>
<br><img height="1" width="1" border="0" src="http://go.rm0010.net/open/067A8608A17441E1802DC5BB04E48136"></body></html>