Re: [mythtv-users] Manually enter freq. in database.
On 01/28/2006 04:18 AM, Tom Burt wrote: > On Friday 27 January 2006 23:00, Martin Madsen wrote: > >> Hi Myth-list, >> I'm using a Hauppauge PVR 350 and MythTV running on a Ubuntu linux. >> My backend starts fine but I cannot see any channels. (Only snow on the >> screen) >> I'm using XMLTV. >> So I'm looking for a way to put the frequencies into my database manually >> because the "scan channels" option in mythtv-setup doesn't work (I can't >> select it.) >> Anybody knows what to look after in the database and in what format I need >> to plug in the frequencies? My frequencies are listed on my cable >> provider's homepage in this format: >> http://www.tre-for.dk/default.aspx?m=2&i=220 >> > > You have to update the columns "freqid" and "finetune" in the table > "channel". > I had the same problem as you, so I created an Openoffice spreadsheet that > generates the necessary update statements from something like your web page. > The idea is that you search the frequency closest to yours in the "official" > list of channels which will give freqid (e.g. 48.250MHz -> E2, 55.250MHz -> > E3, 62.250MHz -> E4 etc.) and then calculate > finetune = ( - ) * 16 > If you are interested, I can send you the spreadsheet or give all the details > if you prefer to use a different tool. > Note, also, that you can change channum, freqid, and finetune using MythWeb's channel settings page... Mike ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Manually enter freq. in database.
>On 28/01/06, Martin Madsen <[EMAIL PROTECTED]> wrote: > >> Ok in your calculation you use "official freq" which I think is the one >on >> www.tre-for.dk but "your freq" is a little hard to find since I haven't >been >> able to find a utility that is able to scan for channels on my PVR 350. > >There's a useful utility called ptune-ui which allows you to tune your >card and see the results onscreen along with the channel numbers. This >is detailed on Jarod Wilson Fedora HOWTO here >http://wilsonet.com/mythtv/fcmyth.php#capture. I Will look into this utility, it's actually just the thing I need for this to come together. Thanks, Best Regards Martin Madsen >Nick I am using the free version of SPAMfighter for private users. It has removed 467 spam emails to date. Paying users do not have this message in their emails. Try www.SPAMfighter.com for free now! ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Manually enter freq. in database.
>> >> I'm using XMLTV. >> >> So I'm looking for a way to put the frequencies into my database >> >> manually because the "scan channels" option in mythtv-setup doesn't >work >> >> (I can't select it.) >> >> Anybody knows what to look after in the database and in what format I >> >>need >> >> to plug in the frequencies? My frequencies are listed on my cable >> >> provider's homepage in this format: >> >> http://www.tre-for.dk/default.aspx?m=2&i=220 >> > >> >You have to update the columns "freqid" and "finetune" in the table >> >"channel". >> >> Ok and the "channum" I can set to what ever I like, depending where I want >> the channel when zapping in mythfrontend? > >Yes, as far as I know. > >> >The idea is that you search the frequency closest to yours in the >> >"official" >> >list of channels which will give freqid (e.g. 48.250MHz -> E2, 55.250MHz >> > -> >> > >> >E3, 62.250MHz -> E4 etc.) >> >> I think you are getting close to my root (not the user :)) problem(s) >now. >> >> 1. I don't know exactly what number to put under "freqid" under channels >in >> my database. If the Danish channel "TV2" if running on 175,25MHz will I >put >> in 175,25 | 17525 | 175250 or something else? > >You would put "E5" into freqid because that is the official identifier of >the >channel that has the standard frequency of 175.25MHz. > >> >and then calculate >> >finetune = ( - ) * 16 >> Ok in your calculation you use "official freq" which I think is the one on >> www.tre-for.dk but "your freq" is a little hard to find since I haven't >> been able to find a utility that is able to scan for channels on my PVR >> 350. >I'm probably using the wrong terminology, but by "your freq" I meant the >actual frequency that you want to tune which is what your provider uses, or >to be more precise, the frequency that your capture card thinks it is set to >when tuned to the channel in question :). And "official freq" would be the >frequency that is the standard frequency for the given freqid. Your provider >could use non-standard frequencies which fall between two standard freqs, >that's why you have finetune. > >Anyway, I checked the web page you mentioned and found 13 channels there. >For >the first 11 of them, set freqid to "E" and the value under Kanal >concatenated (i.e. "E2", "E3", ... "E12") and for the last two channels >freqid is "SE9" and "SE10" respectively. Finetune is 0 for all the channels. >Hope this helps :) >Tom That is really great information Tom, I have tried to put the pieces together all day and I have now finally figured out what you mean. The reason why I took so long even with your fine explanation was: 1. The listings on www.tre-for.dk doesn't fit the signal im getting here for some reason. Might have something to do with tre-for has only recently taken over the company who delivers cable for me. For example the E10 ID should be 210,25MHz and the Channel DR1. But it is in fact a whole other channel. 2. I couldn't get the ivtv-tune utility to show other than "us-cable". The reason was me. :D Because I thought I had to issue "ivtv-tune -t europe-west" to set the settings to Europe-west, followed by "ivtv-tune -l" and then read the output. The right thing is of course: "ivtv-tune -t europe-west -l" in one single command. Now the only thing I miss (for now :D) is the REAL frequencies for my cable since the ones on www.tre-for.dk doesn't fit for me, however I don't expect any of you to help me with that. I'll have to find them myself. I'll start off with ptune-ui which has been suggested in another post (Thanks to Nick the knowledgejunkie :D) Thanks for any help provided. I will use this help to help2-3 coworkers who have also bought hardware for at mythbox and who, if it's possible, is more newbs at this than me :) Best Regards Martin Madsen I am using the free version of SPAMfighter for private users. It has removed 467 spam emails to date. Paying users do not have this message in their emails. Try www.SPAMfighter.com for free now! ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Manually enter freq. in database.
On 28/01/06, Martin Madsen <[EMAIL PROTECTED]> wrote: > Ok in your calculation you use "official freq" which I think is the one on > www.tre-for.dk but "your freq" is a little hard to find since I haven't been > able to find a utility that is able to scan for channels on my PVR 350. There's a useful utility called ptune-ui which allows you to tune your card and see the results onscreen along with the channel numbers. This is detailed on Jarod Wilson Fedora HOWTO here http://wilsonet.com/mythtv/fcmyth.php#capture. Nick ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Manually enter freq. in database.
> >> I'm using XMLTV. > >> So I'm looking for a way to put the frequencies into my database > >> manually because the "scan channels" option in mythtv-setup doesn't work > >> (I can't select it.) > >> Anybody knows what to look after in the database and in what format I > >>need > >> to plug in the frequencies? My frequencies are listed on my cable > >> provider's homepage in this format: > >> http://www.tre-for.dk/default.aspx?m=2&i=220 > > > >You have to update the columns "freqid" and "finetune" in the table > >"channel". > > Ok and the "channum" I can set to what ever I like, depending where I want > the channel when zapping in mythfrontend? Yes, as far as I know. > >The idea is that you search the frequency closest to yours in the > >"official" > >list of channels which will give freqid (e.g. 48.250MHz -> E2, 55.250MHz > > -> > > > >E3, 62.250MHz -> E4 etc.) > > I think you are getting close to my root (not the user :)) problem(s) now. > > 1. I don't know exactly what number to put under "freqid" under channels in > my database. If the Danish channel "TV2" if running on 175,25MHz will I put > in 175,25 | 17525 | 175250 or something else? You would put "E5" into freqid because that is the official identifier of the channel that has the standard frequency of 175.25MHz. > >and then calculate > >finetune = ( - ) * 16 > Ok in your calculation you use "official freq" which I think is the one on > www.tre-for.dk but "your freq" is a little hard to find since I haven't > been able to find a utility that is able to scan for channels on my PVR > 350. I'm probably using the wrong terminology, but by "your freq" I meant the actual frequency that you want to tune which is what your provider uses, or to be more precise, the frequency that your capture card thinks it is set to when tuned to the channel in question :). And "official freq" would be the frequency that is the standard frequency for the given freqid. Your provider could use non-standard frequencies which fall between two standard freqs, that's why you have finetune. Anyway, I checked the web page you mentioned and found 13 channels there. For the first 11 of them, set freqid to "E" and the value under Kanal concatenated (i.e. "E2", "E3", ... "E12") and for the last two channels freqid is "SE9" and "SE10" respectively. Finetune is 0 for all the channels. Hope this helps :) Tom ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Manually enter freq. in database.
>On Friday 27 January 2006 23:00, Martin Madsen wrote: >> Hi Myth-list, >> I'm using a Hauppauge PVR 350 and MythTV running on a Ubuntu linux. >> My backend starts fine but I cannot see any channels. (Only snow on the >> screen) >> I'm using XMLTV. >> So I'm looking for a way to put the frequencies into my database manually >> because the "scan channels" option in mythtv-setup doesn't work (I can't >> select it.) >> Anybody knows what to look after in the database and in what format I >>need >> to plug in the frequencies? My frequencies are listed on my cable >> provider's homepage in this format: >> http://www.tre-for.dk/default.aspx?m=2&i=220 > >You have to update the columns "freqid" and "finetune" in the table >"channel". Ok and the "channum" I can set to what ever I like, depending where I want the channel when zapping in mythfrontend? >I had the same problem as you, so I created an Openoffice spreadsheet that >generates the necessary update statements from something like your web >page. That sounds like the way to do it, and I have the info on the page I linked to en my earlier post. I use PHPMYAdmin to update the data but that shouldn't matter. >The idea is that you search the frequency closest to yours in the >"official" >list of channels which will give freqid (e.g. 48.250MHz -> E2, 55.250MHz -> >E3, 62.250MHz -> E4 etc.) I think you are getting close to my root (not the user :)) problem(s) now. 1. I don't know exactly what number to put under "freqid" under channels in my database. If the Danish channel "TV2" if running on 175,25MHz will I put in 175,25 | 17525 | 175250 or something else? 2. I'm a bit confused by the E2, E3 ect. But I suspect them to be channel numbers like the ones I see when issuing "ivtv-tune -l" at the very end of the list. Sadly when I issue the command "ivtv-tune -l" it shows the "us-cable" channels/frequencies. I should be able to change that by issuing "ivtv-tune -t europe-west" but still the "ivtv -l" shows "us-cable" at the top of the list. Now I don't know if this is important but I would rather be sure since I have struggled all week with myth. :) >and then calculate >finetune = ( - ) * 16 >If you are interested, I can send you the spreadsheet or give all the >details >if you prefer to use a different tool. >Tom Ok in your calculation you use "official freq" which I think is the one on www.tre-for.dk but "your freq" is a little hard to find since I haven't been able to find a utility that is able to scan for channels on my PVR 350. Thankyou very much for your help, I really appreciate it. :) Best Regards Martin I am using the free version of SPAMfighter for private users. It has removed 466 spam emails to date. Paying users do not have this message in their emails. Try www.SPAMfighter.com for free now! ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
Re: [mythtv-users] Manually enter freq. in database.
On Friday 27 January 2006 23:00, Martin Madsen wrote: > Hi Myth-list, > I'm using a Hauppauge PVR 350 and MythTV running on a Ubuntu linux. > My backend starts fine but I cannot see any channels. (Only snow on the > screen) > I'm using XMLTV. > So I'm looking for a way to put the frequencies into my database manually > because the "scan channels" option in mythtv-setup doesn't work (I can't > select it.) > Anybody knows what to look after in the database and in what format I need > to plug in the frequencies? My frequencies are listed on my cable > provider's homepage in this format: > http://www.tre-for.dk/default.aspx?m=2&i=220 You have to update the columns "freqid" and "finetune" in the table "channel". I had the same problem as you, so I created an Openoffice spreadsheet that generates the necessary update statements from something like your web page. The idea is that you search the frequency closest to yours in the "official" list of channels which will give freqid (e.g. 48.250MHz -> E2, 55.250MHz -> E3, 62.250MHz -> E4 etc.) and then calculate finetune = ( - ) * 16 If you are interested, I can send you the spreadsheet or give all the details if you prefer to use a different tool. Tom ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
[mythtv-users] Manually enter freq. in database.
Hi Myth-list, I’m using a Hauppauge PVR 350 and MythTV running on a Ubuntu linux. My backend starts fine but I cannot see any channels. (Only snow on the screen) I’m using XMLTV. So I’m looking for a way to put the frequencies into my database manually because the “scan channels” option in mythtv-setup doesn’t work (I can’t select it.) Anybody knows what to look after in the database and in what format I need to plug in the frequencies? My frequencies are listed on my cable provider’s homepage in this format: http://www.tre-for.dk/default.aspx?m=2&i=220 Any input about why “scan channels” doesn’t work will be appreciated too. Sorry for my bad English. Best Regards Martin I am using the free version of SPAMfighter for private users.It has removed 466 spam emails to date.Paying users do not have this message in their emails.Try SPAMfighter for free now! ___ mythtv-users mailing list mythtv-users@mythtv.org http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users