The XML interface toolkit provides mechanisms to import and export data in XML format. Arbitrary structured XML data is mapped to according UBIK® objects and its properties by a mapping specified in a separate mapping configuration file. Both files have to be specified in the interface command file additional to the default parameters.
 | The XML document must use the correct encoding, e.g. UTF-8 |
Parameters
The general parameters, marked by Import/Export, are equivalents of the settings used by UBIKSTUDIO to connect to a database, please refer to its settings section for a detailed description.
The parameter DataView is used only for export purposes and defines the name of a UBIK® View object. In an export process the XML toolkit
- evaluates the view hierarchy and its objects
- exports an object as defined in the mapping
- in the same hierarchy as placed in the view
| Key | Application | Description |
|---|---|---|
| Server | Import/Export | Name of the SQL Server (DataSource) |
| InitialCatalog | Import/Export | The name of the instance on the SQL Server (DataBase) |
| UserID | Import/Export | SQL Server user name (User) |
| Password | Import/Export | SQL Server password (Password) |
| RecordLifeTime | Import/Export | Duration how long records are valid before they will be requeried for changes by the kernel; -1 to turn off |
| WorkingFolder | Import/Export | Defines a folder where temporary files will be placed and deleted after processing |
| DataFile | Import/Export | Import: File path to XML data file to be imported; Export: Exported XML data will be stored in this file |
| DataMappingFile | Import/Export | File path to file containing the XML mapping information, both for import as well as export |
| DataView | Export | Name of a UBIK® view object defining the scope and hierarchy of exported objects |
| DataObject | Export | Guid of a single UBIK® object to be exported |
| DeleteFile | Import/Export | Defines whether or not the specified DataFile should be deleted after processing |
| LogFolder | Import/Export | Defines a folder where log files will be created into; if set a log file will be created always! |
| LogFile | Import/Export | Optional: defines a certain log file name; it not set the system will create an arbitrary one |
Example: Export
<Commands>
<Interface FullName="UBIK.Interface.Module.XML, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" File="C:\UBIK\Studio\Interfaces\UBIK.Interface.Module.XML.dll" Class="UBIK.Interface.Module.XML.XMLDataInterface" Direction="E">
<Parameter Key="Server" Value="sqlserver" />
<Parameter Key="InitialCatalog" Value="ubik" />
<Parameter Key="UserID" Value="sa" />
<Parameter Key="Password" Value="sa" />
<Parameter Key="RecordLifeTime" Value="-1" />
<Parameter Key="WorkingFolder" Value="C:\UBIK\Xml\Work" />
<Parameter Key="DataFile" Value="C:\UBIK\Xml\Data\data.xml" />
<Parameter Key="DataMappingFile" Value="C:\UBIK\Xml\Map\map.xml" />
<Parameter Key="DataView" Value="VIE_EXPORT" />
<Parameter Key="DeleteFile" Value="0" />
<Parameter Key="LogFolder" Value="C:\UBIK\Log\Temp" />
<Parameter Key="LogFile" Value="export.log" />
</Interface>
</Commands>
</InterfaceManager>
Example: Import
<Commands>
<Interface FullName="UBIK.Interface.Module.XML, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" File="C:\UBIK\Studio\Interfaces\UBIK.Interface.Module.XML.dll" Class="UBIK.Interface.Module.XML.XMLDataInterface" Direction="I">
<Parameter Key="Server" Value="sqlserver" />
<Parameter Key="InitialCatalog" Value="ubik" />
<Parameter Key="UserID" Value="sa" />
<Parameter Key="Password" Value="sa" />
<Parameter Key="RecordLifeTime" Value="-1" />
<Parameter Key="WorkingFolder" Value="C:\UBIK\Xml\Work" />
<Parameter Key="DataFile" Value="C:\UBIK\Xml\Data\data.xml" />
<Parameter Key="DataMappingFile" Value="C:\UBIK\Xml\Map\map.xml" />
<Parameter Key="DataView" Value="" />
<Parameter Key="DeleteFile" Value="0" />
<Parameter Key="LogFolder" Value="C:\UBIK\Log\Temp" />
<Parameter Key="LogFile" Value="import.log" />
</Interface>
</Commands>
</InterfaceManager>
Mapping
The XML data is converted into according UBIK® data (objects, property values,...) by applying a mapping between XML elements / attributes and UBIK® MetaClasses / MetaProperties.
Envelope
The default envelopes of the XML data is <UbikXMLData> but can be modified via the mapping configuration settings. The mapping information must be enveloped by a XML tag <UbikXMLMap>.
Classes
XMLDataInterface
- Process XML data and create or update UBIK® objects
- Process mapping information and apply on XML / UBIK® data
public class XMLDataInterface : UBIKStandardInterface, IUBIKImport, IUBIKExport
XMLDataImport
- Creates or update UBIK® objects from XML data using a XML converter and XML mapping
public class XMLDataImport
XMLDataExport
- Creates XML data from UBIK® objects using a XML converter and XML mapping
public class XMLDataExport