AWARD_SECRETARY project and its purpose

Purpose of the project AWARD_SECRETARY in short shows the About window .

AWARD_SECRETARY project serves the following tasks:

1.	Performing 1st application for award - automatically in the prescribed paper form by the publisher or in a external file for ON_LINE method do application

2.	Performing the next supplement award (endorsement , if these are provided for by the publisher award /

Choosing QSO confirmations for award depending on the set method confirmations ( only QSL or only LOTW ) or mixed selection acknowledgments (First QSL Second LOTW or FIRST LOTW second QSL) is done automatically. There is an additional possibility to manually change the selection for any QSL's - because , for example ,not wish to send a QSL card in a nice graphical form

Continue management awards endorsement for awards that were already submitted manually. This is done in such a way that the first will automatically calculate the current state of the application for confirmation and then having to manually choose a QSO which has already been reported. At this point it is possible deletion of the countries, if not yet been reported. Further additions entrust to proogram AWARD_SECRETARY. Besides this method, which can sometimes be time-consuming, for the old amateurs who already have some award . program AWARD_SECRETARY offers yet another three methods of recovery starting state award basis on a external file in any file format, ie adi csv, txt - text methods , what are described in Chapter

5.	Details of QSO's are loaded in ADIF format from any logger to log maintained by the AWARD_SECRETARY. This log is stored some additional fields needed primarily for awards ARLL

6.	As we have already a database in a format MYSQL you can ask additional SQL queries - queries like give me a QSL managers unreliable and as long as I'm waiting for a QSL card from them, Countries send - not confirmed, Time is waiting QSL card, Time is waiting direct QSL card., etc

7.	Cost optimization for checking of QSL cards or LoTW confirmations

8.	Project AWARD_SECRETARY show bellow picture :

Project AWARD_SECRETARY

Project is made up from the following components:

•	AWARD_SECRETARY program.

•	Databases in MySQL format that stores tables MYSQL -join to the main log , qsos_awards, list_dxc, and table for awards dxcc_5_bands_award, dxcc_mixed_award, polska_award, iota_award, etc

•	libraries as files with the extension .dll eg dxcc_5band.dll , dxcc_mixed.dll, etc., in which is contained the whole philosophy of the requirements for the award .

•	procedure to print the application for a award in the prescribed form and saving the printed application as a external file

•	support for databases in format MySQL is doing by AWARD_SECRETARY program , what in a principle is give to uniform user interface to different awards tables

ARRL awards

Special discuss require application for the ARRL

There are present 18 different awards issued by the ARRL.

1.	160 Meters

80 Meters

40 Meters

20 Meters

10 Meters

17 Meters

15 Meters

12 Meters

6 Meters

10.

2 Meters

11.	70 Centimeters

12.	5-Band DXCC

13.

Mixed

14.

Phone

15.

16.

DIGITAL

17.

Sattelite

18.	DXCC Challenge

In the ARRL awards -the following rule applies : if you have a QSO approved award in one award, it does not need to be reported this QSOs in another award - if you want to get it. We have eg. Approved QSO with a station HA1GH SSB (Phone) on 80 meters band for the 1st notification Mixed category. It QSOs do not have to re-apply for award Phone category and also to category 80 meters. You can see that one QSL card can be used, ie three times.

•	for category Mixed

•	for category Band

•	for category Mode

Of course you need lead the application so that it was possible. In the extreme case, it can be every time the other QSOs - but then you have to pay three times for check cards.

The program AWARD_SECRETARY program can perform the selection in this way that it's possible to optimize the cost of checking of QSL cards. It is done in that way that the first calculating achievements for award dxcc_5bands_award and stores the relevant information in the main log qso_awards used by other awards. For other awards ARRL is recorded similar information, and if the QSO is approved - that we give him the date of confirming QSO (there are named as date_granted) of the QSO (also named as date of approval of the QSO) , Then this QSO will no longer be shown in the list of applications on another award, although it will be automatically added in the verification process for the award . More about the tactics of cost you see currently below

Additional possible to manually fixes selection QSO- QSL

Proposed by AWARD_SECRETARY QSO_QSL to some award can we for some reason do not respond. There is then the possibility of selecting another QSO in the manner described below. The reasons why we may not respond may be as follows:

•	card has nice graphics and you cannot lost it . You can then select other QSOs - but then you must remember that the new QSO_QSL must chose on the same band and the same emission. Then do not lose valuable optimize costs for the country which do AWARD_SECRETARY for awards ARRL.

•

AWARD_SECRETARY program we use to continue supplement (endorsement) to the award . Then it is difficult - optimization backlinks applications we do not have - but the program will continue to try to carry out further additions in the best way for awards ARRL. In this case, the program offers a deletion one row (country) in the table selected QSO_QSL, such as this country has not yet been reported

Program AWARD_SECRETARY has the ability to conducting supplements to the award

After the first application many publishers diplomas provides the ability to report supplements to the award (endorsement) A process for the procedure is here as follows:

•	Mark for the previous report that QSO_QSL been approved - giving it as the date of approval (date granted ) from current date. Of course, if some QSO_QSL has not been approved, you can designate that the QSO as Not Approved

•	Now update the award after loading the new data from ADIF file log from logger

Print the application or supplementing to the award

After completing your application in the award it is possible to print the application to the printer. Printing is done on the form provided by the publisher award

Saving a printed application to the file

In addition to print to the printer AWARD_SECRETARY program provides the ability to save application to the file wit extension .rvf. The title of the set consists of the name of the award + current date + extension .rvf. These are so kind of archive - what we reported and when .File .rvf type can only be read by AWARD_SECRETARY. You can also write to the ADI and CSV format for submissions by ON_LINE method .For some awards as Polish award is the ability to write to a file of ASCII text. This form of application was predicted by publisher award .

Cooperation program's with the DXCC list from CLUBLOG

As of today, ie 10.19.2014 AWARD_SECRETARY program cooperating with XML DXCC list and with others files , what ofers to check pages on www CLUBLOG your .adi

file . It is on a page

https://clublog.org/index.php

I have to admit that the authors CLUBLOG have done hard and needed job, because it is possible to define entity and its parameters, not only for the current time, but also for the QSOs from the past . In its files XML is includes the date (DATE from) and date (Date TO) in which a given prefix or the all callsign was counted .

I must admit that the appearance of the CLUBLOG websites meant that the work for the AWARD_SECRETARY program moved significantly forward, because I saw that the data on entities provided from loggers are mostly incorrect and there was a need for an international standard for the DXCC list international standard to the DXCC list. ARRL was reluctant to do this job

This work has made by the team CLUBLOG , the persons is show bellow (links to websites CLUBLOG )

https://clublog.org/about.php

•	Michael G7VJR - Creator of Club Log

•	Alan 5B4AHJ - Database Manager

•	Jim KE8G - Helpdesk Volunteer

•	Marios 5B4WN - Expedition Tools

•	Dimitri SV2YC - Zones Manager

AWARD_SECRETARY program with data from CLUBLOG cooperating through the universal module library DXCC_lst.dll Universal module library DXCC_lst.dll. Its advantage is that it can be implemented in any programming language eg Delphi, C ++, C #, Misrosoft Visual C ++, Visual Basic. It is a dll that I ' m author . Suitable further descriptions are provided in the next sections

Numbering QSL with use label as a quick method of finding QSL

The program offers numbering QSL received wit use sticker with number QSL cards, which greatly accelerates the process of finding the QSL if do aplication for awards It is described here

Navigation: »chapter is not sub-section upper level «

AWARD_SECRETARY project and its purpose

Expand all elements Collapse all elements