Loading...
Quick Links

I am trying to import % complete data with a merge key of unique_ID from xls…

Home Forums Discussion I am trying to import % complete data with a merge key of unique_ID from xls…

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #384317 Reply
    graham henderson
    Guest

    I am trying to merge import % complete data with a merge key of unique_ID from xls to an mpp project
    there are no error msgs but no % complete data is imported!?

    #384624 Reply
    Sai PrasadSai Prasad
    Participant
    • Community Leader
    • Forum Pro

    Hi,

    I am tested the below approach in Project 2010 and hope it applies to Project 2013 too
    1. Exported task details that includes Unique Id and % Complete to Excel workbook
    2. Updated the % complete in Excel workbook
    3. Made sure default task mode is Auto Schedule, otherwise during merge Project is unable to calculate and update Actual Start, Actual Finish and other tracking fields
    4. Import the Excel workbook using Merge option.
    5. Since you have exported and importing the same file, the field mapping will be preset
    6. Complete the wizard, and you should see % complete updated in Project file

    Regards
    Sai

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: I am trying to import % complete data with a merge key of unique_ID from xls…
Your information:




− 1 = 3