Sorting by address MLS and LDS tools

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

Sorting by address MLS and LDS tools

#1

Post by david.fox2 »

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: 34418
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Re: Sorting by address MLS and LDS tools

#2

Post by russellhltn »

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 Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.

So we can better help you, please edit your Profile to include your general location.
User avatar
aebrown
Community Administrator
Posts: 15153
Joined: Tue Nov 27, 2007 8:48 pm
Location: Draper, Utah

Re: Sorting by address MLS and LDS tools

#3

Post by aebrown »

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: 1222
Joined: Thu Dec 08, 2011 10:42 am
Location: Emmett, Idaho

Re: Sorting by address MLS and LDS tools

#4

Post by Gary_Miller »

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: 34418
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Re: Sorting by address MLS and LDS tools

#5

Post by russellhltn »

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 Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.

So we can better help you, please edit your Profile to include your general location.
User avatar
showseason
Member
Posts: 150
Joined: Sat Feb 26, 2011 9:56 pm
Location: Oregon

Re: Sorting by address MLS and LDS tools

#6

Post by showseason »

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.
Locked

Return to “MLS Support, Help, and Feedback”