How to categorize DivX movies burned on DVDs

[Sasa M]

Hi to all..

For a couple years I use griffith for my home movie categorization.
What i needed was simply categorization by burned DVD number. So, on
one DVD it is possible to burn couple DivX movies. On that DVD, after
burning 4-5 movies, I wrote No 1, and so on on other DVDs. Under
griffith tab Technical information > Discs I wrote that DVD number.
So, you have for or five movies under one Disc number. Then, under
griffith tab Technical information > Collection i wrote foreigner,
domestic or cartoon movies and I select one of this three category. So
when I search for movie, i find it let say by the name, and then open
Technical tab and I can see what DVD Disc number that movie is burned,
so I can find that DVD in my collection (45 or 67 or 86 etc) and than
I can play it.
But, today i faced with problem because it is possible to wrote up to
100 Dics and no more. So I burned 101 DVD with movies and now I can't
type 101 under Technical information > Discs. What to do, is there any
other way for categorization, because i have 101 DVDs with more then
500 movies on them.

Thank you

[CinéphOli]

Hello,

Le 12/06/2012 22:10, Sasa M a �crit :

Using SQL commands, it should be possible to copy/move the content of
the field movies.media_num to the field volumes.name. They are located
in two different tables, but it should be possible to link on the volume_id.

But: how about using instead the field movies.classification to store
your DVD numbers? It can hold up to 128 characters, plenty of space for
your numbering scheme, and it is searchable in the advanced search
screen (like volumes and collections). Are you really interested in
PG-ratings and such things? Also, you would keep free both fields volume
and collection to maintain and further sort your DVDs.
And since it is a field in the same table (movies), the transfer is even
easier to realize with SQL commands.

If your database is in the SQLite format (the default one) and if you
don't know how to use SQL commands (or SQL Alchemy), then you can send
me your database, I'll (try to) do the changes for you.

--
Cin�phOli
Using Griffith v0.13 on Ubuntu 10.04 LTS