90% of my DISH Channels have NO EPG >> EpgGrabber: no channel found for networkid

[natopotato]

OK, I have rebuilt this a couple times... originally i had trouble with scanning my channels (i have a DishPro LNB setup) I got that worked out now when i grab a 2 day (or 9 day) EPG it only shows about 5-10% of my channels i finally realized that it is only showing EPG info for my Channels that have a title in the "Provider" Colum. about 90% of my channels have " , " listed in the Provider field. Is there a SQL Query i can run to change this or ANYTHING.... I cant even find a way to manually edit the "Provider" Field.... even though i would never want to do this 900 times YIKES

In the Log file (part of which i have attached) maby 90% of my channels get this
"
TimeshiftingEpgGrabber: no channel found for networkid:0x1004 transportid:0x6 serviceid:0x83
"

[natopotato]

UPDATE**
dalmer created a script to populate the missing channel info (missing networkID and transportID) This fixed most of my missing channels incase anybody else is having the same problem. You have to run this SQL Query in the management console




*******************THIS IS THE FIX HE POSTED FOR ME TO USE (you just need to update the DISEQC to match your setup*********************************



UPDATE TuningDetail set NetworkID = 4100, TransportID = 2 WHERE Frequency = 12239000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4100, TransportID = 4 WHERE Frequency = 12268000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4100, TransportID = 6 WHERE Frequency = 12297000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4100, TransportID = 8 WHERE Frequency = 12326000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4100, TransportID = 10 WHERE Frequency = 12355000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4100, TransportID = 11 WHERE Frequency = 12370000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4100, TransportID = 12 WHERE Frequency = 12384000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4100, TransportID = 13 WHERE Frequency = 12399000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4100, TransportID = 14 WHERE Frequency = 12414000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4100, TransportID = 15 WHERE Frequency = 12428000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4100, TransportID = 16 WHERE Frequency = 12443000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4100, TransportID = 17 WHERE Frequency = 12457000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4100, TransportID = 18 WHERE Frequency = 12472000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4100, TransportID = 19 WHERE Frequency = 12486000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4100, TransportID = 20 WHERE Frequency = 12501000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4100, TransportID = 21 WHERE Frequency = 12516000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4102, TransportID = 224 WHERE Frequency = 12355000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4102, TransportID = 224 WHERE Frequency = 12384000 AND diseqc = 3
UPDATE TuningDetail set NetworkID = 4102, TransportID = 18 WHERE Frequency = 12559000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 201 WHERE Frequency = 12224000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 202 WHERE Frequency = 12239000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 203 WHERE Frequency = 12253000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 2464 WHERE Frequency = 12268000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 205 WHERE Frequency = 12282000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 206 WHERE Frequency = 12297000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 208 WHERE Frequency = 12326000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 209 WHERE Frequency = 12341000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 210 WHERE Frequency = 12355000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 211 WHERE Frequency = 12370000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 2462 WHERE Frequency = 12384000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 214 WHERE Frequency = 12414000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 215 WHERE Frequency = 12428000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 216 WHERE Frequency = 12443000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 224 WHERE Frequency = 12443000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 219 WHERE Frequency = 12486000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 221 WHERE Frequency = 12516000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 222 WHERE Frequency = 12530000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 2453 WHERE Frequency = 12545000 AND diseqc = 4
UPDATE TuningDetail set NetworkID = 4102, TransportID = 224 WHERE Frequency = 12559000 AND diseqc = 4












*******************THIS IS FOR DISHPRO LNB SETUPS (BANDSTACKED FREQUENCIES)******************



UPDATE TuningDetail set NetworkID = 4100 , TransportID = 2 WHERE Frequency = 13361000
UPDATE TuningDetail set NetworkID = 4100 , TransportID = 4 WHERE Frequency = 13332000
UPDATE TuningDetail set NetworkID = 4100 , TransportID = 6 WHERE Frequency = 13303000
UPDATE TuningDetail set NetworkID = 4100 , TransportID = 8 WHERE Frequency = 13274000
UPDATE TuningDetail set NetworkID = 4100 , TransportID = 10 WHERE Frequency = 13245000
UPDATE TuningDetail set NetworkID = 4100 , TransportID = 11 WHERE Frequency = 12370000
UPDATE TuningDetail set NetworkID = 4100 , TransportID = 12 WHERE Frequency = 13216000
UPDATE TuningDetail set NetworkID = 4100 , TransportID = 13 WHERE Frequency = 12399000
UPDATE TuningDetail set NetworkID = 4100 , TransportID = 14 WHERE Frequency = 13186000
UPDATE TuningDetail set NetworkID = 4100 , TransportID = 15 WHERE Frequency = 12428000
UPDATE TuningDetail set NetworkID = 4100 , TransportID = 16 WHERE Frequency = 13157000
UPDATE TuningDetail set NetworkID = 4100 , TransportID = 17 WHERE Frequency = 12457000
UPDATE TuningDetail set NetworkID = 4100 , TransportID = 18 WHERE Frequency = 13128000
UPDATE TuningDetail set NetworkID = 4100 , TransportID = 19 WHERE Frequency = 12486000
UPDATE TuningDetail set NetworkID = 4100 , TransportID = 20 WHERE Frequency = 13099000
UPDATE TuningDetail set NetworkID = 4100 , TransportID = 21 WHERE Frequency = 12516000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 224 WHERE Frequency = 13245000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 224 WHERE Frequency = 13216000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 18 WHERE Frequency = 13041000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 201 WHERE Frequency = 12224000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 202 WHERE Frequency = 13361000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 203 WHERE Frequency = 12253000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 2464 WHERE Frequency = 13332000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 205 WHERE Frequency = 12282000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 206 WHERE Frequency = 13303000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 208 WHERE Frequency = 13274000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 209 WHERE Frequency = 12341000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 210 WHERE Frequency = 13245000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 211 WHERE Frequency = 12370000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 2462 WHERE Frequency = 13216000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 214 WHERE Frequency = 13186000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 215 WHERE Frequency = 12428000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 216 WHERE Frequency = 13157000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 224 WHERE Frequency = 13157000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 219 WHERE Frequency = 12486000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 221 WHERE Frequency = 12516000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 222 WHERE Frequency = 13070000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 2453 WHERE Frequency = 12545000
UPDATE TuningDetail set NetworkID = 4102 , TransportID = 224 WHERE Frequency = 13041000

[ASiDiE]

That script will work well in the future. The real issue here is the scanning. Dish has duplicated 90% of it's channels over on sat 72. When MP does a scan, it sees the channel on 72 instead of 110/119. It will then add the transponder ID as 9xx. When the EPG grabber goes out to find the channels, it seems to be looking in the correct place but they don't match up in the Database. That's why you get no channel found. There are a couple posts on DVBN about this... most of them from me. It seems that other programs (My theater) are able to scan just fine. When I use TSReader, it also sees the channels on the wrong transponder... so the TV Engine really isn't broken... it's scanning as it should.

At this point, I think GEMX or Frodo would be the only guys to fix this.... And neither of them are around.

[natopotato]

Thx for the reply asidie, About 40% of my channels are still without EPG info, Is there anyway I can help complete this script to cover all of the channels??

[ASiDiE]

I can help you out by giving you an up to date list.. .from my database.. I noticed that some are off.. and this would result in giving you all channels for that transponder to give you blank results. I only use 100-538, so this should be most of them. Some of them might be the same, so just look at your script and edit the changes


110.
12224000 = 201
12253000 = 203
12282000 = 205
12341000 = 209
12370000 = 211
12428000 = 215
12486000 = 216 *
12516000 = 221
12239000 = 202
12297000 = 206
12326000 = 208
12355000 = 210
12414000 = 214
12443000 = 216 *
12559000 = 224 *

119.
12370000 = 11
12399000 = 13
12428000 = 15
12457000 = 17
12486000 = 19
12516000 = 21
12239000 = 2
12268000 = 4
12297000 = 6
12326000 = 8
12355000 = 10 *
12384000 = 12
12414000 = 14
12443000 - 16
12472000 = 18
12501000 = 20

The ones with * mean they will have different transonder ID's for these channels. This is becuase Dish has moved some channels. To complete you listing. Download the 2 day guide and search for your SID number for the channel. Write down the networkID and Transponder ID. Convert these from bin to Hex (I use this web site: Hex-Dec Converter) And edit your SQL database. This is the only way I know of... of getting ALL of your channels to have EPG guide.

[madpb]

Could you give me a step by step on how to run " this SQL Query in the management console"
I have no idea about MySQL

I get t o here


and then I ' Open Script ansi '



but then what do I do? I execute the script and all i get is errors. Was I wrong to clip and paste into a text file?

[madpb]

ok.. 2 things were wrong.
The 'U' in UPDATE was missing on the first line.

Each line was missing the " ; " at the end of each line.

Now to wait and see if it works

[jerame20]

has this issue been resolved in the newer rc3 and svn's

[lar1r]

I am not sure that the devs are looking at this.
Anyone know who the right contact is?

In the meantime I am going to install dvbdream and try this util to see if i can get dvbdream to fix the import list.

DVBNetwork Forums

Update: Until the devs fix the EPG problem for USA DISH network, this tool is actually really good since it takes the channel data from DVBDream and saves it into a Mediaportal channel database. My EPG works now.