Hello,
I’m new to Ruby on Rails and I’ve been really enjoying the framework.
I have recently hit a wall that I can’t seem to get around. I’ve
searched to web and haven’t found an answer(and my agile development
with rails book hasn’t arrived)…
My problem: I have a CSV file that has information about recreation
programs, and the buildings that each program is housed in. It is in
a one line format.
So,
Building name | Location | Program name | Description of program |
Time |
Buildings have many programs, but programs only have one building.
I need to import this CSV into a mysql database. I can do this using
migrations and FasterCSV. There are duplicate entries for buildings,
and I only want each building entered into the database once, which I
could use validates uniqueness to ensure.
The wall I’ve encountered is how do I maintain the relationship
between programs and buildings throughout this import process?
Ie I want to be able to list the programs in each building…
Many Thanks and apologies if there is a very obvious solution that I
am missing,
Jay