我正在尝试保存在Rails App上具有Unicode字符的CSV的信息,
代码错误说:
IngorterController中的TypeError#upload
没有将字符串的隐式转换为哈希
,问题出现在此行
@csv = SmarterCSV.process(params[:csv].tempfile, "r:bom|utf-8")
编辑在这里日志
Started POST "/importer/upload" for 127.0.0.1 at 2018-02-14 17:46:31 +0100
Processing by ImporterController#upload as HTML
Parameters: {"utf8"=>"✓", "authenticity_token"=>"rnz9HzM4aKALO2By3YtSbADmdAEhW4C+iv+9XAB3JArI/B8DAYkGdrJDULCA20p+Hx2APP4yErP9YSycsGfxdA==", "csv"=>#<ActionDispatch::Http::UploadedFile:0x007fd80801c1f0 @tempfile=#<Tempfile:/tmp/RackMultipart20180214-26318-zurnez.csv>, @original_filename="got_characters.csv", @content_type="text/csv", @headers="Content-Disposition: form-data; name="csv"; filename="got_characters.csv"rnContent-Type: text/csvrn">, "commit"=>"Upload"}
Completed 500 Internal Server Error in 1ms (ActiveRecord: 0.0ms)
TypeError (no implicit conversion of String into Hash):
app/controllers/concerns/character_mock.rb:46:in `import_create'
app/controllers/importer_controller.rb:6:in `upload'
Rendering /home/marcos/.rvm/gems/ruby-2.4.0@hbo/gems/actionpack-5.0.6/lib/action_dispatch/middleware/templates/rescues/diagnostics.html.erb within rescues/layout
已解决!
最后,需要在MySQL上更改桌子以使用UTF8MB4而不是UTF8,然后:
File.open(params[:csv].tempfile, "r:bom|utf-8") do |csv|
chars = SmarterCSV.process(csv);
chars.each do |char|
#Then this will work
Register.create(name: char[:name])
end
end
end
您也可以尝试Register.create(name: char[:name].force_encoding("UTF-8")
似乎在mySQL上的错误会导致这种问题。