In this section you can configure the settings for the database that is used by ISOWARE to read data that has been imported from external data sources.
The imported data can for example be used in reports.
Data can be imported from external SQL servers, Microsoft Excel documents, Microsoft Word documents, txt files, XML files etc.
No matter which data that is imported it has to be stored in a table in a SQL database that is accessible by ISOWARE.
The settings in this section tell ISOWARE how to read the imported data.

Enable import database
This has to be activated if the data import feature will be used
Database
The name of the database that contains the imported data
Username
The username of a database user with access to the import database
Password
The username of a database user
Server
The network address of the database server containing the import database
TCP port
The TCP port number used by the database server
Mapping XML
Here it is stated in XML format, how ISOWARE should read the data from the import database.
The Import Database can contain any number of tables, each containing any number of columns.
The XML structure must contain one and only one <recordtypes> element.
For each table to be read by ISOWARE, you have to create a <recordtype> element in the XML structure.
The <recordtype> element has to be placed under the <recordtypes> element and has two attributes, name and table.
The attribute name specifies the name that appears in ISOWARE for that record type.
The attribute table specifies the actual name of the table in the database.
Under each <recordtype> element you must create a mandatory <id> element, and an optional number of <column> elements.
The <id> element represents the primary key in that table, i.e. a column that contains unique values.
The <column> element represents all other columns in the table with one element for each column.
The <id> and <column> elements both have the following attributes: name, which specifies the name of the column in the table, datatype that specifies the column's data type and displayname, which is the name that appears in ISOWARE.