Export membership to spreadsheet and/or query interface with LCR?

Discuss basic duties of stake and ward clerks, including where to begin.
nasfarley88
New Member
Posts: 13
Joined: Tue Nov 01, 2011 4:44 am

Export membership to spreadsheet and/or query interface with LCR?

Postby nasfarley88 » Sun Dec 11, 2016 4:42 am

Hi,
I've recently been called as a ward assistant clerk for membership and I'm wondering if there is a way to get the whole membership of the ward in a spreadsheet, or alternatively query the database online with LCR via something like an SQL interface or similar?

E.g. I would like to search for all members between two ages, and display their baptismal dates.

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

Re: Export membership to spreadsheet and/or query interface with LCR?

Postby russellhltn » Sun Dec 11, 2016 10:58 am

nasfarley88 wrote:I've recently been called as a ward assistant clerk for membership and I'm wondering if there is a way to get the whole membership of the ward in a spreadsheet, or alternatively query the database online with LCR via something like an SQL interface or similar?

At one time there was, but most - if not all of them have been taken away "due to privacy reasons".


nasfarley88 wrote:E.g. I would like to search for all members between two ages, and display their baptismal dates.

For that, I'd suggest MLS custom reports. (No such feature in LCR - yet.)
Have you searched the Wiki?
Try using a Google search by adding "site:tech.lds.org/wiki" to the search criteria.

nasfarley88
New Member
Posts: 13
Joined: Tue Nov 01, 2011 4:44 am

Re: Export membership to spreadsheet and/or query interface with LCR?

Postby nasfarley88 » Sun Jan 01, 2017 1:48 am

Thanks, I'll have a look into MLS custom reports.

SmithBri
New Member
Posts: 2
Joined: Thu Nov 03, 2016 3:54 pm

Re: Export membership to spreadsheet and/or query interface with LCR?

Postby SmithBri » Sun Jan 08, 2017 8:45 pm

Member information can be exported via the Directory function in the My Ward column.

jdlessley
Community Moderators
Posts: 6607
Joined: Sun Mar 16, 2008 11:30 pm
Location: USA, TX

Re: Export membership to spreadsheet and/or query interface with LCR?

Postby jdlessley » Mon Jan 09, 2017 7:39 pm

SmithBri wrote:Member information can be exported via the Directory function in the My Ward column.

There is no export capability from the Directory. It was removed a few years ago.
JD Lessley
Have you tried finding your answer on the LDS.org Help Center page or the LDSTech wiki?

User avatar
kd7mha
Member
Posts: 161
Joined: Thu Mar 13, 2008 1:27 pm
Location: Logan, Utah

Re: Export membership to spreadsheet and/or query interface with LCR?

Postby kd7mha » Mon Jan 09, 2017 7:46 pm

jdlessley wrote:
SmithBri wrote:Member information can be exported via the Directory function in the My Ward column.

There is no export capability from the Directory. It was removed a few years ago.


as an assitant Ward Clerk I DO have an export Households option in the Directory
There are 11 types of people. Those who understand Gray Code and those that don't.

jdlessley
Community Moderators
Posts: 6607
Joined: Sun Mar 16, 2008 11:30 pm
Location: USA, TX

Re: Export membership to spreadsheet and/or query interface with LCR?

Postby jdlessley » Mon Jan 09, 2017 8:22 pm

kd7mha wrote:as an assitant Ward Clerk I DO have an export Households option in the Directory

It is limited to certain callings rather than to the general membership. The removal of the capability was for the general membership.
JD Lessley
Have you tried finding your answer on the LDS.org Help Center page or the LDSTech wiki?

emarkp
New Member
Posts: 4
Joined: Sun Nov 16, 2014 12:22 pm

Re: Export membership to spreadsheet and/or query interface with LCR?

Postby emarkp » Sun Jan 15, 2017 1:26 pm

I believe this is a permission assigned in the permissions screen. At least I know any member of our bishopric can do this, but I (Finance Clerk) cannot.

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

Re: Export membership to spreadsheet and/or query interface with LCR?

Postby russellhltn » Sun Jan 15, 2017 1:59 pm

emarkp wrote:I believe this is a permission assigned in the permissions screen. At least I know any member of our bishopric can do this, but I (Finance Clerk) cannot.

At this time, I think the only permissions screen that still exists is the one in MLS. Neither LCR not the directory has one. Rights are based on calling held.
Have you searched the Wiki?

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

cheerioboy
New Member
Posts: 45
Joined: Mon Oct 29, 2012 8:53 pm
Location: Southern California, United States

Re: Export membership to spreadsheet and/or query interface with LCR?

Postby cheerioboy » Wed Jan 25, 2017 12:16 pm

If you're willing and have the expertise, the fields can be copied and pasted into a regular-expression capable text editor (such as vi or Vim or EditPad [for Windows), then the appropriate magical commands can be performed. I have been able to convert our stake budget details into a CSV file through appropriate massaging of the fields, which I was able to script. The purpose of that export was to categorize some trends over years.

I'm not sure who still uses vi or Vim anymore, nor how many are familiar with regexs (the price of progress?).


Return to “Getting Started for New Clerks”

Who is online

Users browsing this forum: No registered users and 1 guest