JamesShort wrote:
The solution that we are looking into needs some careful design so there are paper trails in the event of a failure. I'm thinking that the system can put an auto remark in the notes section of every paypal txn that has the info for the person and year and type of membership (single or family or lifetime) just incase the form generation fails or isn't archived or the emails are lost (whatever method we go with).
The biggest complication is handling the membership type. Things that can and do happen:
- Getting an individual renewal from someone with a family membership (is it a mistake, or are they dropping the rest of the family members?)
- Getting a family renewal from someone with an individual membership (how do you know who else is now included?)
- Getting a family renewal from someone who isn't a listed member, but may have a legitimate "family" membership (if the name isn't conclusive and the address doesn't match, whose membership gets renewed?)
- Getting an individual renewal from someone who isn't a listed member, but was formerly a legitimate "family" member (what does that mean? could be a mistake, or maybe a son or daughter "coming of age")
These are some of the factors (besides laziness) that have kept me from creating a membership database so far. Really, for most of these conditions the best answer is to shoot off an email or a phone call and ask the person what's up. That's why having a dedicated person handling memberships is a good idea. So far, that's been Bowie, and he's great at it. You could have another person who just handles online renewals, and that keeps a human in the equation that can work through these issues without requiring any lines of code

. They'd be doing a lot of what Bowie is already doing, but that's OK, as long as they don't step on each other in managing the database or Excel spreadsheet or whatever you're using. Ultimately it's not a computer issue, it's a people issue.
_________________
Carl Fisher
Be Cool to the Pizza Dude:
http://www.npr.org/templates/story/stor ... Id=4651531