none
Migrate Project Server 2010 files (with enterprise fields) to Project Online 2016 RRS feed

  • Question

  • Hi All

    I'm having trouble moving data from our existing PS 2010 system to PS 2016.

    We have a number of enterprise fields in PS2010 but when I save the plans to MPP files and then try and read them / import them to PS 2016 they seem to 'get lost'.

    The import process only appears to let me map local custom field to enterprise fields....not enterprise to enterprise...unless I am doing something wrong.

    Thursday, August 17, 2017 3:40 PM

All replies

  • Hey,

    This Link could Help you: https://technet.microsoft.com/en-us/library/dd207290(v=office.14).aspx

    Thursday, August 17, 2017 3:56 PM
  • Are you using the "Import Project to Enterprise" short cut on ribbon.  click on Icon and follow the five steps of the wizard.

    If it is not there then do this to add it to the ribbon.

    Open project and connect to PWA

    1) right click on ribbon on far right in right space

    2) select customize the Quick access tool bar.

    3) select all commands

    4) scroll down and select "import project to enterprise"

    5) OK

    Then open MPP file and run thru wizard


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Friday, August 18, 2017 3:39 AM
    Moderator
  • Thanks for the reply...that's what I'm doing already

    I first save the project plan out of Project 2010 along with the enterprise fields that we use to an MPP file.

    I then go to Project 2016 (connected to PWA), open the MPP file and run the wizard. I can map the resources out of the MPP to my enterprise resource pool on PS2016 however when it comes to mapping the fields on the task I can only see native fields when I drop down the Task Field combo (i.e. Cost1-10, Date1 to 10 etc.). I don't see the enterprise fields I thought I'd be able to see that I used in Project 2010.

    Friday, August 18, 2017 8:46 AM
  • Have the Customer Enterprise Task Fields been mapped on the new server?   Check with the PWA Admin and verify that this has happened.

    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Saturday, August 19, 2017 12:46 AM
    Moderator
  • ADT-Miller --

    The enterprise custom field values from your Project Server 2010 system will not be visible when you open the project for import into Project Online.  I know this to be true as I have been down this road multiple times at a former employer.  Here is what you will need to do:

    1. Launch Microsoft Project 2010 and connect to Project Server.
    2. Open an enterprise project.
    3. Create one corresponding LOCAL column for every ENTERPRISE column.
    4. Copy the information from each ENTERPRISE column into its corresponding LOCAL column.
    5. Save, close, and check in the project.

    You will need to do this for EVERY enterprise project in your Project Server 2010 system.  One way to speed up this process would be to write one or more macros in Project VBA to set up and populate the local columns.  That is what I did at my former employer, which saved lots of time.

    After doing this for each enterprise project, you will be able to import the project into Project Online.  Using the Import Project Wizard, you will be able to map the values from the LOCAL fields to their corresponding ENTERPRISE fields in Project Online.

    Hope this helps.


    Dale A. Howard [MVP]

    Saturday, August 19, 2017 10:21 PM
    Moderator