Wednesday, July 14, 2021

Export or import data to another file format

The Export Wizard and Import Wizard help you transfer project data between Microsoft Project and other programs. The following is a list of formats you export to or import from.

  • Microsoft Excel (as a workbook or PivotTable report)

  • text-only (tab delimited)

  • comma-separated values (CSV)

  • Extensible Markup Language (XML)

By defining or editing the export or import maps of these wizards, you can easily transfer data to and from the task, resource, or assignment fields that you want.

What do you want to do?

Export project information

  1. Choose File > Save As.

  2. Choose Browse. (Not applicable in Project 2010.)

  3. In the Save As type box, select the file format that you want to export data to.

  4. In the File name box, type a name for the exported file.

  5. Choose Save.

  6. Follow the instructions in the Export Wizard to export the data that you want into the proper fields of the destination file.

  7. When the wizard prompts you to create a new map or use an existing one, do one of the following:

    • Choose New map to create a new export map from scratch.

    • Choose Use existing map to use a default map or a map that you previously defined and saved.

  8. 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, choose Add All.

    • To add all task or resource fields of a specific table to the export map, choose Base on Table. Select the table you want to use, and then select OK.

    • To remove all task, resource, or assignment fields from an export map, choose Clear All.

    • To insert a new field above another field, select a field in the From column, and then choose Insert Row.

    • To insert a new field above another field, select a field in the From column, and then choose Insert Row.

    • To delete a field, select it in the From column, and then choose Delete Row. To change the name of the field in the destination file, select the field in the To column, and then type a new name.

  9. To export certain tasks or resources only, select the filter that you want in the Export filter box.

  10. If you want to change the order of the fields in the destination file, select a field in the To column, and then use the Move buttons to move the field to the position that you want.

  11. On the last page of the Export Wizard, choose Finish to export your data.

Notes: 

  • 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, choose 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.

Import project information

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.

  1. Choose File > Open > Browse.

    (In Project 2010, choose File > Open.)

  2. In the Files of type box, select the file type that you want to import data from.

  3. Navigate to the folder that contains the file you want to import, and then select the file in the file list.

  4. Choose Open.

  5. Follow the instructions in the Import Wizard to import the data that you want into the proper Project fields.

  6. 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, select 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, select the field in the To column, and then type a new name.

    • To delete a field, select it in the From column, and then choose Delete Row.

    • To insert a new field above another field, select a field in the From column, and then choose Insert Row.

    • To remove all task, resource, or assignment fields from an import map, choose Clear All.

    • To add all task, resource, or assignment fields of the destination file to the import map, choose 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.

  7. To change the order of the fields in the destination file, select a field in the To column, and then use the Move buttons to move the field to the position that you want.

  8. On the last page of the Import Wizard, choose 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, choose Save Map, and then type a name in the Map name box. The new map will be added to the list of predefined maps.

Notes: 

  • You can use an existing import map from another project if the map is available in the global file. By using the Organizer, you can copy an import map from a project file to the global file.

  • When you create an import map to incorporate data from 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 import 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.

  • Although you can enter values in some calculated fields, Project may recalculate these values, either automatically or when you specify.

  • Project can import only XML data that can be validated against its data interchange schema.

  • If you are using Microsoft Project Professional, and you want to import information from another file format into an enterprise project that requires you to enter specific information for tasks, you won't be able to save the project until you enter all required information.

  • If you are using Microsoft Project Professional, remember that resource cost fields cannot be updated in an enterprise project. You can import resource cost information only in nonenterprise projects or for nonenterprise resources in a project.

No comments:

Post a Comment