Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

Perl Automated CSV or XML to MySQL?

by jdlev (Scribe)
on Sep 16, 2013 at 18:36 UTC ( #1054324=perlquestion: print w/ replies, xml ) Need Help??
jdlev has asked for the wisdom of the Perl Monks concerning the following question:

Can anyone recommend a good module that will go to a website, download a csv file or parse an xml file, and then create a new table in a mysql database with the information? TIA :)
I love it when a program comes together - jdhannibal

Comment on Perl Automated CSV or XML to MySQL?
Re: Perl Automated CSV or XML to MySQL?
by davido (Archbishop) on Sep 16, 2013 at 19:08 UTC

    Along the way you're going to discover LWP::UserAgent, WWW::Mechanize, and a few others that facilitate scraping.

    You'll probably end up using a module like Text::CSV. And for your XML... there are dozens of parsers on CPAN. But there's one that looks very useful for your situation: XML::EasySQL. I've got no experience with it, but if it works as advertised... *wow*!


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1054324]
Approved by ww
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (15)
As of 2015-05-22 18:54 GMT
Find Nodes?
    Voting Booth?

    In my home, the TV remote control is ...

    Results (464 votes), past polls