Re: DBD::CSV and skip_first_line

2013-01-29 Thread Scott R. Godin
On 11/26/2012 11:56 AM, H.Merijn Brand wrote: >> I still think it would be easier if skip_first_line were not presumed >> > (forced to) false if col_names is set, but rather presumed false only if >> > not set explicitly true. > > We agree, investigating what is actually required (and should be > d

Re: DBD::CSV and skip_first_line

2012-11-26 Thread Scott R. Godin
On 11/26/2012 11:56 AM, H.Merijn Brand wrote: > Can you attach the first 4 lines of your csv datafile? Here is some randomized data that closely resembles the data in the csv if this is any help in working with variations on $dbh->prepare(q{Select key, PHM_ID, DAW_CD, GENBRND_CD from clms limit 1

Re: DBD::CSV and skip_first_line

2012-11-26 Thread Scott R. Godin
On 11/26/2012 11:56 AM, H.Merijn Brand wrote: > On Mon, 26 Nov 2012 11:49:49 -0500, "Scott R. Godin" > wrote: > > On 11/25/2012 04:16 AM, Jens Rehsack wrote: >>> On 25.11.12 10:00, H.Merijn Brand wrote: On Fri, 23 Nov 2012 17:43:50 -0500, "Scott R. Godin" wrote: > I've run into an i

Re: DBD::CSV and skip_first_line

2012-11-26 Thread Scott R. Godin
On 11/25/2012 04:16 AM, Jens Rehsack wrote: > On 25.11.12 10:00, H.Merijn Brand wrote: >> On Fri, 23 Nov 2012 17:43:50 -0500, "Scott R. Godin" >> wrote: >> >>> I've run into an issue where I need both col_names set and >>> skip_first_line still set to TRUE, because of malformed colnames in the >>

Re: DBD::CSV and skip_first_line

2012-11-26 Thread H.Merijn Brand
On Mon, 26 Nov 2012 12:29:25 -0500, "Scott R. Godin" wrote: > On 11/26/2012 11:56 AM, H.Merijn Brand wrote: > > On Mon, 26 Nov 2012 11:49:49 -0500, "Scott R. Godin" > > wrote: > > > > On 11/25/2012 04:16 AM, Jens Rehsack wrote: > >>> On 25.11.12 10:00, H.Merijn Brand wrote: > On Fri, 23 Nov

Re: DBD::CSV and skip_first_line

2012-11-26 Thread H.Merijn Brand
On Mon, 26 Nov 2012 11:49:49 -0500, "Scott R. Godin" wrote: > > On 11/25/2012 04:16 AM, Jens Rehsack wrote: > > On 25.11.12 10:00, H.Merijn Brand wrote: > >> On Fri, 23 Nov 2012 17:43:50 -0500, "Scott R. Godin" > >> wrote: > >> > >>> I've run into an issue where I need both col_names set and >

Re: DBD::CSV and skip_first_line

2012-11-25 Thread Jens Rehsack
On 25.11.12 10:00, H.Merijn Brand wrote: On Fri, 23 Nov 2012 17:43:50 -0500, "Scott R. Godin" wrote: I've run into an issue where I need both col_names set and skip_first_line still set to TRUE, because of malformed colnames in the original dumpfiles that conflict with SQL Reserved Words (such

Re: DBD::CSV and skip_first_line

2012-11-25 Thread H.Merijn Brand
On Fri, 23 Nov 2012 17:43:50 -0500, "Scott R. Godin" wrote: > I've run into an issue where I need both col_names set and > skip_first_line still set to TRUE, because of malformed colnames in the > original dumpfiles that conflict with SQL Reserved Words (such as 'key') > that I am unable to find