Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

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*!


    Dave

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (16)
As of 2015-03-30 13:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When putting a smiley right before a closing parenthesis, do you:









    Results (644 votes), past polls