FYI, we are in the final faze of completing a Stake Directory. The
directory has 3 parts:
-----------------------------
Stake Directory
-----------------------------
1. Stake Organization (3 pages - 15k)
a. Organization
b. Position
c. Name
d. Spouse
e. Email
f. Phone
2. Wards/Branches: (28 pgs, averages 3 pgs p/ ward - 325k)
a. Organization
b. Directory: Family, Address, Phone
3. Stake Phone Directory: (10 pgs - 107k)
a. Last Name (sorting)
b. Head of Household and Spouse
c. Unit Number
d. Phone Number
Points of interest:
- Compact: We have had a focus on making this somewhat compact to save
space
and money. Last years directory was 80+ pages, we have included more
information in this directory, but keeping it half the size
- Our stake has 8 wards, with an additional 2 small branches
- 95% of information is extracted from Stake MLS (I previously had done
this
on a ward level, but am now making these reports at a stake level)
- PDF Format: Because the information is extracted from MLS and because
it's
out of date within less than a month, we are generating these reports in
PDF
Format which can be generated and electronically available once a month.
File size of all reports in less than 500k (250k zipped). Several put
these
pdf files onto their PDA's.
-----------------------------
Template Community
-----------------------------
The reports are template based. I've always felt that we could generate a
community of templated reports. Here's some I've allready created, all
which pull from MLS. Most of the reports are for the leaders of the
organization, and most of them are very compact.. 2 to 5 pages.
- Stake Directory
- Bishopric Ward Directory: : Names, Address, Phone, Home Teachers,
Visiting
Teachers, Callings (6 pages)
- PDA/PDF Version of the above
- Ward Family/Address Booklet Directory:
- 8.5x11 folded in half, tops looke just like White Pages w/ page
numbers
- Ward Organization
- Address: Headers have Alphabet Index (ia Ab - Br)
- Compact Ward Family/Address Directory (2 pgs, or 1 pge double sided)
- PDA/PDF Version of the above
- High Priests Group Report: Names, Address, Phone, Home Teachers, HT
Companion, HT Families
- Elders Report: Names, Address, Phone, Home Teachers, HT Companion, HT
Families
- Elders Photo Directory: Photo, Names, Address, Phone,
- Sisters Report: Names, Address, Phone, Visiting Teachers, VT Companion,
VT Families
-----------------------------
Skills
-----------------------------
Skills Needed to Generate Reports:
- Basic SQL Skills
- Basic Layout Skills (put a box here, put a line there)
- XML Skills (not required, but helpful)
- Also, having a clerk position is helpful
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________
Ldsoss mailing list
[email protected]
http://lists.ldsoss.org/mailman/listinfo/ldsoss
