Data migration

2 posts / 0 new
Last post
dk9he
dk9he's picture
Data migration

Hello there,
I consider to migrate my current log data to cqrlog. ADIF seems to be the only way.
Now I can't find the right destination fields or tables of my running logs. Goes all worked awards and club members into one award field?
How to deal with table content of worked German DOKs?
Has the migration to go with one shot or can I split it in basic data like date, time. call, name,
and upload my worked award tables later?
How ever, I played around for a while with cqrlog. Now it looks great and I would like
to work with it. 
73,
Andy DK9HE
 

ok2cqr
ok2cqr's picture
Re: Data migration

Hi Andy,
 
yes, ADIF is only way. There is only one award field but every club has it's own field. It's because the club can have numbers or only callsigns. It's quite complicated because one station can be member of one club several times and always can have differenct number - e.g. FOC.
You can see whole DB structure in QSO list window -> Filter -> SQL console. The SQL command is select * from cqrlog_main.
You can use also any MySQL GUI app when CQRLOG is running, the port is 64000, no password required.
 
73 Petr, OK2CQR