MovieWiz 1.0.24.0 Series Lookup

[gehing]

Hello,
I have some trouble with series lookup in the new version. It works the first time, but the second time it doesn't look in thetvdb.com, instead it goes to IMDB.
The first was the episode "The Butterfly Effect" from Heroes. My title field was:
Heroes | The Butterfly Effect

The log shows:

VERBOSE [1] MovieWizConfigForm: tsbLookupDetail_Click()- Lookup detail requesetd.
VERBOSE [1] TheTvDbScraper: SearchForShow("Heroes", "The Butterfly Effect")- BEGIN
VERBOSE [1] AWizScraper: filterShowName()- Title: Heroes
VERBOSE [1] AWizScraper: filterShowName()- Returns: Heroes
VERBOSE [1] HttpInfoGrabber: ProcessHttpRequest()- http://thetvdb.com/api/GetSeries.php?seriesname=Heroes
VERBOSE [1] MovieWizConfigForm: cboLocation_SelectedIndexChanged- BEGIN
VERBOSE [1] MovieWizConfigForm: cboLocation_SelectedIndexChanged- END
VERBOSE [1] MovieWizConfigForm: tsbLookupImage_Click()- Image lookup requested - Config Order
VERBOSE [1] WizThumbnail: getShowImageHandle()- Source: LOCAL_MOVIE_SRC Title: Heroes | The Butterfly Effect
VERBOSE [1] WizThumbnail: getShowImageHandle()- Source: MANUAL_LOOKUP_NO_PROMPT Title: Heroes | The Butterfly Effect
VERBOSE [1] WizThumbnail: getShowImageHandle()- Found: False
VERBOSE [1] WizThumbnail: getShowImageHandle()- Found: False
VERBOSE [1] WizThumbnail: getShowImageHandle()- Source: THETVDB Title: Heroes | The Butterfly Effect
VERBOSE [1] AWizScraper: Constructor- WizUtilities/ScraperDebugLogging: False
VERBOSE [1] TheTvDbScraper: SearchForShow("Heroes", "The Butterfly Effect")- BEGIN
VERBOSE [1] AWizScraper: filterShowName()- Title: Heroes
VERBOSE [1] AWizScraper: filterShowName()- Returns: Heroes
VERBOSE [1] HttpInfoGrabber: ProcessHttpRequest()- http://thetvdb.com/api/GetSeries.php?seriesname=Heroes
VERBOSE [1] WizThumbnail: getShowImageHandle()- Found: True
VERBOSE [1] WizThumbnail: getShowImageHandle()- Source: TVGUIDE Title: Heroes | The Butterfly Effect
VERBOSE [1] WizThumbnail: getShowImageHandle()- Found: False
VERBOSE [1] WizThumbnail: getShowImageHandle()- Source: LOCAL_MEDIA_ART Title: Heroes | The Butterfly Effect
VERBOSE [1] WizThumbnail: getShowImageHandle()- Found: False
VERBOSE [1] WizThumbnail: getShowImageHandle()- Source: IMDB Title: Heroes | The Butterfly Effect
VERBOSE [1] AWizScraper: Constructor- WizUtilities/ScraperDebugLogging: False
VERBOSE [1] AWizScraper: filterShowName()- Title: Heroes | The Butterfly Effect
VERBOSE [1] AWizScraper: filterShowName()- Returns: Heroes The Butterfly Effect
VERBOSE [1] HttpInfoGrabber: ProcessHttpRequest()- http://www.imdb.com/find?s=tt;q=Heroes+T...fly+Effect
VERBOSE [1] AWizScraper: filterShowName()- Title: Heroes The Butterfly Effect
VERBOSE [1] AWizScraper: filterShowName()- Returns: Heroes The Butterfly Effect
VERBOSE [1] HttpInfoGrabber: ProcessHttpRequest()- http://www.imdb.com/find?s=tt;q=Heroes+T...fly+Effect
VERBOSE [1] WizThumbnail: getShowImageHandle()- Found: False
VERBOSE [1] WizThumbnail: getShowImageHandle()- Source: YAHOO Title: Heroes | The Butterfly Effect
VERBOSE [1] WizThumbnail: getShowImageHandle()- Found: False
VERBOSE [1] WizThumbnail: getShowImageHandle()- Source: EPGUIDE Title: Heroes | The Butterfly Effect
VERBOSE [1] WizThumbnail: getShowImageHandle()- Found: False
VERBOSE [1] MovieWizConfigForm: tsbLookupImage_Click()- Image found on The TvDB http://thetvdb.com/banners/episodes/79501-389522.jpg
VERBOSE [1] WizWebHelper: ThumbnailImage- http://thetvdb.com/banners/episodes/79501-389522.jpg
VERBOSE [1] MovieWizConfigForm: tsbSave_Click()- Save requested for S3E02 The Butterfly Effect

The second was the episode "One of Us, One of Them" from Heroes. My title field was:
Heroes | One of Us One of Them

The log shows:

VERBOSE [1] MovieWizConfigForm: tsbLookupDetail_Click()- Lookup detail requesetd.
VERBOSE [1] AWizScraper: filterShowName()- Title: 3037 One of Us One of Them
VERBOSE [1] AWizScraper: filterShowName()- Returns: 3037 One of Us One of Them
VERBOSE [1] HttpInfoGrabber: ProcessHttpRequest()- http://www.imdb.com/find?s=tt;q=3037+One...ne+of+Them
VERBOSE [1] AWizScraper: filterShowName()- Title: 3037 One of Us One of Them
VERBOSE [1] AWizScraper: filterShowName()- Returns: 3037 One of Us One of Them
VERBOSE [1] HttpInfoGrabber: ProcessHttpRequest()- http://www.imdb.com/find?s=tt;site=aka;q...ne+of+Them
VERBOSE [1] AWizScraper: Constructor- WizUtilities/ScraperDebugLogging: False
VERBOSE [1] MovieWizCore: SearchForDefafultEntry- 3037 One of Us One of Them
VERBOSE [1] MovieWizConfigForm: tsbLookupDetail_Click()- Lookup detail requesetd.
VERBOSE [1] AWizScraper: filterShowName()- Title: 3037 One of Us One of Them

This time, it didn't take the title, it took the filename instead.

How can this be fixed? I cannot close/open the MovieWiz Manager after each lookup, that take too much time.

Regards,
Gert

[JavaWiz]

What version of the program (and DLLs are you using)? I have found a couple bugs in the current version on the wiki related to thumbnail processing. Still working on the fixes for that.

The current version actually pops up an Alternates dialog for me when searching for "One of Us One of Them".

Try upgrading to current version (if you are not already on it), and then I'll supply a patch if you are still having problems.

[gehing]

I just did a clean install with GBPVR 1.3.11 and MovieWiz 1.0.24.0 because I thought that would solve the problems (I had this problem already with version 1.0.23.3). I would appreciate if you could give me a fix.
Regards,
Gert

[JavaWiz]

Give this version a try. I've made a couple of logic changes and added a little more logging.

I'm wondering if maybe I am not repeating the same steps you are, if there are still problems, recreate then send me the complete log.

[gehing]

With your new dll, I tried with two episodes of Heroes: "I Am Become Death" and "Angels and Monsters". After I loaded these entries into the DB, it would take the filename instead of the title "Heroes | I Am Become Death" (MovieWizManager.exe-1.log). Then I restarted MovieWizManager (MovieWizManager.exe.log).
The first time, it used the title "Heroes | I Am Become Death". It worked right and got the entry from thetvdb.com.
The second time, I tried "Heroes | Angels and Monsters". This time, it didn't use the title but the filename instead and tried to find an entry in IMDB.

Regards,
Gert

[JavaWiz]

Try this version. I've included a complete install since the WizDLL changed also. If it does not work, zip and post log.

[gehing]

I tried the new version and I have even more problems.
I tried the new episode from Family Guy, named Family Gay. Even on the first try it didn't give me the series information, it gave me an alternative list from IMDB (the title was "Family Guy | Family Gay"). Also, when I tries to update the information in the database, it told me that it couldn't save the information in the db.

I have another question too: It seems that the performance is getting worse over time as I add movies and episodes (I have 1700+ entries in the db). Is there a way to re-org the database for performance? Or add any indexes?

[JavaWiz]

I tried the new version and I have even more problems.
I tried the new episode from Family Guy, named Family Gay. Even on the first try it didn't give me the series information, it gave me an alternative list from IMDB (the title was "Family Guy | Family Gay").

Ok, finally with the enhanced logging, I think I see what is going on.

MovieWiz has no way to know if the entry you are trying to load is a Series or just a movie. It assumes a series/episode title is in the format "seriesName - episode" or "seriesName | episode". It uses this logic both at load time (Add Content tab), and at manual lookup time (Manage Content tab).

When you loaded the file \\SPEEDY\series\Family Guy\Season 7\7116 Family Gay.avi, there was no '-' in the filename, so it assumed it was a movie and bypassed TheTvDb lookup and used IMDB instead. Note, MovieWiz does not understand directory structures, only filenames (load) and your manually inputted titles (manage content).

When you performed the manual lookup, the title was set to "7116 Family Gay" again, not in Series|Episode format. Based on the title, there is no way to know that that entry belongs to the series "Family Guy".

Before you click the "Lookup Detail" button, check the "Override Title" checkbox. You will then be able to pre-pend "The Family Guy|" to the title string in order to get an accurate lookup.

To make things easier on load, I may be able to provide a 'Series' textbox so that, if supplied, each entry is treated as an episode to what ever series name you supply. This will ease batch loading of several episodes at once.

Also, when I tries to update the information in the database, it told me that it couldn't save the information in the db.

This looks like a bug, I'll take a look.

I have another question too: It seems that the performance is getting worse over time as I add movies and episodes (I have 1700+ entries in the db). Is there a way to re-org the database for performance? Or add any indexes?

Yes I think so. Indexes probably will help, I will look at adding some after we get the logic straighten out with the above problems.

Meanwhile, I've added a "Vacuum Db" feature in the next version (Settings 1 tab) that will compress the database, and hopefully speed things up a bit.

[hakras]

Hey JavaWiz

I haven't tried TV Series, but have a suggestion. Since most movie files would be in a folder with the same name and tv files would be in a program name folder and episode file with different name, maybe you can check for "-" and if it doesn't exist use the folder name for program and file name for episode.

Just a thought....