home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The Education Master 1994 (4th Edition)
/
EDUCATIONS_MASTER_4TH_EDITION.bin
/
files
/
religion
/
rccdonor
/
rccd17.bcf
/
RCCDONOR.DOC
next >
Wrap
Text File
|
1979-11-30
|
105KB
|
2,637 lines
r . c . c
D O N O R
Version 1.7
Donation Tracking System
(C) Copyright 1991, 1992 by Alan Irwin
Alan Irwin
Irwin Computer Engineering
PO Box 1748
Goleta, CA 93116
(805)564-2400
CIS 71370,1513
September 1992
DISCLAIMER OF WARRANTY
THIS SOFTWARE AND MANUAL ARE SOLD "AS IS" AND WITHOUT WARRANTIES AS TO
PERFORMANCE OF MERCHANTABILITY OR ANY OTHER WARRANTIES WHETHER EXPRESSED OR
IMPLIED. BECAUSE OF THE VARIOUS HARDWARE AND SOFTWARE ENVIRONMENTS INTO
WHICH THIS PROGRAM MAY BE PUT, NO WARRANTY OF FITNESS FOR A PARTICULAR
PURPOSE IS OFFERED.
GOOD DATA PROCESSING PROCEDURE DICTATES THAT ANY PROGRAM BE THOROUGHLY
TESTED WITH NON-CRITICAL DATA BEFORE RELYING ON IT. THE USER MUST ASSUME
THE ENTIRE RISK OF USING THE PROGRAM. ANY LIABILITY OF THE SELLER WILL BE
LIMITED EXCLUSIVELY TO PRODUCT REPLACEMENT OR REFUND OF PURCHASE PRICE.
_______
____|__ | (R)
--| | |-------------------
| ____|__ | Association of
| | |_| Shareware
|__| o | Professionals
-----| | |---------------------
|___|___| MEMBER
rccDONOR is a "shareware program" and is provided at no charge to the user
for evaluation. I encourage you to share it with other organizations, but
please do not give it away altered or as part of another system. The
essence of "user-supported" software is to provide personal computer users
with quality software without high prices, and yet to provide incentive for
programmers to continue to develop new products.
If you find this program useful and find that you are using rccDONOR and
continue to use rccDONOR after a reasonable period of time, you must make a
registration payment of $100.00 to Irwin Computer Engineering. The $100.00
registration fee will license one copy for use on any one computer at any
one time. You must treat this software just like a book. An example is that
this software may be used by any number of people and may be freely moved
from one computer location to another, so long as there is no possibility
of it being used at one location while it's being used at another. Just as
a book cannot be read by two different persons at the same time.
Site-License arrangements may be made by contacting Irwin Computer
Engineering. Please refer to the file REGISTER.DOC for further registration
information and a registration form. A registration form also appears in
Chapter 10 of this manual, or a form can be generated from the Info. on
rccDONOR task of the Utility menu.
Anyone distributing rccDONOR for any kind of remuneration must first
contact Irwin Computer Engineering for authorization. This authorization
will be automatically granted to distributors recognized by the (ASP) as
adhering to its guidelines for shareware distributors, and such
distributors may begin offering rccDONOR immediately (however Irwin
Computer Engineering must still be advised so that the distributor can be
kept up-to-date with the latest version of rccDONOR). Please refer to the
the files VENDOR.DOC and SYSOP.DOC included with the distribution package.
You are encouraged to pass a copy of rccDONOR along to other non-profit
organizations for evaluation. Please encourage them to register their copy
if they find that they can use it. All registered users will receive:
- a copy of the latest version of the rccDONOR system
- a printed, bound copy of the manual
- extensive support (see Chapter 10)
- a subscription to "For What It's Worth", a newsletter of tips and
ideas for fundraising using rccDONOR
CONTENTS
1 Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Target Audience . . . . . . . . . . . . . . . . . . . . . . . . . 1
How to Use This Manual . . . . . . . . . . . . . . . . . . . . . . 1
Key Conventions . . . . . . . . . . . . . . . . . . . . . . . . . 1
2 Getting Started . . . . . . . . . . . . . . . . . . . . . . . . . . 2
System Requirements . . . . . . . . . . . . . . . . . . . . . . . 2
Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
3 Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
Basic File Definitions . . . . . . . . . . . . . . . . . . . . . . 6
Basic Screen Definitions . . . . . . . . . . . . . . . . . . . . . 7
Editing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
4 Main Menu . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
Quit . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
5 Edit Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Mail List . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Zip Codes . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
Events . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
Codes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
Searching . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
6 Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
Basic Report Prompt . . . . . . . . . . . . . . . . . . . . . . 18
Direct Output to Screen, Printer, or File . . . . . . . . . . . 19
Filter Selection . . . . . . . . . . . . . . . . . . . . . . . . 19
Mail List Report . . . . . . . . . . . . . . . . . . . . . . . . 21
Labels/Pledge Sheets . . . . . . . . . . . . . . . . . . . . . . 21
Donor Profile . . . . . . . . . . . . . . . . . . . . . . . . . 22
Events Report . . . . . . . . . . . . . . . . . . . . . . . . . 23
Word Processor Merge . . . . . . . . . . . . . . . . . . . . . . 23
Zip Code Counts . . . . . . . . . . . . . . . . . . . . . . . . 24
7 Log (Event) . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
Select Event Log . . . . . . . . . . . . . . . . . . . . . . . . 25
Event Log Edit . . . . . . . . . . . . . . . . . . . . . . . . . 25
Print Event Log . . . . . . . . . . . . . . . . . . . . . . . . 27
Word Processor Merge . . . . . . . . . . . . . . . . . . . . . . 28
Value Received Entry . . . . . . . . . . . . . . . . . . . . . . 29
8 Utilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30
Option Values . . . . . . . . . . . . . . . . . . . . . . . . . 30
Create/Convert Files . . . . . . . . . . . . . . . . . . . . . . 31
Reindex Data Files . . . . . . . . . . . . . . . . . . . . . . . 31
Field Options . . . . . . . . . . . . . . . . . . . . . . . . . 31
Validate Data . . . . . . . . . . . . . . . . . . . . . . . . . 32
Info. on rccDONOR . . . . . . . . . . . . . . . . . . . . . . . 32
9 Filter Commands . . . . . . . . . . . . . . . . . . . . . . . . . 33
Individual Criteria . . . . . . . . . . . . . . . . . . . . . . 33
Combining Criteria . . . . . . . . . . . . . . . . . . . . . . . 34
Command Reference Summary . . . . . . . . . . . . . . . . . . . 36
10 Shareware . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
Registering rccDONOR . . . . . . . . . . . . . . . . . . . . . . 37
Where to Register . . . . . . . . . . . . . . . . . . . . . . . 38
Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38
Ombudsman . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
RCCDONOR REGISTRATION FORM . . . . . . . . . . . . . . . . . . . 40
1 Introduction
Welcome to the latest release of rccDONOR. This is a donation tracking
system which can be used in a variety of ways. In its simplest form, this
is a mailing list program used to track members of an organization or
generate labels for a bulk mailing. But, when used fully, rccDONOR serves
as a sophisticated donation tracking system and event support system.
Target Audience
rccDONOR was developed and tested with small to medium sized non-profit
organizations, specifically a rape crisis center in California (that's
where the name came from) and a battered women's shelter in Pennsylvania.
Both groups were new to computerization. Traditional donation tracking
systems were priced too far out of their operating budget and seemed to be
aimed at much larger organizations. rccDONOR is meant to provide the power
of a donation tracking system at a price which a struggling non-profit can
afford, and it is marketed by the shareware method so that an agency can
"try before buy". There is a more complete discussion of shareware in
Chapter 10.
How to Use This Manual
The manual is written to closely follow the menu command structure seen
while operating the software. Later, a tutorial and common usage manual
will be provided to registered users.
Also, a "context sensitive help system" is provided. This means that at
most times, you can press the [F1] key to get a brief description of what
you can do (or are expected to do) at the current step of the program.
Key Conventions
Within this manual, the following font conventions will be used. When a
basic key on the keyboard is described (such as pressing the key for the
letter y), it will be shown as Y. When a special key is described (such as
one of the function keys either at the top or on the side of the keyboard),
it will be shown as [F1]. The ^ character is used to mean that the control
key is held down while the next key is pressed. The Control-C key sequence
will be displayed as ^C. And, a control key sequence for a special key is
represented as ^[F1].
When the computer is asking for a bunch of text to be entered (such as when
the program must be started from the DOS prompt), the computer prompt will
be shown as C:\> and the response you type will be displayed as rccdonor.
To simplify a description, you may be shown the prompt and response
together, such as:
C:\> rccdonor
The names of files will be shown as RCCDONOR.EXE
1 : Chapter 1 Introduction
2 Getting Started
System Requirements
The following is a list of requirements to run rccDONOR.
IBM PC/XT/AT/386/486
DOS 3.3 or higher
512K Memory
Floppy Disk
Hard Drive (optional but highly recommended)
Also, the CONFIG.SYS file must be checked or altered to allow at least 30
files:
FILES=30
and the AUTOEXEC.BAT needs to include the statement:
SET CLIPPER=F30
During installation, the INSTALL program (see below) will check for both of
these lines in the proper files and add them if necessary.
Installation
There are two methods of installing rccDONOR, depending on the source and
type of distribution files you received. If you downloaded the distribution
file from a bulletin board service (BBS), then you should follow the
instructions under ZIP INSTALLATION, below. If you received rccDONOR on a
disk, then follow the instructions under BCF INSTALLATION.
A. ZIP Installation
If you downloaded a file from a BBS, then you probably received a single
file named RCCD17.ZIP (where 17 identifies the version 1.7). This file
contains the programs, documentation, and support files compressed into a
single package.
If this is the first time you are installing rccDONOR, then create a
subdirectory for the rccDONOR system and move the ZIP file into that
directory. If you are upgrading from a previous version of rccDONOR, then
move to the directory in which you have the current version.
Unpack the file using a ZIP decompression utility such as PKUNZIP. If you
are upgrading your version of rccDONOR and you are using PKUNZIP, then
answer YES (press the Y key) for every file it asks you to overwrite.
Now, continue with the next section, titled BCF INSTALLATION, below.
2 : rccDONOR
B. BCF Installation
If you received a floppy disk with a distribution copy of rccDONOR, or
after unpacking the ZIP file, there should be 10 files. They are:
FILE_ID.DIZ A text file following a standard format for describing
rccDONOR for use on BBS systems.
READ.ME Important last minute information.
PACKING.LST A list of all the files in this package.
VENDOR.DOC Information and restrictions for disk vendors, distributors,
user groups, and more.
SYSOP.DOC Information for Bulletin Board System distribution.
DESCRIBE.DOC Sample descriptions for catalogs, BBSs, etc.
REGISTER.DOC Registration information and order form.
HISTORY.DOC rccDONOR Upgrade History
INSTALL.EXE rccDONOR installation program
RCCD17.BCF The complete rccDONOR execution set in a compressed format
Switch to the drive where these files are located and then type
INSTALL
followed by the [ENTER] key. This starts the installation procedure. Answer
the questions you are asked and rccDONOR will be installed automatically.
If you are upgrading your version of rccDONOR, the installation program
will replace the necessary files.
The following files will be created by the installation:
RCCDONOR.EXE
RCCHELP.DBF
RCCHELP.DBT
RCCHELP.NTX
RCCDONOR.DOC
RCCTY1PF.WP5
RCCTY5PF.WP5
RCCTY1PF.MW5
RCCTY5PF.MW5
Now start the program by entering:
C:\RCCDONOR> rccdonor
You will end up in the main menu display. The first step you must take is
to create or update your data files.
3 : Chapter 2 Getting Started
First, press the U key (for the Utilities menu). Then press C (for the
Create Data Files task). You will be shown a list of the data files used by
rccDONOR and the current status of each. If you are installing rccDONOR for
the first time, all of them need to be created. If you are upgrading from a
previous version of rccDONOR, then some of the data files may not need any
action, some of the files may need to be converted, and some of the files
may need to be created. You will be told which is which. Before any file
name which needs to be created or converted is a box which indicates
whether you request an action for that file. Make sure each box is marked
with a 'Y'. Press the Y key at each box to set them. Then, at the bottom of
the screen is a question whether to perform these actions. Mark this box
'Y' in the same way. The program will go off and create or convert data
files for each of the data sets. Any newly created data sets will start out
empty. Those data sets converted to a new format will go through a process
of automatically converting the data to the new format. The original
version of each file will be left on the disk as a back up.
If you are installing the rccDONOR program for the first time, you must
next customize this system for your computer. Press the [ESC] key leave the
file creation task. Press O (for the Options Values task). There are two
values which need to be set. First, press the E key to change the system
title. Enter the name of your organization and press [ENTER]. Next, press
the S key to select your printer. For a first time installation, you will
be told that there is no printer file and asked whether to create one.
Press Y. You will then be shown a list of available printers. Select a
printer closest to the one you use. If none are acceptable, select the NONE
option for now. Later, you can add a description for your printer (the
instructions for doing this are listed later in this manual, under the
UTILITIES section.
The basic installation of the system has been completed. Press the [ESC]
key to leave this task, press the [ESC] key again to leave the Utilities
menu, and press [ESC] again to leave the program. You will be asked whether
you truly want to leave the program. Press the Y key to finally exit back
to the C: prompt.
Files
At this stage, all the necessary files for the rccDONOR system reside on
your disk. They are:
RCCDONOR.EXE The rccDONOR program.
RCCHELP.DBF Help data file.
RCCHELP.DBT The help text file.
RCCHELP.NTX The index for the help system.
RCCPRNTR.DBF Set up string for some printer choices.
RCCPUB.MEM Variable settings for this installation
RCCMAIL.DBF The basic mailing list data
RCCMID.NTX The mailing list index by Donor ID
RCCMNAME.NTX The mailing list index by last name
RCCMZIP.NTX The mailing list index by zip code
RCCMORG.NTX The mailing list index by organization
RCCZIP.DBF The basic zip code data
RCCZIP.NTX The zip code index by zip code
4 : rccDONOR
RCCSOLIC.DBF The solicitation data
RCCSOLIC.DBT Notes save for each donor
RCCSID.NTX The solicitation index by Donor ID
RCCDITEM.DBF The donation data
RCCDITEM.NTX Donation index by Donor ID
RCCDEVNT.NTX Donation index by event and number
RCCEVENT.DBF The event data
RCCEVENT.NTX Event index by event code
RCCCODES.DBF Donor and donation codes
RCCCODES.NTX Codes index by type and code
RCCDONOR.DOC An ASCII file of the documentation
The following sample files can be used for creating mail merge letters:
RCCTY1PF.WP5 Sample WordPerfect 5.1 merge file
RCCTY5PF.WP5 Sample WordPerfect 5.1 merge file
RCCTY1PF.MW5 Sample Microsoft Word merge file
RCCTY5PF.MW5 Sample Microsoft Word merge file
Also, from time to time a temporary file is created in the normal course of
operating rccDONOR. If you should see one of these files in the directory,
do not worry. The file will be properly dealt with by rccDONOR. These file
names are:
RCCATMP.DBF
RCCATMP.NTX
RCCSTOT.DBF
Finally, you may see files which you have optionally created during your
operation of rccDONOR. For instance, you can cause a report to be sent to a
file of your own choosing rather than to the printer. These file do not
affect the operation of rccDONOR, and they may be deleted.
5 : Chapter 2 Getting Started
3 Overview
This section will cover some of the basics about how to get around within
the rccDONOR program.
Basic File Definitions
The basic donation tracking information is contained in six files. The
files are:
A. RCCMAIL
This contains the basic mailing list information, including the name of the
donor, the address, phone number, and category codes. This file is the core
of the system and at its simplest, is a basic mailing list. However, all
the other files link into this file so that you can track donation
information about this donor and also what donors contribute to what
events.
B. RCCZIP
The city and state information for each donor could take up a lot of room.
To save space, the city and state components of the address for a donor in
the mailing list are derived from the zip code. This file lists each zip
code and what the city and state are for that zip code. There is a method
for specifying more than one city for a basic 5 digit zip code. This list
is created as you enter names into the mailing list. It is not a complete
list of all possible zip codes.
C. RCCSOLIC
Not all entries in the zip code file are donors (or potential donors) which
you want to maintain extensive information on. Therefore, a separate file
exists to hold the additional data used in solicitation campaigns. The
information in this file is directly linked to the mailing list
information, and potentially every individual in the mailing list can have
a solicitation record. The specific information kept in the solicitation
record is discussed later.
D. RCCDITEM
This file holds information on each individual donation. The file holds
data relevant to cash and item donations. Each donation is linked to a
donor in the mailing list and to an event in the event list. This
arrangement allows report to be made based on an individual donor's
activity or a report on the donations made to an event.
6 : rccDONOR
E. RCCEVENT
This file collects some general information about each event which an
agency sponsors and for which it expects to receive donations. The
information includes the budgeted amounts and a summary of the donations
received. Reports can be generated based on each event.
F. RCCCODES
Each entry in the mailing list can be marked with a set of 2 letter
category codes. Also, each donation to an event can be marked with a 2
letter code to categorize it within an event. The definitions for all of
these codes are kept in this file.
Basic Screen Definitions
The basic working screen of the rccDONOR system consists of five
components. The very top line displays basic status information. The
information may consist of the current data record within the overall data
file, whether the current data record is to be deleted, or whether the
editor is in insert mode or not. Also, any messages concerning the active
operation of the program may be displayed to allow you to track the
progress of the program.
The second line is the Main Menu line, which shows the primary work topics
available in rccDONOR. When active, the main menu will produce drop down
menus showing the possible tasks within the work topic. For instance, under
the Edit Data main menu item there is a drop down menu which lists the
files available for editing (Mail List, Zip Codes, Events, and Codes).
The bottom line is a description of what some basic keys will do. This list
will change based on the active keys available at each point in the
program.
Between these information lines is the work area, surrounded by a double
box. The topmost line of this area is the title line for the user. This
title is entered into the system using the Utilities, Setup command. Below
the title is the activity currently being performed. The bottom line of the
work area is a prompt line for the activity being performed. Typically,
pressing a key will cause some activity important to the current task to be
performed, and these are listed on the bottom line. Finally, within the
work area is the data used by the selected task.
Each screen follows this basic format, although the information displayed
varies between applications.
7 : Chapter 3 Overview
Editing
Data is entered into new records, and old records are changed by the
editor. When the editor is active, data fields are surrounded by brackets
(the [ and ] characters) and the values in the data fields are bold. The
blinking cursor also appears and indicates where the next entered character
will be put. All the cursor keys are active and move you around the screen
in the following manner
Right Arrow [RIGHT] move one character right
Left Arrow [LEFT] move one character left
^Rt Arrow ^[RIGHT] move one word right
^Lf Arrow ^[LEFT] move one word to the left
Up Arrow [UP] move to the previous field
Down Arrow [DOWN] move to the next field
Page Down [PGDN] Exit the editor
Page Up [PGUP] Exit the editor
Home [HOME] Move to the start of field
End [END] Move to the end of field
^Home ^[HOME] Move to the first field
^End ^[END] Move to the last field
Insert [INS] Switch insert & overwrite
Delete [DEL] Delete character at cursor
Backspace [BKSP] Delete char. before cursor
^W ^W Exit & keep changes
Esc [ESC] Exit editor & lose changes
Enter [ENTER] Finish this field, to next
When you reach the last field, pressing ENTER will leave the editor.
8 : rccDONOR
4 Main Menu
Along the top of the screen is the main menu bar listing all the active
topics. When active, pressing the [LEFT] and [RIGHT] arrow keys will move
the cursor between the main topics. Select a topic by pressing the [ENTER]
key when the topic is highlighted. You will then see a 'Drop Down Menu'
listing the possible actions you can take within that topic.
You can also select a topic by pressing the first letter of that topic
name. For instance, you can select the Reports topic by pressing the R key.
These are the topics:
Edit Data All the mailing list and donation information can be edited
Reports The mailing list, labels, donor profiles, and other reports
Log (Event) Routines to edit and report on donations organized by event
Utilities Set system options, reindex files, create data files, or
convert data from older versions
Quit Leave this program, return to DOS
Most of these topics are discussed in their own sections. However, the
process to quit the program is discussed below.
Quit
To quit from rccDONOR and return to DOS, you can select the Quit option
from the main menu, or you can press the [ESC] key from the main menu. In
both cases you will be asked to confirm that leaving rccDONOR is your
intent. You must press Y to finally leave rccDONOR and return to DOS
9 : Chapter 4 Main Menu
5 Edit Data
There are four main tasks which you can perform under the Edit Data topic.
These tasks become available from a 'Drop Down Menu' when the Edit Data
topic is selected from the Main Menu. You can select a task by using the
[UP] and [DOWN] arrow keys to move the cursor over the desired task and
then pressing the [ENTER] key. Or, you can press the first letter of the
desired task, such as pressing the Z key to edit the Zip Codes.
The four tasks are:
Mail List Edit Edit the mailing list, donation, and solicitation
information
Zip Code Edit Edit the Zip Code data
Events Edit Edit information about a fundraising event or campaign
Codes Edit Edit the codes used to label Mail List categories and
Donation Item categories
Mail List
A. Mail List Table
This mailing list is provided in a table format to allow quick comparison
and selection of entries. The list can be ordered in one of four ways.
Normally, the list is in alphabetical order by last name, but you can also
list by Donor ID, by Zip Code, or alphabetically by organization. Pressing
the [F5] key will show you the list of sort orders you may choose from.
Highlight the order you want with the cursor bar and press the [ENTER] key.
The current sort order is displayed at the top of the screen, next to the
current task.
Initially, the donor id, first name, last name, and organization of each
entry can be seen. By using the [LEFT] and [RIGHT] arrow keys, you can move
between the field columns. More fields are available to the right of the
screen and can be seen by continually pressing the right arrow key. You can
move an entire screen at a time by pressing ^[RIGHT] and ^[LEFT]. ^[HOME]
will take you to the furthest left field (Donor) and ^[END] will take you
to the furthest right field (Category).
The cursor bar can be moved between mail list entries by using the [UP] and
[DN] arrow keys. The [PGUP] and [PGDN] keys will move up and down a block
of entries. By pressing ^[PGUP] you will be taken to the first entry.
^[PGDN] will take you to the last entry.
You can search for a specific entry by entering the name or Donor ID of an
entry. The methods of searching for an entry are discussed at the end of
this section.
You can mark an entry to be deleted by pressing the [DEL] key. Pressing it
again will remove the delete marker. If an entry is marked for deletion, an
indicator will be shown in the upper right.
10 : rccDONOR
You can add an entry by pressing the [INS] key. A blank entry will be added
and you will be put into the basic mail list entry screen, ready to enter
the new information.
Pressing the [ENTER] key or the + key will move you to the basic data entry
screen for the mailing list. Pressing the - key will take you to the
donations list for this mailing list entry.
B. Mail List Basic
The mailing list data is edited one record at a time on the full screen.
All the basic information is listed here. At the top of the data screen, a
unique ID number has been assigned to each mailing list entry. This is
assigned automatically, and is displayed only. Also, at the right of the
screen is the current date, the date this entry was created (Date Added),
and the last date this entry was changed (Last Edit). All of this
information is displayed only and cannot be directly edited.
The data fields to be entered and edited are:
Title Such as Mr., Ms., Dr.
First Name First name and middle initial
Last Name Last name and titles such as DDS or Jr.
Greeting The name used for the salutation of a thank you letter
Organization Business or professional
Address Street address (or PO Box)
Zip Code The ZIP+4 code is entered here, and the city and state come
from the corresponding entry in the Zip Code file (see
discussion below)
Home Phone Home or nighttime phone number
Work Phone Work or daytime phone number
Categories A set of two letter codes separated by a dash (-) or a comma
(,) which label the categories this entry is part of. The
categories are derived from the codes entered in the codes
database, and the selected codes are displayed with their
meanings (below).
You can change these data fields by pressing the E key. The cursor will
appear in the Title field, and you can switch between fields by pressing
the [ENTER] key or the arrow keys. The city and state entries are derived
from the 5 digit zip code entry (NOT the entire ZIP+4 entry). If the
entered zip code is not in the zip code file, then you will be asked to
enter the city and state to be linked to that zip code. If the zip code is
already in the file, then you will be shown a list of all the cities
already linked to that zip code and asked to pick one of them or to select
a new entry. Whenever a new zip code entry must be made, you will enter the
city and state information after the phone numbers and category information
is entered.
The category codes may be entered manually by typing in the two letter
codes, separated with a comma. After the [ENTER] key is pressed, a list of
all the codes is displayed, with an X marking all the codes currently
assigned to this mail list entry. You may mark additional codes by moving
11 : Chapter 5 Edit Data
the cursor bar over the desired code and pressing the [SPACE] bar. Pressing
the [ENTER] key finishes the changes.
You can switch between entries by pressing [PGDN] (for the next entry) or
[PGUP] (for the previous entry). ^[PGDN] will show you the last mail list
entry. ^[PGUP] will show you the first entry.
The entries may be in one of four different orders. Normally, the list is
in alphabetical order by last name, but you can also list by Donor ID, by
Zip Code, or alphabetically by organization. Pressing the [F5] key will
show you the list of sort orders you may choose from. Highlight the order
you want with the cursor bar and press the [ENTER] key. The current sort
order is displayed at the top of the screen, next to the current task.
By pressing the S key, you can search for an entry by the sort method
currently active. If the list is in name order, then after requesting a
search you will be asked for the first 10 characters of the last name, the
first name, and the organization. If the order is by Donor ID, then you
will be asked to enter a Donor ID to search for. The Zip Code order will
ask you for a Zip Code, and the organization sort order will ask you for
the first 10 characters of the organization and the last name.
You can mark an entry to be deleted by pressing the [DEL] key. Pressing it
again will remove the delete marker. If an entry is marked for deletion, an
indicator will be shown in the upper right of the screen.
You can add an entry by pressing the insert [INS] key. A blank entry will
be added and you will be put into the basic mail list entry screen, ready
to enter the new information.
Pressing the [ENTER] key or the + key will move you to the solicitation
data entry screen for the mailing list. Pressing the - key will take you to
the mail list table format.
C. Solicitation
Additional information can be stored for a mail list entry. This
information is geared towards donation requests. This information is
optional and only stored for those entries where donation information is
recorded, or when it is specifically requested.
The layout of the solicitation information is similar to the layout for the
basic mailing list. The additional information consists of:
Total Donations The sum of all donations attributed to this donor ID
Last Donation The date, amount, and event for the last donation
from this donor
Solicitor The name of the person who is to ask this donor for a
donation
Requested Amount The donation amount which is to be requested of this
donor
Notes Miscellaneous information you want to keep about this
donor
12 : rccDONOR
If solicitation information already exists for a mail list entry, then the
data is shown on the screen and you are allowed to edit the data. If there
is currently no solicitation record for this mail list entry, then
asterisks appear in place of the data, and you are only allowed to add a
solicitation record for this donor.
You can move through the solicitation data in the same way you would the
basic mail list. You may use the cursor keys or search for an entry based
on the current sort order.
The information in the Notes field can be as long as you would like. This
field will allow you to enter any notes you would like to keep about a
donor. These notes could prove handy for any solicitation campaign you are
planning. The potential size of the note is quite large and should allow
you plenty of flexibility.
The note can be much larger than the display area shown. You can think of
the display as a small window looking onto the note, very much like a word
processor. The cursor keys will cause the note to scroll within the window.
The [PGUP] and [PGDN] keys will scroll the note a full window at a time,
and the [UP] and [DN] arrow keys will cause the window to scroll one line
at a time when they are at the limits of the window. You finish editing the
notes by pressing the [ESC] key (if you do NOT want to keep your changes)
or the [F7] key (if you want to KEEP your changes).
Pressing the [ENTER] key or the + key will move you to the donations table
for this donor. Pressing the - key will take you to the basic mail list.
D. Donations
Donation information can be kept for each donor in the mail list. Each
donation is individually tracked and linked to both a donor and an event so
that the complete donation history for any donor may be reviewed. In the
donations screen, a table is shown with all the donations for this donor.
Initially, the first eight fields for each entry can be seen. By using the
[LEFT] and [RIGHT] arrow keys, you can move between the field columns. More
fields are available to the right of the screen and can be seen by
continually pressing the [RIGHT] arrow key. You can move an entire screen
at a time by pressing ^[RIGHT] and ^[LEFT]. ^[HOME] will take you to the
furthest left field (Date Received) and ^[END] will take you to the
furthest right field (Description).
The data fields for a donation are:
Date Rcd The date the donation was made
C/I A single character indicates whether the donation is (C)ash
or an (I)tem
Event A 5 character code marks what the donation is for. I
recommend using 3 characters for the event and the last two
characters indicating the year of the event. For instance, a
donation from the 1990 fund appeal campaign would be marked
FAC90
Num. Each item within a campaign may optionally be numbered for
use within that campaign (ex. auction)
13 : Chapter 5 Edit Data
Type Each event may use 2 letters to categorize a donation, these
codes are set in the Codes file.
Value The value of the donation
Received The value received for a donation, which is used when a
donated item is resold (ex. auction)
TYL Date The date a thank you letter was sent, used for generating
merge files for your word processor
Solicitor The solicitor of the donation
Location The current location of an item
Description A 40 character space for any special notes you want to keep
for this entry
You can edit the donation information by moving the cursor bar onto the
donation and pressing the [ENTER] key. The screen will change to show you
all the data for that entry and the editing controls will be in effect.
When the last data field has been edited, you will be returned to the
table.
The Type field is optional, but if it is not blank, then the code must be
from the list defined in the Codes database. Whenever the Type field is not
blank after editing that field, then a list of the donation codes is shown.
Move the cursor bar over the code you want and press the [ENTER] key. The
selected code will appear along with its description.
The cursor bar can be moved between donation entries by using the [UP] and
[DN] arrow keys. The [PGUP] and [PGDN] keys will move up and down a block
of entries. By pressing ^[PGUP] you will be taken to the first entry.
^[PGDN] will take you to the last entry.
You can mark an entry to be deleted by pressing the [DEL] key. Pressing it
again will remove the delete marker. If an entry is marked for deletion, an
indicator will be shown in the upper right of the screen.
You can add an entry by pressing the [INS] key. A blank entry will be added
and you will put into the editor, ready to enter the new information. If
solicitation data is not already entered for this donor, a new solicitation
record will be also be added.
Pressing the + key will move you to the mail list table screen. Pressing
the - key will take you to the solicitation data for this donor.
Zip Codes
Editing zip codes is done in a table format. All the zip codes are listed
in numeric order along with the city and state associated with that zip
code. Since there can be more than one city associated with a 5 digit zip
code, there may be a letter attached to the zip code number. This letter is
used to distinguish between the possible cities. A blank space is used to
identify the first of a series of duplicate zip code entries and is the
only distinguishing character necessary for non-duplicated zip codes.
The cursor bar can be moved between zip codes by using the arrow keys. The
[PGUP] and [PGDN] keys will move up and down a block of zip codes. Pressing
14 : rccDONOR
^[PGUP] will take you to the first zip code. ^[PGDN] will take you to the
last zip code.
Pressing the [ENTER] key will allow you to edit the zip code at the cursor
bar. After entering all four values (the zip code, the distinguishing
letter, the city, and the state), you will be returned to the table list.
You can mark a zip code to be deleted by pressing the [DEL] key. Pressing
it again will remove the delete marker. If an entry is marked for deletion,
an indicator will be shown in the upper right of the screen.
You can add a zip code by pressing the insert [INS] key. A blank entry will
be added, ready to edit.
Events
Information about each event or campaign is kept in addition to a record of
all donations made to the event. In the event screen, a table is shown with
all the events listed. Initially, the event code, description, date of the
event, and budgeted income can be seen. By using the [LEFT] and [RIGHT]
keys, you can move between the field columns. More fields are available to
the right of the screen and can be seen by continually pressing the right
arrow key. You can move an entire screen at a time by pressing ^[RIGHT] and
^[LEFT]. ^[HOME] will take you to the furthest left field (Code) and ^[END]
to the furthest right field (Actual Exp).
The data fields for an event:
Code A 5 letter code which uniquely identifies an event. I
recommend using 3 characters for the event and the last two
characters indicating the year of the event. For instance, a
donation from the 1990 fund appeal campaign would be marked
FAC90
Description You may put in a description of the event of up to 40
letters
Date The date of the event
Bdgt Inc Budgeted event income
Bdgt Exp Budgeted event expense
Actual Exp Actual event expenses
You can edit the event information by moving the cursor bar onto the
donation and pressing [ENTER]. The screen will change so that you can see
all the data for that event in one spot and edit the event in the normal
way. When the last data field has been edited, you will be returned to the
basic table display.
The cursor bar can be moved between event entries by using the [UP] and
[DOWN] arrow keys. The [PGUP] and [PGDN] keys will move up and down a block
of entries. By pressing ^[PGUP] you will be taken to the first entry.
^[PGDN] will take you to the last entry.
You can mark an entry to be deleted by pressing [DEL]. Pressing it again
will remove the delete marker. If an entry is marked for deletion, an
indicator will be shown in the upper right of the screen. Whenever an event
15 : Chapter 5 Edit Data
is to be deleted, the donations are checked to determine whether there are
any assigned to this event. If there are, then you are warned, and then you
are asked to select a new event for those donations. This helps prevent
donations from being assigned to unknown events.
You can add an entry by pressing the [INS] key. A blank entry will be added
and you will put into the editor, ready to enter the new information.
Codes
There are two sets of code lists which are kept by the system. One list is
for categorizing donors. The other set of codes are used to categorize
donations. Only one list at a time is shown in the data area (table
format). The data list currently displayed is shown at the top of the
screen, next to the task label. You can change between the two list by
pressing the C key for the donor category codes and pressing the D key for
the donation codes.
The codes are listed in alphabetical order along with the code
descriptions. The cursor bar can be moved between codes by using the arrow
keys. The [PGUP] and [PGDN] keys will move up and down a block of codes.
Pressing ^[PGUP] will take you to the first code. ^[PGDN] will take you to
the last code.
Pressing the [ENTER] key will allow you to edit the code at the cursor bar.
After entering the values (the code and the description), you will be
returned to the table list.
You can mark a code to be deleted by pressing the [DEL] key. Pressing it
again will remove the delete marker. If an entry is marked for deletion, an
indicator will be shown in the upper right of the screen.
You can add a code by pressing the insert [INS] key. A blank entry will be
added and will be ready to edit.
Searching
A. Search for Name
When the mail list is in alphabetical order by last name, only the first 10
letters of the last name are used. Those with the same last name then use
the first 10 letters of the first name to sort. Finally, the first 10
letters of the organization are used to further sort. The organization
sorting really is only important when there is no name associated with the
mail list entry. All the organizations entries with no first or last names
are sorted together at the beginning of the list.
To search for a name, enter the parts needed starting with the last name.
The search will find the name closest to the one you enter.
16 : rccDONOR
B. Search for ID
Each mail list entry has a unique Donor ID associated with it. This Donor
ID is printed on the mailing labels and is used throughout the rccDONOR
program. Sometimes you need to look up an entry by the Donor ID. The number
can be from 1 to 5 digits long.
If the number cannot be found, a message will appear at the bottom of the
screen.
C. Search for Zip Code
When the mail list is in zip code order, the 5 digit zip code, the first 10
letters of the last name, and the first 10 characters of the organization
are entered for the search. The search is done in that order, first a match
on zip code, then on last name, and if those all match, then on the
organization.
D. Search for Organization
When the mail list is in organization order, the first 10 characters of the
organization are matched first and then the first 10 characters of the last
name are matched. Mail list entries without an organization are grouped
together at the start of the list (organization is blank).
E. Zip Code Search
The zip code list is kept in the order of the zip codes. You can search for
a particular zip code by entering the zip code number.
F. Event Search
Each event has a unique, 5 letter code associated with it. You may search
for an event entry by entering its code.
17 : Chapter 5 Edit Data
6 Reports
There are six tasks which you can perform under the Reports topic. These
tasks become available from a "Drop Down Menu" when the Reports topic is
selected from the Main Menu. You can select a task by using the [UP] and
[DOWN] arrow keys to move the cursor over the desired task and then
pressing the [ENTER] key. Or, you can press the first letter of the desired
task, such as pressing the D key to get Donor Profiles.
The six tasks are:
Mail List Print entries from the mail list
Labels/Pledge Sheets Print addresses from the mailing list onto labels or
onto pledge sheets
Donor Profiles Print information about donors and potential donors
Event Summaries Print summary information about all the events
Word Processor Merge Create a word processor merge file from donor
information
Zip Code Counts Print the number of entries in the mail list for
each zip code
Basic Report Prompt
Most of the reports allow you to perform any of three actions. Towards the
bottom of the screen, the three controls for these actions are listed as: E
for editing the options unique to that report, S to select a filter to be
in effect during that report (see below), and P to start printing the
report.
Each report has several options allowing you to alter the form or
organization of a report. At the very least, each report has one option
setting allowing you to determine the destination of the report. Each
report and all the options available for it are described below.
In most cases, all the possible entries from the mailing list or other data
files will be used to generate a complete report. However, occasionally
only a subset of the total data available needs to be included in a report.
To determine the data records to include, a filter is selected which checks
each data record against a set of tests and decides whether to include that
record based on the test. A complete description of selecting and creating
filters is given later.
The command to start a report being created is 'Print Report'. However,
that term can be misleading. The report will only go the printer if the
direction option is set to P for the printer. By executing the 'Print
Report' task, you just begin generating the report, and it is created onto
whichever device the output direction option is set to (see below).
You may pause the printing action at any time by pressing the [ESC] key. A
box will appear on the screen telling you that printing has paused. If you
press the [ESC] key again, you cancel any further printing action. Pressing
any other key will resume printing. This pause/cancel option is available
when you print to either the screen, printer, or file.
18 : rccDONOR
Direct Output to Screen, Printer, or File
The destination of each report can be set by editing the options. Most
reports have a set of option controls which can change the form or ordering
of the report. The last option for all reports is the output direction
option. Any report can be directed to the screen (S), the printer (P), or
to a file (F). What this means is that instead of only printing a report
onto your printer, you may also look at a report on the screen, or put the
report into a file.
You would direct the report to the screen in cases where you want to
quickly review a file without wasting paper or just to see if the report is
formatted the way you want it to look before committing it to paper.
You would direct the report to a file if you want to print it out later, or
if you want to incorporate it into another program, say a word processing
document or a spreadsheet. If you select the file direction, then you are
also asked for a name for the report file.
Filter Selection
A filter is a way of only printing out partial lists. Any report may have a
filter active when it is created, and so specialized reports can be
generated. For instance, you may print labels just for donors marked AA in
the category field and who have donated over $100.
A. Selection
Whenever you press S at any report prompt, you are shown a list of 9
previously defined filters. If one of the filter names is blank (no name)
then the filter is empty or undefined. Move the cursor bar over the name of
the filter you want and press the [ENTER] key.
The filter is initially set to ALL RECORDS whenever rccDONOR is started.
The ALL RECORDS filter also appears as the first entry in the filter list.
All the other entries are defined by the user. You can add a new entry to
the list by pressing the [INS] key, or by moving the cursor bar over a
blank entry and pressing the [F9] key. You may change any existing filter
(except for the ALL RECORDS filter) by moving the cursor bar over the
existing filter and pressing the [F9] key.
B. Editing
There are two components to a filter: its name and the filter conditions.
You are allowed to change either one when editing.
The name is used to identify the filter when selecting it from the list of
possible filters or to determine which filter is active when generating a
report.
19 : Chapter 6 Reports
The filter conditions are a set of dBase III compatible commands which
logically determine whether to include a donor in the printout. The set of
possible commands and how they work together is more extensively discussed
in a later section. However, to simplify the most standard requests, there
are three different 'Set Screens' which can automatically create filter
commands. These screens can be selected by the function keys. [F2] will
allow you to set conditions based on the basic mailing list information.
[F3] will allow you to select conditions based on the category list of a
donor, and [F4] will allow you to set conditions based on the solicitation
information of a donor. Each of the 'Set Screens' (described below) will
add the appropriate commands to the filter conditions in the edit box. You
can alter these commands at any time by editing the filter.
C. Mail List Set Screen
Each of the mail list data fields are listed here as a potential range of
values. You may enter the starting and ending value of each field you want
to serve as a filter condition. The maximum and minimum values of each data
field are initially displayed. Only those fields which you change are
included in the final set of conditions. When you change the lower limit
(labeled as FROM), then those records which have a field value greater than
your entered value are selected for the report. When you change the upper
limit (labeled TO), then only those records with a value less than the
entered value are included. Changing both the upper and lower limits sets a
range of values which any record must fall between. If the upper and lower
limit are the same, then only records with values equal to the setting are
included.
The Donor ID is listed as a selectable field range, as is the title field.
You can also select the name from which to start printing. There are two
ways to approach this. If you want to treat the last name, first name, and
organization fields separately, you may do so. But you will often want to
create a joint name, such as when you want to print all records after Jane
Doe from the YMCA. In this case you will want to treat all three fields as
a single entity. You do this by entering Y in the field after the name
fields.
You can also select a range using the street address, the zip codes, or the
phone number.
Finally, you can select entries based on the last date they were edited.
This allows you to print a report of just those entries you've changed
within a specified period of time.
After setting all the conditions, you will be asked to confirm the limits
you've selected. A verbal description of the limits is displayed along with
a request to add the settings to the filter. Pressing Y will add the
appropriate commands to the filter definition.
20 : rccDONOR
D. Category Set Screen
You may select a set of categories to include or exclude from the report.
Any categories entered here are matched against the categories in each
donor's record. If any of the categories match, then the donor's record is
considered a match. You also decide whether a matched record is to be
included in the report or excluded from the report.
The category codes may be entered manually by typing in the two letter
codes, separated with a comma. After the [ENTER] key is pressed, a list of
all the codes is displayed, with an X marking all the codes currently
assigned to this mail list entry. You may mark additional codes by moving
the cursor bar over the desired code and pressing the [SPACE] bar. Pressing
the [ENTER] key finishes the changes.
By entering the * character into the options, then if a donor is marked
with any category, that donor is a match. Only those donors with a blank
category field would not be considered a match.
E. Solicitation Set Screen
Each of the primary solicitation data fields are listed here as a potential
range of values. You may enter the starting and ending value of each field
you want to serve as a criteria. The maximum and minimum values of each
data field are initially displayed. Only those fields which you change are
included in the final set of conditions. When you change the lower limit
(labeled as FROM), then those records which have a field value greater than
your entered value are selected for the report. When you change the upper
limit (labeled TO), then only those records with a value less than the
entered value are included. Changing both the upper and lower limits sets a
range of values which any record must fall between. If the upper and lower
limit are the same, then only records with values equal to the setting are
included.
The fields are the total donations from a donor (the sum of all donations
from this donor) and the requested donation. Also, the solicitor field can
be used for matching.
Mail List Report
This procedure prints out the information from the basic mailing list
entries. The list includes the Donor ID, Name (with Title), Organization,
Street Address, Zip Code, and Phone Numbers. Each entry takes up one line.
The mail list report provides the standard set of command controls, and the
only option setting provided is the destination of the report.
Labels/Pledge Sheets
This report will generate either of two types of mailing address inserts.
Mailing Labels are printed on sheets with 3 labels across the page and
continuously down a page. This is a standard format for mailing labels.
21 : Chapter 6 Reports
Pledge sheets are printed one across and 3 to a page. This is the standard
format for an insert which displays an address through a window envelope.
Both the labels and the pledge sheets are printed in order by zip code and
alphabetically by name within a zip code. The Donor ID appears in the upper
right, and then comes the name, the organization, and the address. If
either the name or the organization is blank, then the label is printed
without that line.
For the labels/pledge sheet report you have four options to edit. The first
is whether to print labels or pledge sheets. The next two are the offsets
for printing the address on a label or pledge sheet. The offset from the
top changes how far down on a label or pledge sheet the address appears.
The offset from the left changes how far over from the side edge the
address appears. The ranges allowed are shown, and the ranges are different
for a label than for a pledge sheet. Whatever values you select are
remembered for the next time you print. Independent values are kept for
labels and for pledge sheets.
The last option is where the report is to be sent. You can select sending
the report to your screen, to the printer, or to a text file.
When you print the report to a printer, you are given the opportunity to
test the alignment of the printer, since the alignment of labels or pledge
sheets is very important. This part of the procedure will let you print 6
sample labels (2 rows) or 3 sample pledge sheets (1 page) to test the
alignment. The samples are nonsense (X's and 9's) but are used to show how
a very large address would fit.
Pressing the Y key will print the sample set. After the set prints, you can
press Y again to print another sample set. When you are confident with the
allignment, you may press N (or press the [ENTER] key) to continue the
normal printing of the labels or pledge sheets.
Pressing the [ESC] key will halt all printing and return you to the control
screen.
Donor Profile
A donor profile report can consist of a short report or a long report. A
short report has a single line for each donor, including the donor's ID,
total amount donated, and name.
The long report has several lines for each donor separated by a double
line. Included in the report is mail list information for the donor, the
solicitation information, and a list of all the donations recorded for this
donor.
The entries in the donor profile can be listed in alphabetical order by
name or by the total donation amount (lowest values first, increasing to
the largest value last).
22 : rccDONOR
The three options you are allowed to edit are to select a long or short
report, whether to list donors alphabetically or in order of their total
donations (smallest to largest), and where to direct the report.
Events Report
The event report prints one line for each event summarizing the information
for that event. The event code, description, date of the event, actual
income (from all donation entries), budgeted income, actual expenses, and
budgeted expenses are reported.
This report has only two commands. You may change (edit) the options of the
report by pressing the E key. Or you can start printing the report by
pressing P. There is no filter selection available for the events report.
The only option available to edit is where the report is to be sent. As
usual, you can select whether the report is sent to your screen, to the
printer, or to a text file.
Word Processor Merge
This routine prints a merge file to be used by your word processor, either
WordPerfect or Microsoft Word (see the Option Values task of the UTILITES
menu item). You can create letters to donors or customized reports in your
word processor using this procedure.
As with any report, you have three options. You may change (edit) the
options of the report by pressing the E key. You can select a set of
conditions or ranges to filter the entries you want in the report by
pressing the S key. Or you can start printing the report by pressing P. In
this case, the report is printed to a file in the mail merge format.
The set of options for this report is a list of the fields you may include
in the merge records. To include a field, set the value to 'Y'. To remove a
field from the merge file, set the value to 'N'. Initially, all the fields
are set to 'Y'.
You will then be asked to enter the name of the merge file to be created.
Remember the name of this file when performing the mail merge operation
from your word processor.
When you press the P key to start printing the merge file, if you have not
already set the name of the merge file, you will be asked to enter the
name. A merge file name must be entered.
You are then shown a list of the fields which will be included in the merge
file. This list is derived from your option selections. The field numbers
listed will be used by your word processing program during a merge
operation. You will want to keep track of these field numbers.
Press Y to continue using this field set. Press N if you want to cancel
this report and change the field list.
23 : Chapter 6 Reports
Zip Code Counts
This report totals the number of mail list entries for each zip code. It is
useful when planning a mailing because it provides the zip code counts
necessary for bulk mailing and a total count needed to figure postage
costs. Be sure that when generating the report, you have the same filter
active that you use for printing the mailing labels.
This report function has the usual set of commands available, and the only
option you may edit is where to direct the report output.
24 : rccDONOR
7 Log (Event)
There are five tasks which you can perform under the Log topic. The tasks
work on the donation log of one specific event. These tasks become
available from a 'Drop Down Menu' when the Log topic is selected from the
Main Menu. You can select a task by using the [UP] and [DOWN] arrow keys to
move the cursor over the desired task and then pressing the [ENTER] key.
Or, you can press the first letter of the desired task, such as pressing
the E key to get the Event Log Edit.
The five tasks are:
Select Event Log Pick the event log to be used by the other tasks
Event Log Edit Add or edit entries in the selected Event Log
Print Event Log Print the Event Log
Word Processor Merge Create a merge file for a word processor using
donation information
Value Recvd Entry Enter the value received for each item in a Log
Select Event Log
The event log functions work on donations which have all been linked to the
same event. The donation list for an event is called the log, and so this
is where the event log is selected for the other tasks to work on.
You are shown an alphabetized list of defined events. The list shows the
event code followed by a colon and then the event description. The cursor
bar can be moved between mail list entries by using the [UP] and [DOWN]
arrow keys. The [PGUP] and [PGDN] keys will move up and down a block of
entries. By pressing ^[PGUP] you will be taken to the first entry. ^[PGDN]
will take you to the last entry.
When the cursor bar is on the event you wish the log tasks to work on,
press the [ENTER] key to select it. The event description currently
selected will always appear in the upper part of a task screen, next to the
task description. You can quickly move to a specific event by entering the
event code.
Event Log Edit
The event log is displayed in one of two formats, either a table format
where several donation items are shown at one time or an expanded format
where one complete donation item is shown at a time (both are similar to
the mailing list formats)
A. Event Log Table
The log for an event is provided in a table format to allow quick
comparison and selection of entries. The list is in numeric order (by log
number) and includes all the data for a donated item. Initially, the
donation Number, Code, Description, Date Received, and Value are shown. By
using the [LEFT] and [RIGHT] arrow keys, you can move between the field
25 : Chapter 7 Log (Event)
columns. More fields are available to the right of the screen and can be
seen by continually pressing the right arrow key. You can move an entire
screen at a time by pressing ^[RIGHT] and ^[LEFT]. ^[HOME] will take you to
the furthest left field (Number) and ^[END] will take you to the furthest
right field (Location).
The cursor bar can be moved between event log items by using the [UP] and
[DOWN] arrow keys. The [PGUP] and [PGDN] keys will move up and down a block
of entries. By pressing ^[PGUP] you will be taken to the first entry.
^[PGDN] will take you to the last entry.
You can mark an entry to be deleted by pressing the [DEL] key. Pressing it
again will remove the delete marker. If an entry is marked for deletion, an
indicator will be shown in the upper right of the screen.
You can add an entry by pressing the [INS] key. A blank entry will be added
and you will put into the basic event log entry screen, ready to enter the
new information.
Pressing the [ENTER] key or the + key or the - key will move you to the
basic data entry screen for the event log.
B. Event Log Basic
The event log data can be edited one record at a time on the full screen.
All the basic information is listed here. At the top right of the screen is
the current date, the date this entry was created (Date Added) and the last
date this entry was changed (Last Edit). All of this information cannot be
directly edited.
The data fields to be entered and edited are:
Date Recvd The date the item was received
Log No. This is an optional number assigned to identify each item
from an event as it is logged
Type A 2 letter code to categorize donations within an event,
these are set in the Codes database
Donor The donor of an item is identified by their ID in the
mailing list with the name and address of the donor shown
next to the ID
Value Value of the donated item
Descrip A description of the item
Solicitor The identification for the solicitor of this item
Date of TYL Date thank you letter was sent to donor
Location Current location of the item
You can change these data fields by pressing the E key. The cursor will
appear in the Date Received field, and you can switch between fields by
pressing the [ENTER] key or the arrow keys.
The Type field is optional, but if it is not blank, then the code must be
from the list defined in the Codes database. Whenever the Type field is not
blank after editing that field, then a list of the donation codes is shown.
26 : rccDONOR
Move the cursor bar over the code you want and press the [ENTER] key. The
selected code will appear along with its description.
You can switch between entries by pressing [PGDN] (for the next entry) or
[PGUP] (for the previous entry). ^[PGDN] will show you the last log entry.
^[PGUP] will show you the first entry.
The entries are in numeric order by the log number. You can search for any
entry by pressing the N key and then entering the log number.
You can mark an entry to be deleted by pressing the [DEL] key. Pressing it
again will remove the delete marker. If an entry is marked for deletion, an
indicator will be shown in the upper right of the screen.
You can add an entry by pressing the [INS] key. A blank entry will be added
and you will be put into the basic event log entry screen, ready to enter
the new information.
Pressing the [ENTER] key, the + key, or the - key will move you to the
event log table format.
In situations where you do not know the Donor ID of an entry in the mail
list, you can optionally search the mail list by name. You select this
option by pressing S and you are presented with a table of the names in the
mail list in alphabetical order. Move the cursor (using the standard cursor
controls for any list) over the name you want to select by using the cursor
keys, and then press the [ENTER] key. The Donor ID will be automatically
entered for this mail list entry.
Also, you may correct or add a name into the mailing list when necessary.
If you cannot find the donor in the alphabetical list, you can add a new
donor to the mailing list by pressing the [INS] key from the Select Donor
option. When you are looking at the alphabetical list of donors, press
[INS] and the screen will change to show you a blank mailing list entry
which you can then fill in. The standard editing controls are active. When
you are done, this entry will be added to the mailing list and you may then
select it from the list for this donation.
If you have entered a donor for the donation and you notice that the name
or address needs correcting, you can also change the current entry from the
Select Donor option. Press S to get the Alphabetical screen of donors. The
cursor should be on the selected donor. By pressing the + or - key, you
will be put into a full view of the mailing list entry for this donor with
the editing options active. You can make any changes you like to this mail
list entry. When you are done, you can again select this dongr, and the
corrected information will be displayed.
Print Event Log
The event log can be printed in 2 different ways and in 2 different orders.
You select whether to print all the log information with multiple lines for
each item in the extended format or just a quick log with a single line for
each item. You can print the list in item number order or grouped by type.
27 : Chapter 7 Log (Event)
This report follows the same format as the other reports previously
described. It does not allow a filter to be selected. There are three
options which can be edited. The first two set whether to print the log in
long or short format and whether to print the list in numeric order (by log
number) or by the donation type. The third option determines where to
direct the report.
Word Processor Merge
This routine prints a merge file to be used by your word processor, either
WordPerfect or Microsoft Word (see the Option Values task of the UTILITES
menu item) for generating letters from the event log. You can create thank
you letters to donors using this procedure.
As with other reports, you have two options. You may change (edit) the
options of the report by pressing the E key. Or you can start printing the
report by pressing P. In this case, the report is printed to a file in the
mail merge format.
The WP Merge report has several options. First, is the option to create a
record for all the entries in the log, or just for those entries which do
not yet have a date assigned to the TYL Date field. If the 'U' option is
selected, then this routine searches the list for those entries which do
not have a date and generates the merge file from those items. The 'A'
option will include all the log entries.
Next, you can select whether to create a new merge file entry for each item
in the log, or you can collect up to 5 donations from a single donor into a
single merge record. The 'O' option creates a new merge record for each log
entry, repeating the donor information if needed. The 'M' option will try
to create one merge record for each donor, and collect all the donations
from that donor into the merge record. The number of items for a donor is
limited to 5, and then a new merge record repeating the donor information
will be created for the next set of 5.
The next option determines whether to set the TYL Date field of a record to
today's date. This is useful when generating Thank You Letters. Press the Y
key to set the date of any log entry included in the merge file. Pressing
the N key will leave the dates in the log unchanged.
The next set of options are a list of the fields you may include in the
merge records. To include a field, set the value to 'Y'. To remove a field
from the merge file, set the value to 'N'. Initially, all the fields are
set to 'Y'.
Finally, you will be asked to enter the name of the merge file to be
created. Remember the name of this file when performing the mail merge
operation from your word processor.
When you press the P key to start printing the merge file, if you have not
already set the name of the merge file, you will be asked to enter the
name. A merge file name must be entered.
28 : rccDONOR
You are then shown a list of the fields which will be included in the merge
file. This list is derived from your option selections. The field numbers
listed will be used by your word processing program during a merge
operation. You will want to keep track of these field numbers.
Press Y to continue using this field set. Press N if you want to cancel
this report and change the field list.
The greeting field contains the "Greeting" entry from the mail list if the
entry is not blank. If the mail list "Greeting" entry is blank, then the
Name field is copied into this field. In a letter, this field is meant to
be used in the salutation, after 'Dear '.
There are two sample WordPerfect and two sample Microsoft Word merge files
included with the installation files. They are the primary files in a merge
operation and will properly use the secondary (data) files created with
this report. Modify them for your own use. RCCTY1PF is meant to be used
with reports for one donation per letter, and RCCTY5PF is meant to be used
for letters containing up to 5 donations. The files with the WP5 extension
are for WordPerfect 5.1, and the files with the MW5 extension are for
Microsoft Word. Please refer to the appropriate word processor's manual for
help in performing a merge operation.
Value Received Entry
The items donated to some events are resold at the event (such as auctions,
or rummage sales). After the event has been completed, you can enter the
final value received on each item (for later analysis). This routine
presents the event log in a table format. Only the log number, value of the
item, and item description are listed in the table, along with the value
received field. To enter the value received on an item, move the cursor
onto the row of the item and press the [ENTER] key. You will be put onto
the received field and allowed to enter the value. When you are done
entering the value and have pressed the [ENTER] key, the cursor will be
moved down to the next entry.
The cursor bar can be moved between auction items by using the [UP] and
down [DN] arrow keys. The [PGUP] and [PGDN] keys will move up and down a
block of entries. By pressing ^[PGUP] you will be taken to the first entry.
^[PGDN] will take you to the last entry.
You can also quickly move to an item by just entering the Event Log number.
29 : Chapter 7 Log (Event)
8 Utilities
There are six tasks which you can perform under the Utilities topic. These
tasks become available from a "Drop Down Menu" when the Utilities topic is
selected from the Main Menu. You can select a task by using the [UP] and
[DOWN] arrow keys to move the cursor over the desired task and then
pressing the [ENTER] key. Or, you can press the first letter of the desired
task, such as pressing the R key to Rebuild Indexes.
The six tasks are:
Option Values Change options for this system
Create/Convert Files Create new data files to be used or convert data
files from older versions of rccDONOR
Rebuild Indexes Pack data files and reindex
Field Options Change the way some fields in the database are
defined
Validate All Data Check each of the data files for common errors, and
optionally delete data with those errors
Info. on rccDONOR The current version and how to register this copy of
rccDONOR
Option Values
The option routine allows you to customize rccDONOR for your particular
organization. You have two sets of options you can change.
Pressing E will let you set two configuration values. The first is your
organization's name. This name will appear on all reports and at the top of
all data entry screens.
The second configuration value is the type of word processor you use. This
setting affects the Word Processing Merge task in the Reports menu and in
the Log (event) menu. Both of those tasks create files useable by a word
processor when performing a mail merge operation. By setting the word
processor type here, then the task will add the appropriate mail merge
codes to the file. You can set the value to 'W' for WordPerfect or to 'M'
for Microsoft Word.
You must inform rccDONOR of your current printer. This information is used
for report generation. There are two codes used to change the printer into
high density (sometimes called compact) mode and to reset the printer. By
selecting a standard printer the correct codes are automatically generated
for you. You select a printer by pressing S and then move the cursor bar
over the printer name which most nearly matches your current printer. If
you do not see a matching printer, you can enter your own codes by adding a
new printer command set.
To enter a new printer, press the [INS] key from the list of printers. You
will then be asked for the name of this printer and the two control codes.
The codes are entered in a special format such that non printable ASCII
codes are surrounded by the CHR() function and ASCII print codes are
surrounded by double quotes (").
30 : rccDONOR
In the case where you manually change the print format on your printer
before printing a report, you would want to make these two codes completely
blank. There is a NONE option available when selecting a printer, and that
setting will automatically provide blank codes for you.
Create/Convert Files
This routine is used to create new data files or convert files from older
RCCMail and rccDONOR formats into the current format. Each data file is
checked for its current status. If the file is the current version, then
that status is shown and you may not do anything else. If no file is found,
then you may create a new data file for the current version. If an older
version of the data file is found, then the appropriate conversion
procedure is given as an option. You select which actions to perform by
entering Y in the box before each data type. Typically, you will select all
the options listed. You must also enter Y at the bottom of the screen to
tell the system to go ahead.
Although the file creation process is very quick, the conversion process
takes a fairly long time depending on the size of your data files.
Reindex Data Files
This procedure is used to pack and index your data files. When you mark
entries for deletion in any data file, you do not actually remove the data
from the file. Instead, the data record is marked for future deletion in a
procedure called packing.
On the screen, you will see a box for each data file. Within each box is a
list of the ways that data is organized (indexed). When you pack the data
or in case the index files somehow get corrupted, you will want to reindex
the files. You can indicate which index you want rebuilt (usually all of
them within a data box) by entering Y at the beginning of each list item.
You must also enter Y at the bottom of the screen to tell the system to go
ahead.
During the execution, you will see the current activity displayed at the
top of the screen. You will also see the number of records in each file
displayed at the top of each data box. The number will change after a pack
is completed to show you the new (smaller) number of entries left in the
data file (when records have been deleted). When an index has been rebuilt,
an asterisk will appear at the start of the index description.
Field Options
There is currently one field in the solicitation data base which can have
its definition changed. That field is the Total Donations field. The
parameters that define total donations are set here. Press the T key to
edit the parameters.
31 : Chapter 8 Utilities
The Total Donations field is the sum of the donations made by a donor. You
can restrict the donations summed by setting a date range; setting whether
to just count cash or item donations, or both; and whether to restrict
donations made to a specific event. By default, the date range is set from
January 1, 1980 (01/01/80) to December 31, 1999 (12/31/99). You can change
the range to a single year of interest. For instance, all of 1991 would be
in the range 01/01/91 to 12/31/91.
When all the values defining the Total Donations field have been set, then
all the Total Donations fields for all the donors will be recalculated.
Validate Data
This procedure is used to check the validity of the data in the files. You
select which data files to check and which types of errors are to be
automatically marked for deletion.
On the screen, you will see a box for each of the main data files. Within
each box is a list of the errors that will be checked within that file. You
decide which data files are to be checked by entering a Y at the top of the
box and leave the boxes marked N for files to be skipped.
If a record within an examined file is found to have and error, you can
have the program automatically mark the record to be deleted. All errors
found will cause a message to be generated, and if you want an error to
automatically mark a record to be deleted, enter a Y at the error
description.
You will also need to indicate whether the error report should go to the
screen, the printer, or to a data file, just as you would for any of the
reports. After this entry has been made, rccDONOR will examine all the
selected files. This procedure will take quite a while to complete,
depending on the size of the data files.
Info. on rccDONOR
This task will display a brief message about the current version of the
rccDONOR program and how to get hold of someone to help with any problems
you may encounter. You may also generate a registration form from this
menu. When you press R, a registration form will be printed out on your
printer which you can fill out and send to Irwin Computer Engineering. This
form is similar to the one shown in Chapter 10, and either can be used for
registering your copy of rccDONOR.
32 : rccDONOR
9 Filter Commands
Filters are a way to choose just some of the mailing list to include in a
report. The ideas behind filters are pretty simple, although the simple
ideas can be combined in complex ways.
A filter acts in a way similar to what the name would suggest. Out of all
the names in the mailing list, some are kept (filtered) for a report and
the rest are discarded from the report, just as a water filter only allows
the desired, pure water to pass through.
A filter is made from a set of tests. Each record is tested by the filter,
and those which pass the test are kept for the report. The simplest test is
a single, individual criteria. Several criteria can be combined into
complex tests (filters).
Individual Criteria
An example of a typical test would be whether a donor had a particular zip
code. First we must decide how to express that we are looking at the zip
code. Since the zip code is part of the basic mailing list information, it
appears in the RCCMAIL file, and we express the zip code as:
rccmail->zip_code
This all appears as one connected set of letters, no spaces. The underlined
is important in the above expression.
Now that we know how to say what we are looking at, we need to show what
test we are performing. Since we are looking for a single zip code (say
93101), then we want the zip code to be equal to the value we want. We
express this statement as:
rccmail->zip_code="93101"
This little test can either pass or fail. We can also say that the test is
true or false. This test can be a complete filter all by itself, and what
it does is say that each record has its zip code checked. When the zip code
equals 93101 then the test is true for that record and the report will
print that record.
These single tests are important for filter criteria. Besides equality, a
test can check whether a value is greater than another value (>), less than
another value (<), greater than or equal to another value (>=), less than
or equal to another value (<=), or not equal to another value (<>).
The way these tests work make sense when we are talking about numbers, but
how about for names and letters. When we compare names or any field where
letters are allowed (called strings) then we are talking about alphabetical
order. For instance,
rccmail->last_name="IRWIN"
33 : Chapter 9 Filter Commands
says that the test is true when the last name is the same as (equals)
IRWIN. But, we can also say
rccmail->last_name>="IRWIN"
and this means that any record with a last name greater than or equal to
IRWIN is true. In this case, anyone whose last name is after IRWIN
alphabetically is also true. Less than or equal to (<=) would mean any name
before IRWIN alphabetically or equal to IRWIN would be true.
There is an additional test specifically for strings, and that is appears
in ($). For example, we can test whether someone has the category code AA
in its category settings with the expression:
"AA"$rccmail->category
This would be described as AA appearing in the rccmail category field.
Combining Criteria
These single tests are important, but the more complex filters are created
by combining several of these tests at once. Two tests are connected by one
of three statements:
.AND. This word combines two tests such that both tests must be true
for the combined test to be true
.OR. This word combines two test such that if one of the tests or the
other test or both tests are true, then the combined test is
true.
.XOR. This combines two tests so that if one test is true or the other
test is true but not both tests are true, then the statement is
true.
Parenthesis are used to group individual tests, and also to group together
combination statements in any order you require. Tests within a set of
parenthesis are tested together before the next set of parenthesis are
tested.
For example, if you want to filter records so that only people with zip
codes in the range 93000 to 93999 are selected, the filter statement would
be:
(rccmail->zip_code>="93000")
.AND.(rccmail->zip_code<"94000")
Another test would be for donors who have given more than $100, or who live
in the 93101 through 93130 zip code areas, or both.
((rccmail->zip_code>=93101)
.AND.(rccmail->zip_code<=93130))
.OR.(rccsolic->total_don>=100)
34 : rccDONOR
This example shows how the zip code test is grouped together before the
donation test by the parenthesis.
You should not need to create your own filter from scratch very often. More
likely, you will want to modify a test created by the set screens. Every
time a set screen is used, the tests selected are added to the previous
filter conditions by an .OR. combining word. You should always check the
entire filter after you've used the set screens. Make sure that the
combined criteria is testing in the way you want it to. The set screens
will try and combine criteria for you, but the combinations they create may
not be the combinations you meant to occur.
35 : Chapter 9 Filter Commands
Command Reference Summary
Individual tests are expressed as:
x = y x must be equal to y
x > y x must be greater than y
x < y x must be less than y
x >= y x must be greater than or equal to y
x <= y x must be less than or equal to y
x <> y x must not be equal to y
x $ y x must appear in y
Individual tests are combined with:
x.AND.y Both x and y must be true
x.OR.y x or y or both must be true
x.XOR.y x or y true, but not both
The result of a test can be reversed by:
.NOT. x Requires x to be false
!x Same as .NOT. x
Parenthesis group tests together and sets the order of evaluating tests:
((x .AND. y) .OR. z)
The x .AND. y combined tests are evaluated first, and then the result
.OR. z is evaluated
36 : rccDONOR
10 Shareware
Shareware distribution gives users a chance to try software before buying
it. If you try a Shareware program and continue using it, you are expected
to register. Individual programs differ on details -- some request
registration while others require it, some specify a maximum trial period.
With registration, you get anything from the simple right to continue using
the software to an updated program with printed manual.
Copyright laws apply to both Shareware and commercial software, and the
copyright holder retains all rights, with a few specific exceptions as
stated below. Shareware authors are accomplished programmers, just like
commercial authors, and the programs are of comparable quality. (In both
cases, there are good programs and bad ones!) The main difference is in the
method of distribution. The author specifically grants the right to copy
and distribute the software, either to all and sundry or to a specific
group. For example, some authors require written permission before a
commercial disk vendor may copy their Shareware.
Shareware is a distribution method, not a type of software. You should find
software that suits your needs and pocketbook, whether it's commercial or
Shareware. The Shareware system makes fitting your needs easier, because
you can try before you buy. And because the overhead is low, prices are low
also. Shareware has the ultimate money-back guarantee -- if you don't use
the product, you don't pay for it.
Registering rccDONOR
rccDONOR is a "shareware program" and is provided at no charge to the user
for evaluation. I encourage you to share it with other organizations, but
please do not give it away altered or as part of another system. The
essence of "user-supported" software is to provide personal computer users
with quality software without high prices, and yet to provide incentive for
programmers to continue to develop new products.
If you find this program useful and find that you are using rccDONOR and
continue to use rccDONOR after a reasonable period of time, you must make a
registration payment of $100.00 to Irwin Computer Engineering. The $100.00
registration fee will license one copy for use on any one computer at any
one time. You must treat this software just like a book. An example is
that this software may be used by any number of people and may be freely
moved from one computer location to another, so long as there is no
possibility of it being used at one location while it's being used at
another. Just as a book cannot be read by two different persons at the same
time. Site-License arrangements may be made by contacting Irwin Computer
Engineering. A registration form appears at the end of this section, in the
file REGISTER.DOC included with this package, or a form can be generated
from the Info. on rccDONOR task of the Utility menu.
Anyone distributing rccDONOR for any kind of remuneration must first
contact Irwin Computer Engineering for authorization. This authorization
will be automatically granted to distributors recognized by the (ASP) as
adhering to its guidelines for shareware distributors, and such
37 : Chapter 10 Shareware
distributors may begin offering rccDONOR immediately (however Irwin
Computer Engineering must still be advised so that the distributor can be
kept up-to-date with the latest version of rccDONOR). Please see the
VENDOR.DOC file for more information and an authorization form.
You are encouraged to pass a copy of rccDONOR along to other non-profit
organizations for evaluation. Please encourage them to register their copy
if they find that they can use it. All registered users will receive:
- the latest version of the rccDONOR system
- a printed, bound copy of the manual
- extensive support (see below)
- a subscription to "For What It's Worth", a newsletter of tips and
ideas for fundraising using rccDONOR
Where to Register
You can order by sending check, cash or money order to Irwin Computer
Engineering (see the registration form below) or with MC, Visa, Amex, or
Discover from the Public (software) Library by calling 1-800-2424-PsL or
713-524-6394 or by FAX to 1-713-524-6398 or by CIS Email to 71355,470.
These numbers are for orders only. To insure that you get the latest
version, PsL will notify us the day of your order and we will ship the
product directly to you. Any questions about the status of the shipment of
the order, refunds, registration options, product details, technical
support, volume discounts, dealer pricing, site licenses, etc, must be
directed to Irwin Computer Engineering (see Support below). You can also
mail credit card orders to PsL at P.O.Box 35705, Houston, TX 77235-5705.
rccDONOR is also part of the CompuServe registration program. If you have
an account with CompuServe, then after logging in, enter GO SWREG. Once
there, you will be allowed to register rccDONOR with your normal CompuServe
payment method. The Registration ID number for rccDONOR is 108.
Support
Support for rccDONOR will be provided for 120 days after registration.
Questions, problems, compatibility issues, and bug reports all fall under
the definition of "support". Problems involving a specific hardware
environment, software environment, or a feature of rccDONOR, and which
require a significant alteration of rccDONOR, will be solved at the
discretion of the author. If this type of modification of rccDONOR has been
rejected, and the problem was reported within the support period, the
registration fee will be refunded.
Support can be provided in any of three ways: mail, CompuServe, or
telephone.
38 : rccDONOR
A. Mail
The address for mail support:
Alan Irwin
Irwin Computer Engineering
P.O. Box 1748
Goleta, CA 93116
Please include a complete description of the problem, a sample (if
appropriate), a description of the system on which you are running rccDONOR
(hardware and software environment), and your address and phone number. I
will either respond by phone or by mail.
B. CompuServe
My CompuServe ID is 71370,1513. I regularly sign on to CompuServe and will
typically respond within a day. Please include a complete description of
the problem, a sample (if appropriate), a description of the system your
are running rccDONOR on (hardware and software environment), and your phone
number.
C. Telephone
My office number is (805) 564-2400. There is an answering machine available
24 hours a day.
Ombudsman
This program is produced by a member of the Association of Shareware
Professionals (ASP). ASP wants to make sure that the shareware principle
works for you. If you are unable to resolve a shareware-related problem
with an ASP member by contacting the member directly, ASP may be able to
help. The ASP Ombudsman can help you resolve a dispute or problem with an
ASP member, but does not provide technical support for members' products.
Please write to:
ASP Ombudsman
545 Grover Road
Muskegon, MI 49442
or send a CompuServe message via CompuServe Mail to ASP Ombudsman
70007,3536.
39 : Chapter 10 Shareware
RCCDONOR REGISTRATION FORM
Contact Name: ____________________________________________________________
Organization: ____________________________________________________________
Address: _________________________________________________________________
City, State, Zip: _______________________________________________________
Telephone: ____________________________________________________________
Date rccDONOR First Obtained __________ Obtained From: __________________
Disk Format: 5.25" [ ] 3.5" [ ]
Answers to the following questions are optional, but will help me to
further develop rccDONOR and other information management programs for
non-profit organizations:
1) What is the purpose or mission of your organization?
2) What do you like about rccDONOR?
3) What features would you like to see added to rccDONOR?
4) What other information management programs do you have?
5) What other information management programs do you see a need for?
6) How did you hear about rccDONOR?
7) What type of computer and peripherals do you use?
8) Additional comments:
Send this registration form and $100.00 registration fee to:
Alan Irwin
Irwin Computer Engineering
P.O. Box 1748
Goleta, CA 93116
(805) 564-2400
Index
AUTOEXEC.BAT 2 Filter 19
Codes 7, 16 Category Set Screen 20
Donation 16 Combining Criteria 34
Donor 16 Command Reference 36
Editing 16 Commands 33
RCCCODES 7 Editing 19
Selecting Donation 14, 26 Individual Criteria 33
Selecting Donor 11, 20 Mail List Set Screen 20
CONFIG.SYS 2 Selection 19
Create/Convert Files 31 Solicitation Set Screen
Donations 6, 13, 25 21
Donor 13 Getting Started 2
Editing 13 How to Use This Manual 1
Event 25 ID Searching 17
RCCDITEM 6 Info. on RCCDonor 32
Selecting Codes 14, 26 Installation 2
Donor Profile Report 22 Introduction 1
Edit Data Menu 10 Key Conventions 1
Editing 8 Labels/Pledge Sheets Report
Codes 16 21
Donations 13 Log (Event) Menu 25
Event Log 25 Mail List 6, 10
Events 15 Basic 11
Mail List 11, 27 Donations 13
Solicitation 12 Editing 11, 27
Zip Codes 14 RCCMAIL 6
Event Log 25 Report 21
Basic 26 Searching 12, 16
Editing 25 Select Entry 27
Report 27 Solicitation 12
Select 25 Sort Order 10, 12
Table 25 Table 10
Value Received Entry 29 Main Menu 9
Word Processor Merge 28 Microsoft Word 5, 23, 28,
Events 7, 15 30
Editing 15 Name Searching 16
RCCEVENT 7 Notes 13
Report 23 Option Values 30
Searching 17 Organization Searching 17
Field Options 31 Overview 6
Files 4 Quit 9
Convert Data 31 RCCCODES 7
Create Data 31 RCCDITEM 6
Create Execution 3 RCCEVENT 7
Definition 6 RCCMAIL 6
Reindex 31 RCCSOLIC 6
Temporary 5 RCCZIP 6
Reindex Data Files 31 Zip Codes 6, 14
Report Output (Screen, Count Report 24
Printer, File) 19 Editing 14
Reports 18 RCCZIP 6
Donor Profile 22 Searching 17
Event Log 27
Events 23
Filter Selection 19
Labels/Pledge Sheet 21
Mail List 21
Output Direction 19
Prompt 18
Word Processor Merge 23,
28
Zip Code Counts 24
Reports Menu 18
Screen Definitions 7
Searching 16
Event 17
ID 17
Mail List 12
Name 16
Organization 17
Zip Code 17
Select 27
Event Log 25
Mail List Entry 27
Shareware 37
Solicitation 6, 12
Editing 12
Notes 13
RCCSOLIC 6
System Requirements 2
Target Audience 1
Total Donations 31
Utilities 30
Create/Convert Files 31
Field Options 31
Option Values 30
Reindex Data Files 31
Validate Data 32
Utilities Menu 30
Validate Data 32
Value Received Entry 29
Word Processor Merge
Event Log 28
Report 23
WordPerfect 5, 23, 28-30
Zip Code Searching 17