📄️ USoft XML formats
The USoft platform has a range of tools, features and APIs for selecting, importing, exporting, moving, comparing data from and between repositories. These tools share common USoft XML formats or XML schemas: common ways of representing relational data.
📄️ XML table section syntax
An XML table section is an XML fragment that describes a set of records from the same table. Table sections are used in XML single-table documents and XML multi-table documents. An XML table section may contain any number of elements corresponding to records in the table.
📄️ DML instruction tags
In a table section, table elements represent database records. A table element is allowed to have an optional DML instruction tag. This is an explicit instruction to XML.Import about what to do with the record on import (See "Meaning of DML instruction tags" later in this article). DML (Data Manipulation Language) is an abbreviation from the SQL specification.
📄️ XML single-table document format
A USoft XML single-table document contains data from a single table.
📄️ XML multi-table document format
A USoft XML multi-table document is allowed to contain data from multiple tables.
📄️ usoft-xml processing instruction
Gives instructions to XML.Import for handling the import of records from a USoft XML document:
📄️ XML representation of date values
In general, the ISO 8601 standard is used for representing date values within XML documents. A description of the ISO 8601 standard for dates can be found at:
📄️ XML representation of queries
XML documents can contain query instructions with conditions for the records to be retrieved. In this case, the XML document complies with the Query By Form (QBF) definition.
📄️ Meta-Rows-Fields document format
A Meta-Rows-Fields XML document is allowed to contain data from multiple tables.
📄️ XML error messages
USoft XML error messages look like this: