home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
database
/
chrchpr4.zip
/
MPROFIL2.DOC
< prev
next >
Wrap
Text File
|
1987-01-06
|
80KB
|
2,047 lines
Section 3.F: MPROFILE SPECIAL PROCESS - Special Files, Reports
F. MPROFILE SPECIAL PROCESS: Special Files, Reports
1. Introduction
This process of MPROFILE allows the operator to create a wide variety of
files and reports related to the MEMBERS file and report system. The
idea is to allow as much flexibility as possible in having the user
define what will be in the file that is made and the report that is
printed. The following is the Menu that results from entering "6" -
"Special File Creation, Reports" from the MPROFILE Main Menu.
Figure 3-7: MPROFILE - Special File Creation, Reports
DATA DISK = B
Special File Creation, Reports 6-/MSPFILES/
1) Display people from a selected file, group
2) Print Full-Information Report
3) Print One-Line Report of a selected file, group
4) Print Mailing Labels of a selected file, group
5) Create a new Special File from selected file, criteria
6) Generate FCMEMBRS file (families), with index
7) Generate MSCROST file (Small Churches), with index
8) Generate MACTIVTY file (Special Activities), with index
9) Generate MSKILLS file (Interests/Abilities), with index
A) Generate SCMEMBRS index file to MEMBERS file.
B) Generate OFFERNDX index file to MEMBERS file
Enter selection :5
Select Input File -
1. Full-Church [MEMBERS]
2. Full-Church, Families [FCMEMBRS--FCMEMBRS]
3. Small Church - children, singles [MSCROST]
4. Special Activities [MACTIVTY]
5. Interests / Abilities [MSKILLS]
7. Special File [-- ? --]
Enter selection :
There are 3 general areas of the above processes:
1) Print/display a report from a selected file, of operator-selected
member records (selection criteria). - From menu selections 1,2,3,4.
2) Create a new, separate file from a specified input file, with
specified information conditions (selection criteria), and to a
specified output file. - From menu selection 5.
3) Create one of the standard secondary files, as required by certain
processes in the MPROFILE program sections. - From menu selections 6,
7, 8, 9, A, and B.
You can make a special report directly, or can make a special file, with
the records that you want in it, then make a report from it. Any Special
File used as input to a report must have all the fields required by that
report. Notice the difference in the data fields of files FCMEMBRS and
MEMBERS.
Page 3-14-1
Section 3.F: MPROFILE SPECIAL PROCESS - Special Files, Reports
2. Print/Display reports from selected file and selected record criteria
This is from the first four menu selection items: File-Display, Full-
Information Report, One-Line Report, and Mailing Labels. The operator
is asked the following questions -
QUERY 1:
Select Input File -
1. Full-Church [MEMBERS]
2. Full-Church, Families [FCMEMBRS--FCMEMBRS]
3. Small Church - children, singles [MSCROST]
4. Special Activities [MACTIVTY]
5. Interests / Abilities [MSKILLS]
7. Special File [-- ? --]
Enter selection :
The operator enters the number of the file to be read from in making the
report. If "7" is selected, the operator is asked the following:
QUERY 2
"Enter desired source file name:"
You must enter the name of a dBASE data file that is on the data
disk. The process will search for it and use it as input. If it is
not found, the following message is displayed:
"This file does not exist on the data disk. Enter again "
The process is continued until it finds the name you enter or until
you enter "Q" for "quit".
QUERY 3:
"Enter selection criteria:"
This is the standard "selection criteria" condition in this
process, as described in paragraph 5, below.
The program immediately begins the display or print-out.
For the display process (menu selection "1"), the following fields are
printed, all on one line -
(3) Small Church (The number in parenthesis is the
(2) MEMBSTATUS number of characters printed, starting
(8) SP:ACTIVTY from the begining of the field.)
(18) Name
(9) home phone
(30) Address
If the operator requests one of the MPROFILE report processes, the
program makes the same operator queries, then passes program control to
the respective MPROFILE Report routine. If the input file is not found
on the data disk, the following message is displayed (same as above):
"This file does not exist on the data disk. Enter again "
Note that the input file does not have a file index attached to it. If
you made a Special File, you can index it, then copy it, indexed, to
still another file, then enter this other file name as the input file to
this process.
If the selection criteria is invalid; that is, there are no such data
field names in the input file, the program will display a SYNTAX error
when trying to make the report. You have to know the proper syntax.
For Full Church reports or reports with large input files and a
selection criteria, the report print-out may go very slow. It takes up
to a second for MPROFILE to look at each record and determine if it
should be printed.
Page 3-14-2
Section 3.F: MPROFILE SPECIAL PROCESS - Special Files, Reports
3. Create a new, separate file from a specified input file -
This process lets you make your own custom secondary file from the
MEMBERS file, or maybe from another secondary file. The file must be a
data-type file, with MEMBERS field names. If you use the FCMEMBRS file
as input, note the restricted field names in the file structure, when
using the file as input to a report. For example, there is no
attendance record in FCMEMBRS (SSSCATTD field). This process is started
by selection "5" from the "Special Files, Reports" menu.
QUERY 1:
"Enter your new Special File name :"
Make up a name for a file that you know does not exist on the data
disk, yet. The program will warn you if it does exist, and lets you
re-enter a name, or write over the old name, whatever you choose.
The result of this process is the creation of a file with this
name.
QUERY 2:
"Enter selection criteria:"
Decide exactly what the data value conditions are that you want for
this file. See below, for a description of "selection criteria".
Once the input file has been found, and the selection criteria
determined to be valid, the program displays the following message and
copies all records that meet the selection criteria from the input file
to the new file:
"Now copying selected records from C:INFILE to C:NEWFILE "
The message "Special File operation is complete. Press <retn>" indicates
completion of the Special File creation. The number of records copied is
displayed just before this message. This number can give you valuable
count information. You could state MEMBSTATUS="Y" as the selection
criteria, copy the MEMBERS file to any new file name, then look at this
count to tell you how many official members are in the church.
Press <return> to return back to the "Special Files, Reports" menu.
4. Create an MPROFILE Secondary File
These processes are for creating one or more of the standard MPROFILE
secondary files, without doing anything with it. You might want to make
a file, then make its report at a later time. The process performs the
exact same routine as when making the secondary file for the reports.
For example, making the MSCROST file here is the same as making it for
when you are making a Small Church report, The query: "Does the MSCROST
file have the latest updates from MEMBERS?" is made, which you would
answer "No". This causes the MSCROST file to be made in the same way as
this Special File creation process.
Making the secondary file is very straight-forward. Just enter the menu
selection that you want, and the program makes the new file directly,
with no queries. The secondary files and the routines that make them are
described in paragraph 3-G.2. The two file indexes to the MEMBERS file
have the following purpose:
- OFFERNDX index - For making the Full-church report, by offering
envelope. Also, this is the same as used in
making CONTRIBUTIONS statements in MCONTRIB
process. of CFINANCE.
- SCMEMBRS index - For Small Church attendance marking and reports
Page 3-14-3
Section 3.F: MPROFILE SPECIAL PROCESS - Special Files, Reports
5. Selection Criteria description
The above processes allow the operator to select only certain records
from the input file to the report. All records in the input
file that do not meet the selection criteria are skipped over; all
others have their data printed, as determined by the particular report.
The operator refers to the structure of the input file for determining
what data field names can be selected. The structures of the MEMBERS
file and the four secondary files are defined in Appendix 3-A. For
example, when using the FCMEMBRS file as input, the data field names
are: FAMILYCODE, LAST:NAME, FIRST:NAME, CHILDREN, ...
The following is an example of a selection criteria. It selects
everyone with ZIP code of 54321 and who has an "X" in MEMBSTATUS, column
3, which the church might have defined to indicate a "handicapped":
$(MEMBSTATUS,3,1)="X" .and. ZIP="54321"
There are three parts to this DBASE "expression":
1. Data names: names of the fields in the data file
2. Comparatives: = > < <> These compare the first field value
to the second and determine if the comparison is TRUE or FALSE.
3. Connectors: .and. .or. .not. The combined conditions of two
statements determine TRUE or FALSE separate from each condition
by itself.
You may select whole data field names or parts of a field. Just say the
field name for the whole field. If you want just a portion, then enter
the dBASE "string" structure, as follows: $(MEMBSTATUS,3,2)
This example looks at only the third and fourth characters of the
MEMBSTATUS field. The 3 is for the 3rd character in MEMBSTATUS, and
the 2 is how many characters you want to be looked at, starting with
character 3. See the DBASE User's Manual for a more complete
description of "strings".
After you enter the field name, enter a comparative right after it.
Comparatives are the standard algebra kinds of symbols, as follows:
= equals < less than
<> not equal > greater than
The program compares the first field/sub-field to the second, using the
specified comparative. If the expression is true, the program thinks
"TRUE" and uses the specified member record to print report line(s). If
the expression is "FALSE" the record is skipped over (not printed).
The third part of the expression is the connector. You can specify that
several conditions be true at the same time for a record to be printed.
For example, to ask if a person is a member AND is in Small Church "C28"
means that both conditions have to be true for the record to be printed,
while if you say OR, only one or the other need be true for the record
to be printed in the report. If you say NOT, the condition must
specifically not be true for the member to be printed. For example:
.NOT. $(MEMBSTATUS,1,1)='Y' means to print all people who are
not official church members. The following are valid Connectors:
.AND. .OR. .NOT.
Examples:
- $(FAMILYCODE,8,2)="2M" All married women
- $(MEMBSTATUS,1,1)="Y".AND.CITY:STATE="Edina" All official church
members that live in Edina. Note that if you shorten the name, the
match only compares as much as you entered. The state was not included
in CITY:STATE.
Page 3-14-4
Section 3.G: MPROFILE SPECIAL PROCESS - Attendance Marking, Reports
G. MPROFILE SPECIAL PROCESSES: Attendance Marking, Reports
1. Overview
MPROFILE can record weekly attendance of individuals in the church, then
report back various attendance information. Attendance can be recorded
(marked) by Full Church (all members, in alphabetical order), or by a
selected Small Church. The Full Church Attendance system is entered by
selecting 2-9 from the MPROFILE main menu. The Small Church Attendance
system is entered by selecting 3-4 from the MPROFILE main menu.
Attendance is expected to be marked each week. A year's attendance
marking is gathered in the MEMBERS file before it is cleared, then set
up for another year. Attendance is "marked" by the program sequentially
displaying each name on the screen, allowing the operator to enter an
"X" (present) or a space (not present). The program transfers this mark
to the particular SSSCATTD field character that is associated with the
week that the operator specifies. When attendance marking is complete
for the week, the operator goes to the "Add New People" section, which
makes MUPDATE-ADDs, and marking the week's attendance at the same time.
After this is complete, the operator can select one or more reports to
be printed related to attendance. These are defined in the Full Church,
or the Small Church Attendance menus, shown below.
Figure 3-9A
Full Church Attendance Marking, Reports 2-9-/FCATTEND/
1) WEEKLY Attendance Check List [OL]
2) Add New People /MUPADD/
3) Mark Attendance - all attenders
4) NEWLY-ACTIVES List [OL]
5) NEWLY-INACTIVES List [OL]
6) 1ST TIMERS List [OL]
7) 1ST TIMERS, Mailing Labels [ML]
8) Full Attendance Report
9) Set up Attendance Marks for a New Year
Enter selection :
1) This is a One-Line list of everyone active in the church. Husbands
and wives are listed separately. It contains the 2 attendance status
codes and the 6 most-recent weeks of attendance at the front of each
line.
2) This performs the MUPDATE-Add function, followed by automatically
marking this week's attendance and marking a "1ST-TIME VISITOR".
3) This enters the attendance marking routine, described in paragraph
3-H3, below.
4) This prints a One-Line report of everyone just calculated to be a
regular as of this week - 3 times present in the last six.
5) This prints a One-Line report of everyone just calculated to be
inactive as of this week - three absences in a row.
6) This prints a One-Line report of everyone just entered new this week.
7) This prints Mailing Labels of everyone just entered new this week.
8) This prints a special report showing everyone's name, followed by a
series of X's each one signifying an attendance for a week, starting
with the beginning of the attendance year.
9) This clears all attendance marks in the SSSCATTD field. Then it
moves the last 5 weeks over to the front of the field, which carries the
last weeks of last year over for starting the new year with.
Page 3-14-5
Section 3.G: MPROFILE SPECIAL PROCESS - Attendance Marking, Reports
Figure 3-9B Small Church Attendance Marking, Reports
Small Church Attendance Marking, Reports 3-5-/SCATTEND/
1) Small Church MONTHLY Attendance Check List [MA]
2) Small Church WEEKLY Attendance Check List [OL]
3) Mark Attendance, by Small Church /MUPADD/
4) NEWLY-ACTIVES List [OL]
5) NEWLY-INACTIVES List [OL]
6) 1ST TIMERS List [OL]
7) 1ST TIMERS, Mailing Labels [ML]
8) Full Attendance Report
9) Set up Attendance Marks for a New Year
Enter selection :
1) This is a report of everyone active in specified small churches, with
date spaces for each week of the up-coming month. It does not use any
attendance marking, but is rather just a list of everyone active in the
particular Small Churches - attendance marking is optional when using
this report.
2) This is a One-Line list of everyone active in the specified Small
Church. Husbands and wives are listed separately. It contains the 2
attendance status codes and the 6 most-recent weeks of attendance at the
front of each line.
3) This performs the MUPDATE-Add function, followed by automatically
marking this week's attendance and marking a "1ST-TIME VISITOR".
3) This performs the attendance marking routine, described in paragraph
3-H3, below.
4) This prints a One-Line report of everyone just calculated to be a
Newly-ACTIVE, as of this week.
5) This prints a One-Line report of everyone just calculated to be
INACTIVE as of this week.
6) This prints a One-Line report of everyone just entered new this week.
7) This prints Mailing Labels of everyone just entered new this week.
8) This prints a special report showing everyone's name, followed by a
series of X's, each one signifying an attendance for a week, starting
with the beginning of the attendance year.
9) This clears all attendance marks in the SSSCATTD field. Then it
moves the last 5 weeks over to the front of the field, which carries the
last weeks of last year over for starting the new year with.
Page 3-14-6
Section 3.G: MPROFILE SPECIAL PROCESS - Attendance Marking, Reports
2. Attendance Marking Start-up
The operator needs to know the meaning of the following Set-Up
parameters, as used by the Attendance Marking routines:
- "This month's dates" - in the MONTHLY Attendance Check List, used
for the column header for each week's check off space.
- "This week's dates" - in most of the Attendance processing, is the
sequence of date names for the year. Each date name is in MM/DD
format, and has five characters plus a space. The start-up part of
the Attendance process reads and displays these names, allowing the
operator to select one of the weeks as the current week. The week
number that is shown with the name is the week number in the year.
An attendance year may start anywhere in the calendar year -
September is good to pick. The SSSCATTD field has its 6th character
being equal to the 1st week of the calendar year - the first five
characters are cary-over from the previous year, for continuity.
Marking attendance involves having the program call up names, in
sequence, then the operator marking "X" (present) or space (absent) to
each name. After you have entered the "X" or space, the program enters
your mark into the SSSCATTD field at the current week, then calculates a
new status condition for the person you are on. (Actually, pressing any
key except (space) "Q" or "!" is the same as marking "X". Status
conditions are contained in two attendance status characters, stored in
the 7th and 8th characters of the MEMBSTATUS field of each person.
These two characters are called the NEW Counter and the ACTIVE Status.
They can have the following values:
- NEW counter - 1, 2, or 3 for 1st, 2nd or 3rd time present.
- "I" for "just made inactive this week"
- ACTIVE Status - (space) - a regular attender
- "N" - a NEW person; NEW counter mark indicates
the number of times present, so that after 3 times
present out of 6, "N" is changed to "X" (Newly-
Active)
- "X" - Newly-Active
- "*" - Inactive; is automatically marked after the
week this person appears on the Newly-Inactives
list
- "A" - Active override; when a person is known to
miss several times but also known to be a regular.
for example, someone on business out-of-town for a
month. Don't forget that he/she will stay
permanently "Active" until this status is manually
changed.
Page 3-14-7
Section 3.G: MPROFILE SPECIAL PROCESS - Attendance Marking, Reports
3. Attendance Marking
Starting up attendance marking and reports requires that you have set
the Attendance dates in the set-up parameters, and you have cleared the
SSSCATTD attendance marks from any previous year (menu selection "9").
Then you can go right into the "Mark Attendance" routine, as selected
from the menu. The program first asks you to specify one of the dates
you previously set up in the parameters as being the current week. There
is a little trick with this entry: If you enter a dash (-) after the
week number, the program asks for a last name to start at. This lets
you start in the middle of your file, in case you have previously
made some attendance marking. If you are marking attendance for a Small
Church, the computer will ask for you to specify a valid Small Church
code. Then the program goes straight to the MEMBERS file and displays
names for you to make an attendance mark next to. The following Figure
is a typical screen display, during attendance marking:
Figure 3-9C - Attendance Marking Screen
1N XX XXX :c: Anderson Pat 436-5904
A X :c: Baker Sam 944-5044
I X : : Carlson Barb 833-4033
New Counter : : Active Status :A: Today's Attendance : : Daniels Lois
XXXX X :x: Emerson Charles 388-4093
Each name appears individually, with the cursor at the attendance mark
spot on the screen - between the two colons. The fields on the far left
are the two STATUS characters and the five most-recent week's attendance
marks ("X" = present). You press just one key to mark the attendance,
then the program calculates the new attendance status and brings up the
next name. After a screen is full, the program pauses with a short
operator query, then clears the screen and brings up the next name.
The following rules apply to attendance marking:
1. Enter a mark for "present" or a space for "not present"
2. Any character except ! or q or Q may be entered as an attendance
"mark". The program will read it, then place an "X" in the attendance
record (SSSCATTD field) in place of it.
3. The "!" allows the operator to manually change either the NEW
Counter or the ACTIVE Status value from the MEMBSTATUS field. These
values are normally calculated automatically. For example, you may
want to manually enter a value for making a person "permanent" (ACTIVE
Status="A").
4. The "q" or "Q" are read as an indication that you want to stop
editing, and return to the previous menu before getting through all
the names. Remember that you can start up in the middle of the file,
later, by entering a dash (-) after the current date week query, then
enter a starting last name.
Page 3-14-8
Section 3.G: MPROFILE SPECIAL PROCESS - Attendance Marking, Reports
The following are the rules for the new computer-calculated attendance
Status values:
1. Entering new names causes the two status characters to become "1N"
(first-time visitors)
2. Marking the attendance as "present" for a previous "1N" causes the
New counter to be incremented - becoming "2N"
3. Marking the attendance as "present" for a previous "2N" causes the
New counter to be incremented - becoming "3N". If there have been 3
weeks present in the last six, then this status is changed to " X".
This means "Newly-Active". Then this person will appear on the Newly-
Actives list for this week. The next pass through Attendance Marking
wipes out this " X", leaving a blank, so that this person will not
appear on the Newly-Actives list again.
4. When a person has been a regular - has blank status characters -
then attendance is just marked the the SSSCATTD field of MEMBERS, with
no change in the statuses. This is unless the following happens ...
5. If a person has three absent marks in a row, counting the current
mark (you will see two spaces plus have just marked the third
absence), the program will mark the person as a Newly-Inactive,
designated by "I" in the NEW Counter. This will only happen when
there is no Active override in the ACTIVE Status. This Newly-Inactive
mark will stay in the record until the next week's Attendance Marking.
The Newly-Inactives report will print him/her, until the next week.
6. Individuals marked Newly-Inactive the previous week have their
ACTIVE Status value converted to a "*". Church follow-up can call
this person and then report back to the computer attendance marker
(operator), via the Attendance Marking report, any people wanted to be
kept on the rosters as active. Then the operator can manually mark the
ACTIVE status as something other than "I " or " *". If just a space is
marked, the name will again show as a Newly-Inactive, on the following
week, so you probably want to mark something else.
Page 3-14-9
Section 3.G: MPROFILE SPECIAL PROCESS - Attendance Marking, Reports
4. Attendance Reports
After attendance marking is complete for a week, the church chooses
which reports they want to use for their program, as shown on the
Attendance menus. The current attendance is good in the reports only
until the next attendance marking is made. Entering the attendance for
another week changes the 1st-time, 2nd time, Newly-active, etc.statuses.
The week number/name on the report is the SYSTEM DATE, not the
number/name entered by the operator.
Year-end processing. The church will have defined a year's span for
recording church attendance. At the end of this year - when you are at
either week 52 or week 53 - the SSSCATTD field will have no more room
for attendance marks. The 9th process on the Attendance menu causes the
last 5 week's attendance of the previous year to be carried over to the
front of the field, then the rest of the field cleared. This is all
quite automatic. After you do this, you are ready to define the week
names (dates) for (each Sunday of) the next year. Then the Attendance
marking cycle begins again. You probably want to save the MEMBERS file,
first, in order to have an attendance record saved.
Figure 3-9D - Full Attendance Report
Career II Weekly Attendance Report week of 04/09
XX XXX Anderson Pat 436-7759
3N X XX Baker Dan 533-5212
A X XXX Decker Carl 866-7558
5. Year-end processing.
The church will have defined a year's span for recording church
attendance. At the end of this year - when you are at either week 52 or
week 53 - the SSSCATTD field will have no more room for attendance
marks. The 9th process on the Attendance menu causes the last 5 week's
attendance of the previous year to be carried over to the front of the
field, then the rest of the field cleared. This is all quite automatic.
After you do this, you are ready to define the week names (dates) for
(each Sunday of) the next year. Then the Attendance marking cycle
begins again. You probably want to save the MEMBERS file, first, in
order to have an attendance record saved.
Page 3-14-10
Section 3:H MPROFILE - Pastoral Calling
H. Pastoral Calling
Pastors can use this process to record the dates that pastoral calls are
made. The program will save the dates, then recall individuals who have
not been called in a certain number of months. All calls are expected
to have been made within a year's span. The pastor or office worker can
ask for pastoral call names to be displayed on the screen, or to be
printed.
1. Recording call dates -
The operator marks pastoral call dates by selecting the "Pastoral
Call" process of MPROFILE-Update. Enter DBASE, and MPROFILE with
the SYSTEM DATE set to the date that Pastoral Calls were made. On
entering "1" from the main menu, the MMPROFILE-Update menu is
displayed. The operator enters "P", then is prompted for a name in
the same way as for making a name change. The program finds the
name and displays it, then marks the pastoral call date with the
SYSTEM DATE. The date is in YY\MM\DD format (year is first),
although that is transparent to the operator. The screen will
simply display the message:
"The above name now has today's date for pastoral call."
2. Calling up the Pastoral Call section -
The operator enters "7" from the MPROFILE Main Menu to start up the
Pastoral Call section. Pastoral Call dates need to have previously
been marked from the MPROFILE-Update Process (step 1, above).
The following Figure is displayed:
Figure 3-H
PASTORAL CALLING
This routine assists in recording and reporting back information about
your past congregational calling. The first step is to establish a
calling record. Mark congregation MEMBER records with the date that you
made a pastoral call to them: with the computer date set to the date of
some calls, go into the MPROFILE-Update process and select "P" for
Pastoral Call. The program will ask for a name, then will record the
system date into CALLING of that member's record. (Always mark only the
head-of-househole's record.) After this has been done for several
months, you are ready to query your calling history. This routine asks
for the number of months that you allow between calls, then displays all
names that have been called and have a last-called date farther back
than the number of months you allow between calls.
Now indexing the MEMBERS file by CALLING date.
100 RECORDS INDEXED
102 RECORDS INDEXED
Select one of the following functions.
1) Display calls that are due
2) Display a history of all calls
Enter selection: 1
Enter length of calling period, in months:8
Page 3-14-11
Section 3:H MPROFILE - Pastoral Calling
3. Pastoral Call Reports -
Entering this selection causes the program to read the MEMBERS file
in pastoral call date order, starting with the oldest date first.
The program will only display dates a year or less old. The two
reports have exactly the same format and perform virtually the same
process. The only difference is that the second displays all
pastoral call dates in the past year, while the first displays only
names of people who are over-due for a call. Only the first process
makes the second query: "Enter length of calling period, in months:"
The names of people found will be displayed on the screen in the
following format:
04\23\84 Paul Johnson 1397 Oak Grove, Thriving City, MN 55555
05\17\84 Mary Anderson 1241 Pine Place, Thriving City, MN 55555
Notice the following display characteristics:
- The calling date on the left is in reverse-date order - oldest
date is first.
- Only the head-of-household is named. You should just mark the
head-of-household with the calling date, then refer to a separate
list for the spouse's name. The person displayed is married when
there is an "=" in front of his/her name. Also, the dash (-) in
front of the name indicates that the person is an official church
member.
- The address may be shortened, in order to fit on the screen in
one line.
- The information that is displayed can also be printed. Just
press <ctrl-P> after the last response that you make to the queries.
Don't forget to have the printer turned on and be on-line.
- Entering "Q" exits this process.
Page 3-14-12
Appendix 3-A - MPROFILE Files
1. MEMBERS file
This file is the central file of the MEMBERS program. All individual
membership information is recorded in it. From it, reports can be made
directly, or it can be used to generate several secondary files. These
secondary files - FCMEMBRS, MSCROST, MACTIVTY, MSKILLS - get all their
information from the original MEMBERS file. The MEMBERS file has a
standard index file - MEMBERS.NDX - which keeps the sequence order
continually on the fields LAST:NAME, FIRST:NAME. If you used the file
without this index attached (say "USE MEMBERS", from the dBASE prompt),
then you could list out the file in the order that the records were
originally entered. The MPROFILE program also uses two other index
files in its processes - SCMEMBRS, for Small Church attendance marking;
and OFFERNDX, for contributions statements printing. These processes
automatically create their respective index file when about to use it.
The following is the MEMBERS file structure -
Name Type Number of
characters
LAST:NAME C 15
FIRST:NAME C 14
FAMILYCODE C 9
HOME:PHONE C 9
ADDRESS C 25
CITY:STATE C 20
ZIP C 6
ZONE C 4
BIRTHDATE C 12
SPEC:DATES C 18
MEMBSTATUS C 10
OFFERINGEN N 5
WORK:PHONE C 9
SS:SC:MEMB C 5
TEACH:SSSC C 5
SP:ACTIVTY C 20
SKILLS C 30
OTHER C 24
COMMENTS C 20
SSSCATTD C 59
CALLING C 8
DATES C 10
---
338
Page 3A-1
Appendix 3-A - MPROFILE Files
2. FCMEMBRS File
This file is generated for use by reports that have members grouped by
families. These are: full-church roster; Small Church reports, by
couple, and mailing labels, by household. This file is created by the
MGFCROST program module (file). This file has two file indexes:
1) FCMEMBRS, which is an index on LAST:NAME, FIRST:NAME;
2) FCRSCNDX, which is an index on SS:SC:MEMB, LAST:NAME, FIRST:NAME.
The following is the FCMEMBRS file structure -
Name Type Number of
characters
FAMILYCODE C 7
LAST:NAME C 15
FIRST:NAME C 30 (husband's, then wife's first names)
CHILDREN C 50 (each child's first name)
HOME:PHONE C 9
WORK:PHONE C 9 (usually the work phone of the husband)
ADDRESS C 25
CITY:STATE C 20
ZIP C 6
ZONE C 4
BIRTHDATE C 17 (Husbands, then wife's birthdates)
SPEC:DATES C 18
MEMBSTATUS C 10
SS:SC:MEMB C 5
CALLING C 8
DATES C 10
---
236
3. MSCROST File
This file contains all the information of all people in Small Churches.
It has the file index of MSCROST, which is indexed on SS:SC:MEMB+
LAST:NAME+FIRST:NAME. The MGSCROST program module generates the
MSCROST file. The fields in MSCROST are exactly the same as the MEMBERS
file fields.
4. MACTIVTY File
This file contains all the information of all people who are in Special
Activities. Each person appears in this file once for every activity
recorded in his/her SP:ACTIVTY field of MEMBERS file. The MGSAROST
program module generates the MACTIVTY file. The fields in MACTIVTY file
are exactly the same as the MEMBERS file fields. File index MACTIVTY is
indexed on SP:ACTIVTY+LAST:NAME+FIRST:NAME.
Page 3A-2
Appendix 3-A - MPROFILE Files
5. MSKILLS File
This file contains all the information of all people who have indicated
one or more Interests/Abilities. Each person appears in this file once
for every Int./Ability recorded in his/her SKILLS field of MEMBERS file.
The MGIAROST program module generates the MSKILLS file. The fields in
the MSKILLS file are exactly the same as the MEMBERS file fields. File
index MSKILLS is indexed on SKILLS+LAST:NAME+FIRST:NAME.
6. MDIRFILE File
This is the Names Directory file, as used in MPROFILE start-up to get
church and computer parameter values for use by the regular MPROFILE
processes. It contains all variables that are commonly used, so that
they are recorded once, then recalled automatically, when needed. The
MPROFILE, SET UP process allows operator entry and change to these
variables. The following are the variable names and sample values that
appear for the operator to change.
EDITING STANDARD CHURCH PARAMETERS
Church name :Grace Church :
Disk I.D. containing data files :A :
Mailing labels spacing : 6:
Mailing labels, lines per page :66:
Mailing labels, 1st column :6 : - 2nd column :40:
PRINTER SET-UP SPECIAL (ASCII) CHARACTERS :30 06 :
Voting age :18: New letter separator :No :
Zone Marking :No : Use 9-digit ZIP? :No :
Dates format: MM/D1 MM/D2 MM/D3 MM/D4 MM/D5 YYYY
This month's dates: 3/4 3/11 3/18 3/25 1981
This year's dates : 9/1 9/8 9/15 9/22 9/29
10/5 10/12 10/19 10/26
11/2 11/9 11/16 11/23 11/30
12/5 12/12 12/19 12/26
1/2 1/9 1/16 1/23 1/30
2/6 2/13 2/20 2/27
3/4 3/11 3/18 3/25
4/2 4/9 4/16 4/23 4/30
5/7 5/14 5/21 5/28
6/3 6/10 6/17 6/24
7/1 7/8 7/15 7/22
8/3 8/10 8/17 8/24 8/31
Most fields are self-explanatory. "This year's date are for attendance
marking and used in weekly attendance marking. "This month's dates" goes
on the monthly attendance check lists. Each line is one month. Three
lines in a row are not allowed to contain more than 14 weeks of dates.
The PRINTER SET-UP, SPECIAL (ASCII) CHARACTERS are 2-digit decimal
values for special ASCII characters that your printer might need to have
sent to it before printing reports. Zone marking allows the 4-digit
zone field to appear on the MUPDATE-ADD screen. The new letter
separator relates to the 2-column roster and the full church directory.
It causes an indented single letter to be printed when the first letter
of the next last name has changed.
Page 3A-3
Appendix 3-A - MPROFILE Files
The rest of the MDIRFILE identifies particular names and abbreviations
to Small Churches, Special Activities, SKILLS and OTHER groups.
The base MDIRFILE is called MDIRFILX. It becomes MDIRFILE during the
initialize process. It has the following contents. You can see how
directly it correlates to the Names Directory Change menu, shown above -
A Grace Church
B Data files disk: A
C Dates of the month: (1984
D01/01 01/08 01/15 01/22 01/29
E 9/1 9/8 9/15 9/22 9/29
F10/5 10/12 10/19 10/26
G11/2 11/9 11/16 11/23 11/30
H12/5 12/12 12/19 12/26
I 1/2 1/9 1/16 1/23 1/30
J 2/6 2/13 2/20 2/27
K 3/4 3/11 3/18 3/25
L 4/2 4/9 4/16 4/23 4/30
M 5/7 5/14 5/21 5/28
N 6/3 6/10 6/17 6/24
O 7/1 7/8 7/15 7/22
P 8/3 8/10 8/17 8/24 8/31
Q
R Printer: 30
S MAILING LABELS SPACING: 06
T MAIL.L. LINES PER PAGE: 66
U MAIL LABELS, 1ST COLUMN: 6
V MAIL LABELS,2nd COL(OPT):41
W Voting Age: 18
X New-Letter Separator? No
Y Zoning? Yes
Z Use 9-digit ZIP code? No
a
b
c
SCH: Schools
SPAC: Special Activities
SSSC: Small Church classes
SKLS: Interests/Abilities
7. MPROFILE Working-storage Files
The following files are on the MPROFILE diskette, and are used in
various places of the MPROFILE processes. The user need not know
where or how. Just make sure that they are on the disk; otherwise, the
program will sometimes display the message - COMMAND FILE CANNOT BE
FOUND - and would just terminate, returning to the DBASE prompt (.).
Working-storage files:
FILLFILE.DBF, FCMEMBRX.DBF, MEMBERSX.DBF, MDIRFILX.DBF
Page 3A-4
Appendix 3-A - MPROFILE Files
8. Church Membership Information Form
Each church will need to determine what information it wants to request
about its membership. The kinds of information to be asked of people
should be carefully thought about. The membership should understand why
they are being asked and what the information will be used for. This
can be a very sensitive subject. You can imagine the many ways that the
distribution of church or church group rosters can be abused. Most women
in our society, especially in large cities, are careful about how their
home phone is given out. Birthdays can be a sensitive subject, also.
The local church should get a pulse on how people feel about how their
home and family information should be used. You may want to say in an
information poll, what part of the information will be given to people
outside of the church office. The following is an example of an
information questionaire that could be sent to church members/attenders.
You might write a personal letter about the form to send with it.
Page 3A-5
Appendix 3-A - MPROFILE Files
Figure 3A-1 - Church Membership Information Form
LAST NAME _____________________ HOME PHONE __________ WORK ___________
HUSBAND'S NAME ___________________________ BIRTHDATE _________________
(or single man) DATE BAPTISED _____________
WIFE'S NAME ___________________________ BIRTHDATE _________________
(or single woman) DATE BAPTISED _____________
HOME ADDRESS _____________________________ WEDDING ANNIVERSARY
_____________________
City, State, ZIP _________________________
CHURCH ACTIVITIES HUSBAND WIFE
----------------- ------------------- ---------------------
Small Church ___________________
Teach Sunday School? ___________________ ____________________
Wednesday nights ___________________ ____________________
Committees, ___________________ ____________________
other activities
___________________ ____________________
Interests / Abilities ___________________ ____________________
(see attached names list)
___________________ ____________________
Comments ____________________________________________________________
____________________________________________________________
CHILDREN
--------
1. NAME _______________________________ BIRTHDATE ___________________
SUNDAY SCHOOL ______________________ SCHOOL _____________________
Church Activities __________________ GRADE ________
____________________________________ COMMENTS ____________________
2. NAME _______________________________ BIRTHDATE ___________________
SUNDAY SCHOOL ______________________ SCHOOL _____________________
Church Activities __________________ GRADE ________
____________________________________ COMMENTS ____________________
(use other side, for more children)
Page 3A-6
Appendix 3-B - MPROFILE Reports
The MPROFILE program makes a wide assortment of reports. These reports
can include all church members or a selected group of people. The
reports are made by special report program modules (files) that are
called by one or more of the MPROFILE processes. For example, the 2-
column roster is from program module M2COLROS, and is called by SCREPORT
and by SAREPORT. Mailing labels and the one-line report are called from
10 or 12 different places each. The following is a list of the reports,
followed by the processes that call them. The 2-character codes in
brackets are the codes used for these reports throughout this manual.
[FI] FULL-INFORMATION - A five line report of all fields in MEMBERS
> 1-1-/FCREPORT
> 6-2-/MPRSETUP (user-specified file)
[TL] TWO-LINE - A report with two lines of information per
person
> 2-2-/FCREPORT
> 3-2-/SCREPORT > 4-2-/SAREPORT
[OL] ONE-LINE - A report with one line of information per
person
> 2-3-/FCREPORT > 2-9-3,4,5,6-/FCATTEND
> 3-2-/SCREPORT > 4-1-/SAREPORT
> 5-1,2-/IAREPORT > 6-3-/MPSFILES
> 7-2-/FCSURVEY > 8-2,3,4-/FCALLING
[MA] MONTHLY ATTENDANCE - A report formatted for individual attendance
check-off over the period of a month. It can
be made only for Small Church groups.
> 3-4-1-/SCATTEND
[2C] 2-COLUMN ROSTER - A roster of everyone in the selected
function, listed alphabetically, in two
columns
> 3-3-/M2COLROS
[ML] MAILING LABELS - A print-out of names and addresses formatted
to fit on special-form labels. Such labels
can have one or two columns of labels.
> 2-6,7,8-/FCREPORT > 3-9-/SCREPORT
> 4-7-/SAREPORT > 5-3,4-/IAREPORT
> 6-4-/MSPFILES > 2-9-7-/FCATTEND
[CL] CHANGES LISTS - A one-line report of a selected group of
people, usually with changes in the last month
> 2-5-1-/MSPMINAC > 3-5,6,7,8
> 4-4,5,6-/SAREPORT > 5-1,2-/IAREPORT
[FD] F.C. DIRECTORY - A directory of everyone in the church, by
family
> 2-4-/FCREPT4
Page 3B-1
Appendix 3-B - MPROFILE Reports
MEMBERSHIP REPORTS
Church | Full- Small Special Interests/ Special
Report Group | Church Church Activity Abilities File
Format___________|______________________________________________________
|
Full Information | X (X) (X) (X) X
[FI] |
One-Line [OL] | X X X X X
|
Full-Church | X
Roster [FR] |
2-column Roster | X X (X)
[2C] |
Attendance | X (X)
Check List [AC2|
Attendance | X (X)
Report [AR] |
Mailing Labels | X X X X X
[ML] |
Monthly birthdays| X X X
New people/ |
address changes|MC]
------------------------------------------------------------------------
X - report is available for the selected category of people
(X) - report can be made, but only indirectly, through special user
commands; for example, to make a full-information report of the
Adult Choir, select Special File Reports from the Main Menu, then
select "6" for full information. Enter MACTIVTY as the "special
file", then enter ACH (Adult Choir).
NOTE: There are many special features to these reports, such as:
1. Mailing labels to all people with offering envelopes, by family
2. Variable mailing label spacing on the page, in order to have
automatic sheet-feed printing of a printed mail item, rather than
having to print separate labels.
Also, accomodates for various sizes of mailing labels.
3. Birthdays, school names, Bible study group names etc, can
optionally be listed for any Small Church or special activity.
4. The "Special File" is a file the user can easily have the computer
make, separate from the regular files that has only the people that
the user selects.
Page 3B-2
Appendix 3-B - MPROFILE Reports
Figure 3B-1 - Full Information Report [FI]
Grace Church - Full Membership Report March 1, 1984 Page 1
ANDN0014 SC:PR2 Andersen, Ann TEL:436-7768 635-4362
MEMB:N E# 12514 Fordham Court, Apple Valley, MN 55124
ACTY:SPA,CC2, OTHER:SCH=001, 1283,0284
283 I/A:CA,SA, BD:07/22/73-91 08/22/82,
(comments)
ANDN0012M SC:C28 PR2 -Andersen, Patricia TEL:436-7768
MEMB:Y E# 11 12514 Fordham Court, Apple Valley, MN 55124
ACTY: ACH,SPA" OTHER:SCH=001 1283,0284
284 I/A: BD:01/18/56- 03/22/69,09/21
ANDN0011M SC:C28 -Andersen, Irvin TEL:436-7768 429-9823
MEMB:Y ENVL# 11 12514 Fordham Court, Apple Valley, MN 55124
ACTY: OTHER: BSG=001 1283,0284
BD:01/18/56- 06/17/62,09/21
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
========================================================================
Report Explanation -
1. This is the work-horse report of MPROFILE. It tells everything
about everyone in the church. It has enough information that it should
probably be kept in a secured place so that church members that happen
to be in the church office can't easily glance through it.
2. Most information is self-explanatory. The following are explanations
of certain fields -
- line 1, f1 - FAMILY CODE
- Line 1, f3 - Name, preceeded by a dash (-) if the person is a
member
- line 2, f2 offering envelope number ("E#")
- line 3, f3 - DATES: month,year first entered, then month,year
of last address/phone change
- line 4, f1 - record number in the MEMBERS file.
- Line 5 (if printed) - the attendance record. Each "X" is a
"present" mark for a particular Sunday, starting with the
first date in the Attendance dates in the Names Directory
Page 3B-3
Appendix 3-B - MPROFILE Reports
Figure 3B-2 - Two-Line Report [TL]
Primary, Grades 1 - 3 September 16, 1984
Birthdate PHONE NAME Address
11/21/78- 866-6332 Jim Baker 2345 Berea Dr., Thriving City
4 N School: Roosevelt Elementary DATES:1283,1283 BA:
05/30/77- 2 871-6176 Terri Bruns 4561 Lyndale Ave S. Mpls 55473
46 N School: Roosevelt Elementary DATES:1283,1283 BA:
07/18/77- 2 429-0308 Melanie Carlson 2407 E. 28th St. Mpls,MN 55442
48 N School: Roosevelt Elementary DATES:0284,0284 BA:
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
========================================================================
Report Explanation -
1. This report is designed for the leader of Small Churches or Special
Activitites. It includes the year of birth, so might be considered to
be a confidential list when used with adult groups.
2. The 3rd field of the second line is a variable field; that is, it
can have different fields in it depending on what the operator said when
starting the report. The standard field name is the SP:ACTIVTY field.
This example has the School name for this field, which is from the OTHER
field of MEMBERS file. SCH (school) This is valid only when the church
has defined itas an OTHER category name. The operator enters any OTHER
field code that is desired, when making this report from the Small
Church reports, or the Sp. Activities reports.
3. The report fields are as follows:
line 1, f1 - Birthdate
line 1, f2 - Grade in school (only when the backwards slash was
entered after the report selection number, when ADDing
an OTHER code.
line 1, f3 - home phone
line 1, f4 - first, then last name. A dash in front of the name
means "member".
line 1, f5 - home address; includes city, state, and zip, when
there is room to print it
line 2, f1 - record number in the MEMBERS, MSCROST, or MACTIVTY
file (note that this number cannot be used to find
somebody from MEMBERS Update when this is a Small
Church or Special Activity report.
line 2, f2 - MEMBSTATUS field, characters 3 and 4 (user-defined)
line 2, f3 - Variable field: Default field is SP:ACTIVITY
Can also be a particular OTHER field. For example,
you can ask for the Bible study groups that the
Adult Choir members are in.
line 2, f4 - DATES field - month,year first entered, and month,
year of the most recent address/phone change
line 2, f5 - Year of baptism/confirmation
line 2, f6 - COMMENTS
Page 3B-4
Appendix 3-B - MPROFILE Reports
Figure 3B-3 - One-line Report [OL]
Church 28 March 21, 1984 Page 1
SP.ACTIVITY Name Phone Address
ORK, -Irvin Andersen 436-7768 12514 Fordham Court, Apple Valle
-Evelyn Andersen 436-7768 12514 Fordham Court, Apple Valle
-Dr. Kenneth Baker 866-6332 2345 Berea Dr., Thriving City,
-Karen Baker 866-6332 2345 Berea Dr., Thriving City,
Arthur Bruns 871-6176 4561 Lyndale Ave S., Mpls, MN
Mary Bruns 865-7682 4561 Lyndale Ave S., Mpls, MN
-Leonard Carlso 429-0308 2407 E. 28th St., Mpls, MN
ACH,MIS" -Linda Carlson 429-0308 2407 E. 28th St., Mpls, MN
Bev Larson 536-9668 5470 53rd Ave N. Apt 271, Mpls,
Harvey Larson 536-9668 5470 53rd Ave N. Apt 271, Mpls,
Frank Warner 826-9943 5330 Grand Ave S., Mpls, 55446
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
========================================================================
Report Explanation -
1. This is the most common report format. It has just the Special
Activities field, the Name, the Phone, and the Address fields.
2. A special form of this report is in the Full Church reports menu.
The one-line report, by offering envelope, prints all individuals with
envelope numbers, in envelope number order. There is a line with just
the envelope number printed for un-assigned numbers. The office can use
the report to easily see which numbers to assign new people. Then the
person assigning the number writes the name in the blank line with the
number.
Page 3B-5
Appendix 3-B - MPROFILE Reports
Figure 3B-4 - Monthly Attendance Check List [MA]
Church 28 Attendance Check List -- March, 1984
Please check the column under today's date and beside your name. Also,
mark any recent change of address or phone number underneath your name.
New people, please record your attendance on the last page.
03/02 03/09 03/16 03/23 03/30 ________________________________________
Andersen, Evelyn TEL: 436-7768
_____ _____ _____ _____ _____ 12514 Fordham Court, Apple Valley, 55124
________________________________________
Andersen, Irvin TEL: 436-7768
_____ _____ _____ _____ _____ 12514 Fordham Court, Apple Valley, 55124
________________________________________
Baker, Karen TEL: 866-6332
_____ _____ _____ _____ _____ 2345 Berea Dr., Thriving City, MN 55555
________________________________________
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
========================================================================
Report Explanation -
1. This report is for passing around to the Small Church groups during
class for individuals to check off their having attended. There is a
place for attendance marking for each week of the month. The week date
names are variables kept in the Names Directory file, as changed in the
SET UP process.
Page 3B-6
Appendix 3-B - MPROFILE Reports
Figure 3B-5 - 2-Column Roster [2C]
Church 28 Roster - - March, 1984
Andersen, Irvin and Ev H: 431-7168 Victor, Gene H: 655-9558
12514 Fordham Court W: 929-2653 3448 Maple View Dr. W: 922-3421
Apple Valley, MN 55124 hBD: 07/22 Thriving City, MN BD: 11/14
wBD: 12/03
Baker, Kenneth and Karen H: 866-6332 Warner, Frank H: 826-9943
2345 Berea Dr. W: 876-7593 5330 Grand Ave S.
Thriving City, MN 55555 hBD: 02/22 Mpls, MN 55446 BD: 01/18
Carlson, Andy H: 932-0093 Washburn, George H: 422-3437
1443 Bethlehem Drive W: 844-5433 5443 Garden Grove
Thriving City, MN 55555 Apple Valley, 55124 BD: 07/15
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
========================================================================
Report Explanation -
1. This is the report formatted especially for making rosters for
distributing to the members of church groups for individual use at
home. The fields are quite self-explanatory. Both husband's and
wife's birthdays are printed, if given in the data.
2. There is one parameter used. The "Letter Separator" parameter, when
set to "Yes", causes an indented single-letter to be printed, when the
first letter of the last name is changed. For example, when the
report notices the next name starts with a "D" when it was printing C's,
the program will print 3 extra spaces and the letter "D" centered in the
line.
Page 3B-7
Appendix 3-B - MPROFILE Reports
Figure 3B-6 - Mailing Labels [ML]
Dr. Kenneth and Karen Baker
2345 Berea Dr.
Thriving City, MN 55555
Sam Chapman
8401 W. 101st St.
Bloomington, MN 55444
Harvey Larson
5470 53rd Ave N. Apt 271
Mpls,MN 55446
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
========================================================================
Report Explanation -
1. This is the standard mailing labels report. It can be accessed from
many places in the MPROFILE report menus. Virtually any group in the
church can have lavels printed for it. The Special Files/Reports menu
allows selection of any file and any selection criteria to be sent into
this report process.
2. The Names Directory file allow the following parameters to be varied-
- Column number of left edge of the label printing
- Spacing between labels
- Number of labels on the printer page (between page EJECTS)
- One or two labels printed on one line (the sample above has only
one column of labels)
3. The label is a simple Name, Address, City,State,Zip
4. For husband and wife groups, the label has both the husband's and
wife's first names.
5. One special format of this report is for MAILING LABELS of all church
people with offering envelopes. This is nice for placing each mailing
label on the new envelope boxes at the beginning of each year. The
MAILING LABELS routine prints the envelope number on the label for this
case.
6. A 9-digit zip code is optionally printed, when the "9-digit ZIP" SET
UP parameter says "Yes".
7. SPECIAL WARNING: If you set the first and second columns too close
to each other during parameters set-up, the mailing labels will print
very strangely - there may be character over-printing, or characters
printed at the end of a line that shouldn't be. Just look to see that
you have allowed enough characters to be printed between columns.
Page 3B-8
Appendix 3-B - MPROFILE Reports
Figure 3B-7 - Changes List [CL]
Grace Church Address / Phone Changes - October 4, 1983
Windom, Carla h:844-3210 1234 Bertha Road, Thriving City, 55443
Wilson, Barry h:866-4422 84053 Arthur's Court, Thriving C 55433
Williams, Nancy h:633-5596 102 Central Ave., Mpls, MN 55476
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
========================================================================
Report Explanation -
1. This report is also quite common. It is for making quick update
lists of recent changes and distributing to group members between
roster updates. The lists can be printed in monthly newsletters.
2. An Address/phone change is from the MEMBERS Update-CHANGE process.
It includes a work phone change. You have to customize the report to
have the work phone printed, though.
3. Changes lists can be for any of the following, depending on what
menu selection you make. NOTE: You have to have entered the
system date for the month you are operating on. If you want to
print changes made in August for a newsletter mad in September,
you have to have the System date to have an August month.
- New people for the month
- Address/phone changes for the month. (Same NOTE)
- Newly-Actives list
- Newly-inactives list
- Birthdays for the up-coming month
- (Wedding Anniversaries are made in One-Line format)
- Attendance: 1st Timers; Newly-Actives, Newly-Inactives
Page 3B-9
Appendix 3-B - MPROFILE Reports
Figure 3B-8 - Full Church Directory [FD]
Grace Church Directory - September, 1983 Page 1
Anderson, Mark and Carol 866-4422
Bob, Debbie
1234 Shady Oak Dr., Thriving City, MN 55443
Barry, Carol 664-2211
Cindy
5543 Berea Dr., Thriving City, MN 54332
Carpenter, Dr. James and Jenny 543-2100
Bert, Alice
1169 Arthor's Court, Thriving City, MN 44332
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
========================================================================
Report Explanation -
1. This is the directory of all members/attenders at your church.
It is for distribution to the church body. The fields are self-
explanatory.
2. There is one parameter used. The "Letter Separator" parameter, when
set to "Yes", causes an indented single letter to be printed when the
first letter of the last name is changed. For example, when the
report notices the next name starts with a "D" when it was printing C's,
the program will print 3 extra spaces and the letter "D" centered in the
line.
Page 3B-10
Appendix 3-C - MPROFILE Programs, Process Diagram
The diagram below shows all MPROFILE program module names. Each of these
are separate files on your disk. They have the suffix ".CMD"; for
example, MUPDATE really is the file MUPDATE.CMD, which you can find in
your file directory. The structure is hierarchial, which means that the
programs start from a single entry point, the MPROFILE main menu.
Each sub-menu or process is underneath one of the headings given on this
menu. The diagram shows all MPROFILE menus and how they are linked
together. The single numbers/letters followed by a dash indicate what
the operator enters to get into the menu or to start the process. The
name following this number/letter is the program module (file name) that
contains the menu or process. Processes in brackets are accessed
automatically or semi-automatically, but are not direct menu items or
processes. The highest level in the hierarchy (farthest left) is the
MPROFILE main menu, as shown in Figure 3-1.
MPROFILE Process Diagram
1-MUPDATE MEMBERS file updating
A-MUPADD [MUPADD1] Add a new name
C-MUPCHNG [MUPEDIT] Change an existing name
D- Delete a name
I- Make a name full-church inactive
J- Make a name small-church inactive
P-MUPCHNG Mark a pastoral call
2-FCREPORT Full church processing, reports
1-FCREPT1 Full-information report
2-MTWOLINE Briefer, two-line report
3-MS1LINE One-line report, by envelope number
4-FCREPT4 [MGFCROST] Full-church directory
5-FCSDATES [MSPMINAC] Special dates lists
1-MONELINE Wedding Anniversaries this month
2- Birthdays this month
3- New people this month
4- Address/phone changes this month
5- Full-church inactives this month
6- All full-church inactives
6- [MSPFMAIL] Mailing labels - all families
7- [MSPFMAIL] Mailing labels - all voting members
8- Mailing labels - all offering envlps.
9-FCATTEND [MSSATTND,MUPADD attendance marking, reports
1- [MONELINE] Active attenders check list
2- [MUPADD,MUPADD1] Add new people
3- [MSSATTND] Mark attendance
4- [MONELINE] Print newly-actives list
5- [MONELINE] Print newly-inactives list
6- [MONELINE] Print 1st Timers list
7- [MSPFMAIL] Print 1st Timers mailing labels
8- [MATTYEAR] Attendance report - year-to-date
9- Set up attendance marks for next year
Page 3C-1
Appendix 3-C - MPROFILE Programs, Process Diagram
3-SCREPORT [MGSCROST] Small church processing, reports
1- [MTWOLINE] Two-line report
2- [MONELINE] One-line report
3-M2COLROS Two-column roster
4-SCATTEND [MSSATTND] Attendance checking, reports
1- [SSATTD,SSATTD1] Monthly attendance check list
2- [MONELINE] Weekly attendence check list
3- [MUPADD,MUPADD1] Add new people
4- [MSSATTND] Mark attendance
5- [MONELINE] Print newly-actives list
6- [MONELINE] Print newly-inactives list
7- [MONELINE] Print 1st Timers list
8- [MATTYEAR] Attendance report - year-to-date
9- Set up attendance marks for next year
5- [MSPMINAC] New People list
6- [MSPMINAC] New-changes list this month
7- [MSPMINAC] Birthdays this month
8- [MSPMINAC] Newly-inactives list
9- [MSPFMAIL] Mailing labels
4-SAREPORT [MGSAROST] Special Activities reports
1- [MONELINE] One-line report
2- [MTWOLINE] Two-line report
3- [M2COLROS] Two-column roster
4- [MSPMINAC] New people this month
5- [MSPMINAC] New changes this month
6- [MSPMINAC] Birthdays this month
7- [MSPFMAIL] Mailing labels
5-IAREPORT [MGIAROST] Interests/Abilities (SKILLS) reports
1- [MONELINE] Selected I/A - all members
2- [MONELINE] Selected I/A - selected Small Church
3- [MSPFMAIL] M.labels, selected I/A - all members
4- [MSPFMAIL] M.labels, selected I/A and Sm.Church
6-MSPFILES Special files/reports creation
1- Display selected file, group
2- [FCREPT1] FI report of selected file, group
3- [MONELINE] OL report of selected file, group
4- [MSPFMAIL] ML report of selected file, group
5- Create new file from special criteria
6- [MGFCROST] Generate FCMEMBRS file (families)
7- [MGSCROST] Generate MSCROST file (Small Churches
8- [MGSAROST] Generate MACTIVTY file (Sp.activities
9- [MGIAROST] Generate MSKILLS file (Int./Abilities
Page 3C-2
Appendix 3-C - MPROFILE Programs, Process Diagram
7-FCALLING [MONELINE] Pastoral Calling
8-MPRSETUP Files, names set-up
1- Create initial MEMBERS file
2- Re-index MEMBERS file
3- Re-index a specified file
4-MCNAMESC Church, computer parameters editing
5-MCNAMES Church activity names editing
1- Print the Names Directory (MDIRFILE)
2-MCNAMES1 Add a Small Church Name
3- Delete a Small Church name
4- Add a Special Activity name
5- Delete a Special Activity name
6T- Add an OTHER category name
6-MCNAMES2 Add an OTHER name
7- Delete an OTHER name
8- Add an Interest/Ability name
9- Delete an Interest/Ability name
P- Purge inactive names from MDIRFILE
6- Printer special character start-up
7- File copy to an external format
8- Purge inactive members from MEMBERS
Page 3C-3