Using Mechanize to Populate Neatline w/ Geocoded Information

points.csv

upload.rb

require 'mechanize'
require 'csv'
 
agent = Mechanize.new {|a|
	a.user_agent_alias = 'Mac Safari'
}
 
agent.get('http://localhost:8888/omeka/admin/') do |page|
	omeka_page = page.form_with(:action => '/omeka/admin/users/login') do |form|
		form.username = 'username'
		form.password = 'password'
	end.submit
 
	CSV.foreach('./points.csv', :headers => true) do |line|
 
		# add logic to fill out form
		# click on items
		item_page = agent.click(omeka_page.link_with(:text => %r/Items/))
		# click on add items
		add_item_page = agent.click(item_page.link_with(:text => %r/Add an Item/))
 
 
		# Add the item to the form
		add_item_page.form_with(:method => 'POST') do |item_form|
				item_form['public'] = 1
				item_form.checkbox_with(:name => 'public').check
				item_form['Elements[50][0][text]'] = "#{line["location"]}"
				
				item_form.add_field!('Elements[38][0][zoom]',10)
				item_form.add_field!('Elements[38][0][mapon]',1)
				item_form.add_field!('Elements[38][0][html]',0)
				item_form.add_field!('Elements[38][0][free]',"")
				item_form.add_field!('Elements[38][0][geo]',line["point"])
				item_form.add_field!('Elements[38][0][base_layer]',"osm")
				item_form.add_field!('Elements[38][0][center_lon]',line["point"].gsub("POINT(","").gsub(")","").split(" ").first)
				item_form.add_field!('Elements[38][0][center_lat]',line["point"].gsub("POINT(","").gsub(")","").split(" ").last)
				item_form.add_field!('Elements[38][0][text]',"#{line["point"]}|10|#{line["point"].gsub("POINT(","").gsub(")","").split(" ").first}|#{line["point"].gsub("POINT(","").gsub(")","").split(" ").last}|osm")
				
				item_form['Elements[40][0][text]'] = line["date"]
				item_form['Elements[48][0][text]'] = line["voyage"]
				item_form['Elements[51][0][text]'] = line["type"]
		end.submit
	end
end