Version 5 News and History


Version 5.96 25.03.2017

Version 5.95 17.01.2017

Version 5.94 16.12.2016

Version 5.93 22.07.2016

Version 5.92 20.04.2016

Version 5.91a 11.01.2016

Version 5.91 03.12.2015

Version 5.9d 16.07.2015

Version 5.9c 06.05.2015

Version 5.9b 01.04.2015

Version 5.9a 12.02.2015

Version 5.9 25.12.2014

Version 5.8 14.02.2010

Version 5.7 04.01.2010

Version 5.6b 09.10.2009

Version 5.6 10.06.2009

Version 5.5 15.04.2009

Version 5.4 27.11.2008

Version 5.2  24.06.2005

5.2 Ecb  15.10.2007 (thank you to Pascal HB9IIB and Christian HB9DBC)

5.2 Eca  19.04.2006

5.2 Ec  13.04.2006

5.2 EA  03.04.2006

5.2 Dc  13.06.2006

5.2 Db  28.02.2006

5.2 Ck  27.12.2005

5.2 Ch  24.11.2005  

5.2Cc  27.09.2005

5.2 c  07.07.2005

5.2 b  26.06.2005

Version 5.1  10.01.2005

Version 5.09 01.10.2004

Version 5.08 24.09.2004

Version 5.07 06.09.2004

Version 5.06 26.08.2004

Version 5.05 16.08.2004

Version 5.04 10.08.2004

Version 5.03 27.07.2004

Version 5.02 23.07.2004

Version 5.01 15.07.2004

Version 5.0   25.06.2004

 This page briefly documents Changes and New Functions added to the various releases.

Version  5.96 25.03.2017

This version includes the following corrections/enhancements:

Version  5.95 17.01.2017

This version includes the following corrections/enhancements:

Version  5.94 16.12.2016

This version includes the following corrections/enhancements:

Version  5.93 22.07.2016

This version includes the following corrections/enhancements:  

Select "Standalone Window" from the popup menu or the Functions main menu.

If using any of these modes user will have to manually select any similar QSO mode in Swisslog or add them in Edit | Add / Edit modes.

Version  5.92 20.04.2016

This version includes the following corrections/enhancements:   

IMPORTANT: It's necessary to review ALL callsigns in the Callbook table for wrong DXCC allocations. Otherwise you will get unexpected DXCC sorting order when printing QSL cards, labels, etc. Correcting DXCC in the whole Callbook table will take long time depending the number of callsigns entered in your logbook. At first startup of this version Swisslog will show you a message indicating an estimated process time to perform this operation depending the number of callsigns in your logbook. User may choose to do it then automatically or do it manually later in TOOLS - FOR EXPERTS ONLY - SET DXCC IN CALLBOOK. If NO is chosen, PLEASE don't forget to do it later to leave your logbook in mint conditions.

Version  5.91a 11.01.2016

This version includes the following corrections/enhancements:   

Version  5.91 03.12.2015

This version includes the following corrections/enhancements:   

Also added new statistics: EPC, DMC, BDM and NDG.

When executing one of these options Swisslog will download an updated list of all members/references from the official website and will import them into the corresponding info tables. Depending the number of members/references of the selected option it may take some time to be performed. A progress bar is displayed.

IMPORTANT: you need internet connection to perform these operations! In order to update the AGCW, DCE, DEE, DERESP and HSC tables Microsoft Excel must be installed in your computer. Otherwise you won't be able to update these info tables.

Also included an option to "Update ALL" which run all options. Keep in mind that depending your computer speed and internet connection it may take long time to update everything! As an example: In a Core 2 Quad computer and 5Mb ADSL connection it takes about 13 minutes to update all. It's recommended to use this option when you are not using your computer to allow Swisslog working alone. Now there is no need to wait for an updated version of Swisslog to get all these statistics updated! In future versions I will be implementing all awards whose references changes often or from time to time.

Not all award managers make available on internet a suitable list of references / members. Some award managers are publishing listings in complicated formats difficulting automatic data extraction (i.e. PDF format). Special tools and manual work are needed to extract data in such formats. In that cases I will adapt the format manually so that Swisslog can download the adapted format from the Swisslog server instead of the official website.

At startup, Swisslog will display a message informing which tables need update indicating the number of days since your last update. I have set a warning time period of 30 days for LOTW/eQSL members list, 60 days for awards and 180 days for club memberships. Swisslog will prompt you if you want to update just after the message is displayed.

LOTW doesn't offer the possibility to download any official list. However the LOTW user list is downloaded from "hb9bza.net/lotw-users-list" which is the most important and updated LOTW user lists world wide, used by many DX clusters and software developers. Also adapted the LOTW USERS SQL script (which runs faster than before) to set 'LOTW' in the QSL action field in all your previously saved QSO with LOTW users where you have not received a QSL card.

Version  5.9d 16.07.2015

This version includes the following corrections/enhancements:  

Version  5.9c 06.05.2015

This version includes the following corrections/enhancements:

Version  5.9b 01.04.2015

This version includes the following corrections/enhancements:

Version  5.9a 12.02.2015

This version includes the following corrections/enhancements:

Version  5.9 25.12.2014

This version includes the following corrections/enhancements:

Statistic table - Changes and news

The statistic table contains the following changes: 

ADDED:

IMPORTANT: You MUST run a SQL script to clean the contents of the Special field. ONLY ONCE AND BEFORE entering any WFF references. This has to be performed, specially those users from the DOS version, because the SP field may contain obsolete data currently.

To run the script perform the following steps:

1. Start SWISSLOG
2. Open Tools | For experts only | Run SQL Script
3. Select the file "Clean Special field.sql" which is found in the SCRIPTS folder (is located as a sub-folder where Swisslog is installed) and press OK to all confirmation messages.

UPDATED:  AGCW, ARLHS, DCFP, DEE, DEFE, DFCF, DIE, DIEI, DIP, DME, DMF,  DMVEA, DMVE, DVGE, FEA, FOC, HSC, IOTA,  IOSA, JCC, JIIA, Puentes y Acueductos de España, RDA, RRA, RTC, SP POWIAT, USI,  WAE, WCA y  WAP-WADA  IMPORTANT: See RDA section below!!! There have been important changes that need user action!!

RENAMED:

DELETED:

If you have a personal statistic defined in any of fields of the new added statistics there could be a conflict depending on the statistic definition. If you have problems don't hesitate to contact me by mail and I will move your personal statistic data into another free field: ea3gcv@castelldefels.net 

 

NOTE: If you are an advanced user and you have modified or customized standard statistics please keep in mind that the SWLSTAT.MDB file will be replaced!!! But don't be afraid, the installer will make a backup of your current SWLSTAT.MDB in the Backup folder located where Swisslog is installed.

 

If you have created other statistics that could be interesting for other users, please send me the definition files and I will try to implement it in the next version.

SQL Scripts

Swisslog has a very powerful function to run SQL Scripts which allows the execution of complicated queries to modify fields or move data from one field into another. In this way we avoid using complicated operations in the logbook view. Though, SQL scripts are executed in seconds and can perform complex operations that can't be done with the available functions provided by Swisslog.

I have created some scripts which you may find them very useful. I'm not a SQL expert at all but with help of my knowledge in Access and a special view to see the SQL code created in queries I could create it with success.

This version installs them in the SCRIPTS folder which is located as a sub-folder where Swisslog is installed.

DXCC - WAE Corrections

NOTE: In version 5.9 this script is executed automatically in invisible mode at first Swisslog startup, so there is no need to execute it again manually. It's only explained so that users know what this script performs.

Up to now every time the prefix allocation table of certain entities was changed, a very complicated manual operations should be performed to adapt your QSO to the new situation. Thanks to the powerful SQL script function this operation can be now automatically made in just seconds!

I have created a script which automatically adapt the prefix allocations previously explained by Hardy, DL5SBA (SK) (Montenegro, Cook Islands, Bosnia Herzegowina, Juan de Nova and Europe, Glorious, Tromelin, South Sudan as well as other changes) safely, automatically and in just seconds!!. In this way we avoid using the manual procedures explained up to now which could cause errors by the user. Best of all is that even if you previously performed the manual operations, you can now run this script without any problem! If all the operations were done well nothing will be changed. Otherwise the script will correct it!

To run the script perform the following steps:

1. Start SWISSLOG
2. Open Tools | For experts only | Run SQL Script
3. Select the file "DXCC-WAE Corrections" which is found in the SCRIPTS folder (is located as a sub-folder where Swisslog is installed) and press OK to all confirmation messages.

This script perform the following changes:

Castles Awards

Users who likes castles awards (home awards and WCA) will like a lot this couple of scripts. When you are working a station operating from a castle you will enter the home award or WCA reference in the corresponding field. Main problem is that home and WCA references are completely different! If you want to handle all castle awards you would have to check the cross-reference and enter them manually in each QSO!!! a real hard work!!! However, these scripts will perform the operation in a second! I have created these scripts:

Can't be easiest!! Choose the method you prefer. Whether you prefer to continue entering home references or WCA references it's up to you. Depending your decision simply run the corresponding script from time to time to keep all the castle awards updated! And no matter if you sometimes enter the WCA reference and sometimes the home reference. Run both scripts from time to time and you will still have your castle statistics correctly updated!

To run the scripts perform the following steps:

1. Start SWISSLOG
2. Open Tools | For experts only | Run SQL Script
3. Select the file "Home Castles to WCA.sql" or "WCA to Home Castles.sql" which are found in the SCRIPTS folder (is located as a sub-folder where Swisslog is installed) and press OK to all confirmation messages.


How to avoid sending a QSL via bureau to those QSO partners with no bureau service


This script selects all QSO with entities with no bureau service (having the QSL Manager field empty) and sets "Direct" in the QSL-Action field. If a QSO contains a QSL Manager, because the QSL could be sent via bureau to the manager, it's out of the script selection.

To run the script perform the following steps:

1. Start SWISSLOG
2. Open Tools | For experts only | Run SQL Script
3. Select the file "Set Direct in QSO without bureau.sql" which is found in the SCRIPTS folder (is located as a sub-folder where Swisslog is installed) and press OK to all confirmation messages.

If you want to change "Direct" by another word simply edit this file with a text editor (Notepad for example) and change "Direct" in the first line of code (is marked boldface in the code below):

UPDATE PQTH INNER JOIN LOGBOOK ON PQTH.P_CALLID = LOGBOOK.L_CALLID SET LOGBOOK.L_QSL_ACTION = "Direct"
WHERE (((PQTH.P_DXCC)="3B8" Or (PQTH.P_DXCC)="3C1" Or (PQTH.P_DXCC)="3DA" Or (PQTH.P_DXCC)="4J" Or (PQTH.P_DXCC)="4W6" Or (PQTH.P_DXCC)="5A" Or ......

Russian District Award (RDA)

This award is valid for QSOs since 12 June 1991. Swisslog was defined to count QSOs since 13 June 1991 so this error has been now corrected. Please check your QSO worked on 12 June 1991 with European Russia (UAEU), Asiatic Russia (UAAS), Kaliningrad (UA2), Malyj Vysotskij (R1MV) and Franz Josef Land (R1FJ) and assign the correct district.

 

The new list (valid since 1 March 2010) reflects the union of Chitinskaya oblast (CT) and Aginsko Buryatsky Autonomous Okrug (AB) into the Zabajkal`sky Kraj. They have changed the 2 letter short name of the region to ZK Zabajkal`skiy Kraj. All QSOs with regions CT and AB will count for ZK automatically (for all dates from June 1991). There are exceptions depending on the different situations of union and deletion of districts.

There have been district name changes, completely new districts, deleted districts and automatic replacement of districts. See official note HERE.

 

NOTE: There have been new RDA districts, created out of already existing districts in connection with separation in 2 separate administrative districts. Let's take a simple example:
Till 01.03.2010 existed the district AL-36 Loktevsky area /incl. Gornyak/. After 01.03.2010 a separation of the Loktevsky area and the city Gornyak took part, the RDA number AL-36 stayed with Loktevsky area while the city Gornyak received the number AL-74. All contacts till 01.03.2010 are valid for AL-36 no matter from where they took place (from the area or the city), after that date all QSOs with the area are valid for AL-36 and all QSOs with the city are valid for AL-74, so AL-74 is valid only after 01.03.2010. There may be given out RDA number which earlier existed.

Separated districts (7):

Till 01.03.2010    OLD    NEW
AL-36 ->           AL-36   AL-74
BR-31 ->          BR-31   BR-36
IR-17 ->            IR-17    IR-47
IV-14 ->            IV-14    IV-31
KM-02 ->         KM-02   KM-15
NO-01 ->         NO-01   NO-02
SV-59 ->         SV-59    SV-76


To avoid manual procedures to edit all these QSOs I have created an SQL Script that automatically performs all these changes.

 

Please perform the following steps:

1. Start SWISSLOG
2. Open Tools | For experts only | Run SQL Script
3. Select the file "Fix RDA.sql" which is found in the SCRIPTS folder (is located as a sub-folder where Swisslog is installed) and press OK to all confirmation messages.

 

NOTE: Due to the amount of checkings and/or data changes the Script may handle, this operation may take some time. It depends on your computer speed and the number of QSOs in your database. NO PROGRESSION BAR is displayed! You must wait until a message is displayed showing that the scripts has been successfully executed.

Version  5.8 14.02.2010

This version corrects the synchronizing issue with LoTW (Logbook of the World)

Version  5.7 04.01.2010

This version has no enhancement. Just changed version number because there is only a single installer package in English, but I still recommend to install full 5.2 version and apply the updater

Version  5.6b 09.10.2009

This version implements XML support for the online access to QRZ.COM.

Go to Options | CD-Callbook and type in the URL field:
 
http://www.qrz.com/xml?username=xxxxxxx;password=xxxxxxxx
 
Replace the xxxxx for your username and password of your QRZ account. Obviously you have to register first to QRZ.COM

Version  5.5 15.04.2009

Swisslog is public domain now (free) as desired by Walter, HB9BJS

This version corrects (again) the problem with QRZ.COM...

Version  5.4 27.11.2008

Version  5.2 24.06.2005

SWISSLOG Version 5.2 contains 

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

The following standard functions have been changed:

New Functions:

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

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.

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 Cc  27.09.2005

5.2 Ca  05.09.2005

5.2 c  07.07.2005

 

5.2 b  26.06.2005

Contains fixes for small problems discovered during the Hamradio fair

5.2 a  24.06.2005

 

Version  5.1 10.01.2005

5.1h  21.05.2005

5.1g  18.04.2005

5.1f  03.04.2005

5.1ea 25.02.2005

5.1e 20.02.2005

5.1d 12.02.2005

5.1c 26.01.2005

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

5.1a 17.01.2005

Minor changes:

There are major changes of the database in this version:

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 :

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

 

 

Version 5.09  01.10.2004

Corrections:

 

Version 5.08 24.09.2004

Corrections:

 

Version 5.07 06.09.2004

Corrections:

 

Version 5.06 26.08.2004

Corrections:

Version 5.05 16.08.2004

Corrections:

Version 5.04 10.08.2004

Corrections:

Version 5.03 27.07.2004

Corrections:

Version 5.02 23.07.2004

Corrections:

Version 5.01 15.07.2004

Corrections:

 

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.swisslogforwindows.com 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

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

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.

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


Copyright © 2004 SWISSLOG
Last modified: 25 mar. 2017