I am a faithful MediaPortal user who also utilizes ForTheRecord as the scheduling engine. I love my HTPC setup, but was bummed out when I found that it was not possible to watch any recordings that were made by ForTheRecord on the MPExtended web interface or in aMPdroid.
For anyone else who has been in this predicament, I am happy to share the solution I came up with for my own setup. Using the SQL script that I wrote, I am able to synchronize all recordings from the ForTheRecord database to the MediaPortal database. Since ForTheRecord does not use the stock MP TV client, it should be perfectly safe to insert the necessary information.
Long story short, when this script runs it synchronizes all recordings that are present in the ForTheRecord database into the MediaPortal database. By doing this, MPExtended can then "see" the recordings that are present on the hard disk and is able to stream it as if the recording were made natively by MediaPortal. I really do hope that this script is able to be useful to someone else as much as it is for me.
Anyone who decides to try this out, please let me know how it goes!
Notes:
-Steve
For anyone else who has been in this predicament, I am happy to share the solution I came up with for my own setup. Using the SQL script that I wrote, I am able to synchronize all recordings from the ForTheRecord database to the MediaPortal database. Since ForTheRecord does not use the stock MP TV client, it should be perfectly safe to insert the necessary information.
Long story short, when this script runs it synchronizes all recordings that are present in the ForTheRecord database into the MediaPortal database. By doing this, MPExtended can then "see" the recordings that are present on the hard disk and is able to stream it as if the recording were made natively by MediaPortal. I really do hope that this script is able to be useful to someone else as much as it is for me.
Anyone who decides to try this out, please let me know how it goes!
Notes:
- This script only synchronizes in ONE direction. Every time this script is ran, it ensures that the MediaPortal database reflects exactly what the ForTheRecord database shows at the time the script is ran. In order to help prevent situations where a recording originated from MediaPortal itself instead of being added by this script, ALL recordings that are added by this script are marked with a idSchedule of -102.
- This script was written for MySQL only, there's an extremely high chance that it will not work at all with MSSQL installations without first being rewritten.
- The MediaPortal and ForTheRecord database both must reside on the same MySQL server instance.
- When using MediaPortal as the recording engine, the script will not work properly if any of the channels are manually mapped in the MediaPortal TV Server ForTheRecord plugin. This is because the mappings are stored in a XML file that this script cannot access. The best workaround is to make sure that ALL channel names
- When using ForTheRecord as the recording engine (untested), the MediaPortal TV server must be installed on the same machine that hosts MPExtended. This is because MPExtended will only access a MediaPortal TV server instance. You should not need to import any EPG or XMLTV data, but you WILL need to make sure that that all channels that exist in ForTheRecord, must also be present in the MediaPortal TV Server. I do not believe that you will need to map any channels to cards, but again, this entire setup is untested. I ask that someone try and let me know how it works out.
- If your MySQL database is not on the same machine where MediaPortal and ForTheRecord are located, you will need to install the MySQL client utilities or find another way to run this script and ignore most of the directions here.
- Unpack this zip file to anywhere you want.
- Edit Synchronize.bat and locate the following lines toward the top of the file:
- set SQLhost=localhost
- set SQLuser=root
- set SQLpassword=changeme
- Change the host, username, and password for your MySQL database server. This password is usually 'MediaPortal'
- Schedule the bat file to run (see below)
- Login to MPExtended Web and/or open aMPdroid on Android and verify that recorded TV shows all the recordings that are available in ForTheRecord.
- To schedule in Windows (tested method), you will need to add a new scheduled task in Windows Task Scheduler. I recommend having the task run every 5 minutes. Just make sure that you specify the start path to the location that you unpacked the zip file to above.
- This script could also be scheduled in Window's Task Scheduler or setup to run at the start and the end of any recording in ForTheRecord, but this is untested.
-Steve