2.1 Command Line Usage Summary

Format

The general format of the command line usage is as follows:

 
SwiftCmd.exe [Options] <Request> <SwiftDocument> <Arguments ..>
Request

Represents the action to be performed.

SwiftDocument

Path name of the Swift document to perform the action on.

Arguments

Arguments for the request (depends on the request).

Requests

Requests are used to indicate the activity to be accomplished. Valid Requests are as follows. For more details on each request, please see the following sections.

importXML

Import one or more XML files into the Swift Document.

listXML

List the XML files imported into the Swift Document.

listQueries

List the queries defined in the Swift Document. (To create queries, please use the Swift XML Converter (GUI).)

listTables

List the tables defined in the Swift Document.

exportXLS

Export data to Microsoft Excel (XLS) format.

exportMDB

Export data to Microsoft Access (MDB or ACCDB) format.

exportCSV

Export data to CSV (comma-separated values) format (compatible with Microsoft Excel).

exportTXT

Export data to plain text (TXT) format.

exportHTML

Export data to HTML format.

Options

The following are all the options that are supported. Please note that some options are applicable only for specific requests (as noted).

-a AccessVersion

Specify the version of Microsoft Access with which you want the exported MDB or ACCDB file to be compatible with. Should be one of 2007, 2003 or 97 (default).

Applicable only with the exportMDB request.

-e Encoding

Specify output encoding when exporting to CSV, Text or HTML. Valid encodings are ANSI, UTF-8 or UTF-16.

-i InputFile

Read XML file locations (or URLs) to import by listing them in a file, one per line. Each line can be a local file path or a URL. Local file paths are processed for wildcards too.

Applicable only when importXML is being used.

-N (on|off)

Normalize (with -N on) repeated XML elements to a separate table. By default, repeated XML elements are inserted into the same table with suffixes e.g. column1, column2, etc.

Applicable only when importXML is being used.

-s SeparationChar

Specify the field delimiter character to be used with text output. Typical examples include “,” (comma), “:” (colon), “;” (semi-colon) or “|”. Must be a single character (not a string).

For specifying the tab-character, use “\t” (back-slash followed by “t”).

Applicable only with the exportTxt request.

-w

Overwrite output files as needed. Existing output files will not be overwritten unless this option is used.

Applicable only with the export requests such as exportXLS, etc.

-x

Use alternative Microsoft Excel output. With this option, each exported table (or query) is exported to a separate sheet within the Worksheet. By default, all exported tables are written into a single sheet.

Applicable only when used with exportXLS.

Swift XML Converter

Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.

Exult Standard

Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.

Exult SQL Server

Shred and import XML into SQL Server.

Exult MySQL

Import XML data into automatically created MySQL tables.

Exult Oracle

Import XML into Oracle.