sub!': invalid byte sequence in UTF-8 about activewarehouse-etl HOT 4 CLOSED

Nevermind with that for now... I forced mysql to export to UTF-8 some of the csv file. and it fixed the issue..

from activewarehouse-etl.

My understanding is that your file is encoded in ISO-8859-1 and that you work by default with UTF-8, is that right?

Based on Ruby 1.9 CSV doc, you will have to provide an :encoding option to tell the parser that the source is in ISO-8859-1, or to modify Encoding::default_external (but then it's a general setting affecting all your reads).

You should be able to pass the :encoding option without having to hack the source code (the options are propagated from the DSL to the line you pointed if I'm right).

Alternatively you may want to preprocess the file if you prefer (I tend to do that in a first pass).

Can you check if passing the :encoding option works for you? If it works, we'll close this issue and open a documentation issue instead, this will certainly become a FAQ.

from activewarehouse-etl.

I missed your comment while writing mine! Ok - I'll close this one (but it probably needs some documentation here).

from activewarehouse-etl.

Yes! adding to the doc would help for sure :) That would be a nice to know for the future :)

from activewarehouse-etl.