The general format of the command line usage is as follows:
SwiftCmd.exe [Options] <Request> <SwiftDocument> <Arguments ..> |
Represents the action to be performed.
Path name of the Swift document to perform the action on.
Arguments for the request (depends on the request).
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.
Import one or more XML files into the Swift Document.
List the XML files imported into the Swift Document.
List the queries defined in the Swift Document. (To create queries, please use the Swift XML Converter (GUI).)
List the tables defined in the Swift Document.
Export data to Microsoft Excel (XLS) format.
Export data to Microsoft Access (MDB or ACCDB) format.
Export data to CSV (comma-separated values) format (compatible with Microsoft Excel).
Export data to plain text (TXT) format.
Export data to HTML format.
The following are all the options that are supported. Please note that some options are applicable only for specific requests (as noted).
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.
Specify output encoding when exporting to CSV, Text or HTML. Valid encodings are ANSI, UTF-8 or UTF-16.
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.
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.
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.
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.
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.
Create Pivot Tables and Pivot Charts from Large Datasets.
Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Import XML data into automatically created MySQL tables.