Polski Związek Krótkofalowców

 

Polski Klub Radiovideografii

Navigation:  AWARD_SECRETARY project and its purpose > Bookmarks implementing the function program > Conditions confirmation of the QSL or LOTW For Award > Bookmark Main database of QSOs >

Entering abnormal data for Polish awards

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

Speaking of Polish awards in this chapter I mean the following awards

AWARD POLSKA_MIXED in 15 categories, ie diploma MIXED, PHONE, CW, DIGI, 80M, 40M, 30M, 20M, 17M, 15M, 12M, 10M, 6M, 2M. Besides this, the division may contain class award .   Class basic diploma ie, bronze, silver and gold.    AWARD_SECRETARY program,  classes join together in a single application , sou it there need only one .dll ..
SPPA award issuued for QSO confirmed with 100 counties SP (powiaty by polish) . For more QSOs confirmed stickers are issued.
PGA award for at least 100 municipalities. PGA-H 100 Award -  is awarded for 100 different municipalities. For larger quantities confirmations are given higher class diploma

When creating these awards I like to obtain neded fields  automatically only  from the station callsign , reliable data for the required fields for these awards . The fields, for these awards  are:

QTH
nazwa wojewodztwa - the name of the province
skrót kodowy wojewodztwa -province code shortcut
skrót kodowy powiatu -county code shortcut
nazwa powiatu -county name
nazwa gminy name of the municipalities
skrót kodowy gminy - code shortcut municipalities

 

A difficult task, but it is possible to perform automatically .. To do this , in the bookmark The main base QSO call from the menu :

Calling the module for introduce data Polish award

after calling this module if in the data to any station have any errors  appear to us the following window

Errors in the data - in this case, delete<br>
question mark and press OK. You can not use Polish<br>
characters

Errors in the data - in this case, delete
question mark and press OK. You can not use Polish
characters

Appear this window

Table and control elements in the module Control
introduction of non-standard data awards Polish

When you move the mouse over the field to collect data from the server side ,  appears to us as a descriptive field for download  data button  For example, as shown below

For others buttons suitable description appears. Quite important is the button

In this button we have a possibility to the  after selecting the row or rows replacing uncertain data from other servers with new more certain data from another server instance with QRZ COM. If we want to not replace existing QTH select this field.     Then we should download from the server HAMQTH.com available data for amateur radio station. This server does not limit the number of downloads. Press the button   Download data for all rows .

 

appearance of the screen at the time of downloading data from the server

We can still arise the question of correcting  data in the field  ZIP or QTH. Doing so would improve the Polish diacritics to replace characters without stalks. ie  only ASCI characters. Such a process has forced the proceedings that AWARD_SECRETARY can be used  by foreign stations - and certainly in a different environment than the Polish  . Polish Windows characters will be  be appeared in the form of "bushes". It is also important which characters will use MYSQL

 

Any field from table can be edited by double-clicking the mouse in the field.

The program behaves so that way that leaves the selected fields such selected  rows for which no data. In our case, the lack of data for 580 rows. So we can choice sewer DXWATCH.COM and try to download it for missing data rows.

Choice another sever DXWATCH.COM

If for some reason the data are empty - ie the lack of data QTH or this data will be incorrect then we can choose a selection QSO to  download proper  data from server QRZ.COM

Selection server <br>
QRZ.com

Selection server
QRZ.com

then SELECT the  QSO for download

Select QSO  for download data
from more sure serwera's QRZ.com

Now we have the most important at this time data given  ie QTH  station and ZIP code On its basis, program can almost automatically, can define the necessary data, ie the municipality, county, state (wojewodztwo) and their codes based only on callsign . Why almost? . Well, in Poland there are many places (municipality)  with the same name. To make the job more difficult  one ZIP code can be assigned to a few municipality or  villages .Therefore, in such cases, you will be prompted on the screen to make a choice. Generation of the data is done by pressing the button

The case of the existence of many towns that
meet the condition.  You should make a choice.
In the event that we do not know what to
choose select Cancel (anuluj)

After filling the table program do  automatic saving the data

The state of the table of data after automatically filled
for Polish awards  After a full array of necessary
data, the data is automatically stored in the main array
QSOs_AWARDS

Let us now do look  , if we have all the data for all stations

So we need to correct  the field QTH. Double-click on the field and get

Correcting fiel  to  Zabrze<br>
and pressing OK

Correcting fiel  to  Zabrze
and pressing OK

How to make a manual correction of incorrect or not exists data in field  QTH  and others regarding the municipality, county, state. So in this line press the right mouse button and get filled row .

Method for correct , when error is in the  QTH

Finding data for municipality, county, province
after error correction codes for the QTH

Data table filled with municipal, county, state
and their codes

 

After correction for other incorrect data, save additional special data by buttoon

ext I describe how to introduce  data to  the PGA award_ and credit  QSO as confirmed  by participation in the contest  PGA .This possibility for QSOs  predicted by publisher PGA  award . . Method presented here should not be used if the name of the Contest was transferred from the contest program logger   to main logger and from there  to AWARD_SECRETARY. If these data we lack is you can do this as below. Here are two possible methods of selecting data - first - by date QSOs and the second by the number shown on the screen QSO. Here, we'll show you the method of the 2nd

Resulting this in an table as  form

Filling field name Contest_Name for QSO
from 493 to 503 as  predefined name Contest PGA

Now you need to save the data by pressing the button

If you would like to select QSOs by date then we have  mini calendar