Re: Please comment my thoughts -- Need help with application for controlling Time attendance...
Re: Please comment my thoughts -- Need help with application for controlling Time attendance...
- Subject: Re: Please comment my thoughts -- Need help with application for controlling Time attendance...
- From: Bernardo Hoehl <email@hidden>
- Date: Tue, 5 Jul 2005 16:32:24 -0300
Hi folks,
Thanks to you all who replied to my original post. You all have been
very helpfull.
I didn't initially consider looking for a ready made solution, didn't
know they even existed, but after taking a look at them, I could learn
at least some functions a good app should have, and what it shouldn't
have ---> a few of them are some real bad examples of what I shouldn't
do, and you bet: we learn from good "bad examples".
My employees are a few very humble guys, and have in past done some
very childish things (such as turning back my mechanical clock's
pointers).
My guess is that using an app such as the one "from the dark side",
concerns me, since it can be opened and edited in a very simple manner.
Maybe writing the files as just text to disk with a dot before its name
(making them inivisible from finder), can do a good trick. You can't
see it, it doens't exist to a certain extent.
A good thing I imagine is that my app could email me in the background
regularly, maybe twice a day, telling me which employees have come to
work, and in case someone is "punching the card" for someone else, I
could notice right away.
A god preferences pane is important, setting up my "normal working
hours", so that my app can decide when overtime occurs. (rarely
happens).
My plan is also to implement lines in my main log file like
"application started at so and so", and "application shut down at so
and so", and as the applications is launched, try to read the main log
file backwards, and in case we don't find first an "application shut
down" line, we can execute an "application did not close properly"
routine .
Another concern is regarding the employee who might leave the company
without "punching" his card, simply forget to do so, it is very common,
I have to make sure my application is able to detect this event,
without accounting this as overtime work. Any thoughts or suggestions?
Thanks.
Bernardo
=====================
On 05 Jul, 2005, at 2:47 PM, Doug McNutt wrote:
At 01:02 -0300 7/5/05, Bernardo Hoehl wrote:
I have my own small company
I will assume that means the task is for employees of your company.
For hundreds of employees real databases are the way to go.
, and have been trying to learn Applescript for the past 18 months.
You're about 1/4 of the way to becoming partially proficient. High
school Latin was easier.
Spreadsheets are good. They can handle times as numbers which one can
subtract, they format numbers nicely as dates and as currency, they
have pretty good macro languages. It's unfortunate that the only
excellent one is from the dark side. They do do some things right in
Redmond.
When you create your log file think about reading it back directly
into MS Excel. If you put tab characters between "columns" and give
the file a *.tsv extension Excel will open it directly including
conversion of dates "July 5, 2005 10:23" into time sequence numbers.
Format each column with things Excel will recognize: digits and
decimal points allowed for numbers, xx:xx:xx for a time and the like.
You can easily come up with formats and macros that will make the
file readable to the uninitiated while preserving the capability to
sort and do arithmetic.
--
Applescript syntax is like English spelling:
Roughly, but not thoroughly, thought through.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
email@hidden
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden