Perl Automated CSV or XML to MySQL?

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?

Replies are listed 'Best First'.
Re: Perl Automated CSV or XML to MySQL? by davido (Cardinal) 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	[reply]
Re^2: Perl Automated CSV or XML to MySQL? by Anonymous Monk on Sep 17, 2013 at 08:25 UTC
cough DBD::AnyData	[reply]