xml2csv-conv 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
Usage
Syntax
java -jar xml2csv-conv.jar [-options]
xml2csv-conv [-options]
Options
-l
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001341s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.099735s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001880s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.003123s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001868s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.006098s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001701s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005680s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.023147s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001734s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 97059 [ RunTime:0.004412s ]
