TROOPER
09-29-2008, 08:43 AM
This information was brought up in another thread and I thought it would be handy to have this in it's own thread to locate it easily.
Don't freak out if MS Access barks about unit of measurements when opening tables or select queries!
How to use update queries:
1. Make a backup copy of channels.mdb
2. Open channels.mdb in MS Access
3. Click on queries
4. Click on create query in design view
5. Close table selection window(leave empty with query window open)
6. Click on SQL in toolbar or right-click and select SQL view
7. Paste text of query (in between ---------- lines)
8. Run query
9. If so desired save query to any name you wish
Delete All Satellites That Is Packaged with MyTheatre Install
Before opening MyTheatre for the first time, open Channels.MDB in MS Access. Open the Satellites table. Press Ctrl + A keys (Select All). Press Delete Key. When asked if you want to delete select yes. Due to the relationships setup in the Channels.MDB file, deleting the satellites will delete all the other tables just like taking the 5 minutes to manually delete satellites from within MyTheatre.
Setting PID for all encrypted channels
You can just select the 1810, you don't need to delete. It's going to be a long process using channel properties from within MT and if you want to speed that up you can use an Update query from MS Access. The following SQL statement will change all your encrypted channels to 1810.
------- Query Text -------------------------------------------------------
UPDATE (Satellites INNER JOIN Transponders ON Satellites.SatID=Transponders.SatID) INNER JOIN (PIDType RIGHT JOIN (Favorites RIGHT JOIN (Channels INNER JOIN PIDs ON Channels.CHID=PIDs.CHID) ON Favorites.FavID=Channels.FavID) ON PIDType.Type=PIDs.Type) ON Transponders.TranspID=Channels.TranspID SET PIDs.Sel = 1
WHERE (((Satellites.Name) Like "echo*") AND ((PIDs.Opt1)=6160) AND ((PIDs.Type)=6));
------- End of Query Text ------------------------------------------------
Note: In LNB/DisEqC settings of MT, make sure your sats are named either "Echostar x" or "Echo x" as appropiate per sat (bold characters in query)
Run with How to use update queries above.
Ever have myEPG not have the channel name?
------- Query Text -------------------------------------------------------
UPDATE Channels SET Provider = [Name] WHERE (((Provider)=""));
------- End of Query Text ------------------------------------------------
Run with How to use update queries above.
Want the channel numbers to be in channel properties w/o manually adding them?
------- Query Text -------------------------------------------------------
UPDATE Channels SET ChNum = [SID] WHERE (((ChNum)=0));
------- End of Query Text ------------------------------------------------
Run with How to use update queries above.
After running that I run
------- Query Text -------------------------------------------------------
SELECT * FROM Channels ORDER BY SID;
------- End of Query Text ------------------------------------------------
I then find my locals (8900's here) in the table view of the Query and change ChNum's to 5,7,9 etc
Quick Way to setup Favorites
Open Favorites Table and edit/add (do not use 0 FavID line) in Name Field, make a list so it's handy (FavID & Name) and run
------- Query Text -------------------------------------------------------
SELECT FavID, SID, ChNum, Name, Provider FROM Channels WHERE (((FavID)>0)) ORDER BY SID;
------- End of Query Text ------------------------------------------------
Get a Clue What Those Funky Channel Names Are After A Scan
------- Query Text -------------------------------------------------------
UPDATE Channels SET Name = "Channel " & [SID] WHERE (((Left([Name],1))="0")) OR (((Left([Name],1))="1")) OR (((Left([Name],1))="2"));
------- End of Query Text ------------------------------------------------
Run with How to use update queries above.
Edit: I'm leaving this here only as a teaching tool, testing has shown that better method is to use MT list (Transpoder) to isolate TP and then clear the transponder and just rescan that/those TP's...Thanks to Ptown that is
Then to find them easily
Run this and do a manual edit on Names and Provider
------- Query Text -------------------------------------------------------
SELECT * FROM Channels WHERE (((Name) Like "Channel*"));
------- End of Query Text ------------------------------------------------
There is more to the editing in this section so if you don't get results you expect other fields need editing too (fields Type thru NetID) to get it all correct.
Enjoy!!
Don't freak out if MS Access barks about unit of measurements when opening tables or select queries!
How to use update queries:
1. Make a backup copy of channels.mdb
2. Open channels.mdb in MS Access
3. Click on queries
4. Click on create query in design view
5. Close table selection window(leave empty with query window open)
6. Click on SQL in toolbar or right-click and select SQL view
7. Paste text of query (in between ---------- lines)
8. Run query
9. If so desired save query to any name you wish
Delete All Satellites That Is Packaged with MyTheatre Install
Before opening MyTheatre for the first time, open Channels.MDB in MS Access. Open the Satellites table. Press Ctrl + A keys (Select All). Press Delete Key. When asked if you want to delete select yes. Due to the relationships setup in the Channels.MDB file, deleting the satellites will delete all the other tables just like taking the 5 minutes to manually delete satellites from within MyTheatre.
Setting PID for all encrypted channels
You can just select the 1810, you don't need to delete. It's going to be a long process using channel properties from within MT and if you want to speed that up you can use an Update query from MS Access. The following SQL statement will change all your encrypted channels to 1810.
------- Query Text -------------------------------------------------------
UPDATE (Satellites INNER JOIN Transponders ON Satellites.SatID=Transponders.SatID) INNER JOIN (PIDType RIGHT JOIN (Favorites RIGHT JOIN (Channels INNER JOIN PIDs ON Channels.CHID=PIDs.CHID) ON Favorites.FavID=Channels.FavID) ON PIDType.Type=PIDs.Type) ON Transponders.TranspID=Channels.TranspID SET PIDs.Sel = 1
WHERE (((Satellites.Name) Like "echo*") AND ((PIDs.Opt1)=6160) AND ((PIDs.Type)=6));
------- End of Query Text ------------------------------------------------
Note: In LNB/DisEqC settings of MT, make sure your sats are named either "Echostar x" or "Echo x" as appropiate per sat (bold characters in query)
Run with How to use update queries above.
Ever have myEPG not have the channel name?
------- Query Text -------------------------------------------------------
UPDATE Channels SET Provider = [Name] WHERE (((Provider)=""));
------- End of Query Text ------------------------------------------------
Run with How to use update queries above.
Want the channel numbers to be in channel properties w/o manually adding them?
------- Query Text -------------------------------------------------------
UPDATE Channels SET ChNum = [SID] WHERE (((ChNum)=0));
------- End of Query Text ------------------------------------------------
Run with How to use update queries above.
After running that I run
------- Query Text -------------------------------------------------------
SELECT * FROM Channels ORDER BY SID;
------- End of Query Text ------------------------------------------------
I then find my locals (8900's here) in the table view of the Query and change ChNum's to 5,7,9 etc
Quick Way to setup Favorites
Open Favorites Table and edit/add (do not use 0 FavID line) in Name Field, make a list so it's handy (FavID & Name) and run
------- Query Text -------------------------------------------------------
SELECT FavID, SID, ChNum, Name, Provider FROM Channels WHERE (((FavID)>0)) ORDER BY SID;
------- End of Query Text ------------------------------------------------
Get a Clue What Those Funky Channel Names Are After A Scan
------- Query Text -------------------------------------------------------
UPDATE Channels SET Name = "Channel " & [SID] WHERE (((Left([Name],1))="0")) OR (((Left([Name],1))="1")) OR (((Left([Name],1))="2"));
------- End of Query Text ------------------------------------------------
Run with How to use update queries above.
Edit: I'm leaving this here only as a teaching tool, testing has shown that better method is to use MT list (Transpoder) to isolate TP and then clear the transponder and just rescan that/those TP's...Thanks to Ptown that is
Then to find them easily
Run this and do a manual edit on Names and Provider
------- Query Text -------------------------------------------------------
SELECT * FROM Channels WHERE (((Name) Like "Channel*"));
------- End of Query Text ------------------------------------------------
There is more to the editing in this section so if you don't get results you expect other fields need editing too (fields Type thru NetID) to get it all correct.
Enjoy!!