MISORG is a simple java application that will create Ward organization lists that can be imported into a Palm or other personal digital assistant (PDA).
The lists created include:
Each organization and their respective calls. For example: All calls associated with the Relief Society. Similar to MIS report MIS 121.
Adults without calls. A list of adult members who do not currently have a call assigned to them. Similar to MIS report MIS 123.
Adults who have served for over two years.
Young Men quorums where each quorum is ordered by age (oldest to youngest). For example: All current Priests ordered from oldest to youngest. Similar to MIS report MIS 111.
Young Women groups where each group is ordered by age (oldest to youngest). For example: All current Beehives ordered from oldest to youngest. Similar to MIS report MIS 111.
Elders quorum and High Priests group lists. Similar to MIS report MIS 111.
Current temple recommend holder list. Similar to MIS report MIS 262.
Endowed members not holding temple recommends list. Similar to MIS report MIS 263.
Married members not endowed list. Similar to MIS report MIS 264.
Current missionaries list.
Bishopric Action and Interview List. Similar to MIS report MIS 241.
Relief Society list. Similar to MIS report 111.
Primary list. Similar to MIS report 111.
Sunday School list. Similar to MIS report 111.
Families not assigned home teachers list. Similar to MIS report 1314.
Sisters not assigned visiting teachers list. Similar to MIS report 1414.
Young single adult list. Similar to MIS report 111.
Single adult list. Similar to MIS report 111.
Ward statistics summary.
Step 1) Install Java if needed.
MISORG is a Java application built using Java SDK v 1.3. The 1.3 version of Java can be downloaded here. All you need to download is the JRE which is about 5MB. (MISORG requires a minimum of JDK 1.2)
If using MIS:
Step 2) Generate MEMOUT.DAT, ORGOUT.DAT, and HTVTOUT.DAT from MIS. These files are the data files MISORG processes to create MISORG.CSV.
Step 3) Place MISORG.jar, MEMOUT.DAT, ORGOUT.DAT, and HTVTOUT.DAT in the same folder.
If using MLS:
Step 2) Generate Membership.csv, Organization.csv, HomeTeaching.csv, and VisitingTeaching.csv from MLS. These files are the data files MISORG processes to create MISORG.CSV.
Step 3) Place MISORG.jar, Membership.csv, Organization.csv, HomeTeaching.csv, and VisitingTeaching.csv in the same folder.
Using Ward MIS 4.10 or later:
(Tested using version
4.10h, a user in New Zealand reports that version 4.00f works too)
From the MIS main menu, select menu 3.7.3 (Membership Clerk Menu, System Maintenance Menu, then Generate Ward ASCII Data Files) and export the membership database into ASCII files. The following options will appear on the screen:
Create Member File? (Y/N) -- Enter Y, creates MEMOUT.DAT.
Create Organization File? (Y/N) -- Enter Y if you want to include calling information, creates ORGOUT.DAT. Enter N if you do not want to include that information.
Create Home/Visiting Teaching File? (Y/N) -- Enter Y if you want to include home/visiting teaching assignments, creates HTVTOUT.DAT. Enter N if you do not want to include that information.
Create Field-Delimited DOS Files? (Y/N) -- Enter N.
ASCII Data Files Drive and Directory -- Enter the drive and directory where the output files will be placed.
Once you have selected the export options, press F10 to export the data.
Note: I do not have information for pre-4.10 versions of Ward MIS. If you have access to an older version, please forward the necessary information and/or screen shots and I’ll include it. Please include the version number.
From the main menu, select File then Export. Note: You must be
logged in as someone with all rights.
<Need screen shot here>
Once Java is installed and your membership data files have been created, MISORG is ready to run.
MISORG can be run several ways:
If running Windows, you may be able to simply double-click MISORG.jar.
You can also run the batch file MISORG.BAT to run MISORG.
Finally, from a command-prompt, type java -jar MISORG.jar.
In all cases MISORG.jar must be in the same folder as your membership data files.
Once MISORG has been run, there will be a new file called MISORG.CSV created in the same folder as MISORG.jar.
Once created, it can be imported into the Palm through the Palm Desktop or the Palm file link feature. Once in your Palm (or PDA) each list becomes a separate memo.
MISORG.CSV can be imported into many types of PDAs. I am only documenting the Palm because that is what I use.
From the Palm Desktop:
Create a new memo category
Switch to the new category
Select File | Import
Select the file type: Comma Separated (*.csv, *.txt)
Browse for and select MISORG.CSV
Press Import
Press OK
Now Hotsync your Palm.
To update the memos, from within the Palm Desktop:
Select all memos in the category that contains your MISORG data.
Press Delete and answer to delete the memos.
Now re-import using the same instructions from above.
There are many other ways you can import MISORG.CSV. One is to use the file link feature of the Palm HotSync application. Each PDA has it's own method. If you would like to document your favorite way, I would be happy to add it to this document.
MISLIST aids in creating Ward directories. Simply run MISLIST.BAT and then look for WardList1.txt and WardList2.txt. Each file contains different Ward directory formats. See what you think and let me know any suggestions.
Version 1.0
Ready for suggestions...
Version 1.1
Fixed bug with couple missionary ages. The husband's age was incorrectly displayed for the wife.
Version 1.2
Added birthday list.
Version 1.3
Added statistics summary report.
Version 1.4
Revised the Primary class names.
Added MISList option.
Version 2.0
Added windows interface.
Version 2.1
Added MLS support.
Added adults serving over two years report
Missing: If using MLS, there are no home teaching or visiting teaching reports (yet)
Version 2.2
Added Home Teaching and Visiting Teaching Reports for MLS.
Added ability to select the folder where MIS/MLS data files reside.
Version 2.3
Added support for MLS 2.2
Please e-mail Matt Brooks at mgbrooks@mis2palm.com