Re: [mythtv-users] how do I assign XMLTVIDs (was mythfilldatabase problem)
On 10/21/05, Neale Swinnerton <[EMAIL PROTECTED]> wrote: Ben Edwards wrote:>> Is this a DVB scan? Also don't I have to enter the first channel manualy?>yes, I'd assumed you were using a DVB-T card, but I see you never saidthat. :-) If you are using some other type of card you'll have to create the channels yourself.You don't have to enter the first channel manually for a DVB-T scan (Icertainly don't), why do you think that? OK, so I guess there is a problem because the full scan does not set up and channels. Think I will abandon breezy and give knoppixmyth a go. I was compiling from latest cvs, maybe there is a problem with that. Ben ___mythtv-users mailing list mythtv-users@mythtv.orghttp://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 objectivityIf you have a problem emailing me usehttp://www.gurtlush.org.uk/profiles.php?uid=4 (email address this email is sent from may be defunct) ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] how do I assign XMLTVIDs (was mythfilldatabase problem)
Ben Edwards wrote: Is this a DVB scan? Also don't I have to enter the first channel manualy? yes, I'd assumed you were using a DVB-T card, but I see you never said that. :-) If you are using some other type of card you'll have to create the channels yourself. You don't have to enter the first channel manually for a DVB-T scan (I certainly don't), why do you think that? ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] how do I assign XMLTVIDs (was mythfilldatabase problem)
On 10/21/05, Neale Swinnerton <[EMAIL PROTECTED]> 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 anditv ids if you're not in London) that'll get you most of the way (you'll have to create the logos ofcourse. You can download the animated gifs from the frontpage ofwww.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 0If you have an id in your .xmltv file that's not in the DByou'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' , visible=1 where callsign='ITV1';update channel set icon='/usr/share/mythtv/logos/logo_itv3.gif',xmltvid='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' , visible=1 where callsign='ITV2';update channel set icon='/usr/share/mythtv/logos/logo_channelfour.gif', xmltvid='channel4.com' , visible=1 where callsign='Channel 4';update channel set icon='/usr/share/mythtv/logos/logo_e4.gif',xmltvid='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' , visible=1 where callsign='ITV News';update channel set icon='/usr/share/mythtv/logos/logo_bbc1.gif',xmltvid='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' , visible=1 where callsign='BBC TWO'; update channel set icon='/usr/share/mythtv/logos/logo_bbc3.gif',xmltvid='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' , 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' , visible=1 where callsign='CBBC Channel';update channel set icon='/usr/share/mythtv/logos/logo_parliament.gif', xmltvid='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' , visible=1 where callsign='BBC FOUR';update channel set icon='/usr/share/mythtv/logos/logo_cbeebies.gif',xmltvid='cbeebies.bbc.co.uk' , visible=1 where callsign='CBeebies'; update channel set icon='/usr/share/mythtv/logos/logo_community.gif',xmltvid='communitychannel.org' , visible=1 where callsign='Community';update channel set icon='/usr/share/mythtv/logos/logo_thehits.gif', xmltvid='the-hits.emap.com' , visible=1 where callsign='The HITS';update channel set icon='/usr/share/mythtv/logos/logo_tmf.gif',xmltvid='tmf.nl ' , visible=1 where callsign='TMF';update channel set icon='/usr/share/mythtv/logos/logo_ukbrightideas.gif',xmltvid='ukbrightideas.tv' , visible=1 where callsign='UKTV Br''tIdeas'; update channel set icon='/usr/share/mythtv/logos/logo_ftn.gif',xmltvid='ftn.tv' , visible=1 where callsign='f tn';update channel set icon='/usr/share/mythtv/logos/logo_idealworld.gif', xmltvid='idealworld.tv' , visible=1 where callsign='Ideal World';update channel set icon='/usr/share/mythtv/logos/logo_.gif',xmltvid='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' , visible=1 where callsign='five'; update channel set icon='/usr/share/mythtv/logos/logo_qvc.gif',xmltvid='qvcuk.com' , visible=1 where callsign='QVC';update channel set icon='/usr/share/mythtv/logos/logo_abc1.gif', xmltvid='abc1.disney.com' , visible=1 where callsign='abc1';update channel set icon='/usr/share/mythtv/logos/logo_bidtv.gif',xmltvid='bid-up.tv ' , visible=1 where callsign='bid tv';update channel set icon='/usr/share/mythtv/logos/logo_pricedroptv.gif',xmltvid='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' , visible=1 where callsign='Sky News';update channel set icon='/usr/share/mythtv/logos/logo_sk
Re: [mythtv-users] how do I assign XMLTVIDs (was mythfilldatabase problem)
>> 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 ] 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 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 .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' , visible=1 where callsign='ITV1'; update channel set icon='/usr/share/mythtv/logos/logo_itv3.gif', xmltvid='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' , visible=1 where callsign='ITV2'; update channel set icon='/usr/share/mythtv/logos/logo_channelfour.gif', xmltvid='channel4.com' , visible=1 where callsign='Channel 4'; update channel set icon='/usr/share/mythtv/logos/logo_e4.gif', xmltvid='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' , visible=1 where callsign='ITV News'; update channel set icon='/usr/share/mythtv/logos/logo_bbc1.gif', xmltvid='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' , visible=1 where callsign='BBC TWO'; update channel set icon='/usr/share/mythtv/logos/logo_bbc3.gif', xmltvid='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' , 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' , visible=1 where callsign='CBBC Channel'; update channel set icon='/usr/share/mythtv/logos/logo_parliament.gif', xmltvid='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' , visible=1 where callsign='BBC FOUR'; update channel set icon='/usr/share/mythtv/logos/logo_cbeebies.gif', xmltvid='cbeebies.bbc.co.uk' , visible=1 where callsign='CBeebies'; update channel set icon='/usr/share/mythtv/logos/logo_community.gif', xmltvid='communitychannel.org' , visible=1 where callsign='Community'; update channel set icon='/usr/share/mythtv/logos/logo_thehits.gif', xmltvid='the-hits.emap.com' , visible=1 where callsign='The HITS'; update channel set icon='/usr/share/mythtv/logos/logo_tmf.gif', xmltvid='tmf.nl' , visible=1 where callsign='TMF'; update channel set icon='/usr/share/mythtv/logos/logo_ukbrightideas.gif', xmltvid='ukbrightideas.tv' , visible=1 where callsign='UKTV Br''tIdeas'; update channel set icon='/usr/share/mythtv/logos/logo_ftn.gif', xmltvid='ftn.tv' , visible=1 where callsign='f tn'; update channel set icon='/usr/share/mythtv/logos/logo_idealworld.gif', xmltvid='idealworld.tv' , visible=1 where callsign='Ideal World'; update channel set icon='/usr/share/mythtv/logos/logo_.gif', xmltvid='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' , visible=1 where callsign='five'; update channel set icon='/usr/share/mythtv/logos/logo_qvc.gif', xmltvid='qvcuk.com' , visible=1 where callsign='QVC'; update channel set icon='/usr/share/mythtv/logos/logo_abc1.gif', xmltvid='abc1.disney.com' , visible=1 where callsign='abc1'; update channel set icon='/usr/share/mythtv/logos/logo_bidtv.gif', xmltvid='bid-up.tv' , visible=1 where callsign='bid tv'; update channel set icon='/usr/share/mythtv/logos/logo_pricedroptv.gif', xmltvid='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' , visible=1 where callsign='Sky News'; update channel set icon='/usr/share/mythtv/logos/logo_skysportsnews.gif', xmltvid='news.sports.sky.com' , visible=1 where callsign='Sky
Re: [mythtv-users] how do I assign XMLTVIDs (was mythfilldatabase problem)
On 10/20/05, Nick <[EMAIL PROTECTED]> wrote: On 20/10/05, Ben Edwards <[EMAIL PROTECTED]> wrote:> Ime using the uk_rt grabber. I have got the channels listed in mythtv-setup> but they are all listed twice. There is hovever no listing data. Below is > what I get when I run mythfilldatabase followed by a section oof the> mythbackend output that seems relevent (run with -varbose all).>> Any ideas?Do you have XMLTVIDs associated with all the channels you want listings for, and do you have appropriate *.xmltv files for your videosources 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. Regards, Ben Nick___mythtv-users mailing list mythtv-users@mythtv.orghttp://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users -- Ben Edwards - Bristol, UK, EnglandWARNING:This email contained partisan views - dont ever accuse me of using the veneer of objectivityIf 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) ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users