Write the daily time for a ressource worked on a task

[mm10dev]

hi,

i have a small database where my employees write down their work times
on tasks. i can read the task informations from a project file. but is
it possible, to write to the project file the work times of the
ressources via the project object model?

thank
y. bogazci

 

[Rod Gill]

Hi,

Yes it is, but it will only be reliable and useful if your database has
Unique IDs for Tasks and Resources. If you rely on Task names to be
accurately typed in by people you will never reliably match tasks in the db
with tasks in Project!

At the beginning of the week export current tasks to the db along with their
Unique IDs then import data back with actual hours at the end of the week. I
have done this for a number of clients, but it only works when you have this
closed loop.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[Jan De Messemaeker]

Hi,

Yes, no problem.
Look for the TimeScaleValues class and the Timescaledata object.
The problem is rathe rto find the right task/resource (=assignment)
combination.
This is generally done by exporting to your other DB the UniqueID of the
assignment.
Hope this helps,