4 posts in this topic
By Mr. B
We are Americans who are a non-profit and have a school for squatter children in the slums of the Philippines and would like to create student attendance database that provides various rewards.
Our goal is to encourage the kids to attend school who otherwise wouldn't and provide them with a reward point type of system. Each day they attend school, they get 5pts. If they remembered to wear their school uniform they get additional 5 pts. At the end of the day or the end of the week, they can use their points and trade them in for rice, milk, things that will help them feed their family, get school supplies etc.
We would like to account for how often they come to track their daily attendance. We are hoping to include other fields that would be helpful to medical assistance, needs, etc.
As of now, we print and laminte, cutout little paper coins we give them and it is a lot of work. We have around 400-600 kids who attend class. Annually we have several large community events where we track the daily attendance during summer of up to 3,000 students who attend. This is all done by hand so a digital type system would really benefit, save time, manpower, and streamline what we are doing.
- track attendance
- reward attendance and such by point system
- can use their student card points at cafeteria for snacks or for extra stuff as incentive to help their families.
If you know of something that would help us, or have some ideas, please let us know.
I am running a server side script that attempts to update records in a MySQL table that is set up as an external data source. It runs without issue for hours to weeks at a time then gets hung on error 512 (Record was already modified by another user). The problem is that I can't figure out how to capture and handle this error. I've tried adding "If get(lasterror)=512 then <skip this record and continue to next> just after the 'Go to Record(next)' but it never gets to that step. Instead hangs on try to move the record pointer and writing error after error to the log.
I've searched the forums fairly thoroughly but there is not a lot of info forthcoming. Surely this has been a problem for someone else that has figured out how to handle it. Any suggestions appreciated.
Will be glad to provide more info on the environment if needed.
Thanks in advance,
I tried to install MirrorSync 3.17 today on a MacOS with 10.12.3 and FMS 18.104.22.1688. The installer is hanging at about 80% progress at "Running package scripts..."
Is there an installer log file that I can examine?
In addition I noted in the docs the restriction against multiple users sharing the same file on the same device:
I am wondering about the details of this restriction and is it possible for multiple users to share the same db file on the same device if there is no record filtering or record-level access features enabled?
What is wrong when Database appears unavailable to the scheduler, yet regular users are logged in?
By Colin Hunter
I'm running FMS 22.214.171.1240 on OS X 10.9.5. It's serving forty databases, one of which is served to the web via custom web publishing. Everything is running smoothly but the campus security auditor is picking up a vulnerability with the old version of OpenSSL running on OS X 10.9.5's Apache. I addressed this on a different, non-FMS Mac by disabling Apple's bundled Apache and using MacPorts to install Apache2.
How to do this on my FMS 11 Mac? Just getting MacPorts to install Apache2 is the first problem as port install apache2 fails with a conflicting ports message. I assume this is because the existing Apache is blocking installation of the new version but how to stop the existing one? I tried turning off web publishing in the FMS admin console but port install still fails with the familiar conflicting ports message. Even stopping the web server with Mark Banks' FMSControl didn't help.
I therefore have a couple of questions:
How do I stop the existing Apache so MacPorts will install Apache2? Once I have Apache2, how do I get FMS11 to use it instead of Apple's bundled Apache1? Thanks