Search Results for "convert xml to sql"

Convert xml to csv, like extract only nodes /CATALOG/CD/TITLE, /CATALOG/CD/ARTIST, /CATALOG/CD/PRICE in format PostgreSQLCsv java -jar xml2csv-1.0.jar -f PostgreSQLCsv -o '/CATALOG/CD/TITLE, /CATALOG/CD/ARTIST, /CATALOG/CD/PRICE' test/cd_catalog.xml

...It was created for performance engineers to be able to have a easy way to compare data from two testruns and be able to automate the comparing process of various files with scripts. There is a command line tool as well as a user interface. In case you need to compare .xml-Files you can convert them to .csv-Files with my other project CSV Transformer. The advantages by using CSV as input and output are the following: - Many applications allow an export of its data to CSV or Excel(were it could be saved to CSV) - It is possible to pre- and postprocess the data, e.g removing version numbers before comparing - It is easy to create CSV data from logfiles and other resources by using unix tools like sed or awk - CSV can be loaded into other applications, especially Excel, were it can be formatted by macros for analyzing.