From: "Abu A." <abua66@...>
Date: 2011-02-09T02:33:46+09:00
Subject: Re: Q about the FasterCSV

I'm trying to upload data into the database and I've done so using
paperclip.  However, l am having trouble loading the contents into the
database using fastercsv.  I am using Hobo, but I suppose after managing
to upload the csv file its standard RoR.

This is my model:

import.rb:

class Import < ActiveRecord::Base

 hobo_model # Don't put anything above this

 fields do
   datatype :string
   abu  :string
   paul :string
   age :integer
  timestamps
 end

 # Paperclip
         has_attached_file :csv
         validates_attachment_presence :csv
         validates_attachment_content_type :csv, :content_type =>
['text/csv','text/comma-separated-values','text/csv','application/csv','application/excel','application/vnd.ms-excel','application/vnd.msexcel','text/anytext','text/plain']

this works fine and it loads the csv file in public/systems/csvs

I am having trouble using Fastercsv to load the contents into the
database.

Can you point me to the right direction with this please.

Thanks in advance.

Abu

-- 
Posted via http://www.ruby-forum.com/.