Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

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
Corion is in a similar situation.#

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (16)
As of 2017-01-16 14:14 GMT
Find Nodes?
    Voting Booth?
    Do you watch meteor showers?

    Results (150 votes). Check out past polls.