The format in which data is exported by default is a standardised USoft XML format. In this format, XML element names map to table names, XML attribute values map to column names, and XML attribute values map to column values.
This format is used across the entire USoft platform with the exception of USoft Benchmark, which still uses the obsolete TDF format, and conventional Export Tasks in USoft Batch (now part of USoft Definer), which still output comma-separated values.
For convenience and for backward compatibility only, Delivery Manager offers "Export to TDF" as a separate action.
For details on the USoft XML format generally, see the "USoft XML Specification" section in USoft Definer Help. For details on the implementation of this format in Delivery Manager, see the individual Help topic for actions.
Delivery Manager outputs to the variety of the USoft XML format that supports multi-table data in a single output file, even if the exported data is from a single table:
<multi-table-root>
<underscored-object-name-plural>
<table column="value" column="value" ... />
...
For example:
<MultiExport>
<Accredited_Persons>
<PERSON ID="177" FAMILY_NAME="Haynes" FIRST_NAME="Deborah"/>
<PERSON ID="112" FAMILY_NAME="Smith" FIRST_NAME="John"/>
...
|