Forum Discussion
What columns are mapped when importing .MPP file into Project for the web?
Hi all,
I was wondering if anyone had a list of what fields get imported into Project for the Web(P4W) when importing an MPP file. I've seen the list of what does not get imported in, but it's not quite what I'm looking for.
There are obvious ones like notes, name, finish etc, but are there any fields in Project desktop I can fill in that will map to either Buckets or Labels in P4W? I know it's a stretch, but if it's possible to import into a custom text column that would be amazing (but I'm not holding my breathe.)
Essentially currently we have excel sheets with 300+ tasks each that have been exported from another system. These tasks need to be input into P4W, inclusive of outline level/correct summary task order and notes - I have resolved this by importing the Excel file into Project Desktop to keep the correct formatting, and then using the 'import project as plan' function to put the MPP into P4W.
It would be great if in this import process I could also have either buckets or Labels(or both!) mapped, as they currently have to be manually added a once the import is complete.
Any help would be greatly appreciated!
Hello PewPewProject ,
You've probably seen this list I guess: https://support.microsoft.com/en-gb/office/move-your-project-from-project-desktop-to-project-for-the-web-143ab391-002e-451a-aedb-3b6fa1f6ab8b#bkmk_featuresthatdontmigrate
There are no custom fields in MS Project that can be imported / mapped to buckets / labels etc. as MS Project is not aware of buckets / labels and the import mapping is hard coded by Microsoft. Up to 10 custom fields from the mpp file will be be imported (if you have more than 10, you get a window to select which 10).
If you want to code something yourself for the import, there is the schedule API: https://learn.microsoft.com/en-us/dynamics365/project-operations/project-management/schedule-api-preview
I hope that helps
Paul
Hello PewPewProject ,
You've probably seen this list I guess: https://support.microsoft.com/en-gb/office/move-your-project-from-project-desktop-to-project-for-the-web-143ab391-002e-451a-aedb-3b6fa1f6ab8b#bkmk_featuresthatdontmigrate
There are no custom fields in MS Project that can be imported / mapped to buckets / labels etc. as MS Project is not aware of buckets / labels and the import mapping is hard coded by Microsoft. Up to 10 custom fields from the mpp file will be be imported (if you have more than 10, you get a window to select which 10).
If you want to code something yourself for the import, there is the schedule API: https://learn.microsoft.com/en-us/dynamics365/project-operations/project-management/schedule-api-preview
I hope that helps
Paul
Thanks Paul_Mather , that was my gut feeling but thought it best to check anyway!
"Up to 10 custom fields from the mpp file will be imported (if you have more than 10, you get a window to select which 10)."
I was not aware of custom fields being able to map over, I assume this is limited to custom fields like text, true/false etc? would you happen to know if the fields need to be enterprise fields or not?
thank you again so much!
Hello PewPewProject ,
I think you'll find it is only local custom fields not enterprise custom fields but I've not tried it for a while.
Paul
