uk freesat tuning

For discussion related to MythTV which doesn't belong in another forum.

Moderator: Forum Moderators

Post Reply
jonbanjo
Newcomer
Posts: 5
Joined: Wed Apr 29, 2015 1:39 pm
Great Britain

uk freesat tuning

Post by jonbanjo » Thu Sep 27, 2018 12:02 pm

After years, I finally got round to sorting out the Freesat channels for mythtv. The main information I found was at https://www.mythtv.org/wiki/UK_Channel_Assignments but there seemed to be a lot of queries and a fair bit of jiggling about. I decided to try a different approach which seemed easier to me and am wondering if others have tried it or whether (while it seems to have worked perfectly for me) there are any pitfalls. My set up is currently freesat only and I’m working on the idea that the serviceid for a provider/channel is reasonably unique.

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                                                                                               |
Again, a db import and a query. This hopefully results in more detailed naming for the itv channels.

Post Reply