Dec 132017
 
DBASE IV Ham Radio Log System. Straightforward logging plus status reports & QSL card label printing routine. Source code included.
File DB4HAMLG.ZIP from The Programmer’s Corner in
Category Science and Education
DBASE IV Ham Radio Log System. Straightforward logging plus status reports & QSL card label printing routine. Source code included.
File Name File Size Zip Size Zip Type
CALLSIGN.NDX 1024 44 deflated
CATALOG.CAT 607 227 deflated
CONFIG.DB 720 362 deflated
CONFIG1.DB 720 362 deflated
CONFIG2.DB 718 360 deflated
CONTACT1.BAR 1297 573 deflated
CONTACT1.DBO 14268 4887 deflated
CONTACT1.FRG 4191 1719 deflated
CONTACT1.PRF 698 39 deflated
CONTACT1.PRG 14647 2207 deflated
CONTACTS.BAK 6188 1485 deflated
CONTACTS.DBF 1326 332 deflated
CONTACTS.FMO 6120 2254 deflated
CONTACTS.FMT 6203 1495 deflated
CONTACTS.MDX 8192 1433 deflated
CONTACTS.SCR 7390 1876 deflated
DB4HAMLG.APP 1145 384 deflated
DB4HAMLG.CAT 10019 1123 deflated
DB4HAMLG.DBO 18788 9127 deflated
DB4HAMLG.PRG 19328 6080 deflated
DXCCNTRY.NDX 28672 3745 deflated
EXIT1.POP 748 221 deflated
FOR_LIST.DBO 5988 3058 deflated
FOR_LIST.FRG 5215 2049 deflated
FOR_LIST.FRM 5074 1455 deflated
FOR_LIST.PRF 698 39 deflated
HOUSKEEP.POP 917 351 deflated
QSLACTN1.DBO 5992 3052 deflated
QSLACTN1.FRG 5210 2039 deflated
QSLACTN1.FRM 5069 1462 deflated
QSLACTN1.PRF 698 39 deflated
QSLCARD.LBG 3104 1245 deflated
QSLCARD.LBL 2042 706 deflated
QSLCARD.PRF 698 42 deflated
QSLSTAT1.DBO 5992 3049 deflated
QSLSTAT1.FRG 5611 2145 deflated
QSLSTAT1.FRM 6153 1732 deflated
QSLSTAT1.PRF 698 39 deflated
README.DOC 6319 2440 deflated
RPTLBL01.POP 1713 640 deflated
SHORTLST.DBO 5280 2694 deflated
SHORTLST.FRG 4779 1904 deflated
SHORTLST.FRM 3196 1012 deflated
SHORTLST.PRF 698 39 deflated
UNTITLED.CAT 3503 422 deflated

Download File DB4HAMLG.ZIP Here

Contents of the README.DOC file



****************************************************
* 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


 December 13, 2017  Add comments

Leave a Reply