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

Re: Best method to load a csv file.

by jcoxen (Deacon)
on Dec 17, 2004 at 16:53 UTC ( [id://415691]=note: print w/replies, xml ) Need Help??


in reply to Best method to load a csv file.

Re: Text::CSV::Simple - it does just what it's names implies. It makes loading CSV files simple. The thing is, you still have to manipulate them once you've loaded them. And it doesn't help you write the files out to your database.

I'm using that module right now on a project I'm working on to load a bunch of CVS files. Some of them, I only load certain fields, some I load everything, some I load everything but then throw away certain fields or load a pair of fields into a hash. Text::CSV::Simple is a great help for all of this...but only on the input side.

Import the CSV files, manipulate them as necessary and then take trammell's suggestion and use the data import function on your database program.

Jack

Cogito cogito, ergo cogito sum
(I think I think, therefore I think I am)

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others learning in the Monastery: (7)
As of 2024-04-24 10:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found