home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
General Forums
Newcomers Forum
Schedules Direct
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="valdi" data-source="post: 845433" data-attributes="member: 116882"><p>Hello, My first post, certainly not the last one<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /> I've got mediaportal going with schedules direct over ATSC in canada. But my problem is with SD plugin not pulling down the right channel information. scan, re-scan delete rinse and repeat is not something I want to do with 60 channels of cable and 20 channels of OTA. I was wondering if anyone knew of a wiki page or forum post that could instruct me on how to change the station ID within MediaPortal/SD plugin via the SQL Database?</p><p> </p><p>I just want to manually add my analog cable channels within TVserver Configuration program, do a scan, let SD pull whatever it's going to pull down and then enter the database (mptvdb?) and update the channel ID from SchedulesDirect website with the correct channel ID and then update the EPG data with a TVServer restart, and have the channels updated all at once (OTA and CABLE). My problem is I can't find the database to manipulate nor the program to open the database. I've tried sql lite and MySQL but have not be able to find the database to open.</p><p> </p><p>Once I get this going, then I start working on IR Blasting for cable set top box channel changing (found all the wiki pages for this one). I know it's free and I love the tinkering, but having a hard time with the above item. Any suggestions or push in the proper direction (wiki, forum) would be greatly appreciated.</p><p> </p><p>Thanx.</p><p> </p><p></p><p>Yay.....I posted in frustration too soon literally, hours too soon . I opened the mptvdb with MySQL Workbench and opened a local instance of the channel table and found what I was looking for. I was confused with MySQL Workbench and how to open the database. I was assuming it was a single file with all the goodies(tables/fields etc) in one file ready to be edited. Not so....whoever finds this post concerning opening the mptvdb process for adjusting channel Id's manually for schedulesdirect feel free to use what I did below. </p><p> </p><p>Within in MySQL Workspace - Edit Table Data....(lower right part of screen)</p><p>Stored Connection: Local Instance MySQL (located in dropdown box tab. </p><p>Password: MediaPortal (Case Specific)</p><p>Click Next</p><p>Schema: mptvdb</p><p>Table: channel</p><p>Click Finish</p><p>The editor opens up </p><p>field externalID is the number you want to change i.e. </p><p>17593.43.schedulesdirect.org - 17593 = schedulesdirect Id number found associated with the line-up you have already selected.</p><p>Lo and Behold it worked!!!</p><p> </p><p>Love the program.</p></blockquote><p></p>
[QUOTE="valdi, post: 845433, member: 116882"] Hello, My first post, certainly not the last one:) I've got mediaportal going with schedules direct over ATSC in canada. But my problem is with SD plugin not pulling down the right channel information. scan, re-scan delete rinse and repeat is not something I want to do with 60 channels of cable and 20 channels of OTA. I was wondering if anyone knew of a wiki page or forum post that could instruct me on how to change the station ID within MediaPortal/SD plugin via the SQL Database? I just want to manually add my analog cable channels within TVserver Configuration program, do a scan, let SD pull whatever it's going to pull down and then enter the database (mptvdb?) and update the channel ID from SchedulesDirect website with the correct channel ID and then update the EPG data with a TVServer restart, and have the channels updated all at once (OTA and CABLE). My problem is I can't find the database to manipulate nor the program to open the database. I've tried sql lite and MySQL but have not be able to find the database to open. Once I get this going, then I start working on IR Blasting for cable set top box channel changing (found all the wiki pages for this one). I know it's free and I love the tinkering, but having a hard time with the above item. Any suggestions or push in the proper direction (wiki, forum) would be greatly appreciated. Thanx. Yay.....I posted in frustration too soon literally, hours too soon . I opened the mptvdb with MySQL Workbench and opened a local instance of the channel table and found what I was looking for. I was confused with MySQL Workbench and how to open the database. I was assuming it was a single file with all the goodies(tables/fields etc) in one file ready to be edited. Not so....whoever finds this post concerning opening the mptvdb process for adjusting channel Id's manually for schedulesdirect feel free to use what I did below. Within in MySQL Workspace - Edit Table Data....(lower right part of screen) Stored Connection: Local Instance MySQL (located in dropdown box tab. Password: MediaPortal (Case Specific) Click Next Schema: mptvdb Table: channel Click Finish The editor opens up field externalID is the number you want to change i.e. 17593.43.schedulesdirect.org - 17593 = schedulesdirect Id number found associated with the line-up you have already selected. Lo and Behold it worked!!! Love the program. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
General Forums
Newcomers Forum
Schedules Direct
Contact us
RSS
Top
Bottom
