Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

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

Replies are listed 'Best First'.
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 all is quiet...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (3)
As of 2017-08-18 02:18 GMT
Find Nodes?
    Voting Booth?
    Who is your favorite scientist and why?

    Results (294 votes). Check out past polls.