[mythtv-users] how do I assign XMLTVIDs (was mythfilldatabase problem)

[Ben Edwards]

On 10/21/05, Neale Swinnerton <mythtv-users.spam at isismanor.com> wrote:
>
> >> Do you have XMLTVIDs associated with all the channels you want
> >> listings for, and do you have appropriate *.xmltv files for your video
> >> sources in your ~/.mythtv/ directory?
> >
> >
> > I've got the .xmltv file but dont know anything about assigning
> XMLTVIDs.
> > Did not c anything in the manual. Could someone plaease point me to
> > instuctions on how to do this.
> >
>
> 1. Delete all your channels
> 2. run a full scan, [ this will re-create the channels ]


Is this a DVB scan? Also don't I have to enter the first channel manualy?

Regards,
Ben

then log on to the database and execute the SQL below (adjust the bbc and
> itv ids if you're not in London)
>
> that'll get you most of the way (you'll have to create the logos of
> course. You can download the animated gifs from the frontpage of
> www.freeview.org <http://www.freeview.org> and split them up using the
> GIMP.
>
> Your goal is that this:
>
> select count(*) from channel where xmltvid is null or xmltvid = ''
>
> returns 0
>
> If you have an id in your <whatever>.xmltv file that's not in the DB
> you'll get a new channel created when you run mythfilldatabase, so make
> sure that the .xmltv file and the database are 'in sync'
>
>
>
>
> update channel set visible=0;
>
> update channel set icon='/usr/share/mythtv/logos/logo_itv1.gif',
> xmltvid='central.carlton.com <http://central.carlton.com>' , visible=1
> where callsign='ITV1';
> update channel set icon='/usr/share/mythtv/logos/logo_itv3.gif',
> xmltvid='itv3.itv.co.uk <http://itv3.itv.co.uk>' , visible=1 where
> callsign='ITV3';
> update channel set icon='/usr/share/mythtv/logos/logo_itv2.gif',
> xmltvid='itv2.itv.co.uk <http://itv2.itv.co.uk>' , visible=1 where
> callsign='ITV2';
> update channel set icon='/usr/share/mythtv/logos/logo_channelfour.gif',
> xmltvid='channel4.com <http://channel4.com>' , visible=1 where
> callsign='Channel 4';
> update channel set icon='/usr/share/mythtv/logos/logo_e4.gif',
> xmltvid='e4.channel4.com <http://e4.channel4.com>' , visible=1 where
> callsign='E4';
> update channel set icon='/usr/share/mythtv/logos/logo_.gif', xmltvid='' ,
> visible=1 where callsign='705';
> update channel set icon='/usr/share/mythtv/logos/logo_itvnews.gif',
> xmltvid='itn.co.uk <http://itn.co.uk>' , visible=1 where callsign='ITV
> News';
> update channel set icon='/usr/share/mythtv/logos/logo_bbc1.gif',
> xmltvid='london.bbc1.bbc.co.uk <http://london.bbc1.bbc.co.uk>' , visible=1
> where callsign='BBC ONE';
> update channel set icon='/usr/share/mythtv/logos/logo_bbc2.gif',
> xmltvid='london.bbc2.bbc.co.uk <http://london.bbc2.bbc.co.uk>' , visible=1
> where callsign='BBC TWO';
> update channel set icon='/usr/share/mythtv/logos/logo_bbc3.gif',
> xmltvid='choice.bbc.co.uk <http://choice.bbc.co.uk>' , visible=1 where
> callsign='BBC THREE';
> update channel set icon='/usr/share/mythtv/logos/logo_bbcnew24.gif',
> xmltvid='news-24.bbc.co.uk <http://news-24.bbc.co.uk>' , visible=1 where
> callsign='BBC NEWS 24';
> update channel set icon='/usr/share/mythtv/logos/logo_bbci.gif',
> xmltvid='' , visible=1 where callsign='BBCi';
> update channel set icon='/usr/share/mythtv/logos/logo_cbbc.gif',
> xmltvid='cbbc.bbc.co.uk <http://cbbc.bbc.co.uk>' , visible=1 where
> callsign='CBBC Channel';
> update channel set icon='/usr/share/mythtv/logos/logo_parliament.gif',
> xmltvid='parliament.bbc.co.uk <http://parliament.bbc.co.uk>' , visible=1
> where callsign='BBC PARLMNT';
> update channel set icon='/usr/share/mythtv/logos/logo_bbc4.gif',
> xmltvid='knowledge.bbc.co.uk <http://knowledge.bbc.co.uk>' , visible=1
> where callsign='BBC FOUR';
> update channel set icon='/usr/share/mythtv/logos/logo_cbeebies.gif',
> xmltvid='cbeebies.bbc.co.uk <http://cbeebies.bbc.co.uk>' , visible=1 where
> callsign='CBeebies';
> update channel set icon='/usr/share/mythtv/logos/logo_community.gif',
> xmltvid='communitychannel.org <http://communitychannel.org>' , visible=1
> where callsign='Community';
> update channel set icon='/usr/share/mythtv/logos/logo_thehits.gif',
> xmltvid='the-hits.emap.com <http://the-hits.emap.com>' , visible=1 where
> callsign='The HITS';
> update channel set icon='/usr/share/mythtv/logos/logo_tmf.gif',
> xmltvid='tmf.nl <http://tmf.nl>' , visible=1 where callsign='TMF';
> update channel set icon='/usr/share/mythtv/logos/logo_ukbrightideas.gif',
> xmltvid='ukbrightideas.tv <http://ukbrightideas.tv>' , visible=1 where
> callsign='UKTV Br''tIdeas';
> update channel set icon='/usr/share/mythtv/logos/logo_ftn.gif',
> xmltvid='ftn.tv <http://ftn.tv>' , visible=1 where callsign='f tn';
> update channel set icon='/usr/share/mythtv/logos/logo_idealworld.gif',
> xmltvid='idealworld.tv <http://idealworld.tv>' , visible=1 where
> callsign='Ideal World';
> update channel set icon='/usr/share/mythtv/logos/logo_.gif',
> xmltvid='men.granadatv.co.uk <http://men.granadatv.co.uk>' , visible=1
> where callsign='Men & Motors';
> update channel set icon='/usr/share/mythtv/logos/logo_five.gif',
> xmltvid='channel5.co.uk <http://channel5.co.uk>' , visible=1 where
> callsign='five';
> update channel set icon='/usr/share/mythtv/logos/logo_qvc.gif',
> xmltvid='qvcuk.com <http://qvcuk.com>' , visible=1 where callsign='QVC';
> update channel set icon='/usr/share/mythtv/logos/logo_abc1.gif',
> xmltvid='abc1.disney.com <http://abc1.disney.com>' , visible=1 where
> callsign='abc1';
> update channel set icon='/usr/share/mythtv/logos/logo_bidtv.gif',
> xmltvid='bid-up.tv <http://bid-up.tv>' , visible=1 where callsign='bid
> tv';
> update channel set icon='/usr/share/mythtv/logos/logo_pricedroptv.gif',
> xmltvid='price-drop.tv <http://price-drop.tv>' , visible=1 where
> callsign='price-drop tv';
> update channel set icon='/usr/share/mythtv/logos/logo_skynews.gif',
> xmltvid='sky-news.sky.com <http://sky-news.sky.com>' , visible=1 where
> callsign='Sky News';
> update channel set icon='/usr/share/mythtv/logos/logo_skysportsnews.gif',
> xmltvid='news.sports.sky.com <http://news.sports.sky.com>' , visible=1
> where callsign='Sky Spts News';
> update channel set icon='/usr/share/mythtv/logos/logo_skytravel.gif',
> xmltvid='travel.sky.co.uk <http://travel.sky.co.uk>' , visible=1 where
> callsign='Sky Travel';
> update channel set icon='/usr/share/mythtv/logos/logo_ukhistory.gif',
> xmltvid='ukhistory.tv <http://ukhistory.tv>' , visible=1 where
> callsign='UKTV History';
> update channel set icon='/usr/share/mythtv/logos/logo_e4+1.gif',
> xmltvid='plus-1.e4.channel4.com <http://plus-1.e4.channel4.com>' ,
> visible=1 where callsign='E4+1';
> update channel set icon='/usr/share/mythtv/logos/logo_more4.gif',
> xmltvid='more4.channel4.com <http://more4.channel4.com>' , visible=1 where
> callsign='More 4';
> update channel set icon='/usr/share/mythtv/logos/logo_.gif',
> xmltvid='terrestrial.teachers.tv <http://terrestrial.teachers.tv>' ,
> visible=1 where callsign='Teachers\'
> TV';
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>



--
Ben Edwards - Bristol, UK, England
WARNING:This email contained partisan views - dont ever accuse me of using
the veneer of objectivity
If you have a problem emailing me use
http://www.gurtlush.org.uk/profiles.php?uid=4
(email address this email is sent from may be defunct)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20051021/0385c023/attachment.htm