Program HAM SECRETARY and its purpose

Go to polish version

Program HAM SECRETARY HAM_SECRETARY.EXE version 2.4.5 is a 2.0.4 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

•	Print QSL cards with use Mail merge methodology and use the 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.

•	Print bookmarks between countries for sending parcels 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

•	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. Merge method is described on my website

http://sp9auv.com/index.html?met_korespondencji_seryjnejdladrukuqsl_msword2003.php

•	The format can be any collection: ADIF, csv, text.

•	Translate files between any formats - ADIF - csv - txt - cbr on any format

•	Create file in a Cabrillo format standard 2.0 or 3.0

The program features outside the following features

•	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 set 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 deployment of print elements, since it is already evident in the design phase pattern

•	you can forget about a fairly complex method Mail merge method

•	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.

•	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 or using mail merge in Microsoft Word

•	Creating a bookmark in a. Csv file format for archive home QSL cards - print them for later Ham_Secretary directly or by a mail merge in Microsoft Word

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 or print bookmarks by use mail merge. Print QSL cards or labels shall be keep 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

If you use the mail merge methodology QSL-s, or labels on the card are 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.

•

The collections 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 , are 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.

•	The Catalog HAM_SECRETARY \ Pattern_for_Serial_Coresponding_method collections 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 ..

•

In addition to sorting program can made translate any formats - ADIF - csv txt - cbr to any ADIF - csv file - txt - cbr. Translation is possible from any format to any other format. You do not need here to make any settings for a column here as is the case with many other programs. The program itself is doing with these cases by analyzing a set of source at the time of translation.

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

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

HAM_SECRETARY program and its purpose