This version corrects the link to the LoTW page so synchronization works again; and corrects the problem that some users - with non-native English Windows setups - had with QRZ.com.

Version 5.5 15.04.2009

Swisslog is has now been released in the public domain, per Walter HB9BJS's wish!

This version - again - corrects the problem that we had with QRZ.com...

Version 5.4 28.11.2008

In this new version the DX Summit link has been fixed, and the problem with the QRZ.com QSL manager database has been fixed as well.

Version 5.3 21.11.2007

This corrects the problem that we were having with the outdated SFI data from DX Summit. In version 5.3 this data is downloaded directly from the NOAA website.

Version 5.2 24.06.2005

SWISSLOG Version 5.2 contains

The Award Administration Functions which are not fully completed but are nevertheless useful.
The QSL Sort Function
Some existing functions are slightly changed to support the new functions.

You find the 5.2 functions in the main menu under New Functions.

The following standard functions have been changed:

Add / Edit Mode and Band
The functions to define Report-Modes and Bands was moved to the Add / Edit Mode and Band dialogs

New Functions:

Statistic This is the new version of the statistic. It should give the same results as the old one.
Award Administration
This is the main Window for the Award Administration. It consist of 4 sub-windows

Select QSOs for the Award.

SWISSLOG calculates the QSOs which qualify for the award. You can accept the proposed QSOs or select an other one.
- Press on the + sign to see what other QSOs are available and select QSOs by checking the checkbox in the 'Select' column.
- To deselect a proposed or selected QSO just deselect the corresponding checkbox.
- Press Save Selection to save Your choices in the Award Control Table
- The Need column tells You if a QSO is needed for the Award
Organize QSOs for Award

In this Window you see the QSOs which are currently selected for the Award and their status. You can change the status of selected QSO by pressing the corresponding function button.
- Select QSOs by setting the checkmark in the 'Select' Column. Note: Currently the first QSO can not be selected not all fields are fully visible. I have made an error report to the maker of the grid component.
- You can replace QSOs which are not yet submitted with the delete function.
- Press on the + sign to see what other QSOs are available and select QSOs by checking the checkbox in the 'Select' column.
Statistic

This is the Award Statistic. It is used to see the total counts

Reports

This is a special report window which works only on the QSOs selected for the Report. Currently You can use every report which is available. But remember the selection criteria's of the report is only applied to the QSOs of the Award. Because the reports are dynamically modified, some may not work.

For each Award a view (table) is created which selects the QSOs of the Award. the name of the View is the name of the Award from which all blanks and special characters have been removed prefixed with AWD_. For example for the Test-Award DXCC Full the name of the view is AWD_DXCCFull

A special View called ACTIVEAWARD selects the QSO of the currently active Award. This makes it possible to create generic reports, reports which can be used for all award. I have created such a report. Currently it is automatically selected if You open the Report window.
Create / Modify Award Definitions

Award definitions are very similar to the statistic reports you already know. The only difference is, that award definitions are connected to a statistic. You can create award definitions when you open the Award Administration or with the specific function.

There can be many award definitions for the same statistic. The statistic is only used to select the qualifying QSOs. I have only defined two Award Definitions or testing. These may not represent valid awards.

I hope, that some of You who are specialized in awards will define Award Definition and send them to me. To define an award, you may have define new Report .Bands and -Modes This is now done under Edit ¦ Add/ Edit Bands and Add / Edit Modes

Statistic Colors

This dialog can be called from the main menu or from within a statistic. It allows You to specify how the status of a QSO is displayed. You can use text or pictures. Send me the pictures if you have good looking ones.

Callbook View

The Callbookview Lists all callbook-entries and allows You to edit the Callbook - Entries independent of QSOs. When initially opened the view is grouped by ISQslManager. If there are any QSL-Manager in the Log You see two groups, one containing the stations which act as QSL-Manager and an other with stations which don't.

5.2 Ecb 15.10.2007

QRZ.com bug is now fixed. The callbook infos can be correctly retrieved directly from the qrz.com server.

5.2 Eca 19.04.2006

Servernames in Telnetwindow contained garbage at the end.

5.2 Ec 13.04.2006

HamCall CD lookup fixed
Bottom-Panel Problem fixed

5.2 Eb 03.04.2006

QSL-Send Date is now set in the Register-QSL Window
Update if MyQTH, Event and WConds works again

5.2 Ea 03.04.2006

DXCC-Tab is now part of the Datamodel and can be used for reports. It contains the ARRL DXCC Number.
The Register-QSL Window opens with the correct tab activated
Calls in the form call*prefix ar converted to Call/prefix for ADIF Export
Country Database was updated (VQ9)

5.2 Dc 16.03.2006

Mass-update is now possible most fields in MyQTH, Evends and WCOND
Default RST behavior corrected
Wrong QSL Sortkey when DXCC in callbook-entry was NIL

5.2 Db 28.02.2006

Important: Please do also download and replace:

the new Country Database
the new SWLSTAT.MDB
the new Mapfiles

Searcharguments in the form Call/Suffix like or prefix/Call like fo/dl5xu are now supported. Search arguments containing a / can not contain any compare opeators and only one DXCC can be assigned to them.
WAP-Statistic: Added F and I in the selection criteria. The consequence is, that the field for the DPF-Statistic had to be changed for Field 3 to Field 7.
The DB-Error when storing a new QSO in which the QSL-Manager is the QSO-Partner itself is solved
If the new Country-DB is used, all DXCC entries with CE9 are converted to KC4 because in the new Country DB CE9 has been replaced by KC4.

5.2 Da 26.02.2006

The Problem with the Pivot Tables is corrected

5.2 D 15.02.2006

LoTW: Problems with missing QSOs with where exactly at midnight solved
Telnet-Support: Swisslog now generates automatically a different SIDD for each connection (up to 10)
Reset of QTH Locator and of the geographical coordinates when changing Date is corrected

5.2 Cka 30.12.2005

The Band / QRG modification did not work 100% if the QRG was taken from the TX

5.2 Ck 27.12.2005

LotW import problems solved. Some QSOs where not imported properly, this is solved now
Input sequence in QTH Page mad more consistent
Band / QRG conflict handling changed. Conflict are solved automatically in most cases.

5.2 Ch 24.11.2005

Several small correction made
Invalid Mode was not recognized correctly at many places. This could lead to errors in importing QSOs or in LOTW updates and other places.

5.2 Cc 27.09.2005

Calculation for Report-Modes with AND connectors corrected
Error during Migration from Version 4 DB to Version 5 DB corrected
Problem with LOTW Synchronization solved. (if there are more than one QSOs on same Band and Mode on same day only the first QSO was flagged as accepted.

5.2 Ca 05.09.2005

Support for the Hallo Rotor added
The Dialog displayed when QTH-Locator / Coordinates do not match can again be disabled for the session

5.2 c 07.07.2005

I added some functions we discussed at the Hamradio workshop
- Totals all Bands to have a total for the DXCC Challenge. It contains the sum of the countries confirmed in all bands which are part of the Statistic. If You add a Report-Mode containing all modes which count for the Challenge You have the total for the Challenge
- New Total for the number selected for the Award submission
- Checkbox to easily select the QSOs for the report based on the status.
Add a check if the correct DB is selected when opening a DB
Fixed some of the reported problems.

5.2 b 26.06.2005

Contains fixes for small problems discovered during the Hamradio fair

Setting the Status in the Award -A Admin function did not always work
QSO Entry Window, Selected Page was not restored after restart
QSO Entry Window, Statistic-Values not saved when copied from the info-table
QSO Entry Window, Added Codnitions field to new- and Previous QSOs
Register QSL-Card, cursor not in search-field when opened
New Statistic, Change from text to graphic display did not work
Some QSL-Label reports where not fully converted for the QSL-Card sort

5.2 a 24.06.2005

Initial Version released for the Hamradio fair

Version 5.1 10.01.2005

5.1h 21.05.2005

Clear Dates when QSL Indicators are cleared

automatically drop down Band- and Mode-Box in QSO Entry window when entering the field for operation without mouse.

LoTW Window now sizable

Headers in Quick-Info Window now bold again

Default format for calculated fields (Day, Mont, Year) was invalid

'Index out of bound' problem (hopefully) solved

Refreshing Callbook CD info should now work, please test !

5.1g 18.04.2005

LoTW login Problems solved ! ARRL did change the LoTW Login, Swisslog had to be adapted.

5.1f 03.04.2005

MyQTH, MyCond and Event are now saved in the DB. So the selection should be correct after a DB change

MyConds and Event are automatically synchronized with the ones defined as default in MyQTH if MyQTH is changed

Colors for the chart of the propagation Prediction optimized. Colors can be selected and legend has the sam background as the chart

Added some fields to the window which displays the QSO qualifying for a statistic

Date validation added

and some other small fixes....

5.1ea 25.02.2005

Inconsistent selection of MyQTH, MyConds and Events fixed. Occurred with many entries in these tables

5.1e 20.02.2005

Automatically filled statistic values where not saved in the DB

Fixed the problem that some query expressions in statistics where not recognized

5.1d 12.02.2005

Fixed the following Problems:

automatic lookup in Infotable

Inconsistency in PQTH assignments fixed

QTH-Locator assignment in My_QTH

Dos Import for new Statistic Fields

5.1c 26.01.2005

Problem when migrating private statistics fixed !

Attention: All of You who had problems with the private statistics should fall back to the back-up copy of the database Swisslog made. In the ..\DB directory locate the file which ends with _BAK.MDB. This is the back-up copy. Rename the current to DB ..._S, then remove the _BAK from the name of the back-up copy. Now start Swisslog. Note that You have to reenter all QSOs You entered since the back-up copy was made.

5.1b 20.01.2005

Fixed some minor bugs

Copy Past should now work for all fields !

5.1a 17.01.2005

Minor changes:

Help Interface did not work for all topics

QSO Group for Print QSL Cards was not created for new Databases.

There are major changes of the database in this version:

The Information contained My - QTH (MyConds Table) have been split into 3 separate parts
1. Information about the own QTH (MyQTH)
2. Working Conditions (WCONDS)
3. Event Information (EVENTS)
This allows to combine these 3 parts in any combination for a QSO. With the old model You had to create a New MyQTH for each Event / Contest and for each set of working condition. Some station ended up with hundreds of MyQTH Records.

The split into 3 Parts helps to avoid this. You can define a MyQTH for each real QTH and define Working Condition record for each TX/Antenna combination. So for example if You have 3 QTHs and 3 Antennas at each QTH You need 3 QTH records and in maximum 9 working condition records. You end up with 12 Records opposed to 27 in the current release.

Splitting of the Event / Contest serves a similar purpose. There is no more need to create a MyQTH for each contest.
More Statistic fields have been added
With the introduction of the standard statistics we got short of statistic fields. Therefore I added 10 Diploma fields in the PQTH Table and 11 Special Fields in the Callbook table. This also introduced changes in the definitions of the standard statistics. All variable statistics could be converted to normal statistics.

Private Statistics which use the Fields Diplom_1 to Diplom_5 will be changed to use the Fields Diplom_11 to Diplom_15. The Statistics using the Fields Spezial_1 to Spezial_4 will be changed to use the fields Spezial_11 to Spezial_14.

By convention private statistics should use the fields with the numbers 11 to 15.
New Table which allows to set Please / Thank QSL based on the QSL Receive Status

I added a new Table QSLTEXT which contains a Text and a Please and Thanks mark for QSL Received and QSL not Received. These texts are used to automatically set Please / Thanks QSL on the QSL cards. I have adapted all QSL Examples. You find the under :

Reports\QSLCards\QSL Cards 51

Reports\QSL Labels 51

You can edit this text under Edit ¦ Edit QSL Pse/Tnx.

Version 5.09 01.10.2004

Corrections:

DX - Window scrolling with heavy traffic improved
New Menu Item in Option allows to set the Font of most Windows
IOTA are extracted from the comment of a DX Message. That means that the IOTA Statistic can be used in the DX Window
ICOM TX-Interface : Added new modes and try to restore correct filter settings -> needs testing !

Version 5.08 24.09.2004

Corrections:

In the DXCC window, when more then one DXCC is possible for a call the callbook is checked for the presence of a QSO which contains the correct DXCC
SQL was not correctly generated for QSO Groups when it contained or conditions For example : (QSLR = 1 or LotW_received = 1)
LOTW Displayed wrong date in error messages

Version 5.07 06.09.2004

Corrections:

Deleted indicator other than 'D' are recognized
Access violation when DX window was standalone corrected
Statistic values where incorrect in some situations
No QSOs displayed for variable statistics when clicking on a statistic cell

Version 5.06 26.08.2004

Corrections:

Trace in LOTW disabled
Statistic Migration clears now old values
Create new DB does only copy private Info Tables
Generate correct SQL when filtering on Function based fields like Year
Added direct link to Swisslog Homepage and to the Forum under the Help menu

Version 5.05 16.08.2004

Corrections:

LOTW QSL-since Date not coupled to QSO-since Date anymore
Import of Info-tables also works for text files which where not exported first
Telnet 10 private buttons are now possible

Version 5.04 10.08.2004

Corrections:

LOTW automatic synchronization improved / corrected.
LOTW SAT QSOs are now exported correctly
Function to Export and Import Information Tables from the SWLSTAT.MDB added
Customizable Button added to Telnet Window
Statistic-conflict resolution improved
Support for the Rotor OR2800PDC added
Paper selection for Printer changed. Paper selected in Printer Dialog overwrites the paper defined in the report

Version 5.03 27.07.2004

Corrections:

Migration of DB did not work on all systems
Connection to WinPR did not work. The Configuration of WinPR must be changed:
- In WinPR select 'Einstellungen ¦ DDE'
- On the DDE Screen change all occurrences of 'SWISSLOG' to 'SWISSLV5' see the on line Help
Rezising columns in DX Window works again
Quickinfo is OK again

Version 5.02 23.07.2004

Corrections:

QSLR / QSLS was not correctly initialized in QSO Entry window
Hamscope Interface improved
DXCC not recalculated when date was changed
DXCC not accepted when copied from info table
Variable Statistic Field values not initialized correctly when no value was found for QSO
SV2AGV connect Via corrected
QSO Entry Window did grow when refreshing DB Connection
LOTW QSOs with the time 00:00:00 not imported
LOTW new QSL where not imported
Now QSOs and QSL import is controlled separately. Additional Option for this purpose was added
Scan for ICOM TX Address did not always work

Version 5.01 15.07.2004

Corrections:

Invalid information displayed in the Diploma fields
Statistic Quick-View
- 'Not needed' color is no saved
- mixed mode QSOs are now displayed when double clicking on a cell
Second of the times are now exported into ADIF files. This is needed for LoTW.
The standard information table can now be updated
Import of QRG from ADIF did not always work

Version 5.0 25.06.2004

Some general Information

Version 5 of SWISSLOG establishes the foundation for several new features I plan to add in the future. The most important change in version 5 is the separation of 'static' information from the 'dynamic' (personal) information in the database. 'Static' Information includes things that are the same for all SWISSLOG users – such as statistic definitions and information tables. Dynamic information includes things that are specific to a particular station like your QSO's.

'Static' information is now stored in a separate database named SWLSTAT.MDB. The ‘STAT’ in the name stands for ‘static’, however it could also stand for 'statistic' because the new database contains all of the statistic definitions and the corresponding information tables. Which means, it is no longer necessary to define or import statistics, or load information tables. All the common statistics are now defined it the SWLSTAT.MDB. When the Information tables do change or when new Statistics are added, I will distribute a new version of the database, which will be available to everyone.

All of the Statistics defined in the Stat-DB are by default active – currently there are over 70 statistics. This means every time you enter a QSO, it is checked against all the active statistics to determine which statistics are applicable. This feature required a complete redesign for this part of SWISSLOG.

New Functions

See the Help for details

Version 5.0 does not contain all of the new functions initially planned. I underestimated the amount of effort required to implement the 'One Button LoTW Support'. LoTW is very complex and was not easy to implement! However, it is now fully functional and works well. Due to the extra time required for the LoTW functions, I was not able to finish the Award administration as planned – it will follow soon!

Watch the SWISSLOG homepage www.informatix.li for an announcement of new features.

Predefined Statistics

Statistics and information tables are now predefined in the SWLSTAT.MDB. The SWLSTAT.MDB will be replaced whenever new Statistics or updates for the Statistic tables are available.

A new user friendly dialog to select the Statistic views is available.

Note: You will have to reselect the statistics to be displayed in the Statistic-Quick Info and the DX Message windows.

Fully integrated LoTW Support

LoTW Support of SWISSLOG is fully integrated. Once setup, the synchronization of your log with LoTW is fully automatic.

Important Information for the Upgrade from previous Versions

SWISSLOG Version 5 works with a copy of your Log database

Because of the fundamental changes in the database, SWISSLOG creates a new copy of your log database. The new version 5 database has the same name as your current DB with '_V5' appended. So if your current database is named SWLOG.MDB the version 5 database will be called 'SWLOG_V5.MDB'.

QSO's that you add using SWISSLOG version 5 database will not be added to the previous database.

SWISSLOG Version 5 can be used in parallel with older version

SWISSLOG Version 5 is installed in the current SWISSLOG directory. The program name was changed to SWISSLV5.EXE. Therefore it can be used at the same time as the previous version.

Statistic Selections in the Statistic-Quick-Info and the DX-Message windows have been changed

The ID's of the Statistics changed because they are defined in the SWLSTAT.MDB. That means, the statistic lists stored in the previous .ini files are no longer valid. Therefore, you need to reselect the Statistics you want displayed the first time you run SWISSLOG.

Statistic Field conflicts.

The fields used in private- and standard. statistic may conflict. Please read Resolve Statistic Field Conflicts