I’m using FasterCSV to upload some csv files and create some records
based off the data in the CSV files. I’m pretty sure the problem is a
character encoding issue because the CSV is full of French and German
words. If I remove all the accents off the letters, then it uploads
fine, otherwise it just throws a FasterCSV::MalformedCSVError.
jeremy-woertinks-imac:winovations jeremywoertink$ file -I
~/Downloads/example.csv
/Users/jeremywoertink/Downloads/example.csv: text/plain;
charset=iso-8859-1
I’m using
jeremy-woertinks-imac:winovations jeremywoertink$ ruby -v
ruby 1.8.7 (2010-08-16 patchlevel 302) [i686-darwin9.8.0]
gem ‘rails’, ‘3.0.1’
gem ‘fastercsv’, ‘1.5.3’
Is there a way to set the default encoding for FasterCSV? I looked
through the docs and didn’t see it, and most my google searches turned
up people wanting the encoding to be UTF-8, but I don’t think that’s
what I should be using.
Any ideas?
Thanks,
~Jeremy