XML Conversion Utility

From FPDS-NG

This download is available to all FPDS-NG users interested in analyzing and comparing the data contained in XML files. Specifically, the XML Conversion Utility allows you to convert large XML files to delimited text files.

Please click on the file name to download this tool.

 Version 1.2 Version 1.3
File Name:

XMLConversionUtilitySP2.0.zip (Windows),
XMLConversionUtilitySP2-0-linux.tar (Linux)

XMLConversionUtilitySP10.0.zip (Windows),
XMLConversionUtilitySP10-0-linux.tar (Linux)
Version: 2.0 1.0
Date Published: September 23, 2008June 05, 2009
Download Size: 25.6 MB (Windows), 30.3 MB (Linux) 30.01 MB (Windows), 117.31 MB (Linux)

Overview The XML Conversion Utility converts an XML file into a pipe (|) delimited output file. This tool is extremely helpful for users who want to:

  • Import large XML files into a tool that reads delimited text, such as Excel.
  • Extract reports from XML files.

System Requirements

  • Supported Operating Systems: Linux, Windows XP/NT/2000
  • Java 1.5 or higher

Instructions To download this utility, click the file name and specify a directory to which you want to copy the tool. This downloads the zip file for the utility to the directory you specify. The zip file includes the program executable (XMLConversionUtility.exe), support files (in the lib directory), and sample files (XSLT and XML). Open the program executable to start using the utility.

Specifying the Input Files and Output File: On the XML File Conversion tab, there are three fields from which you can select or specify the input and output files to use when running the utility:

FieldDescription
Input XML FileSelect the Extensible Markup Language (XML) file that you want to convert. The file consists of tags and text.
Input XSLT File Select the Extensible Stylesheet Language Transformations (XSLT) file to use for the conversion. This file specifies the formatting of the XML file.
Output File Specify an output file name to use for the conversion. This file will be the pipe (|) delimited text file that the utility generates. You can also select an existing text file to use as the output file; the utility will append the converted XML to the file.

Converting the XML File: Once you specify the input files and the output file, click the Convert XML File button to start the XML file conversion. The process indicator updates you on the status of the conversion process. When the process is complete, the indicator states that:

Conversion complete: output file created.

Note: The conversion time varies based on the size of the XML file; for XML files that are quite sizable the conversion time will be greatly increased. See "Utility Processing Statistics" in the utility help for more information.

After the conversion is complete, you can manipulate the output file as needed by opening it or copying it from its directory.

For Additional Information: Click the Help menu item in the utility window to access the help.