CSV Import with Nested Set problem


#1

Hi all,

Am struggling to get this to work:

I am importing CSV file into the database.

This is my code

def import

  file = params[:import][:file]
  row_count=0

    FasterCSV.parse(file, :headers => true) do |food|

      import_this_row = {:id => food[0],
                 :recipe_name => food[1],
                 :recipe_id=> food[2],
                 :reference => food[3],


           }

          @recipes = Recipe.new(import_this_row)

  @recipe.save!
             end

end

The problem comes with recipe_id where I am using awesome_nested_type
and in the csv file I have this under the recipe_id rows:
Food|Beverages|Pineapple Shake
Food|Snacks|Burger

Now when I import I need to get the id of the recipe_id after reading
the name mentioned in the row.

Could anyone please guide me with this…

Cheers

Sam