Forum Discussion

Charles130123's avatar
Charles130123
Copper Contributor
Jan 13, 2023

Import Wizard to update fields in existing project

I am using the Import Wizard to update two fields in my existing project using the Unique ID as a key. The two fields are both Textxx fields. When I import, I get 

for every task and it either deletes all the start/finish/duration details (Yes) or just the duration and effort fields (no). I don't want MSP to touch these fields. 

 

What can I do?


Thanks

 

Charles

14 Replies

Sort By
  • John-project's avatar
    John-project
    Silver Contributor
    Jan 14, 2023
    Charles130123,
    First of all, what version of Project are you using?
    Are you attempting to Append or Merge the data?
    What are the two fields you are tying to update?
    Also, a screen shot of your import map would be useful.

    John
    • Charles130123's avatar
      Charles130123
      Copper Contributor
      Jan 14, 2023

      John-project 

       

      Thanks for replying. Answers below. Charles

      Version:

      Import Wizard:

       

       

      MS_Planner_ID is Text10

      MS_Planner_Completed_Off is Text16

       

      Grateful any help on this. An example of before and after is:

      Before:

      After (replying No to above dialog box)

       

       

      • Charles130123's avatar
        Charles130123
        Copper Contributor
        Jan 14, 2023
        Might be worth adding that the required fields are updated - I just don't want this side effect (obviously!). I am sure this has worked before (I have used it for two years) - and also not worked before. So I don't know what is different? Maybe a silent MS Project version upgrade?

        Charles

        Any suggestions gratefully received.

Resources