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

Church Policy is explicit that membership data in any form should not be uploaded to other servers. If you really want to view the KML file with Google Maps the only way might 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. Check settings are correct.
  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.

Google Maps' geocoder is pretty forgiving, so go ahead and try it even if your data isn't formatted consistantly.
Settings:
Export | Import | MLS defaults | LUWS defaults

 Title or Ward name
 Google Maps API Key  (Can be left blank, or apply here.)
 
Columns:
Set to blank to ignore a column.
Only name and address1 are required.
If there is no country in your data you can type it directly below (if needed)
  •  Name
  •  Address1
  •  Address2
  •  City
  •  Postal/Zip Code
  •  State
  •  Country
  •  Phone 1
  •  Phone 2
  •  Email
 Filters:
Only locate lines that matches all the filters below. (Only requires a partial match, not an exact match. Leave column number blank to ignore. Click the link to change type.)
Column must contain
Column must not be blank/empty.
Column must not be blank/empty.
Column must not be blank/empty.

Lattitude, Longitude, or both can be defined in a column, or can be set in the boxes below (must contain decimal point.)
Lat/Long should be used only when address not found
Lat/Long should always be used when defined
  •  Lat,Long (eg -74.044547,40.689229 - help); or
  •  Lattitude and
  •  Longitude
Icons:
Advanced use only
Icon styleurl name
Column contains the style to use for that row (paste additional style definitions into the kml after processing.
Icon Scale: enter as decimal to make the pinpoint bigger/smaller (1=100%)

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.
This is now version 2.3 - 9 Jan 2008