Where is the HamQTH info stored.

6 posts / 0 new
Last post
N3MOW
Where is the HamQTH info stored.

Petr,
 
I use CQRLog mainly because of the HamQTH lookup. There are many other reasons too. I noticed that the name and address info does not appear to be stored in the database. If you view a past QSO that info does not appear. I looked in the database, using sql, and could not find it. Is it retained any where?
If not it would be a good addition. With that info I could print mailing labels as well as qso info. Is there a work around? Perhaps a user field or remarks to call sign.
 
73,
Marty, N3MOW

ok2cqr
ok2cqr's picture
Re: Where is the HamQTH info stored.

Marty,
 
cqrlog doesn't store the address anywhere. I'm sorry, it seems there is no work around for that. CQRLOG only show the address in the callbook box and nothing more.
 
There is address tag for it in ADIF spec. I'll add the address there. There is another problem - how to separate easch line of the address. gLabels uses ',' as separator, I can't use it to separate address lines.
 
I'll think about that.
 
73 Petr

N3MOW
Petr,

Petr,
I've found a work around that will work for me. I need some information on the database. If I cut and paste the HamQTH info into remarks I can get it with an SQL query. I would like to use the comments to callsign field as that would leave the remarks field open.
From the help files I see there is a table called remarks which has the call and comment data. If I try a simple select query on this table it errors out. Table cqrlog001.remarks does not exist. Yet it looks like it is created when the program is installed.
The question is how can I access this table and can I write an inner join type query to get both qso data and match it to the remarks table data? If so I can generate a CSV file containing the address data.
 
 
 

Marty, N3MOW

ok2cqr
ok2cqr's picture
Re: Where is the HamQTH info stored

Marty,
 
there are two types of remarks. One related to QSO (Comment to QSO)  and other related to callsign (Comment to callsign). Comments to QSO is stored to cqrlog_main table into field called remarks. The comment related to callsign is stored into table called notes.
 
Structure of notes database is id_notes;callsign;longremarks
 
It seems the help file is outdated a bit, I'll fix it.
 
73 Petr, OK2CQR

ok2cqr
ok2cqr's picture
Re: Where is the HamQTH info stored
N3MOW
Petr,

Petr,
Thanks for the information. It was just what I needed to test my idea. First I cut and paste the HamQTH information to the "Comment on Callsign" field. Then I change the carrige returns to semicolons. this give one log string. Then save the record.
I run a compound SQL query using cqrlog_main joined to notes on callsign. This gives me the callsign and longremarks (for a given date range defined in a where clause). The data returned is exported as a .csv file.
When the exported .csv file is opened in Excel, using the semicolon as the delimeter the longremarks field is broken out into descrite fields. The only problem I have is there seems to be no way to change the delimiter in the CQRLog export file. It would be nice if the delimter could be a comma but I can work around this.
73,
Marty, N3MOW

Marty, N3MOW