1.8.3 After the Contest
- 1.8.3 After the Contest
- 1. First, a Word on Protecting Your Data
- 2. Editing Individual QSOs
- 3. Entering Multiple QSOs After the Contest
- 4. Change All QSO Times/Dates by a Fixed Amount
- 5. How to Create Cabrillo Files
- 6. How to Merge Contest Logs
- 7. How to Print the Log
- 8. How to Get Statistics
1. First, a Word on Protecting Your Data
After almost every contest, we hear from a new user (or sometimes even an experienced one) who is afraid he or she has lost the log from the contest just completed. Fortunately, it is usually not true, but here are a few things to remember:
- Backup - this is just as important with logging software as with any other computer application. Data not backed up can be data lost if something happens to your hardware or you make a mistake while manipulating the log database if you haven't backed it up. N1MM Logger+ stores all your QSO data in a file with the extension .s3db. The name of the file is whatever name you assigned to it when you first set up the program. There are other databases also used by the program - N1MM Admin.s3db, N1MM Packet Spots.s3db, and Do_Not_Use_Or_Erase.s3db, but all the QSO data are in that first one. The easiest way to do really secure backup is to use a free backup program such as Syncback SE to back up your active QSO database to a USB "thumb drive." Any such drive you can buy today is plenty big enough, dirt cheap, and safe from virtually anything short of a ball peen hammer.
- Save A Copy - Before you do anything, even if you just want to peek into your QSO database with an SQLite viewer, save a copy manually to a safe location. You are, after all, only human; we all can make mistakes, so it's wise to do what you can to protect yourself against them.
- Transaction Files - During normal operation N1MM Logger+ saves the information about each QSO in a simple text file. These files are stored in a sub-folder in the Databases folder in the user files area and can be used to recover in the event the database file is corrupted.
- Here's an explanation of how you can use those files to recover your data quickly, during a contest, or at your leisure if you haven't done one of the two steps suggested above:
- The transaction log is created for each contest you log to
- The file is closed after each transaction and reopened to force the data to be written to disk
- To keep things simple and foolproof, you are not allowed to change the name of the transaction log
- The name is used to make sure you are loading it properly, and to prevent mixing logs of two contests. Example name: 'CQWWCW - 2005-09-19 - 14.TRN' i.e.: Contest name - date log created - an internal index number
- To Recover your log, you MUST import the transaction log into a NEW (empty) database and a NEW contest log. See this link
- The new contest log must be the same contest as the contest from the transaction file (Example: if restoring CQWPXCW, the new contest must also be CQWPXCW). Why? To prevent a user recovering from a database problem making the problem worse. This will prevent any issues from duplicate contacts and a number of other problems
- As you load the transaction log, a new transaction log is automatically made with the transactions in the first log. Thus you should never have to merge logs. You always use the last one
2. Editing Individual QSOs
The easiest way to edit a QSO is by double-clicking in the Log window on the data you want to change. In rare cases, you may need to select the QSO in the Log Window and right-click. Select "Edit Contact." The Edit Contact Window will appear - for full details see the explanation here.
Crackdown on Post-Contest Logging ChangesContest sponsors are cracking down on post-contest log "massaging" that uses resources you access after the contest is over. The CQWW Contest Committee has recently been particularly explicit about this, saying that "the...Committee considers it unsportsmanlike to 'clean' your log post-contest using data sources such as recordings, call sign databases, etc." This kind of restriction is not intended to apply to post-contest log changes that are based on things you noted during the contest, such as problems with the CTY.DAT file, bad abbreviations for counties, states or provinces, etc. If you caught it during the contest, you should feel free to fix it afterward.
Sometimes you may need to recover a QSO that you deleted by mistake during the contest. When a QSO is deleted, it is not completely removed from the database; instead, it is moved into a special log called DELETEDQS, from which it can be recovered as follows:
- First, export the contest log to ADIF (File > Export > Export ADIF to file > Export ADIF to file...). Open that ADIF file with Notepad and look for an entry that looks like <CONTEST_ID:nn>contest-name in each QSO record. Take a note of what nn and contest-name are - you will need to use them in the next step. Keep that Notepad window open.
- Open the DELETEDQS log from inside N1MM+ (File > Open Log in Database... - it will be the bottom log entry on the list), find the QSO in question, right-click on it and select Copy > Copy ADIF string (Copy is near the bottom of the popup menu). Then you can paste that into the Notepad window with the main contest log ADIF file in it. Edit the <CONTEST_ID:8>DELETEDQS field in the recovered QSO record to change it to match the other QSOs in the file. Save the file.
- In N1MM+, create a new database (File > New Database...). In that new database, create a new contest log of the correct type. The start date and time won't be right, but you can edit those to change them to the actual contest date. Now import the edited ADIF file into the log (File > Import > Import ADIF from File...), and use the Tools > Rescore Current Contest menu item to recalculate the score.
3. Entering Multiple QSOs After the Contest
Computer trouble? Made a paper log during (part of) the contest? The program has some nice features that will allow rapid QSO entry. You can either enter the time for each QSO, or there are features to let you set the date and time via interpolation. (Remember, exact QSO times are not critical for contest sponsors, just within reason).
- Type frequency band (4 or 5 digit numeric frequency, e.g. 7000, 14000) in the call-sign textbox of the Entry window and hit Enter. Then type the mode (CW, USB, LSB, etc.) and hit Enter.
- Enter calls and exchanges, and log them, as long as they are on the same band. Don't worry about date and time right now.
- When you need to change bands, enter the new frequency band and continue.
3.1. Change Time/Date for a Single Hand-Entered QSO
Updating the date and/or time of a single QSO is best done by double-clicking on the time stamp for that QSO and then using the date-time box that appears to edit the date and time. Alternatively, you can use the Edit Contact option in the right-click menu associated with the Log Window and edit the date and/or time in the Edit Contact window.
3.2. Change Time for Multiple Hand-Entered QSOs
This method can be used to interpolate approximate times for a series of contacts. This time interpolation feature is most useful if you have a bunch of QSOs to enter. If you have one or two QSOs whose times need changing it is easier to do it by editing in the Log
Make a Copy of Your LogMake a backup copy of your log database. You cannot (automatically) reverse the time interpolation process below. You have been warned!
- In the Log window, single-click the first QSO whose time and date you want to change. to highlight the row
- With mouse over the Log window, right click
- Select >Set Start Interpolation Time Row
- Enter the new timestamp for the first QSO, and click <OK>
- Now, click on the last QSO whose time/date you want to change, to highlight the row
- With mouse over Log window, right click
- Select >Set Stop Interpolation Time Row
- Enter desired time for that last QSO, and click <OK>
Changing QSO Time and DateThe utility will average out and interpolate the time for each QSO in the group of QSOs you have selected. Remember there is no "undo" feature. If you have a large gap in time in your hand log, enter the first batch of QSOs, and do the interpolation. Then enter the second group of QSOs and do a 2nd interpolation.
Single Computer Mode OnlyIf you have more than one computer networked in N1MM+, this feature does not work. The option is disabled whenever Networked Computer Mode is on.
4. Change All QSO Times/Dates by a Fixed Amount
Back Up Your Log DatabaseWhile you could easily recover from a mistake during the following adjustment by performing another offset, it is still a good idea to play safe.
This will fix a log where all QSOs are off by a fixed amount of time (for example, when the times are correct but the dates are wrong by one or more days because the QSOs were entered after the contest).
- Right click in the Log window
- Select >Change timestamps of the entire log by a fixed amount
- A dialog box will open, and enter offset time (+ or -) in minutes
The date will automatically adjust if the offset rolls a QSO into a different day. Time is entered in minutes, and can be negative time to go backwards. (You might need a calculator to determine the offset minutes if your date was off by many days, months, or years). For example, entering +1440 will shift a complete day forward; -2880 two days back.
5. How to Create Cabrillo Files
To submit your log, you need to export it from the database in the proper format. Cabrillo is used by all major contests.
- Select File >Generate Cabrillo File.
- Make sure that your Station information (Config >Change Your Station Data), and overall contest setup are correct (in the Contest Setup dialog, reached through File >Open Log in Database ...). For example, is your entry class correct? Your power classification? Whether Assisted or not? Are your State and ARRL Section both entered correctly in your station data?
- Did you put the right information in the Sent Exchange field, and nothing else? For example, when the exchange in a contest is 5NN WV, it may be tempting to put the whole thing in the Sent Exchange. That will screw up the Cabrillo file with multiple signal reports for each QSO, so get in the habit of putting the signal report in your stored messages, not in this field.
- A Cabrillo file will be created named <yourcall>.LOG. By default this is placed in the ExportFiles sub-folder in the N1MM Logger+ user files directory, but you are given the options of choosing a different name and/or of saving the file anywhere else you wish.
It is a good idea to rescore your log (Tools >Rescore Current Contest) before generating the Cabrillo file.
6. How to Merge Contest Logs
If you ran a multi-op station but did not network your logging computers, you will need to combine the logs from each computer into a single log submission for the contest sponsors.
6.1. Using N1MM Logger+ and ADIF Files to Merge Logs
This merge method is the most automated and should require no manual log editing, but will only succeed if the contest types in each logging computer were identical. If the contest types were not identical, it may be possible to recover with the help of a text editor and some detective work, but it will likely not be easy. It's better by far to avoid this situation by using the identical contest types during the contest.
- Examine the logs to ensure that the contest types are identical in each computer: >File >Open Log in Database
- Export an ADIF file from each logging computer: >File >Export >Export ADIF to file. Assign a unique name to each ADIF file to distinguish it from others when importing. Before continuing, guarantee that the contest types from each computer were identical by opening each ADIF file with a text editor (like Notepad) and looking for the ADIF expression CONTEST_ID. They should all be the same length and contest name. For example: <CONTEST_ID:14>ARRL-FIELD-DAY
- Copy all exported ADIF files to the computer that will create the merged log
- Launch N1MM Logger+ in the merge computer. If the merge computer is one of the ones that was used during the contest, you will need to create a new database for the merged log: >File >New Database. Now in the new database or on the new computer, create a new contest log for the merged records: >File >New Log in Database. Be careful to make the contest type identical to the contest type that was used during the contest
- Import the extracted ADIF files one after another into the new contest log: >File >Import >Import ADIF from file
- Use >Tools >Rescore Current Contest to rescore the contest
- Extract the new, merged contest log for submission to the contest sponsor: >File >Generate Cabrillo File
6.2. Using Excel and Cabrillo Files to Merge Logs
In some circumstances, it might be easier to combine logs outside N1MM Logger+ by importing the Cabrillo files into a spreadsheet program like Excel. As with the ADIF method, this works best if the contest types are identical, or at least use the same Cabrillo format (i.e. similar contest exchanges, same columns).
- Create a Cabrillo file from each log: >File >Generate Cabrillo file. Assign a unique name to each log file to distinguish it from others when importing
- Copy all exported Cabrillo log files to the computer that will create the merged log
- Combine the QSO records from each Cabrillo log into a single text file using a text editor (like Notepad). Open each Cabrillo file, and copy only the QSO records - leave out the header information in the beginning and END-OF-LOG statement at the end. Paste this QSO information into a new text document (a .TXT file) with the QSOs from every log.
- Launch Excel in the merge computer, and import the combined .TXT file into a spreadsheet. In Excel: >File >Open, set file type for TXT, and select the merged QSO log file. In the Excel text import wizard, declare the original data type as fixed width. In the Data Preview dialog window, adjust the field delimiters as necessary to begin each Excel column at the beginning of a log field. Press <Finish>. Examine the QSO columns in the spreadsheet to ensure that your import was successful
- Select the entire spreadsheet using your mouse or <ctrl-A>, then sort the spreadsheet by date and time: >Data >Sort, column D (date), and column E (time)
- Export the sorted log data to a space-delimited file: >File >Save as >FORMATTED TEXT (Space Delimited) .PRN
- Using an editor, copy/paste the Cabrillo header information and END-OF-LOG statement from one of the original Cabrillo logs into the sorted data file. Rename this file as a .LOG file type and submit it to the contest sponsor.
7. How to Print the Log
There is no specific option for printing a log directly. However, if you Click on Export on the File menu, there's a variety of options that can be used to create a file that you can then print a copy of:
The most likely reason for wanting a printed log is for awards submissions or archiving. Because N1MM Logger+ is not intended as a general-purpose logging program, it does not offer award tracking functions. However the ADIF file option will give you a file that can be readily imported into any popular general logger. If you just want something for a notebook, the Generic export will give you a text file that can be printed from Notepad.
8. How to Get Statistics
From the View menu item in the Entry window, choose Statistics. This tool allows you to select any two data points of interest. For example, you can select hours for the Row and Zones for the Column, and the program will display a table of how many QSOs in which zones were worked in which clock hours. This is a lot easier to use than it is to explain in words, so give it a try.