The format file contains the order and selection of the fields you want to export. You must enter or specify a format file to use with your export. This is an important step if your export data needs to match outside data in a prescribed format. For example, you would use a format file if you plan to import the data into an external system or back into MPM.
MPM comes with a set of standard format files that describe the order and fields for the most frequently used exports. If you plan to export this data, make changes, and then import that data back into MPM, you must use the standard format file for the data.
Format file names have the extension .FMT. The standard format files are described below:
ACTUAL.FMT is used for actuals data
BCWP.FMT is used for BCWP data
BE-MIL.FMT is used for milestone data being exported to Deltek
ESTIMATE.FMT is used for estimates data
MILESTON.FMT is used for milestones data
SCHEDULE.FMT is used for schedule data
WBS.FMT is used for WBS data
WEEKWBS.FMT is used for weekly WBS data
WEEKEOC.FMT is used for weekly EOC data
To select a format file, complete the following steps:
Click the Format File Name criteria box on the Export Conditioning window. The Criteria box will add two buttons, Browse and Field Mapping.
Click the Field Mapping button. MPM displays the Format File Name dialog box where you can select a format file.