agencies.csv

gistfile3.txt

seeds.rb

# import_agencies_from_file(file_path)
#
# file_path as String
def import_agencies_from_file(file_path)
  # Parse CSV File
  FasterCSV.foreach(file_path) do |row|
    begin
      # Instanciate row variable
      country_name = row[0]
      division_name = row[1]
      agency_name = row[2]
      agencychild_name = row[3]

      # Retrieve Country
      country = Country.find_or_create_by_name(country_name)

      # Retrieve Division
      division = Division.find_or_create_by_name(division_name, :country_id => country.id) { |d| d.country = country}

      # Retrieve Agency
      agency = Agency.find_or_create_by_name(agency_name, :division => division) { |a| a.division = division }

      # Retrieve AgencyChild if there is
      if agencychild_name
        Agency.find_or_create_by_name(agencychild_name, :division => division, :parent_id => agency.id){ |a| a.division = division; a.parent_id=agency.id}
      end
    rescue Exception => e
      p e.message + " / #{row}"
    end
  end
end

########
# Main #
########

# Import Country/Divisions/Agencies from file
import_agencies_from_file('lib/tasks/data/agencies/agencies.csv')