Allowing only one genre per movie (1 Viewer)

[BlackdogZA]

Hi

I appreciate that a movie fits into multiple genres but I find it quite annoying that IMDB allows a movie to have so many genres that it renders a view by genre almost useless for large movie collections.

Is there a way to limit the update from IMDB to say just the first genre?

Editing each movie to change the genre is incredibly time consuming. I guess the other way is a single SQL update statement. Hmm, I might ask the Mrs for help with that.

Other ideas ?

 

[Gup]

Hi,

I understand your problem. The only way i found a solution is to store all movies by genre on disk. Then adding catagories based on full path. This way i decide the genre for the movie and not the crap imdb tag.

 

[RoChess]

You can also work around the limitations of the existing system that you forsee.

I personally like the multiple-genres done by IMDb, because a movie like 'Scream' is more a comedy to me then a 'Horror', but my wife would look under Horror/Thriller to find it.

But you can just create your own genre folders, and then add complex exceptions for it, or combinations. For example I got a genre 'Romatic Comedy' that looks for movies that have genre 'Comedy' and 'Romance'. And then exclude those movies from the custom 'Comedy' genre. It can get complex and I got some custom categories with like 30 rules, but only had to set it up once and enjoy it forever (praying that IMDb doesn't decide to change genre naming).

The problem with only using one genre from IMDb is that the genres are shown in alphabetical order. So eventhough it is easy to adjust the scraper to only grab one genre, the results will not be pretty. Avatar for example will be put under 'Action' and while technically correct, I have it under the Sci-Fi genre myself.

 

[Octagon]

On a somewhat related note - is there a (preferably free, of course GUI based SQL editor available anywhere?

Manually editing a large collection is pretty tedious but if I could say select multiple records from a list in one pane and then apply the same change(s) to all of them at once I might be willing to put that time in.

It would also be useful for managing music collections.

I've played around with SQLite and can manage basic queries but something a little more user-friendly would definitely be worth a look.

 

[RoChess]

I use SQLite Browser for quick and easy editing, but I also use:

SQLite Expert - A powerful administration tool for your SQLite databases

for when things require a little more finess.

 

[Octagon]

Thanks for the link. I don't know how it will help my limited query abilities but the data browser alone was worth the download.

Very cool.