Loading...
Quick Links

Importing actual hours fm Excel into Proj Pro 2010

Home Forums Discussion Importing actual hours fm Excel into Proj Pro 2010

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #5059 Reply
    CommunityCommunity
    Keymaster

    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.

    #6649 Reply
    CommunityCommunity
    Keymaster

    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

    #6651 Reply
    CommunityCommunity
    Keymaster

    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.

    #6652 Reply
    CommunityCommunity
    Keymaster

    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.

    #10392 Reply
    CommunityCommunity
    Keymaster

    JSON

    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).

    More ideas?

    Thanks… Jess

    #10393 Reply
    CommunityCommunity
    Keymaster

    Ellen

    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).

    Jess

    #10394 Reply
    CommunityCommunity
    Keymaster

    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.

    http://msdn.microsoft.com/en-us/library/ee767706.aspx

    Note this bullet for “What the PSI Does”:

    • Integrate with project accounting systems   Capture the resource costs and expenses associated with projects to feed financial and billing systems and for budget comparison purposes. Synchronize tasks, resources, and assignments between the systems. Capture timesheet data in one system to feed the other (which timesheet is used depends on needs of the organization or of individual projects).

      Jim

Viewing 7 posts - 1 through 7 (of 7 total)
Reply To: Importing actual hours fm Excel into Proj Pro 2010
Your information: