This page can be run locally. Save as a file on your computer and double click to open in your browser. Note: Firefox has security restrictions that means this won't work if run from a website.

Church Policy is explicit that membership data in any form should not be uploaded to other servers. If you want to view the KML file with Google Maps the only way would be to temporarily host it on your own local computer and paste a URL that points to your computer into the search box of Google Maps (and delete quickly so its not indexed by search engines, etc.) More analysis here.

Steps

  1. In MLS:
    1. Go to File->Export and download Memebership.csv.
      Use the default column numbers under settings.
    2. Go to Custom Reports and make a report.
      Specify which column is which in the fields in the settings.
      Phones and email can be replaced with other columns if using a custom csv file (eg. childrens names.)
      This is particularly useful so you can use the report field 'HOH & Spouse'.
  2. Open csv in a text editor (eg. notepad), select all, copy and paste into first textarea.
  3. Click 'Generate kml data'
  4. When finished, select all from the second textarea, copy and paste into new file (in notepad), save with the file extension .kml
  5. Open kml file in Google Earth.
  6. The KML file will contain information about any addresses it couldn't find at the end of the file in comments (<--   -->) these lines can be deleted if you wish. Often these are just misspelt street names.

Google maps may block your IP address from using their services if you run this script too many times or if your list is too long (>1000).

No data leaves this page except to send each address (excluding name/phone/email) to Google Maps to get coordinates.
Columns:
  •  Name
  •  Address1
  •  Address2
  •  City
  •  Postal/Zip Code
  •  State
  •  Country
  •  Phone 1
  •  Phone 2
  •  Email
(Defaults are based on the Membership.csv export file. Set to blank to ignore a column.) 		Settings:
Title or Ward name:

Google Maps API Key:

(Can be left blank, or apply here.)

Filters:
By Default all "Head of Household" addresses are searched for.
 Find only families where this column has a value. (Default is Ward GeoCode. Set to blank to find all families. Allows you to exclude Less-Actives or Request-No-Visit's or other groups.)
 Or enter a specific string that should be in the above column to filter on. (Only requires a partial match, not an exact match.)

Paste CSV text here:


Status: 

Copy KML text from here:

Kudos to David Ostler who did the initial version of this page in Python 28 June 2007.
The Python version was converted to HTML/Javascript by Fraser Redmond 28 Sep 2008.