Importing actual hours from another system into Project Server 2007

M

Michael Santos

Hi,

I've been asked if it's possible to import actual hours from another system
into Project Server 2007. Our client has a database that stores this
information plus additional financial data and they'd like to import these
actual hours into PS. Also they'd like to export the Estimated Time To
Completion hours to a flat file. Can this be done? Any ideas on how to do
so?

Thanks!
 
R

Rod Gill

Hi,

Yes this can be done, but you need to export GUID or unique IDs to the other
system for people to enter time to. You cannot rely on users to type in task
names 100% accurately, so unless you have unique ID numbers to reference
tasks and resources, the code will never be able to update accurately.

There are two ways to update data in Project Server 2007:
1) Use the PSI interface, which requires professional developers who know C#
and web services etc.
2) Write code that controls the Project Application using automation. This
is best in VB.Net or in Project VBA.

Yes you can export to a text file or Excel using Project VBA.

--

Rod Gill
Project MVP

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

Colin

Rod - Do you have any example code that shows how to import hours into
Project Server 2007. Our group wants to use SAP for the time entry process,
but we want the actuals in Project Server as well for reporting purposes and
I don't want to force double entry.

Thanks,

Colin
 
R

Rod Gill

Search the Microsoft.com site. There is an add-in for Project Server to
integrate with SAP. Use that. It is vital that time sheets are pre-loaded
with project tasks, otherwise you will never be able to automate updating
schedules as people will never know, let alone type 100% accurately tasks
names in your schedule!

--

Rod Gill
Project MVP

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

Paul Piper

Hi Rod,

i can't see how to import data from a database into MS Project using VBA.
How is this done?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cap Actual Effort Hours for Cost Calculations 1
How to import multiple projects into 2007 in one go? 1
Import from 3rd party financial appl to Project Server 2003 2
Automate Actual Hours from Excel 2
Import actual hours from excel into task/resource/date actual work 5
project 2007 time Sheet 4
Problem importing project items into Server 2007 0
Actual hours - moved from reporting database to publish database 5

Top