Online timesheets with ASP??? 1

[chmilz]

Hello all,

I am a webmaster for an IT consulting company. Currently the do their time sheets in an excel spreadsheet and email them to their accounting dept. I would like to set up a Members Only section on their website where they would be able to go and enter all of their time sheet information ON SITE (right from the client site). I was wondering if it was possible to do this using ASP. Any ideas would be greatly appreciated. Thanks in advance!

Cheers,

Chmilz

 

[chmilz]

Hello again all,

I has just talked to a member of the company and this is what he wants. He wants employees to be able to enter their timesheet information on line by way of a form (easy enough) then he wants that information sent to a table in an SQL Database on the company server. Can THIS be done using ASP?? Thanks for your ideas and replies in advance!

Cheers,

Chmilz

 

[travisbrown]

yes, quite easily.

 

[Tarwn]

Yes this can be, and has been, done. If you do a search through this forum for timeclock or timesheet you will see a set of posts not to long ago concerning this very topic. I actually conversed at quite length with someone in the process of doing the same type of development as you are looking at. You will also find a rather lengthy description of a system I was designing a while ago before getting side tracked, if you have any questions concerning that set of posts, feel free to ask.
-Tarwn ------------ My Little Dictionary ---------
Extreme Programming - (1)Trying to code before my second cup of coffee. (2) While(1){ Ctrl+C; Ctrl+V; }
FAQ - Web-ese for "Forget Asking Questions, I am to busy"

 

[Tarwn]

Here is a bit of starter work. One you will need a database. Depending on how you plan to store the values your design will differ from the one I am about to propose.
User_List
*user_id - autonumber or incremental integer
user_name - varchar or text
user_pass - varchar or text
full_name - varchar or text
user_level - small int

JobList
*job_id - autonumber or incremental integer
job_name - varchar or text
job_desc - varchar or text

Timecard
*timecard_id - autonumber or incremental integer
entry_date - date/time
entry_time - decimal
user_id - integer, foreign key to UserList
job_id - integer, foreign key to JobList

Stars denote primary or unique keys. The idea behind this model is that users will login, having their username and opassword verified against the UserList table. After verification they should be able to add time to their card with a simple form or view hours already in the database. Time is added by specifying a date and number of hours as well as a job (supplied by a dropdown filled from the JobList table). That information is placed into the Timecard db along with their user_id(obtained and set during login verification) and the job_id (the values for the options in job dropdown). At some point someone is going to want to get a report from this thing, so I added the user_level attribute to the UserList table which will allow you to set a level, like 0 for common user, 1 for administrative. You should have an option that appears only for administrative people (or financial) to add jobs, edit jobs, view employees hours, etc.
If you have any further questions, don't hesitate to ask. I have some experience with these types of systems, my personal one allows for timeclock entry (time in/out), single hour entry (like above), dual hour entry(actual vs reported), etc, has user customizable reports from calendar views to Access-Like listings, job grouping, 3 differant sets of menus for independant contracting, supervisor, and supervisee. I have pretty much been through the works for timecards, so I should be able to offer some advice if needed.
Hope the above helped to start you off,
-Tarwn ------------ My Little Dictionary ---------
Extreme Programming - (1)Trying to code before my second cup of coffee. (2) While(1){ Ctrl+C; Ctrl+V; }
FAQ - Web-ese for "Forget Asking Questions, I am to busy"