Import CSV Files from a directory in order to seed a database on Rails

Question

I need to seed a database with a lot of records from some Excel files, but I will only use those CSV files once because after seeding the database the other records will be input from forms.

My boss told me to put the CSV files in a directory in the project and then get the records from those files to the database.

I'm using MongoDB on Rails.

I don't want the full code, just some guidance with gems, logic, etc.

Most DBMs have ways of importing directly from CSV files. Why not take advantage of their built-in, pre-tested, executables rather than write your own? — the Tin Man, May 08 '15 at 00:06

score 1 · Accepted Answer · answered May 07 '15 at 16:28

1

If it's for a one-off import, why not use something like this nice gist or MongoDB's own tool, mongoimport (which can accept CSVs)

answered May 07 '15 at 16:28

Mario

1,349
11
16

score 0 · Answer 2 · answered May 07 '15 at 18:22

0

You need the CSV library. From the docs:

arr_of_arrs = CSV.read("path/to/file.csv")

This will give you a 2D array which you can process as you like. CSV similar to IO.read, but with a few extras such as header parsing.

answered May 07 '15 at 18:22

Brian Davis

357
3
7

Import CSV Files from a directory in order to seed a database on Rails

2 Answers2

Linked