Reply to thread

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 = '[B]MyChannel[/B]'

[/code]

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

'[B]MyNewChannel[/B]',[isRadio],[isTv],[timesWatched],[totalTimeWatched],

[grabEpg],[lastGrabTime],[sortOrder],[visibleInGuide], [externalId] ,

[freetoair], [displayName], [epgHasGaps]

from [Channel]

where idChannel=[B]X[/B]

[/code]

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 = '[B]MyNewChannel[/B]'

[/code]

Now onto the real splitting, new query:

[code]

select * from TuningDetail

where idChannel = '[B]X[/B]'

[/code]

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 = [B]NewChannelID[/B]

where idTuning = [B]X[/B]

[/code]

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.