xml2csv

NAME

SYNOPSIS

xml2csv [ { -l fieldname | -k fieldlist | -i fieldlist | -e emptydata | -s separator } ] ( sourcefile | URL ) destinationfile

AVAILABILITY

DESCRIPTION

xml2csv is command line tool for converting data from XML schema to CSV. The tool has many command line options. The software is platform independent and was written in Java language.

Features:

-

Converts XML schema to CSV file

-

Can deal with filenames and urls

-

Automatically detects loops (repeated elements) in XML used for splitting data to rows

-

Allows to override name of the loop/repeated field

-

Allows to keep only specific tags/fields

-

Allows to ignore specific tags/fields

-

Allows to set values for empty data and CSV separator

-

Supports distinct option

-

Platform Independent

OPTIONS

-h

usage message.

-l fieldname

set the name of the field that repeats in XML schema.

-k fieldlist

comma separated list of fields to be kept.

-i fieldlist

comma separated list of fields to be ignored.

-e emptydata

data to be used for empty fields.

-s separator

field separator in CSV file.

sourcefile | URL

file or url to read the XML data from.

destinationfile

CSV file to write the data to.

ENVIRONMENT

EXIT STATUS

0

always.

FILES

EXAMPLES

  xml2csv -l field -i city,country -d -s "," data.xml data.csv
  xml2csv -k "name, surname" data.xml data.csv
  xml2csv http://www.example.com/data.xml data.csv
  xml2csv data.xml data.csv

SEE ALSO

NOTES

BUGS

AUTHOR

COPYRIGHT

This is free software; see WA2LWinTools/man/COPYING for copying conditions. There is ABSOLUTELY NO WARRANTY; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.