home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The World of Computer Software
/
World_Of_Computer_Software-02-385-Vol-1of3.iso
/
s
/
scoute24.zip
/
SCOUT.DOC
< prev
next >
Wrap
Text File
|
1992-12-22
|
15KB
|
365 lines
Scout Education Program
RELEASE 2.1 3/92
release 2.2 not issued to public 9/92
RELEASE 2.3 10/92
RELEASE 2.4 12/92 removed restriction on record type
report 7 last name first
report 8 added
Author Richard Mourino
150 Rollstone Ave
West Sayville New York 11796
Compuserv Id 74010,1722
Troop 139 Oakdale Long Island NY
This program was written in order to provide an easy way to
keep the scout records and also provide the Scout's Parents
with a report on the status of their son. I did obtain a
scout program but found it did not do all that I needed to
do. I decide to write my own program and provide the
functions that I needed. This program is the result of that
effort. I am not a shareware programmer so please forgive
this documentation for its simple approach.
The normal disclaimer : I will not warrantee or guarantee
this program or any damage caused by its use. Ok that's out of
the way.
This program is the sole property of the Author. The program
can be used by any scout council, however I am asking for a
donation of $25 dollars to Troop 139. All funds that are
donated are the sole property of the Scout Troop and not of
the Author. I would like you to register your troop so if
enhancements are made I can contact you about upgrades. All
upgrades will be uploaded to Compuserv or sent to those who
register. If you have obtained a copy from another source
and wish a clean copy please write to the author using the
registration form at the end of this document.
System Requirements:
The program is less than 220k in size and can run on a
single floppy system. You will have to move the Program
scoututl.exe off your master to use a single floppy disk.
The system will function on a non color monitor.
For double floppy system (360K) move all the files except the files
that end in EXE to a data disk and perform the following:
1. if drive b contains the data then
set the pc to drive b with b:
then from drive b type in exec a:scout.exe
This will execute the program from drive a but will find
all the files it needs on drive b.
If you have a drive greater than 360k it all can fit on one
drive. The leadship and hold(reports) files can get rather
large if you have a lot of scouts.
If you are using a hard disk drive just copy all the files to
a directory of your choice.
Remember to always backup you data disk often.
The files on system are as follows:
1. scout.exe the main program
2. scoututl.exe utility program to rebuild the indexes and
re-organize the leadship file. This is
useful after you have been using the system
for some time. The data is not saved within
the file in sorted order and over time the
report facility will become very slow. The
first option rebuilds the index if the index
is ever broken. The second option dumps the
data to a file called dump.txt it then
reloads to a database called leadnew.dbf.
The Leadship.dbf is renamed to Leadold.dbf.
Then leadnew.dbf is renamed to Leadship.dbf
and the indexes are rebuild. Please backup your
files before running this option.
Option 3 upgrades releases using the Config.dbf
as control.
3. Roster.dbf file containing the scout's name address
etc. it also can contain those individuals that
are members of your scout troop that do not have
children in the scout troop such as your troop
benefactor.
4. Rostidx.ntx The index file for roster sorted by the last
and first name of the scout.
Rost2idx.ntx The second Index file for roster sorted by the patrol
last and first name of the scout. New in Rel 2.3
5. Leadship.dbf File containing any advancement, camping,
leadership positions, skill awards or
training and merit badges and Pending merit badges.
6. Leadidx.ntx Index on the leadship file using the scout's
last, first name, record type, and the date
awarded.
Record types are :
A = advancement (tenderfoot etc)
S = skill (old scout awards) or special training
L = leadership (patrol leader etc)
M = merit badges
C = camping and other things
P = Pending merit badges that scout is working on
7. Lead2idx.ntx Index on the leadship file using the record
type and date awarded as the key.
8. Scourpt2.frm Report sorting the leadship file by record
type and date awarded. (option 2 on report
menu). Does not show advancement type records.
9. Scourpt3.frm report on the leadship file on the records
that have been changed. (option 3 on report
menu).
10.Scourpt4.lbl Label program showing the scout name and
address on a standard 1 inch label form. It
also shows the Scout's phone number and date
of last activity on the far right. This
report has 2 purposes, Labels and master
list. (option 4 on report menu)
11 Config.dbf Configuration file containing the release
information and the education coordinator's
name and phone number which is used in some
reports.
Also used by Scoutidx.exe program for release
upgrades.
12 Scourpt6.frm report on the leadship file on the records
that are a pending type record. Type P is used
to denote that the scout is working on a merit badge
but has not completed it.
Report 7 sorts by patrol name first
13 Scourp7b.frm Master list NEW
List out the roster file sorted by patrol showing
their name phone last updated and if suspended
(SECOND PART OF REPORT)
Scourp7a.frm The same information sorted by last name
Sample entries exist in the data base under the name of Mourino.
You will have to erase them before adding your real data.
Upgrades only (previous user) :
1. backup all of your file to be safe.
2. Copy the following programs to your scout disk or directory
Scout.exe (contains browse functions)
Scoututl.exe (fixed bug in re-org function and is release converter)
Scourpt2.frm (heading changed and shows all but advancements types)
Scourpt3.frm audit report no change
Scourpt6.frm (pending merit badges report new)
Scourp7b.frm (control list by patrol new)
Scourp7a.frm (control list by scout name new)
Scourpt4.lbl (Label output has slight modifications )
3. Run the scoututl.exe program with the option 3 from the
menu. The program reads your config.dbf and will convert the
Release 2.1 to 2.3 or 2.4 by creating a new index. It then updates
the Config.dbf with the release info. It will not update a
file more than once since the Config.dbf controls it actions.
Getting Started (new user) :
1. Copy all the files to your computer.
Start the system by executing the program scout.ex
The system will present a menu of options. Please note all
input must be in Capitol letters.
The first action is to use option C to set up the
administrators name and phone number on the reports.
You will not have to use this function again unless your
phone number changes or you quit scouts.
2. If your system does not have a built in clock you MUST set
the date. The system uses dates internally for its audit
reports. Without the correct date the audit feature will
not work properly. (option T from main menu).
3. The menu is self explanatory.
Now add some scouts to the system.
You cannot add any advancement info into the system unless
the scout has first been added.
4. After the scouts have been added now add the advancements
info. The search routine needs on a few letters to find
the scout, but if nothing is found the program drops into
a view mode that shows all the fields within the file and
their data values. Use the arrow keys to find the right
scout and press enter. (sorry I spelled the field Eagle wrong in the
Database definition too late to fix it.)
Note The page down key can be used as a exit command. That
is if the screen allows forward and back functions then
enter the function and use the page down key rather than
using the enter key.
5. The use of the word "COUNCIL" as the patrol name will
prevent that scout record from printing ON report 1 and 5.
I use this for the sponsor's record so the label program
produces the address labels that includes the sponsor but
not the scout report.
6. The use of the word "QUIT" in the suspend field on the
roster record will also prevent that record from printing
on the scout reports and labels sent directly to the
printer. The scout name will appear on the label program
if the report is sent to disk (option T in the report
menu). The far right side of the label shows the phone
number and date last modified.
This field will accept the word NOLABEL which will prevent the
label program from producing a label. I use this with the COUNCIL key
word in the patrol field to keep a list of the council members.
7. Who gets reports? In my troop the report 7 goes to the scoutmaster
and the committee chairperson. The labels plus the list version go
to our secretary.
The rest are placed in my binder for reference.
A copy of all the scouts records (report 1) also go to
scoutmaster as well as sent to all the parents at least twice a year.
Report 6 (new) helps me keep track of who is working on a merit badge
When adding advancement to the scout file it is easier to group all the
scouts together with the same advancement type record. Example you have
gone camping with 15 scouts. To add this camping type to the system add
the first scout first then for every additional scout use the "C"
function to copy the exact information to another scout. This will
eliminate a lot of typing and keep the information uniform among the
scouts.
How does the program distinguish between an eagle and non eagle badge?
The program looks at the record type being added or modified and looks
for key letters. The sub string commands used are at the bottom of this
document.
Deletions:
In order to delete you must delete all the advancement
info before you erase the scout roster record. If you
erase the roster record first and run the DELETE option
you will still have information in the leadership file
that you cannot get at or erase. I am working on an
improved delete functions. If this happens create the scout
again in the roster file and then go back and delete all the
leadership records.
Modify:
The system will allow you to modify any field except the scout's name
since this is the key between both files. If you spell the scout's
name wrong there is no way to fix it except erase it.
Reports:
The report menu shows 8 available reports. The first and
fifth report are really the same except option 5 will only
print out those scouts that have been modified on a date
greater than or equal to the system date.
This is to reduce paper expense.
Report 6 will display only leadership records that are pending Type
"P".
The main report 1, 5 and 8 display the badges needed to advance to star
life and eagle when the scout get more than 3 merit badges.
Report 7 list out the scouts from the roster file sorting by patrol
and then sorted by last name.
Report 8 allows you to print one scout record only to screen or printer
or disk.(new)
The report menu allows you to print the report to the screen
the printer or to a disk file. Most reports do not contain pauses
when they are written to the screen except 5 and 8 when you use the H
option
The data that goes to disk is in ascii format and can be read
by most word processors. You can also use the DOS TYPE
command to print the report to the screen.
TYPE HOLD1.rpt | more
Note the special character | it is not :
More is a dos command .
All comments and recommendations are welcome.
If you find the program useful please make a donation.
If you cannot make a donation at least leave me a comment.
The substring commands to determine if a badge is eagle or not
SUBSTR('&ftitle',1,7) = 'CAMPING' .AND. TYPE = 'M'
SUBSTR('&FTITLE',1,5) = 'FIRST' .AND. TYPE = 'M'
SUBSTR('&FTITLE',1,7) = 'CITIZEN' .AND. TYPE = 'M'
SUBSTR('&FTITLE',1,5) = 'ENVIR' .AND. TYPE = 'M'
SUBSTR('&FTITLE',1,6) = 'COMMUN' .AND. TYPE = 'M'
SUBSTR('&FTITLE',1,6) = 'SAFETY' .AND. TYPE = 'M'
SUBSTR('&FTITLE',1,6) = 'EMERGE' .AND. TYPE = 'M'
SUBSTR('&FTITLE',1,8) = 'LIFE SAV' .AND. TYPE = 'M'
SUBSTR('&FTITLE',1,14) = 'PERSONAL MANAG' .AND. TYPE = 'M'
SUBSTR('&FTITLE',1,14) = 'PERSONAL FITNE' .AND. TYPE = 'M'
SUBSTR('&FTITLE',1,08) = 'SWIMMING' .AND. TYPE = 'M'
SUBSTR('&FTITLE',1,06) = 'SPORTS' .AND. TYPE = 'M'
***********************************************
Scout Education System Release 2.3 10/92
Please make check payable to Troop 139
Richard Mourino
150 Rollstone Ave
West Sayville, New York 11796
Troop name or
Donated by _________________________________________
Address c/o_______________________________________
_________________________________________
_________________________________________
Donation ____________
Disk type needed 740k 3 inch 360k 5 inch
___ ___
Since Disk cost money, If you got this program from Compuserv
and from my ID then you have a clean disk.
Comments
------------------------------------------------------------------
------------------------------------------------------------------
------------------------------------------------------------------
------------------------------------------------------------------