My order, fill it!
August 28, 2013 1:45 AM Subscribe
We have four departments and each has their own way of managing their student lists, I'd like to find one solution to rule them all.
posted by monocultured to computers & internet (6 answers total) 1 user marked this as a favorite
Each department has their own way of managing which students are active, on sabbatical, sick leave, and their contact information, with solutions ranging from a Google doc spreadsheet, Excel document, to DB-to-PDF export — all dumped in one shared folder on the network. I'm on the receiving end of this when I'm managing mailing lists etc.
The fastest solution would be 1 strictly controlled Excel document on the shared volume, but this opens up for human errors of saving, moving, or when there's simultaneous editing of the document. The next step up is a locally hosted database which I would administer, with a simple & pretty GUI for those who update the student info.
I need to be able to create categories (Year, course, name, email, phone, ss#) and be able to view & export the data. My users would have to be able to add/erase student information (but not categories) and view/export the data, and because of the data I'd need to have some security — most practically with a user/pass setup.
What's the least painful way of doing this? I want to have a web interface for this, and won't go near Filemaker with a cat5-pole. We have an OSX server running, but can set up another host should it be required.