Polski Związek Krótkofalowców

 

Polski Klub Radiovideografii

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

Files for printing the bookmarks between countries

 Print this Topic Previous page come-back to begin of chapter Next page
Expand all elements   Callapse all elements
1.In order to facilitate the dispatch office via the bureau QSL   program in the process of sorting produces file  COUNTRY.CSV in a  format. csv file which is the basis for  printable bookmarks between sending countries in a package sent QSL cards. File  is saved in the directory where you saved the sorted file 

 

The format of the data file COUNTRY.CSV format .Csv file looks like this

"NR_CTY_COUNTRY","NR_ADIF_DXCC","COUNTRY","START_CALL","END_CALL","PREFIKSES"

"3","260","MONACO","3A2MD","3A2MW","3A,3B6,3B7,"

"4","4","AGALEGA & ST. BRANDON IS.","3B7SP","3B7SP","3B6,3B7,3B8,3B1,"

"5","165","MAURITIUS","3B8GT","3B8GT","3B8,3B1,VQ8CP,VQ8CR,VQ8CS,VQ8CV,VQ8CZ,3B9,=VQ9CPR,"

"6","207","RODRIGUEZ I.","3B9FR","3B9FR","3B9,=VQ9CPR,3C,"

"12","468","SWAZILAND","3D6BD","3D6BD","3DA,3D6AK,3D6AX,3D6BP,3D6BD,ZD5B,ZD5E,3V,TS,"

"13","474","TUNISIA","3V1A","3V8ST","3V,TS,3W,XV,"

"18","18","AZERBAIJAN","4K0ADS","UK6DAC","4J,4K,UD6,UK6D,4L,=4U/TF1MM,R6F,UF6CR,UF6VAG,RF6F,UF6F,"

 

One line represents one country and one of the bookmark

This file can be used as a basis for printing the bookmarks directly from program HAM SECRETARY or by  using the mail merge method .  In order to print by mail merge method use the  pattern template for mail merge method BOOKMARK.DOC and load it to MS Word-a (preferably by pressing the BOOKMARK.DOC) and use data from the produced COUNTRY.CSV file

 

Proceedings for the application of the mail merge method   is described on my site  http://sp9auv.com specifically on the

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

 

Created a bookmark for the 1st line of data will be looked

Bookmarks bettwen countries

 

2 For the purpose of the QSL card archive home program produces a file COUNTRIS.CSV that contains the lines   for all countries from the list DXCC.lst  File is stored in the directory with the program HAM_SECRETARY.  Creating this file is described in section Bookmarks for home archive QSL cards.  Same method of printing as well as the appearance of tabs is the same as in step 1

 

 

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

Files for printing the bookmarks between countries

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