Sorting membership lists by ZIP Code
Posted: Tue Mar 11, 2008 11:44 am
My stake clerk has passed along a request from our mission president:
"President Murray . . . would like to have a directory of all members that was sorted by Unit and by family to include their names, birthdates and addresses with zip codes in the Wilmington Delaware Stake. He is asking all Stakes in the Mission to provide their entire membership data in that directory format. I understand MLS has such a directory, but do not know how to download / export to an excel spreadsheet to provide it to him."
Generating a directory in CSV or XLS that just has the parents' names, and is sortable by zip, I can do. The CSV file that is downloaded from the ward websites has everyone's first name, but no ages or birth dates, and the ZIP code isn't in its own field (nor is it consistently in one field.)
The Directory of Members, of course, has all the necessary data. Is there a way to sort that by postal code and export it? Can anyone think of another way to pull this off (in MLS 2.8)?
Thanks for any help you can provide
John Taber
Assistant Stake Clerk (Membership etc.)
Wilmington Delaware Stake
"President Murray . . . would like to have a directory of all members that was sorted by Unit and by family to include their names, birthdates and addresses with zip codes in the Wilmington Delaware Stake. He is asking all Stakes in the Mission to provide their entire membership data in that directory format. I understand MLS has such a directory, but do not know how to download / export to an excel spreadsheet to provide it to him."
Generating a directory in CSV or XLS that just has the parents' names, and is sortable by zip, I can do. The CSV file that is downloaded from the ward websites has everyone's first name, but no ages or birth dates, and the ZIP code isn't in its own field (nor is it consistently in one field.)
The Directory of Members, of course, has all the necessary data. Is there a way to sort that by postal code and export it? Can anyone think of another way to pull this off (in MLS 2.8)?
Thanks for any help you can provide
John Taber
Assistant Stake Clerk (Membership etc.)
Wilmington Delaware Stake