Reply to thread

Message

<blockquote data-quote="IcePickrg" data-source="post: 175884" data-attributes="member: 47745">Channel numbers and sortingyou could pull your hair out with sorting, but here is the key - it's done by group.&nbsp; When MP loads up for the first time without groups, it will create one by default, called All Channels.&nbsp; Delete this, and MP will take it's best guess at the default sort on restart and recreate the group All Channels.&nbsp; In the latest SVN, you can now sort in the group by channel - thanks again WZ!Not to hijcak the thread, but you asked about leading 0's in your channels.&nbsp; Don't change the SID, becuase that used for tuning, your only free to change dbo.channel.channel.name and channel number&nbsp; I like using the channel number patch from WZ, so I don't perfer numbers in my channel names, but I have channel names like so:&nbsp;Turner Classic&nbsp;FOX Movies&nbsp;BBC America&nbsp;FX&nbsp;QVC&nbsp;TNT&nbsp;TBS Superstation&nbsp;ESPN&nbsp;ESPN Alt&nbsp;ESPN News&nbsp;ESPN CLASSICS&nbsp;ESPN2&nbsp;ESPN Alt&nbsp;ESPN Alt 2&nbsp;ESPN Alt&nbsp;ESPN U&nbsp;Fox SoccerMy method gives the option to add leading 0's or really what ever you want.&nbsp; It's a hack, but works well for me.&nbsp; If you like the channel names as above without manualy entering them, follow along.Check out <a href="http://www.sharpc.com" target="_blank">http://www.sharpc.com</a> they have a program called channel master.&nbsp; Download your sats, change the names how ever you want, then export to My Theater.&nbsp; This creates a MS Access database.&nbsp; The database contains a SID and a real nice channel name in the format of your choice.&nbsp; I have created another database, that uses odbc links to connect to the TVServer database, and the freshly exported My Theater Access Database.&nbsp; I run a query based on SID updating channel name.&nbsp; There is always fresh data on their site, so when channels change, it easy to replicate once you have it set up.&nbsp; I've posted my master db @ <a href="http://www.rockervision.net/icepick/master.zip" target="_blank">http://www.rockervision.net/icepick/master.zip</a> all you'll need to do is re-make the links to the outside the databases, and run the query &quot;qSatName&quot;&nbsp; Clear as mud? perhaps someone likes this enough to create a MSSQL query.....</blockquote>

[QUOTE="IcePickrg, post: 175884, member: 47745"] [b]Channel numbers and sorting[/b] you could pull your hair out with sorting, but here is the key - it's done by group. When MP loads up for the first time without groups, it will create one by default, called All Channels. Delete this, and MP will take it's best guess at the default sort on restart and recreate the group All Channels. In the latest SVN, you can now sort in the group by channel - thanks again WZ! Not to hijcak the thread, but you asked about leading 0's in your channels. Don't change the SID, becuase that used for tuning, your only free to change dbo.channel.channel.name and channel number I like using the channel number patch from WZ, so I don't perfer numbers in my channel names, but I have channel names like so: Turner Classic FOX Movies BBC America FX QVC TNT TBS Superstation ESPN ESPN Alt ESPN News ESPN CLASSICS ESPN2 ESPN Alt ESPN Alt 2 ESPN Alt ESPN U Fox Soccer My method gives the option to add leading 0's or really what ever you want. It's a hack, but works well for me. If you like the channel names as above without manualy entering them, follow along. Check out [url]http://www.sharpc.com[/url] they have a program called channel master. Download your sats, change the names how ever you want, then export to My Theater. This creates a MS Access database. The database contains a SID and a real nice channel name in the format of your choice. I have created another database, that uses odbc links to connect to the TVServer database, and the freshly exported My Theater Access Database. I run a query based on SID updating channel name. There is always fresh data on their site, so when channels change, it easy to replicate once you have it set up. I've posted my master db @ [url]http://www.rockervision.net/icepick/master.zip[/url] all you'll need to do is re-make the links to the outside the databases, and run the query "qSatName" Clear as mud? perhaps someone likes this enough to create a MSSQL query..... [/QUOTE]

Verification