ADIF-Calc-KML Converter by DL2KI
When searching for a software for editing already logged data outside of the logging program, I came across the ECXEL solutions:
to Excel code by DL1HW and
Excel to KML code by simon_a with mods by ZL3DW (Andrew Barron)
In principle, the applications were in line with what I was looking for.
I have been looking already for some time for a project to start programming of OpenOffice.org Calc. Here seemed to be a good opportunity.
From this work, there came the presented OpenOffice.org Calc workbook. While working on the project there came always more and more ideas for possible use. The application is therefore not intended as a finished product but as a basis for those who also want to deal with the programming of an OpenOffice application and want to contribute their ideas in the application.
The workbook was created on Linux using OpenOffice.org version 3.2.0 and Windows XP Version 3.2.0.
The complete VBA code has been revised or re-programmed. Service macros were combined in the module "Lib". The respective sources are given there.
core routine in ADIF import has been reprogrammed as a state
machine. This solution is
clear, easily extendable and faster.
The KML Export for Google Earth was installed and fixed code segments for KML was integrated in the source code. For QRO and QRP different pins are selectable. Decimals require a decimal point.
A special user interface (forms) was not installed. This leaves room for improvement for interested parties.
The ADIF data is loaded into a Calc spreadsheet. Here, the formatting of the data is matched. The name and QTH fields are converted in uppercase.
From the data an extra statistics page is created. The data is displayed in diagrams as well.
Furthermore a table where QRP-Call are marked is created. This table is intended for the portable operation to quickly check for dupes. An additional digit markers can be added. At the beginning of the field "NOTES" the label "# [0-9]" is checked.
This workbook is a programming exercise for the author to start programming OpenOffice. It is therefore assumed that a lot can be done better. The error handling is certainly for improvement.
is not intended to provide user support to a greater extent. The
to invite others to program themselves in the first place:
Pse feel free to copy and modify.
If you use the code in your application it is supposed to be free as well.
OpenOffice.org dialogs" with Linux: If the option is not
selected, it is going to crash.
Use when opening files. The cause is still being determined.
ensure free choice of default headers, I have adapted different
(Sortieren01 "," sortieren02 ", error handling) Currently, a fixed position of the columns "QSO_DATE" or "CALL" is given.
The error handling needs to be updated and completed.
Notes and User Interface
ADIF data import
In the yellow box "working directory" the last selected path is stored by the program. If the field is deleted before the import, Calc opens the file selection dialog, the Default directory.
The header specification meets the requirements of the logbook software used by me "CQRLog" by
OK2CQR and OK1RR. There are 3 different default columns can be selected in the entry cell "D13" .
Input from users are to be made only on the first page, in the pale yellow shaded cells.
Some of the cells are deposited with selection lists.
Only records where the "grid square" is not empty and the content has a length of 4 or 6 characters will be exported.
The imported records in the worksheet "Log" are now available for further processing.