Import Budgets/EACs from Excel: Process Overview

The following is an overview of the process for using this utility to upload budgets/EACs from Excel to the Project Budgets/EACs application. For more detailed information, see field descriptions within this topic and the links to related subtasks at end of this topic.

Step 1: Download and complete the Excel template

The template (available from the Excel Template subtask) includes column headings that correspond to fields within the Project Budgets/EACs application. The completed template must be saved in the .xml format.

If you are unfamiliar with saving in the .xml format, see the Excel online help.

If you are a System Administrator and have not yet configured Costpoint to accept this format, add the .xml format to the File Upload Limits table of the Admin » System Administration » System Administration  Controls » Configure System Settings screen.

Step 2: Select Processing Settings

In the Import Budget/EACs from Excel screen, you select settings for handling duplicate project budgets/EACs, as well as error report settings.

Step 3: Select and Upload the File

Use to select the .xml file for upload and processing.

The .xml must be saved to a preconfigured location within Costpoint, referred to as an Alternate File Location. When you save the template as an .xml file, you must either save it to the Alternate File Location, or copy it to that location using File Upload on the Process menu.

If you do not know the Alternate File Location, check with your System Administrator.

If you are a System Administrator and have not yet configured the Alternate File Location, see online help for Administration » System Administration » File Management » Manage Alternate File Locations.

After the file is selected, click the Upload File button to upload and process it.

Step 4: Review Results

Depending on validation settings, the Budgets/EACs that did not contain errors are either uploaded immediately to the Project Budgets/EACs application as budgets with a Working status , or all the budgets/EACs fail if any errors exist.

You can review error messages on the Error Report subtask. The Upload Report subtask displays the budgets/EACs that were successfully uploaded. From that same subtask, you can also commit selected budgets/EACs, and in the Project Budgets/EACs application, the status of the uploaded budget/EAC changes from Working to Incomplete.

Step 5: Correct Errors and Rerun the Process

Using information on the Error Report subtask as a guide, you can make corrections to your original entries in the Excel template, and then re-run the process until you have successfully imported all budgets/EACs into the Project Budgets/EACs application.