ruby-on-rails - FasterCSV:读取远程 CSV 文件

Question

我似乎无法让它工作。我想从不同的网络服务器中提取 CSV 文件以在我的应用程序中读取。我想这样调用它:

url = 'http://www.testing.com/test.csv'
records = FasterCSV.read(url, :headers => true, :header_converters => :symbol)

但这行不通。我试过谷歌搜索，我得到的只是这段摘录:Practical Ruby Gems

所以，我尝试修改如下:

require 'open-uri'
url = 'http://www.testing.com/test.csv'
csv_url = open(url)
records = FasterCSV.read(csv_url, :headers => true, :header_converters => :symbol)

... 我得到一个can't convert Tempfile into String 错误(来自 FasterCSV gem)。

谁能告诉我如何让它工作？

Answer 1

require 'open-uri'
url = 'http://www.testing.com/test.csv'
open(url) do |f|
  f.each_line do |line|
    FasterCSV.parse(line) do |row|
      # Your code here
    end
  end
end

http://www.ruby-doc.org/core/classes/OpenURI.html http://fastercsv.rubyforge.org/