Change channel by channelNumber or SID (w. code)

[damaster]

I'm using MySQL. What is the MediaPortal database name?

use <database_name>;
show tables;
...

Ok, I figured it out. Using MySQL client:
use TVLibrary;
UPDATE TuningDetail SET channelNumber = serviceId;

This does the trick, but my channels are still not sorted by SID in MediaPortal. Still sorted by name which sucks. I may end up exporting to XML, writing some Perl to change the sorting and importing back the XML.

[hansdegit]

update channel set sortorder = (select min(serviceid) from tuningdetail where tuningdetail.name = channel.name)

That should do the trick.

[x4mer]

Or go into the mapping section on the TV server config, where the right side window is labelled channel number. Simply click the column header to sort channels by that column.

[damaster]

Yup, the easiest solution is as x4mer suggests, but only works the first time you do a channel scan. If you do a channel scan, sort by name, and then close the TV Server configuration, the channels are already sorted in the DB, and then requires SQL to fix. But, if you do a channel scan, then right-click on all the scanned channels and select "Add SID to front of channel name", then sort by name (which will actually sort by SID since you added SID to the channel names), and then close the TV Server configuration, everything will be sorted correctly.

However, you still need to run some SQL to set the channelNumber column to serviceId in order to be able to punch in channel numbers on your remote and jump to the appropriate channel number as per NA SIDs.

[lar1r]

ok, I've the tried the suggested sql commands
use TVLibrary;
UPDATE TuningDetail SET channelNumber = serviceId;

I can also confirm that in setuptv.exe->TV Channels-> edit that each channel now has the serviceid and channel being the same.

Yet in MP, when I key in the channel number it still doesnt correlate... The sort is correct now using the TVMapping->channel right click method.

Other options to try in order to get this to work with a remote?
Thx

[x4mer]

The code to get channel change working from fullscreen TV was never added to SVN as far as I know. If you call up the guide, & then enter the channel number, it will jump in the guide to that channel for selection.

As you're entering the channel number, the first time slot header (eg. 7:00pm) will get overwritten with the channel number you're entering.


Icepick put together the code to get channel entry working in fullscreen TV as well (see post 26 & 28 of this thread). The code was just never picked up by a dev for SVN inclusion.

[lar1r]

It works now - I had to go to MP Config->MY TV and uncheck the box that mentioned channel sorting for NON US

[rede96]

Sorry for the n00b question but can anyone give me the heads up on how to set MP 0.2.3.0 (Not with TV Server) to change channel by channel number in full screen please.

My life would be complete if only I could get MP to change channel by channel numbers!

Thanks

[stoked]

Channel changing by number is fine by deselecting the default checkbox in the config. However, what are you guys doing about the zero button? When I press the zero button it goes to the last viewed channel. Was hoping to decouple this feature from the zero button and use a different button but can`t seem to.

[50chickens]

Originally Posted by rede96

Sorry for the n00b question but can anyone give me the heads up on how to set MP 0.2.3.0 (Not with TV Server) to change channel by channel number in full screen please.

My life would be complete if only I could get MP to change channel by channel numbers!

Thanks

hi rede96

i've written a epg grabber for oztivo for non tvserver users just recently and i am adding this new feature (eg, your STB channel number will be the MP channel number). So far the program i wrote is specific to oztivo users (australia), but i doubt it'd take much effect to expand it to other services (i see you are in the UK?). Have you got a link for your epg data source? I'll take a look if you want.