How can I report User Login Logout Times ?

H

Heiko

Hi

I had set up a Login-Logout Timesheet (Gantt Chart) in Excel and would
like to do the same in Project.
How can I do this ?

ie. it should show between 0-500 users, and when the user logged into
our program.

eg.:
User1 logged in from 10h35 to 11h05, then from 14h30 to 14h45
User2 logged in from 18h00 to 22h14
User5 ...
....

Is there a template, a sample, a plugin, or a macro that I can look at ?

Thanx

Heiko Risser
 
H

Heiko

Heiko said:
I had set up a Login-Logout Timesheet (Gantt Chart) in Excel and would
like to do the same in Project.
How can I do this ?

ie. it should show between 0-500 users, and when the user logged into
our program.

eg.:
User1 logged in from 10h35 to 11h05, then from 14h30 to 14h45
User2 logged in from 18h00 to 22h14
User5 ...
...

Is there a template, a sample, a plugin, or a macro that I can look at ?
Click to expand...

The above is the basic outline of what is required.

Additionally I would like to load login/logout information from a sql
database, or from a text file into project, and this would then graph
login/logout times for all the users.

(
As mentioned, I had similar functionality in Excel (with the help of a
plugin to do gantt charts), but I was a bit limited on the graphin and
data manipulation side of things.
Hoping that I can get more flexibility from MS Project

ie. Filter Users, Zoom in and out, display different time ranges,
sorting ...
ie. controlling more from the user interface instead of programming them.)

Thanx
Heiko Risser
 
J

JackD

Sounds like it would work.
You will have some trouble when a shift crosses midnight as project treats
each day as a separate day.
I'm sorry I don't have any code to automate the import of the data, but it
should be pretty simple if the data in your database is organized correctly.

Things to watch out for are: making sure that the user name is not repeated.
That timespans which go across midnight are broken in two.
That you provide enough additional information for sorting and categorizing.
You can just dump this data into text fields if you like and filter, sort,
group based on them.
 
Top