class YahookeywordController < ApplicationController
def createfromfile
@importfile = params[:yahookeyword][:importfile]
if @importfile.class.to_s == "String"
# Safari 3 bug
@importdata = @importfile
else
@importdata = @importfile.read
end
csv_import(convert(@importdata))
end
def convert(unicodefile)
s = String.new
unicodefile.each_char do |c|
s<0
# keywords_array << row
# end
# n = n + 1
# end
# Yahookeyword.import(columns, keywords_array, :validate => false)
# puts "CSV Import Successful, #{n} new records added to data base"
n=0
parsed_file.each do |row|
unless n==0
keywords_array << row
if n%1000==0
Yahookeyword.import(columns, keywords_array, :validate => false)
puts "Dumped to db, n = #{n}"
keywords_array.clear
GC.start
end
end
n = n + 1
end
Yahookeyword.import(columns, keywords_array, :validate => false)
puts "CSV Import Successful, #{n} new records added to data base"
GC.start
end
end