View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 9 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Sat Apr 18, 2009 6:42 pm 
Offline
Joined: Tue Mar 28, 2006 8:26 pm
Posts: 804
Location: Minneapolis, MN
When you do a channel scan with the Mythtv GUI (in Mythtv setup), where does the scanned channel information go? Which file?

Eric

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner


Top
 Profile  
 
 Post subject:
PostPosted: Sat Apr 18, 2009 7:09 pm 
Offline
Joined: Tue Jan 18, 2005 2:07 am
Posts: 1532
Location: California
It is stored in tables in the database -- "channel" and "dtv_multiplex". I know that dtv_multiplex is used for QAM tuners and that it is not used for analog or firewire tuners. I don't know if it is used for any other tuning scenarios, such as ATSC.

_________________
Marc

The views expressed are my own and do not necessarily reflect the views of my employer.


Top
 Profile  
 
 Post subject: how to view?
PostPosted: Sat Apr 18, 2009 10:41 pm 
Offline
Joined: Tue Mar 28, 2006 8:26 pm
Posts: 804
Location: Minneapolis, MN
OK. That explains why I didn't find any obvious files on the computer called "channel" or "channels".

The reason for the question - a friend was asking me how to view the list of scanned channels. He has an HD-5500 card. Since it is in the database rather than a simple text file, is there still a way to view it?

Eric

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner


Top
 Profile  
 
 Post subject:
PostPosted: Sat Apr 18, 2009 11:34 pm 
Offline
Joined: Tue Jan 18, 2005 2:07 am
Posts: 1532
Location: California
You can use webminto look from your browser. If you go this route look under servers->MySQL->mythconverg

Alternatively, from a shell window you can enter

Code:
mysql -uroot mythconverg -B --exec "select * from channel;"


This will dump a lot of info because there are a lot of column in that table. An interesting subset of columns:

Code:
 mysql -uroot mythconverg -B --exec "select channum,callsign,xmltvid from channel;"

_________________
Marc

The views expressed are my own and do not necessarily reflect the views of my employer.


Top
 Profile  
 
PostPosted: Sun Apr 19, 2009 2:41 pm 
Offline
Joined: Tue Mar 28, 2006 8:26 pm
Posts: 804
Location: Minneapolis, MN
Thanks for your responses, Marc. They have been a springboard!

I looked at the mythconverg database field names using Webmin and picked out the fields I think my friend wants to see.

I think this command line will produce a text file with his desired information.
Code:
mysql -uroot mythconverg -B --exec "select channum,callsign,freqid,atsc_major_chan,atsc_minor_chan from channel;" > /home/user/scannedchannels.txt

Code:
channum   callsign   freqid   atsc_major_chan   atsc_minor_chan
2.4   tpt Wx   16   2   4
2.9   data2   16   2   9
29.1   WFTC-HD   21   29   1
29.2   WFTC-SD   21   29   2
9.1   KMSP-HD   26   9   1
9.2   KMSP-SD   26   9   2
4.1   WCCO-DT   32   4   1
2.1   tpt 2   34   2   1
2.2   tpt MN   34   2   2
11.1   KARE-HD   35   11   1
11.2   KARE-WX   35   11   2
41.1   ION   40   41   1
41.2   qubo   40   41   2
41.3   IONLife   40   41   3
41.4   Worship   40   41   4
45.1   KSTCDT1   44   45   1
5.1   KSTPDT1   50   5   1
5.2   KSTPDT2   50   5   2
2.3   tptLife   16   2   3
23.1   WUCW-HD   22   23   1
23.2   WUCW-SD   22   23   2

:D

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner


Top
 Profile  
 
 Post subject:
PostPosted: Sun Apr 19, 2009 7:11 pm 
Offline
Joined: Tue Jan 18, 2005 2:07 am
Posts: 1532
Location: California
Glad to help out. What is your friend wanting to do with that information and what type of channels is your friend tuning? (ie, ATSC, clear QAM, analog, etc.) I ask because there are some other tables that sometimes come into play that may or may not be relevant, depending on the objective. As an example, the column "mplexid" is an index into dtv_multiple, which contains additional info. It is used for QAM tuning; not certain about ATSC, but I suspect so; never used for analog or firewire tuning. If I have a bit more context, I may be able to provide a few more points.

I've been playing with the channel tables quite a bit lately as I've been developing some scripts that semi-automate the process of setting up clear-QAM channels using data from Silicon Dust, Schedules direct and the mythtv database.

_________________
Marc

The views expressed are my own and do not necessarily reflect the views of my employer.


Top
 Profile  
 
PostPosted: Sun Apr 19, 2009 8:56 pm 
Offline
Joined: Tue Mar 28, 2006 8:26 pm
Posts: 804
Location: Minneapolis, MN
My friend said he wanted to keep track of the QAM cable channel lineup on his cable system over time. He said the lineup keeps changing.
I think the channel frequency and channel id number will probably be most useful.

My thought is that text files of the channel lineup will be the easiest to store and compare over time.

I've never tuned in QAM channels on cable with my HD-3000 and HD-5500 tuner cards, so I don't know what other data might be helpful for the channel list. Are there sub-channels like there are with over-the-air DTV (example, channel 2.1, 2.2, 2.3, etc)?

Eric

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner


Top
 Profile  
 
 Post subject:
PostPosted: Sun Apr 19, 2009 9:53 pm 
Offline
Joined: Tue Jan 18, 2005 2:07 am
Posts: 1532
Location: California
Try this query
Code:
select t1.chanid, t1.channum, t1.xmltvid, t1.callsign, t1.serviceid, t2.frequency, t1.name from channel t1, dtv_multiplex t2 where t1.sourceid=t2.sourceid and t1.mplexid=t2.mplexid;


I actually have a script that I am developing that helps with this type of problem. I have it tied to a cronjob the runs daily. It merges the data published by Silicon Dust with the data in the mythtv database, diffs that against what the data looked like the previous day and sends me an email message if anything has changed. This script is pretty bound up in my environment right now, so it isn't easy for me to make it available for others just yet, but if your interested, I'll work on making the changes so I that can give you a copy.

Also, if your friend isn't aware of the Silicon Dust QAM tuning data, he should check it out. It is very helpful and can be found at http://www.silicondust.com/hdhomerun/channels

In terms of your question -- the channel number that is exposed to the end-user is a simple number between 2 and 999. If you go down a layer, each "channel" has enough bandwidth to carry many sub-channels. I don't recall the exact numbers, but you can fit at least 2 hidef transmissions or 14-15 standard def transmission in one channel. The "serviceid" in the query above identifies the subchannel on the "frequency" that being used.

_________________
Marc

The views expressed are my own and do not necessarily reflect the views of my employer.


Top
 Profile  
 
 Post subject:
PostPosted: Mon May 04, 2009 1:16 am 
Offline
Site Admin
Joined: Fri Sep 19, 2003 6:37 pm
Posts: 2659
Location: Whittier, Ca
Why not use webmin to view the data?


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 9 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 27 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu