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

#1

Post by PSpencer-p40 »

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

#2

Post by aebrown »

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: 34417
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

#3

Post by russellhltn »

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 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.
User avatar
marianomarini
Senior Member
Posts: 619
Joined: Sat Jan 19, 2008 3:13 am
Location: Vicenza. Italy

#4

Post by marianomarini »

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 7:07 pm
Location: Washington, DC
Contact:

crude but works

#5

Post by thedunsons »

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: 34417
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

#6

Post by russellhltn »

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 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.
crislapi
Senior Member
Posts: 1267
Joined: Mon Jul 07, 2008 4:05 pm
Location: USA

#7

Post by crislapi »

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: 1184
Joined: Sun Oct 21, 2007 6:04 am
Location: Utah, united states

tracking speaking

#8

Post by kisaac »

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: 619
Joined: Sat Jan 19, 2008 3:13 am
Location: Vicenza. Italy

#9

Post by marianomarini »

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: 9858
Joined: Mon Mar 17, 2008 12:30 am
Location: USA, TX

#10

Post by jdlessley »

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 ChurchofJesusChrist.org Help Center or Tech Wiki?
Post Reply

Return to “Getting Started for New Clerks”