Just another Perl shrine | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
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) In reply to Re: Best method to load a csv file.
by jcoxen
|
|