XML to MySQL and CSV and Excel

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hello Monks,

Can you pls guide me to select the (best) perl modules which can be used to convert the following,

(1)XML to CSV

(2)XML to MySQL

(3)XML to Excel

Thanks in advance.

Comment on XML to MySQL and CSV and Excel

Replies are listed 'Best First'.

Re: XML to MySQL and CSV and Excel
by marto (Cardinal) on May 05, 2013 at 16:52 UTC

You want to read an XML file and output it to various formats. Use one XML library for input, parse the data into a data structure which makes sense, do whatever processing you need. XML::Simple XML::Twig come to mind, depending on your exact requirements, some research is needed on your part. For the rest of your requirements use the data structure you created to output to the required targets using the following modules:

[reply]

Re: XML to MySQL and CSV and Excel
by Anonymous Monk on May 06, 2013 at 06:53 UTC

join - join two files according to a common key
part - split up files according to column value
Merge two files with similar column entries
Opening multiple files ( csvpaste.pl )
Open multiple file handles?
X, Y Table structure
How to extract the particular residues from PDB files(text csv split hash bioperl)
Select only desired features from a text (text csv split hash bioperl)
Sort on Table headers (text csv split hash bioperl)
I need help joining tab-delimited files/tables!
split then join based on common value in field
Smart way to read a file vertically?
reformatting tab delimited file
edit a CSV and "in-place" replacement
Re: Reversing a mysql table, transpose-tsv -- invert a tab-delimited table

Text::CSV

examples/csv2xls Script to onvert CSV files to M$Excel

examples/csv-check Script to check a CSV file/stream

examples/csvdiff Script to shoff diff between sorted CSV files

examples/parser-xs.pl Parse CSV stream, be forgiving on bad lines

[CSV hash ] CSV hash: Best way to match a hash with large CSV file; perl hash to CSV using Text::CSV_XS; Issue parsing CSV into hashes?; Veriable Length Array/Hash derived from CSV to populate an XML; extracting data from CSV files and making hash of hashes; Re^2: build hash from csv file; Encoding a hash in perl before saving it as a CSV file; hash from CSV-like structure; Read the csv file to a hash....; Parsing CSV into a hash; build hash from csv file; Converting a CSV list to a list of hashrefs naming the fields

[reply]
[d/l]

Re^2: XML to MySQL and CSV and Excel

by Anonymous Monk on May 06, 2013 at 06:55 UTC

XML::Twig

XML::LibXML

Mojo::DOM

Re: The best module for handling xml

Re: How to grab a portion of file with regex (don't)(parsing html/xml with xpath/twig/dom, because html::parser is low level)

Re: How to grab a portion of file with regex (parsing html/xml with xpath/twig/dom, because xml::parser is low level)

Re^4: How to grab a portion of file with regex (parsing html/xml with xpath/twig/dom, because ::parser is low level)

[reply]