Cobra Help

Integrate Actual Costs Process

Use the Integrate Actual Costs API process to import actual costs into a project in progress.

Process Settings

Below are the settings you must define for the Integrate Actual Costs API process.

Setting

Description

Sample Value

ProcessID

This setting informs Cobra to run the Integrate Actual Costs process.

IntegrateActualCosts

ConfigurationName

This setting refers to the name of the configuration stored in the database. The configuration file is created on the last page of the Integration Wizard and contains the list of actions to be run on the project.

This setting is required.

MyConfig

Project

This setting refers to the project where you want to import actual costs.

This setting is required.

Demo Advanced

TransactionFile

This setting refers to the file that contains the data you want to import.

This must be a fully qualified filename.

This setting optional. By default, this setting is set to the settings in the configuration file.

C:\\Cobra\\System\\Demodata\\Trn\\ac_tran1.csv

ConfigurationOwner

This setting is optional. However, if the user ID running the API process is not the owner of the configuration file, you must define this setting in the API script.

SYSADMIN

ExclusionFile

This setting forces the zeroing process to ignore the actual costs contained in a file.

The exception file must be in the same format (Format 1 or Format 2) and have the same column order as the actuals import file.

This setting is ignored if the ZeroUnreferencedActualCosts field is not set to 1.

This setting is optional.

C:\\Cobra\\IgnoreTheseRecords.csv

ValidateOnly

Use this setting to validate the actual costs without posting any data to the Cobra database.

This setting is optional and the default value is 0.

1

Class

If the file does not include the Actuals class, this setting is used to determine the class that will hold the data when loaded. The value must be an Actuals class in the Cobra project; otherwise the process will not be completed successfully.

This setting is optional.

Actual

ClassId

This setting is optional and can be used instead of the Class setting.

Actual

FieldList

This setting holds a comma-delimited list of the fields used when loading data from an import file. The field list is used to determine the position of the data being loaded into Cobra. The field list must use field labels such as CA1, CA2, WP, CECODE, HOURS, DIRECT, OVERHEAD, or GANDA and not WBS or Resource. The fields are separated by commas and there should not be any spaces between the fields.

This setting is optional.

CA1,CECODE,HOURS,DIRECT

IgnoreClassList

This setting forces the zeroing process to skip any actual cost records whose class appears in the defined cost class list. This setting is ignored if ZeroUnreferencedActualCosts is not set to 1.

This setting is optional.

Budget,Forecast,OTB

ResultsToCalculate

This setting holds a comma-delimited list of resource Results that are calculated after the actual costs are loaded.

This setting is optional.

OVERHEAD,GANDA

ResultIdList

This setting is optional and can be used instead of the ResultsToCalculate setting.

OVERHEAD,GANDA

ZeroUnreferencedActualCosts

If the value is set to 1, Cobra zeroes out actual cost records that do not have a corresponding entry in the load actuals import file.

This setting is optional and the default value is 0.

1

FieldMapperColumnHeaders

This setting is optional and can be used instead of the FieldList setting.

CA1,CECODE,HOURS,DIRECT

ExcludedClassesIdList

This setting is optional and can be used instead of the IgnoreClassList setting.

Budget,Forecast,OTB

Sample Script

Below is a sample script file for the Integrate Actual Costs API process.

[Process004]
ProcessID=IntegrateActualCosts
Project=Demo Advanced
ConfigurationName=MyConfig
TransactionFile=F:\Accounting\Jan-10.csv
ConfigurationOwner=SYSADMIN
Class=Actual
FieldList=CA1,CECODE,HOURS,DIRECT
IgnoreClassList=Budget,Forecast,OTB
ResultsToCalculate=OVERHEAD,GANDA
ZeroUnreferencedActualCosts=1

How to...

Import Actual Cost Data

Run the API Script

Create Windows Shortcut for the API Script


Learn more about...

API Script

Project Template Creation

Data Import-Actual Costs


Parent Topic:

Process Sections of the API Script