Reply to thread

Message

<blockquote data-quote="geoffstewart" data-source="post: 624415" data-attributes="member: 83396">Re: Schedules Direct US/Canadian/Mexico EPG Plugin (Updated April 2010)Hey Andrew,First, the First Aired field seems to get filled in if it's provided.&nbsp; It goes in the originalAirDate database field.&nbsp; The quality of this information is highly suspect for sure.&nbsp; Sometimes, it refers to when the series first began.&nbsp; Other times, it refers to when this episode was actually aired.Second,&nbsp; here is the list of database fields:[CODE]idProgram&nbsp; &nbsp; int(11)&nbsp; &nbsp; NO&nbsp; &nbsp; PRI&nbsp; &nbsp; &lt;null&gt;&nbsp; &nbsp; auto_incrementidChannel&nbsp; &nbsp; int(11)&nbsp; &nbsp; NO&nbsp; &nbsp; MUL&nbsp; &nbsp; &lt;null&gt;&nbsp; &nbsp; startTime&nbsp; &nbsp; datetime&nbsp; &nbsp; NO&nbsp; &nbsp; &nbsp; &nbsp; &lt;null&gt;&nbsp; &nbsp; endTime&nbsp; &nbsp; datetime&nbsp; &nbsp; NO&nbsp; &nbsp; &nbsp; &nbsp; &lt;null&gt;&nbsp; &nbsp; title&nbsp; &nbsp; varchar(2000)&nbsp; &nbsp; NO&nbsp; &nbsp; &nbsp; &nbsp; &lt;null&gt;&nbsp; &nbsp; description&nbsp; &nbsp; text&nbsp; &nbsp; NO&nbsp; &nbsp; &nbsp; &nbsp; &lt;null&gt;&nbsp; &nbsp; seriesNum&nbsp; &nbsp; varchar(200)&nbsp; &nbsp; NO&nbsp; &nbsp; &nbsp; &nbsp; &lt;null&gt;&nbsp; &nbsp; episodeNum&nbsp; &nbsp; varchar(200)&nbsp; &nbsp; NO&nbsp; &nbsp; &nbsp; &nbsp; &lt;null&gt;&nbsp; &nbsp; genre&nbsp; &nbsp; varchar(200)&nbsp; &nbsp; NO&nbsp; &nbsp; &nbsp; &nbsp; &lt;null&gt;&nbsp; &nbsp; originalAirDate&nbsp; &nbsp; datetime&nbsp; &nbsp; NO&nbsp; &nbsp; &nbsp; &nbsp; &lt;null&gt;&nbsp; &nbsp; classification&nbsp; &nbsp; varchar(200)&nbsp; &nbsp; NO&nbsp; &nbsp; &nbsp; &nbsp; &lt;null&gt;&nbsp; &nbsp; starRating&nbsp; &nbsp; int(11)&nbsp; &nbsp; NO&nbsp; &nbsp; &nbsp; &nbsp; &lt;null&gt;&nbsp; &nbsp; parentalRating&nbsp; &nbsp; int(11)&nbsp; &nbsp; NO&nbsp; &nbsp; &nbsp; &nbsp; &lt;null&gt;&nbsp; &nbsp; episodeName&nbsp; &nbsp; text&nbsp; &nbsp; NO&nbsp; &nbsp; &nbsp; &nbsp; &lt;null&gt;&nbsp; &nbsp; episodePart&nbsp; &nbsp; text&nbsp; &nbsp; NO&nbsp; &nbsp; &nbsp; &nbsp; &lt;null&gt;&nbsp; &nbsp; state&nbsp; &nbsp; int(11)&nbsp; &nbsp; NO&nbsp; &nbsp; MUL&nbsp; &nbsp; 0&nbsp; &nbsp; [/CODE]I don't know of any information that is provided that is not already being added to the database.&nbsp; Let me know if you find that to be incorrect and I'll add it for sure.As for the checkbox to enable uniqueness, I think if you pick Episode Title, it really only helps for not recording the same Movie more than once and has the horrible side-effect of recording just the first episode of a series... bad.&nbsp; Since the quality of episode number is still not that great, I think that would be a tricky one to use too.&nbsp; I elected to not use that checkbox and just delete duplicates if I get them.&nbsp; I think the combination of episode title/episode name (and possibly episode number) would get closer to not having duplicates depending on the quality of the data.Cheers.Geoff</blockquote>

[QUOTE="geoffstewart, post: 624415, member: 83396"] [b]Re: Schedules Direct US/Canadian/Mexico EPG Plugin (Updated April 2010)[/b] Hey Andrew, First, the First Aired field seems to get filled in if it's provided. It goes in the originalAirDate database field. The quality of this information is highly suspect for sure. Sometimes, it refers to when the series first began. Other times, it refers to when this episode was actually aired. Second, here is the list of database fields: [CODE] idProgram int(11) NO PRI <null> auto_increment idChannel int(11) NO MUL <null> startTime datetime NO <null> endTime datetime NO <null> title varchar(2000) NO <null> description text NO <null> seriesNum varchar(200) NO <null> episodeNum varchar(200) NO <null> genre varchar(200) NO <null> originalAirDate datetime NO <null> classification varchar(200) NO <null> starRating int(11) NO <null> parentalRating int(11) NO <null> episodeName text NO <null> episodePart text NO <null> state int(11) NO MUL 0 [/CODE] I don't know of any information that is provided that is not already being added to the database. Let me know if you find that to be incorrect and I'll add it for sure. As for the checkbox to enable uniqueness, I think if you pick Episode Title, it really only helps for not recording the same Movie more than once and has the horrible side-effect of recording just the first episode of a series... bad. Since the quality of episode number is still not that great, I think that would be a tricky one to use too. I elected to not use that checkbox and just delete duplicates if I get them. I think the combination of episode title/episode name (and possibly episode number) would get closer to not having duplicates depending on the quality of the data. Cheers. Geoff [/QUOTE]

Verification