Polski Związek Krótkofalowców

 

Polski Klub Radiovideografii

Navigation:  AWARD_SECRETARY project and its purpose >

Download project AWARD_SECRETARY and version history

Print this Topic Previous page come-back to begin of chapter Next page
Expand all elements   Callapse all elements

 

To install the project AWARD_SECRETARY you should download two files:

1.File for install MYSQL database MYSQL_INSTAL.ZIP
2.File to install AWARD_SECRETARY_INSTAL.ZIP

 

Files can download by clicking on the following Buttons.

 

MYSQL database installation is described in the section - click. I offer users remote installation of MYSQL database

with using TeamViewer, which can be downloaded from my website

http://sp9auv.com/index.html?teamviewer_wersja_7_0_12799_pomoc_zdalna_zdalne_sterowanie.php

 

Downloading AWARD_SECRETAY_INSTAL_WITH_MYSQL.ZIP

in the last version as describing bellow

Button

File was download

4427

times

 

Customers who have downloaded this program are invited to enter the form below. although this is not a necing bellow essary condition to download the program ..

 

Prosze podac swój znak - oraz prawidłowy e-mail :

Please enter you callsign and correct e-mail :

callsign:
e_mail:

 

I would simply like to know if my job is useful to someone. Such persons will be notified whenever new version of the program. . If you have any questions, you can type your comments or questions to my fudforum

http://sp9auv.com/fudforum/

 

Version history for the program AWARD_SECRETARY.EXE

AWARD_SECRETARY.EXE  version 4.1.0 at  22.12.2023 year

The following changes have been made in this version:

- In this version, the need to obtain a license file is eliminated and everyone can perform calculations for all 30 diplomas and 8 special queries, as well as use diplomas that will be developed in the future.

- The installer interface has changed to reflect these new features.

- Fixed an error that occurred when examining a long string sent and received after my provider updated the PHP software version.

- The AWARD-SECRETARY.exe and AWARD-SECRETARY_PL.chm programs have been improved according to these new possibilities.

 

AWARD_SECRETARY.EXE  version 4.0.2 at  05.08.2022 year

The following changes have been made to this release

The search for a version smaller than 4.0.1 was abandoned because the search time on single-partition disks with a 500 GB partition was up to 15 minutes. Instead, the user is asked if he has a version lower than 4.0.1 and if he has a version lower than 4.0.1 installed, he must manually indicate the directory where this version is.

AWARD_SECRETARY.EXE  version 4.0.1 at  30.06.2022 year

The following changes have been made to this release:

It's been two years since the previous version 3.0.3 was developed and I made a lot of changes
First of all, the program is much less restrictive when it comes to licensing conditions and practically the full version is available for every ham radio without paying any fees - completely free. You just need to write me an e-mail to sp9auv@wp.pl  and provide the main sign of the station for which you have obtained or intend to obtain the ARRL certificate. You will receive a license file back, which you just copy to the main AWARD_SECRETARY directory
In fact, you can install and run the program without an Internet connection - although then you will be deprived of the valuable property of checking data on CLUBLOG
At the moment, the program can do calculations for  30 awards, including 18 DXCC awards and 12 WAZ and WAC awards or others, and for 8 special inquiries, eg - tell me how long I wait for confirmation with QSL cards.
The issue of duplicate QSOs has been cleared. The problem is that the emission symbol is not treated unequivocally and the same over time by logging programs. Ie. Logger 32 used to use PSK31 and PSK63 symbols as emission symbols.
The program AWARD_SECRETARY as a symbol that uniquely identifies the QSO also uses the emission symbol (MODE). . Now PSK31 and PSK63 emission are converted to PSK when reading ADIF data and in various other situations. . Changing the emission to PSK is also done for the CRC field - so that there will be no duplicate QSOs.
For DXCC awards, they will be combined into a DIGITAL mode.
Introduced and improved the method of numbering QSL cards with a sticker on the card in the logger when selecting and with QSL the QS card has been received, which greatly speeds up the process of looking for cards when submitting a awards . Currently, you can only use the DXCC country sort method for QSL numbering.
The synchronization of QSOs data from the logger adif with data entered into the MYSQL table was also taken care of - because it was found that some loggers increase the TIME_ON parameter by 1 sec after some time, which means that the program may malfunction in the future and give a false result. TIME_ON is a critical data because it is included in the so-called QSO index.
Currently, it is possible to submit multiple diplomas in one application. This is done in the so-called In the 1st application form, the method of uploading ON-LINE to the ARRL website of the appropriately produced application file. The application file may contain any number of awards. It is also possible to include supplements in such application - endorsement
A possibility has also been introduced that when submitting supplements to diplomas (endorsement), you can also include new diplomas, the so-called first application for diplomas that met the requirements.
Corrections related to the DATE_GRANTED date used after the award is approved by ARRL. Now this date can also be entered in combined diplomas - merged, and this date will be entered in all component diplomas
A new browser program has been developed to work with CLUBLOG.Browser_chrome3.exe. . The previous program, Browser_chrome.exe, stopped working in the new Windows environment.
The program can work with CLUBLOG. Then the comparison of the data downloaded from the ADIF file from the logger and the data calculated on the CLUBLOG website takes place. After the data comparison, the data can be improved to the MYSQL DIFFERENCE_LOGGER_CLUBLOG table and to  QSO_AWARDS
It is possible to change all QSOs automatically or manually sign by sign. I recommend using this option when working with CLUBLOG. Regardless of the automatic selection, it is possible to select a single QSO according to the data from the Logger. It is then good to make these changes to the logger as well.

 

AWARD_SECRETARY.EXE  version 3.0.3 at  17.07.2020 year

In this version, I do the following changes

Was do changes for CTY.XML file for CLUBLOG .

AWARD_SECRETARY.EXE  version 3.0.2 at  04.06.2018 year

In this version, I do the following changes

the INTERFACE NOT SUPPORTED error has been removed as a result of the changes made to the site addresses for CLUBLOG, because  AWARD_SECRETARY also works with CLUBLOG.

AWARD_SECRETARY.EXE  version 3.0.1 at  06.10.2016 year

- In this version, I do the following many changes and improvements, so that this version significantly improves the process of execution of the application and search QSL

introduced a mechanism for numbering QSL cards received in the form of small labels glued on the received QSL cards, which greatly accelerates the process of finding and preparing QSL cards for notified applications. This is described here
made merge of several diplomas or endorsement in a notification application. Description see here
program watches which is suitable for 1st filing applications in the merger diplomas and what is suitable to create a supplement endorsement in one application
for merged awards or endorsement I  developed a new form for printing  awards  ARRL.
Described in detail the method of reporting ON_LINE  applications ARRL including showing how to load a file .adif and where you fill data about your account details for payment . File  adif for the cheapest method ON_LINE produces AWARD_SECRETARY. Description see here.
field CONFIRM_CONDITION_AWARD was added to the table  ARRL_AWARDS_SUMMARY that can better recognize that awards  fulfills the conditions
.modules .dll was added to the ARRL awards  for all bands  besided the 2 M.
eliminated mistake which he appeared once a day - when run the program. This was due to the lack of a reset variable r.
the modifications was made to in the module DXCC_Lst.dll, because he do error for duplicate station  DXCC = 0
due to changes in the CLUBLOG consisting in this that it accepted TIME_OFF as TIME_ON I developed a special procedure which translates file adif uploaded to the  CLUBLOG so that TIME_OFF = TIME_ON which prevents changes  this value by CLUBLOG, otherwise change TIME_ON was  caused create a new QSO - even when TIME_OFF differ by 1 sec
I developed procedure to update the structure of all tables wards , and add a new field NO_QSL_CARD, also for awards  already calculated
in the first bookmark  for importing data adi has been removed truly continuous reset windows , what allow  import  data and use the vertical slider to see  what was  performed operations. In this window is printed now more information at startup and especially as the prosecution proceeded downloading data from Polish servers.
Introduced in AWARD_SECRETARY and in the installation program recognize whether the program is running in Windows 10 upgraded from  version 7 or 8, making it possible to adapt the program in the new environment.
for MYSQL_INSTALL_AUTOMATIC_ALL_COMPONENT_AND_CONFIGURE_IT.exe in  version 1.1.0 Improved interface so that better shows and describes the problems that may arise when installing MYSQL database on Windows 10.

AWARD_SECRETARY.EXE  version 2.1.0 at  03.03.2016 year

- In this version I do the following changes and   improvements

Entering file Config_for_needed_Name_server_.txt in this is present the new address page for a list of DXCC official

               http://www.arrl.org/files/file/DXCC/dxcclist_mar_2016.txt

also changed DXCC_NO in a module DXCC_lst.dll in this way , when do upgrade does not make an error in the field DXCC_NO what can be  not proper  Now DXCC_NO = DXCC always
Fixed many patterns of fields for Regular Expression. so now there is less critical  and ordinary bugs
Because in th previous versions of the program may be situations that a session connecting to a remote server has been initiated by the server, and that really does not like firewalls or routers, causing blocking of packets. In this version uses new components in which the connecting session is initiated by the client program, ie in this case install_upgrade_AWARD.exe or AWARD_SECRETARY.exe or UNIINSTAL.exe
Changed components for use with web sites. Before you start cooperation with a remote server, it is tested whether the transmission is correct, and if it is incorrect, it indicated are the reasons that may arise as a result of misalignment of the  firewall or hardware router, resulting in blocking transmission .
The program features a procedure if  a long string sent is the same  with the received, indicating the reason for the wrong firewall settings or router that is blocking  packages
Replaced those encountered symbols bands occurring in some files, such .adif  40m to 40M, ie for compatible with standard adif

AWARD_SECRETARY.EXE  version 2.0.3 at  25.01.2016 year

- In this version I do the following changes and   improvements

Was produced a new file of help taking into account the amendments. especially for validation ADIF fields with Regular Expression pattern
Was corrected program Browser_chrome.exe so that was transfer to him the path and name of the selected file of Adif, which enabled self-closing some windows of the browser, thus preventing the user to select a different file ..

AWARD_SECRETARY.EXE  version 2.0.2 at  03.01.2016 year

- In this version I do the following changes and   improvements

Liquidated error that appeared when you try to uploading  file ADIF to page CLUBLOG. It was caused by changes in the concept of checking the data and changes in the latest version
changed in  a program MYSQL_INSTALL_AUTOMATIC_ALL_COMPONENT_AND_CONFIGURE_IT.exe start from the  version 1.0.1 software for the automatic installation of MYSQL database

AWARD_SECRETARY.EXE  version 2.0.1.1 at  22.12.2015 year

- In this version I do the following changes and   improvements

In this version it is possible to run the program in different national environments. The message about the need to set up the date of the short and long in the Control Panel - Regional Options does not appear, because AWARD_SECRETARY is designed to work in different national environments. An issue with a different date format used in various countries - due to the use of the program in different countries. CTY.XML file download from CLUBLOG uses the following format of the dates in his file  of XML.

<adif>23</adif>

       <name>BLENHEIM REEF</name>

       <prefix>1B</prefix>

       <deleted>TRUE</deleted>

       <cqz>39</cqz>

       <cont>AF</cont>

       <long>72.00</long>

       <lat>-7.00</lat>

       <start>1967-05-04T00:00:00+00:00</start>

       <end>1975-06-30T23:59:59+00:00</end>

And so there is used format yyyy-MM-dd .For different countries are used completely different standards, eg. for Britain dd/MM/yyyy.

For the USA, it is used standard M/d /yy. Here it is mentioned the so-called standard short date. Besides, there is still the notion of the so-called standard long date .This was resulted in  that the program behaved unexpectedly in different national environments. For not  to change the type of date in the settings of Windows, the program AWARD_SECRETARY uses its own format for a date that does not conflict with other programs that use Windows based set date. The program AWARD_SECRETARY must make  many operations on dates of DATE_QSO , since DXCC country is determined not only by the prefix stations, but also on the basis of the date of the QSO. Also, cooperation with CLUBLOG is made using date. So the program will work properly in different countries

IN_POLSKA.dll module is now available for all in  a global license

AWARD_SECRETARY.EXE  version 2.0.1 at  04.12.2015 year

- In this version I do the following changes and   improvements :

In  the module IN_POLSKA.DLL designed for Polish station , you can  choose todisplasy QSOs  as :  only QSOs confirmed or all QSOs. As confirmed they are treated QSO confirmed by the following methods
QSL
LOTW
E_QSL
QSO made in contest PGA

It makes no sense to download data for a QSO not confirmed yet, because there is no way to verify the correctness with the QSL, downloaded QTH from  QRZ 's

The only exception is the case when you want to select a range of QSOs as made in the contest PGA. , which allows in the module IN_POLSKA.dll. Then select a range of QSOs as made in the contest PGA , save data , and after the new select Only QSOs confirmed, this QSO in the contest will also be shown

 

In the module IN_POLSKA.DLL is possible download  QTH for all Polish stations, but unfortunately QRZ's not always give QTH properly. For example, for SP5GIIJ/6 QRZ.COM deleted characters after the broken / and gives QTH for SP5GIJ, which is definitely not correct .Therefore in this module including automatic selection of QSOs for the download of data is done only for  callsign full, not broken by the character /. It is only  possible selecting one single QSO , download and see QTH . If, however, you see that it QTH is not correct  - you should erase QTH by double clicking on the QTH and DELETE
Introduced now for the majority of awards  restored from the startup file that , if you do not have field MODE and CONFIRM_METHOD restore this values from the main file  of QSOs  QSOS_AWARDS

 

AWARD_SECRETARY.EXE  version 2.0.0 at  28.11.2015 year

 

- In this version I do the following changes and   improvements :

Now every field in the imported file. adi is verified using a special programming technology RegEx Regular Expression based on the so-called. pattern for field , .  This technology is new for Windows programming technology and provides a high possibility of finding errors . This errors are found :  Faults ordinary and so-called critical errors which may cause  stop working the program or give erroneous results. In the event of critical errors further work program is stoped. Correction error you must do in the logger and again produce .adi  file . Some errors can be corrected  as is possible will be corrected automatically
Due to this technology for check fields screens look a little different , especially if you choose cooperation with CLUBLOG. For now help chm does not yet include a description of these new screens.
To perform functions related to the RegEx Regular Expression is designed dll module - pcrelib.dll placed in the installation directory. As a result of its operation may appear  a single screen when you start AWARD_SECRETARY with message that was changed so-called date type long and short 
Reducing height of screens in bookmarks , so that now each display is located on a 15 inch monitor (that is 768 pixels vertically)
Improved the installation program install_upgrade_AWARD.exe, so that it behaves better when installing
Improved module IN_POLSKA.dll, used to produce data for Polish awards based only on the station sign.
Improved also way to check the logging to up to 4 servers personal information for Polish station.
Improved also a reproduction method start state award for people who already have a a award and have a file for this award  in any format .. Reduced the number fields that are needed to restore the state startup if you can restore some fields from the main QSOs MYSQL file

AWARD_SECRETARY.EXE  version 1.1.8.0 at  08.10.2015 year

- In this version I do the following changes and   improvements :

for installing a database more easily I was developed a special program for automated installation  database MYSQL .MYSQL_INSTALL_AUTOMATIC_ALL_COMPONENT_AND_CONFIGURE_IT.exe , so that the installation is very simple and does not require any data from keyboard or familiarization with the  Help. The program installs a database and immediately configures it for the needs for AWARD_SECRETARY without the need for asking anybody from  the user These parameters for install and configuration parameters are collected in  the initiatal  file  setup.ini. The program can also serve for professionals purpose to provide users  easy tool for install  database MySQL ( " also by Mrs. Sophie from  the accounting departments " ) Professionals person will find there also the source of this program in Delphi. You need only must  respectively edit the setup.ini . But ham- radio  should not, however, absolutely edit this file . Description of the installation is included here
In connection with the automatic installation of MySQL, the program AWARD_SECRETARY also been enhanced , so that it no longer needs to use the program  for administration  database.  Function backup and restore database or award is do directly in the program AWARD_SECRETARY in a simple way Description here
In the AWARD_SECRETARY resign from giving by the user USERNAME and password for the user in a MYSQL database , because it was only the reason for mistakes made by users  and  then errors in a  program. These data are set permanently during and configuration Installation of MYSQL database.
Improved checking the presence of a connection to the Internet.
Improved method for checking the appears  of a new version of the new  version program AWARD_SECRETARY and in the library dll for DXCC List
Now in line header AWARD_SECRETARY program and  instal_upgrade_award.exe and MYSQL_INSTALL_AUTOMATIC_ALL_COMPONENT_AND_CONFIGURE_IT.exe appears small text about version such as V .1.0.8

AWARD_SECRETARY.EXE version 1.1.5.0 at  20.08.2015 year

- In this version was do the following changes and improvements

because many logger inserts in the field QSL_Via all what give QRZ.COM or another server without any corecting data what "innovation " user put there. AWARD_SECRETARY was equippped  into my routine what do  corect  field QSL_Via .described there .  This corecting by AWARD_SECRETARY is made if the input data if it is entered directly from the logger-a, or  use of the "transmission" this data via website CLUBLOG.
Made many correcting  in the installation program install_upgrade_AWARD.exe, because I think users have met with a problems in the process  installation. Now the installation program detects if the installation is performed from a network drive, which really do not like Windows to and any firewalls. This situation is recognized and a suitable message appear on the screen that  tells you to copy the installation files  to the  disk physically connected to your computer .- see
Expanded file help for the Installation section for the project AWARD_SECRETARY, which describes how to configure firewalls various kinds, including three versions of firewall and Commodo and for firewal ZONE_ALARM and firewall PERSONAL_SUNBELT_FIREWALL, and  for AVAST anti-virus program, especially functions start in the sandbox. The installation screen itself recalls the need of read the help , linked from the relevant button's  or links from the program messages to the appropriate chapter or in detail to the points help file. Of course, as my all of my programs, like something you do not know what do  - simply press the F1 key help - because it is equipped with mechanisms context help.
Fixed a bug in the previous installer program , comprising the steps that it could not be installed in the  Windows 7 32 bit, as reported the following error

Error what was appear in the  previous installation
program version. error removed

Please all ham-radio  who had tried to install a program or a database of all kinds of installation  ,  send to me report  from installation (positive or negative install)  , and if positive install , report from use program AWARD_SECRETARY . In particular, please amateurs do answer to the following questions:

Are you generally interested in obtaining awards . It's not just question about the ARRL awards . There are many national awards , or published  by the journal CQ free , or pay with low-paying. For me making  a new award  is just making the appropriate DLL.
Please give these data in my group discussion..

http://sp9auv.com/fudforum/ 

or write to me e-mail to adres  sp9auv@wp.pl

AWARD_SECRETARY.EXE version 1.1.4.5 at  19.07.2015 year

- Start the version made available to users- after 4 years works - hi . If you have any problems - please write to my disccussion group , after creation account

http://sp9auv.com/fudforum/

 

 

 

Navigation:  AWARD_SECRETARY project and its purpose >

Download project AWARD_SECRETARY and version history

Print this Topic Previous page Come-back to the begin of chapter Następna strona
Expand all elements   Collapse all elements