Print List of Families
-
- New Member
- Posts: 4
- Joined: Fri Dec 09, 2011 3:23 pm
- Location: Long Beach, CA USA
Print List of Families
Is it possible to print a list of families from LCR? I need to export a family list so we can make some other reports/assignments, but I'm only able to print an entire member list (individuals). If it's not possible in LCR is it possible in MLS? (Sorry, not at the church so can't look). Thanks!
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
Re: Print List of Families
In LCR, depending on your permissions, you can go to the Unit Statistics area (under Reports) and then click on Households. It will just show the heads of households, which may not be exactly what you hope for when you ask for a "family list."kylejhunt wrote:Is it possible to print a list of families from LCR? I need to export a family list so we can make some other reports/assignments, but I'm only able to print an entire member list (individuals). If it's not possible in LCR is it possible in MLS? (Sorry, not at the church so can't look). Thanks!
In MLS, you can print various household lists; for example, the Abbreviated Directory will list all the households with both head of household and spouse named.
-
- New Member
- Posts: 4
- Joined: Fri Dec 09, 2011 3:23 pm
- Location: Long Beach, CA USA
Re: Print List of Families
Sounds like MLS is the winner. Thanks for the quick response.
-
- Church Employee
- Posts: 3025
- Joined: Mon Feb 09, 2009 4:55 pm
- Location: Riverton, Utah
Re: Print List of Families
The next LCR release (currently in beta) has some improvements for viewing and printing households.
-
- New Member
- Posts: 7
- Joined: Sun Dec 08, 2013 9:24 am
Re: Print List of Families
So I needed a household list with addresses, and the LCR did not have it. I went to LDS.org and was able to export it to .CSV there. Is there a plan on making reports available in LDS.ORG available on the LCR?
- sbradshaw
- Community Moderators
- Posts: 6245
- Joined: Mon Sep 26, 2011 9:42 pm
- Location: Utah
- Contact:
Re: Print List of Families
There's a checkmark above the Member List in Leader and Clerk Resources to show addresses. With the next release of Leader and Clerk Resources (currently in beta), it will be possible to switch to household view on the Member List, and with addresses checked, that may be what you're looking for.knorseth wrote:So I needed a household list with addresses, and the LCR did not have it. I went to LDS.org and was able to export it to .CSV there. Is there a plan on making reports available in LDS.ORG available on the LCR?
Samuel Bradshaw • If you desire to serve God, you are called to the work.
-
- New Member
- Posts: 7
- Joined: Sun Dec 08, 2013 9:24 am
Re: Print List of Families
Unfortunately the member list in the LCR will not work. The member list shows everyone, children and all on a seperate line. I just want one line per household, the head of house (and spouse) and their address in this case. LDS.ORG did the job, I was able to export this to a .CSV file in LDS.ORG
LCR does not have an export to .CSV option on anything as I can see. Yes I know I can do some things to export a web page to an EXCEL file, but it is not straightforward and is problematic. The ability to export a report to excel to do further slicing and dicing of the data is an important option to me.
Custom reporting I would think would be an important part of the LCR testing. Expose the ability to users like it was available in the MLS and it would help out.
LCR does not have an export to .CSV option on anything as I can see. Yes I know I can do some things to export a web page to an EXCEL file, but it is not straightforward and is problematic. The ability to export a report to excel to do further slicing and dicing of the data is an important option to me.
Custom reporting I would think would be an important part of the LCR testing. Expose the ability to users like it was available in the MLS and it would help out.
-
- New Member
- Posts: 3
- Joined: Fri Feb 04, 2011 6:45 pm
- Location: Seattle, WA USA
Re: Print List of Families
They had restored the ability to export to a . CSV file in the recent beta version were I was able to use it in March 2016, but they took it back out in the final release due to privacy issues. I understand the concerns but there ought to be a way the key holders can export the list
-
- Member
- Posts: 55
- Joined: Sun Feb 05, 2012 9:04 am
- Location: Stavanger, Norway
Re: Print List of Families
If you have Adobe Acrobat Pro (or access to it) you can print what you need to .PDF from the LCR and then inside Acrobat (under tools) you can Export your .PDF to any number of formats including Word, .XLS, .XML, PowerPoint and more. Once in .XLS format it's just another quick step to save it as a .CSV.
As an additional help, every other row in my export had an additional space at the front. This can be cleaned by using the =TRIM(cell) function in the next column (referencing the cell to the left), then copy the results and paste values (Shift-F10, V) to a third column. Then you can delete the first two columns and then perform a "text to columns" (under the data tab) using the comma as the delimiter to make separate lastname, firstname columns (and so forth if you exported address, email etc.)
As an additional help, every other row in my export had an additional space at the front. This can be cleaned by using the =TRIM(cell) function in the next column (referencing the cell to the left), then copy the results and paste values (Shift-F10, V) to a third column. Then you can delete the first two columns and then perform a "text to columns" (under the data tab) using the comma as the delimiter to make separate lastname, firstname columns (and so forth if you exported address, email etc.)