****************************************************
* dBase IV HAM RADIO CONTACT LOGGING SYSTEM *
* by Paul Elliott, N3GPU *
* Functional Specifications & Installation Notes *
* Version 1.0 *
* December 1989 *
****************************************************


This is a simple logging system for dBASE IV, using the
Applications Generator. You can use this system with a
runtime-only version of dBASE IV, or you can run it or
make modifications to it using a full copy of dBASE IV.
Source code is included so that dBASE III users can modify
the system to run under the prior version.

I offer this system to dBASE users in the amateur radio
community, to use as-is or as a basis for expansion. It is
available free of charge as a Shareware product. My only
request is that those who share it take care to ensure that
ALL 45 files listed in this document are passed on to the next user or bulletin board system. See file list below.
NOTE: As you use the system, dBASE may create additional
files for its own use. They need not be passed on to the
next user. However, all files listed below are require
for the system to work properly.

No registration fees are required or solicited. Please
direct any comments or questions to my mailing address in
the latest Radio Amateur Callbook. If you want to be
assured a clean, virus-checked copy of the system, please
send $2 to my callbook address with your request to cover
duplication and mailing costs.


Functions
---------

This system incorporates the following functions:

1. Ability to handle 5-10,000 contacts in a single database,
with no more than 2-second response time to retrieve any
record. I used a single dBase IV database file with a
single active index on callsign. There is some redundant
information in each record this way, such as rig,
antenna, and country. But overall system response time
is better than that achieved by using multiple files, and
the system is easier for the average user to modify.
Also, system memory limitations will be avoided.

The sequence of items on the log maintenance screen
follows the format of the ARRL standard log form.

2. Ability to print a report showing all contacts for which
you have not yet sent a QSL card. The report is sorted
by DXCC country. Other reports include a detailed
listing of all contacts in the log, and a one-line
abbreviated listing for each contact, sorted by callsign.
3. Ability to print QSL card labels for contacts where the
QSL Status field and QSL Sent field are both blank,
showing:

- Station worked
- Date
- Time
- Mode
- Frequency
- His RST Report
- My Antenna
- My Rig
- My Power

These data items are all availabel from the contact
record. The labels required are the size normally used
for labeling a 3.5" computer diskette (2-3/4" X 2-3/4",
Avery number 4241 or equivalent -- Egghead software
carries them).



Processing Outgoing QSL Cards Using Computer Labels
---------------------------------------------------

Do ALL of these steps for each batch of contacts before
printing labels for the next. Otherwise, you will print
many duplicate labels.

1. Enter contact information in computer log after checking
for duplicates (stations previously contacted).

2. Check for addresses/routings in Callbook and other
listings. NOTE: I highly recommend the W6GO/K6HHD QSL
Manager List, available for $20/year (12 issues) from
P.O. Box 700, Rio Linda, CA 95673-0700.

3. Check for SASE needs.

4. Update Status field in computer log as follows:
a. Have an address/routing/tracts/stamps -- leave blank
b. No address/routing -- "NA"
c. Need stamps for SASE -- "NS"
e. QSL card already prepared -- add "R/" to any of the
above

5. Print labels for those with a blank Status field.

6. Affix labels to cards and sign. Indicate "PSE QSL" or
"TNX QSL".

7. Address and stuff envelopes.

8. Update computer log QSL Sent, Bureau/Direct, IRC, and
SASE fields as you mail the cards, not beforehand.


Installation Procedure
----------------------

1. Set up a subdirectory called DB4HAMLG under your existing
DB4 directory on your hard disk. Copy all files into
this subdirectory.

2. Set up a .BAT file, Automenu routine, or other menu
selection startup routine with the following sequence of
commands:

PATH=(your normal path);C:\DB4;C:\DB4\DB4HAMLG
CD DB4\DB4HAMLG
DBASE /T DB4HAMLG
PATH=(your normal path)
CD \


Listing of Files
----------------

The following are the names of the 45 files in this system:

DB4\DB4HAMLG\CALLSIGN.NDX
DB4\DB4HAMLG\CATALOG.CAT
DB4\DB4HAMLG\CONFIG.DB
DB4\DB4HAMLG\CONFIG1.DB
DB4\DB4HAMLG\CONFIG2.DB
DB4\DB4HAMLG\CONTACT1.BAR
DB4\DB4HAMLG\CONTACT1.DBO
DB4\DB4HAMLG\CONTACT1.FRG
DB4\DB4HAMLG\CONTACT1.PRF
DB4\DB4HAMLG\CONTACT1.PRG
DB4\DB4HAMLG\CONTACTS.BAK
DB4\DB4HAMLG\CONTACTS.DBF
DB4\DB4HAMLG\CONTACTS.FMO
DB4\DB4HAMLG\CONTACTS.FMT
DB4\DB4HAMLG\CONTACTS.MDX
DB4\DB4HAMLG\CONTACTS.SCR
DB4\DB4HAMLG\DB4HAMLG.APP
DB4\DB4HAMLG\DB4HAMLG.CAT
DB4\DB4HAMLG\DB4HAMLG.DBO
DB4\DB4HAMLG\DB4HAMLG.PRG
DB4\DB4HAMLG\DXCCNTRY.NDX
DB4\DB4HAMLG\EXIT1.POP
DB4\DB4HAMLG\FOR_LIST.DBO
DB4\DB4HAMLG\FOR_LIST.FRG
DB4\DB4HAMLG\FOR_LIST.FRM
DB4\DB4HAMLG\FOR_LIST.PRF
DB4\DB4HAMLG\HOUSKEEP.POP
DB4\DB4HAMLG\QSLACTN1.DBO
DB4\DB4HAMLG\QSLACTN1.FRG
DB4\DB4HAMLG\QSLACTN1.FRM
DB4\DB4HAMLG\QSLACTN1.PRF
DB4\DB4HAMLG\QSLCARD.LBG
DB4\DB4HAMLG\QSLCARD.LBL
DB4\DB4HAMLG\QSLCARD.PRF
DB4\DB4HAMLG\QSLSTAT1.DBO
DB4\DB4HAMLG\QSLSTAT1.FRG
DB4\DB4HAMLG\QSLSTAT1.FRM
DB4\DB4HAMLG\QSLSTAT1.PRF
DB4\DB4HAMLG\README.DOC
DB4\DB4HAMLG\RPTLBL01.POP
DB4\DB4HAMLG\SHORTLST.DBO
DB4\DB4HAMLG\SHORTLST.FRG
DB4\DB4HAMLG\SHORTLST.FRM
DB4\DB4HAMLG\SHORTLST.PRF
DB4\DB4HAMLG\UNTITLED.CAT