Sorting by address MLS and LDS tools

Discussions around using and interfacing with the Church MLS program.
User avatar
david.fox2
New Member
Posts: 8
Joined: Sat May 18, 2013 12:20 am
Location: Alberta, Canada

Sorting by address MLS and LDS tools

Postby david.fox2 » Thu Jun 13, 2013 12:38 am

Idea: enable smarter sorting by address in LDS tools and MLS so that is can sort by street name not just number.

Backstory:
As a YSA ward clerk we have been entering in addresses using both the street1 (house number) and street2 (street name) fields in MLS so that we can sort by street name and end up a fairly well organized list for assigning FHE groups, visiting routes, etc.

This could be implemented by having a separate field in the lds tools for house number, aprt, street name, box, like they do for some postal and account information.

Additionally this seems to cause some problems for our stake clerk when they print off lists as they usually only include street1 (so he has to enable street2 just for our ward) And it apparently doesn't adhere to postal guidelines.

I have been told this isn't really done much in family wards, But I would love to hear some opinions as our ward finds it a quite useful setup.

russellhltn
Community Administrator
Posts: 20754
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Re: Sorting by address MLS and LDS tools

Postby russellhltn » Thu Jun 13, 2013 1:42 am

david.fox2 wrote:As a YSA ward clerk we have been entering in addresses using both the street1 (house number) and street2 (street name) fields in MLS so that we can sort by street name and end up a fairly well organized list for assigning FHE groups, visiting routes, etc.

Sounds like a job for Geo codes.
Have you searched the Wiki?
Try using a Google search by adding "site:tech.lds.org/wiki" to the search criteria.

User avatar
aebrown
Community Administrator
Posts: 14691
Joined: Tue Nov 27, 2007 8:48 pm
Location: Sandy, Utah

Re: Sorting by address MLS and LDS tools

Postby aebrown » Thu Jun 13, 2013 5:00 am

When I've done this, I've used a spreadsheet to do the sorting. That way I can leave the addresses properly formatted in MLS. I just export the address list from MLS (typically by doing a copy and paste from the MLS Abbreviated Directory report). Then I paste it into a spreadsheet and use the spreadsheet's functions to isolate the street name into a separate column, which I can easily sort on.

Once you've set up the spreadsheet, for future iterations you can just do a quick paste and sort in less than a minute when you want to update the list as people move in and out of the ward.

Gary_Miller
Senior Member
Posts: 1218
Joined: Thu Dec 08, 2011 10:42 am
Location: Emmett, Idaho

Re: Sorting by address MLS and LDS tools

Postby Gary_Miller » Thu Jun 13, 2013 10:47 am

I'm with russell Geo codes would work great for what your trying to do. depending on the area of the ward you could use the street names as the Geo Code.

russellhltn
Community Administrator
Posts: 20754
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Re: Sorting by address MLS and LDS tools

Postby russellhltn » Thu Jun 13, 2013 10:50 am

I didn't think about it at the time, but one weakness of Geo Codes may be in the reporting. I know it's the bane of custom fields.
Have you searched the Wiki?

Try using a Google search by adding "site:tech.lds.org/wiki" to the search criteria.

User avatar
showseason
Member
Posts: 115
Joined: Sat Feb 26, 2011 9:56 pm
Location: Medford, OR

Re: Sorting by address MLS and LDS tools

Postby showseason » Thu Jun 13, 2013 11:54 am

aebrown wrote:Once you've set up the spreadsheet, for future iterations you can just do a quick paste and sort in less than a minute when you want to update the list as people move in and out of the ward.

I'm with aebrown on this. It's a pain to set up but once it is it is easily maintained. We also have added a column for comments and have some info on most families in the ward. The Bishop loves it.


Return to “MLS Support, Help, and Feedback”

Who is online

Users browsing this forum: No registered users and 1 guest