[mythtv-users] Correlating video sources to their numbers in the database...
Douglas Peale
Douglas_Peale at comcast.net
Mon Aug 6 01:57:05 UTC 2018
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>
More information about the mythtv-users
mailing list