Polski Związek Krótkofalowców

 

Polski Klub Radiovideografii

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

Configuration for sorting and translation files

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

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

Main configuration

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

 

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 formatWe 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

Field here is only displayed, ie dimmed without the possibility of change.  Language is selected after running in a separate 1-st window.   The choice there is made is saved so the next launch will not require re-approval and only select OK, or click the mouse on any point on the 1st of the window

Options for printing QSL cards

This area determines how files will be prepared for the print queue in the process of sorting  file source (any format. adi. csv,. txt) with  data cards printed by a mail merge in MS Word. Recommended to select as the output format type. csv adopt it as MS Word.  This area contains the following fields:

Number of QSOs on one QSL card. Any digit between 1 and any real number of QSOs which it is possible to print on one QSL.

If for a particular station is less than the declared number of QSOs in the one card here - then in the output will be sorted so inserted. empty rekords containing a blank data for all fields value ='----------' which will print on the QSL card characters in an empty field ----------

 

Divide sorting file on parts This option allows you to create collections of sub-headed as their main output filename to write, and given numbers from 001 to the required quantity resulting from the splitting of eg source_sorted_001.csv.

If this box is not checked "pipe" then the next field will be dimmed

Maximum number of QSL in one file of output.This field gives how much of the QSL's which will be printed in a single pass printing. This saves a break in printing for printing problems

Last used input directory. . This field gives the directory which was used to set the input data source QSO.  It protects us from "traveling into directories" in cause reuse program

Last used directory of the input is saved in a file of configuration parameters setup.ini, so that the next run the program that the program will first use the previously stored directory . This window have scrolled horizontal bar

Last  used output directory. This field gives the directory which was used to set the output for use in the method of printing a mail merge in MS Word. It protects us from "traveling into directories in cause reuse program.

Last used directory of the input is saved in a file of configuration parameters setup.ini, so that the next run the program that the program will first use the previously stored directory. This window have scrolled horizontal bar

Signature Configuration

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