in reply to Convert CSV export from Outlook - MySQL

Maybe I'm missing it, but I don't see the DBD::CSV doing anything for you that Text::CSV wouldn't do faster, better, and cheaper. You're pulling out the columns in their natural order, and using them all.

Am I missing something, or are you using a jackhammer to drive a nail?

-- Randal L. Schwartz, Perl hacker

  • Comment on •Re: Convert CSV export from Outlook - MySQL

Replies are listed 'Best First'.
Re: •Re: Convert CSV export from Outlook - MySQL
by George_Sherston (Vicar) on Jun 25, 2002 at 00:03 UTC
    You're quite right... that's to say, I'm not using DBD::CSV because I want all its features, only because I know how to use it. As an enthusiast for power tools, the idea of using a jackhammer to drive a nail appeals... sure does drive that nail. But you're quite right, if I were optimising for anything but my own time, I'd want something without the overhead - and you're quite right to point that out here for benefit of posterity. /me takes his lumps :)

    § George Sherston
[reply]
      I used your script but whenever I run the perl script it inserts a blank row in mysql. Can anyone tell me why it happens and it the command line I get also this error. DBD::CSV::st execute failed: Missing first row at /usr/local/share/perl/5.6.1/DBD/CSV.pm line 171. Missing first row at /usr/local/share/perl/5.6.1/DBD/CSV.pm line 171. Arunav Mandal. dibun@hotmail.com
[reply]
        This tool does it in minutes www.geniusconnect.com
[reply]

In Section Code Catacombs