Exporting MLS Reports for use in MS Office apps

Discussions around using and interfacing with the Church MLS program.
Bfolker-p40
New Member
Posts: 2
Joined: Wed Dec 12, 2007 1:11 am

Exporting MLS Reports for use in MS Office apps

Postby Bfolker-p40 » Wed Dec 12, 2007 1:25 am

I am new to MLS (just called as the Ward Clerk). I know I can export membership data to .csv files that I can later import into Excel etc., but I would like to know if it is possible to use the "Print to a file" feature for any of the canned MLS reports the same way? What other programs (besides MLS itself) can read files with that file extension? For instance, I created an organizational chart for the entire ward and I want to be able to print the Members with calling (or without) and import those lists into Excel to make sure I have everyone slotted. The only way I can figure out to do that today is to scan in a printed list and use OCR software to convert the printed text to Word and then copy and paste it into Excel.

User avatar
thedqs
Community Moderators
Posts: 1038
Joined: Wed Jan 24, 2007 8:53 am
Location: Redmond, WA
Contact:

Postby thedqs » Wed Dec 12, 2007 8:30 am

I believe as it stands there is no direct access into MLS, so you have to export the csv and then import it into excel (spreadsheet) or access (database) and then create queries to get the information you want and then you can create a report that displays it as you want.
- David

danpass
Member
Posts: 345
Joined: Wed Jan 24, 2007 5:38 pm
Location: Oregon City, OR
Contact:

Copy and Paste MLS report data in delimited form

Postby danpass » Wed Dec 12, 2007 10:17 am

Bfolker wrote:I am new to MLS (just called as the Ward Clerk). I know I can export membership data to .csv files that I can later import into Excel etc., but I would like to know if it is possible to use the "Print to a file" feature for any of the canned MLS reports the same way? What other programs (besides MLS itself) can read files with that file extension? For instance, I created an organizational chart for the entire ward and I want to be able to print the Members with calling (or without) and import those lists into Excel to make sure I have everyone slotted. The only way I can figure out to do that today is to scan in a printed list and use OCR software to convert the printed text to Word and then copy and paste it into Excel.



In any of the MLS reports (canned and custom), if you click in the body of the report and do a control-shift-c, MLS places a delimited copy of the report data into the Windows clipboard. You can then paste the data directly into your spreadsheet.

jander04
New Member
Posts: 26
Joined: Fri Oct 05, 2007 5:37 pm
Location: Phoenix, Arizona

Postby jander04 » Sun Dec 16, 2007 8:56 pm

danpass wrote:In any of the MLS reports (canned and custom), if you click in the body of the report and do a control-shift-c, MLS places a delimited copy of the report data into the Windows clipboard. You can then paste the data directly into your spreadsheet.



This is one of the great mysteries of MLS that is worth its weight in gold. All stake clerks and computer specialists should spread this word to all ward clerks and assistant clerks. I learned about this by calling SLC and complaining that I couldn't export any list, and they told me about the CNTL-SHIFT-C combination. I use it all the time.

Jerry


Return to “MLS Support, Help, and Feedback”

Who is online

Users browsing this forum: No registered users and 1 guest