Post-processing Steps

Setup

Add a Net Change Result Processor custom step.

Report Filtering

Filters are available to control the output of the Net Change result file:

  • All: Detailed status of all actions are reported.

  • Error only: Detailed status of failed actions are reported.

  • Error and warning only: Detailed status of actions that have generated an error or a warning message are reported.

When performing a Net Change Setup, this step generates a simple XML report that indicates how many entities have been processed during the operation. Since a Net Change Setup does not import any data into the product, there are no entity results in this report.

Add a Net Change Result Processor custom step.

This step is optional for Net Change Setup. It transforms the file generated by the Net Change Result Processor into a standard TCC CSV file.

Select the load file to use as import file for this integration. This is the same file as the one used for Computation.

Select the Output properties check box to include the CSV file properties in the result file.

Property

Description

Example

CSVLineCount

Number of data rows present in the CSV result file (excluding the column header row). In the case of an Net Change Setup process, this value will always be 0.

CSVLineCount=0

total.[entity]

Total number of entities processed. If no entities are processed by the target application, this property is not included.

total.jobfield=96

duration

Time taken by target application to process entire import file generated by Net Change engine. In the case of an Net Change Setup, no entities are imported in the customer zone, the duration should be close to 0.

duration=0:00:00.106

CSV Result File Format

The file generated by Net Change Result Transformation has the following format (Note that if in the configuration general tab you have specified to not output the column header, then no header will be included in the result CSV file):


#BEGINPROPERTIES
PropertyName=PropertyValue
#ENDPROPERTIES
"Index","Identifier","Status","TransactionType","Result","Message"

CSV Result File Description

Net Change Setup processing does not generate any rows in the CSV file since no imports are done on the customer zone.

Computation

Add a Net Change Result Processor custom step.

Report Filtering

Filters are available to control the output of the Net Change result file:

  • All: Detailed status of all actions are reported.

  • Error only: Detailed status of failed actions are reported.

  • Error and warning only: Detailed status of actions that have generated an error or a warning message are reported.

This step processes the target application result file to update the local Net Change reference database in order to reflect the state of the target application.

For each record, if the transaction was successfully processed, then the local Net Change reference database is updated with the new value. If the record was not successfully processed, the Net Change reference database is not updated.

Add a Net Change Result Processor custom step.

This step transforms the file generated by the Net Change Result Processor into a standard TCC CSV file.

Select the load file to use as import file for this integration. This is the same file as the one used for Computation.

Select the Output properties check box to include the CSV file properties in the result file.

Property

Description

Example

CSVLineCount

Number of data rows present in the CSV result file (excluding the column header row).

CSVLineCount=96

total.[entity]

Total number of entities processed.

If no entities are processed by the target application, this property is not included.

total.jobfield=96

total.[entity].create

Total number of entities created.

If no entities are created, this property is not included.

total.jobfield.create=48

total.[entity].update

Total number of entities that are updated.

If no entities are updated, this property is not included.

total.jobfield.update=10

total.[entity].delete

Total number of entities that are deleted.

If no entities are deleted, this property is not included.

total.jobfield.delete=10

total.status.success

Number of entities that are processed with success by the target application.

If no success has been detected, this property is included with a value of 0.

total.status.success=30

total.status.error

Number of entities reported in error at the target application.

If no error is reported, this property is included with a value of 0.

total.status.error=48

total.warning

Number of warning messages generated by the target application.

If no warning is generated, this property is included with a value of 0.

total.warning=18

duration

Time taken by target application to process entire import file generated by Net Change engine.

duration=0:00:03.2890

CSV Result File Format

The file generated by Net Change Result Transformation has the following format (Note that if in the configuration general tab you have specified to not output the column header, then no header will be included in the result CSV file):


#BEGINPROPERTIES
PropertyName=PropertyValue
#ENDPROPERTIES
"Index","Identifier","Status","TransactionType","Result","Message"

Column Name

Description

Index

Row sequential number

Identifier

Unique key name used Net Change to identify the entity. This key is composed of the following sub sections:

Entity Name|Net Change Action|Entity Search Key Id

Example:

JobTemplate|create|NC2_00791130771

Status

Net Change Result Status for the entity. Indicates whether Net Change operation completed with success or error.

The possible values are:

  • success

  • error

TransactionType

Target application transaction type to perform Net Change action.

For example, if an update has been detected for the job template entity, the transaction type will be “jobtemplate.update”.

Note that the action done on the target application might be different than the Net Change action. For example, in the case of inactivation when a Net Change delete action is detected, an update operation is required. In this case the Net Change Action will be delete and the transaction type will be update.

Result

Not used for now.

Message

Detailed message about the error or the warning returned by the target application.