Importing timesheet hours to database? Consultant?

E

Ernie

Like Abraham, I too need to get actual hours from our
corporate timesheet system to MS Project. This is a major
evaluation factor in adopting MS project for our 100+
projects. Is there a DB script or something for this? Is
there a consulting group who does this?
 
G

Gérard Ducouret

Hello Ernie,

It's possible to do that with VBA : I justed finished such an application.
But the actual data were well organized in an Excel file where the Unique ID
of each assignment could be reach easily.
So the question is : what kind of file your corporate timesheet system can
generate, and how the data are organized.

Gérard Ducouret
 
S

Scott McClure

Gérard,

Did you see my post regarding how MSP handles "overtime" if it is not
expecting it? We would like to do this as well and actually have some VB
code that reads it directly from our SQL-based ERP system (The tasks are
tied to steps on a work order -- no problem there).

(rant) The problem is we don't trust MSP to leave the numbers alone. During
manual entry it will change the numbers entered (even though they are
"actuals." That is, as best we can determine, if the resource doesn't have
as many hours available as entered, it will move the "extra" time to the
future. It has also simply thrown time away -- we've never found where it
might have gone. The second time it is entered, it leaves it alone.

Do you not have this problem?

Scott McClure
 
G

Gérard Ducouret

Scott,
I didn't have this problem. I had a look at your previous post (15/12/03)
but I don't have sufficient information to try a simulation of your problem.
For ex. when you say "Entered: 5.5 hours " is it
- at the assignment level,
- at the task level
- in the time sheet or in a column of the Table

Gérard Ducouret
 
S

Scott McClure

Sorry -- at the task level. We are using the Task Usage (modified to
include actual work) as the entry form. So, "entered 5.5" means entered 5.5
hours on the task level and allow PS to spread between resources if there is
more than one assigned.

Does that help?

Thanks,
Scott
 
Top