Greetings everyone. I hope I will be forgiven if these questions are answered somewhere already. I looked through the FAQ and "search" for an answer but didn't really get a clear one. I am looking for some software for my Masonic lodge to do the following:

1) Calendaring, for scheduling events etc. It would be great if it could be integrated with iCal.

2) A way to store PDF/TIFF images of scans I am doing of lodge records. This at the moment consists of simple cards of members that were used before we went to computers. Name, Address, DOB, when they joined, are they current on their dues, how many years have they been a member, etc. Pretty boring mundane stats. But the cards go back close to 100 years and we have cabinets full of these I want to scan and archive for our history.

3) Membership list with contact information so the members can keep in contact with each other and they wont have to keep asking various other members "Hey do you have so and so's phone # or email?".
This has started to get out of hand because no one in my lodge can seem to remember anyones details :)

4) I prefer to be able to store all this in a PostgreSQL database. I know many prefer MySQL but one of my attractions to Drupal is its neutral stance for backends and its ability to use PG.

5) Some other things I would like to use the software for is a mass mailing to members of a PDF newsletter I will put together and then just mail out to all the members on a list.

That was just an idea of what I want to do. My question so far is really about #2 I wasn't able to find if Drupal has full PDF text indexing and search? Plone seems to have it but that's what the site says I havent tried it to see if it works, it could be all marketing talk. Being able to index the PDF's automatically would be great. Then people could search for a members card based on name, or member number, or whatever information is on that persons membership card. So in researching the software I guess thats my first question I wasn't able to answer was if Drupal supports full indexing/searching of PDF files.

Thanks for any pointers to relevant information!

Chris

Comments

missym’s picture

Hi Chris --

The answers to all your questions are already posted except #2.

You can look at the Swish-e Indexer module for PDF indexing. If you have 100 year old records, many are likely hand written and may not work well with OCR software. Import/Export iCal in calendar module.

Good luck --

Missy.

msheridan69’s picture

Hi Chris,

I too am looking for a jump start in setting up out lodge website - can you help me?

Cheers!
Martin

usonian’s picture

I'm a bit late to the game, but I recently started a working group to discuss the possibility of an installation profile that could be used by Masonic lodges and other fraternal/community organizations to quickly get a site off the ground. Not much activity yet, but it would definitely be great to start a dialog and learn what people think are "must have" features:

http://groups.drupal.org/lodges-and-other-fraternalcommunity-organizations