Use this screen to define the source file structure for importing project budgets. You can use the Configure Project Planner Mapping Definitions screen to define links between the list of columns you defined for the input file and the list of columns required for update in the Costpoint tables. You must use these two screens before executing the Import Project Budgets screen.
Use this block to define source file name, description, and the input file content from a Costpoint budgeting perspective.
Enter the source name.
Enter a source file description.
Select this check box to indicate that the input file contains a header row.
Use the drop-down list to define the type of data contained in the input file. Valid options are
BUDGET
FORECAST
BOTH
ETC
Use the drop-down list to define the level at which the data is loaded into Costpoint. Valid options are:
TOTAL
PERIOD
You can select TOTAL or PERIOD if you selected BUDGET or FORECAST in the Type field. If you selected ETC in the Type field, you must select TOTAL in this field.
Subtask |
Description |
Include Exclude Definition |
Use the Include Exclude Definition subtask to define the rules for including or excluding rows using row identification specifications, which are based upon specific columns and the data value within those columns. |
Row Definition |
Use the Row Definition subtask to define source file row type, description, and input file content definition from a Costpoint budgeting perspective. You also define row specifications using a specific column number and a data value within that column. |