You can enter mapping definitions for the Update operation in Sub-Item Mode. Update mapping involves selecting an MSP project field and matching it to a PPM category.
To map an MSP project field:
- On the MSP Project Fields tab, double-click in the MSP Project Fields column to select the MSP project field you would like to map to PPM.
- Double-click in the PPM Categories column to select the corresponding PPM category.
- Repeat this process for every MSP project field you want to map.
- To remove previously defined mapping, select the project field or a category from the list and click Remove.
To map an MSP task field at the item level:
- On the Task Fields (Item) tab, double-click in the Task Fields (Item) column to select the MSP task field you would like to map to PPM.
- Double-click in the PPM Categories column to select the corresponding PPM category.
- Repeat this process for every MSP task field you want to map.
- To remove previously defined mapping, select the project field or a category from the list and click Remove.
To map an MSP task Field at the sub-item level:
- On the Task Fields (Sub-Item) tab, double-click in the MSP Task Fields column to select the MSP task field you would like to map to PPM.
- Double-click in the PPM Categories column to select the corresponding PPM category.
- Repeat this process for every MSP task field you want to map.
- To remove previously defined mapping, select the project field or a category from the list and click Remove.
To map a reporting database:
If you want a breakdown of cost or work by time slices or by resource type, you need to map data in the MSP Reporting Database. In general, only task fields are available through the MSP Reporting Database.
- On the Reporting Database tab, double-click in the MSP Project Fields column to select the MSP project field you would like to map to PPM.
- Double-click in the Filter column.
- In the Filter dialog box, in the Period field, select the period that you want to summarize.
- In the Summarize field, specify the resources about whom summarized data is shown.
- Click OK.
- Repeat this process for every MS project field you want to map to the Reporting Database.
- To remove previously defined mapping, select the project field or a category from the list and click Remove.
- To edit a previously defined Filter, select the project field or category from the list and click Edit.
- When you are done specifying update mapping definitions, click Finish.