XML

enaio® import-export • 11.0 »

Data in the 'XML' format can be exported in a linear or hierarchical object model.

XML – Linear Object Model

The exported file receives the extension 'xml'. The data are displayed in a table structure containing columns and rows.

The attributes of the columns comprise object type names, filed names, database type, database length, and database name. The 'system' attribute has the value '1' for basic parameter fields.

Example:

Two documents of type 'Photo' are exported from the 'Film' cabinet. In addition to the document's index data, the 'Film' folder's index data and the 'Casting' register's index data are also exported.

<?xml version="1.0" encoding="UTF8" ?> 
<DMSContent format="LOL">
 <Archive name="Film" id="22" osguid="8FD65A2155D040B2914E8AFCFBE7B731">
 <ObjectType name="Photo" id="196629" osguid="887BF5A03BFC49E3AF0A9A7370DFED80" type="DOCUMENT" modul="COLOR">
 <Rowset>
 <Columns>
<Column object="Film" name="Arbeitstitel" type="TEXT" ostype="X" size="1000" dbname="feld1" system="0" /> 
<Column object="Casting" name="Rolle" type="TEXT" ostype="X" size="50" 
dbname="feld5" system="0" /> 
<Column object="Photo" name="angelegt" type="DATE" ostype="D" size="0" dbname="angelegt" system="1" /> 
<Column object="Photo" name="Typ" type="TEXT" ostype="X" size="50" 
dbname="feld4" system="0" /> 
<Column name="@FILES" type="text" ostype="X" size="255" system="0" /> 
 </Columns>
 <Rows>
 <Row id="2558">
<Value>Wald</Value> 
<Value>Hauptdarsteller</Value> 
<Value>03.02.2004</Value> 
<Value>Portait</Value> 
<Value>D:\xml\jp4_2131BA664D194F65880B46379F1070A2.000</Value> 
 </Row>
 <Row id="2559">
<Value>Wald</Value> 
<Value>Hauptdarstellerin</Value> 
<Value>09.02.2004</Value> 
<Value>Portait</Value> 
<Value>D:\xml\jp4_8C2743344D7A4ADD9CE7380D9D43685A.000</Value> 
 </Row>
 </Rows>
 </Rowset>
 </ObjectType>
 </Archive>
</DMSContent>

In the Output options dialog, you can specify an XSL style sheet, in which case the unformatted file will be written to the output location.

XML – Hierarchical Object Model

The exported file receives the extension 'xml'. The data are written in the form of a nested list.

The list contains folder objects that can contain registers as 'ChildObjects', and these registers can contain documents as 'ChildObjects'.

The following data for the objects are exported:

  • 'Fields' – index data and file name

  • 'MultiFields' – data of multi-fields

  • 'TableFields' – table field data

    The data associated with table fields are written in a tabular structure, made up of columns and rows.

Example:

A document of type 'Photo' is exported from the 'Film' cabinet. In addition to the document's index data, the 'Film' folder's index data and the 'Casting' register's index data are also exported.

Data from the 'Version' multi-field and the 'Publications' table field are also exported.

<?xml version="1.0" encoding="UTF-8" ?> 
 <DMSContent format="HOL">
 <Archive name="Film" id="22" osguid="8FD65A2155D040B2914E8AFCFBE7B731">
 <ObjectType id="22" name="Film" osguid="8FD65A2155D040B2914E8AFCFBE7B731" 
type="FOLDER" modul="">
 <ObjectList>
 <Object id="2557">
 <Fields>
 <Field name="Arbeitstitel" system="0" internal_name="" datatype="TEXT" 
size="1000" dbname="feld1">Wald</Field> 
 </Fields>
 <ChildObjects>
 <ObjectType id="6488064" name="Casting" 
osguid="CA6222CB51C546049F71A268BC14936C" type="REGISTER" modul="">
 <ObjectList>
 <Object id="2562">
 <Fields>
 <Field name="Rolle" system="0" internal_name="" datatype="TEXT" 
size="50" dbname="feld5">Hauptdarsteller</Field> 
 </Fields>
 <ChildObjects>
 <ObjectType id="196629" name="Photo" 
osguid="887BF5A03BFC49E3AF0A9A7370DFED80" type="DOCUMENT" 
modul="COLOR">
 <ObjectList>
 <Object id="2561">
 <Fields>
<Field name="angelegt" system="1" internal_name="" datatype="DATE" 
size="0" dbname="angelegt">03.02.2004</Field> 
<Field name="Typ" system="0" internal_name="" datatype="TEXT" 
size="50" dbname="feld4">Portait</Field> 
<Field name="FILES" internal_name="" datatype="text" size="10" dbname="">
D:\xml\jp4_5DA8E8A02F654FFF8B3A42F78B44D5CE.000</Field> 
 </Fields>
 <MultiFields>
 <MultiField name="Version" internal_name="" datatype="TEXT" size="50">
 <Page id="1">
 <Value>Orginal</Value> 
 </Page>
 <Page id="2">
 <Value>Bearbeitet</Value> 
 <Value>Farbkorrektur</Value> 
 </Page>
 <Page id="3">
 <Value>Bearbeitet</Value> 
 <Value>Lichtkorrektur</Value> 
 </Page>
 </MultiField>
 </MultiFields>
 <TableFields>
 <Field name="Publikationen" internal_name="">
 <Columns>
 <Column name="publiziert in" datatype="TEXT" size="50">
publiziert in
</Column> 
 <Column name="publiziert von" datatype="TEXT" size="50">
publiziert von
</Column> 
 <Column name="Datum" datatype="DATE" size="10">
Datum
</Column> 
 </Columns>
 <Field id="1">
 <Value>Intern</Value> 
 <Value>Maier</Value> 
 <Value>22.05.2004</Value> 
 </Field>
 <Field id="2">
<Value>Flyer</Value> 
<Value>Schulz</Value> 
<Value>01.06.2004</Value> 
</Field>
</Field>
</TableFields>
</Object>
</ObjectList>
</ObjectType>
</ChildObjects>
</Object>
</ObjectList>
</ObjectType>
</ChildObjects>
</Object>
</ObjectList>
</ObjectType>
</Archive>
</DMSContent>