converting ward lists into excel

Discuss basic duties of stake and ward clerks, including where to begin.
PSpencer-p40
New Member
Posts: 1
Joined: Sat Feb 27, 2010 7:39 pm
Location: Warren, RI, USA

converting ward lists into excel

Postby PSpencer-p40 » Sat Feb 27, 2010 8:32 pm

Okay, real basic question. Hopefully a real simple solution. I'm wanting to put our ward membership into an excel spreadsheet so that I can easily manipulate it to note when people have spoken in Sacrament meeting, etc.

Is there a way to input people's names into excel without having to type them all in manually? I hope so....

And if anyone has any nifty templates that they find helpful, I'd love to take a look.

Thanks,

Peter

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

Postby aebrown » Sat Feb 27, 2010 8:40 pm

PSpencer wrote:Okay, real basic question. Hopefully a real simple solution. I'm wanting to put our ward membership into an excel spreadsheet so that I can easily manipulate it to note when people have spoken in Sacrament meeting, etc.


There are a variety of ways to do this, but the easiest is to copy and paste from MLS using the clipboard. For details, see MLS keyboard shortcuts.

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

Postby russellhltn » Sat Feb 27, 2010 10:59 pm

The problem with using a spreadsheet is keeping it updated without losing the information.

Unless you have a very static ward, I'd suggest looking into some of the MLS companion databases. I think they simplify the update process.

Sorry, I don't have any experience with any of them, so I don't have any recommendations.

Another possibility is to create a custom field in MLS. That way your list of members is always current. Just be sure to do a test by creating a custom report. The greatest weakness of the custom fields is the reporting.
Have you searched the Wiki?
Try using a Google search by adding "site:tech.lds.org/wiki" to the search criteria.

User avatar
marianomarini
Senior Member
Posts: 594
Joined: Sat Jan 19, 2008 3:13 am
Location: Vicenza. Italy
Contact:

Postby marianomarini » Sun Feb 28, 2010 3:12 am

I wonder how easy is to get MLS data in outside world.
My question is: Why keep MLS data security so restricted and let a widely door open?
If security is not an issue, why don't use an open database format? (DB, MySQL, ecc?).
La vita è una lezione interminabile di umiltà (Anonimo).
Life is a endless lesson of humility (Anonimous).

User avatar
thedunsons
New Member
Posts: 21
Joined: Sat Aug 25, 2007 6:07 pm
Location: Washington, DC
Contact:

crude but works

Postby thedunsons » Sun Feb 28, 2010 9:53 am

you can always export as a .csv, which you can even do from the web. Problem is families will be listed on a single line, so you would have to manually eliminate primary children, and then seperate YM, YW, and spouses to separate lines. But it can be done with a little time and TLC. And it would be free!

We maintain a separate Google Doc (spreadsheet) to capture talks. This does require some maintenance, but it primarily serves as a way to organize our sacrament meeting agendas, not to track when the last time Sis NNNNN or Bro HHHHHH gave a talk. Though you can conduct a search and find this info. If you are going to try and track this in MLS, you will find it difficult to include High Council Speakers, other outside of the ward speakers, Full-time Missionaries, etc.

My columns are:

Date, topic, Youth, adult 1, adult 2, adult 3

Just some thoughts from a guy with some experience with this issue.
-mike

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

Postby russellhltn » Sun Feb 28, 2010 11:43 am

marianomarini_vi wrote:If security is not an issue, why don't use an open database format? (DB, MySQL, ecc?).


Security is an issue and not all fields are exported.
Have you searched the Wiki?

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

crislapi
Senior Member
Posts: 1265
Joined: Mon Jul 07, 2008 3:05 pm
Location: USA

Postby crislapi » Mon Mar 01, 2010 11:42 am

An easy way to get it in Excel is to create a custom report in MLS w/ the fields you want and save it as a file (will be a csv, which can then be opened with excel). After you open it in excel, be sure to save it as an xls file.

If you are not able to get access to MLS, you can use the LUWS and save the directory as a csv file.

kisaac
Community Moderators
Posts: 1170
Joined: Sun Oct 21, 2007 5:04 am
Location: Utah, united states

tracking speaking

Postby kisaac » Tue Mar 02, 2010 1:16 pm

PSpencer wrote:Okay, real basic question. Hopefully a real simple solution. I'm wanting to put our ward membership into an excel spreadsheet so that I can easily manipulate it to note when people have spoken in Sacrament meeting, etc.


yes, as others have said, its real simple to get the MLS data to excel. Either make yourself a custom reports showing just the data you need, and Save to a jump drive or desktop. Or, pull up almost any screen with the data you want, and copy then past into your spreadsheet of choice. (I use Openoffice.org)

I export things all the time to spreadsheets to make HT reports, graph attendance data, fill out agenda's, but maintaining a ward list manually would be tough. If there is some "MLS companion" that will help, great. I don't use any.

What we do: Don't track who hasn't spoken, track those who do - its far easier. I'll post sample files in a day or two to show what we do now. Youth are track by year, so we have a running total of each year, and when each youth spoke.

I've entered custom fields into MLS to track speaking, because ultimately I think this will be superior, but it's still in "beta." If I ever get it worked out, I'll post it.

User avatar
marianomarini
Senior Member
Posts: 594
Joined: Sat Jan 19, 2008 3:13 am
Location: Vicenza. Italy
Contact:

Postby marianomarini » Sun Mar 07, 2010 2:09 am

RussellHltn wrote:Security is an issue and not all fields are exported.

I wonder wich one?
If I could set a custom report with that fields included and then print it out into a file (CVS) would MLS deny that operation?
La vita è una lezione interminabile di umiltà (Anonimo).
Life is a endless lesson of humility (Anonimous).

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

Postby jdlessley » Sun Mar 07, 2010 8:05 am

MLS will not export custom report data. It gives that impression from the custom reports management screen but the export there is only to export the filtering criteria and the report format for a custom report. The data does not accompany that export. The MLS export function is limited to the data in the export dialog. Any filtering of data not done by MLS at the export dialog must be done after the data is exported. Since MLS filters some data to be excluded during export there is no other way to include the data other than manually adding it after the export.
JD Lessley
Have you tried finding your answer on the LDS.org Help Center page or the LDSTech wiki?


Return to “Getting Started for New Clerks”

Who is online

Users browsing this forum: No registered users and 1 guest