Export membership to spreadsheet and/or query interface with LCR?
-
- New Member
- Posts: 13
- Joined: Tue Nov 01, 2011 5:44 am
Export membership to spreadsheet and/or query interface with LCR?
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.
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.
-
- Community Administrator
- Posts: 34421
- Joined: Sat Jan 20, 2007 2:53 pm
- Location: U.S.
Re: Export membership to spreadsheet and/or query interface with LCR?
At one time there was, but most - if not all of them have been taken away "due to privacy reasons".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?
For that, I'd suggest MLS custom reports. (No such feature in LCR - yet.)nasfarley88 wrote:E.g. I would like to search for all members between two ages, and display their baptismal dates.
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.
So we can better help you, please edit your Profile to include your general location.
-
- New Member
- Posts: 13
- Joined: Tue Nov 01, 2011 5:44 am
Re: Export membership to spreadsheet and/or query interface with LCR?
Thanks, I'll have a look into MLS custom reports.
-
- New Member
- Posts: 2
- Joined: Thu Nov 03, 2016 4:54 pm
Re: Export membership to spreadsheet and/or query interface with LCR?
Member information can be exported via the Directory function in the My Ward column.
-
- Community Moderators
- Posts: 9860
- Joined: Mon Mar 17, 2008 12:30 am
- Location: USA, TX
Re: Export membership to spreadsheet and/or query interface with LCR?
There is no export capability from the Directory. It was removed a few years ago.SmithBri wrote:Member information can be exported via the Directory function in the My Ward column.
JD Lessley
Have you tried finding your answer on the ChurchofJesusChrist.org Help Center or Tech Wiki?
Have you tried finding your answer on the ChurchofJesusChrist.org Help Center or Tech Wiki?
- kd7mha
- Member
- Posts: 294
- Joined: Thu Mar 13, 2008 2:27 pm
- Location: Logan, Utah
Re: Export membership to spreadsheet and/or query interface with LCR?
as an assitant Ward Clerk I DO have an export Households option in the Directoryjdlessley wrote:There is no export capability from the Directory. It was removed a few years ago.SmithBri wrote:Member information can be exported via the Directory function in the My Ward column.
There are 11 types of people. Those who understand Gray Code and those that don't.
-
- Community Moderators
- Posts: 9860
- Joined: Mon Mar 17, 2008 12:30 am
- Location: USA, TX
Re: Export membership to spreadsheet and/or query interface with LCR?
It is limited to certain callings rather than to the general membership. The removal of the capability was for the general membership.kd7mha wrote:as an assitant Ward Clerk I DO have an export Households option in the Directory
JD Lessley
Have you tried finding your answer on the ChurchofJesusChrist.org Help Center or Tech Wiki?
Have you tried finding your answer on the ChurchofJesusChrist.org Help Center or Tech Wiki?
-
- New Member
- Posts: 12
- Joined: Sun Nov 16, 2014 12:22 pm
Re: Export membership to spreadsheet and/or query interface with LCR?
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.
-
- Community Administrator
- Posts: 34421
- Joined: Sat Jan 20, 2007 2:53 pm
- Location: U.S.
Re: Export membership to spreadsheet and/or query interface with LCR?
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.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.
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.
So we can better help you, please edit your Profile to include your general location.
-
- Member
- Posts: 68
- Joined: Mon Oct 29, 2012 9:53 pm
- Location: Southern California, United States
Re: Export membership to spreadsheet and/or query interface with LCR?
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?).
I'm not sure who still uses vi or Vim anymore, nor how many are familiar with regexs (the price of progress?).