Jump to: navigation, search

Difference between revisions of "XML Interface Toolkit"

(→‎Mapping file)
Line 1: Line 1:
 
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 [[Interface_Manager#Configuration|default parameters]].
 
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 [[Interface_Manager#Configuration|default parameters]].
 +
 +
{{Attention|The XML document must use the correct encoding, e.g. UTF-8}}
  
 
== Parameters ==
 
== Parameters ==
Line 87: Line 89:
 
== Mapping ==
 
== 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]].
 
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
 +
 +
<source lang="csharp">
 +
namespace UBIK.Interface.Module.XML
 +
public class XMLDataInterface : UBIKStandardInterface, IUBIKImport, IUBIKExport
 +
</source>
  
 
== See also ==
 
== See also ==

Revision as of 10:46, 11 February 2014

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.

IC Attention.pngThe 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

  <InterfaceManager>
  <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

  <InterfaceManager>
  <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
namespace UBIK.Interface.Module.XML
public class XMLDataInterface : UBIKStandardInterface, IUBIKImport, IUBIKExport

See also

Retrieved from "https://wiki.augmensys.com/index.php?title=XML_Interface_Toolkit&oldid=8925"