[mythtv-users] Correlating video sources to their numbers in the database...

[Douglas Peale]

On 08/05/2018 05:20 PM, Douglas Peale wrote:
> I have six video sources from three antennas pointed in three different directions.
>
> I have given each video source a name reflecting the type of tuner, and direction of the antenna in the mythtvbackendsetup, but
> both the database and mythweb refer to the sources by number.
>
> (For some reason, mythtv has chosen the numbers 4, 5, 9, 10, 11, and 12 for the six video sources).
>
>
> How do I correlate the names I gave to the sources with the numbers?
>
> I wish to hide channels that are duplicates of others that use a less optimal antenna. There is a lot of overlap between the
> antennas, and off axis reception is flaky.
>
>
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

I did not find a way to find the video source name in the database, but I did find a way to correlate the numbers with the
following database query:

mysql> select cardid, sourceid, cardtype, videodevice from capturecard;
+--------+----------+-----------+-------------+
| cardid | sourceid | cardtype  | videodevice |
+--------+----------+-----------+-------------+
|      1 |       10 | HDHOMERUN | 1040253E-0  |
|      2 |       10 | HDHOMERUN | 1040253E-1  |
|      3 |       12 | HDHOMERUN | 10401F3E-0  |
|      4 |       12 | HDHOMERUN | 10401F3E-1  |
|      5 |       11 | HDHOMERUN | 10401D98-0  |
|      6 |       11 | HDHOMERUN | 10401D98-1  |
|      7 |        5 | HDHOMERUN | 1016A87D-0  |
|      8 |        9 | HDHOMERUN | 1016A87D-1  |
|      9 |        9 | HDHOMERUN | 101694BD-0  |
|     10 |        4 | HDHOMERUN | 101694BD-1  |
|     11 |       10 | HDHOMERUN | 1040253E-0  |
|     12 |       10 | HDHOMERUN | 1040253E-0  |
|     13 |       10 | HDHOMERUN | 1040253E-1  |
|     14 |       10 | HDHOMERUN | 1040253E-1  |
|     15 |       12 | HDHOMERUN | 10401F3E-0  |
|     16 |       12 | HDHOMERUN | 10401F3E-0  |
|     17 |       12 | HDHOMERUN | 10401F3E-1  |
|     18 |       12 | HDHOMERUN | 10401F3E-1  |
|     19 |       11 | HDHOMERUN | 10401D98-0  |
|     20 |       11 | HDHOMERUN | 10401D98-0  |
|     21 |       11 | HDHOMERUN | 10401D98-1  |
|     22 |       11 | HDHOMERUN | 10401D98-1  |
|     23 |        5 | HDHOMERUN | 1016A87D-0  |
|     24 |        5 | HDHOMERUN | 1016A87D-0  |
|     25 |        9 | HDHOMERUN | 1016A87D-1  |
|     26 |        9 | HDHOMERUN | 1016A87D-1  |
|     27 |        9 | HDHOMERUN | 101694BD-0  |
|     28 |        9 | HDHOMERUN | 101694BD-0  |
|     29 |        4 | HDHOMERUN | 101694BD-1  |
|     30 |        4 | HDHOMERUN | 101694BD-1  |
+--------+----------+-----------+-------------+


I know which HDHomeRun is connected to which antenna, and now I know what source ID is associated with that.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180805/3a11e315/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: OpenPGP digital signature
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180805/3a11e315/attachment-0001.sig>