Reply to thread

Message

<blockquote data-quote="sixgun" data-source="post: 398457" data-attributes="member: 71410">I've been looking at the TVLibrary database and found a couple of likely suspects for holding the season recording information.So, far I've got this as my SQL for extracting the information...[CODE]SELECT * FROM Schedule WHERE id_Schedule NOT IN (SELECT idSchedule FROM CanceledSchedule)[/CODE]Can anyone tell me if that's correct and if I've missed anything?I am planning to upgrade from v1 RC1 to v1 (final), and I really want to avoid having to re-enter my season recordings as and when they re-appear in the TV Guide. One of the *BIG* plus points of having media portal is that I can set my season records up and just forget about it, then when things appear in Recorded TV I just watch them when I feel like it. I rarely watch Live TV for that very reason (oh, and the ad skipping <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />)Anyway, I'm hoping I can run the above query against my TvLibrary database, save the results to a text file and then just do a bulk insert once I've done a clean install of MediaPortal v1.0</blockquote>

[QUOTE="sixgun, post: 398457, member: 71410"] I've been looking at the TVLibrary database and found a couple of likely suspects for holding the season recording information. So, far I've got this as my SQL for extracting the information... [CODE]SELECT * FROM Schedule WHERE id_Schedule NOT IN (SELECT idSchedule FROM CanceledSchedule)[/CODE] Can anyone tell me if that's correct and if I've missed anything? I am planning to upgrade from v1 RC1 to v1 (final), and I really want to avoid having to re-enter my season recordings as and when they re-appear in the TV Guide. One of the *BIG* plus points of having media portal is that I can set my season records up and just forget about it, then when things appear in Recorded TV I just watch them when I feel like it. I rarely watch Live TV for that very reason (oh, and the ad skipping :)) Anyway, I'm hoping I can run the above query against my TvLibrary database, save the results to a text file and then just do a bulk insert once I've done a clean install of MediaPortal v1.0 [/QUOTE]

Verification