This video demonstrates how to use the Data Import feature. Duration 9 min.
The Import Data feature simultaneously creates an entity and imports its associated data. All entities except tasks follow the same basic steps for importing and updating data. See Task Import/Export for instructions for importing and exporting tasks; tasks cannot be updated.
PPM Pro supports importing from the latest two versions of MS Excel.
Before you can import/create an entity, you must prepare a .xlsx file with the data to import. There are two flavors of import file - one for entity creation, and one for updating an existing template. Note that carriage returns in spreadsheet cells are not supported.
- Navigate to Admin/Data Import.
- Select the entity for which you are creating the import file.
- Click the appropriate button - either Generate Import File for New or Generate Import File for Update.
- The Excel file will open. Refer to Import Notes below as you enter data
- Save the spreadsheet.
Note that entity IDs are located on Admin/Web Services API; instance ID can be found by using the ID Inspector.
Note that carriage returns in spreadsheet cells are not supported.
Hint: The best way to determine what fields and formats are required for any particular entity is to initiate the import using an empty spreadsheet. The second page of the wizard is the mapping screen, which lists all the fields in the spreadsheet and indicates which are required (asterisk * next to field name), as well as formats such as ID vs Last, First, when applicable. For example, if you want to import assets, select Assets from Admin/Data Import and then click the Generate Template for New. Save the resulting .xls file. Now click the Import button. In Step 1 of 2, select the xls file you just created. Leave all the other settings as they are. Click Next. Step 2 of 2, the mapping screen, appears. Gather the details you need to fill out your import file (cancel the current import when you are done).
For all entities except tasks, PPM Pro accepts data in an .xlsx file from Microsoft Excel. Please note the following:
|Group Members||If you use the import file generator, please ignore the Permission Profile field.|
% Complete Method
Can edit Calendar
Capacity Start Date
|Tasks||Tasks are created by importing .mpp (Microsoft Project) files; tasks can be exported to XML. See Task Import/Export for more information.|
Note: It is strongly recommended that you use the Create Import File feature to prepare the data you will be importing. Note that carriage returns in spreadsheet cells are not supported.
- Navigate to Admin/Data Import.
- Select the entity you wish to create/update and click the Import button.
- You will see a modal similar to the one below. This example uses the Project entity; there might be additional options for other entities, as shown in the table below.
- Select the type of import (new or update existing) by selecting the appropriate radio button.
- Browse to the desired .xlsx file located on your computer or network resource. The selected .xlsx file will be uploaded to PPM Pro (this may take a few minutes if the file is particularly large).
- PPM Pro-generated import files will always have a header row, so "File includes a header row" will be checked if you used the PPM Pro facility. Set this property accordingly if you manually created a header-less import file and you want to import the data in the first row of the file.
- Choose the technique you wish to use to map fields. The default is "Map file fields to entity fields that have exactly the same name". If you wish to loosen up that requirement, choose "Map file fields to entity fields that have similar titles". If you wish to manually map all fields, choose "Manually map fields".
- Additional options:
For some entities there are additional options; if you are not importing an entity listed in the table below, go to step 6.
Choose a default Department, Category, and Status, if desired. The default values are used if the column is not included in the spreadsheet, or if it is included but the values are null or invalid. If no default values are selected and no matching values are found in PPM Pro, the project will not be imported.
Select a default Owner, Enterprise, Division and Status if desired. The default values are used if the column is not included in the spreadsheet, or if it is included but the values are null or invalid. If no default values are selected and no matching values are found in PPM Pro, the Department will not be imported.
Select the entity for which you are importing team members. If you wish to import team members for multiple entities, then select n/a and enter the parent entity type ID for each set of team members in the .xlsx file. Click here for a list of parent entity IDs.
- Click Next.
- According to the technique you chose, either accept the automatic matching or select which columns in the .xlsx file will be imported into which data fields in PPM Pro.
- Click Save.
All entities except tasks can be updated. You update an entity using the same technique as importing an entity. The main difference is that your spreadsheet should only contain the fields you want to update. Note that carriage returns in spreadsheet cells are not supported.
For example, imagine that you want to update project data. You want to build a spreadsheet with Project ID, Project Status, Project Target Date, Project Complete Date, and a UDF called Project Total Spend Estimate. To create the spreadsheet, you can run an Org level list report on Projects that have the same fields as listed above, then export the report to excel. Then you would update the spreadsheet with new Status, Target Dates, Complete Dates where applicable, and new Total Spend estimates. Now you can use the spreadsheet to perform the update - only the fields you want to update are included in the file. Follow the same instructions for importing data, but choose Update from the Function dropdown list.