SQL Console export to ADIF?

9 posts / 0 new
Last post
N0NB
SQL Console export to ADIF?

I've been thinking of participating in the SKCC anniversary as a K3Y op and the log submission is required in ADIF. After having hacked up a nice SQL query to extract exactly the fields needed for the log submission, I find that only CSV and HTML are the supported formats. Oops!

May I suggest that ADIF be added to the export formats of the SQL console?

ok2cqr
ok2cqr's picture
Re: SQL Console export to ADIF?

If you need export to ADIF, please use filter to extract QSO from entire log and in Preferences -> Export you can choose fields to export.

N0NB
Re: SQL Console export to ADIF?

I'll give that a try. Since the SQL console is so powerful, adding ADIF to the SQL Console for a future release would be a very nice addition.

N0NB
Filter works well, but I want more!

So far I've been able to upload my daily log file to the area SKCC coordinator without complaint by using the filter and then export to ADIF. It works very well. Thanks for a nice program

Now for the "but" part. :-)

SKCC offers various awards for the number of unique SKCC members worked. In the filter dialog I can select an award string but I see no obvious way of ignoring duplicate SKCC numbers. Although I've yet to try it, I imagine that I could do so from the SQL Console via a regex. So I hope that adding ADIF export from the SQL console would help me and others a lot and reduce your coding efforts in the Filter dialog. ;-)

ok2cqr
ok2cqr's picture
Re: Filter works well, but I want more!

Hi Nate,

CQRLOG already includes this function :-). If you need only one value from award field, try to use group by function. Choose group by Award in filter window and it will be excactly what are you looking for.

Or if you have set SKCC in membership support, you can choose this club in filter window and choose group by Call. This way doesn't need skcc number in any field.

73 Petr, OK2CQR

N0NB
That works...

as far as it goes.

For example, I am looking at my log for operating K3Y/0. It has 41 records in it. By selecting SKCC in the Membership drop-down and Call in the Group-by drop down, I still have 41 records. I know there are at least two duplicates and one station I worked three times in that log. What I wish to be able to do is eliminate the duplicate numbers/calls and give me a list of each station the first time I worked them based on their SKCC number.

N0NB
Any progress on this?

I played with the SQL console again today and while I can export to an HTML table, an ADIF export option would be superb. I suppose I can write a script to convert the HTML to ADIF, but it's always possible that I'll get the syntax wrong. :-)

ok2cqr
ok2cqr's picture
Re: Any progress on this?

Hi Nate,

I'm sorry no progress.
Problem is with filed names. Result in SQL should include only field names which are in ADIF specification. What with other fileds? Should I suppose all fields in result have the same name as in ADIF spec?

73 Petr, OK2CQR

N0NB
Re: Any progress on this?

Thanks for the reply, Petr.

I guess that I assumed that all of the fields in CQRlog are mapped to corresponding ADIF fields. I suppose that the easiest would be to simply document which fields have corresponding ADIF fields. Then simply don't export those fields which don't correspond while issuing a warning to the user showing the fields that cannot be exported. I would be satisfied with that as a solution.

73, de Nate >>