"IEKAdif"

IEK ADIF log (*)

by is0iek

 

Page dedicated to those who adopt their own log utility, as mine, using standard database products. The only advantage being, perhaps, to quickly know where to put hands in case of fault or difficult , HI !

Pagina dedicata a quanti, come me, adottano un proprio programma di log appoggiato a prodotti database standard. Il cui unico vantaggio è, forse, quello di sapervi rapidamente mettere le mani in caso di difficoltà o malfunzionamenti, HI !

 

LOG Table field definitions :

Naming conventions : ID for data identification codes (keys), DT for date/hour type data, NM for numbers, CD for codes, FL for flags (only ON or OFF admitted), TXT for any other text

(concerning more data meaning than data format)

LOG.DT_QSO, (QSO date yyyymmdd)

LOG.DT_QSO_TIME, (QSO time UTC)

LOG.NM_FREQ, (QSO freq)

LOG.CD_MODE, (mode code : SSB, RTTY, CW, TOR ....)

LOG.TXT_PWR, (TX power, number or signs, eg. < 15w)

LOG.TXT_RIG, (50, my rig definition)

LOG.TXT_ANT, (50, my antenna definition)

LOG.ID_OM, (12, correspondent's CALL)

LOG.TXT_QSL_VIA, (50,QSL via, deafault blank)

LOG.ID_OM_FROM, (30, sending CALL, portable prefix and locator) (*)

LOG.CD_RST_SNT, (15, report sent + ev. progressive es. 59-010-015)

LOG.CD_RST_RCV, (15, report received+ ev. progressive es. 59-1231-014)

LOG.DT_QSO_TIMEND, (QSO ending time UTC)

LOG.CD_QRM, (3, QRM mark, such as X, XX, XXX )

LOG.CD_QSB, (3, QSB mark, such as X, XX, XXX)

LOG.DT_QSL_SNT, (QSL card SENT date)

LOG.DT_QSL_TNX, (QSL card RECEIVED date)

LOG.DS_OM_NAME_QTH, (100, correspondent's name & QTH)

LOG.TXT_OCCASION, (default length, occasion of QSO, eg. Contest, Expedition, ...)

LOG.TXT_REMARKS, (default length, .... any other)

FL_QSO_NOT ; (1, NO QSO mark, such as CQ, HRD, test, ooolà ...)

(*)

default mycall + prefix (if any) & locator for portable operations out of habitual QTH (es. IM0/IS0IEK JM49CD), to be printed on QSL cards (may be also used as a multi-log database identifier !)

default mycall + eventuale prefisso & locator (es. IM0/IS0IEK JM49CD) in caso di operazioni in portatile fuori dal QTH abituale, da riportare nelle QSL (consentirebbe anche il multilog !)

 

 

Query definition :

SELECT Left([DT_QSO],4) & Mid([DT_QSO],6,2) & Right([DT_QSO],2) AS QSO_DATE, Left([DT_QSO_TIME],2) & Right([DT_QSO_TIME],2) AS TIME_ON,

Int([NM_FREQ]) & "." & Right([NM_FREQ]*1000,3) AS FREQ,

"<MODE:" & Len([CD_MODE]) & ">" & Left([CD_MODE],4) AS MODE, (*)

Left([ID_OM],8) AS CALL,

IIf([CD_MODE]="SSB" Or [CD_MODE]="AM" Or [CD_MODE]="FM", Left([CD_RST_SNT],2),Left([CD_RST_SNT],3)) AS RST_SENT,

Left([TXT_OCCASION],40) AS COMMENT

FROM LOG

WHERE (((LOG.FL_QSO_NOT)=" " Or (LOG.FL_QSO_NOT) Is Null) AND ((Left([DT_QSO],4) & Mid([DT_QSO],6,2) & Right([DT_QSO],2))>=[since YYYYMMDD]))

ORDER BY Left([DT_QSO],4) & Mid([DT_QSO],6,2) & Right([DT_QSO],2), Left([DT_QSO_TIME],2) & Right([DT_QSO_TIME],2);

 (*) for MODE a default length of 4 will not be accepted.

 

Generating a Report in ADIF (*) format

Element name : Testo2 Origin : ="<QSO_DATE:8>" & [QSO_DATE]

Element name : Testo3 Origin : ="<TIME_ON:4>" & [TIME_ON]

Element name : Testo4 Origin : ="<FREQ:7>" & [FREQ]

Element name : Testo5 Origin : =[MODE]

Element name : Testo6 Origin : ="<CALL:8>" & [CALL]

Element name : Testo7 Origin : ="<RST_SENT:3>" & [RST_SENT]

Element name : Testo8 Origin : ="<QSL_COMMENT:40>" & [COMMENT]

Element name : Testo9 Origin : ="<EOR>"

(Field alignment in the output will be a bit complicate)

Then send in Ms-Dos format, and save it on disk (ready for upload)

 

Just the same way you can generate a QSL label printing Report, or directly a QSL printing one.

 

-...-

(*) ADIF stands for Amateur Data Interchange Format (see http://www.hosenose.com/adif/) ; this format is adopted for log upload at eQsl !

ADIF sta per Amateur Data Interchange Format (vedi http://www.hosenose.com/adif/) ; tale formato è adottato per il carico dei log su eQsl !

home