By itowler on

I am not sure how to accomplish this, so I thought that I would ask the community.

I have a drupal 6.x site up and running, and everything seems to be chugging along fine. I would like to add a feature to the site, but I can not seem to find the correct module/combination of modules to get this done. What I want is to have a searchable database. Yes I know that Drupal is database driven, but I would like to have a separate database for this particular application. The database will be similar to a phone book, but instead it will contain names, death dates, service state, burial locations etc... The people in the database will not be members, so a "profile" type module will not work.

There are a few other "catches" I expect that when finished, the database will have around 10,000 people in it, but currently I only have about 2000 people, so I would like to have an interface to add to the database via the website, as an admin. Adding to the database would not be a "public / anonymous" feature, only an admin feature.

lastly I would like the public/anonymous user to be able to search the database using a name, or place... once the search results are displayed a link will be given for the individual so detailed info can be provided.

An example of an implementation of this can be found at :

http://graves.inssar.org/ (try searching for Arbuckle as surname, or Clark county as burial place...)

I figure this is not a straight forward application, but would love to have any input.

my current site is :

www.marylandsar.org

Thanks for the time in advance... :)

⋅ Categories: Drupal 6.x

Comments

ray_223’s picture

ray_223 commented

CCK will allow you to create a node type with the appropriate fields.
I don't know of any search modules that are restricted to a particular content type - but have a look through the "Search" modules at:
http://drupal.org/project/Modules/category/105

Ray Smith
http://RaymondSmith.com

Ray Smith
http://RaymondSmith.com

itowler’s picture

itowler commented

Just wanted to post a follow up to my original post. Between CCK / Views 2 / and Token I managed to get what I wanted.

Thanks

digitalflick’s picture

digitalflick commented

I'm am trying to do a searchable database as well. Really simple search terms though.

Basically user signs up, creates specific content & enters some basic fields. These fields need to be searchable site-wide.

How'd you do it! Thanks

ukcowboy282’s picture

ukcowboy282 commented

Hi

I need the same sort of thing, I run a site for my old Regiment. The guys using it like to be informed of old comrades and as they are getting older there are fewer and fewer. There is no database anywhere for the recording of deaths and i would like to create a searchable database. I can get most of the information from other sources I just need to create a method for the guys to be able to search for fallen comrades. Can anyone suggest a simple method?