You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@usergrid.apache.org by sn...@apache.org on 2016/02/05 00:01:04 UTC

[26/42] usergrid git commit: Bring in docs and website from master.

http://git-wip-us.apache.org/repos/asf/usergrid/blob/5ed3d753/website/utilities/map-markers.rb
----------------------------------------------------------------------
diff --git a/website/utilities/map-markers.rb b/website/utilities/map-markers.rb
new file mode 100644
index 0000000..4c3fb25
--- /dev/null
+++ b/website/utilities/map-markers.rb
@@ -0,0 +1,62 @@
+require 'rest_client'
+require 'csv'
+require 'json/ext'
+
+rapportive_token = "BAgiX3BYOTZUVXlNalExclVBNWIyazVNcjBxK3UzdURNUnovTXVTamRZVTVmRmNsakw5WGZrUHJIYXFRaVV2YkRYaGctLWNFQjJLUmZNam05cjdmZDEzVGFPL3c9PQ==--71d66f8c1b8eafb0a8f31691b55b95fbce58857a"
+rapportive_qs    = "?viewport_height=325&view_type=cv&user_email=tim.anglade%40gmail.com&client_version=ChromeExtension+rapportive+1.4.1&client_stamp=1382671311"
+
+places = {}
+
+# CSV.foreach("usergrid.csv") do |row|
+# 	begin
+# 		next if row[0].start_with?('Members ')
+# 		next if row[0].start_with?('Email ')
+# 		email = row[0]
+# 		#puts email
+			
+# 		response = RestClient.get "http://profiles.rapportive.com/contacts/email/#{URI.escape(email)}#{rapportive_qs}", {"user-agent" => "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.71 Safari/537.36", "origin" => "https://mail.google.com", "referer" => "https://mail.google.com/mail/u/0/", "x-session-token" => rapportive_token}
+# 		rapportive = JSON.parse(response.to_str)
+			
+# 		next unless rapportive['contact']['location']
+# 		location = rapportive['contact']['location'].gsub(/\sBay\sArea$/,'').gsub(' Area,',',').gsub(/\sArea$/,'').gsub(/^Greater\s/,'')
+
+# 		puts location 
+
+# 		places[location] ? places[location] += 1 : places[location] = 1
+# 	rescue => e
+# 	 	puts e
+# 	 	sleep 10
+# 	 	retry
+# 	end
+# end
+
+# places.each do |place, count|
+# 	puts "\"#{place}\",#{count}"
+# end
+
+places2 = {"Sydney, Australia"=>2, "Provo, Utah"=>1, "San Francisco Bay"=>27, "Bay of Plenty, New Zealand"=>1, "Kenya"=>1, "Istanbul, Turkey"=>2, "Iasi County, Romania"=>1, "Vancouver, Canada"=>2, "United Kingdom"=>3, "Jacksonville, Florida"=>1, "Austin, Texas"=>6, "Brazil"=>1, "Hartford, Connecticut"=>2, "Dublin"=>1, "Melbourne, Australia"=>1, "Egypt"=>1, "Los Angeles"=>7, "Seoul, Korea"=>1, "Sri Lanka"=>2, "Denver"=>6, "Quebec, Canada"=>1, "New York City"=>5, "Minneapolis-St. Paul"=>1, "Turkey"=>2, "Raleigh-Durham, North Carolina"=>3, "Korea"=>4, "Jakarta Selatan"=>1, "Sarasota, Florida"=>1, "Bologna, Italy"=>1, "Philadelphia"=>2, "United States"=>1, "Fort Collins, CO"=>2, "Toronto, Canada"=>2, "Seattle"=>6, "Israel"=>1, "Kingston upon Thames, United Kingdom"=>1, "Valencia, Spain"=>1, "London, United Kingdom"=>2, "Washington D.C. Metro"=>1, "Phoenix, Arizona"=>2, "Portland, Oregon"=>1, "Madison, Wisconsin"=>1, "Greensboro/Winston-Salem, North Carolina"=>1, "San Francisco, CA"=>1, 
 "Penang, Malaysia"=>1, "Asheville, North Carolina"=>1, "China"=>1, "Santa Barbara, California"=>1, "Singapore"=>2, "Norfolk, Virginia"=>1, "Hong Kong"=>3, "Paris, France"=>1, "Madrid, Spain"=>1, "Pune, India"=>3, "nashville, TN"=>1, "Dublin, Ireland"=>1, "Miami/Fort Lauderdale"=>1, "Detroit"=>1, "720 32nd St, Oakland, CA 94609"=>1, "Pensacola, Florida"=>1, "Bucharest, Romania"=>1, "Cleveland/Akron, Ohio"=>1, "Bengaluru, India"=>7, "Ireland"=>1, "Socorro, New Mexico"=>1, "Peru"=>1, "Copenhagen, Denmark"=>1, "Somewhere"=>1, "Istanbul, Turkey"=>1, "Shanghai City, China"=>1, "Atlanta"=>2, "Thiruvananthapuram, India"=>1, "Chennai, Tamil Nadu"=>1, "Melbourne, Florida"=>1, "Maryland"=>1, "Hyderabad, India"=>1, "Sao Paulo, Brazil"=>1, "Utrecht, Netherlands"=>1, "Parbhani, India"=>1, "Mumbai, India"=>1, "Bangalore, Karnataka, India"=>1, "Porto, Portugal"=>1, "Beijing, China"=>1, "Boston"=>1, "Dallas/Fort Worth"=>1, "Greece"=>1, "Mountains"=>1, "Stanford, California"=>1, "Japan"=>1}
+
+countries = {}
+
+places2.each do |place, count|
+	begin
+		response = RestClient.get "http://maps.googleapis.com/maps/api/geocode/json?address=#{URI.escape(place)}&sensor=false"
+		j = JSON.parse(response.to_str)
+		geocoding = j["results"][0]["geometry"]
+		j["results"][0]["address_components"].each do |c|
+			next unless c["types"].include?("country")
+			countries[c["short_name"]] ? countries[c["short_name"]] += 1 : countries[c["short_name"]] = 1
+		end
+
+		#puts "new google.maps.Marker({\nmap:map,\nanimation: google.maps.Animation.DROP,\nposition: new google.maps.LatLng(#{geocoding['location']['lat']},#{geocoding['location']['lng']})\n});"
+		sleep 0.1
+	rescue => e
+ 		puts e
+	end
+end
+
+puts "Found #{countries.size} countries"
+
+
+
+

http://git-wip-us.apache.org/repos/asf/usergrid/blob/5ed3d753/website/utilities/markers.txt
----------------------------------------------------------------------
diff --git a/website/utilities/markers.txt b/website/utilities/markers.txt
new file mode 100644
index 0000000..994555d
--- /dev/null
+++ b/website/utilities/markers.txt
@@ -0,0 +1,440 @@
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(-33.8674869,151.2069902)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(40.2338438,-111.6585337)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(37.6909682,-122.3107517)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(-37.6825027,176.1880232)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(-0.023559,37.906193)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(41.00527,28.97696)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(47.1569444,27.5902778)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(49.261226,-123.1139268)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(55.378051,-3.435973)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(30.3321838,-81.65565099999999)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(30.267153,-97.7430608)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(-14.235004,-51.92528)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(41.76371109999999,-72.6850932)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(53.3498053,-6.2603097)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(-37.814107,144.96328)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(26.820553,30.802498)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(34.0522342,-118.2436849)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(37.566535,126.9779692)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(7.873053999999999,80.77179699999999)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(39.737567,-104.9847179)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(52.9399159,-73.5491361)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(40.7143528,-74.00597309999999)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(44.9374831,-93.20099979999999)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(38.963745,35.243322)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(35.7795897,-78.6381787)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(35.907757,127.766922)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(-6.2689913,106.8060388)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(27.3364347,-82.53065269999999)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(44.494887,11.3426163)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(39.952335,-75.16378900000001)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(37.09024,-95.712891)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(40.5852602,-105.084423)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(43.653226,-79.3831843)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(47.6062095,-122.3320708)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(31.046051,34.851612)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(51.41233,-0.300689)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(39.4699075,-0.3762881)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(51.51121389999999,-0.1198244)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(42.3556899,-83.361853)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(33.4483771,-112.0740373)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(45.5234515,-122.6762071)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(43.0730517,-89.4012302)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(36.1031378,-80.202394)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(37.7749295,-122.4194155)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(5.263234100000001,100.4846227)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(35.5950581,-82.5514869)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(35.86166,104.195397)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(34.4208305,-119.6981901)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(1.352083,103.819836)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(36.8507689,-76.28587259999999)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(22.396428,114.109497)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(48.856614,2.3522219)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(40.4167754,-3.7037902)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(18.5204303,73.8567437)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(36.1666667,-86.7833333)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(53.3498053,-6.2603097)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(26.0993883,-80.1343301)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(42.331427,-83.0457538)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(37.82206000000001,-122.272437)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(30.42130899999999,-87.2169149)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(44.4325,26.1038889)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(41.0700485,-81.49516210000002)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(12.9715987,77.5945627)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(53.41291,-8.24389)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(34.0583995,-106.8914159)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(-9.189967,-75.015152)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(55.6760968,12.5683371)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(53.9807737,-6.7148821)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(31.230416,121.473701)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(33.7489954,-84.3879824)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(8.4874949,76.948623)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(13.0524139,80.25082460000002)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(28.0836269,-80.60810889999999)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(39.0457549,-76.64127119999999)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(17.385044,78.486671)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(-23.5489433,-46.6388182)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(52.09179,5.114569899999999)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(19.2667,76.7833)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(19.0759837,72.8776559)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(12.9715987,77.5945627)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(41.1566892,-8.6239254)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(39.90403,116.407526)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(42.3584308,-71.0597732)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(32.725409,-97.3208496)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(39.074208,21.824312)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(10.066049,123.538599)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(37.42410599999999,-122.1660756)
+});
+new google.maps.Marker({
+map:map,
+animation: google.maps.Animation.DROP,
+	    position: new google.maps.LatLng(36.204824,138.252924)
+});

http://git-wip-us.apache.org/repos/asf/usergrid/blob/5ed3d753/website/utilities/snapshot-apigee.rb
----------------------------------------------------------------------
diff --git a/website/utilities/snapshot-apigee.rb b/website/utilities/snapshot-apigee.rb
new file mode 100644
index 0000000..cda4663
--- /dev/null
+++ b/website/utilities/snapshot-apigee.rb
@@ -0,0 +1,71 @@
+require 'rubygems'
+require 'mechanize'
+require 'anemone'
+require 'pandoc-ruby'
+# require 'json/ext'
+
+TO_REMOVE = [ 'div.toc-filter-back-to-top',
+              '.rate-yesno-title',
+              'colgroup',
+              'div.rate-widget',
+              'div.toc-filter.toc-filter-bullet'  ]
+
+puts "Crawling..."
+
+urls = []
+Anemone.crawl("http://apigee.com/docs/app_services", :skip_query_strings => true) do |anemone|
+  # anemone.on_every_page {|page| puts page.url}
+  # anemone.skip_links_like(/https?\:\/\/apigee.com\/docs\/(comment|node|api-platform|console|ja|enterprise|consoletogo)/)
+  anemone.focus_crawl { |page| page.links.select{|l| l.to_s.match(/https?\:\/\/apigee.com\/docs\/(app-services|usergrid)\/content/) } }
+  anemone.on_pages_like(/https?\:\/\/apigee.com\/docs\/(app-services|usergrid)\/content/) do |page|
+    urls.push page.url
+    # puts "Found #{page.url}"
+  end
+  # anemone.after_crawl {  }
+end
+
+urls = urls.compact.map{|u| u.to_s}.uniq.sort
+
+puts "Found #{urls.size} documentation articles"
+puts urls.join("\n")
+gets
+
+a = Mechanize.new { |agent|
+  agent.user_agent_alias = 'Mac Safari'
+}
+
+urls.each do |url|
+  name = url.split('/')[-1]
+  puts "Processing #{name}"
+  begin
+    a.get(url) do |article|  
+      # title = article.search('h1').first
+      body = article.search('section#block-system-main>div.node>div.field-name-body').first
+      next if body.nil?
+      # body.children.first.add_previous_sibling(title)
+      # body.search('br').each {|l| l.remove}
+      body.search(TO_REMOVE.join(', ')).each {|l| l.remove}
+      body.search('div#collapse').each do |div|
+        div.add_next_sibling '<a id="'+div.attributes['id'].value+'"></a>'
+        div.remove
+      end
+      body.search('h2').each {|h| h.remove_attribute('class')}
+      body.search('*').each{|n| n.remove_attribute('style')}
+      body.search("a").each do |link|
+        begin
+          link.attributes["href"].value = link.attributes["href"].value.gsub(/^\/docs\/app-services\/content\//,'/')
+        rescue
+        end
+      end
+      markdown = PandocRuby.convert(body, :from => :html, :to => :markdown)
+      front_matter = "---\ntitle: #{title.inner_html.gsub(':',' - ')}\ncategory: \nlayout: article\n---\n\n"
+      markdown.gsub!('Apigee App Services', 'Apache Usergrid')
+      markdown.gsub!('App Services', 'Apache Usergrid')
+      markdown.insert(0,front_matter)
+      today = Time.new.strftime('%Y-%m-%d')
+      File.open("../content/docs/#{today}-#{name}.md", 'w') {|f| f.write(markdown) }
+    end
+  rescue Exception => e
+    puts e
+  end
+end
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/usergrid/blob/5ed3d753/website/utilities/usergrid.csv
----------------------------------------------------------------------
diff --git a/website/utilities/usergrid.csv b/website/utilities/usergrid.csv
new file mode 100644
index 0000000..485c7e3
--- /dev/null
+++ b/website/utilities/usergrid.csv
@@ -0,0 +1,290 @@
+Members for group Usergrid
+Email address,Nickname,Group status,Email status,Email preference,Posting permissions,Join year,Join month,Join day,Join hour,Join minute,Join second,Time zone
+0xfleo@gmail.com,,member,,"email","allowed",2013,6,5,18,39,55,America/Los_Angeles
+aaadonai@gmail.com,"AR",member,,"no email","allowed",2012,7,22,23,11,15,America/Los_Angeles
+aaron.allsbrook@gmail.com,"Aaron Allsbrook",member,,"no email","allowed",2013,5,14,12,53,42,America/Los_Angeles
+aaron@lingotek.com,"Aaron Davis",member,,"digest","allowed",2012,7,11,12,1,2,America/Los_Angeles
+aaustin@apigee.com,"Ashley Austin",member,,"no email","allowed",2013,6,11,11,35,17,America/Los_Angeles
+abbdef@gmail.com,"James Hancock",member,,"no email","allowed",2012,7,12,5,12,51,America/Los_Angeles
+achachiez@gmail.com,"Emmanuel Nyachoke",member,,"no email","allowed",2013,4,23,1,0,29,America/Los_Angeles
+achalil@gmail.com,"anil chalil",member,,"no email","allowed",2013,2,14,9,44,55,America/Los_Angeles
+ad2joe@gmail.com,"ad2joe",member,,"abridged","allowed",2012,9,13,0,40,46,America/Los_Angeles
+adam@dymitruk.com,"Adam Dymitruk",member,,"no email","allowed",2013,1,14,12,4,46,America/Los_Angeles
+adam@enigmaticflare.co.uk,"Adam Roberts",member,,"no email","allowed",2012,8,14,23,18,59,America/Los_Angeles
+akaia75@gmail.com,"이현태",member,,"email","allowed",2012,9,3,17,6,46,America/Los_Angeles
+akarasulu@apigee.com,"Alex Karasulu",member,,"no email","allowed",2013,9,26,11,52,54,America/Los_Angeles
+akarasulu@gmail.com,"Alex Karasulu",member,,"no email","allowed",2013,7,16,7,26,18,America/Los_Angeles
+alan.m.shelly@gmail.com,"Alan Shelly",member,,"no email","allowed",2013,3,31,23,12,53,America/Los_Angeles
+alan@apigee.com,"Alan Ho",member,,"abridged","allowed",2013,4,2,9,0,14,America/Los_Angeles
+alberto.alvine@corp.globo.com,"Alberto Leal",member,,"email","not allowed",2013,1,16,7,43,24,America/Los_Angeles
+alexandernetworks@gmail.com,"Kenneth L. Fax",member,,"no email","allowed",2013,6,21,10,48,1,America/Los_Angeles
+alexwhite3000@gmail.com,"Alex White",member,,"no email","allowed",2013,6,2,5,31,36,America/Los_Angeles
+alothien@gmail.com,"Kevin Hoffman",member,,"no email","allowed",2013,10,19,14,31,30,America/Los_Angeles
+alvaro.pereda@gmail.com,"Alvaro Pereda",member,,"no email","allowed",2012,12,7,7,12,56,America/Los_Angeles
+amir.moghimi@gmail.com,"Amir",member,,"abridged","allowed",2012,6,12,21,44,22,America/Los_Angeles
+amr.zagloul@gmail.com,"amr_zagloul",member,,"no email","allowed",2012,2,20,3,27,39,America/Los_Angeles
+amund@appdevs.no,"Amund",member,,"no email","allowed",2012,7,17,5,57,4,America/Los_Angeles
+amuramoto@apigee.com,"Alex Muramoto",member,,"abridged","allowed",2013,7,8,10,9,58,America/Los_Angeles
+angel.marquez@gmail.com,"Angel",member,,"email","allowed",2011,10,3,20,17,41,America/Los_Angeles
+anwithct@gmail.com,"anwith ct",member,,"no email","allowed",2012,10,7,23,42,19,America/Los_Angeles
+askagirl@gmail.com,"fritz lee",member,,"no email","allowed",2012,7,3,1,45,42,America/Los_Angeles
+athyholdt@gmail.com,"Andreas Thyholdt",member,,"abridged","allowed",2013,7,11,3,31,55,America/Los_Angeles
+authenticgeek@gmail.com,"Nick O'Neill",member,,"no email","allowed",2013,2,20,19,23,5,America/Los_Angeles
+avs.nagendra@gmail.com,"Nagendra addepalli",member,,"abridged","allowed",2013,6,20,23,29,59,America/Los_Angeles
+aybars.sogancilar@gmail.com,"aybars",member,,"abridged","allowed",2013,10,1,8,20,41,America/Los_Angeles
+bandara.nuwan@gmail.com,"Nuwan Bandara",member,,"no email","allowed",2013,9,20,7,14,45,America/Los_Angeles
+ben@benatkin.com,"Ben Atkin",member,,"no email","allowed",2013,3,22,14,26,18,America/Los_Angeles
+benbjammin@gmail.com,,member,,"no email","allowed",2013,3,22,14,28,9,America/Los_Angeles
+bernard.franssen@gmail.com,"Bfr",member,,"no email","allowed",2013,3,17,10,31,3,America/Los_Angeles
+bharu0503@gmail.com,"Bharathi R",member,,"no email","allowed",2013,9,4,3,44,7,America/Los_Angeles
+boudreault.alan@gmail.com,"Alan Boudreault",member,,"no email","allowed",2013,6,13,17,51,45,America/Los_Angeles
+bradjonesca@gmail.com,"Brad Jones",member,,"email","allowed",2012,7,12,6,23,33,America/Los_Angeles
+brian@brianchildress.co,,member,,"no email","allowed",2013,3,23,14,45,8,America/Los_Angeles
+broadhigh@gmail.com,"Broadhigh Computer",member,,"abridged","allowed",2013,7,11,18,34,57,America/Los_Angeles
+bryan.martinez@gmail.com,"extra_rice",member,,"digest","allowed",2012,8,7,15,46,17,America/Los_Angeles
+carchrae@gmail.com,"Tom Carchrae",member,,"no email","allowed",2012,4,6,5,48,15,America/Los_Angeles
+carlos.eberhardt@gmail.com,"Carlos Eberhardt",member,,"email","allowed",2012,5,18,19,36,30,America/Los_Angeles
+cengizbilgic85@gmail.com,"cengiz bilgic",member,,"no email","allowed",2012,9,21,1,57,43,America/Los_Angeles
+cetauri@gmail.com,"ohsang.kwon",member,,"no email","allowed",2012,11,27,3,7,50,America/Los_Angeles
+charlieandrews.cwa@gmail.com,"Charlie Andrews",member,,"no email","allowed",2013,5,20,12,53,23,America/Los_Angeles
+charsyam@gmail.com,"Dae-Myung Kang",member,,"no email","allowed",2012,11,29,8,59,21,America/Los_Angeles
+choipd.net@gmail.com,"Myungjin Choi",member,,"no email","allowed",2012,11,30,18,53,44,America/Los_Angeles
+chopade.ritesh23@gmail.com,"Ritesh",member,,"no email","allowed",2013,1,7,1,50,43,America/Los_Angeles
+clee@escalation-point.com,"Cory Lee",member,,"no email","allowed",2013,4,25,13,30,18,America/Los_Angeles
+com.y.naka@gmail.com,"Yusuke NAKA",member,,"no email","allowed",2013,4,2,18,11,36,America/Los_Angeles
+creative.meidy@gmail.com,"meidydoang",member,,"no email","allowed",2012,7,29,21,2,33,America/Los_Angeles
+curioe@gmail.com,"curioe",member,,"no email","allowed",2012,7,25,0,27,26,America/Los_Angeles
+cywjackson@gmail.com,"Jackson Chung",member,,"no email","allowed",2013,10,15,14,54,48,America/Los_Angeles
+dan@code4.com.au,"Dan Miles",member,,"no email","allowed",2012,3,10,20,18,49,America/Los_Angeles
+daniel.simons1@gmail.com,"Daniel Simons",member,,"no email","allowed",2013,7,11,18,38,45,America/Los_Angeles
+dardo82@gmail.com,"Michele Venturi",member,,"no email","allowed",2013,4,26,5,5,55,America/Los_Angeles
+dave.aiello@after6services.com,,member,,"no email","allowed",2013,4,25,15,5,57,America/Los_Angeles
+david.barkman13@gmail.com,"David Barkman",member,,"no email","allowed",2013,1,12,8,55,9,America/Los_Angeles
+davidstoker@gmail.com,"David Stoker",member,,"no email","allowed",2012,9,10,7,1,18,America/Los_Angeles
+dereknkata@gmail.com,"Nkata Derrick",member,,"no email","allowed",2013,6,25,0,46,50,America/Los_Angeles
+deric.crago@gmail.com,"Deric Crago",member,,"no email","allowed",2012,7,12,21,41,35,America/Los_Angeles
+dev.scsu@gmail.com,,member,,"no email","allowed",2013,2,10,9,11,57,America/Los_Angeles
+dfzuluaga@gmail.com,"Diego Zuluaga",member,,"no email","allowed",2013,10,16,13,30,8,America/Los_Angeles
+dhrim00@gmail.com,"dohyoung rim",member,,"no email","allowed",2012,10,18,17,21,28,America/Los_Angeles
+dia.ab88@gmail.com,"Dia",member,,"no email","allowed",2013,2,6,8,29,33,America/Los_Angeles
+dipanjan122@gmail.com,"Deepanjan Majumdar",member,,"no email","allowed",2012,9,14,10,32,44,America/Los_Angeles
+dlewis@sympletech.com,"Daniel Lewis",member,,"no email","allowed",2012,9,14,12,6,49,America/Los_Angeles
+dmjohnson@apigee.com,"Dave Johnson",member,,"email","allowed",2013,9,26,11,34,35,America/Los_Angeles
+dnielsen@gmail.com,"Dave Nielsen",member,,"no email","allowed",2012,11,27,9,19,52,America/Los_Angeles
+dpchiesa@hotmail.com,"Dino Chiesa",member,,"no email","allowed",2012,9,15,16,6,17,America/Los_Angeles
+dulithaz@gmail.com,"Chan",member,,"no email","allowed",2013,9,22,19,39,27,America/Los_Angeles
+e.gunay@gmail.com,"Erdem Gunay",member,,"abridged","allowed",2013,6,23,23,19,20,America/Los_Angeles
+eanuff@apigee.com,"Ed Anuff",owner,,"no email","allowed",2012,8,9,14,53,6,America/Los_Angeles
+earthshipsolutions@gmail.com,"David Davida",member,,"no email","allowed",2013,6,16,10,5,0,America/Los_Angeles
+ed@anuff.com,"Ed Anuff",owner,,"email","allowed",2011,10,2,22,34,11,America/Los_Angeles
+ed@usergrid.com,"Ed Anuff",owner,,"no email","allowed",2011,9,27,14,31,49,America/Los_Angeles
+engin.deveci@gmail.com,"Engin Deveci",member,,"email","allowed",2012,9,4,3,17,59,America/Los_Angeles
+eort@apigee.com,"Ed Ort",member,,"no email","allowed",2012,9,11,11,43,18,America/Los_Angeles
+erhanabay@gmail.com,"Erhan Abay",member,,"abridged","allowed",2013,3,4,23,55,25,America/Los_Angeles
+eric.hanley@gmail.com,"eric",member,,"email","allowed",2012,6,25,10,38,22,America/Los_Angeles
+esecilakbas@gmail.com,"Ece Seçil AKBAŞ",member,,"abridged","allowed",2013,2,28,13,2,22,America/Los_Angeles
+esentuna1@gmail.com,"Esen Tuna",member,,"email","allowed",2013,2,25,23,18,5,America/Los_Angeles
+evyatar@doat.com,"Evyatar",member,,"no email","allowed",2012,7,23,23,1,48,America/Los_Angeles
+evyatron@gmail.com,,member,,"no email","allowed",2012,12,15,14,1,8,America/Los_Angeles
+feedback@apigee.com,"Apigee Feedback",member,,"no email","allowed",2013,5,28,15,3,7,America/Los_Angeles
+fernando@zenksworld.com,"Fernando Tomé",member,,"no email","allowed",2013,4,16,8,40,17,America/Los_Angeles
+feroz.panwaskar@gmail.com,"Feroz Panwaskar",member,,"no email","allowed",2013,5,15,9,0,0,America/Los_Angeles
+flozano@gmail.com,"Francisco Alejandro Lozano López",member,,"no email","allowed",2011,11,15,17,56,47,America/Los_Angeles
+garifuna@gmail.com,"Jorge Garifuna",member,,"email","allowed",2012,7,28,1,44,31,America/Los_Angeles
+garlandk@gmail.com,"gar",member,,"no email","allowed",2012,3,24,15,53,2,America/Los_Angeles
+george@mobitroll.no,"george",member,,"no email","allowed",2012,12,10,8,37,24,America/Los_Angeles
+gertjvr@gmail.com,"Gert Jansen van Rensburg",member,,"no email","allowed",2012,6,28,22,24,5,America/Los_Angeles
+ggem@acm.org,"ggem",member,,"abridged","allowed",2013,3,23,14,44,13,America/Los_Angeles
+ghartstein@gmail.com,"hartsteins",member,bouncing,"no email","allowed",2012,11,9,10,0,29,America/Los_Angeles
+gilberts55@gmail.com,"Gilbert EKOUE",member,,"no email","allowed",2013,8,28,11,15,9,America/Los_Angeles
+google@dbsolutions.net,"Dwight Barbour",member,,"no email","allowed",2013,8,19,21,13,56,America/Los_Angeles
+gorla.patricia@gmail.com,"Patricia Gorla",member,,"no email","allowed",2013,10,1,12,40,33,America/Los_Angeles
+grewis@apigee.com,"Greg Rewis",member,,"no email","allowed",2013,10,8,17,32,1,America/Los_Angeles
+gtrmjz@gmail.com,"Robert James",member,,"no email","allowed",2013,1,30,13,1,15,America/Los_Angeles
+guruguru@gmail.com,"Chris Kwon",member,,"no email","allowed",2012,8,8,18,13,30,America/Los_Angeles
+hal.newton@gmail.com,"Hal Newton",member,,"no email","allowed",2012,7,3,15,59,49,America/Los_Angeles
+hani.elabed@gmail.com,"hani",member,,"abridged","allowed",2011,10,3,8,44,47,America/Los_Angeles
+harigharan@softsuave.com,"Harigharan E",member,,"no email","allowed",2013,8,12,8,30,32,America/Los_Angeles
+harrybrook0@gmail.com,"Harry Smith",member,,"no email","allowed",2013,9,29,6,23,35,America/Los_Angeles
+hayesmp@thefrontside.net,"Michael Hayes",member,,"email","allowed",2013,10,21,14,42,35,America/Los_Angeles
+hellraiser101@gmail.com,"narendra chitrakar",member,,"no email","allowed",2012,10,14,20,52,6,America/Los_Angeles
+help@apigee.com,"Apigee Help",member,,"email","allowed",2013,5,28,15,6,21,America/Los_Angeles
+himanshuanandani@gmail.com,"himanshu anandani",member,,"no email","allowed",2013,8,29,1,52,23,America/Los_Angeles
+hjrascoe@gmail.com,"Justin Rascoe",member,,"no email","allowed",2013,5,28,19,55,1,America/Los_Angeles
+hmclaug@gmail.com,"Hunter Cash",member,,"no email","allowed",2013,3,2,13,56,37,America/Los_Angeles
+hotbabay22@yahoo.fr,"hotbabay22@yahoo.fr",member,bouncing,"no email","allowed",2012,2,20,22,57,31,America/Los_Angeles
+hvandenbulk@gmail.com,"Henri",member,,"no email","allowed",2012,11,7,21,26,17,America/Los_Angeles
+hwhelan@apigee.com,"Helen Whelan",member,,"no email","allowed",2012,7,11,11,49,42,America/Los_Angeles
+i.judekim@gmail.com,"Jude Kim",member,,"abridged","allowed",2012,8,23,5,5,35,America/Los_Angeles
+ian.cumberland@gmail.com,"fukurou",member,,"no email","allowed",2013,2,26,3,15,25,America/Los_Angeles
+ibrahim.abuelruzz@gmail.com,"Ibra Ibra",member,,"no email","allowed",2012,6,18,10,57,9,America/Los_Angeles
+ilya@eonmediagroup.com,"Ilya EONmediagroup",member,,"no email","allowed",2013,3,23,14,41,9,America/Los_Angeles
+indalyadav042@gmail.com,"INDAL YADAV",member,,"no email","not allowed",2013,10,16,23,58,19,America/Los_Angeles
+informationchef@gmail.com,"Information Chef",member,,"email","allowed",2011,10,3,10,59,41,America/Los_Angeles
+intuedge@gmail.com,"Doug May",member,,"no email","allowed",2013,6,26,22,13,59,America/Los_Angeles
+jameztcc@gmail.com,"James Tan",member,,"no email","allowed",2013,5,15,0,8,8,America/Los_Angeles
+jamison.k.bell@gmail.com,"Jamison K. Bell",member,,"no email","allowed",2012,6,22,3,50,19,America/Los_Angeles
+jarbunk@gmail.com,"Justin Mahar",member,,"no email","allowed",2012,9,7,10,57,38,America/Los_Angeles
+jason.duley@gmail.com,"Jason Duley",member,,"no email","allowed",2013,4,29,16,25,41,America/Los_Angeles
+jasonograves@gmail.com,"Jason Graves",member,,"no email","allowed",2013,6,30,19,45,18,America/Los_Angeles
+jay.ockers@gmail.com,"jockers",member,,"no email","allowed",2013,3,23,14,43,33,America/Los_Angeles
+JChung@apigee.com,"Jackson Chung",member,,"abridged","allowed",2012,7,24,17,54,6,America/Los_Angeles
+jdubray@gmail.com,"JJ",member,,"no email","allowed",2011,10,13,12,36,43,America/Los_Angeles
+jeffhsu.life@gmail.com,"J",member,,"no email","allowed",2013,6,4,23,36,44,America/Los_Angeles
+jeffrey.mock@gmail.com,"Jeffrey Mock",member,,"no email","allowed",2013,2,4,22,20,58,America/Los_Angeles
+jeremy@ignite.ms,"Jeremy Anticouni",member,,"no email","allowed",2013,4,19,18,44,43,America/Los_Angeles
+jerryhamby@gmail.com,"jerry hamby",member,,"digest","allowed",2012,8,8,11,31,45,America/Los_Angeles
+jinan62@gmail.com,"Jinan Toh",member,,"no email","allowed",2012,5,9,7,52,0,America/Los_Angeles
+jodyfranklin@gmail.com,"Jody Franklin",member,,"email","allowed",2012,9,2,17,16,31,America/Los_Angeles
+joel.yen@gmail.com,"Joel Yen",member,,"no email","allowed",2013,5,12,18,44,54,America/Los_Angeles
+johan.chouquet@gmail.com,"Johan Chouquet",member,,"no email","allowed",2013,6,3,21,4,31,America/Los_Angeles
+john.j.baumbach@gmail.com,"John B",member,,"no email","allowed",2013,2,10,15,13,55,America/Los_Angeles
+jose.vibar@gmail.com,"Jose Vibar",member,,"no email","allowed",2012,12,2,1,5,33,America/Los_Angeles
+jrodriguez@zenksworld.com,"Jorge Rodriguez",member,,"email","allowed",2013,5,13,4,15,56,America/Los_Angeles
+juanpablof@gmail.com,"J P",member,,"no email","allowed",2011,10,11,13,45,48,America/Los_Angeles
+julielieyal@gmail.com,"Julie Li",member,,"no email","allowed",2013,6,19,23,29,21,America/Los_Angeles
+jyotiman.prusty@gmail.com,"jyotiman",member,,"no email","allowed",2012,9,3,6,29,59,America/Los_Angeles
+kanitkar.abhishek@gmail.com,"Abhishek Kanitkar",member,,"no email","allowed",2012,10,16,0,25,17,America/Los_Angeles
+karim.varela@gmail.com,"Karim Varela",member,,"no email","allowed",2012,11,3,23,21,39,America/Los_Angeles
+kaytami@yahoo.com,"KC",member,,"no email","allowed",2012,5,31,0,10,13,America/Los_Angeles
+kevinecor@gmail.com,"mayorbyrne",member,,"no email","allowed",2012,11,22,12,5,34,America/Los_Angeles
+keyurchitnis@gmail.com,"keyur chitnis",member,,"no email","allowed",2012,11,7,13,32,31,America/Los_Angeles
+kglowacki@gmail.com,"Kris Glowacki",member,,"abridged","allowed",2013,5,20,11,19,32,America/Los_Angeles
+kirandeo87@gmail.com,"Kiran Deorukhkar",member,,"no email","allowed",2013,10,7,10,40,47,America/Los_Angeles
+kroll.rich@gmail.com,"Rich Kroll",member,,"abridged","allowed",2013,6,4,14,39,43,America/Los_Angeles
+kruti.barot.27@gmail.com,"Kruti Barot",member,,"no email","allowed",2013,9,20,23,21,27,America/Los_Angeles
+kswiber@gmail.com,"Kevin Swiber",member,,"email","allowed",2012,7,11,10,44,6,America/Los_Angeles
+ktopits@gmail.com,"Kirk Topits",member,,"no email","allowed",2013,5,28,10,8,1,America/Los_Angeles
+kurt.kanaskie@gmail.com,"Kurt Kanaskie",member,,"no email","allowed",2012,7,17,6,37,56,America/Los_Angeles
+laurent.pasquali@gmail.com,"Laurent PASQUALI",member,,"no email","allowed",2012,10,19,5,52,24,America/Los_Angeles
+lgo@apache.org,,member,,"email","allowed",2013,9,21,10,47,33,America/Los_Angeles
+lifesaverpc@gmail.com,"Tech LifesaverPC",member,,"digest","allowed",2012,8,22,15,9,10,America/Los_Angeles
+lloyd.reshard@gmail.com,"Lloyd Reshard",member,,"digest","allowed",2012,10,4,20,36,9,America/Los_Angeles
+luck0131.park@gmail.com,"geeluck",member,,"abridged","allowed",2012,7,27,8,5,7,America/Los_Angeles
+maciej.rakowicz@adleritech.com,"mr",member,,"no email","allowed",2013,8,9,0,26,8,America/Los_Angeles
+macs.dragon1@gmail.com,"macs",member,,"no email","allowed",2012,10,19,9,12,36,America/Los_Angeles
+marie.parnigoni@gmail.com,"Marie Parnigoni",member,,"no email","allowed",2012,4,30,1,32,26,America/Los_Angeles
+marius.andreiana@gmail.com,"Marius Andreiana",member,,"no email","allowed",2012,8,2,3,2,23,America/Los_Angeles
+mark@shust.com,"Mark Shust",member,,"no email","allowed",2012,6,27,21,58,18,America/Los_Angeles
+markmwaura3@gmail.com,"Mark Mwaura",member,,"abridged","allowed",2012,9,19,21,2,53,America/Los_Angeles
+marsh.gardiner@gmail.com,"Marsh Gardiner",member,,"no email","allowed",2012,8,29,9,52,43,America/Los_Angeles
+marsh@apigee.com,"Marsh Gardiner",member,,"digest","allowed",2012,3,28,22,3,14,America/Los_Angeles
+maruthi@apigee.com,"Maruti",member,,"email","allowed",2012,6,28,4,15,27,America/Los_Angeles
+mastung@gmail.com,"Hao TANG",member,,"no email","allowed",2013,8,7,0,34,58,America/Los_Angeles
+matt.mcclean@gmail.com,"Matt McClean",member,,"no email","allowed",2012,6,19,6,38,27,America/Los_Angeles
+matthias.gliwka@gmail.com,"Matthias Gliwka",member,,"no email","allowed",2013,7,19,11,46,55,America/Los_Angeles
+mattsobieray@gmail.com,"Matt Sobieray",member,,"no email","allowed",2013,3,23,14,43,44,America/Los_Angeles
+mattyg2k6@gmail.com,"Matthew Garcia",member,,"no email","allowed",2013,9,28,1,45,39,America/Los_Angeles
+mdobson@apigee.com,"Matthew Dobson",member,,"abridged","allowed",2013,3,12,10,52,14,America/Los_Angeles
+meinert@gmail.com,"Andrew Meinert",member,,"no email","allowed",2013,1,30,16,2,58,America/Los_Angeles
+metilluyoc@gmail.com,"Javier Herrera Núñez",member,,"digest","allowed",2013,10,13,21,45,0,America/Los_Angeles
+mhaller@escalation-point.com,,member,,"no email","allowed",2013,7,8,15,9,13,America/Los_Angeles
+michaelshen7@gmail.com,"Michael Shen",member,,"no email","allowed",2013,10,1,20,58,36,America/Los_Angeles
+michartmann@gmail.com,"Michael Ryberg Hartmann",member,,"no email","allowed",2013,1,31,15,26,6,America/Los_Angeles
+mikerex89@gmail.com,"Mike Rex",member,,"no email","allowed",2012,11,26,7,1,8,America/Los_Angeles
+mingfai.ma@gmail.com,"Mingfai Ma",member,,"email","allowed",2013,7,4,8,46,0,America/Los_Angeles
+mmalloy@apigee.com,"Michael Malloy",member,,"no email","allowed",2013,10,2,10,58,30,America/Los_Angeles
+monspo2@gmail.com,"Sung Moon",member,,"no email","allowed",2012,7,13,11,41,55,America/Los_Angeles
+mpease@gmail.com,"Matthew Pease",member,,"no email","allowed",2012,6,18,7,3,10,America/Los_Angeles
+mustafak26@gmail.com,"مصطفى كمال",member,,"no email","allowed",2012,9,23,5,7,7,America/Los_Angeles
+nathaniel.simpson@gmail.com,"Nathan Simpson",member,,"no email","allowed",2012,12,20,13,9,17,America/Los_Angeles
+neal.schneier@gmail.com,"Neal Schneier",member,,"no email","allowed",2012,10,5,10,41,21,America/Los_Angeles
+neil@cazcade.com,"Neil Ellis",member,,"no email","allowed",2013,5,29,14,23,13,America/Los_Angeles
+niranjan.karu@gmail.com,"Niranjan Karunanandham",member,,"no email","allowed",2013,9,23,3,1,45,America/Los_Angeles
+nmccall@apigee.com,"zznate",manager,,"email","not allowed",2012,3,16,11,12,35,America/Los_Angeles
+nrosolski@gmail.com,"nrosolski",member,,"no email","allowed",2012,7,3,21,51,52,America/Los_Angeles
+nvadiee@apigee.com,"Nima Vadiee",member,,"abridged","allowed",2013,2,6,11,24,0,America/Los_Angeles
+opolyo01@gmail.com,"Oleg Polyakov",member,,"no email","allowed",2012,10,21,11,22,29,America/Los_Angeles
+orcaelectronic@aol.com,"Simon Haller",member,,"digest","allowed",2013,5,25,4,51,52,America/Los_Angeles
+oyediyildiz@gmail.com,"Orhan Yediyıldız",member,,"no email","allowed",2012,6,4,15,17,15,America/Los_Angeles
+pashabhai@gmail.com,"Prashant Purkar",member,,"no email","allowed",2012,7,24,0,20,48,America/Los_Angeles
+paul.wood.iii@gmail.com,"Paul Wood",member,,"no email","allowed",2013,1,12,22,7,5,America/Los_Angeles
+prabhat143@gmail.com,"Prabhat Jha",member,,"email","allowed",2013,10,22,15,14,31,America/Los_Angeles
+pratik13butani@gmail.com,"Pratik Butani",member,,"no email","allowed",2013,5,1,21,58,27,America/Los_Angeles
+priteshpatel15@gmail.com,"Pritesh Patel",member,,"email","allowed",2013,4,25,16,41,24,America/Los_Angeles
+prwfreeman@gmail.com,"Hereford App Dev",member,,"abridged","allowed",2012,9,1,8,48,45,America/Los_Angeles
+radiozeux@googlemail.com,"Sebastian Albert",member,,"no email","allowed",2013,5,4,10,16,57,America/Los_Angeles
+rahul0704@gmail.com,"Rahul",member,,"no email","allowed",2012,9,7,11,35,9,America/Los_Angeles
+rahulkrishnan007@gmail.com,"Rahul Krishnan",member,,"abridged","allowed",2012,9,21,10,47,2,America/Los_Angeles
+rajanish@apigee.com,"Rajanish Gundlupet Jagadish",member,,"abridged","allowed",2012,10,10,9,58,18,America/Los_Angeles
+rajeev@apigee.com,"Rajeev Ramani",member,,"no email","allowed",2013,4,26,18,45,47,America/Los_Angeles
+rakesh.s@apigee.com,,member,,"no email","allowed",2013,5,28,17,8,24,America/Los_Angeles
+rakeshvk4u@gmail.com,"Rakesh VK",member,,"no email","allowed",2013,9,11,9,54,20,America/Los_Angeles
+ramesh.v1210@gmail.com,"Ramesh V",member,,"no email","allowed",2012,7,31,2,18,21,America/Los_Angeles
+rampradeepk@gmail.com,"Rampradeep",member,,"email","allowed",2012,10,8,23,38,18,America/Los_Angeles
+rasmus@moyo.la,"Rasmus Hansson",member,,"no email","allowed",2012,8,1,14,2,38,America/Los_Angeles
+raykyri@gmail.com,"Raymond Zhong",member,,"no email","allowed",2012,6,7,15,5,4,America/Los_Angeles
+rbwright@gmail.com,"rbw",member,,"email","allowed",2012,7,30,15,7,31,America/Los_Angeles
+reggieesposa@gmail.com,"reggie",member,,"abridged","allowed",2013,9,7,8,47,43,America/Los_Angeles
+rino@techsquare.a-tono.net,"Rino Seminara",member,,"no email","allowed",2012,3,12,8,59,46,America/Los_Angeles
+rippela@apigee.com,"Renu Ippela",member,,"no email","allowed",2013,9,26,11,34,53,America/Los_Angeles
+rnsksoft@gmail.com,"Kai Cherry",member,,"abridged","allowed",2012,7,31,15,23,30,America/Los_Angeles
+robert.djurasaj@gmail.com,"Robert Djurasaj",member,,"no email","allowed",2013,3,22,14,26,20,America/Los_Angeles
+robslama@gmail.com,"speedy2222",member,,"digest","allowed",2012,9,7,6,29,2,America/Los_Angeles
+rod@apigee.com,"Rod Simpson",member,,"email","allowed",2012,5,31,11,54,34,America/Los_Angeles
+rohit@tingendab.com,"Rohit Rai",member,,"no email","allowed",2013,9,17,12,10,49,America/Los_Angeles
+rubentrancoso@gmail.com,"Ruben Trancoso",member,,"abridged","allowed",2013,5,28,13,58,24,America/Los_Angeles
+rupenp525@gmail.com,"Rupen P",member,,"abridged","allowed",2013,6,29,10,21,12,America/Los_Angeles
+rutgerius@gmail.com,"Rutger van Dijk",member,,"no email","allowed",2012,8,17,7,57,38,America/Los_Angeles
+ryakkala@apigee.com,"RAppSy",member,bouncing,"no email","not allowed",2013,3,30,16,35,6,America/Los_Angeles
+sachin@webmobi.com,"S Anand",member,,"email","allowed",2012,6,3,17,15,54,America/Los_Angeles
+sagarborse.borse@gmail.com,"Sagar Borse",member,,"no email","allowed",2013,9,23,8,20,51,America/Los_Angeles
+sanchitml@gmail.com,"Sanchit Mittal",member,,"abridged","allowed",2012,11,13,16,58,50,America/Los_Angeles
+sangramsingh@apigee.com,"Sangram Singh Kunwar",member,,"no email","allowed",2012,10,10,9,49,23,America/Los_Angeles
+sarahkungfu32@gmail.com,"Sara Santos",member,,"abridged","allowed",2013,6,7,14,38,40,America/Los_Angeles
+sarthak@apigee.com,"Sarthak Gangopadhyay",member,,"email","allowed",2012,5,6,18,38,32,America/Los_Angeles
+sathishvj@gmail.com,"Sathish VJ",member,,"no email","allowed",2012,12,11,1,23,26,America/Los_Angeles
+sayem@asteriskbd.com,"Abu Sayem",member,,"no email","allowed",2013,8,2,3,9,44,America/Los_Angeles
+scott@apigee.com,"Scott Regan",member,,"email","allowed",2012,3,13,16,23,20,America/Los_Angeles
+seh40@students.uwf.edu,"Bobisback",member,,"no email","allowed",2012,10,9,15,52,12,America/Los_Angeles
+semplake@gmail.com,"semplake semplake",member,,"no email","allowed",2013,6,13,22,29,40,America/Los_Angeles
+SGanyo@apigee.com,"Scott Ganyo",member,,"email","allowed",2012,8,6,14,21,10,America/Los_Angeles
+shaozhuang.liu@gmail.com,"Shaozhuang Liu",member,,"digest","allowed",2013,6,3,13,25,10,America/Los_Angeles
+shivraj.cse@gmail.com,"Shivraj",member,,"no email","allowed",2012,9,5,2,10,23,America/Los_Angeles
+sinan.inel@gmail.com,"sinel",member,,"abridged","allowed",2012,7,28,8,2,21,America/Los_Angeles
+slknarayanan@gmail.com,"Narayanan S",member,,"email","allowed",2012,4,27,7,20,22,America/Los_Angeles
+snoopdave@gmail.com,"Dave Johnson",member,,"no email","allowed",2013,8,30,5,22,43,America/Los_Angeles
+sourajit.basac@gmail.com,"Sourajit Basak",member,,"no email","allowed",2012,7,22,22,53,59,America/Los_Angeles
+srujanmathur@gmail.com,"mathur",member,,"no email","allowed",2013,4,7,22,36,20,America/Los_Angeles
+starinsights@gmail.com,"JustinM",member,,"no email","allowed",2012,4,11,13,24,39,America/Los_Angeles
+stevem@currentww.com,"StMcPherson",member,,"email","allowed",2012,7,24,7,39,24,America/Los_Angeles
+stewmorg@gmail.com,"Stewart Morgan",member,,"no email","allowed",2013,6,20,7,29,16,America/Los_Angeles
+stliu@hibernate.org,"Shaozhuang Liu",member,,"no email","allowed",2013,5,29,20,39,33,America/Los_Angeles
+stovak@apigee.com,"STOVAK",member,,"no email","allowed",2012,10,3,12,15,6,America/Los_Angeles
+straut@apigee.com,"Steve Traut",member,,"abridged","allowed",2013,7,8,10,24,5,America/Los_Angeles
+sungju@softwaregeeks.org,,member,,"email","allowed",2013,5,2,18,35,0,America/Los_Angeles
+sunil.rnsit@gmail.com,"Sunil Kumar BT",member,,"no email","allowed",2012,11,7,10,41,40,America/Los_Angeles
+tahatayyab@gmail.com,"Taha Tayyab",member,,"no email","allowed",2013,6,1,23,31,51,America/Los_Angeles
+tebica@gmail.com,"Minwoo Park",member,,"no email","allowed",2012,7,24,23,45,45,America/Los_Angeles
+thani_rbd@hotmail.com,"Thaniara manchini teodoro",member,,"no email","allowed",2013,4,12,21,51,49,America/Los_Angeles
+thatboy.phantom@gmail.com,"Fab",member,,"no email","allowed",2013,1,31,16,43,4,America/Los_Angeles
+thinklog@gmail.com,"Joseph",member,,"email","allowed",2011,10,19,9,5,40,America/Los_Angeles
+thomas.holiyop@gmail.com,,member,,"no email","allowed",2013,7,4,2,59,41,America/Los_Angeles
+tim.anglade@gmail.com,"Tim Anglade",member,,"email","allowed",2013,10,10,19,59,52,America/Los_Angeles
+tim@apigee.com,"Tim Anglade",manager,,"no email","allowed - override",2012,4,3,9,52,47,America/Los_Angeles
+tim@radtastical.com,,member,,"abridged","allowed",2013,1,25,16,57,16,America/Los_Angeles
+tnine@apigee.com,"Todd Nine",manager,,"no email","allowed",2012,3,16,11,9,36,America/Los_Angeles
+todd.nine@gmail.com,"Todd Nine",manager,,"no email","allowed",2012,6,13,16,46,46,America/Los_Angeles
+tom.marrs@gmail.com,"Tom Marrs",member,,"no email","allowed",2013,3,22,14,26,26,America/Los_Angeles
+tomt555@gmail.com,"Tom",member,,"abridged","allowed",2012,8,12,19,52,39,America/Los_Angeles
+toto.thkim@gmail.com,"Taeho@KTH",member,,"no email","allowed",2012,11,7,0,0,26,America/Los_Angeles
+travis@cloudmetal.com,"Travis James",member,,"no email","allowed",2013,5,24,13,33,42,America/Los_Angeles
+traviskds@gmail.com,"Travis De Silva",member,,"no email","allowed",2013,1,11,5,12,29,America/Los_Angeles
+tsourapas@gmail.com,"Kiriakos",member,,"no email","allowed",2012,9,15,0,36,23,America/Los_Angeles
+tushar.m.s@gmail.com,"Tushar",member,,"no email","allowed",2012,6,18,21,0,49,America/Los_Angeles
+tutonehcc@gmail.com,"LogHomeFinishing Colorado",member,,"no email","allowed",2013,1,1,9,54,18,America/Los_Angeles
+twinhope108@gmail.com,"Eutiquio Chapa",member,,"no email","allowed",2012,9,23,23,27,51,America/Los_Angeles
+twong@twong.com,"Terry Wong",member,,"no email","allowed",2013,5,9,2,32,28,America/Los_Angeles
+v@vinspee.me,"Vince Speelman",member,,"no email","allowed",2013,7,1,17,52,25,America/Los_Angeles
+vaibhavb@gmail.com,"Vaibhav Bhandari",member,,"no email","allowed",2013,4,25,15,2,14,America/Los_Angeles
+vmasina@gmail.com,"Vijay Masina",member,,"no email","allowed",2013,2,26,16,27,17,America/Los_Angeles
+wattersjames@gmail.com,"James Watters",member,,"digest","allowed",2012,9,3,17,32,20,America/Los_Angeles
+wil.moore@wilmoore.com,"Wil Moore",member,,"no email","allowed",2013,3,23,14,40,42,America/Los_Angeles
+xybrek@gmail.com,"Xybrek",member,,"digest","allowed",2013,2,20,23,2,42,America/Los_Angeles
+yahya@g.ucla.edu,"Yahya Shaikh",member,,"no email","allowed",2013,6,15,21,33,6,America/Los_Angeles
+yamanoor@gmail.com,"Srihari Yamanoor",member,,"email","allowed",2012,10,9,16,54,2,America/Los_Angeles
+yasuzo100@gmail.com,"Yasuhide Kato",member,,"email","allowed",2013,9,27,4,44,40,America/Los_Angeles
+ymolists@gmail.com,"ymo",member,,"no email","allowed",2012,9,22,11,8,4,America/Los_Angeles
+yramiyer@gmail.com,"leo",member,,"abridged","allowed",2013,5,4,21,38,51,America/Los_Angeles
+ys1382@gmail.com,"Yusuf X",member,,"no email","allowed",2012,4,6,4,3,29,America/Los_Angeles
+zznate.m@gmail.com,"Nate McCall",member,,"no email","allowed",2013,10,9,7,40,38,America/Los_Angeles
\ No newline at end of file