Ok guys, interesting problem for you:
The company I work at are moving to an 'agile working' environment, where all staff members will come into the office and grab whatever seat is available. Sadly, we're not going to be getting VoIP phones for some time (we have a static tdm pbx system; extension numbers are fixed to individual handsets), so we've got to get a little creative with managing our online phonebook. Luckily, we will have a record of what extension number is next to what workstation, and this is fixed.
So, with that in mind, what we want to do is set up a system where, upon logging in to a workstation, the username, workstation number and associated telephone extension is sent to a database. Upon receiving this, the database will update with the new records so that anyone searching will receive the latest results.
Now, I'm charged with the database/web side of things, one of our network admins is charged with the script. He says he can create the script with no problem. The problem I foresee is getting the database over written (scheduling an update would be simple, but it won't be up to date enough) and dealing with the enormous numbers of overwrite requests could get a little tricky (approximately 400 staff, so 8:30 - 9:00am is going to be fairly busy).
Thoughts on this, anyone? Vegetta, you tackled anything like this?
Rather than doing it based upon an overwrite, can you do something instead where you just add records to the database, and only pull in the most recent addition for each extension? You could then do a flush of old records on a schedule basis.