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...
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
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- Charles,
No problem, I fully understand your need to protect sensitive information. I can send you a macro that will remove all sensitive information from your Project file. It reduces the file to a generic structure. Let me know if you want it. I don't have anything for Excel files, you'll have to desensitize it yourself.
Once you have something to send, send it to me at the address below. Note, I need both your Project and Excel files.
John
jmacprojataticlouddotdotcom
(remove obvious redundancies
