Home › Forums › Microsoft Project Discussion Forum › Importing actual hours fm Excel into Proj Pro 2010
Tagged: Microsoft Excel, Microsoft Project 2010
I cannot import actual hours for resources from an Excel Spreadsheet. Trying to use the WBS as the MERGE key so the hours are applied to the right task. No data is coming in. Even tried using the Resource Name and got no data.
You are having problems because of the way the database is set up. You can’t expect assignment data to flow through the imported task data. The only way of doing this is custom VBA code and it is tricky to make it work.
Ellen Lehnert, MVP
You will need to hav a 3 worksheet workbook, one for tasks, one for resources and one for assignments. Try exporting a project with tasks, resources and assignments to see the structure. It’s better not to import dates as these set constraints against tasks which is counter-productive.
This will take customized programming for you to get this accomplished. MSPS does not standardly provide interfaces to do this sort of thing. I have several clients that use MSPS as the time collection and then export the information to the time tracking system. Many are having people enter time twice. Keep in mind that time for payroll is different than time that is progress on tasks. You might do best with having people put in time twice.
Exported as you suggested. Fields were UID, ID, Name,Work, Actual Work (in the appropriate worksheets).
Then changed actual hours on 1 resource in the resource sheet and imported. Used UID as merge field, but no hours registered in project (Project file open, used merge data option).
We expect to have Server 2010 shortly. When we do, could we flow the excel data into timecards and then process them?
Is there any way to use SharePoint to get excel hrs data imported?
We use JAMIS/eTimecard for capturing hours and do not plan to move to Project timecards, so we need an automated way to move data into project (2010 Pro).
Definitely would require custom coding via the PSI (Project Server Interface), but you should be able to pull or feed Project Server 2010 with Timesheet data.
Note this bullet for “What the PSI Does”: