MediaPortal Forums HTPC/MediaCenter

Go Back   MediaPortal Forum » MediaPortal 1 » MediaPortal 1 Talk


Reply
 
LinkBack Thread Tools Display Modes
Old 2008-06-16, 09:49   #1 (permalink)
Portal Member
 
Join Date: Jan 2007
Age: 30
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts


Default Prevent channels from combining

Hi!
I am using DVB-T card and FireTV DVB-C with TV-Server (RC1 and latest svn build).
The problem is: Directly during scanning for new channels, all channels with same names are combined into one and listed with their name and the two frequencies .
It would be great to have them listed separately in the channel list in order to be able to choose them manually (according e.g. to picture quality), even if I would loose some nice properties (such as letting tv-server decide between choosing which channels etc.)
Nevertheless, is there a way to prevent those channels from being matched together or to manually separate them into two separate channels afterwards?

Thanks!!!!
ophth1 is offline   Reply With Quote
Old 2008-06-24, 00:26   #2 (permalink)
Community Plugin Dev
 
armandp's Avatar
 
Join Date: Apr 2008
Age: 29
Posts: 734
Thanks: 34
Thanked 235 Times in 111 Posts

Country:

My System

Default

i have a similar issue: Ziggo (my cable company) broadcasts the History Channel in both SD and HD quality but they use the same name. After scanning they are combined into one channel.

Below is short walkthrough of how i manually seperated them.
It's a bit technical and some knowledge of SQL Server Management Studio Express is required.

Also when you do a new scan these changes will probably get overwritten.

CAUTION: USE THIS _HACK_ AT YOUR OWN RISK

- First scan all your channels in the TV Server configuration so they get saved into the database.
- Start up SQL Server Management Studio Express and connect to the MpTvDbRC1 database
- New query:

Code:
select * from channel
where name = 'MyChannel'
Replace MyChannel with the channel name you want to split.
Write down the idChannel value for reference.

Now create a 'copy' of this channel with new name:

Code:
INSERT INTO [Channel]
(
[name],[isRadio],[isTv],[timesWatched],[totalTimeWatched],
[grabEpg],[lastGrabTime],[sortOrder],[visibleInGuide],
[externalId],[freetoair],[displayName],[epgHasGaps]
)
SELECT
'MyNewChannel',[isRadio],[isTv],[timesWatched],[totalTimeWatched],
[grabEpg],[lastGrabTime],[sortOrder],[visibleInGuide], [externalId] ,
[freetoair], [displayName], [epgHasGaps] 
from [Channel]
where idChannel=X 
Replace X with the idChannel you wrote down and replace the MyNewChannel's with the new name for the channel. Hit execute and you'll get 1 row(s) affected if the copy is succesfull.

Check the id for the new channel by quering:

Code:
select * from channel
where name = 'MyNewChannel'

Now onto the real splitting, new query:

Code:
select * from TuningDetail
where idChannel = 'X'
Replace the X with the original channel id you wrote down in the beginning.
Now you'll get a row for each channel (allthough they are listed as combined in the TV Server configuration they are seperate rows in this table).

Now we are going to update one of these records to use the new idChannel we created. Pick one of the rows and write down the idTuning value and update the record:

Code:
UPDATE TuningDetail
SET idChannel = NewChannelID
where idTuning = X 
Replace NewChannelID with the idChannel of the new channel you created and replace X with the idTuning value you wrote down before.

You have now seperated the channels. Startup the TV Server configuration and check if the new channel is present and that it's correctly mapped to a card and/or group (optional). Startup the TV plugin in MP and test if the channel works.

Hope this workaround works for you! I don't know of any other way to achieve the same using just the configuration UI.
__________________
- "Improving the WAF"

MediaPortal: Multi-seat 1.1.0 RC1 + custom core
Skin: StreamedMP | Plugins: Moving Pictures | My Trailers | MP-TVSeries | For The Record
Htpc: Gigabyte GA-MA78GM-S2H | AMD Athlon X2 4850e | Gigabyte GV-R455D3-512I ATI Radeon HD4550 (details)
Spotlight: My Trailers 2.0.x | Moving Pictures 1.0.x | StreamedMP 1.0.x

Last edited by armandp; 2008-06-24 at 12:49..
armandp is offline   Reply With Quote
Old 2008-07-14, 02:00   #3 (permalink)
MP Donator
 
Join Date: Aug 2006
Age: 26
Posts: 241
Thanks: 9
Thanked 14 Times in 12 Posts

Country:

My System

Default

I also seem to suffer from this problem, anny way that there can be an option added to prvent this?

It's pretty annoying that a FTA channel from DVB-C is combined with a scrambled channel from DVB-S and when tvserver decides that you watch the DVB-S one, there comes the error 'channel is scrambled'
ocram is offline   Reply With Quote
Reply

Bookmarks

Tags
combining, prevent

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining FireDTV DVB-C and Floppy DVB-S2 ocram MediaPortal 1 Talk 0 2008-03-15 13:20
Prevent Windows From Sleeping/Standby lilaundgelb Newcomers Forum 4 2008-02-01 07:47
How can I prevent guide updates to channels? Das Hammer zap2it (discontinued) 4 2007-08-28 14:09
HDHomeRun (2 tuners) not combining... dherman zap2it (discontinued) 1 2007-04-11 07:46


All times are GMT +1. The time now is 01:20.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2 Protected by Akismet Blog with WordPress
Advertisement System V2.6 By   Branden