wrburgess/import_and_parse_remote_csv_rails.md

Created November 3, 2014 14:24

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/wrburgess/ea0869979accad8172d3.js"></script>
Save wrburgess/ea0869979accad8172d3 to your computer and use it in GitHub Desktop.

Import and parse remote csv with Rails

Raw

import_and_parse_remote_csv_rails.md

require 'csv'
require 'open-uri'

csv_text = open('http://www.vvv.hh.yyy.ggg/~hhhh/uuuu.csv')
csv = CSV.parse(csv_text, :headers=>true)
csv.each do |row|
  puts row
end

ref: http://stackoverflow.com/questions/11426475/this-code-is-able-to-read-a-csv-file-from-file-system-but-what-about-reading-fro

wowremywang commented Dec 30, 2019

What is the way to read CSV file in SFTP server?