Built-In Data Schemas

< Previous section  |  Table of Contents  |  Index  |  Next section >

A data schema consists of XML code describing the format of data in a database. Schemas are used when importing data into a database or exporting data from the database. MBUtility has a number of built-in schemas that can be used for this purpose. To get a list of these built-in schemas, execute the command

mbutility ListImportSchemas

The result is a list of keywords that may be used on an MBUtility command line, as described in later sections of this guide.

Generating Schema Definitions: You can obtain the actual XML code for a built-in schema using MBUtility's GenerateImportSchema verb. The command line has the format:

mbutility GenerateImportSchema option option ...

where the options are:

/SchemaIdentification:schema
Specifies the schema whose definition you wish to obtain. This should be one of MBUtility's built-in schemas. Names are case-sensitive. If the schema name contains blank characters, the name should be enclosed in quotes, as in
/si:"Storeroom Assignment"
/Output:filename
A file where MBUtility should write the XML definition of the schema. This file will be written in Unicode characters, which means it should only be edited with software that can deal with Unicode (e.g. Wordpad).
+EXCEL
Specifies that the XML code in the schema should be in a format acceptable to Microsoft Excel.

For example, the following creates a schema for unit records, in a format acceptable to Excel:

mbutility gis /si:Unit /out:unitdef.xml +excel

< Previous section  |  Table of Contents  |  Index  |  Next section >