On 10/21/05, <b class="gmail_sendername">Neale Swinnerton</b> <<a href="mailto:mythtv-users.spam@isismanor.com">mythtv-users.spam@isismanor.com</a>> wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
>> Do you have XMLTVIDs associated with all the channels you want<br>>> listings for, and do you have appropriate *.xmltv files for your video<br>>> sources in your ~/.mythtv/ directory?<br>><br>><br>
> I've got the .xmltv file but dont know anything about assigning XMLTVIDs.<br>> Did not c anything in the manual. Could someone plaease point me to<br>> instuctions on how to do this.<br>><br><br>1. Delete all your channels
<br>2. run a full scan, [ this will re-create the channels ]</blockquote><div><br>
Is this a DVB scan? Also don't I have to enter the first channel manualy?<br>
<br>
Regards,<br>
Ben<br>
</div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">then log on to the database and execute the SQL below (adjust the bbc and<br>itv ids if you're not in London)
<br><br>that'll get you most of the way (you'll have to create the logos of<br>course. You can download the animated gifs from the frontpage of<br><a href="http://www.freeview.org">www.freeview.org</a> and split them up using the GIMP.
<br><br>Your goal is that this:<br><br>select count(*) from channel where xmltvid is null or xmltvid = ''<br><br>returns 0<br><br>If you have an id in your <whatever>.xmltv file that's not in the DB<br>you'll get a new channel created when you run mythfilldatabase, so make
<br>sure that the .xmltv file and the database are 'in sync'<br><br><br><br><br>update channel set visible=0;<br><br>update channel set icon='/usr/share/mythtv/logos/logo_itv1.gif',<br>xmltvid='<a href="http://central.carlton.com">
central.carlton.com</a>' , visible=1 where callsign='ITV1';<br>update channel set icon='/usr/share/mythtv/logos/logo_itv3.gif',<br>xmltvid='<a href="http://itv3.itv.co.uk">itv3.itv.co.uk</a>' , visible=1 where callsign='ITV3';
<br>update channel set icon='/usr/share/mythtv/logos/logo_itv2.gif',<br>xmltvid='<a href="http://itv2.itv.co.uk">itv2.itv.co.uk</a>' , visible=1 where callsign='ITV2';<br>update channel set icon='/usr/share/mythtv/logos/logo_channelfour.gif',
<br>xmltvid='<a href="http://channel4.com">channel4.com</a>' , visible=1 where callsign='Channel 4';<br>update channel set icon='/usr/share/mythtv/logos/logo_e4.gif',<br>xmltvid='<a href="http://e4.channel4.com">e4.channel4.com
</a>' , visible=1 where callsign='E4';<br>update channel set icon='/usr/share/mythtv/logos/logo_.gif', xmltvid='' ,<br>visible=1 where callsign='705';<br>update channel set icon='/usr/share/mythtv/logos/logo_itvnews.gif',
<br>xmltvid='<a href="http://itn.co.uk">itn.co.uk</a>' , visible=1 where callsign='ITV News';<br>update channel set icon='/usr/share/mythtv/logos/logo_bbc1.gif',<br>xmltvid='<a href="http://london.bbc1.bbc.co.uk">london.bbc1.bbc.co.uk
</a>' , visible=1 where callsign='BBC ONE';<br>update channel set icon='/usr/share/mythtv/logos/logo_bbc2.gif',<br>xmltvid='<a href="http://london.bbc2.bbc.co.uk">london.bbc2.bbc.co.uk</a>' , visible=1 where callsign='BBC TWO';
<br>update channel set icon='/usr/share/mythtv/logos/logo_bbc3.gif',<br>xmltvid='<a href="http://choice.bbc.co.uk">choice.bbc.co.uk</a>' , visible=1 where callsign='BBC THREE';<br>update channel set icon='/usr/share/mythtv/logos/logo_bbcnew24.gif',
<br>xmltvid='<a href="http://news-24.bbc.co.uk">news-24.bbc.co.uk</a>' , visible=1 where callsign='BBC NEWS 24';<br>update channel set icon='/usr/share/mythtv/logos/logo_bbci.gif',<br>xmltvid='' , visible=1 where callsign='BBCi';
<br>update channel set icon='/usr/share/mythtv/logos/logo_cbbc.gif',<br>xmltvid='<a href="http://cbbc.bbc.co.uk">cbbc.bbc.co.uk</a>' , visible=1 where callsign='CBBC Channel';<br>update channel set icon='/usr/share/mythtv/logos/logo_parliament.gif',
<br>xmltvid='<a href="http://parliament.bbc.co.uk">parliament.bbc.co.uk</a>' , visible=1 where callsign='BBC PARLMNT';<br>update channel set icon='/usr/share/mythtv/logos/logo_bbc4.gif',<br>xmltvid='<a href="http://knowledge.bbc.co.uk">
knowledge.bbc.co.uk</a>' , visible=1 where callsign='BBC FOUR';<br>update channel set icon='/usr/share/mythtv/logos/logo_cbeebies.gif',<br>xmltvid='<a href="http://cbeebies.bbc.co.uk">cbeebies.bbc.co.uk</a>' , visible=1 where callsign='CBeebies';
<br>update channel set icon='/usr/share/mythtv/logos/logo_community.gif',<br>xmltvid='<a href="http://communitychannel.org">communitychannel.org</a>' , visible=1 where callsign='Community';<br>update channel set icon='/usr/share/mythtv/logos/logo_thehits.gif',
<br>xmltvid='<a href="http://the-hits.emap.com">the-hits.emap.com</a>' , visible=1 where callsign='The HITS';<br>update channel set icon='/usr/share/mythtv/logos/logo_tmf.gif',<br>xmltvid='<a href="http://tmf.nl">tmf.nl</a>
' , visible=1 where callsign='TMF';<br>update channel set icon='/usr/share/mythtv/logos/logo_ukbrightideas.gif',<br>xmltvid='<a href="http://ukbrightideas.tv">ukbrightideas.tv</a>' , visible=1 where callsign='UKTV Br''tIdeas';
<br>update channel set icon='/usr/share/mythtv/logos/logo_ftn.gif',<br>xmltvid='<a href="http://ftn.tv">ftn.tv</a>' , visible=1 where callsign='f tn';<br>update channel set icon='/usr/share/mythtv/logos/logo_idealworld.gif',
<br>xmltvid='<a href="http://idealworld.tv">idealworld.tv</a>' , visible=1 where callsign='Ideal World';<br>update channel set icon='/usr/share/mythtv/logos/logo_.gif',<br>xmltvid='<a href="http://men.granadatv.co.uk">men.granadatv.co.uk
</a>' , visible=1 where callsign='Men & Motors';<br>update channel set icon='/usr/share/mythtv/logos/logo_five.gif',<br>xmltvid='<a href="http://channel5.co.uk">channel5.co.uk</a>' , visible=1 where callsign='five';
<br>update channel set icon='/usr/share/mythtv/logos/logo_qvc.gif',<br>xmltvid='<a href="http://qvcuk.com">qvcuk.com</a>' , visible=1 where callsign='QVC';<br>update channel set icon='/usr/share/mythtv/logos/logo_abc1.gif',
<br>xmltvid='<a href="http://abc1.disney.com">abc1.disney.com</a>' , visible=1 where callsign='abc1';<br>update channel set icon='/usr/share/mythtv/logos/logo_bidtv.gif',<br>xmltvid='<a href="http://bid-up.tv">bid-up.tv</a>
' , visible=1 where callsign='bid tv';<br>update channel set icon='/usr/share/mythtv/logos/logo_pricedroptv.gif',<br>xmltvid='<a href="http://price-drop.tv">price-drop.tv</a>' , visible=1 where callsign='price-drop tv';
<br>update channel set icon='/usr/share/mythtv/logos/logo_skynews.gif',<br>xmltvid='<a href="http://sky-news.sky.com">sky-news.sky.com</a>' , visible=1 where callsign='Sky News';<br>update channel set icon='/usr/share/mythtv/logos/logo_skysportsnews.gif',
<br>xmltvid='<a href="http://news.sports.sky.com">news.sports.sky.com</a>' , visible=1 where callsign='Sky Spts News';<br>update channel set icon='/usr/share/mythtv/logos/logo_skytravel.gif',<br>xmltvid='<a href="http://travel.sky.co.uk">
travel.sky.co.uk</a>' , visible=1 where callsign='Sky Travel';<br>update channel set icon='/usr/share/mythtv/logos/logo_ukhistory.gif',<br>xmltvid='<a href="http://ukhistory.tv">ukhistory.tv</a>' , visible=1 where callsign='UKTV History';
<br>update channel set icon='/usr/share/mythtv/logos/logo_e4+1.gif',<br>xmltvid='<a href="http://plus-1.e4.channel4.com">plus-1.e4.channel4.com</a>' , visible=1 where callsign='E4+1';<br>update channel set icon='/usr/share/mythtv/logos/logo_more4.gif',
<br>xmltvid='<a href="http://more4.channel4.com">more4.channel4.com</a>' , visible=1 where callsign='More 4';<br>update channel set icon='/usr/share/mythtv/logos/logo_.gif',<br>xmltvid='<a href="http://terrestrial.teachers.tv">
terrestrial.teachers.tv</a>' , visible=1 where callsign='Teachers\'<br>TV';<br><br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org
</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote></div><br><br clear="all"><br>-- <br>Ben Edwards - Bristol, UK, England
<br>WARNING:This email contained partisan views - dont ever accuse me of using the veneer of objectivity<br>If you have a problem emailing me use<br><a href="http://www.gurtlush.org.uk/profiles.php?uid=4">http://www.gurtlush.org.uk/profiles.php?uid=4
</a><br>(email address this email is sent from may be defunct)