Polski Związek Krótkofalowców

 

Polski Klub Radiovideografii

;

Nawigacja:  »Rozdział nie jest podrozdziałem wyższego poziomu«

Drukowanie kart QSL,kopert,zakładek metodą koresp.seryjnej

Print this Topic Poprzednia strona Powrót to początku rozdzału Następna strona

Poniżej wybrano i opisano  metodę druku kart QSL w oparciu o metode wymiany danych .CSV , która nadaje się do druku kart QSL dla  wszystkich typów loggerów , poniewaz większość programów loggujących moze wyprodukować zbiór danych o QSO's w postaci zbioru z rozszerzeniem .CSV . Taki zbiór .csv to nic innego jak baza danych z danymi o QSO's, gdzie poszczególne pola danych rozdzielone są przecinkiem (comma separated value). Do drukowania kart QSL doskonale nadaje się Microsoft Word i jego dość rzadko stosowana medodyka korespondencji seryjnej opisana w nastepnym rozdziale . Typowa zawartość takiego zbioru w formacie .csv może wyglądać jak niżej

Uwaga : ze względu na ograniczenie dlugośći linii w przegladarce jedna linia została tutaj podzielona na wiele linii

1-sza linia zawiera nazwy pól danych jakie będą występowały w następnych liniach

"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","APP_LOGGER32_eQSL_SENT","APP_LOGGER32_eQSL_RCVD","APP_LOGGER32_LOTW_SENT","APP_LOGGER32_LOTW_RCVD","FREQ_RX","BAND_RX","APP_LOGGER32_QSO_NUMBER"

2-ga i następne linie zawierają dane rozdzielone przecinkiem , z tym że każda dana jest zawarta w znakach cudzyslowia " " w celu mozliwości wstwienia znaków specjalnych

"","","","40M","RA6DE","","","EU","RUSS RTTY Contest","16","","054","7,041","","","29","","","RTTY","","","SP9AUV","RA6","","Y","N","","","20071220","","03-09-2005","","599","599","","","","","","16","","","04:43","04:43","","","","Y","N","N","N","","","00004226"

"","","","20M","EA1FEH","","","EU","","14","","281","14,0727","","","37","","","PSK63","Jose","","SP9AUV","EA1","","Y","Y","","","20071011","20051214","12-12-2005","Aviles","599","599","","","","","","","","","15:50","15:53","50","","","Y","N","N","N","","","00004907"

"","","","80M","YO8FR","","","EU","ARRL RTTY Contest","20","","275","3,58","","","28","","","RTTY","Proto","","SP9AUV","YO8","","N","N","","","","","08-01-2006","Botosani","599","599","","","","272","","239","","","19:23","19:23","","","","Y","N","N","N","","","00005430"

Oprócz drukowania kart QSL metodyka korespondencyjna seryjnej może także służyc do druku kopert , kopert zwrotnych  oraz zakładek (bookmarks) pomiędzy posortowane QSL-ki w wysyłanym pakiecie kart QSL do biura QSL managera  oraz zakładek pomiedzy posortowane kraje w naszym archiwum kart QSL . Jak więc widac jest to metoda która moze służyc do większości zadań sekretarskich w naszym radio- shacku i warto poświęcić jej trochę uwagi na zapoznanie się z nią

 

 

Nawigacja:  »Rozdział nie jest podrozdziałem wyższego poziomu«

Drukowanie kart QSL,kopert,zakładek metodą koresp.seryjnej

Print this Topic Poprzednia strona Powrót do początku rozdzału Następna strona