Exporting on a reference date

Application management : Tools : Enterprise Talk : Examples - export : Exporting on a reference date

This example explains how to export all data of a contract, a life cycle aware business object. In the example, the accepting party of a contract has a changed. The BO fields selected for export are the following:

• Code

• Name

• Start date contract (BeginDate)

• Accepting party

The fields Code and Name are not life cycle aware; if these fields change value, they change for the entire contract because their changes are not tracked over time. The Accepting party on the other hand is a life cycle field. When you do not specify a reference date, all its values over time are exported. If you want to know when a change was applied, you need to include the field Begindate.

Each life cycle is captured in its own tag and the resulting XML is as follows:

<businessobjects xmlns:talk="http://www.planonsoftware.com/V1/EnterpriseTalk">
<UsrLeaseContract>
<Code>0001</Code>
<Name>Airport Boulevard - Carbon Smart (out)</Name>
<talk:lifecycle>
<BeginDate>2008-01-01</BeginDate>
<AcceptingContractPartyRef>0002</AcceptingContractPartyRef>
</talk:lifecycle>
<talk:lifecycle>
<BeginDate>2015-09-04</BeginDate>
<AcceptingContractPartyRef>0005</AcceptingContractPartyRef>
</talk:lifecycle>
</UsrLeaseContract>
</businessobjects>

Exporting a business object with all life cycles to CSV/Excel is not supported. Please always provide a reference date when exporting contract data to CSV/Excel.