I cannot explain the error below to me. I set col_sep = ";". I also tried a variation of the csv below where empty and integer fields are not quoted.
1.9.3-p194/lib/ruby/1.9.1/csv.rb:1914:in `block (2 levels) in shift': Missing or stray quote in line 1 (CSV::MalformedCSVError)
"ArtNumber";"Title";"Description_Short";"DisplayPrice";"Img_url";"Deeplink1";"ProductCategoryID";"ProductCategoryName";"ImgWidth";"ImgHeight";"ProgramID";"ShopCategoryID";"PricePrefix";"Price";"PriceSuffix";"Currency_Symbol";"Price_old";"Description";"AffilinetProductCategoryID";"AffilinetProductCategoryName";"Img30_url";"Img30Width";"Img30Height";"Img60_url";"Img60Width";"Img60Height";"Img90_url";"Img90Width";"Img90Height";"Img120_url";"Img120Width";"Img120Height";"Img180_url";"Img180Width";"Img180Height";"Deeplink2";"Keywords";"Manufacturer";"Brand";"Distributor";"update_date";"valid_from";"valid_to";"EAN";"ShippingPrefix";"ShippingSuffix";"Shipping_Currency_Symbol";"DisplayShipping";"ProductProgramID";"ProductID";"ImageID";"BasePrice";"BasePriceSuffix";"BasePricePrefix";"BasePrice_Currency_Symbol";"DisplayBasePrice";"Shipping";"gender";"color";"size"
"1716110";"Laufschuh";"Farbe schwarz weiß";"59.90 EUR ";"http://deichmann.scene7.com/is/image/deichmann/1061066_P?$p_img_dm$&defaultImage=default_dsd";"http://partners.webmasterplan.com/click.asp?ref=596937&site=6843&type=text&tnb=15&diurl=http://tracking.metalyzer.com/deichmann/de/click.php?kid=1237&dlid=1&conid=11837&fwid=291906&page=sport%2Fsport-schuhe%2Fsport-schuhe-laufschuhe%2F00000001061066%2FLaufschuh.prod&kw=Laufschuh+-+1716110";"34116842";"Laufschuhe";"300";"300";"6843";"null";"";"59.90";"";"EUR";"100.00";"Farbe schwarz weiß";"215";"Kleidung & Accessoires > Damenschuhe";"http://images30.affili.net/001062/d/8a5ee4cf70c3faa48cf03cd61134940d.jpg";"30";30;"http://images60.affili.net/001062/d/8a5ee4cf70c3faa48cf03cd61134940d.jpg";"60";"60";"http://images90.affili.net/001062/d/8a5ee4cf70c3faa48cf03cd61134940d.jpg";"90";"90";"http://images120.affili.net/001062/d/8a5ee4cf70c3faa48cf03cd61134940d.jpg";"120";"120";"http://images180.affili.net/001062/d/8a5ee4cf70c3faa48cf03cd61134940d.jpg";"180";"180";"";"";"Puma";"";"";"07/27/12";"";"";"";"";"";"EUR";"0.00 EUR ";"1062";"574611019";"314956010";"";"";"";"EUR";"";"0.00";"Unisex";"blau";"8M,8.5M,9M,9.5M,10M,10.5M,11M,11.5M,7.5M"