Use these procedure to map MS Project and save the MSP file (mpp, mpd, xml) as a csv file format to be used for importing schedule data into PM Compass. You can import the csv file when you have Primavera/Other selected as the scheduling tool on the Projects Schedule Integration tab.
This topic includes steps for the following tasks:
For more information, see Schedule Import Overview.
To Export and Map Project Information:
In Microsoft Project, click File ยป Save As.
On the Save As type dialog box, select the file format that you want to export data to.
On the File name dialog box, type a name for the exported file.
Click Save.
Follow the instructions in the Export Wizard to export the data that you want into the proper fields of the destination file.
When the wizard prompts you to create a new map or use an existing one, do one of the following:
Click New map to create a new export map from scratch.
Click Use existing map to use a default map or a map that you previously defined and saved.
On the Task Mapping, Resource Mapping, or Assignment Mapping page of the Export Wizard, verify or edit the mapping assumptions of Project, or create a new map:
To export specific project information, type or select the field that you want in the From column, and then press ENTER.
To add all task, resource, or assignment fields in your project to the export map, click Add All.
To add all task or resource fields of a specific table to the export map, click Base on Table. Click the table you want to use, and then click OK.
To remove all task, resource, or assignment fields from an export map, click Clear All.
To insert a new field above another field, click a field in the From column, and then click Insert Row.
To insert a new field above another field, click a field in the From column, and then click Insert Row.
To delete a field, click it in the From column, and then click Delete Row. To change the name of the field in the destination file, click the field in the To column, and then type a new name.
To export certain tasks or resources only, click the filter that you want in the Export filter box.
If you want to change the order of the fields in the destination file, click a field in the To column, and then click the Move buttons to move the field to the position that you want.
On the last page of the Export Wizard, click Finish to export your data.
You can export only an entire project to XML format. Project maps the data automatically, without the Export Wizard. Also, to minimize the file size, fields that contain null values are not included in the exported XML file.
On the Task Mapping, Resource Mapping, or Assignment Mapping page of the Export Wizard, under Preview, you can review the layout of the export map.
You can save a new or edited export map if you want to use it again. On the last page of the Export Wizard, click Save Map, and then type a name in the Map name box. The new map will be added to the list of predefined maps.
You can use an existing export map from another project if the map is available in the global file. By using the Organizer, you can copy an export map from a project file to the global file.
When you create an export map to save data to either CSV file format or TXT file format and you set the text delimiter, the delimiter, not the file extension, controls the file type. For example, if you save to a file named Myproject.csv but you specified a tab delimiter in the map, the CSV file will have tabs instead of commas, even though the file extension indicates commas.
You can import information into Project by using any entered field from another product's file format, such as Microsoft Office Excel, Microsoft Office Access, Extensible Markup Language (XML), comma-separated values (CSV), or tab delimited text format.
To Import Project Information:
Click the File tab, and then click Browse.
On the Files of type dialog box, click the file type that you want to import data from.
Navigate to the folder that contains the file you want to import, and then select the file in the file list.
Click Open.
Follow the instructions in the Import Wizard to import the data that you want into the proper Project fields.
On the Task Mapping, Resource Mapping, or Assignment Mapping page of the Import Wizard, verify or edit the mapping assumptions of Project:
To import the data from a field in the source file to a different Project field, click the field in the To column, select a new field, and then press ENTER.
To change the name of a field in the destination file, click the field in the To column, and then type a new name.
To delete a field, click it in the From column, and then click Delete Row.
To insert a new field above another field, click a field in the From column, and then click Insert Row.
To remove all task, resource, or assignment fields from an import map, click Clear All.
To add all task, resource, or assignment fields of the destination file to the import map, click Add All.
TIP: On the Task Mapping, Resource Mapping, or Assignment Mapping page of the Import Wizard, under Preview, you can preview the layout of the import map.
To change the order of the fields in the destination file, click a field in the To column, and then click the Move buttons to move the field to the position that you want.
On the last page of the Import Wizard, click Finish to import your data.
TIP: You can save a new or edited import map if you want to use it again. On the last page of the Import Wizard, click Save Map, and then type a name in the Map name box. The new map will be added to the list of predefined maps.
Learn about the Schedule Import form toolbar
Learn about the correct format for schedule import files
Modify a schedule import configuration
Schedule a schedule data import process
Export projects from Primavera 6 release 7
Export schedule data from Microsoft Project