Forum Discussion
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...
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
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
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)
- 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.Charles,
Thanks for the plethora of screen shots. Doing a quick overview, nothing pops out. I emulated your file and did a merged import. As expected everything works fine for me, only the custom text field was updated, nothing else.Project test file:
Excel sheet:
Import map:
Final result in Project:
Would you be willing to share your Project and Excel files with me? It would make troubleshooting a lot easier. If you can share I'll give you my address.
John- Yes, but I will have to redact most of the material. Let me see if I can reduce the example to something I can share which isn't Official Sensitive. I am sure this is something I am doing different and that exercise might expose what it is ...
Charles