Log File Conversion Routines by KA5WSS February 16, 1998 The routines in this package can be used to convert log files to other log formats. DOS version 5.0 or later is expected for the DOS routine and the Windows routine should run on Windows 3.1/95/NT and OS/2. Windows 3.1 and OS/2 users should have Win32s v1.25 or later installed. The included files are: logconv.exe: Converts to and from a variety of file formats (see below). (Windows) clogconv.exe: Windows command line version of logconv.exe dlogconv.exe: DOS version of logconv.exe cqww.cty: Example cty file for DXCluster/DXInfo file read support. stsec.dat: Example file that maps ARRL section and state abbreviations to standard state designators. Used for .sdf file output support. matrix.txt: Shows supported contests for each log format. readme.txt: This file The utilities currently supports the following file formats: File read: ADIF, CT v7, CT v8, CT v9, DXCluster, DXInfo, NA v7, NA v9, TR Log, ARRL .log, WRTC .log File write: ADIF, CT v8, TR Log, dBase, ARRL .log, DXBase .sdf See the file matrix.txt to determine the log and contest types that are supported for input and output. These conversion routines open the input log files read only. However you should always save backup copies of your original log files in case an error occurs. Also some log formats do not record as much QSO information as others. So, ALWAYS keep your original log files! These routines will not write over an existing file. You must delete an output file if you wish to run the conversion program again to generate a file with the same name. Converting WAE logs will usually not retain QTC information. There have been some reports of problems reading in some files that contain embedded spaces (Win95 or WinNT file systems). So far I have only been able to reproduce this with the DOS version of LogConv. If you are running on a Win95 or WinNT system and want to use a command line utility clogconv.exe should work fine and does not appear to be affected by directory names with spaces in them. If you still have problems with the Windows version of LogConv please try the conversion again where neither logconv nor the files to be converted are in directories with spaces in their names. TR Log Note that these utilities do not score the contest if that is not in the input file. QSO point and multiplier information will be output when possible. To add QSO point and multiplier information to a TR .dat log start TR log using the following command: TR READ (file name) This command will load the .dat file and rescore the contest. However you will have to edit a logcfg.dat file for the appropriate contest that also includes the entries: AUTO DUPE ENABLE = FALSE POSSIBLE CALLS = FALSE UPDATE RESTART BIN FILE = FALSE TR Log's merge utility creates a .dat file that does not contain contest header information (contest name and callsign). In order for the logconv utilities to properly handle the merged file reload the log into TR using the TR READ command (see above) so that it will be properly formatted. Generic Options The command line conversion utilities will display progress information when the verbose "-v" option is selected. For large log files this indicates that the program continues to function. Some input files do not contain header information that allows LogConv to determine the contest type on its own. In these cases you must provide the contest type with the "-c" option. The option format is: -c where is one of the following and immediately follows the "-c": AA All Asian Contest ARCI QRP ARCI Contest ARDXDX ARRL DX Contest (DX side) ARRLDX ARRL DX Contest ARRL10 ARRL 10M Contest ARRL160 ARRL 160M Contest CQP California QSO Party CQWW CQ WW DX Contest CQ160 CQ 160M Contest DXPED DXpedition Mode FD Field Day GRIDLOC HF Grid Location Contest IARU IARU HF Championships INTSPR Internet Sprint IOTA Islands on the Air Contest JADX JA Int'l DX Contest KCJ KCJ Contest NAQP North American QSO Party QSO General QSOs SAC Scandinavian Activity Contest SPRINT NA Sprint SS ARRL Sweepstakes TOEC Top of Europe Contest VHFQSO ARRL VHF QSO Party WAE Worked All Europe WPX CQ WPX Contest YODX YO DX Contest 1010 Ten Ten Contest WARNING: specifying an improper contest type could lead to unpredictable results! ARRL File support The ARRL format file does not contain any header information which describes the type of contest the log information represents. When reading in ARRL format files it is up to the user to provide the contest type through the use of the -c option (see above). ARRL Files often contain information pertaining to multiplier and point credit. Logconv attempts to fill in these fields as best it can. However, if the source log file does not contain this information it will not appear in the written file. dBase output dBase output files are written with field names that correspond to expected names in the ADIF portable log format. These names may change when the official ADIF specification is released. When general QSO files are output to dBase format a set of common fields are converted. Not all possible fields can or will be converted because the input file (ADIF for example) may have field types not supported in the dBase code. dBase output options: "-bNumeric" changes the BAND field to state the Amateur band as a numeric value in Meters only. For the UHF bands and above, the band is expressed in fractions of a meter. "-freq" adds a new field to dBase output which displays the exact frequency on which the QSO was made, in MHz. If the original log file does not have this information available this field contains the first frequency of the band specified. Currently only NA input files are known to work with this option. "-qsonum" adds a new field to dBase output which sequentially numbers the QSOs in the file. This field does not necessarily correspond to serial numbers given to stations over the air. "-tApproach" appends a "TM9" label to the time field name so that some dBase compatible programs like Approach will correctly determine that the field is a time field. DXInfo/DXCluster DXInfo files are the .dat files that are output by the rxclustr.exe program available on the web. That program monitors PacketClusters and logs all DX spots. DXCluster files are the .dat files that a PacketCluster stores locally. Logconv assumes that DXCluster/DXInfo files are CQ WW logs. It does NOT filter out contacts on bands or modes that are not allowed in CQWW. For instance a CW spot on 18 MHz will be inserted into the log. Future versions of Logconv may address these problems. Zone information for these log files is determined based upon the information contained in the file "cqww.cty" which should be located in the same directory as the input and output files. cqww.cty is a CT v8 format info file an example of which is now included with logconv. QSO's with stations that can not be found in cqww.cty will be copied to the output file with a zone of 0. NA file support NA file support is currently limited to version 7 files and some of the contests supported by version 9. Due to a lack of sample files I have not been able to support more contests for that version. Please send me more example files! SDF File support Current DXBase SDF file support is still new. I have formatted to output to match some sample files I have come across. I do not yet have a copy of DXBase with which to test SDF file support so this new file format for LogConv may not work properly. SDF file records contain a 30 character comment field. Where possible, LogConv attempts to fill this field with the contest exchange information. For contests which exchange state or ARRL section information Logconv will attempt to fill in the DXBase .sdf file state record based on the information contained in the file "stsec.dat". The file stsec.dat is similar in format to the sec.dat files used by CT but expanded to handle both state and section names. License terms The software in this distribution is released as shareware. If you find the routines useful please register by sending your name, callsign, mailing address, email address and $5.00 to the address below. With this money I hope to purchase some development tools so that I can add support for more file formats, contests and even create new utility programs. When registering, please let me know which versions of logconv you use the most (Windows, Windows command line or DOS). Registered users of these utilities may upgrade to minor releases (ie. 1.10 to 1.11) for free. For semi-major (ie. 1.11 to 1.20) or major (ie. 1.20 to 2.00) releases registered users may upgrade for $2.00. Updates are available from: http://www.qsl.net/ka5wss/log.htm ftp://ftp.qsl.net/pub/ka5wss/logconv.zip You may distribute this package to anyone, provided that all files, including this readme file, are included. Given the nature of the FCC rules governing Amateur Radio, these programs should NOT be distributed via Amateur Radio based networks. 73, Robert Barron, KA5WSS P.O. Box 180703 Austin, TX 78718-0703 U.S.A. email: ka5wss@qsl.net Release Notes: Version 1.43: 2/16/98 - Fixed band designation on CT ARRL 10M contest files. - Changed time stamp method for CT 9.34 files and later. - Added FM mode to TR and ARRL log formats. - Fixed up ARRL .log file output. Version 1.42: 12/27/97 - ADIF file state field filled in automatically when possible. Version 1.41: 11/3/97 - Fixed ARRL 160M ADIF file output. - Fixed QDF file version detection. Version 1.40: 8/22/97 - Added ADIF file read and write support. - Added general QSO mode. - Added Pactor and G-Tor mode support. - Added progress indicator option (clogconv and dlogconv). - Minor CT v8 output bugs fixed. Version 1.31: 7/16/97 - Added support for 47 and 142 GHz bands. - Default "callsign" for ARRL .log input file set to "NOCALL". - Minor TR file output bugs fixed. - Added support for the IOTA and Internet SprINT contests. Version 1.30: 6/21/97 - Added Windows command line version (clogconv.exe) - Added ARRL file read and write support. - Added option to specify contest type (needed for reading ARRL files). - TR Log output will print QSO points if input log provided the info - SDF file state fields filled in automatically when possible. - Fixed CT v9 band field for DXpedition mode. - Fixed CT v9 date processing. Could have been 1 day off. - Fixed dlogconv to properly print QSO numbers > 64K. - Added support for the JA International DX and QRP ARCI Contests. Version 1.22: 2/11/97 - Slightly cleaned up input file type list. - No longer returns file error if stray bytes left at end of input file. - TR read support allows month to be upper or lower case. - Cleaned up .SDF file output (RST sent/rcv are now defaults). Version 1.21: 1/2/97 - Added limited read support for NA v9 files. - Added read support for DX Cluster .dat files. - Changed TR Log "light" band designation from LIT to LGT. - Add -freq option for dBase to output exact frequency. - Expanded number of supported bands on DX Info files. - Added cqww.cty example file to release. Version 1.20: 11/26/96 - Released DOS version of logconv.exe (dlogconv.exe). - Added DXInfo (*.dat) input support (assumes CQ WW only). - Added DXBase (*.sdf) output support. - Added optional QSO number field to dBase output. - Change TR Log 18 MHz band designation to be 17 Meters. - Improved handling of corrupt files. Version 1.12: 10/14/96 - Added configuration options for dBase output. - Fixed TR Log output of QSO numbers greater than 10,000. - Added support for "light" band in VHF contests (CT and dBase). Version 1.11: 9/30/96 - Added Scandinavian Activity Contest (SAC) support (TR and dBase) - Added Top of Europe Contest Club WW Grid contest (TOEC) support (TR and dBase). - Fixed CT v9 SS serial number handling. - Fixed TR Log output file for Cal QSO Party (RST not needed). Version 1.10: 9/13/96 (a.k.a. v1.1) - Added NA v7 .QDF file read support. - Add NA Sprint support (TR, NA and dBase) - Fix placement of QTH on NA QSO Party TR Log output Version 1.02: 9/7/96 - Fix ARRL DX Contest DX side output ability for TR Log files. (TR Log input of ARRL DX Contest DX side still needs to be fixed) - Fix placement of sent RST in TR Log output files.