Latest 3.3 version of MLS does not export MRN in the csv files

Discussions around using and interfacing with the Church MLS program.
Post Reply
tannerr
New Member
Posts: 6
Joined: Sat Jan 01, 2011 4:47 pm

Latest 3.3 version of MLS does not export MRN in the csv files

#1

Post by tannerr »

I exported every file marking every checkbox, but none of the files have the MRN number. Why is this? In my tools for reporting I rely on the MRN to match up people so as to not overwrite my database.

What's up? Bug or new setting?

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

#2

Post by aebrown »

tannerr wrote:I exported every file marking every checkbox, but none of the files have the MRN number. Why is this? In my tools for reporting I rely on the MRN to match up people so as to not overwrite my database.

What's up? Bug or new setting?

This was an intentional change, which was mentioned specifically in the Release Notes:
Membership Record Number No Longer in Export File. When leaders and clerks use the Export feature in MLS to extract membership information to a PDA, the membership record number (MRN) will no longer be included. This decision was made due to security concerns because the MRN is a key LDS Account component used by members to access Church websites.
Questions that can benefit the larger community should be asked in a public forum, not a private message.
dbezzant
New Member
Posts: 11
Joined: Mon Sep 29, 2008 8:37 pm
Location: American Fork, Utah, USA

#3

Post by dbezzant »

I did not see this in the release notes of 3.3 either. My Counselors and Bishop use this information all the time from their PDA's, which are password protected, when they fill-out temple recommends and other documents which need this information. I guess I'll need to print them a sheet with the information, which I think is a bigger security risk, as they not all have access to MLS when they fill out temple recommends.

Will this decision change in the future? With the Ward Tools application, which is what we use, you can password protect the application. I also understand the Church now owns the code for Ward Tools and was hoping this feature would be available in the LDSTools.

Brother Bezzant
Ward Clerk
User avatar
mkmurray
Senior Member
Posts: 3254
Joined: Tue Jan 23, 2007 9:56 pm
Location: Utah
Contact:

#4

Post by mkmurray »

dbezzant wrote:Will this decision change in the future?
I personally doubt it. The decision was just recently made to not allow export of MRNs anymore for security reasons; I can't see them undoing the decision so soon again or on a whim.
nutterb
Member
Posts: 276
Joined: Tue Feb 10, 2009 7:06 am
Location: Berea, KY, USA

#5

Post by nutterb »

dbezzant wrote:My Counselors and Bishop use this information all the time from their PDA's, which are password protected, when they fill-out temple recommends and other documents which need this information.
Ward Clerk

As long as they have an internet connection, it isn't hard to get the number from the membership record on the Clerk and Leader Resources.
crislapi
Senior Member
Posts: 1266
Joined: Mon Jul 07, 2008 4:05 pm
Location: USA

#6

Post by crislapi »

tannerr wrote:What's up? Bug or new setting?
Intentional design change. This has been discussed previously. See here.
nutterb
Member
Posts: 276
Joined: Tue Feb 10, 2009 7:06 am
Location: Berea, KY, USA

#7

Post by nutterb »

tannerr wrote:I exported every file marking every checkbox, but none of the files have the MRN number. Why is this? In my tools for reporting I rely on the MRN to match up people so as to not overwrite my database.

The more experienced database people can correct me if I'm wrong, but MLS also assigns an Individual ID that is specific to that person in that ward. It should work for uniquely identifying people as long as you do not combine exports from multiple wards. So it shouldn't be too difficult to change the identifying field without disrupting your database.
jasonhyer
Member
Posts: 241
Joined: Fri Oct 19, 2007 11:15 am
Location: Roy, UT

#8

Post by jasonhyer »

nutterb wrote:The more experienced database people can correct me if I'm wrong, but MLS also assigns an Individual ID that is specific to that person in that ward. It should work for uniquely identifying people as long as you do not combine exports from multiple wards. So it shouldn't be too difficult to change the identifying field without disrupting your database.
You are correct. Each individual in the export has an Individual ID that you should use instead of the MRN. If you look at the export closely, this is the ID number that links family members to the HoH. LDS Tools uses this ID number for individuals in its database.

Though it may be regrettable that the MRN has been removed, if you have proper authority to access the number, you can get it on the internet on LDS.org through the Leader and Clerk Resources tool.
Jason Hyer
Post Reply

Return to “MLS Support, Help, and Feedback”