Import and Export of Data
Before you implement your import and export tasks with the Application API, it is good practice to test the connections, parameters, SQL queries and so on in XMLSpy. In this way you are able to verify the results and make quick adjustments to import or export parameters. Most of the methods for importing and exporting data are placed in the Application object; the remaining functions are accessible via the Document interface.
There is some preparatory work necessary before the actual import or export can be started. Every import/export job consists of two parts. You need to define a connection to your data and the specific behavior for the import/export process. In case of an import, the connection is either a database, a text-file, or a Word document. The main issue is which data (columns) to imported into XMLSpy. In case of an export, the connection is either a database or a text file. Specify which data (elements of the XML file) and additional parameters (for example, automatic key generation or number of sub-levels) to use from the XML-structure.
The properties in the DatabaseConnection, TextImportExportSettings and ExportSettings interfaces have default values. See the corresponding descriptions in the Interfaces chapter for further information.
The sub-sections of this section describe each of these operations in detail.