A simple csv import function to my Rails application

81 views
Skip to first unread message

Anders Andrew

unread,
Jun 9, 2012, 11:42:45 AM6/9/12
to rubyonra...@googlegroups.com
Hi.

I am in the process of making an application that should handle imports
of the content csv. I plan on incorporating AJAX when I get more routine
(so the page don't have to redirect back after the upload), but for now
I am looking for the simplest upload function. A file could for example
be (First_name;Last_name;Age;State):

Andrew;McDonald;78;California

I am quite new to Rails, so nothing fancy. Preferably some basic code in
View, Controller and Model.

My sqlite3 database has a table that contains the corresponding columns.

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

Colin Law

unread,
Jun 9, 2012, 12:33:00 PM6/9/12
to rubyonra...@googlegroups.com
Which bit do you need help with, the upload or parsing the data? If
the upload have you tried googling for rails upload?

Colin

>
> --
> Posted via http://www.ruby-forum.com/.
>
> --
> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
> To post to this group, send email to rubyonra...@googlegroups.com.
> To unsubscribe from this group, send email to rubyonrails-ta...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
>

Anders Andrew

unread,
Jun 9, 2012, 1:07:49 PM6/9/12
to rubyonra...@googlegroups.com
Colin Law wrote in post #1063851:
> On 9 June 2012 16:42, Anders Andrew <li...@ruby-forum.com> wrote:
>> I am quite new to Rails, so nothing fancy. Preferably some basic code in
>> View, Controller and Model.
>>
>> My sqlite3 database has a table that contains the corresponding columns.
>
> Which bit do you need help with, the upload or parsing the data? If
> the upload have you tried googling for rails upload?
>
> Colin

Hi Colin.

I think that what I am looking for is something this:

http://stdlib.rubyonrails.org/libdoc/csv/rdoc/classes/CSV/Reader.html

I have tryed implementing the one from this article:

http://satishonrails.wordpress.com/2007/07/18/how-to-import-csv-file-in-rails/

But get this error message: "uninitialized constant CSV::Reader".

Linus Pettersson

unread,
Jun 10, 2012, 8:28:38 AM6/10/12
to rubyonra...@googlegroups.com
Have you added
require 'csv'
?
Reply all
Reply to author
Forward
0 new messages