ap_filename_to_id.rake

# S_G_WV_0_49607_1.xml 

 desc "import to db from xml"
  task :import do
    AP_FILES.each do |file|
      a = AP::Import.new(file)
      puts file.inspect      
      file_id = file.gsub(/\/.+\/([A-Z]_[A-Z]_[A-Z]{1,2}_[0-9]{1,2}).*$/){|q| $1.to_s.to_i(36).to_s}
      a.to_db(file_id.to_i)
      puts "imported #{file}"
    end
		#store current seat counts in /public/seat_counts.json
		Race.save_seat_counts
  end