[HELP US] Getting those DVB EPG issues fixed (1 Viewer)

[natopotato]

Not necessarily to know SQL.
What SQL a server stands for you?
If MySQL setup that MySQL 5 GUI tools.
After setup, start MYSQL Administrator.
In the section of Catalogs choose your database (certainly it is named Mptvdbrc2).
In this base choose the table of tuningdetail.
Start "Edit table data", after menu of File -> Export.

And on an occasion epg.log, delete this file and start a channel again. Tvserver again will create him, and he will be less size.

OK, my server was being relocated so i just finished that up.

How do i export table data in MS SQL Express Management studio?

I cant seem to find the option to do this.

 

[Cybertex]

How do i export table data in MS SQL Express Management studio?

I cant seem to find the option to do this.

Hi, from the left tree view, at database level, right click, "tasks", "Export data...".

It will start the export wizard; you have to select source (SQL Server and database), destination (another SQL server, flat file, or other DBMS if you have driver installed), table and so on.

If you have any problem, let me know,
Bye

 

[dalmer]

He is the sql script I created to fix the recent problems with Dish. You will have to change the diseqc number to match the ones found in your db. Please use at your own risk, while this works fine in my system, it might not in yours. Make a backup first...

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

 

[natopotato]

YOU ARE ABSOLUTLY AMAZING!~!!!!!! MAN
OK, I have a DISH PRO setup so my about half my frequencies are modified. I was able to modify your list to match my frequencies though... i am going to post my modified list in case anybody else is having the same problem as i am and they are using DISH PRO DP setups

****************DISH PRO USERS*******************************


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


*************************DISHPRO LNB FREQUENCIES*******************************************************

OK, i just have to do an EPG scan and we SHALL SEE!!!!! This is GREAT.... Hope it works!!!

YOU GUYS ARE AWSOME!!! I am watching my EPG LOG all i see are

[EPG Update thread]:


THANK YOU GUYS!!!!!!!

 

[dalmer]

I'm glad it works for you. I should point out that the list isn't complete, there are a few channels that still don't have the guide. If anyone would care to put a list together I would be happy to enhance the script to fix them as well...

 

[natopotato]

I'm glad it works for you. I should point out that the list isn't complete, there are a few channels that still don't have the guide. If anyone would care to put a list together I would be happy to enhance the script to fix them as well...

Here is a list of 2400 unique CID's that i pulled from my EPG log info..... i posted it a few
About 3/4 of my channels now have EPG.... i am running EPG scan again as i think that will fill the holes in the guide... duno. I checked the log and i did not notice alot of IdleEpgGrabber in there still.....


One thing i noticed was this:


*******************query results******************

(33 row(s) affected)

(423 row(s) affected)

(34 row(s) affected)

(136 row(s) affected)

(68 row(s) affected)

(35 row(s) affected)

(267 row(s) affected)

(83 row(s) affected)

(27 row(s) affected)

(31 row(s) affected)

(200 row(s) affected)

(58 row(s) affected)

(492 row(s) affected)

(119 row(s) affected)

(473 row(s) affected)

(479 row(s) affected)

(68 row(s) affected)

(267 row(s) affected)

(34 row(s) affected)

(22 row(s) affected)

(33 row(s) affected)

(24 row(s) affected)

(423 row(s) affected)

(21 row(s) affected)

(34 row(s) affected)

(136 row(s) affected)

(10 row(s) affected)

(68 row(s) affected)

(35 row(s) affected)

(267 row(s) affected)

(27 row(s) affected)

(31 row(s) affected)

(200 row(s) affected)

(200 row(s) affected)

(119 row(s) affected)

(479 row(s) affected)

(20 row(s) affected)

(12 row(s) affected)

(34 row(s) affected)
**********************************************************

I did not do the math but it seems that the total rows is WAY more then the channels i have (990)... is this expected? Could this be because i removed the diceqc colum from your original script.... was that required? (if so can you confirm if your "3" is 110 and your "4" is 119?



Attached is my stripped down list of CIDS that failed in my epg log, after i removed the duplicates there were about 2400 unique cids(this file is from my EPG info befor your script)