From: Dot Baiki <dot_baiki@...>
Date: 2011-01-24T00:21:24+09:00
Subject: Re: FastCSV fcsv and how to keep imported field format (or how to convert it)

Hello again,

This way seems to be right, but now somehow the :header_converters =>
:symbol is not working anymore. This is the header line from the CSV
file:

Emp No.;AC-No.;No.;Name;Auto-Assign;Date;Timetable;On duty;Off
duty;Clock In;Clock Out;Normal;Real time;Late;Early;Absent;OT Time;Work
Time;Exception;Must C/In;Must
C/Out;Department;NDays;WeekEnd;Holiday;ATT_Time;NDays_OT;WeekEnd_OT;Holiday_OT

But since I use read() (even if I use header_converters => :symbol) the
header line is not converted. I really don't understand it anymore. This
is now my header line:

["Emp No.", "AC-No.", "No.", "Name", "Auto-Assign", "Date", "Timetable",
"On duty", "Off duty", "Clock In", "Clock Out", "Normal", "Real time",
"Late", "Early", "Absent", "OT Time", "Work Time", "Exception", "Must
C/In", "Must C/Out", "Department", "NDays", "WeekEnd", "Holiday",
"ATT_Time", "NDays_OT", "WeekEnd_OT", "Holiday_OT"]

Is there no way to say during import/conversion that column "Emp No."
shall be untouched (expect the header conversion)?

This is what I use now:
csv_data = FCSV.read(input_file, :col_sep => ';', :skip_blanks => true,
:header_converters => :symbol)

Thanks for your help JEG2

Regards,
Baiki

-- 
Posted via http://www.ruby-forum.com/.