Script for generating checkins from a CSV on my website

checkins.rb

require "csv"

for c in CSV.foreach("cafes.csv", :quote_char => '"', :col_sep =>', ', :headers => true)
    slug = c['place_name'].downcase.gsub(/[^a-z0-9]+/i, '-')

    front_matter = "
---
layout: checkin
latitude: #{c["lat"]}
longitude: #{c["long"]}
title: #{c['place_name']}
city: #{c['city']}
country: #{c['country']}
permalink: /checkins/#{c['city'].downcase + "/" + slug}
map: true
"

    if c['rating']
        front_matter += "rating: #{c['rating']}\n"
    end

    if c['description']
        front_matter += "notes: #{c['description']}"
    else
        front_matter += "zoom: 10"
    end

    front_matter += "\n---\n\n"

    city_folder = "_checkins/#{c["city"].downcase}"

    if !File.directory?(city_folder)
        Dir.mkdir(city_folder)
    end
    
    File.open("_checkins/#{slug}.md", "w+") do |f|
        f.write(front_matter)
    end

    puts front_matter
end