Polski Związek Krótkofalowców

 

Polski Klub Radiovideografii

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

HAM_SECRETARY program and its purpose

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

In this chapter was discusses the following points:

1.Pre-discussion of printing QSL cards, labels, envelopes, address, bookmark
2.Pre-discussion of printing labels by mail merge method
3.Other functions performed by the program HAM_SECRETARY
4.Changes in version 3.3 of the program HAM_SECRETARY v 3.3

 

Pre-discussion of printing QSL cards, labels, envelopes, address, bookmark

Program HAM SECRETARY   HAM_SECRETARY.EXE  further continuation of the QSLSORT_TRANSLATION.EXE. And in short, his features illustrated icon About:

 

 

 

The program serves to assist in a ham-radio activities secretarial with his hobby , such as :

 

Print QSL cards or print labels directly from the program   HAM_SECRETARY  withot  use Mail merge methodology and  MS Word
print envelopes and mailing envelopes for the feedback you send direct QSL cards
download address for sending cards direct from QRZ.COM  or for any station.
checking whether for the  QSO and  his country is  present  QSL bureau
Correction field QSL_via provided by Logger. If this field was taken from QRZ.COM without any correction of this field it usually not suitable for printing on QSL card. In this regard, an appropriate correction is doing by HAM_SECRETARY . I recommend  users apply for downloading data from my QRZ_COM program BUREAU_ALL_QRZ_COM_Fi.exe what cooperating with Logger32 and do correction field QSL_Via

http://sp9auv.com/EN/index.html?downloading_programs_cooperating_with_logger32.php

This correction in a field  QSL_Via is do  regardless of whether the above correction has been made by the program BUREAU_ALL_QRZ_COM_Fi.exe. Not only   sees direct effects of correction and you can not make another correction, unless it is made ​​in the logging program.
Print bookmarks between countries for sending packet QSL cards ,  and for  the home QSL card archive
Sorting printed QSL cards or labels according to the selected sorting criterion with move cards to be sent via the QSL Manager .
The file format can be any : ADIF, csv, text.
Printing doing in a user-selected sequence (see below)
Printing is based on printing patterns that can be individually designed by a  program
provided in the directory HAM_SECRETARY \ PATTERN_FOR_PRINT print patterns will likely match for each station because at the time of printing the program take personal information station from a file of configuration SETUP.INI
to QSL fields or labels, you can insert any graphic images which provides a powerful tool for creating full colors QSL cards
design template for the print method is with use WYSIWYG method (what you see it what you get) giving a natural and user-friendly tool for designing printed patterns - no need to re-test in order to see the results  of print elements, since it is already is see in the design time .
you can forget about a fairly complex method Mail merge method
Starting with version 3.1.9 this software when  printing QSL cards for Polish stations do  insert  to  field QSL_VIa   Branch Number field Office  Bureau QSL for - eg OT50 if the station is serviced  by Polish QSL bureau
Also, since this version is checked whether the station in Poland is  a occasional station and check if there are  present  callsign station what must get  QSL card for this station .
Also, since this version is checked whether the operator station is alive and there is no status of Silent Key
In these cases, it is reported with a message on the screen and are saved in files text elevant reports .
Creating a bookmark in a. Csv file  format between countries in a sent QSL package - in order to print them later directly in Ham_Secretary
Creating a bookmark in a. Csv file format  for archive home QSL cards - print them for later Ham_Secretary directly
PROGRM is very helpful to print a massive QSL CARDS including for the DX-expedition STATIONS

Program at the end of print QSL cards or labels creates a  sorted file COUNTRY.CSV - which may be the basis for printing the bookmarks between countries sent directly from Ham_Secretary . Print QSL cards or labels shall be do with  the following conditions:

 

Printing QSL cards or labels are made with use one of three methods of sorting
1.by the next number in the set DXCC.lst containing data about entites  by the ARRL DXCC List
2.by number ADIF -ADIF standard compliant (in Logger32 field is called the DXCC)
3.by the callsign station by which the station is sent QSL card
In the first two points, the program moving a QSO's with a solid field VIA_QSL Manager (sign the QSL Manager) to the  country QSL Manager's. QSO's which must be sent DIRECT, ie in the field VIA_QSL have inserted in the first place the word DIRECT will be inserted into the appropriate box above number by the DXCC country and ADIF_. Then number then will be equal  = 999 which will result in the QSL's sorted at the end of sorted file  and hence will be printed at the end. But this sort of program is doing also second sort by  Callsign field station (ie the in a one country QSL's will be sorted by callsign station). Of course, first sorting will be preserved
In the case of 3-th point - moving the QSL card for the manager is do before  asking whether the user wishes to make such a moving
In the filles provided in the directory HAM_SECRETARY \ PATTERN_FOR_PRINT were put patterns templates on which prints are made. Program give tools to design any pattern, even with elements or a graphical. Design is a further claim on the pattern of fields and the ADIF and / or graphics. Pattern on the screen are not shown the ADIF field names, and only show the real data taken from the test record, or if field QSOs are not there , it is  taken from the personal configuration parameters of the station .  So  I designed template patterns can be directly used for any station because data such as name, callsign the station will be replaced with actual personal data for station that uses the program -- stored in a file Setup.ini.

 

 

 

Pre-discussion of printing labels by mail merge method
It is also possible to use the methodology Mail merge method in MSWord, and  the program also offers the sort order of the QSL card printing (print queue) with move cards sent via the QSL Manager.
Creating a bookmark in .csv format between countries in a send QSL package - for later print them using mail merge in Microsoft Word
Sorting collections (print queue) for print QSL cards or labels on the QSL using Mail Merge in Microsoft Word in a specific sequence and move cards are sent via the QSL Manager to the country QSL_Manager's .The format can be any collection: ADIF, csv, text.
If you use the mail merge methodology QSL-s, or labels there is printed using only one pattern template for the maximum number of QSO's no matter how many QSOs we have done with this station. Consequently, then no longer need to manualy moving cards - which is a big hurdle for a mass shipment of cards

The program uses exported by the logger file in any format (ADIF - csv - txt) that contains information about your QSO's QSL card or labels on the card for printing

 

if for a given station will be done for example, only one QSO, the next record in the sorted file  will be filled with empty "-------","---------","---------", records, etc. up to a maximum number of QSOs on one card.  In this way the print can use only one pattern template regardless of the number QSOs made with a certain station
If in a file DXCC.lst will be not present country for a anybody callsign program will be  generated report on-screen and in file  REPORT.TXT wiil be present info about them  Records from the QSO will be placed at the end of print as the penultimate country called "COUNTRY NOT PRESENT" For him, the country will be assigned number = 998. The operator can manually delete the records from the collection sorted.
If the operator requests it - the generated file can be sorted and divided into parts _001.csv _002.csv etc., each of which will contain only a fixed number of QSL cards. Secure the printer downtime..
The program also generates a file COUNTRY.csv for printing bookmarks  between countries based on the mail merge methodology and template pattern BOOKMARK.DOC. This file (Country.csv) will be placed in a directory where the program will inform the Report.txt. The order in this file will be the same as declared for the QSL card printing.
In th catalog HAM_SECRETARY \ Pattern_for_Serial_Coresponding_method have been placed patterns templates for print  with mail merge method

•  for printing directly on the QSL - QSL.doc

•  for printing labels on the QSL card

•  QSL_label (3x8). doc 3x8 labels on A4 = 24 QSL's - side of the borderlands

•  QSL_Label L7159 (3by8)_3QSO_bez_obrzezy.doc 3x8 nalepek na A4=24 QSL's -  without the side edges.

•  QSL_Label (3by9) _without_edge.doc 3x9 labels on A4 = 27 QSL's - without the side edges

• patterns of ENVELEOPE.doc address envelopes and return envelopes ENVELOPE_SASE.doc

ADRESY_DIRECT.csv file - which is an example of how to perform address data collected from the www.QRZ.com via Internet

• Files located in HAM_SECRETARY \ PATTERN_for_Serial_Coresponding_method should be editing in Microsoft Word for your QSL card and your personal data

• All files supplied at this time for tests -  recall to the appropriate file in a directory test ..

 

For domestic needs of the archive QSL card program creates a list based on DXCC.lst file COUNTRIS.csv underlying printable bookmarks between countries in the home archive QSL cards directly in the program  HAM_SECRETARY or by mail merge method.

 

 

 

Other functions performed by the program HAM_SECRETARY
Sorting file  adif, csv, according to the given order
by sequence number in the file  DXCC.lst containing data entities by the ARRL   DXCC List
according to number ADIF -standard  ADIF (in the Logger32 field is named DXCC).
by callsign station to which it is sent QSL card
Translate files between any formats - ADIF - csv - txt - cbr on any format
Besides sorting program can make collections translate between any formats  - adif - csv - txt - cbr. It is possible translation from any format to any other format. There is no need here to make here any column settings as is the case with many other programs. The program itself copes with these cases by analyzing the source file at the time of translation.
Create file in a  Cabrillo format standard 2.0 or 3.0
Creating a file bookmark in .csv format for home archive QSL cards
For home archive QSL program creates based on a file DXCC.lst file COUNTRIS.csv for  print bookmarks between countries in a home archive QSL cards directly in HAM_SECRETARY or by mail merge

 

 

Changes in version 3.3 of the program HAM_SECRETARY v 3.3

In this release introduces significant changes in improving the functions of the program and enhance the user interface, based on the user feedback, and previous experience:

Deleting checkbox  ---Automatically Align cells from the cursor position

This does not mean, that this align program does not make . Program such align  does the most, but without the need to turn on and off this checkbox  by the user. Past practice has shown that users was  switching this checkbox in a not suitable moments  - often causing the deformation pattern, resulting in large obstacles in the design of the pattern table . The result was the phenomenon that usually printing elements exceed the allowable area , or pattern exceeded acceptable limits and you could scroll by the mouse  pattern table.  Such a phenomenon was evidenced as the incorrect pattern table . 
Now the program itself determines the moments when the alignment is switch on and off. User have on the screen exactly written what must do to correctly design the pattern array. If you will do it  exactly, this design pattern table should no longer do such problems.
Disposed in the tabs button Exit to the main menu, replacing it with the button Exit from a program. I noticed that the users tried after going to the main menu again call other functions or do  the same function again, which caused errors later in a program. These errors were due to the lack of reset some of the structures in the program, for which the reset functions do not work properly. Therefore, given the return button exit the program

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

HAM_SECRETARY program and its purpose

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