Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

•Re: Convert CSV export from Outlook - MySQL

by merlyn (Sage)
on Jun 24, 2002 at 23:45 UTC ( #176988=note: print w/replies, xml ) Need Help??


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
      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
        This tool does it in minutes www.geniusconnect.com

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (4)
As of 2019-08-23 13:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?