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

2005-10-22 Thread Ben Edwards
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)

2005-10-21 Thread Ben Edwards
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


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

2005-10-21 Thread Neale Swinnerton
 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 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' , 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)

2005-10-21 Thread Ben Edwards
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 whatever.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 wherecallsign='ITV1';update channel set icon='/usr/share/mythtv/logos/logo_itv3.gif',xmltvid='itv3.itv.co.uk' , visible=1 wherecallsign='ITV3';
update channel set icon='/usr/share/mythtv/logos/logo_itv2.gif',xmltvid='itv2.itv.co.uk' , visible=1 wherecallsign='ITV2';update channel set icon='/usr/share/mythtv/logos/logo_channelfour.gif',
xmltvid='channel4.com' , visible=1 wherecallsign='Channel 4';update channel set icon='/usr/share/mythtv/logos/logo_e4.gif',xmltvid='e4.channel4.com
' , visible=1 wherecallsign='E4';update channel set icon='/usr/share/mythtv/logos/logo_.gif', xmltvid='' ,visible=1 wherecallsign='705';update channel set icon='/usr/share/mythtv/logos/logo_itvnews.gif',
xmltvid='itn.co.uk' , visible=1 wherecallsign='ITV News';update channel set icon='/usr/share/mythtv/logos/logo_bbc1.gif',xmltvid='london.bbc1.bbc.co.uk
' , visible=1 wherecallsign='BBC ONE';update channel set icon='/usr/share/mythtv/logos/logo_bbc2.gif',xmltvid='london.bbc2.bbc.co.uk' , visible=1 wherecallsign='BBC TWO';
update channel set icon='/usr/share/mythtv/logos/logo_bbc3.gif',xmltvid='choice.bbc.co.uk' , visible=1 wherecallsign='BBC THREE';update channel set icon='/usr/share/mythtv/logos/logo_bbcnew24.gif',
xmltvid='news-24.bbc.co.uk' , visible=1 wherecallsign='BBC NEWS 24';update channel set icon='/usr/share/mythtv/logos/logo_bbci.gif',xmltvid='' , visible=1 wherecallsign='BBCi';
update channel set icon='/usr/share/mythtv/logos/logo_cbbc.gif',xmltvid='cbbc.bbc.co.uk' , visible=1 wherecallsign='CBBC Channel';update channel set icon='/usr/share/mythtv/logos/logo_parliament.gif',
xmltvid='parliament.bbc.co.uk' , visible=1 wherecallsign='BBC PARLMNT';update channel set icon='/usr/share/mythtv/logos/logo_bbc4.gif',xmltvid='
knowledge.bbc.co.uk' , visible=1 wherecallsign='BBC FOUR';update channel set icon='/usr/share/mythtv/logos/logo_cbeebies.gif',xmltvid='cbeebies.bbc.co.uk' , visible=1 wherecallsign='CBeebies';
update channel set icon='/usr/share/mythtv/logos/logo_community.gif',xmltvid='communitychannel.org' , visible=1 wherecallsign='Community';update channel set icon='/usr/share/mythtv/logos/logo_thehits.gif',
xmltvid='the-hits.emap.com' , visible=1 wherecallsign='The HITS';update channel set icon='/usr/share/mythtv/logos/logo_tmf.gif',xmltvid='tmf.nl
' , visible=1 wherecallsign='TMF';update channel set icon='/usr/share/mythtv/logos/logo_ukbrightideas.gif',xmltvid='ukbrightideas.tv' , visible=1 wherecallsign='UKTV Br''tIdeas';
update channel set icon='/usr/share/mythtv/logos/logo_ftn.gif',xmltvid='ftn.tv' , visible=1 wherecallsign='f tn';update channel set icon='/usr/share/mythtv/logos/logo_idealworld.gif',
xmltvid='idealworld.tv' , visible=1 wherecallsign='Ideal World';update channel set icon='/usr/share/mythtv/logos/logo_.gif',xmltvid='men.granadatv.co.uk
' , visible=1 wherecallsign='Men  Motors';update channel set icon='/usr/share/mythtv/logos/logo_five.gif',xmltvid='channel5.co.uk' , visible=1 wherecallsign='five';
update channel set icon='/usr/share/mythtv/logos/logo_qvc.gif',xmltvid='qvcuk.com' , visible=1 wherecallsign='QVC';update channel set icon='/usr/share/mythtv/logos/logo_abc1.gif',
xmltvid='abc1.disney.com' , visible=1 wherecallsign='abc1';update channel set icon='/usr/share/mythtv/logos/logo_bidtv.gif',xmltvid='bid-up.tv
' , visible=1 wherecallsign='bid tv';update channel set icon='/usr/share/mythtv/logos/logo_pricedroptv.gif',xmltvid='price-drop.tv' , visible=1 wherecallsign='price-drop tv';
update channel set icon='/usr/share/mythtv/logos/logo_skynews.gif',xmltvid='sky-news.sky.com' , visible=1 wherecallsign='Sky News';update channel set icon='/usr/share/mythtv/logos/logo_skysportsnews.gif',
xmltvid='news.sports.sky.com' , visible=1 

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

2005-10-21 Thread Neale Swinnerton

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