[mythtvnz] Prime DVB-S changes

[Stephen Worthington]

On Sun, 8 Sep 2013 10:06:13 +1200, you wrote:

>>> >>I guess this means we will need to scan the sky freq now?
>>> >>
>>>
>>>http://www.voxy.co.nz/business/duplicate-prime-satellite-signal-be-removed
>/5/166041
>>> >
>>> >I just did a rescan and no difference, I don't have Sky but I should
>>> >now be able to see an extra Prime channel shouldn't I ?
>>> 
>>> You need to do a scan of the Sky frequency that carries Prime, which is
>>> reported as 1957 in my last scan of the Sky transponders.  So the
>transponder
>>> frequency works out to be 12707000 Hz.  [My LNB frequency is 10750000, so
>>> 12707000 Hz - 10750000 Hz = 1957000 Hz.]
>
>Thanks that was very helpful
>
>I scanned from 12707000 and found quite a few channels, all via Sky I
>presume
>
>The first 3 were prime so I just removed the existing prime channel and
>added the first of the 3 Sky
>ones I found.

Here is my last scan of that transponder:

[[Tuning to 12707000 Hz]]
Animal
Planet;SkyNZ:1957:HC34:S0.0W:22500:1007+8190:1107=eng:1907:0:1014:169:11:0
CNN;SkyNZ:1957:HC34:S0.0W:22500:1005+8190:1105=eng:0:0:1015:169:11:0
Prime;SkyNZ:1957:HC34:S0.0W:22500:1001+8190:1101=eng:0:0:1018:169:11:0
Disney
Channel;SkyNZ:1957:HC34:S0.0W:22500:1008+8190:1108=eng:1908:0:1027:169:11:0
MTV;SkyNZ:1957:HC34:S0.0W:22500:1003+8190:1103=eng:1903:0:1039:169:11:0
Comedy
Central;SkyNZ:1957:HC34:S0.0W:22500:1004+8190:1104=eng:0:0:1042:169:11:0
Prime;SkyNZ:1957:HC34:S0.0W:22500:1002+8190:1102=eng:0:0:1055:169:11:0
Prime;SkyNZ:1957:HC34:S0.0W:22500:1009+8190:1109=eng:0:0:1056:169:11:0
Country
TV;SkyNZ:1957:HC34:S0.0W:22500:1006+8190:1106=eng:0:0:1098:169:11:0

All the other Sky channels there will be encrypted except for the
Prime channels.

>Deleting the old one I had to press "M" then click "Delete" and then accept
>"Delete channel 'Prime'". Of course
>I now see I could have just pressed "D"......
>
>I presume to get the exact specifics of any given channel I need to query
>the DB ?

You can see a lot of the channel data using Mythweb:

  http://<your mythtv IP address>/mythweb/settings/tv/channels

That shows a lot of the data for each channel from the channel table,
but the data for the multiplexes (mplexid, serviceid) is unfortunately
not shown, at least in 0.26.  Maybe 0.27 will.  So if you want to see
everything you will need to delve into the database using SQL or an
SQL tool.  The tables you need to look at are:

  channel
  dtv_multiplex
  diseqc_tree
  cardinput
  capturecard

The diseqc_config table is normally empty in NZ as we do not usually
have multiple or rotateable satellite dishes.

The data from scans is found in:

  channelscan
  channelscan_channel
  channelscan_dtv_multiplex

I have pretty much worked out how all those tables work by now, since
I manually update my channels with SQL.  So let me know if you need
anything explained.
  
>Again thanks

Did you remember to go to mythtv-setup and put in the xmltvid values
for the Prime channels again?  Those are not available from the scan
data and have to be input manually.