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