Importing and Exporting Data 

Use

You can export the data that you have called up in the progress analysis workbench to Microsoft® Excel, where you can change it before importing it back into the progress analysis workbench.

Exporting Data

       1.      Call up the data for your project objects.

       2.      Choose Progress Analysis ® Export ® Excel.

       3.      Choose the required view (table or pivot table).

       4.      Choose Enter.

The system displays the data in Microsoft Excel, where you can change the following values:

¡        For WBS elements and activities:

§         Percentage of completion

§         Customer-defined fields

§         User fields

§         Dates (actual and forecast dates for activities; basic and actual dates for WBS elements)

¡        For milestones:

§         Percentage of completion

§         Dates (basic, forecast, and actual)

Importing Data

...

       1.      On the initial screen for the progress analysis workbench, choose Progress Analysis ® Import ® Excel.

       2.      Select the Microsoft Excel file that you want to import.

The system imports the data into the progress analysis workbench, and updates the changed values in the SAP system.

You can only upload project objects that have a number.

Dates must have the format: mm-dd-yyyy.