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

Discussions around using and interfacing with the Church MLS program.
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

Postby tannerr » Sat Jan 01, 2011 4:48 pm

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: 14691
Joined: Tue Nov 27, 2007 8:48 pm
Location: Sandy, Utah

Postby aebrown » Sat Jan 01, 2011 4:51 pm

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 7:37 pm
Location: American Fork, Utah, USA

Postby dbezzant » Sun Jan 02, 2011 9:42 pm

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: 3241
Joined: Tue Jan 23, 2007 9:56 pm
Location: Utah
Contact:

Postby mkmurray » Sun Jan 02, 2011 10:10 pm

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.
Many questions are already answered on the LDSTech wiki. Check it out!

nutterb
Member
Posts: 257
Joined: Tue Feb 10, 2009 7:06 am
Location: Shaker Heights, OH, USA

Postby nutterb » Mon Jan 03, 2011 9:18 am

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: 1265
Joined: Mon Jul 07, 2008 3:05 pm
Location: USA

Postby crislapi » Mon Jan 03, 2011 12:18 pm

tannerr wrote:What's up? Bug or new setting?

Intentional design change. This has been discussed previously. See here.

nutterb
Member
Posts: 257
Joined: Tue Feb 10, 2009 7:06 am
Location: Shaker Heights, OH, USA

Postby nutterb » Mon Jan 03, 2011 1:12 pm

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: 217
Joined: Fri Oct 19, 2007 10:15 am
Location: Roy, UT

Postby jasonhyer » Mon Jan 03, 2011 1:28 pm

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


Return to “MLS Support, Help, and Feedback”

Who is online

Users browsing this forum: No registered users and 1 guest