forum.coppermine-gallery.net

No Support => Feature requests => Topic started by: rickussher on April 25, 2005, 12:01:00 pm

Title: Keyword Database
Post by: rickussher on April 25, 2005, 12:01:00 pm
Hi all,

have been using extensis portfolio for a long time and are in the process of migrating to coppermine (thx for everyones hard work - it is fantastic)

was wondering how hard it would be to introduce a user defined set of keywords & subkeywords with a one (image) to many (keywords) relationship - which would then be searchable from the search page

thx in advance

cheers

rick
Title: Re: Keyword Database
Post by: Joachim Müller on April 25, 2005, 01:33:45 pm
not sure what you mean: each pic can already have multiple keywords (separated by spaces), and the keywords are being taken into account when searching. What exactly are you requesting?

Joachim
Title: Re: Keyword Database
Post by: rickussher on April 25, 2005, 10:43:46 pm
thx for reply

current coppermine database has a one (album) to many (image) relationship

having a pre defined admin only settable group of keywords improves the integrity of any database - less keywords = better searches

but this would require a one (image) to many (keywords) relationship

eg.

image in "Home\Holidays\2005\Greece" that is say a picture of you lying on the beach could have keywords "beach, people, friends"

would require 2 new tables - one for keywords and a join table to image database

advantages = when searching as well as having free text, and drop down list could make available keywords used to help refine searches

cheers again

rick


Title: Re: Keyword Database
Post by: Nibbler on April 25, 2005, 10:54:53 pm
This already exists in 1.4 You can have the keywords displayed on the search page clickably.
Title: Re: Keyword Database
Post by: rickussher on April 26, 2005, 04:52:10 am
cant wait for 1.4

thx for all the hard work