Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
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 lurking in the Monastery: (6)
As of 2014-09-03 02:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite cookbook is:










    Results (35 votes), past polls