Online Administration Software

Locked
User avatar
Survivor
Posts: 4202
Joined: Fri Dec 27, 2002 8:00 am

Online Administration Software

Post by Survivor »

My quarterly tech post is up again and this time it's about member administration for associations. What I'm basicly looking for is an online solution where people can log into from anywhere and do their stuff.
The contents of the administration software should probably hook up to some MYSQL database to stay generic but as always i'm grainy on the background stuff.
The information to be contained should have constant information and periodwise information, e.g. Name, e-mail and id number and other stuff entered for example are constant but the course followed might change level or entirely over the course of the membership and should be able to be entered per period where periods themselves should also be specifiable by the people who log in. Then it should store this per period so the administrative people can look back if necessary. Members should also be able to be set as members of one or more groups. Also a must is a mass mail function which mails to the databaselinked mails and might be filtered to only send to certain groups or specific members.
An export function to an excel spreadsheet file is also a must.
It does not need specific user right management although a difference between view and edit authority would also be very useful.
I know there are dozens of professional solutions that are capable of doing some of this. However all of them are pricy and only few of them are even usable by my standards. The question here then is does any of you know of a cheap solution, an opensource solution (sourceforge has one bad and nonupdated one as far as i can tell), advice on programming one or willing to program one for some small fee. I can't promise a lot on the last part but since if it is done correctly it shouldn't need anymore updates or service packs as all the professional packages seem to forcingly include an investment might be made.
Fender
Posts: 5876
Joined: Sun Jan 14, 2001 8:00 am

Re: Online Administration Software

Post by Fender »

User avatar
Survivor
Posts: 4202
Joined: Fri Dec 27, 2002 8:00 am

Re: Online Administration Software

Post by Survivor »

No, it's more like a database which is editable and viewable and stored on the space of a rented webserver. The current one is a php frontend on a mysql database but is terribly outdated and not editable because of problems in access rights with the company. That's why i am looking for an alternative. Not a remote desktop system.
^misantropia^
Posts: 4022
Joined: Sat Mar 12, 2005 6:24 pm

Re: Online Administration Software

Post by ^misantropia^ »

No off-the-shelf package I can think of does what you want. Make me an offer I can't refuse and I'll write it for you.
Underpants?
Posts: 4755
Joined: Mon Oct 22, 2001 7:00 am

Re: Online Administration Software

Post by Underpants? »

Though my guess would be that this ^ guy can setup exactly what you need,
http://www.troubleticketexpress.com/
I think this is close to what you're looking for. We use this at my current employer. Didn't set it up, so don't know how much of a bitch it is It has granular access (read-only, create ticket users and administrators) and it also has an export feature:
"Data export with optional Export module to build custom reports using your favorite spreadsheet or analytical program."
http://twiki.org/
looks good, though, too.
Locked