Callbook & expected operation of "Database update"

3 posts / 0 new
Last post
k0skw
Callbook & expected operation of "Database update"

I'm wondering if I've found a bug in "Database update" or if I'm not using it correctly.

Okay, here's what I'm doing. I'm importing an ADIF file with a handful of QSOs from another logging program (JT65-HF). These QSOs don't have names or qth's on them. To have CQRLOG go out and find the names from HamQTH, I go to the Callbook menu, and select "Database update".

I get prompted if I really want to run database update, and I click "Yes".
I get prompted asking if I want to update names from previous QSOs. I don't want to update the names for every QSO (and some of them the names have changed since I have a couple SKs in my log), I just want to update the QSOs that don't have names. I click "No".

Then CQRLOG displays a dialog that says "Updating QSO with" and has a callsign. It goes through every callsign in my log. What is this processes doing, exactly? Is it actually modifying QSOs in my log (the cqrlog_main table), or is it maintaining a separate table? It doesn't seem to change the names of ALL my QSOs, but there are updates on a couple of QSOs, and these are ones that did have names before. I added a field to the MySQL database which contains the current timestamp of when the row was updated, so that I'm able to see if a QSO has been modified.

So... my question is, A) what is database update doing, and B) what exactly does "previous QSOs" mean in the prompt? What if I only want to run database update on highlighted QSOs, would that work?

I'm using 1.4.1 on Xubuntu 11.10 if that helps.

ok2cqr
ok2cqr's picture
Re: Callbook & expected operation of "Database update"

Yes, database update goes through every QSO and update it directly in cqrlog_main database. There is about 1 second delay between requests to qrz/HamQTH server.

If you want to update names from previous QSO, log finds most recent QSO with name and use it also for current callsign.

If you want to run database update only on highlighted QSO, please open it for editting and hit F11 key. It is much faster then create filter with will meet that QSO.

73 Petr, OK2CQR

k0skw
I didn't know about F11! That

I didn't know about F11! That seems to do the trick. Thanks!