novixys

Convert one or more XML files to Excel(XLS), Access(MDB or ACCDB) or CSV using Exult from the command line

The Exult XML Conversion wizard includes a command-line program which can be used for batch conversion. The command line program companion to the Exult XML Conversion Wizard is called Exultcmd.exe and should be installed in the same directory as Exult.exe.

Click here for some usage examples.

An Overview

• Convert multiple XML files to MS Access, MS Excel, CSV, Text or HTML.
• Merge data from multiple XML files and extract to a Microsoft Access Database (MDB or ACCDB), Microsoft Excel spreadsheet (XLS), CSV, HTML or Text.
• Save data from each table to a different file for CSV and Text output.
• MS Access compatibility option: Specify -a 2007 to create an Access 2007 database. Also supported are -a 2003 and -a 97 for older versions.
• Existing output files will NOT be overwritten unless specifically requested (using the -w option).
• Supports a dry-run option (using the -n option) where no actions are performed but the files that will be processed and the output that will be created are shown.

Complete Usage Syntax

The formal usage syntax is given below.

The -t Type option is required to specify the type of output. Also, more than one input file or pattern can be specified.

  Exultcmd.exe [Options] -t <Type> InputFile(s)

The following are the valid output types supported for use with the -t option.

-t MDB

Convert XML to a Microsoft Access Database (MDB or ACCDB)

-t XLS

Convert XML to Microsoft Excel Spreadsheet (XLS)

-t CSV

Convert XML to Comma Separated Values (CSV) file

-t HTML

Convert XML to HTML

-t TEXT

Convert XML to delimited text file. Specify the delimiter using the -s option.

The following options are supported.

-a AccessVersion

Specify the version of Microsoft Access in which the saved output is to be opened. Applicable only when saving to a Microsoft Access Database (-t MDB). Default is to save in an Access 97 compatible format.

-a 2007

Save output in a Microsoft Access 2007 compatible format.

-a 2003

Save output in a Microsoft Access 2003 compatible format.

-a 97

Save output in a Microsoft Access 97 compatible format.

-d OutputDir

Create output file(s) in the specified OutputDir. Supported only for CSV or TEXT output. When this option is specified, data from each table is written to a separate file in the specified directory.

-f OutputFile

Write output to the specified file. Note that only one of -f or -d option can be used.

-n

Dry-run option. Shows the input files that will be processed and the output files that will be created without actually doing anything.

-q

Turns on quiet mode which suppresses progress reporting. Use this option when processing large files since progress reporting slows down the program a little bit.

-s SeparatorChar

Used with -t TEXT output type. Specify the field delimiter character to be used (typically ",", ":", etc).

-w

Overwrite output file(s) as needed. Existing files will NOT be overwritten unless this option is used.

Click here for some usage examples.