[mythtv-users] Should Videos be considered Recorded?

[Raymond Wagner]

On 5/22/2013 9:50 AM, Thomas Boehm wrote:
> Frank Feuerbacher wrote:
>> On 5/19/2013 10:24 PM, Michael T. Dean wrote:
>>> On 05/19/2013 10:17 PM, Frank Feuerbacher wrote:
>>>> I have pointed  my mythtv Videos to my XBMC movies in the hope that I
>>>> could easily see what movies I have already recorded in the mythweb
>>>> movie listings. But, this does not appear to be the case. Can someone
>>>> confirm this? Is there a way to accomplish what I am after?
>>>>
>>>> I can see the XBMC movies in mythtv. I initiated a scan of them to
>>>> get the metadata. I saw the metadata for some files, but had to
>>>> manually initiate fetching for individual movies with the keyboard
>>>> shortcut "w" (perhaps I did not wait long enough for the scan to
>>>> occur). Anyway, I can confirm that the movie "You Can't Take it With
>>>> You" has it's metadata downloaded into Mythtv, but Mythtweb does not
>>>> indicate that it has already been recorded when I look at the TCM
>>>> schedule.
>>> Unfortunately the metadata you get for your movies is different from
>>> the program listings data you get for TV, so it's very difficult to
>>> match up videos with broadcast movies in anything more than a naive
>>> title (and possibly subtitle) type comparison. Even with TV recording
>>> history, we re-record episodes because of similarly non-exact
>>> matches.  This, however, has the advantage that you end up recording
>>> something you don't need, after which you can delete it without
>>> watching (and get an exact match for future airings that have
>>> similarly broken program data).
>>>
>>> So, the best you can do is tell MythTV you already recorded those
>>> movies.  The simplest way to do so is to find the movies in the
>>> Upcoming Recordings page of MythWeb and click on "Never record." That
>>> puts the movie into MythTV's recording history--complete with its
>>> unique program identifier--and tells it not to record, as if you had
>>> recorded the episode.
>>>
>> I'm guessing that there is no tool to let me mark a list of movies as
>> "never record" from a script.
> Some time ago someone here gave me this tip:
>
> Title: Actors
> Additional Tables: , people, credits
> Search Phrase: people.name REGEXP '^Actor1$|^Actor2$|^Actor3$|^Actor4$'
> AND credits.person = people.person AND program.chanid = credits.chanid
> AND program.starttime = credits.starttime AND program.title NOT IN
> (SELECT DISTINCT title FROM videometadata)
>
> Maybe you can use it for your custom recording rule.

I'm not really sure what's going on here.  It looks like you're matching 
on shows with cast members named 'Actor[1-4]', which doesn't make sense, 
but is really irrelevant anyway.  The only bit of consequence is

> program.title NOT IN
> (SELECT DISTINCT title FROM videometadata)

Which comes right back to what Mike said previously about false 
positives on every movie with a duplicate title, which is specifically 
why MythTV uses more than just the title for duplicate matching.