Version 5 Neuigkeiten und Historie 


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 (Dankeschön an Pascal HB9IIB und 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

 Diese Seite dokumentiert kurz die Änderungen und neue Funktionen, die zu den verschiedenen Versionen hinzugefügt wurden.

Version  5.96 25.03.2017

Diese Version enthält die folgenden Korrekturen und Verbesserungen:

Version  5.95 17.01.2017

Diese Version enthält die folgenden Korrekturen und Verbesserungen:

Version  5.94 16.12.2016

Diese Version enthält die folgenden Korrekturen und Verbesserungen:

Version  5.93 22.07.2016

Diese Version enthält die folgenden Korrekturen und Verbesserungen:  

Wähle "Unabhängiges Fenster" aus dem Pop up Menü oder dem Funktionen Hauptmenü.

Bei Benutzung dieser Modes muss der Nutzer manuell einen entsprechenden Mode in Swisslog wählen oder einen Mode neu hinzufügen in Bearbeiten | Mode addieren / ändern.

Version  5.92 20.04.2016

Diese Version enthält die folgenden Korrekturen und Verbesserungen:  

Version  5.91a 11.01.2016

Diese Version enthält die folgenden Korrekturen und Verbesserungen:   

Version  5.91 03.12.2015

Diese Version enthält die folgenden Korrekturen und Verbesserungen:

Hinzugefügte neue Statistiken: EPC, DMC, BDM and NDG.

Wenn eine dieser Optionen ausgeführt wird lädt Swisslog eine upgedatete Liste aller Mitglieder/Referenzen von der offiziellen Webseite und importiert diese in die korrespondierenden Informationstabellen. Abhängig von der Anzahl der Mitglieder/Referenzen der gewählten Option kann dies einige Zeit dauern. Ein Fortschrittsbalken wird angezeigt.
WICHTIG: Du benötigst eine Internetverbindung für diese Operationen! Es gibt auch eine Option "Update ALL" welche alle Optionen ausführt. Denke daran dass es abhängig von Deinem PC und der Internetverbindung lange dauern kann, alles upzudaten! Als Beispiel: Mit einem Core 2 Quad Computer und 5Mb ADSL dauert es etwa 13 min um alles upzudaten. Es wird empfohlen diese Option zu nutzen wenn Du Deinen PC nicht für andere Aufgaben verwendest um Swisslog zu erlauben allein zu arbeiten. Es ist jetzt ncht mehr notwendig auf eine upgedatete Version von Swisslog zu warten um diese Statistiken upzudaten. In zukünftigen Versionen werde ich alle Diplome implementieren, deren Refernzen sich oft oder von Zeit zu Zeit ändern. Nicht alle Diplommanager machen geignete Referenz-/Mitgliederlisten im Internet verfügbar. Manche Diplommanager veröffentlichen Listen in komplizierten Formaten welche die automatische Datenextraktion erschweren (z.B. PDF Format). Spezielle Werkzeuge und Handarbeit sind notwendig um die Daten aus solchen Formaten zu extrahieren. In diesen Fällen werde ich das Format manuell anpassen sodass Swisslog das angepasste Format vom Swisslog Server anstelle von der offiziellen Webseite herunterladen kann. Beim Programmstart wird Swisslog eine Meldung anzeigen welche darüber informiert welche Tabellen ein Update benötigen und anzeigt, wieviel Tage seit dem letzten Update vergangen sind. Die Warnzeit habe ich für LoTW/eQSL Nutzer auf 30 Tage, für Diplome auf 60 Tage und für Clubmitgliedschaften auf 180 Tage gesetzt. Nachdem die Meldung angezeigt worden ist wird Dich Swisslog fragen, ob Du updaten möchtest.
LoTW bietet nicht die Möglichkeit, eine offizielle Liste herunterzuladen. Die LoTW Nutzer Liste wird von "hb9bza.net/lotw-user-list" heruntergeladen, welche die bedeutendste und aktuellste LoTW Nutzer Liste weltweit ist und von vielen DX-Clustern und Softwareentwicklern genutzt wird. Das LOTW USERS SQL Skript (welches schneller läuft als bisher) wurde angepasst um "LOTW" in das QSL Aktion Feld aller Deiner gespeicherten QSOs mit LoTW Nutzern, für die Du keine QSL-Karte erhalten hast, zu setzen.

Version  5.9d 16.07.2015

Diese Version enthält die folgenden Korrekturen/Verbesserungen:

Version  5.9c 06.05.2015

Diese Version enthält die folgenden Korrekturen/Verbesserungen:

Version  5.9b 01.04.2015

Diese Version enthält die folgenden Korrekturen/Verbesserungen:

QSO Zeit in Swisslog gespeichert: 14:11:59

QSO Zeit hochgeladen zu LOTW: 14:11

QSO Zeit runtergeladen von LOTW: 14:11:00

 

Wie von Walter programmiert, erlaubte Swisslog eine Differenz von 59 Sekunden vor und zurück beim Abgleich von LOTW QSOs und Swisslog QSOs. Im obigen Beispiel suchte Swisslog von 14:10:01 bis 14:11:59 (59 s vor und zurück von 14:11). Theoretisch sollte dies funktionieren, weil 14:11:59 das Ende der Suchroutine darstellt. Aber in den meisten Fällen wurde das QSO nicht gefunden, da Abweichungen von Millisekunden vorhanden waren. Mathematik ist eine exakte Wissenschaft! Millisekunden werden nicht angezeigt, aber gespeichert im Swisslog Zeit Feld, wenn in Echtzeit geloggt wird. Um das Problem zu vermeiden, habe ich die zulässige Zeitdifferenz auf 60 Sekunden erhöht. Ich habe auch die Routine korrigiert, wenn Swisslog zwischen 23:59 und 00:01 suchen muss, was etwas komplizierter ist, da 2 verschiedene Datumsangaben beteiligt sind. Ich hoffe, dass die LOTW-Synchronisation  nun "nahezu" 100 % fehlerfrei ist.

Version  5.9a 12.02.2015

Diese Version enthält die folgenden Korrekturen/Verbesserungen:

Version  5.9 25.12.2014

Diese Version enthält folgende Korrekturen/Erweiterungen:

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

Version  5.8 14.02.2010

This version corrects the sincronizing issue with LoTw (Logbook of the World)

Version  5.7 04.01.2010

This version has no enhacement. 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