First step is to download the appropriate channel listing from https://www.satellite-calculations.com/ ... Number.php. This is an html file but the table data is easily converted into a csv file using an online utility such as this one. http://www.convertcsv.com/html-table-to-csv.htm
The csv can be imported into a dbase (I use dBeaver for database management) and a query can be run against the resulting table and the channel table in mythconverg, eg.
update mythconverg.channel
join freesattable on mythconverg.channel.serviceid = tempdb.freesat.datatable.SID
set channum = `channel number`,
name = `Service Name`
I also made a table from some other info I found in another source which I’m not quite sure about but:
Code: Select all
|chan |sid |
|----------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------|
|HTV HD |20730 |
|Granada HD |20740 |
|Tyne Tees HD |20750 |
|South West HD |20760 |
|West HD |20770 |
|STV Central West HD |20800 |
|UTV HD |20810 |
|Anglia East HD |20840 |
|Border HD |20850 |
|London HD |21000 |
|Meridian SE HD |21020 |
|Central West HD |21030 |
|Yorks West HD |21040 |
|ITV London |10060 |
|ITV Granada |10080 |
|ITV Anglia East |10090 |
|ITV+1 Anglia East |10091 |
|ITV Central West |10101 |
|ITV2 |10070 |
|CITV |10071 |
|ITV4 |10072 |
|ITV4+1 |10073 |
|ITVBe |10075 |
|ITV Border (England) |10120 |
|ITV+1 West |10125 |
|ITV Meridian South |10140 |
|ITV+1 Central West |10145 |
|ITV+1 London |10155 |
|ITV Yorkshire West |10160 |
|ITVBe+1 |10139 |
|ITV2+1 |10165 |
|ITV Channel TV |10200 |
|STV North (Aberdeen) |10210 |
|STV Central West |10220 |
|STV Central East |10221 |
|STV North (Dundee) |10225 |
|UTV |10230 |
|UTV+1 |10231 |
|ITV South West |10240 |
|ITV+1 Granada |10255 |
|ITV3 |10260 |
|ITV3+1 |10261 |
|ITV Meridian ThamesV |12101 |
|ITV+1 Tyne Tees |12105 |
|ITV Anglia West |12110 |
|ITV Yorkshire East |12120 |
|ITV Border(Scotland) |12130 |
|ITV Central East |12145 |
|HTV Wales |12150 |
|HTV Wales+1 |12155 |
|ITV+1 Yorkshire |12165 |
|ITV West |12170 |
|ITV+1 South West |12175 |