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.