0

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

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

Viewing 1 reply thread
  • Author
    Posts
    • 01/12/2016 at 2:50 pm #384317
      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!?

    • 01/16/2016 at 6:03 am #384624
      Sai Prasad
      Participant

      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

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.