Import and Export of Data

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Programmers' Reference > Application API > Overview > Programming Languages > JScript >

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 behaviour for the import/export process.

 

In case of an import, the connection is either a database, a text-file or a Word document. The behaviour is basically which data (columns) should be imported in 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.

 

Import from Database
Export to Database
Import from Text
Export to Text

© 2019 Altova GmbH