The Best of the Best

home *** CD-ROM | disk | FTP | other *** search

/ The Best of the Best / _.img / 02192 / logbook.arc / LOGBOOK.DOC < prev next >

Wrap

Text File | 1987-12-25 | 109KB | 2,839 lines

PC-HAM LOGBOOK.DOC Version 3.0 PAGE 1 PC-HAM Version 3.0 G3ZCZ AMATEUR RADIO LOGBOOK PACKAGE VERSION 3.0 (C) Copyright 1985, 1986 - All Rights Reserved By Joe Kasser G3ZCZ POB 3419, Silver Spring, Md., 20901, USA. LOGBOOK is the main program in PC-HAM, a set of DATA Processing Amateur Radio programs for the user of a microcomputer in Amateur Radio. The BASIC language programs may or may not be described in or be based on programs described in the book, SOFTWARE FOR AMATEUR RADIO written by Joe Kasser, G3ZCZ, published by TAB Books (Number 1560), Blue Ridge Summit, Pa., 17214. The DBASE3 programs perform database operations on logbook information. PC-HAM is written and supported by Joe Kasser, G3ZCZ. The program is distributed as a Shareware product. You may freely copy and share the product with your friends, associates and other radio hams. If you decide to use the product, you are asked to become a registered user by sending a QSL card and a contri- bution to the author (suggested amount of $36.50 (ie. half of 73) or equivalent in foreign currency (See registration form below). The contribution covers the cost of distribution of the updated disk, and supports the continual development of "Software for Amateur Radio". Upon receipt of your contribution, you will receive one free update disk ), mail (electronic and regular) support, and notice of further releases. The update disk will contain any new versions of the software on this disk plus new software, accompanying the series of articles currently being written on the applications of data processing concepts of micro- computers to amateur radio. Under no circumstances may this product be sold or distributed with another product without the express written permission of Joe Kasser, G3ZCZ. Joe Kasser, G3ZCZ will only support unmodified copies of this software. Your comments and suggestions for changes are however welcome. If you are the first to suggest a change that is implemented, you will be sent a complimentary copy of the disk with the change incorporated. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 2 TABLE OF CONTENTS 1.0 INTRODUCTION 2.0 LOG ENTRIES 3.0 INSTALLATION 4.0 STARTING THE LOGBOOK PROGRAM 5.0 DISPLAY FILES ON DISK DRIVE 6.0 LOG FUNCTIONS 6.1 CHANGE LOG FILE 6.2 PRINT LOG PAGES 6.3 PRINT LOG INDEXED BY CALL SIGN 6.4 APPEND ENTRIES 6.4.1 DATE 6.4.2 TIME 6.4.3 BAND 6.4.4 CALL 6.4.4.1 Calls of Reciprocal Operators 6.4.5 RX 6.4.6 TX 6.4.7 MODE 6.4.8 POWER 6.4.9 QSLSENT 6.4.10 QSLRX 6.4.11 COMMENTS 6.5 CREATE NEW LOGBOOK DATABASE 6.6 HUNT FOR PREFIX/CALL IN LOG 6.7 SUMMARIZE LOG 6.7.1 TOTAL NUMBER OF CONTACTS 6.7.2 QSL CARDS SENT DIRECT 6.7.3 QSL CARDS SENT VIA BUREAU 6.7.4 QSL CARDS SENT VIA MANAGER 6.7.5 QSL CARDS SENT 6.7.6 QSL CARDS RECEIVED 6.7.7 QSL CARDS OWED 6.7.8 QSL CARDS EXCHANGED 6.7.9 The remaining data. 6.8 UPDATE QSL STATUS 6.9 DISPLAY ENTRIES FOR ONE DAY 6.10 DISPLAY LAST 20 ENTRIES IN THE LOGBOOK 6.11 DISPLAY BLOCK OF 20 ENTRIES 6.12 DETERMINE UNIQUE CONTACTS 6.13 TRANSFER SINGLE PREFIX TO NEW DATABASE 6.15 DISPLAY FILES ON DISK DRIVE 6.16 QUIT THIS MENU PC-HAM LOGBOOK.DOC Version 3.0 PAGE 3 7.0 AWARDS 7.1 WAZ 7.1.1 UPDATE WAZ RECORDS 7.1.2 CREATE A NEW WAZ DATABASE 7.1.3 CHANGE WAZ DATABASE 7.1.4 CHANGE LOGBOOK 7.1.5 PRINT WAZ RECORDS 7.1.6 QUIT THIS MENU 7.2 WAS 7.2.1 UPDATE WAS RECORDS 7.2.2 CREATE A NEW WAS DATABASE 7.2.3 PRINT WAS RECORDS 7.2.4 CHANGE WAS DATABASE 7.2.5 CHANGE LOGBOOK 7.2.6 DISPLAY FILES ON DISK DRIVE 7.2.7 IMPORT FROM A BASIC WAS DATABASE 7.2.8 QUIT THIS MENU 7.3 DXCC 7.3.1 UPDATE DXCC RECORDS (Automatic) 7.3.2 UPDATE DXCC RECORDS (Manual) 7.3.3 CREATE A NEW DXCC DATABASE 7.3.4 CREATE 5BDXCC RECORDS 7.3.5 PRINT DXCC RECORDS 7.3.6 ADD PREFIXES TO A DXCC DATABASE 7.3.7 CHANGE DXCC DATABASE 7.3.8 EDIT PREFIXES IN DXCC RECORD FILE 7.3.9 CHANGE LOGBOOK 7.3.10 UPDATE SINGLE BAND DXCC RECORD (Automatic) 7.3.11 DISPLAY DATA FOR A PREFIX/COUNTRY 7.3.12 DISPLAY FILES ON DISK DRIVE 7.3.13 QUIT THIS MENU 7.4 OBLAST 7.4.1 UPDATE OBLAST RECORDS 7.4.2 CREATE A NEW OBLAST DATABASE 7.4.3 PRINT OBLAST RECORDS 7.4.4 CHANGE OBLAST DATABASE 7.4.5 CHANGE LOGBOOK 7.4.6 DISPLAY FILES ON DISK DRIVE 7.4.7 QUIT THIS MENU 7.5 GENERAL AWARD 7.5.1 UPDATE AWARD RECORDS 7.5.2 CREATE A NEW AWARD DATABASE 7.5.3 PRINT AWARD RECORDS 7.5.4 CHANGE AWARD DATABASE 7.5.5 CHANGE LOGBOOK 7.5.6 DISPLAY FILES ON DISK DRIVE 7.5.7 QUIT THIS MENU 7.6 LZ60 7.7 CHANGE LOGBOOK 7.8 QUIT THIS MENU PC-HAM LOGBOOK.DOC Version 3.0 PAGE 4 8.0 MISCELLANEOUS FUNCTIONS 8.1 MANUAL TRANSFER OF DATA TO CONTEST LOGS 8.2 APPEND FROM BASIC "LOG" FILE TO "DBF" FILE 8.3 DISPLAY FILES ON DISK DRIVE 8.4 DXPEDITION/CONTEST BATCH QSL FUNCTION 8.4.1 Automatically QSL 100% (after a contest or DX-Pedition). 8.4.2 Automatically QSL to those stations you owe cards to. 8.5 (RE)INDEX LOG DATABASE FILE 8.6 CHANGE OFFSET TO UTC 8.7 CHANGE STATION OPERATOR CALL SIGN 8.8 CHANGE LOGBOOK (PUT DATA AND INDEX ON SEPARATE DRIVES) 9.0 POSITION QSL LABELS ON PRINTER 10.0 BASE STRUCTURES 10.1 Logbook 10.2 DXCC 10.3 WAZ 10.4 WAS 10.5 Oblast 10.6 Generic Award 11.0 SHAREWARE PC-HAM LOGBOOK.DOC Version 3.0 PAGE 5 1.0 INTRODUCTION The PC-HAM Logbook is more than a simple menu driven computerized logbook. Not only does it store your logbook on a floppy disk, it allows you to access the data in the logbook in ways that have not been previously possible. The functions of the package are described in detail in this document. Some of the things you can do are. * Display/print your qso's sorted by call sign in Alphanumeric order. * Search for and display all qso's with a specified prefix. * Generate your DXCC status automatically. * Update or Keep award records directly from the log entries. * Analyse contest qso's for duplicates and scoring contacts. * Automatically QSL 100% (after a contest or DX-Pedition) to all stations worked for one contact on each of 5 bands. QSL labels will not be printed for duplicate contacts on any band. The package is written in a programming language called DBASE. A language optimized for data processing. This means that a program laboriously written in BASIC to perform the same functions would require many more lines of code than are used in the modules herein. It is planned to include a contest program written in DBASE in a future Release of PC-HAM. This program will contain fewer lines of code than the BASIC language program included on this disk while at the same time providing more features. A computer language is just a tool for instructing the machine as what to do. In general most any task can be programmed in most any language. The reason that there are so many computer languages is because each is optimized for specific applications. This program was first written in DBASE2 and later updated, improved and converted to DBASE3. 2.0 LOG ENTRIES Each record in the logbook corresponds to a line in a page of a conventional logbook. Each line in the log contains space for the following information. DATE Date. TIME Time. BAND Band. CALL Call sign. RX Signal report received. TX Signal report transmitted. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 6 MODE Mode of QSO, eg. SSB,FM. POWER Transmitter power. QSLSENT QSL sent info. QSLRX QSL rx info. COMMENTS comments and notes. 3.0 INSTALLATION Nothing special required, other than backing up the software before you use it, and then at regular intervals. If you have a Ramdisk, copy the files from the drive to the ramdisk and run the logbook from the Ramdisk. It will execute a lot faster that way. If you have an AUTOEXEC.BAT file on your system you may modify it to start the logbook automatically. 4.0 STARTING THE LOGBOOK PROGRAM WARNING IF YOU ARE USING FLOPPY DISKS, BE CAREFUL WHEN YOU CHANGE DISKS. DO IT ONLY AT THE MENU LEVEL. YOU CAN DESTROY THE DIRECTORY OF A DISK IF YOU REMOVE OR CHANGE DISKS AT THE WRONG TIME. IN OTHER WORDS, OOPS THERE WENT YOUR LOGS. If you are using a hard disk, enter the logbook subdirectory using the "CD LOGBOOK" DOS command. If you are using a floppy disk system, start dBASE in the usual way and then set the default drive to that which contains the logbook diskette. Invoke the logbook by typing the command "DBASE LOGBOOK". After a short period of disk activity, you should see the DBASE sign on message appear and then disappear. The first time you invoke the logbook, you will be asked to supply your call sign and your offset to GMT. Your offset to UTC is the amount of time you have to add to the local time to give you the time in GMT (ZULU) (see section 8.6). You will then be presented with the following screen. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 7 --------------------------------------------------------------- G3ZCZ LOGGING PACKAGE VERSION 3.0 COPYRIGHT (c) 1986, 1987 Default LOG database is LOG LOG FUNCTIONS L AWARDS A MISCELLANEOUS FUNCTIONS M DISPLAY FILES ON DISK DRIVE F POSITION QSL LABELS ON PRINTER P QUIT LOG PACKAGE * QRU : : -------------------------------------------------------------- This is the top level screen. FOR THIS MENU AND ALL SUCCESSIVE ONES, YOU HAVE TO ENTER the CAPITAL letter that corresponds to your choice. It is a good idea to ensure that your CAPS LOCK key is set (to capitals) at this time. A sample logbook is supplied on the disk. It is called FIELD85. It is an extract from a real log. It is suggested that you practise the log functions using that logbook first, and then create your own logbook. 5.0 DISPLAY FILES ON DISK DRIVE Should you choose to display the files on a disk drive, you will be presented with a list of files. A typical display might be as shown below. ----------------------------------------------------------- DATABASE FILES # RCDS LAST UPDATE AWARD DBF 00000 05/08/86 DXCC DBF 00273 05/15/86 LOG DBF 00000 05/02/86 OBLAST DBF 00000 01/01/80 WAS DBF 00050 05/01/86 WAZ DBF 00000 10/18/85 FIELD85 DBF 00159 05/19/86 Waiting ----------------------------------------------------------- PC-HAM LOGBOOK.DOC Version 3.0 PAGE 8 Note that the 'Waiting' message shows up a lot in this package. It is telling you that the computer has paused to let you read the screen. When you have finished reading the screen, let the computer know by depressing the 'ENTER' KEY. 6.0 LOG FUNCTIONS If you select the Log functions, after a few seconds the following menu will be displayed. ----------------------------------------------------------------- G3ZCZ LOGBOOK PACKAGE VERSION 3.0 CURRENT LOGBOOK IS LOG CHANGE LOG FILE L PRINT LOG PAGES P PRINT LOG INDEXED BY CALL SIGN C APPEND ENTRIES A CREATE NEW LOGBOOK DATABASE N HUNT FOR PREFIX/CALL IN LOG H SUMMARIZE LOG S UPDATE QSL STATUS Q DISPLAY ENTRIES FOR ONE DAY 1 DISPLAY LAST 20 ENTRIES IN THE LOG E DISPLAY BLOCK OF 20 ENTRIES B DETERMINE UNIQUE CONTACTS U TRANSFER SINGLE PREFIX TO NEW DATABASE X DISPLAY FILES ON DISK DRIVE F QUIT THIS MENU * QRU :L: --------------------------------------------------------------- 6.1 CHANGE LOG FILE This module prompts you to enter the name of a different logbook. You should normally only change logbooks when one fills up. 6.2 PRINT LOG PAGES This module displays/prints log pages in the order in which the contacts are made. You are prompted to enter the first contact from which the list will be printed as well as the page number. Since a floppy disk can only store about 4000 indexed entries (or 7000 non indexed) you are also prompted for an offset number. This is the number of contacts in the previous log file should your logbook be so big as to require more than one disk file for storage. In this way each time you only need to printout the new entries and they PC-HAM LOGBOOK.DOC Version 3.0 PAGE 9 will appear with the correct sequential numbers even if the log book is split into a number of different database files on different disks. An example of the dialog is shown below for the FIELD85 logbook enclosed on the disk as a sample log file. FIRST ENTRY (Number of entry to be displayed :1 STARTING PAGE :1 Offset From Previous Log (If none, enter 0) :0 Do you want a hard copy (Y/N)? :N The resulting screen display starts off as follows. ---------------------------------------------------------------- LOGBOOK PRINTOUT G3ZCZ PAGE 1 # DATE TIME BND CALL RX TX MODE PWR S R COMMENTS ---------------------------- ------------------------------------ 1 85/09/07 1646 20 G4ANT/P 59 59 SSB 200 - - 1-064 2 85/09/07 1647 20 DF0KD/P 59 59 SSB 200 - - 2-131 3 85/09/07 1648 20 G4AAX/P 59 59 SSB 200 - - 3-086 4 85/09/07 1649 20 YU4EXC/P 59 59 SSB 200 - - 4-198 5 85/09/07 1651 20 DF0SSB/P 59 59 SSB 200 - - 5-160 6 85/09/07 1659 20 G3WAS/P 59 59 SSB 200 - - 6-089 7 85/09/07 1703 20 YU4EZC/4 59 59 SSB 200 - - 7-219 8 85/09/07 1705 20 G4HRS/P 56 59 SSB 200 - - 8-075 9 85/09/07 1712 20 G4MBC/P 59 59 SSB 200 - - 9-136 10 85/09/07 1713 20 DK0LT/P 59 59 SSB 200 - - 10-104 11 85/09/07 1722 20 G3SRC/P 59 59 SSB 200 - - 11-021 12 85/09/07 1726 20 DL0CS/P 59 59 SSB 200 - - 12-073 13 85/09/07 1727 20 DL0HEL/P 59 59 SSB 200 - - 13-045 14 85/09/07 1730 20 G3SFG/P 59 59 SSB 200 - - 14-056 ---------------------------------------------------------------- 6.3 PRINT LOG INDEXED BY CALL SIGN This module /displays prints the whole contents of the log in the alphanumeric order of the call signs. It should be used once in a while, probably after each contest to give you a printed booklet you can refer to during contacts when the computer is not available, or to browse through the log to identify any calls to send QSL cards to. An example of the dialog is shown below for the FIELD85 logbook enclosed on the disk as a sample log file. This time you are only asked one question, namely Do you want hard copy (Y/N) ?:N. The resulting screen display starts off as follows. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 10 ---------------------------------------------------------------- INDEXED LOGBOOK PRINTOUT G3ZCZ as of 85/09/08 PAGE 1 CALL DATE TIME BND RX TX MODE PWR S R COMMENTS ---------------------------------------------------------------- 4X/KA2TJU 85/09/08 0852 15 59 59 SSB 200 - - 88-026 4X6IF/P 85/09/08 0604 15 53 55 SSB 200 - - 38-149 9H3DX/P 85/09/08 0752 20 59 59 SSB 200 - - 71-964 9H4R 85/09/08 1025 20 56 59 SSB 200 - - 122-011 DF0AS/P 85/09/08 0850 15 59 59 SSB 200 - - 87-326 DF0CT/P 85/09/08 0620 15 59 59 SSB 200 - - 50-376 DF0DC/P 85/09/08 1151 15 59 59 SSB 200 - - 150-369 DF0DW/P 85/09/08 0627 15 55 55 SSB 200 - - 58-179 DF0KD/P 85/09/07 1647 20 59 59 SSB 200 - - 2-131 DF0KD/P 85/09/08 1058 15 59 59 SSB 200 - - 124-740 DF0LQ/P 85/09/08 0619 15 55 59 SSB 200 - - 48-136 DF0MN/P 85/09/07 1809 15 59 59 SSB 200 - - 25-040 DF0RE/P 85/09/08 1152 15 59 59 SSB 200 - - 152-246 DF0SSB/P 85/09/07 1651 20 59 59 SSB 200 - - 5-160 DF0SX/P 85/09/08 0844 15 59 55 SSB 200 - - 81-225 DF0WB/P 85/09/08 1330 20 53 53 SSB 200 - - 171- DF3AX/P 85/09/08 0620 15 55 55 SSB 200 - - 51-135 ---------------------------------------------------------------- 6.4 APPEND ENTRIES This module allows you to enter contacts in the log in the traditional sequential manner. It is the module that is "on-line" while you are on the air. As it is used whilst actually in contact with other stations, or in monitoring the bands it has other features. You can use the module in real-time or off-line. In the real-time mode, you use it while you are on the air. The computer will read the date and time form the PC's internal real time clock and enter them in the log. In the off-line mode, you can use the module to enter contact data for contacts previously made. The computer will not automatic- ally update the clock and time information. In both modes, the computer leaves the standard information in place bet- ween entries (to save you keystrokes). You just overwrite data that changed between the sequential entries. The off-line mode can be used while "reading the mail" when you are operating, to enter records from your conventional logbooks into the computer database. As you may have noticed from the sample printouts, and the from scanning the sample logbook FIELD85, each record in the logbook corresponds to a line in a page of a conventional logbook. Each line in the log contains space for the following information. 6.4.1 DATE 8 characters. It is recommended that the date PC-HAM LOGBOOK.DOC Version 3.0 PAGE 11 be entered in the format YY/MM/DD (Year/month/day). this format ensures that the equivalent number associated with the date increases as time passes by. It will simplify retrieval later. You are of course free to use your own method as long as it only uses up to 8 characters. 6.4.2 TIME 4 characters. Use the format HHMM per the samples displayed above. 6.4.3 BAND 3 Characters. The band should be entered in Meters using one of the following bands. 2, 6, 10, 12, 15, 17, 20, 30, 40, 75, 80, or 160. If you do the recommended way, the statistical summary will work properly. If you do it another way, that section of the logbook package will not work. If you work other UHF bands such a 432 MHz use the metric equivalents, such as 70, etc. If you are an OSCAR operator enter the Mode instead of the band, ie A, B, J etc. 6.4.4 CALL 10 characters. Enter the call sign here. If you enter a '-' as the first character in the callsign area, the contact will not be counted in the statistical section. you may thus use it to define contests, change of QTH's or any experimental notes. 6.4.4.1 Calls of Reciprocal Operators It is strongly recommended that you store the calls of reciprocal operators with the area that they are operating in as the prefix in front of the call rather than as the suffix as is commonly done. Thus if you work G3ZCZ operating in W3, store the call as W3/G3ZCZ not G3ZCZ/W3 which is what he calls it. In fact France and Germany amongst others ask reciprocal operators to sign their calls that way on the air. If you don't do this, you will find that for example if you worked G3ZCZ/4X and he was the only 4X contact you have made, the DXCC module will assign him to G rather than to 4X. In fact he might end up as your G card for the DXCC. 6.4.5 RX 3 characters for the received Signal report. 6.4.6 TX 3 characters for the Signal report transmitted. 6.4.7 MODE 4 characters for the Mode of the QSO. Use PC-HAM LOGBOOK.DOC Version 3.0 PAGE 12 SSB,FM,RTTY or SSTV. If you use these, the statistical summary will work properly. If you do it another way, that section of the logbook package will not work. 6.4.8 POWER 4 characters for the Transmitter power in Watts. 6.4.9 QSLSENT 1 character for any QSL sent information. For the purposes of the statistical package, it is recommended that you use the following notation B sent via the bureau D sent direct. M sent via the QSL manager X someone you don't want to send a card to for some reason. 6.4.10 QSLRX 1 character for any QSL received information. It is recommended that you use the following notation R card received. You will notice that a blank in the QSL status (sent or received) is shown as a '-'. This character may be used later in various modules within the logging package. 6.4.11 COMMENTS 10 characters for comments and notes. There are thus a total of 51 characters in each line or record. This mode first asks you if you running in real time. If you elect the "on-line" mode, the computer will fill in the Date and Time information from the computer's internal clock. Make sure that the date and time were set under DOS before you invoked the DBASE2 logging package. The computer will convert your local time to UTC. If you do not elect the "on-line" mode, the computer will copy the date and time information from the previous entry. The mode then clears the screen and displays the log entry at the bottom of the screen. A typical example would be as shown below. ----------------------------------------------------------- 171 LAST CONTACT WAS WITH DF0WB/P DATE TIME CALL BAND POWER MODE RX TX QS QR :85/09/08::1330:: :20 : : 200::SSB : :53 ::53 ::-: :-: QRU (*THPL) : : PC-HAM LOGBOOK.DOC Version 3.0 PAGE 13 ----------------------------------------------------------- When entering information, you may use the cursor left and right keys to position the cursor to the item you wish to enter. You may also use the 'ENTER' key to skip any item. When all of the data has been entered, the cursor will automatically position itself to the control byte. At this time you have the following options. L LOG This is the basic working mode of the module. You enter the QSO data into the spaces provided on the screen. Once the contact data is in the entry, you use the 'L' option to log it to the disk. H HUNT You can check the log to see if a station or prefix has been worked before. P PREVIOUS You can display the last twelve contacts in the logbook on the screen. T TIME You use this to update the time from the computer's clock when using this module in the "on-line" mode. * Terminates the module. A typical display with the P option is shown below. --------------------------------------------------------------- 12 ENTRIES BEFORE DF0WB/P IN LOG, ARE 147 85/09/08 1155 DJ7ST/P 15 59 59 SSB 200 - - 157-349 148 85/09/08 1205 G3BPK/P 15 55 59 SSB 200 - - 159-359 149 85/09/08 1207 G3GHN/P 15 59 59 SSB 200 - - 160-374 150 85/09/08 1209 G3WAS/P 15 59 59 SSB 200 - - 161-1034 151 85/09/08 1215 GM0BRS/P 15 55 55 SSB 200 - - 162-490 152 85/09/08 1242 YC0DPZ 15 59 59 SSB 200 - - 163-024 153 85/09/08 1243 YC4HA 15 59 57 SSB 200 - - 164-049 154 85/09/08 1302 YO9CUF 15 59 59 SSB 200 - - 166-153 155 85/09/08 1305 G4NWG 15 53 54 SSB 200 - - 167-019 156 85/09/08 1306 G4TSH 15 59 55 SSB 200 - - 168-024 157 85/09/08 1307 G4OVF 15 53 57 SSB 200 - - 169-001 158 85/09/08 1323 G4EKT/P 20 59 55 SSB 200 - - 170-592 159 85/09/08 1330 DF0WB/P 20 53 53 SSB 200 - - 171- 159 LAST CONTACT WAS WITH DF0WB/P DATE TIME CALL BAND POWER MODE RX TX QS QR :85/09/08::1330:: :20 : : 200::SSB : :53 ::53 ::-: :-: QRU (*THPL) :P: ---------------------------------------------------------------- PC-HAM LOGBOOK.DOC Version 3.0 PAGE 14 6.5 CREATE NEW LOGBOOK DATABASE This module lets you create a new logbook. You should use this to create your own logbook, name it as your call sign. If you put the log on a blank formatted disk,you won't have to use this feature again until you have made something like 4000 QSO's. It works by creating the new file and copying the structure of the blank file (LOG.DBF) from the default disk to the log file disk. An index file (by Callsign is also created at this time). 6.6 HUNT FOR PREFIX/CALL IN LOG This module allows you to display previous contacts with any station or prefix. If you enter 'G3' for example, you will get a display of all contacts with stations having the "G3" prefix. If you enter 'G3ZCZ' for example, you will get a display of all the contacts with "G3ZCZ". By entering the prefix for a particular country, all contacts with that country may be seen. The module terminates when you enter a '*` as the prefix. 6.7 SUMMARIZE LOG This module does a statistical analysis of the contents of the log. It sequentially checks each entry and displays an ongoing summary of the contacts arranged into various categories. When the module begins, it displays the name of the file and the number of contacts in it at the top of the screen. Then as it scans the log, it puts the date, time and call of the line being scanned on the screen. As each line is scanned, the totals are updated on the screen. A sample of the display is shown below. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 15 ------------------------------------------------------------------ G3ZCZ LOG SUMMARY PROGRAM Version 1.0 G4BGY 81/03/29 1600 2250 CONTACTS IN LOG FILE G3ZCZ-1 QSL SUMMARY SUMMARY OF ENTRIES BY BAND -------------------------------- -------------------------- TOTAL NUMBER OF CONTACTS 2250 10 METERS 666 QSL CARDS SENT DIRECT 1 12 METERS QSL CARDS SENT VIA BUREAU 53 15 METERS 737 QSL CARDS SENT VIA MANAGER 4 17 METERS QSL CARDS SENT 136 20 METERS 585 QSL CARDS RECEIVED 79 30 METERS QSL CARDS OWED 1 40 METERS 35 QSL CARDS EXCHANGED 78 80 METERS 27 160 METERS REPORT BY MODES 6 METERS ---------------------------- 2 METERS 95 SSB CONTACTS 2109 OSCAR MODE A 28 CW CONTACTS 99 OSCAR MODE B 76 RTTY CONTACTS 3 OSCAR MODE J 1 FM CONTACTS 39 OTHERS SSTV CONTACTS ------------------------------------------------------------------ When the scan is over, you are asked if you want to scan another log file. You only answer 'Y' to this if you have so many contacts that they won't fit on one log file. In this example as shown below, the contents of a second log has been added to that displayed above. ------------------------------------------------------------------ G3ZCZ LOG SUMMARY PROGRAM Version 1.0 SV9ADO 86/05/14 1643 6170 CONTACTS IN LOG FILE G3ZCZ-2 QSL SUMMARY SUMMARY OF ENTRIES BY BAND -------------------------------- -------------------------- TOTAL NUMBER OF CONTACTS 8402 10 METERS 1633 QSL CARDS SENT DIRECT 8 12 METERS QSL CARDS SENT VIA BUREAU 281 15 METERS 3269 QSL CARDS SENT VIA MANAGER 14 17 METERS QSL CARDS SENT 852 20 METERS 2879 QSL CARDS RECEIVED 842 30 METERS 2 QSL CARDS OWED 294 40 METERS 160 QSL CARDS EXCHANGED 548 80 METERS 96 160 METERS REPORT BY MODES 6 METERS ---------------------------- 2 METERS 258 SSB CONTACTS 8059 OSCAR MODE 28 CW CONTACTS 137 OSCAR MODE 76 RTTY CONTACTS 3 OSCAR MODE J 1 FM CONTACTS 198 OTHERS SSTV CONTACTS ------------------------------------------------------------------ 6.7.1 TOTAL NUMBER OF CONTACTS PC-HAM LOGBOOK.DOC Version 3.0 PAGE 16 The total number of contacts is the number of call sign entries that don't begin with a "-". 6.7.2 QSL CARDS SENT DIRECT The number of cards that have been sent direct (D) to the stations contacted, and for which replies have not yet been received. 6.7.3 QSL CARDS SENT VIA BUREAU The number of cards that have been sent via the bureau (B) to the stations contacted, and for which replies have not yet been received. 6.7.4 QSL CARDS SENT VIA MANAGER The number of cards that have been sent to the QSL manager (M) of stations contacted, and for which replies have not yet been received. 6.7.5 QSL CARDS SENT The sum of the number of cards sent out, including those for which replies have been received. 6.7.6 QSL CARDS RECEIVED The total number of cards received (R). 6.7.7 QSL CARDS OWED The number of cards that have been received for which you have not replied to. 6.7.8 QSL CARDS EXCHANGED The number of cards which you have exchanged (ie. you sent one, and you received one). 6.7.9 The remaining numbers are the totals in the various categories. If you have used different designations for the BAND information, those data will be summed in the OTHERS category. 6.8 UPDATE QSL STATUS This module allows you to update the QSL status of each contact in the log. If you enter a prefix or call sign, the computer will sequentially present you with each contact in the log for that prefix or call and allow you to change the QSL information. If you don't want to change the information, just type the 'ENTER' key. The module will also print labels for sticking on QSL cards. These labels contain all the information necessary for a valid QSL card. The program is set to print on 3 1/8 by 15/16 (inch) ONE-OFF labels. The labels as printed show the call of the station in enlarged characters. Since this document is on disk, it cannot show a sample of the labels. Run a set of labels PC-HAM LOGBOOK.DOC Version 3.0 PAGE 17 using plain paper in the printer for the FIELD85 sample logbook to see how the module works, and what kind of labels to use. Under certain conditions, such as if you make a change to one entry, you may have to try the command twice to locate other entries for a particular call on the same band. This seems to be due to an anomaly within the DBASE2 language, and is discussed in section 9.1. The module terminates when you enter a '*` as the prefix. 6.9 DISPLAY ENTRIES FOR ONE DAY This module allows you to display/print entries for one specified day. 6.10 DISPLAY LAST 20 ENTRIES IN LOG This module displays the last 20 entries in the logbook. 6.11 DISPLAY BLOCK OF 20 ENTRIES This module displays a block of 20 log entries on the screen. You will be prompted to tell the computer where to start the display. Once the 20 entries are displayed on the screen, you will then have the option to continue, back up or terminate the operation. The prompt is QRU (+ - *). Entering one of these three characters tells the computer what to do next. A + will display the next 20 entries, a - will back up and display the previous 20 entries, while the * character terminates the module as usual. 6.12 DETERMINE UNIQUE CONTACTS. This module allows you to see how many different stations you have contacted and logged. It displays a running count on the screen as it scans the log and then, when it has finished, it displays the totals. 6.13 TRANSFER SINGLE PREFIX TO NEW DATABASE This module lets you extract all the calls beginning with a single prefix into a new or separate database. For example, if you wanted to pull all the stateside log entries from the log you could extract, all entries beginning with N,K,W and A from the main log into a logbook database file called USA.DBF. 6.14 DISPLAY FILES ON DISK DRIVE This module allows you to display the files on a disk drive. You use it to determine the correct name for a file, or to PC-HAM LOGBOOK.DOC Version 3.0 PAGE 18 find out if the file you thought was present on the default drive is really present. 6.15 QUIT THIS MENU This section lets you quit the log section of the program and returns you to the higher level menu. 7.0 AWARDS This module supports various awards. It allows you to extract log entries into the award databases directly without retyping. In the event of the DXCC award, you can let the computer search the log and automatically generate a listing of your DXCC status. When you invoke the AWARD module you will be presented with the following menu. ----------------------------------------------------------------- G3ZCZ AWARD RECORD KEEPING FUNCTIONS Version 1.0 PICK AN AWARD PACKAGE, the following are supported WAZ Z WAS S DXCC D OBLAST O GENERAL AWARD G CHANGE LOGBOOK L LZ60 AWARD (LZ 60th Aniv) B QUIT THIS MENU * QRU : : ----------------------------------------------------------------- At this time you are supposed to pick a letter corresponding to an award package. 7.1 WAZ If you invoke the Worked All Zone (WAZ) module, you will be presented with the following menu. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 19 ---------------------------------------------------------- G3ZCZ WAZ AWARD PACKAGE VERSION 1.4 Default WAZ database is WAZ Default LOGBOOK is LOG UPDATE WAZ RECORDS U CREATE A NEW WAZ DATABASE C CHANGE WAZ DATABASE D CHANGE LOGBOOK L PRINT WAZ RECORDS P QUIT THIS MENU * QRU :Z: ---------------------------------------------------------- The WORKED ALL ZONE award is available from CQ magazine for confirmation of working one station from each of the 40 zones that it has divided the world into. This module contains a database with 40 records, each corresponds to one zone. The record number corresponds to the zone number. The following things may be performed within the award package. 7.1.1 UPDATE WAZ RECORDS This module is used to update the WAZ record file. It is used in an interactive manner. The computer will prompt you with a request for a Zone number. After you have given it one, it scans the WAZ record file and presents you with its findings. If you have an entry for that zone number, it will display it, if you don't have one, it will so tell you. An example of the dialog is ------------------------------------------------------------- Which Zone (0 to terminate) ?:23 Zone 23 is not worked Do you want to update the entry (Y/N) ?: : -------------------------------------------------------------- You are asked if you desire to update the record for that zone, by entering the letter Y for yes, or N for no. If you do, you are then asked to provide a call sign. The computer PC-HAM LOGBOOK.DOC Version 3.0 PAGE 20 will then search the log to find the entry associated with that call sign, and you are prompted to tell the computer to transfer the data from the relevant log entry to the corres- ponding WAZ record. The module terminates when you give it a zone 0. WARNING, DO NOT ATTEMPT TO ENTER DATA INTO THE DEFAULT WAZ FILE ON THE DISK. THIS FILE CONTAINS THE STRUCTURE OF THE DATABASE AND HAS NO SPACE FOR RECORDS. CREATE YOUR OWN RECORD FILE FIRST. IF YOU TRY TO ENTER DATA INTO THIS WAZ DATABASE, THE PROGRAM WILL BOMB. 7.1.2 CREATE A NEW WAZ DATABASE This module allows you to create a new WAZ database. 7.1.3 CHANGE WAZ DATABASE This module allows you to change from one WAZ database to another. You use it if you keep different WAZ records for different bands or modes, or if you have more than one station log file on the computer. 7.1.4 CHANGE LOGBOOK This module allows you to change logbook files without going back to the log function menu. 7.1.5 PRINT WAZ RECORDS This module allows you to print/display the award records. When you invoke it, you are presented with a choice as follows. Whole thing, worked/QSL-d, or QSL-d (T,W,Q) If you want to print/display entries for all the zones in the contest records, enter the letter T for the whole thing. If you want to print/display only those zones which you have either worked or QSL'd, enter the letter W. If you want to display/print only the zones for which you have received QSL cards, enter the letter Q. After typing the 'ENTER' key you will again be prompted. DO you want hard copy (Y/N) ?: If you want hard copy (a printout) answer with the letter Y for yes, else if you only want the information displayed on the screen, enter the letter N. When you follow the choice with the 'ENTER' key, the module will go to work PC-HAM LOGBOOK.DOC Version 3.0 PAGE 21 7.2 WAS The WAS Award is issued by the American Radio Relay League (ARRL) for confirmed contacts with all 50 of the states which make up the United States of America. If you invoke the Worked All States (WAS) module, you will be presented with the following menu. ------------------------------------------------------- G3ZCZ WAS AWARD PACKAGE VERSION 1.1 Default WAS database is WAS Default LOG database is LOG UPDATE WAS RECORDS U CREATE A NEW WAS DATABASE C PRINT WAS RECORDS P CHANGE WAS DATABASE D CHANGE LOGBOOK L DISPLAY FILES ON DISK DRIVE F IMPORT FROM A BASIC WAS DATABASE I QUIT THIS MENU * QRU :S: ---------------------------------------------------------- The following things may be performed within the award package. 7.2.1 UPDATE WAS RECORDS This module is used to update your WAS records. The computer requests a state prefix. You are supposed to give it the US PS two letter code for the desired state. If you don't know or forgot the letters, the computer will remind you as in the following paragraph. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 22 ---------------------------------------------------------------- Which State (* to terminate) ?:TE ENTRY ERROR- THERE IS NO SUCH STATE AS TE ALLOWABLE STATES ARE - AB AL AZ AK CA CO CT DE FL GA HA ID IL IN IO KS KY LA MN MD MA MI MN MS MO MT NB NV NH NJ NM NY NC ND OH OK OR PA RI SC SD TN TX UT VT VA WA WV WS WY WAITING ---------------------------------------------------------- When you enter the correct state, TX for Texas in this example, you will proceed to the next part of the dialog as shown below. --------------------------------------------------------------- STATE OF TX OR TEXAS has not been worked Do you want to update the entry (Y/N/E): : --------------------------------------------------------------- At this time you enter the letters Y N or E depending on what you want to do. The letter Y if you want to update the record. The letter N if you don't want to update the record. The letter E if you want to erase the data in that record. You may want to erase the data in a record if, for example you work K6IR and log him as California, only to find out later when you get the QSL card that he was operating as K6IR/3 in Maryland, and you have not yet worked california. 7.2.2 CREATE A NEW WAS DATABASE This module allows you to create a new WAS database. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 23 7.2.3 PRINT WAS RECORDS This module allows you to print/display the award records. When you invoke it, you are presented with a choice as follows. Whole thing, worked/QSL-d, or QSL-d (T,W,Q) If you want to print/display entries for all the states in any (or all) the call areas in the contest records, enter the letter T for the whole thing. If you want to print/display only those states which you have either worked or QSL'd, enter the letter W. If you want to display/print only the states for which you have received QSL cards, enter the letter Q. After touching the 'ENTER' key you will again be prompted. Which call area (0-9, for all enter 10) At this time you enter the number corresponding to the call area you wish to see displayed. If you wish to see a display of all states in all call areas, enter the number 10. Follow the number with the 'ENTER' key, and you will be prompted with one further request. DO you want hard copy (Y/N) ?: If you want hard copy (a printout) answer with the letter Y for yes, else if you only want the information displayed on the screen, enter the letter N. When you follow the choice with the 'ENTER' key, the module will go to work. 7.2.4 CHANGE WAS DATABASE This module allows you to change from one WAS database to another. You use it if you keep different WAS records for different bands or modes, or if you have more than one station log file on the computer. 7.2.5 CHANGE LOGBOOK This module allows you to change logbook files without going back to the log function menu. 7.2.6 DISPLAY FILES ON DISK DRIVE This module allows you to display the files on a disk drive. You use it to determine the correct name for a file, or to find out if the file you thought was present on the default drive is really present. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 24 7.2.7 IMPORT FROM A BASIC WAS DATABASE If you used the BASIC WAS package in PC-HAM 1.0 or 1.5, you may use this option to append the BASIC record file into the DBASE format used by this package. This module should save you some retyping. Before you do so however, check that the BASIC data is delimited by the "," sequence, not just the comma (,). If it isn't, use a wordprocessor in its non document mode to achieve this state. 7.2.8 QUIT THIS MENU This module takes you back to the previous menu. In this case, you return to the Award menu. 7.3 DXCC The DX Century Club (DXCC) is an award offered by the ARRL for confirmed contacts with at least 100 different countries. If you invoke the DXCC module, you will be presented with the following menu. .cp24 ----------------------------------------------------------------- G3ZCZ DXCC AWARD PACKAGE Version 1.6 Default DXCC database is DXCC Default LOG database is LOG UPDATE DXCC RECORDS (Automatic) U UPDATE DXCC RECORDS (Manual) M CREATE A NEW DXCC DATABASE C CREATE 5BDXCC RECORDS 5 PRINT DXCC RECORDS P ADD PREFIXES TO A DXCC DATABASE A CHANGE DXCC DATABASE D EDIT PREFIXES IN DXCC RECORD FILE E CHANGE LOGBOOK L UPDATE SINGLE BAND DXCC RECORD (Automatic) S DISPLAY FILES ON DISK DRIVE F DISPLAY DATA FOR A PREFIX/COUNTRY X QUIT THIS MENU * QRU :D: --------------------------------------------------------- The following things may be performed within the award package. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 25 7.3.1 UPDATE DXCC RECORDS (Automatic) This module automatically searches a logbook database and updates the DXCC status of the designated DXCC database file. You would use the module the first time you use the package, or after a contest or other period of activity, or after a batch of cards from many countries have arrived from the QSL bureau, and you have updated the QSL status for each of those contacts. This module DOES NOT RECOGNIZE SEPARATE BANDS OR MODES. The module displays each prefix as it is being checked. It then displays the calls of the various stations having that prefix as it searches for the first contact that was QSL'd. 7.3.2 UPDATE DXCC RECORDS (Manual) This module allows you to update a DXCC prefix manually. It is faster to update a single prefix this way. You can use this module to update a country for which you worked a third prefix, ie. a prefix not in the database. For example, the two prefixes for the Philippines are DU and DX. If you have worked neither of these but have worked a DV prefix, you may use this module to enter that 'DV' contact into the record. An example of the dialog is shown below. --------------------------------------------------------------- Which DXCC prefix (* to terminate) ?:I1 00130 I1 IT ITALY IT9ZOU 86-04-25 0622 20 SSB W Do you want to update the entry (Y/N) ?: : ----------------------------------------------------------------- When you give it a prefix, it displays the existing record. If you want to update the record, it will prompt you for the call of the station in the QSO that you want to update the record with. If you give it an unknown prefix, it will so tell you. 7.3.3 CREATE A NEW DXCC DATABASE This module allows you to create a new DXCC database. It assumes that there is a DXCC database on the disk called 'dxcc'. It copies the prefix and country information into a second dxcc database which you name and then ensures that it is blank. In this manner, if you used the default 'DXCC' database when you first begin to use the package, additional databases will always be blank as you create them. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 26 7.3.4 CREATE 5BDXCC RECORDS This module performs an automatic generation/update of your 5 Band DXCC status. It uses default databases named 10DXCC, 15DXCC, 20DXCC, 40DXCC, 80DXCC for those bands. It creates the databases copying the structure and default data from the 'DXCC' database supplied with the package. You may think of this module as performing the CREATE A NEW DXCC DATABASE followed by an UPDATE DXCC RECORDS (Automatic) sequence for each of the traditional 5 HF bands. 7.3.5 PRINT DXCC RECORDS This module displays or prints the contents of a DXCC data- base. You are given the choice of printing the whole data- base, those countries worked/QSL-d, or just those countries QSL-d. The database is in alphanumeric prefix order, so it is ready to be sent to the ARRL with the award request, and is handy for having at the operating position when monitor- ing the bands. This module allows you to print/display the award records. When you invoke it, you are presented with a choice as follows. All PX's,Worked/QSL-d,or QSL-d (P,W,Q) : If you want to print/display entries for all the DXCC countries in the contest records, enter the letter P for the whole thing. If you want to print/display only those prefixes which you have either worked or QSL'd, enter the letter W. If you want to display/print only the prefixes for which you have received QSL cards, enter the letter Q. After typing the 'ENTER' key you will again be prompted. DO you want hard copy (Y/N) ?: If you want hard copy (a printout) answer with the letter Y for yes, else if you only want the information displayed on the screen, enter the letter N. When you follow the choice with the 'ENTER' key, the module will go to work. 7.3.6 ADD PREFIXES TO A DXCC DATABASE In the main, the DXCC database contains the 274 most common or unambiguous prefixes that you are most likely to work. Some prefixes such as 'VP8' or 'VK9' apply to more than one country. If you work those, you should use this module to PC-HAM LOGBOOK.DOC Version 3.0 PAGE 27 add the prefix to the file, and then use the manual updating mode to enter the QSO data into the file. Take care here to make the added prefixes non-ambiguous. For example, if you worked VP8AA in Antarctica, and then VP8FLK on the Falkland islands, use the prefixes VP8A and VP8F respectfully for those areas. In this manner, should you run the automatic updating module at a later time, the computer will not overwrite your data with something that it thinks is more appropriate. Look at the entries for VK9 in the DXCC file for an example of the usage of this approach. In a like manner, new prefixes can be added to the database. The database is then sorted on "prefix" to a new version. Make sure there is space on the disk for a temporary DXCC database before evoking this operation. 7.3.7 CHANGE DXCC DATABASE This module allows you to change from one DXCC database to another. You use it if you keep different DXCC records for different bands or modes, or if you have more than one station log file on the computer. 7.3.8 EDIT PREFIXES IN DXCC RECORD FILE Two possible prefixes are provided for each country. This module has picked the most common ones. If you have worked a different one, edit the database to include it. For example, the two prefixes for the Philippines are DU and DX. If you have worked neither of these but have worked a DV prefix, change the DX to DV and the DXCC status of the Philippines will be taken care of. 7.3.9 CHANGE LOGBOOK This module allows you to change logbook files without going back to the log function menu. 7.3.10 UPDATE SINGLE BAND DXCC RECORD (Automatic) This module performs an automatic update of the DXCC status for a single band. It is identical to the module of section 7.3.1 except in that it requests you to enter the name of the single band file. You can also use this to update the records for one of the new WARC bands such as the 30 Meter band, if you name the corresponding record file as 30DXCC. 7.3.11 DISPLAY DATA FOR A PREFIX/COUNTRY This module is designed to be used when you don't have your printed DXCC records handy. It gives you a display of the contents of a desired Prefix record, so that you can check your DXCC status for a desired country on-line. When you invoke the module you will be presented with the PC-HAM LOGBOOK.DOC Version 3.0 PAGE 28 following display. CURRENT DXCC FILE IS DXCC Which Prefix (* to terminate) ? : : At this time enter a prefix. the computer will match the characters entered, so that for example if you enter the letter G, it will match the first Prefix record that begins with the letter G. If it can't match the prefix, it will tell you so. You terminate the module in the usual manner by entering the * character. The format and contents of the display are shown by this typical example. CURRENT DXCC FILE IS DXCC Which Prefix (* to terminate) ? :G : ENGLAND G3 G0 G3FPK 82/02/14 1518 20 SSB Q You see the country name, followed by the two prefixes you have allocated to that country. If that country had not been worked (or the DXCC database not updated with that information), the rest of the line would have been blank. However, since the country was worked, the display continues. The remaining data are the callsign of the station worked, the date, time, band and mode of the QSO, and lastly the QSL status. Here a letter Q indicates that a QSL card has been received, while the letter W indicates that the station was worked and a QSL card has not yet been received. 7.3.12 DISPLAY FILES ON DISK DRIVE This module allows you to display the files on a disk drive. You use it to determine the correct name for a file, or to find out if the file you thought was present on the default drive is really present. 7.3.13 QUIT THIS MENU This module takes you back to the previous menu. In this case, you return to the Award menu. 7.4 OBLAST This award is issued by the Russian Amateur Radio Sport Federation for working various areas (Oblasts) of the Soviet Union. If you invoke the OBLAST module, you will be presented with PC-HAM LOGBOOK.DOC Version 3.0 PAGE 29 the following menu. ----------------------------------------------------------------- G3ZCZ OBLAST AWARD PACKAGE VERSION 1.4 Default OBLAST database is OBLAST Default LOGBOOK is LOG UPDATE OBLAST RECORDS U CREATE A NEW OBLAST DATABASE C PRINT OBLAST RECORDS P CHANGE OBLAST DATABASE D CHANGE LOGBOOK L DISPLAY FILES ON DISK DRIVE F QUIT THIS MENU * QRU :O: ---------------------------------------------------------------- The following things may be performed within the award package. 7.4.1 UPDATE OBLAST RECORDS This module allows you to update the record for each Oblast. It requests you to enter the Oblast number and then scans the records for the data associated with that particular Oblast. You are then prompted as to how to continue. WARNING, DO NOT ATTEMPT TO ENTER DATA INTO THE DEFAULT OBLAST FILE ON THE DISK. THIS FILE CONTAINS THE STRUCTURE OF THE DATABASE AND HAS NO SPACE FOR RECORDS. CREATE YOUR OWN RECORD FILE FIRST. IF YOU TRY TO ENTER DATA INTO THIS OBLAST DATABASE, THE PROGRAM WILL BOMB. 7.4.2 CREATE A NEW OBLAST DATABASE This module allows you to create a new OBLAST database. 7.4.3 PRINT OBLAST RECORDS This module allows you to print/display the award records. When you invoke it, you are presented with a choice as follows. Whole thing, worked/QSL-d, or QSL-d (T,W,Q) : If you want to print/display entries for all the Oblasts in the award records, enter the letter P for the whole thing. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 30 If you want to print/display only those which you have either worked or QSL'd, enter the letter W. If you want to display/print only those for which you have received QSL cards, enter the letter Q. After typing the 'ENTER' key you will again be prompted. DO you want hard copy (Y/N) ?: If you want hard copy (a printout) answer with the letter Y for yes, else if you only want the information displayed on the screen, enter the letter N. When you follow the choice with the 'ENTER' key, the module will go to work. 7.4.4 CHANGE OBLAST DATABASE This module allows you to change from one OBLAST database to another. You use it if you keep different OBLAST records for different bands or modes, or if you have more than one station log file on the computer. 7.4.5 CHANGE LOGBOOK This module allows you to change logbook files without going back to the log function menu. 7.4.6 DISPLAY FILES ON DISK DRIVE This module allows you to display the files on a disk drive. You use it to determine the correct name for a file, or to find out if the file you thought was present on the default drive is really present. 7.4.7 QUIT THIS MENU This module takes you back to the previous menu. In this case, you return to the Award menu. 7.5 GENERAL AWARD This is a general award package that is designed to be used with any award such as the Deutche Amateur Radio Club (DARC) DOK award or for keeping track of the VHF/UHF QRA locator squares that you have worked. The award records are kept in an indexed database. If you invoke the Generic Award module, you will be presented with the following menu. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 31 ----------------------------------------------------------------- G3ZCZ GENERIC AWARD PACKAGE VERSION 1.2 Default AWARD database is AWARD Default LOG database is LOG What AWARD file :AWARD : ------------------------------------------------------------ THE FIRST THING TO DO IS CREATE A NEW AWARD DATABASE . Thus if you are using the package for the first time, do not prompt the computer with the name of the award file you wish to create, rather just push the 'ENTER' key, advance to the following menu and create the new database file. After you have entered in the name of the Award file that you want to work on, you will be prompted with the following menu. ----------------------------------------------------------------- G3ZCZ GENERIC AWARD PACKAGE VERSION 1.2 Default AWARD database is AWARD Default LOG database is LOG UPDATE AWARD RECORDS U CREATE A NEW AWARD DATABASE C PRINT AWARD RECORDS P CHANGE AWARD DATABASE D CHANGE LOGBOOK L DISPLAY FILES ON DISK DRIVE F QUIT THIS MENU * QRU :G: ----------------------------------------------------------------- The following things may be performed within the award package. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 32 7.5.1 UPDATE AWARD RECORDS This module lets you update the records from the log. You will be prompted along the line for the award area code (DOK number or QRA locator square, etc.). The module works in a similar manner to the other award updating modules. WARNING, DO NOT ATTEMPT TO ENTER DATA INTO THE DEFAULT AWARD FILE ON THE DISK. THIS FILE CONTAINS THE STRUCTURE OF THE DATABASE AND HAS NO SPACE FOR RECORDS. CREATE YOUR OWN RECORD FILE FIRST. IF YOU TRY TO ENTER DATA INTO THIS AWARD DATABASE, THE PROGRAM WILL BOMB. 7.5.2 CREATE A NEW AWARD DATABASE This module allows you to create a new Award database. 7.5.3 PRINT AWARD RECORDS This module allows you to print/display the award records. When you invoke it, you are presented with a choice as follows. All PX'S,Worked/QSL-d,or QSL-d (P,W,Q) : If you want to print/display entries for all the award records, enter the letter P for the whole thing. If you want to print/display only those which you have either worked or QSL'd, enter the letter W. If you want to display/print only those for which you have received QSL cards, enter the letter Q. After depressing the 'ENTER' key you will again be prompted. DO you want hard copy (Y/N) ?: If you want hard copy (a printout) answer with the letter Y for yes, else if you only want the information displayed on the screen, enter the letter N. When you follow the choice with the 'ENTER' key, the module will go to work. 7.5.4 CHANGE AWARD DATABASE This module allows you to change from one AWARD database to another. You use it if you keep different AWARD records for different awards, bands or modes, or if you have more than one station log file on the computer. 7.5.5 CHANGE LOGBOOK This module allows you to change logbook files without going back to the log function menu. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 33 7.5.6 DISPLAY FILES ON DISK DRIVE This module allows you to display the files on a disk drive. You use it to determine the correct name for a file, or to find out if the file you thought was present on the default drive is really present. 7.5.7 QUIT THIS MENU This module takes you back to the previous menu. In this case, you return to the Award menu. 7.6 LZ60 This is an example of a section of software written to scan the log and extract log data and total points for a specific award. The award in question was the Bulgarian 60th Anniversary Award issued by the Radio Club in Sofia for working LZ and LZ6 stations during a particular time frame. The code performing this task is described below. 7.7 CHANGE LOGBOOK This module allows you to change logbook files. 7.8 QUIT THIS MENU This module takes you back to the previous menu. In this case, you EXIT the logbook package, and return to DBASE2. When you return to DBASE2 you will be presented with the following screen. ----------------------------------------------------------------- Enter QUIT <CR> to return to DOS 73 de G3ZCZ . ------------------------------------------------------------------ At this time you may exit to DOS by typing the word QUIT followed by the 'ENTER' key, or you may use the interactive query language mode of DBASE2 itself to access the log data. An example of such an access to display all contacts on any day in any mode that took place between the hours of 1800 UTC and 1900 UTC is listed below. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 34 USE &LOGBOOK DISPLAY ALL FOR TIME > '1800' .AND. TIME < '1900' You may also write small program modules to perform specific tasks. For example, as performed by Section 7.6, the Bulgarian Amateur Radio Club issued the LZ 60 Award in 1986. The requirements for the award were to score 60 points when working LZ stations between 1 July 1986 and 31 December 1986. Each contact with an LZ6 prefix counted as 6 points, while other LZ prefixes only counted as 1 point. A program module to search the log and total up the score could be written looking something as follows. *LZ60 SCAN LOG FOR LZ60 AWARD REQUIREMENTS ? 'LZ60 AWARD POINTS CHECKER' ACCEPT 'Do you want Hard Copy (Y/N) ? ' TO pf IF pf = 'Y' SET PRINT ON ENDIF USE &logbook INDEX &logbook FIND LZ STORE 0 TO points STORE 0 TO spoints ERASE ? ' CALL DATE TIME BD TX RX MODE POWER ' ?? 'COMMENTS POINTS' ? '----------------------------------------------------------' ?? '------------' DO WHILE call = 'LZ' IF date >= '86/07/01' .AND. date <= '86/12/31' IF call = 'LZ6' STORE 6 TO points ELSE STORE 1 TO points ENDIF STORE spoints + points TO spoints ? call,date,time,band,tx,rx,mode,power,comments,points STORE call TO ncall DO WHILE call = ncall * SKIP DUPES SKIP ENDDO SKIP -1 ENDIF SKIP ENDDO USE ? '----------------------------------------------------------' ?? '-------------' ' ? 'TOTAL POINTS = ',spoints SET PRINT OFF RELEASE spoints,points,ncall RETURN PC-HAM LOGBOOK.DOC Version 3.0 PAGE 35 When the program is run, the printout which could be sent to the club as a claim for the award would look something as follows. CALL DATE TIME BD TX RX MODE POWER COMMENTS POINTS ---------------------------------------------------------- LZ1R 86/07/13 0934 15 59 59 SSB 400 207- BFRA 1 LZ2KRM 86/07/13 0702 15 59 59 SSB 400 167- 28 1 LZ6BC 86/08/06 0733 20 57 57 SSB 200 LZ1BC DIM 6 LZ92S 86/07/18 0613 20 59 59 SSB 400 1 ----------------------------------------------------------- TOTAL POINTS = 9 8.0 MISCELLANEOUS FUNCTIONS This module pretty much covers the remaining rarely used functions within the package. If you elect this choice, you will be prompted by the following menu. ----------------------------------------------------------------- MISCELLANEOUS FUNCTIONS VERSION 1.2 LOGBOOK B:G3ZCZ MANUAL TRANSFER OF DATA TO CONTEST LOGS U APPEND FROM BASIC "LOG" FILE TO "DBF" FILE V DISPLAY FILES ON DISK DRIVE F DXPEDITION/CONTEST BATCH QSL FUNCTION Q (RE)INDEX LOG DATABASE FILE I CHANGE OFFSET TO UTC T CHANGE STATION OPERATOR CALL SIGN C Quit this menu * QRU :M: ---------------------------------------------------------------- The following things may be performed within this package. 8.1 MANUAL TRANSFER OF DATA TO CONTEST LOGS This module allows you to enter (by hand) contact data from old contest logs in a speedy manner to build the log data base. After all, there is no point in using this program if you don't have any data in the log. The log should be created using the CREATE function in the logging package. The first entry should then be made manually using the APPEND function (also in the log module) to set the date, mode and power information. Quit that menu PC-HAM LOGBOOK.DOC Version 3.0 PAGE 36 and move back to this one. Set the logbook to whatever you called this one and then choose the 'U' option. Enter the time and call data in the relevant spaces, then enter the whole report received in the comments area, (If you are updating an SSB contest, leave a space between the report and further data. IE., use '59 100' rather than '59100'), the computer will take care of the reformatting later. After the contact data for each QSO has been input, the program prompts for a decision. It gives the operator the choice of three things to do as follows; L Log the entry into the database B Change the band information. * Terminate the program When the program is terminated, the computer prompts the user asking if the last entry was the last entry in the whole log. If it was, the module formats the log by moving the first three characters in the comments to the "report received" column. You are also asked if you want the contacts numbered. If you do, the contacts will be numbered sequentially and that number placed in the comments column. The last operation performed is that the log is indexed so that the regular commands of the package will work on it. It must be repeated that this program is designed for rapid entry of old contest logs into the database, logs in which the only differences between one entry and the next are the time, callsign and reports with the occasional change of band. Any other data must be set or changed using DBASE features. BY THE WAY, THIS MODULE IS GOOD FOR CHECKING A CONTEST (OPERATED AS NON COMPUTER ASSISTED) FOR DUPES AFTER THE EVENT. IF THE CALL AND BAND INFORMATION FROM THE LOGS ARE ENTERED INTO THE DATABASE USING THIS MODULE, THE COMPUTER CAN THEN BE USED TO SORT THE CALLS AND FIND DUPES OR MULTIPLE BAND CONTACTS, TELL YOU HOW MANY COUNTRIES YOU WORKED, ETC. DO YOU KNOW IF YOU WORKED THE SAME STATION ON 5 BANDS? (DO YOU EVEN CARE?) 8.2 APPEND FROM BASIC "LOG" FILE TO "DBF" FILE This module creates a database file (.DBF) from the contest log using a blank log database file (LOG.DBF). It copies the contact data from the log generated by the CONTEST.BAS program into the new database log. It then lets you append the contest log database to the main station logbook database. The main logbook database is then ready for the next contest or any further data processing and analysis desired. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 37 Since the contest log database is saved as a stand alone log file, even after its contents have been appended to the main log database, the module allows you to index the contest log database so that you can then display or print the call signs in the contest in alphanumeric order to check for duplicates, prefixes or what ever. If you want to work directly in DBASE, you may even get displays of contacts on different individual bands by using variations of the DBASE command 'DISPLAY ALL FOR BAND = "xx" ' where xx is the band you want displayed. The module performs much of the same task (excluding the clean up function) as the last part of the CONTEST.BAS program. If you compare the two source code listings, you will get an idea of the differences in string handling between DBASE2 and BASIC. 8.3 DISPLAY FILES ON DISK DRIVE This module allows you to display the files on a disk drive. You use it to determine the correct name for a file, or to find out if the file you thought was present on the default drive is really present. 8.4 DXPEDITION/CONTEST BATCH QSL FUNCTION This module is designed to perform the following two batch QSL label printing functions. It is designed for an EPSON MX series printer and 3 1/8 by 15/16 inch one-off labels. 8.4.1 Automatically QSL 100% (after a contest or DX- Pedition) to all stations worked for one contact on each of 5 bands. QSL labels will not be printed for duplicate contacts on any band. The program does not differentiate between modes, so if you went on a DXpedition and used several modes, keep the logs separate until after this operation is performed. 8.4.2 This module can automatically scan your log for QSO's for which you have received QSL cards but not sent them out, print labels for those contacts and update the QSLSENT status of the log entry. It will request your choice of mode with the following query. All QSO-s or just those owed (A or O) : If you wish to send a card to every unique station on each band, reply with the letter A. If you only want to print labels for those stations that you owe cards to, reply with the letter O. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 38 The module will then start to work. As it scans the log, it will display log entries, and flag those that QSL labels were printed for. It will also change the QSLSENT information from a '-' to a 'B', assuming that all the cards are going via the QSL Bureau. 8.5 (RE)INDEX LOG DATABASE FILE This module allows you to index logs that you have ported over from other DBASE formats, or to re-index logs that have had their index files damaged in some manner. 8.6 CHANGE OFFSET TO UTC You use this module to change the offset to UTC when your local time zone changes between daylight savings time and standard time. You are prompted to enter the offset as follows. What is your offset to UTC (HH) ? Your reply should be the number of hours that you normally add to the local time to give you the time in GMT. For example, if you have to subtract 3 hours from the local time for GMT, reply to the prompt with the number -3. On the other hand if you have to add 7 hours to your local time zone to get the GMT time, you will have to enter 7 in reply to the prompt. This value of offset time is only used in the real-time log updating function (see section 6.4). 8.7 CHANGE STATION OPERATOR CALL SIGN This module allows you to change the station call sign. You use this if you have logs for different stations on-line and want corresponding printouts of the logs. Its useful for husband and wife home stations or for keeping logs from different QTH's all on the same hard disk. 8.7 QUIT THIS MENU This module takes you back to the previous menu. In this case, you return to the Main menu. 8.8 CHANGE LOGBOOK This module allows you to change logbook files. If your logbook file is too large to go onto a single floppy disk, you may put the .DBF file on one disk ,and the .NDX file on another. This IS THE ONLY PLACE IN THE PACKAGE WHERE YOU CAN TELL THE PROGRAM THAT THE DATA AND INDEX FILES ARE IN DIFFERENT PLACES. 9.0 POSITION QSL LABELS ON PRINTER PC-HAM LOGBOOK.DOC Version 3.0 PAGE 39 This module lets you position the labels in the printer before you begin to print a batch of labels to stick on the QSL cards. 10.0 DATABASE STRUCTURES The program package uses a number of data bases. 10.1 LOG.DBF This is a blank logbook data with the following structure. Fld Name Type Width Comment 001 DATE C 008 Date in format YY/MM/DD 002 TIME C 004 Time in format HHMM 003 BAND C 003 Band eg 10, 20, 40 004 CALL C 010 Call sign 005 RX C 003 Signal report received 006 TX C 003 Signal report transmitted 007 MODE C 004 Mode of QSO, eg. SSB,FM. 008 POWER C 004 Transmitter power 009 QSLSENT C 001 QSL sent info. eg. B (bureau) 010 QSLRX C 001 QSL rx info. eg. R (received) 011 COMMENTS C 010 comments and notes. The log is indexed so that the calls in it may be viewed alphanumerically. As a rule in order to be able to find calls in the log, the log has to be indexed. the usual thing to do is to index the log on the call sign. this will place all the call signs in a sequential order. Since there is a good chance that some stations will be worked more than once, they will appear as duplicates to the index. That does not cause any problem until you try to change something in an indexed entry that has a duplicate. If that happens, DBASE makes the change but then positions the record at the end of the duplicates. Thus, for example, if you tried to change the state of the QSL information of the first record of a series of duplicates, the change will be made but the pointer will then be positioned to the next non-duplicate record in the list. This can be annoying, especially when you are updating the QSL status for a station who has sent you more than one card (ie. different cards for QSO's on different bands arrive from the QSL Bureau in the same batch. In an effort to minimize this state of affairs, while at the same time minimizing the amount of disk space taken up by the index, the indexing criterion used here is to index the log on both callsign and band ("call+band"). Using this technique, as far as the index is concerned duplicate PC-HAM LOGBOOK.DOC Version 3.0 PAGE 40 records will only exist for successive contacts ON THE SAME BAND, as opposed to successive contacts. If you wanted to avoid duplicates completely, you could index the log on "call+date+time". 10.2 DXCC.DBF This is a sample DXCC database with the following structure. Fld Name Type Width Comments 001 PX C 004 Prefix for DXCC. 002 PX1 C 004 Alternate prefix. 003 COUNTRY C 010 DXCC country name. 004 DCALL C 010 call of station worked. 005 DDATE C 008 date of QSO. 006 DTIME C 004 time of QSO. 007 BAND C 003 band QSO took place on. 008 DMODE C 004 mode used. 009 DSTATE C 001 QSL status. ** Total ** 00049 10.3 WAZ This is the STRUCTURE of a WAZ database. It is not a sample database. The structure of the database is as follows. Fld Name Type Width Comments 001 DCALL C 010 call of station worked. 002 DDATE C 008 date of QSO. 003 DTIME C 004 time of QSO. 004 DBAND C 003 band QSO took place on. 005 DMODE C 004 mode used. 006 DSTATE C 001 QSL status. ** TOTAL ** 00031 10.4 WAS This is a sample WAS database with the following structure. Fld Name Type Width Comments 001 STATE C 013 The name of the State. 002 CALLAREA N 001 Call area of the State. 003 DSTATE C 001 QSL status. 004 DCALL C 010 call of station worked. 005 DBAND C 004 band QSO took place on. 006 DDATE C 008 date of QSO. 007 DMODE C 004 mode used. 008 PC C 002 The 2 letter abbreviation of the state. ** TOTAL ** 00044 PC-HAM LOGBOOK.DOC Version 3.0 PAGE 41 10.5 Oblast This is the STRUCTURE of an OBLAST database. It is not a sample database. The structure of the database is as follows. Fld Name Type Width Comments 001 DCALL C 010 call of station worked. 002 DDATE C 008 date of QSO. 003 DTIME C 004 time of QSO. 004 DBAND C 003 band QSO took place on. 005 DMODE C 004 mode used. 006 DSTATE C 001 QSL status. ** TOTAL ** 00031 10.6 Generic Award This is the STRUCTURE of an AWARD database. It is not a sample database. The structure of the database is as follows. Fld Name Type Width Comments 001 PC C 010 Award element identifier. 002 DCALL C 010 call of station worked. 003 DBAND C 004 date of QSO. 004 DDATE C 008 time of QSO. 005 DTIME C 004 band QSO took place on. 006 DMODE C 004 mode used. 007 DSTATE C 001 QSL status. ** TOTAL ** 00042 11.0 SHAREWARE PC-HAM is distributed with a marketing approach called Shareware. Shareware, is a method of distributing quality software at a low price. Anyone can receive a distribution copy of the product from the PC-SIG library or from any source whatsoever. You may then use and review the product to determine if you'd like to continue using it. If you decide to use it, you are encouraged to become a registered user. Whatever your decision, you may still freely use, copy and share the product with your friends and associates and other amateur radio operators (hams). This marketing concept saves everyone money because by having users distribute and promote the product, users deal directly with the author, saving the costs of advertising, fancy packaging as well as distributors fees etc. These savings are then passed on to you. The contribution is mainly used to pay for production, copying charges AND to support the further development of PC- HAM. The next version of PC-HAM depends on the support of its users. After using the product, please register for a contribution of PC-HAM LOGBOOK.DOC Version 3.0 PAGE 42 $36.50 (or equivalent in any currency). Registration provides the following benefits: Receive an UPDATED copy of PC-HAM registered to your callsign. You will be included in the mailing list so that you may receive new product announcements. Receive further future releases of PC-HAM at a significant discount. You may register your copy of PC-HAM by completing the accompany- ing registration form and mailing it to the address listed below. A limited license is granted to any user of the program to freely copy and distribute the product on the following conditions: YOU MAY: Use the program on any microcomputer on which this package was designed to operate. Freely copy and share unmodified copies of the product with your associates. This includes putting the software on a BBS. YOU MAY NOT: Sell the product for a fee and/or distribute the product along with other products without express written permission. Provide the use of the software in a computer service business, network, timesharing, interactive cable television link, without express written permission. Grant sub licenses, leases, or other rights in the software to others. Modify or remove the Copyright notice from the program, diskette or its manual. Joe Kasser, G3ZCZ warrants that the original diskette as received from G3ZCZ, in which the PC-HAM program package is distributed is furnished to be free from defects in the material and workmanship under normal use for a period of thirty (30) days from the date of delivery to you. The defective diskette must be returned to Joe Kasser, G3ZCZ for this warranty to be effected. PC-HAM LOGBOOK.DOC Version 3.0 PAGE 43 ================================================================ REGISTRATION FORM Send ____ Copies of Registered PC-HAM at $36.50/ea. ____.__(73/2) TOTAL ____.__ =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=* Mail (Together with a QSL card) To: Joe Kasser G3ZCZ POB 3419, Silver Spring, Md., 20901. As I am on a long term assignment much of the time that involves travel, the mailbox may not be emptied for two months at a time, so please be patient. Name:_____________________________________________CALL__________ Address:________________________________________________________ City:__________________________ State:_____ ZIP _______________ Telephone:(_____) _____-_______ Current PC-HAM Version:__________ Registration on your current copy (or source) :_________________ Comments: Constructive comments will get you on the testers list for future pre-updates.