Re^2: DBD::CSV::st execute failed:

Thank you, Tux. I have removed the file extension .csv, and I note your comments on case sensitivity - all table headings etc are lower case and the csv file is correctly cased - if that is the right expression - as newCsv.csv.

Sadly, I still get the same error messages. Still seeking divine guidance from the Monastery!!

Comment on Re^2: DBD::CSV::st execute failed:

Replies are listed 'Best First'.
Re^3: DBD::CSV::st execute failed: by erix (Prior) on May 28, 2016 at 10:52 UTC
It might be handy to post a part of the file, perhaps a `head -n 20` (that is to say, the first 20 lines) so that experimentation is easier. (and the actual filename)	[reply] [d/l]
Re^4: DBD::CSV::st execute failed: by Sandy_Bio_Perl (Beadle) on May 28, 2016 at 11:48 UTC
Hello again erix, here are the first 4 colums (sid, genotype, gender and tgroup, together with the first 19 rows of data. Thanks for helping me. `sid genotype gender tgroup 1 c female 3 2 b male 3 3 c male 3 4 b male 1 5 c female 3 6 b male 1 7 a female 2 8 a male 3 9 d male 1 10 a female 2 11 d male 2 12 d female 2 13 d male 2 14 d female 1 15 d female 4 16 d female 2 17 d male 3 18 c male 1 19 a male 1` [download]	[reply] [d/l]
Re^4: DBD::CSV::st execute failed: by Sandy_Bio_Perl (Beadle) on May 28, 2016 at 11:32 UTC
Thank you erix. The headings of my spreadsheet, which is called newCsv.csv (that is the correct case sensitivity) are Headings of spreadsheet are: sid name genotype gender tgroup dnabl dnatw2 dnatw4 dnatw8 dnatw12 dnatw16 dnatw24 dnatw48 dnatw8-bl eagabscr eagabbl eagabtw12 eagabtw24 eagabtw48 altscr altbl alttw2 alttw4 alttw8 alttw12 alttw16 alttw24 alttw48 coretcellbl coretcelltw4 coretcelltw8 coretcelltw12 coretcelltw16 coretcelltw24 coretcelltw48 surfacetcellbl surfacetcelltw4 surfacetcelltw8 surfacetcelltw12 surfacetcelltw16 surfacetcelltw24 surfacetcelltw48 hla_a_1 hla_a_2 hla_b_1 hla_b_2 drb1_1 drb1_2 drb3_1 drb3_2 drb4_1 drb4_2 drb5_1 drb5_2 x_1 x_2 Is that what you wanted?	[reply] [d/l]