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: 852775" data-attributes="member: 116882"><p>Hey Tony, I know how you feel, so close yet so far away. You read and read and pick up bits from here and there and try to put it all together.</p><p> </p><p>Hope the <span style="font-family: 'arial black'"><span style="font-family: 'arial'">mor</span><span style="font-family: 'arial'">e</span></span> expanded how-to below helps you out.</p><p> </p><p>The program you need (or what I used) is called MySQL Workbench. </p><p> </p><p>Found here: <a href="http://www.mysql.com/downloads/workbench/" target="_blank">http://www.mysql.com/downloads/workbench/</a> </p><p>Download the following: <span style="font-size: 10px"><span style="font-family: 'verdana'"><span style="color: #666666">mysql-workbench-gpl-5.2.38-win32.msi</span></span></span></p><p>It's the first program listed, install and then do a restart just for kicks.</p><p>I'm not sure, but I would turn off TV Server after the reboot just to be sure that the database is closed for editing.</p><p>After you have rebooted and turned off the TV Server, Open MySQL Workbench from the short-cut that was created. You will then brought to the following screen:</p><p> </p><p>[ATTACH=full]100805[/ATTACH]</p><p> </p><p>Within the MySQL Workbench screen your will see on the lower left hand area of window "Edit Table Data" Click on that command and you will be shown the following screen:</p><p> </p><p>[ATTACH=full]100809[/ATTACH] </p><p> </p><p>Now, the "Stored Connection" Combo Box will be blank when the screen opens, so the first thing you will do is access the already existing</p><p>"Local Instance MySQL" by selecting it in the topmost combo box. Next it's password time, you will 1) Click on "Store in Vault" to access the password prompt text box. 2) Enter the password - "MediaPortal" it is case specific and will only have to be entered once. Next time you want to enter the database your password has been "Stored in the Vault"</p><p> </p><p>[ATTACH=full]100808[/ATTACH] </p><p> </p><p>Click Next to get to the following screen</p><p> </p><p>[ATTACH=full]100810[/ATTACH]</p><p> </p><p>When you installed MediaPortal a database was created named "mptvdb" </p><p> </p><p>1) When you first open the 'Table Selection Window seen above, under the first combo box "Schema:" you will see "information schema" change it to "mptvdb"</p><p> </p><p>2) Change the "Table:" Combo Box to "channel"</p><p> </p><p>3) Click Finish</p><p> </p><p>Next is the edit database screen seen below:</p><p> </p><p>[ATTACH=full]100811[/ATTACH]</p><p> </p><p>Here's the time consuming part: The red arrow is pointing to a column called: "externalID" Here is where the SchedulesDirect plugin gets it information on which channel to pull for your channel line up in your epg. In my case, I'm using Schedules Direct for Set top Box Cable and Over the Air HD. I ensure my schedules direct account has the aapropriate line-up selected from the SchedulesDirect website. as seen below:</p><p> </p><p>[ATTACH=full]100812[/ATTACH]</p><p> </p><p>Click on edit and you will be taken to your line-up where you can get the first 5 numbers of the channel id needed. See Below:</p><p> </p><p>[ATTACH=full]100813[/ATTACH]</p><p> </p><p>If you hover your mouse over the particulair channel your interested in the channel id will appear, write that number down.</p><p>You can also click on "Report in the previous image to get a columned listing with all the channel ids.</p><p> </p><p>Now that you have the channel id you need, go back to the MySQL Workbench "channel" table that you have previously opened and edit the channel thats giving you problems.</p><p>11182.30.schedulesdirect.org</p><p>The externalId format is as follows: XXXXXX.00.schedulesdirect.org</p><p>XXXXX = channelID from Schedulesdirect Website</p><p>00 = channel number from Schedulesdirect Website</p><p> </p><p>After you have entered the correct channel ID for all the channels that are incorrect. Click on "Apply" In the lower right-hand side of the edit tables screen and close up MySQL Workbench.</p><p> </p><p>open up your TV Server Configuration and access your schedules direct plugin configuration screen and click on the check box that will force update of your channel guide on next TV Server restart. </p><p> </p><p>[ATTACH=full]100814[/ATTACH]</p><p> </p><p>Restart the service under Manual Control and give it 10 min or so and bingo, Bob's your Uncle, or Shirley's your Aunt. Whatever it works.</p><p> </p><p>Remember, Open Source needs Community Support - Pay It Forward.</p><p> </p><p>Let me know if it worked or if you have any other questions or changes we can make to this post, HAPPY to help. Amazing program.</p><p> </p><p>S</p></blockquote><p></p>
[QUOTE="valdi, post: 852775, member: 116882"] Hey Tony, I know how you feel, so close yet so far away. You read and read and pick up bits from here and there and try to put it all together. Hope the [FONT=arial black][FONT=arial]mor[/FONT][FONT=arial]e[/FONT][/FONT] expanded how-to below helps you out. The program you need (or what I used) is called MySQL Workbench. Found here: [url]http://www.mysql.com/downloads/workbench/[/url] Download the following: [SIZE=10px][FONT=verdana][COLOR=#666666]mysql-workbench-gpl-5.2.38-win32.msi[/COLOR][/FONT][/SIZE] It's the first program listed, install and then do a restart just for kicks. I'm not sure, but I would turn off TV Server after the reboot just to be sure that the database is closed for editing. After you have rebooted and turned off the TV Server, Open MySQL Workbench from the short-cut that was created. You will then brought to the following screen: [ATTACH=full]100805[/ATTACH] Within the MySQL Workbench screen your will see on the lower left hand area of window "Edit Table Data" Click on that command and you will be shown the following screen: [ATTACH=full]100809[/ATTACH] Now, the "Stored Connection" Combo Box will be blank when the screen opens, so the first thing you will do is access the already existing "Local Instance MySQL" by selecting it in the topmost combo box. Next it's password time, you will 1) Click on "Store in Vault" to access the password prompt text box. 2) Enter the password - "MediaPortal" it is case specific and will only have to be entered once. Next time you want to enter the database your password has been "Stored in the Vault" [ATTACH=full]100808[/ATTACH] Click Next to get to the following screen [ATTACH=full]100810[/ATTACH] When you installed MediaPortal a database was created named "mptvdb" 1) When you first open the 'Table Selection Window seen above, under the first combo box "Schema:" you will see "information schema" change it to "mptvdb" 2) Change the "Table:" Combo Box to "channel" 3) Click Finish Next is the edit database screen seen below: [ATTACH=full]100811[/ATTACH] Here's the time consuming part: The red arrow is pointing to a column called: "externalID" Here is where the SchedulesDirect plugin gets it information on which channel to pull for your channel line up in your epg. In my case, I'm using Schedules Direct for Set top Box Cable and Over the Air HD. I ensure my schedules direct account has the aapropriate line-up selected from the SchedulesDirect website. as seen below: [ATTACH=full]100812[/ATTACH] Click on edit and you will be taken to your line-up where you can get the first 5 numbers of the channel id needed. See Below: [ATTACH=full]100813[/ATTACH] If you hover your mouse over the particulair channel your interested in the channel id will appear, write that number down. You can also click on "Report in the previous image to get a columned listing with all the channel ids. Now that you have the channel id you need, go back to the MySQL Workbench "channel" table that you have previously opened and edit the channel thats giving you problems. 11182.30.schedulesdirect.org The externalId format is as follows: XXXXXX.00.schedulesdirect.org XXXXX = channelID from Schedulesdirect Website 00 = channel number from Schedulesdirect Website After you have entered the correct channel ID for all the channels that are incorrect. Click on "Apply" In the lower right-hand side of the edit tables screen and close up MySQL Workbench. open up your TV Server Configuration and access your schedules direct plugin configuration screen and click on the check box that will force update of your channel guide on next TV Server restart. [ATTACH=full]100814[/ATTACH] Restart the service under Manual Control and give it 10 min or so and bingo, Bob's your Uncle, or Shirley's your Aunt. Whatever it works. Remember, Open Source needs Community Support - Pay It Forward. Let me know if it worked or if you have any other questions or changes we can make to this post, HAPPY to help. Amazing program. S [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
General Forums
Newcomers Forum
Schedules Direct
Contact us
RSS
Top
Bottom