Sorting by Land [solved]

4 posts / 0 new
Last post
dl5ybz
Sorting by Land [solved]

Would be nice to have to option to group the QSOs by land and sort the land group by alphabetical order before start the QSL label export.

The goal should be a label line up just in the order requested by some QSL bureaus to avoid any further sorting by hand.

(I have no idea, if this kind of order is used by all bureaus .. but sorting by land should always be welcome :-) )

73 de Olaf / DL5YBZ

ok2cqr
ok2cqr's picture
Re: Sorting by Land

Hi Olaf,

grouping by land is already there. It is item called dxcc_ref. Sorting by land (dxcc_ref) will be in next release.

73 Petr, OK2CQR

dl5ybz
Re: Sorting by Land

Petr,

yes, I noticed the dxcc_ref field but I found no way to group the table by this field ..running 0.6.0 under Debian (etch and unstable on different machines)

My idea is to get a sorted file for QSL lable export like this :

G0aaa
M0aaa
.
F6ddr
.
Da0aaa
db2aaa
Dc0aaa
dc1aaa
Df1aaa

etc..

So all Lands in one Block, but this block sorted by the prefix.

But I guess, you already got my intention.. sorry for my poor English :-)

A real powerful feature would be a kind of SQL scripting allowing to query the log database for all needs.. but of course this is a tool that really needs a excellent documentation or a perfect "idiot proof" GUI to work without pain :-)

I'm only a stupid "use what you need" MySQL user... so maybe my ideas are far away from the options, firebird base offers.

(but I really would like to avoid any kind of Export as ADIF -> convert ADIF to MYSQL -> Import MySQL -> Do all your queries to MYSQL Database ..queues .. this would ne a shame because your fine log has such a bit potential to meet all my needs .. and it is really my every day used tool!)

73 de Olaf /dl5ybz

ok2cqr
ok2cqr's picture
Re: Sorting by Land

Hi Olaf,

you don't need new group by function. You probably need sorting by dxcc_ref and call. Group by means, that CQRLOG chooses only one record from group of record. E.g. you choose group by dxcc_ref, program selects only one station from each dxcc country.
I'll add sorting by dxcc_ref and call.

CQRLOG already has SQL console. But it is only for debugging without any support for export or other operations. Maybe in the future, I'll add user friendly SQL console.

You can install full version of Firebird 1.5 and use Flamerobin to connect to cqrlog database. This nice and very powerful tool could helps you. But be careful, you can damage log database!

73 Petr, OK2CQR