Reply to thread

Message

<blockquote data-quote="luci5r" data-source="post: 752273" data-attributes="member: 113478">mm,As &quot;promised&quot;, I do have a question for you <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink&nbsp; &nbsp; ;)" loading="lazy" data-shortname=";)" />I was looking at the &quot;Channel&quot; and &quot;TuningDetail&quot; table in my MySQL Database for TV Server Configuration. I'm trying to write a PHP/MySQL script to create all the channels for me in these 2 tables using the tvguide.xml (for channel name &amp; numbers). Following are my 2 tables with 3 example channels that I had entered manually using the TV Server Configuration GUI:<img src="http://www.rahulsjohari.com/ASSETS/GRUBS/DB1.JPG" alt="" class="fr-fic fr-dii fr-draggable " style="" />Here's my question:In the &quot;Channel&quot; table, I can get data for these 2 fields from tvguide.xml:- externalId- displayNameIn the &quot;TuningDetail&quot; table, I can get for these 2 fields from tvguide.xml:- name- channelNumberNow I see there's a lot of fields which are pretty much consistent so I don't have to worry about them and I'll just copy what's in the rest of the records. However, there are 2 fields that seems to have &quot;intelligent&quot; data which is different for each record but not available in tvguide.xml:- idTuning (this is in TuningDetail)- idChannel (The primary key - in both tables which joins the 2 records)Where do I get these 2 values from? Do I generate them on my own? They are obviously not in the tvguide.xml; I'm not sure where to get data for these 2 fields from. Following is an example value from my &quot;tvguide.xml&quot; :[CODE]&lt;channel id=&quot;I655.189993291.microsoft.com&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;display-name&gt;655 FNCHD&lt;/display-name&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;display-name&gt;655&lt;/display-name&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;display-name&gt;FNCHD&lt;/display-name&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;display-name&gt;Fox News Channel HD&lt;/display-name&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;display-name&gt;Satellite&lt;/display-name&gt;&lt;/channel&gt;[/CODE]As you can see, I have externalId, DisplayName &amp; ChannelNumber available in this block; but I don't have idTuning &amp; idChannel in here. Would really appreciate your help. Thanks!!EDIT:I might be answering my own question here; but I just added another channel &quot;manually&quot; and I can see a pattern emerging. It is appearing to me that both &quot;idTuning&quot; and &quot;idChannel&quot; are not so intelligent - instead - they are just sequential numbers. If that is the case - my PHP script should be able to give them sequential numbers without issues. If anyone can confirm this. Thanks!</blockquote>

[QUOTE="luci5r, post: 752273, member: 113478"] mm, As "promised", I do have a question for you ;) I was looking at the "Channel" and "TuningDetail" table in my MySQL Database for TV Server Configuration. I'm trying to write a PHP/MySQL script to create all the channels for me in these 2 tables using the tvguide.xml (for channel name & numbers). Following are my 2 tables with 3 example channels that I had entered manually using the TV Server Configuration GUI: [IMG]http://www.rahulsjohari.com/ASSETS/GRUBS/DB1.JPG[/IMG] Here's my question: In the "Channel" table, I can get data for these 2 fields from tvguide.xml: - externalId - displayName In the "TuningDetail" table, I can get for these 2 fields from tvguide.xml: - name - channelNumber Now I see there's a lot of fields which are pretty much consistent so I don't have to worry about them and I'll just copy what's in the rest of the records. However, there are 2 fields that seems to have "intelligent" data which is different for each record but not available in tvguide.xml: - idTuning (this is in TuningDetail) - idChannel (The primary key - in both tables which joins the 2 records) Where do I get these 2 values from? Do I generate them on my own? They are obviously not in the tvguide.xml; I'm not sure where to get data for these 2 fields from. Following is an example value from my "tvguide.xml" : [CODE] <channel id="I655.189993291.microsoft.com"> <display-name>655 FNCHD</display-name> <display-name>655</display-name> <display-name>FNCHD</display-name> <display-name>Fox News Channel HD</display-name> <display-name>Satellite</display-name> </channel> [/CODE] As you can see, I have externalId, DisplayName & ChannelNumber available in this block; but I don't have idTuning & idChannel in here. Would really appreciate your help. Thanks!! [B][U]EDIT[/U][/B]: I might be answering my own question here; but I just added another channel "manually" and I can see a pattern emerging. It is appearing to me that both "idTuning" and "idChannel" are not so intelligent - instead - they are just sequential numbers. If that is the case - my PHP script should be able to give them sequential numbers without issues. If anyone can confirm this. Thanks! [/QUOTE]

Verification