SetConnect

Boka demo Om oss

XMLexport

Database::XMLexport
Description

Export the data from a database to an XML-file. The XML-file can be structured in any way based on any number of queries. All Output-configurations are stored in the MS-Access compatible database "XMLexport.MDB" which is located in the installation-directory.

The "Database Source" supports ODBC and SQL-Server.

Note: if XMLexport is run on a 64-bit system, the XMLexport.mdb can't be opened directly and you will need to create a system-DSN (ODBC) called "XMLEXPORT"which points to the XMLexport.mdb in the installation folder.
Options
- ODBC
DSN
 The Data Source Name of the source database.
Username
 Username for the DSN-connection.
Password
 Password for the DSN-connection.
Database
 Databse for the DSN-connection.
- SQLserver
Server
 The server name or adddress of the SQL server.
Username
 Username for the connection.
Password
 Password for the connection.
Database
 Database to use.
Truseted Connection
When checked, the current credentials are used to logon to the database server.
Persis Security Info
 Specifies whether the data source can persist sensitive authentication information such as a password.
 
XML Output file
The XML output filename.
Configure XML Output
 Displays the XML-Output Configuration window.
Configuration
 The name of the current configuration.

Switch
 unlocks the "Configuration" combobox, so you can select a different configuration.
Rename
 renames the current configuration.
Copy
 Copy's the current configuration to a new configuration.
Delete
 deletes the current configuration.
XML Output Configuration
Tables
 Contains all available tables of the source-database. Double-clicking a table-name will add the name to the current cursor-position of the XML-tag field.
Columns
 When a table is clicked in the "Tables" section, this will contain all available columns of the selected table. Double-clicking a column-name will add the name to the current cursor-position of the XML-tag field.
XML Configuration

Contains the entire configuration of the XML-output. Clicking a line will show the line in the "XML Tag" field where it can be changed. After a change click the "Change" button to save the change to the "XML Configuration".

The XML Configuration can contain special commands to insert data from the database;

QUERY:1:SELECT DISTINCT COMPANY FROM exrcdw ORDER BY COMPANY
QUERY:2:SELECT TOP 1 * FROM exrcdw WHERE COMPANY='{1!COMPANY}'
<Company>{2!COMPANY}</Company>
<Partner>{2!PARTNER}</Partner>
MOVENEXT:2
MOVENEXT:1

In the above example the QUERY:1 command executes a query (id=1). The next line executes a new query (id=2) and uses part of the result from the first query: {1!COMPANY}. 1 is the query-id and !COMPANY references the column-name "COMPANY" from the query-1.

The commands {2!COMPANY} and {2!PARTNER} reference the result of query-2 and use the columns COMPANY and PARTNER.

MOVENEXT:2 moves the pointer of the recordset which contains the result of query-2 to the next record and returns to the commands below QUERY:2......it keeps doing this until there are no more records in the recordset which contains the result of query-2.

MOVENEXT:1 again moves the pointer of the recordset of query-1 to the next record and returns to the commands below QUERY:1......etc....

Documentation

Release notes