Reply to thread

Message

<blockquote data-quote="luci5r" data-source="post: 751934" data-attributes="member: 113478">Ok - I didn't realize that was the case. But definitely good progress for me here. Is there thread/support discussion somewhere regarding setting up the IR Blaster to switch channels on the STB? I guess that would be critical in order to make the EPG recording work so I have to definitely pursue that. Ok - A LOT of information here to digest; I'll have to go slow &amp; step by step. First of all - yes, I did indeed choose MySQL during installation. I can write a program in PHP and perform whatever is necessary on a mySQL database. I think the problem right now is that I don't quite understand what it is that I exactly have to do. Let me ask you a basic question first - this process of &quot;Mapping&quot;, either via MediaPortal using &quot;rinse &amp; repeat&quot;, or via PHP/MySQL -- Is this something that will have to done every time I update the Guide Data?? Or is this something that only needs to be done once &amp; that's it? I know that I have to get Guide data roughly every week or 2 weeks (using the mc2xml method) and import fresh guide data into MediaPortal. For this I will be lookig into some Windows Task Scheduler or Batch File options to automate this process. If the &quot;Mapping&quot; has to be done just once - maybe it's better to just use the rinse &amp; repeat &amp; get it over with. If it has to be done every time - then I have to absolutely look into the PHP/MySQL solution. That aside - I'm trying to make sense of your clarification on the mapping code. I understand there are 2 tables, Channel &amp; TuningDetail. The records in the Channel will be associated with records in TuningDetail based on a key &quot;ChannelID&quot; that will link the 2 records together. I can use JOIN in mySQL to join 2 tables based on a key. I think here's my confusion:a) Is all the data that I need &quot;already&quot; in the Channel &amp; TuningDetail tables? Or am I getting data from &quot;somewhere&quot; and entering it into these 2 tables?b) Do I need to get the date from the tvguide.xml? In other words - is that XML file the &quot;source&quot; of my data? Or can I ignore that file for this process?I guess, here's an easy way to understand this ... i. Where am I getting the Data from?&nbsp; ii. What data am I trying to get?&nbsp; &nbsp;&nbsp; iii. Once I have the data - where am I inserting it?Once I get clarity on this - then perhaps I can start looking into the PHP/MySQL code required to achieve this. Again - let me assert very strongly - you have been a tremendous help in this process for me; I can't begin to express how much I appreciate your help &amp; support. Thanks.</blockquote>

[QUOTE="luci5r, post: 751934, member: 113478"] Ok - I didn't realize that was the case. But definitely good progress for me here. Is there thread/support discussion somewhere regarding setting up the IR Blaster to switch channels on the STB? I guess that would be critical in order to make the EPG recording work so I have to definitely pursue that. Ok - A LOT of information here to digest; I'll have to go slow & step by step. First of all - yes, I did indeed choose MySQL during installation. I can write a program in PHP and perform whatever is necessary on a mySQL database. I think the problem right now is that I don't quite understand what it is that I exactly have to do. Let me ask you a basic question first - this process of "Mapping", either via MediaPortal using "rinse & repeat", or via PHP/MySQL -- Is this something that will have to done every time I update the Guide Data?? Or is this something that only needs to be done once & that's it? I know that I have to get Guide data roughly every week or 2 weeks (using the mc2xml method) and import fresh guide data into MediaPortal. For this I will be lookig into some Windows Task Scheduler or Batch File options to automate this process. If the "Mapping" has to be done just once - maybe it's better to just use the rinse & repeat & get it over with. If it has to be done every time - then I have to absolutely look into the PHP/MySQL solution. That aside - I'm trying to make sense of your clarification on the mapping code. I understand there are 2 tables, Channel & TuningDetail. The records in the Channel will be associated with records in TuningDetail based on a key "ChannelID" that will link the 2 records together. I can use JOIN in mySQL to join 2 tables based on a key. I think here's my confusion: a) Is all the data that I need "already" in the Channel & TuningDetail tables? Or am I getting data from "somewhere" and entering it into these 2 tables? b) Do I need to get the date from the tvguide.xml? In other words - is that XML file the "source" of my data? Or can I ignore that file for this process? I guess, here's an easy way to understand this ... i. Where am I getting the Data from? ii. What data am I trying to get? iii. Once I have the data - where am I inserting it? Once I get clarity on this - then perhaps I can start looking into the PHP/MySQL code required to achieve this. Again - let me assert very strongly - you have been a tremendous help in this process for me; I can't begin to express how much I appreciate your help & support. Thanks. [/QUOTE]

Verification