Page 1 of 2 12>
Topic Options
#204850 - 2012-04-21 05:44 PM Time-Clock KF App
ShaneEP Moderator Offline
MM club member
*****

Registered: 2002-11-29
Posts: 2127
Loc: Tulsa, OK
Hey guys, I just wanted to share my time-clock/payroll kixforms app. I’ve been creating this slowly over the past year or so, and it’s been in production for about 9 months. If anyone has time, try it out and make suggestions (Performance in particular.)

FILES:
OTC_42.kix The most recent version of the main app code.

(none of the below files are needed for the main portion of the program to function.)
clock/main/password.ico The icon files used in the app.
OTC_Updater.kix The most recent version of the app update code.
OTC_Updater.exe OTC_Updater.kix packaged using Kix2Exe.
OTC_42.exe All above files packaged into one client-side file using Kix2Exe.
Settings.ini A sample settings file. A new will be used if a directory other than the one containing this file is specified.
Test_User_times.ini A sample employee file. If this file is copied to the time directory you specify, Test User will show as an employee.

SETUP:
Simply run the otc_42.kix or otc_42.exe to start from scratch. I included an example settings.ini and a test_user_times.ini file if you want to use those. The administration password for the included settings.ini file is “password”. The password for Test User is "1236".

It will prompt you for the time directory on first run (a server share in our case) which will be written to HKCU\Software\OTC. This saved directory is the folder that the time files and settings file will be created in.

Also, if you place a file called otc.exe in this directory, the client will compare the version against itself on startup and prompt to update if necessary. If yes, then it will run otc_updater.exe. This is how I avoid having to manually update the app on all the clients every time I make a change.

It does include an InstallKixForms() function in the main app, but I have REMed it out so as to not interfere with your setups.


Attachments
otc.zip (133 downloads)
Description:




Edited by ShaneEP (2012-04-21 06:51 PM)

Top
#204851 - 2012-04-21 05:44 PM Re: Time-Clock KF App [Re: ShaneEP]
ShaneEP Moderator Offline
MM club member
*****

Registered: 2002-11-29
Posts: 2127
Loc: Tulsa, OK
be gentle... ;\)

Some screen shots below...


Attachments
275.jpg
Description: Main Form

276.jpg
Description: Payroll calculations

277.jpg
Description: Time entry mods

278.jpg
Description: Time entry report




Edited by ShaneEP (2012-04-21 06:53 PM)

Top
#204852 - 2012-04-21 05:45 PM Re: Time-Clock KF App [Re: ShaneEP]
Allen Administrator Online   shocked
KiX Supporter
*****

Registered: 2003-04-19
Posts: 4567
Loc: USA
How about some screen shots? Thanks for sharing.
Top
#204853 - 2012-04-21 05:53 PM Re: Time-Clock KF App [Re: Allen]
ShaneEP Moderator Offline
MM club member
*****

Registered: 2002-11-29
Posts: 2127
Loc: Tulsa, OK
Oops...If youve downloaded it already and intend to run it, make sure to also REM out the UninstallKixforms() line.
Top
#204854 - 2012-04-21 05:58 PM Re: Time-Clock KF App [Re: ShaneEP]
Lonkero Administrator Offline
KiX Master Guru
*****

Registered: 2001-06-05
Posts: 22346
Loc: OK
download what?
_________________________
!

download KiXnet

Top
#204855 - 2012-04-21 06:17 PM Re: Time-Clock KF App [Re: Lonkero]
ShaneEP Moderator Offline
MM club member
*****

Registered: 2002-11-29
Posts: 2127
Loc: Tulsa, OK
Ok now it should be fixed. Lonk, I removed it for a sec while I fixed the kixforms install part. Should be available again now.
Top
#204856 - 2012-04-21 06:21 PM Re: Time-Clock KF App [Re: ShaneEP]
Lonkero Administrator Offline
KiX Master Guru
*****

Registered: 2001-06-05
Posts: 22346
Loc: OK
but the download doesn't work now...
can you try to re-attach it?
_________________________
!

download KiXnet

Top
#204857 - 2012-04-21 06:37 PM Re: Time-Clock KF App [Re: Lonkero]
ShaneEP Moderator Offline
MM club member
*****

Registered: 2002-11-29
Posts: 2127
Loc: Tulsa, OK
No matter what I do now, the zip doesnt work when I attach it. I even tried to create a new zip file.

Is there a size limitation on the file attachments? I removed the .exe's from the zip which dropped it in size and now it works fine.


Edited by ShaneEP (2012-04-21 06:51 PM)

Top
#204858 - 2012-04-21 06:57 PM Re: Time-Clock KF App [Re: ShaneEP]
Lonkero Administrator Offline
KiX Master Guru
*****

Registered: 2001-06-05
Posts: 22346
Loc: OK
hmm... might be the fact that there are exe's in the file.
_________________________
!

download KiXnet

Top
#204859 - 2012-04-21 07:01 PM Re: Time-Clock KF App [Re: Lonkero]
ShaneEP Moderator Offline
MM club member
*****

Registered: 2002-11-29
Posts: 2127
Loc: Tulsa, OK
Ahh ok that makes more sense. It should be working now then.
Top
#204862 - 2012-04-21 07:23 PM Re: Time-Clock KF App [Re: Lonkero]
Lonkero Administrator Offline
KiX Master Guru
*****

Registered: 2001-06-05
Posts: 22346
Loc: OK
why ytd is empty?
_________________________
!

download KiXnet

Top
#204863 - 2012-04-21 07:36 PM Re: Time-Clock KF App [Re: Lonkero]
Allen Administrator Online   shocked
KiX Supporter
*****

Registered: 2003-04-19
Posts: 4567
Loc: USA
Looks good Shane... never ceases to amaze me what we can do with kix.
Top
#204864 - 2012-04-21 07:51 PM Re: Time-Clock KF App [Re: Allen]
ShaneEP Moderator Offline
MM club member
*****

Registered: 2002-11-29
Posts: 2127
Loc: Tulsa, OK
I just deleted it since I modified an actual employees file for the test user file. Didnt want to expose anyone's actual pay lol. The paycheck section adds to the YTD amounts when a check is actually printed.
Top
#204865 - 2012-04-21 07:54 PM Re: Time-Clock KF App [Re: ShaneEP]
ShaneEP Moderator Offline
MM club member
*****

Registered: 2002-11-29
Posts: 2127
Loc: Tulsa, OK
The main performance hits occur when times are modified as it takes a bit for all the time entries of an employee that clock in/out a lot (smokers) to get populated. Also the printing is not as smooth as I would like. The only method I could come up with to tell when a person actually printed something was to Pause the print spooler, check for the existence of the print job and then restart. Otherwise there was no way of telling if someone went to print and then just hit cancel. Only wanted to update YTD and stuff if it was indeed printed.
Top
#204866 - 2012-04-21 07:56 PM Re: Time-Clock KF App [Re: ShaneEP]
ShaneEP Moderator Offline
MM club member
*****

Registered: 2002-11-29
Posts: 2127
Loc: Tulsa, OK
And thanks Allen. I had to overcome a lot of challenges to get all the functionality I wanted. But it actually works pretty well now.

Would also like to modify the tax calculations to include other states other than OK, but it seems a lot of the states use different formulas, so it would take a lot of time to hit all of them.

Top
#204867 - 2012-04-21 08:09 PM Re: Time-Clock KF App [Re: ShaneEP]
Allen Administrator Online   shocked
KiX Supporter
*****

Registered: 2003-04-19
Posts: 4567
Loc: USA
You just reminded me of a bug we found when you where trying to print using the Internet Explorer Object...

http://www.kixtart.org/forums/ubbthreads.php?ubb=showflat&Number=201671#Post201671

Obviously this is not a Five Alarm bug, but I would be interested in Ruud's comments on this. I think I'll post a note in the beta section.

Top
#204869 - 2012-04-21 08:20 PM Re: Time-Clock KF App [Re: ShaneEP]
Lonkero Administrator Offline
KiX Master Guru
*****

Registered: 2001-06-05
Posts: 22346
Loc: OK
what you mean person printed something?
you mean in this program someone hits print?
and you wanna know if they did print or not?

I guess I need to actually look at the code ;\)
_________________________
!

download KiXnet

Top
#204870 - 2012-04-21 08:27 PM Re: Time-Clock KF App [Re: Lonkero]
Lonkero Administrator Offline
KiX Master Guru
*****

Registered: 2001-06-05
Posts: 22346
Loc: OK
get hours flickers like craazy. what's up with that?
_________________________
!

download KiXnet

Top
#204871 - 2012-04-21 08:37 PM Re: Time-Clock KF App [Re: Lonkero]
Lonkero Administrator Offline
KiX Master Guru
*****

Registered: 2001-06-05
Posts: 22346
Loc: OK
so, do you do anything with the info?
if printed or cancelled?
_________________________
!

download KiXnet

Top
#204872 - 2012-04-21 09:01 PM Re: Time-Clock KF App [Re: Lonkero]
ShaneEP Moderator Offline
MM club member
*****

Registered: 2002-11-29
Posts: 2127
Loc: Tulsa, OK
Well, I know when the person clicks the print button in the app, but dont know if the person then clicks Cancel on the print dialogue box. Dont want to update the YTD numbers, or close a form if someone clicks print, then Cancel.
Top
Page 1 of 2 12>


Moderator:  Arend_, Allen, Jochen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Mart 
Hop to:
Shout Box

Who's Online
1 registered (Allen) and 483 anonymous users online.
Newest Members
batdk82, StuTheCoder, M_Moore, BeeEm, min_seow
17885 Registered Users

Generated in 0.077 seconds in which 0.026 seconds were spent on a total of 16 queries. Zlib compression enabled.

Search the board with:
superb Board Search
or try with google:
Google
Web kixtart.org