Loading labor hours from an external file

T

Tom

We are using a system other than Project Server to capture labor hours. This
system outputs a flat file that I was hoping to batch load into the Project
2003 database using SQL commands. Besides having to learn which SQL tables
to use, my general question has to do with loading data at the detailed task
level vs the summary level. We don't capture time down at the individual
task level. We capture more on a cost account or summary task level. Thus,
multiple people may charge a single summary task.

The question really is if I load the hours at the summary task level, does
Project spread the hours evenly across the resources assigned to the tasks
below or lump them into just one of the assigned resources? Or worse, do I
have to specifically tell Project in my program which resource to aware the
hours?

I understand that the PWA has a nice interface which allows users to enter
their weekly timesheets, but as a government contractor this method is not
acceptable. We have another system which already meets government reporting
standards and must be used.
 
G

Gary L. Chefetz [MVP]

Tom:

You'll be happy to know that the Project Server 2007 time sheet system is
auditable, and therefore can be used as part of a DCAA-compliant system.
With that said, it's far from a fully-baked solution. I'm not sure that what
you're trying to do makes much sense. You certainly can't drive project
progress when you're not collecting work at the same level of detail that
your projects are modeled at. So what do you gain by putting this
information into the Project Plan? What are you trying accomplish?

If you have specific development questions, ask them at
microsoft.public.project.developer. Be sure to state what version of the
software you're using in your post. I can't find any hints in the body of
your post.

--


Gary L. Chefetz, MVP
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
For Project Server Books: http://www.projectserverbooks.com
For Project Server Training: http://www.projectservertraining.com
For Project FAQS: http://www.mvps.org/project
 
Top