Configuration for sorting and translation files

After starting the program you will get the first HAM_SECRETARY.EXE window which must choose in which language: Polish or english to work program

After selecting the language of reports to our board with the parameters to configure the personal data (only once when you first start) and then board for the main menu and once a playing sort of configuration and translation. Presented here for the configuration window for sorting and translation is used only if we prepare for the mail merge methods to print QSL cards or labels. If we make printing directly from the HAM_SECRETARY.exe then there is no need to set the data in this window because the print board contains its own relevant fields to define the parameters for only the input data.

HAM_SECRETARY - Main board

Configuration window is divided into two windows, and set parameters there, determine what features will be made in the further course of the program

is to ask the main parameters for the program and decide what features will be made in the further course of the program by selecting from the main menu functions:

•	Sorting file or

•	Translation file

The main configuration can be divided into a sections as follows

This window contains the following items

May act as:

•	type input ADIF - ADIF standard by

•	type input CSV - comma-separated data-the so-called comma separated file

•	type input TXT - text type - data separated by spaces

•	type input cabrilo cbr - the standard for contest's - data in the column layout separated by spaces. If you choose this type of file in the entry is not possible to make the sort. If you set the Sort menu message appears as below

•	typ TXT , stałe kolumny , CSV , psedo CSV . This type requires a broader discussion. It has been specially designed for the preparation of startup file with data for the award for program AWARD_SECRETARY. From one of the amateurs I received data as a text file for already approved PGA_H award

References worked for the Gminy award by SP7OGP on all bands

Mode: All mode

Page:

--------------------------------------------------------------------------------

DATA OF FIRST QSO

---------------------------------------

REFERENCE QSO Conf. CALLSIGN DATE TIME BAND

---------------------------------------------------------------------------------------

AB04 Wałbrzych (miasto) 3 3 SQ6OXC 13/02/2010 07:06 80 m.

AB08 Stare Bogaczowice 1 0 SP/OM9ABA 09/10/2010 06:25 80 m.

AC01 Sochaczew (miasto) 11 3 SQ5M 09/05/2009 15:08 80 m.

To make possibility use this file as a start file for the program AWARD_SECRETARY need to make the following tasks:

1.	You have to enter the possibility of data entry in the form of a column with a fixed width

2.	You need to ensure the removal of redundant lines descriptive.

3.	You need to ensure the removal of redundant columns

4.	You need to ensure the entry's own description of the significance of columns

5.	You need to ensure for do conversion of certain words (eg (miasto) to miasto , or m. to M

6.	You need to ensure that the conversion of single characters to another character such as ( to a blank sign.

7.	You need to ensure exchange Polish characters to their ASCII equivalents , because use for international location program HAM_SECRETARY and AWARD_SECRETARY.

8.	In addition to entering data in the form of a column, you must provide the ability to input data for which the separator of data fields is not only a comma, but every any character as a separator data.

After selecting the type of TXT, fixed columns, CSV, pseudo CSV report to us

Opening a file for editing and translation for PGA_H award

scrolling table to better see where to set the
vertical lines separating column data

Insert a vertical line separating columns of data fields

The appearance of the table after entering the column

Now you need to remove unwanted lines descriptive. They must be select by using the left mouse button with the CTRL or SHIFT key ., when you want to select more rows with one click. Then click the right mouse button on the table and choose Delete selected rows.

Remove selected rows

Now you have to edit the description of columns. Edit any field obtained after double-clicking in the field.

Editing header field

Deleting column

Search for values in the column and replace

Replace text

Message No more occurrences of the text

Just replace for the column BAND character m. to M accordance with the standard ADIF and replace Polish letters to their counterparts ASCII

If we want to find the line for the designated callsign , enter it in the box

Searching rows by giving callsign

Now you need to make a proper translation of the file, and in fact the data in the table. To do this, first select to what type of file you want, for example to adi file

Select the format of the input and output and
the type of output file

Choice translate file from menu

Confirm translation

Typing the name of the output file

The final announcement of saving the output file

Now will show how to use the option type TXT, fixed columns, CSV, pseudo CSV to load data and correct data in a a CSV format

"ADDRESS","DISTANCE","ARRL_SECT","BAND","CALL","CNTY","COMMENT","CONT","CONTEST_ID","CQZ","USER_1","DXCC","FREQ","GRIDSQUARE","IOTA"

,"ITUZ","USER_2","USER_3","MODE","NAME","NOTES","OPERATOR","PFX","PROP_MODE","QSL_RCVD","QSL_SENT","QSL_VIA","QSLMSG","QSLRDATE",

"QSLSDATE","QSO_DATE","QTH","RST_RCVD","RST_SENT","RX_PWR","SAT_MODE","SAT_NAME","SRX","STATE","STX","K_INDEX","TEN_TEN",

"TIME_ON","TIME_OFF","TX_PWR","SFI","A_INDEX","eQSL_QSL_SENT","eQSL_QSL_RCVD","LOTW_QSL_SENT","LOTW_QSL_RCVD","FREQ_RX","BAND_RX","APP_LOGGER32_QSO_NUMBER"

"","","","20M","FR5ZD","","zwrot - not member","AF","","39","","453","14,09","","AF-016","53","","","RTTY","",

"HENRI NAMTAMECO RAMPE DE ST. FRANCOIS 5052 TOUR LA CHAUMIREE F-97400 ST. DENIS REUNION","SP9AUV","FR5","","N","Y",

"DIRECT F6FYD","","","20050820","19880827","","579","589","","","","","","","","","17:00","17:00","","","","Y","N","N","N","","","00002146"

"","","","20M","V85RM","",

"zwrot F6FNU zaprzeswtal Menagera - brak direct V85RM 19.09.2006","OC","","28","","345","14,09","","","54","","","RTTY","","","SP9AUV","V85","","N","Y",

"DIRECT F6FNU","","","20050820","19890611","","559","589","","","","","","","","","22:54","22:54","","","","Y","N","N","N","","","00002330"

"","","","15M","FP5DX","","wyslalem e-mail do QSL managera ale brak odpowiedzi","NA","","05","","277","21,1","",

"NA-032","09","","","RTTY","","","SP9AUV","FP5","","N","Y","DIRECT TK5NN","","","20050820","19900930","","599/05","599/15","","","","","","","","","14:52","14:52","","","","Y","N","N","N","","","00003061"

"","","","20M","ZC4RAF","","","AS","","20","","283","14,2","","AS-004","39","","","SSB","","","SP9AUV","ZC4","","N","N","5B4YX","","","","20000524","","59","59","","","","","","","","","19:49","19:49","","","","Y","N","N","N","","","00003321"

"Claude Laget, P.O. Box 1373 GPO, Phnom Penh 99999,Cambodia",

"","","20M","XU7ABN","","","AS","","26","","312","14,079","","","49","","","RTTY","Claude","","SP9AUV","XU7","","N","Y","DIRECT","","","20050820","20050622",

"Phnom Penh","599","599","","","","","","","","","17:28","17:31","50","","","Y","N","N","N","","","00003943"

After loading the data we obtain

Change the options for file import strictly CSV ie separated by a comma

The appearance of data in the table after importing a CSV file strictly

If you want to edit this field double click on it and change its contents

Editing field

The further course is similar to that described above

May act as

•	type output ADIF according to standard ADIF .

If you select this type of file and date format QSO_DATE is inconsistent with the ADIF format (standard format for QSO_DATE is YYYYMMDD eg QSOs and 20090112 without a time separator such as hhmm 1706) a message shown on the screenshot below

Custom error setting the QSO_DATE is incompatible with the standard ADIF

After selecting OK, you will get output format in the form

Behavior described above occurs only once ie, if NO is chosen to recall the ADIF output format does not cause re-emergence of communication - as it is selection made by the user. Only after the completion of the process of sorting or translation is "reset" your choice

•	type output CSV - comma-separated data-the so-called comma separated file

•	type output TXT - data separated by spaces

•	Cabrillo output cbr type - the standard for contests - data in the column layout separated by spaces. If you choose this type of file output is not possible to make the sort. If you set the Sort menu message appears as below

This window is divided into two windows:

Input QSO_Date format

This area contains the following check boxes to select one excludes other

•

Dont know. This field must be choiced if we do not know what is the date format in the set of input. To correct the QSO_Date conversion from one format to another program must know the format of input date QSOs. Different programs give them in different formats. Diagnosis autoamatic date format by the program is impossible because such a value in this field = 19051231 may suggest the date 1905-12-31 and 19-05-1231. Therefore, if we do not know the exact date format input must be select by operator. After reading the 1st of the QSO with a set of input QSO_Date that will present by program in a separate window and displays a box where you specify the format of input date QSOs. The program saves the chosen format and set as an input - unless you choose the field Dont know again

•	YYYYMMDD - date format without separators input in the form of eg 20090128 is 2009 years 09 months and 28 days

•	DDMMYYYY - input date format without separators, eg 28092009 as it is 28 on 09 a month and 2009

•

YYYY-MM-DD - date format input from the separator in the form of eg 2009-01-28 is 2009 years 09 months and 28 days. Separator characters may be used: dash - slash / colon: dot. Except that the program correctly recognizes the format of the month in the form of words, eg 2000-Jan-28, and turns it into a digital

•	DD-MM-YYYY - input date format separator in the form of eg 28-01-2009 is 28 on 01 month and 2009 as the separator characters may be used: dash - slash / colon: dot. Except that the program correctly recognizes the format of the month in the form of verbal, eg 28-Jan-2009 and turn it into a digital

This area includes:

It contains a character that will be used as the date separator QSO_DATE in the output file sorted or translated. As signs of separation may be, used here: slash / colon : dot . Hyphen -.

This area contains the following check boxes to select one excludes other

•	As input format. We can use this box if you do not want to change the date format QSO_Date in the initial harvest in relation to the date format in the input file

•	YYYYMMDD - date format output without separators as for example 20090128 is 2009 years 09 months and 28 days

•	DDMMYYYY - date format output without separators, eg 28092009 as it is 28 on 09 a month and 2009

•	YYYY-MM-DD - date format output from the separator in the form of eg 2009-01-28 is 2009 years 09 months and 28 days. As the date separator character is used char from field separator - date separator for output date

•	DD-MM-YYYY - input date format separator in the form of eg 28-01-2009 is 28 on 01 month and 2009 As the date character is used char from field separator - date separator for output date

This field should be given a sign which will be used as a separator for format time QSOs . May be used here: slash / colon : dot . Hyphen -. Here you can also not give any sign then the time will for example look QSO time 1402. When the mark sign : as a separator period will look like 14:02.

If to this point you came from the link Translation file go back to the position of pressing me.

Sort can be as follows:

•

Sort according to list DXCC DXCC.lst - official list of ARRL-in. Sorting is done in the order they appear in the file of countries DXCC.lst located in the root directory of the program. This is the official list of ARRL-in . This file includes not only the current entites (countries) but also removed and countries arising from the so-called cross-reference-list that appeared over the years. The file contains all prefikses s that are included in the list Logger32 and also from file WL-CTY.DAT and also those of my entries for the countries in the POL-LOG logger created be mee SP9AUV in a previous years.

•	Sort according to number ADIF standard. ADIF numbers are also stored in the file DXCC.lst

•	Sort alfanumeric according to callsign station. Here you should realize that such an approach will set a place for callsign 7J3FG and JA3NH in a completely different place, although it is the same country

For the first two sorts will be mandatory conversion of QSL cards that has to go through the QSL Manager ie move QSL with the field QSL_Via to country QSL's manager's. Example given here may seem to QSL_Via = EA7FKR. Accurate rules for the QSL Via field are described in the chapter. For the third sort by alfanumeric. will mark the station during the course of the query whether the user wishes to make such a switch when the box is filled with QSL_Via

After administration of all parameters, press the button Confirm configuration.

When he pressed all the parameters given here are stored in a file of setup.ini. Configuration window will disappear and you will get the window as below

The main window after the approval of the configuration

Repeat this setup can be done after selecting from the main menu Configuration - Configuration for sort and translate files

Navigation: Program HAM SECRETARY and its purpose > Configuration program for work >

Configuration for sorting and translation files

Expand all elements Collapse all elements