<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3676" name=GENERATOR></HEAD>
<BODY>
<DIV><!-- Converted from text/plain format --><FONT face=Verdana>
<TABLE class=maintable cellSpacing=0 cellPadding=0 width="100%" align=center
border=0>
<TBODY>
<TR vAlign=top>
<TD width=16></TD>
<TD class=checkboard width=1><IMG height=1 alt=""
src="http://www.tools4science.de/ext_services/DF0OH/themes/DF0OH/images/pixel.gif"
width=1></TD>
<TD width=16><IMG height=1 alt=""
src="http://www.tools4science.de/ext_services/DF0OH/themes/DF0OH/images/pixel.gif"
width=16></TD>
<TD vAlign=top><BR>
<TABLE cellSpacing=1 cellPadding=0 width="100%" border=0>
<TBODY>
<TR vAlign=bottom>
<TD class=boxtitle align=left>ADIF to KML Convertrer<IMG height=3
alt=""
src="http://www.tools4science.de/ext_services/DF0OH/themes/thebixlight/images/pixel.gif"
width=1></TD>
<TD align=right width="1%"><IMG height=14 alt=""
src="http://www.tools4science.de/ext_services/DF0OH/themes/thebixlight/images/endcap-grey.gif"
width=14></TD></TR>
<TR vAlign=bottom>
<TD class=underline width="100%" colSpan=2 height=1></TD></TR>
<TR>
<TD><A
href="http://www.tools4science.de/ext_services/DF0OH/index.php?module=documents&JAS_DocumentManager_op=viewDocument&JAS_Document_id=6"><IMG
title="ADIF to KML Convertrer" height=315
alt="ADIF to KML Convertrer"
src="http://www.tools4science.de/ext_services/DF0OH/images/pagemaster/kml.jpg"
width=848
border=0></A></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></FONT></DIV>
<DIV>
<H1>ADIF to KML converter</H1>
<P><FONT face=Tahoma><STRONG>Andrew ZL3DW</STRONG> has built an application
which converts ADIF to Excel and then Excel to KML file. </FONT></P>
<P><FONT face=Tahoma>This plots your worked callsigns (if the Maidenhead grid or
field is known) on to Google Earth. In Google Earth, you get a yellow pin
showing the callsign. If you click on the pin you get QSO details and zoom into
the grid square.</FONT></P>
<P><FONT face=Tahoma>License: GNU GPL<BR>The code is free. If you want to use
the code in your project it should be free as well.</FONT></P>
<P><FONT face=Tahoma>What the Program Does<BR>What it does is take a ham radio
log in standard ADIF (Amateur Data Interchange Format) that most electronic logs
support and turns it into a Microsoft Excel File. Then it turns the Excel file
into a Google Earth .kml file. When you load the KML by double clicking the
file, it will automatically start Google Earth. </FONT></P>
<P><FONT face=Tahoma>The KML file will display all log entries that include a
Maidenhead Grid reference as a yellow pin on the Earth. Each yellow pin displays
the callsign of the station and is centred in the centre of the grid square. If
you click the yellow pin, you get a text box showing the QSO details. A double
click zooms in so that the grid square fills the screen view. If you are very
lucky you might even spot the station's Yagi antenna!</FONT></P>
<P><FONT face=Tahoma>The Excel file can also be used for analysing your log
using Excel's math and chart functions. For example a plot of the beam heading
for each QSO. The program calculates the latitude and longitude of each station
that has a Maidenhead grid square listed in the log entry. </FONT></P>
<P><FONT face=Tahoma><STRONG>Harald DL1HW</STRONG> wrote the original ADIF to
Excel code but I modified it a lot. He was very pleased with my additions and
listed the resulting program on his club website. He is happy for me to list it
on my club website as well.</FONT></P>
<P><FONT face=Tahoma>If you list the software my only request is that you
include a note on the download page crediting myself (Andrew Barron ZL3DW) and
Harald DL1HW for the work. Please also state "License: GNU GPL The code is free.
If you want to use the code in your project it should be free as
well".<BR>Notes</FONT></P>
<UL>
<LI><FONT face=Tahoma>You must have MS Excel to use the program. It has not
been tested using any other spreadsheets. </FONT>
<LI><FONT face=Tahoma>You need to have or download Google Earth (It is free)
</FONT>
<LI><FONT face=Tahoma>Your log must support ADIF format (or you could enter
the data into Excel by hand) </FONT>
<LI><FONT face=Tahoma>Your log must have Maidenhead grid squares in 2, 4 or 6
digit format. eg, RE or RE66 or RE66hm (preferably 6 digits). Again these can
be looked up on </FONT><A href="http://www.qrz.com/" target=_blank><FONT
face=Tahoma>QRZ.com</FONT></A><FONT face=Tahoma> or the Internet and added
manually to the Excel file. </FONT>
<LI><FONT face=Tahoma>QSOs without grid references are ignored as there is no
way to calculate the location. </FONT></LI></UL>
<P><FONT face=Tahoma>Link to DF0OH Amateur Radio Club Station Ortsverband A39
Website<BR></FONT><A
href="http://www.tools4science.de/ext_services/DF0OH/index.phpmodule=pagemaster&PAGE_user_op=view_page&PAGE_id=20&MMN_position=33:15"
target=_blank><FONT
face=Tahoma>http://www.tools4science.de/ext_services/DF0OH/index.phpmodule=pagemaster&PAGE_user_op=view_page&PAGE_id=20&MMN_position=33:15</FONT></A><STRONG><BR><BR></STRONG><FONT
face=Tahoma>See also <BR></FONT><A
href="http://www.nzart.org.nz/infoline/promotion/adif2kml.html"
target=_blank><FONT
face=Tahoma>http://www.nzart.org.nz/promotion/adif2kml.html</FONT></A></P>
<P><FONT face=Tahoma></FONT> </P>
<P><FONT face=Tahoma>NZART website </FONT><A
href="http://www.nzart.org.nz/infoline/promotion/adif2kml.html"
target=_blank><BR></A><A href="http://www.nzart.org.nz/" target=_blank><FONT
face=Tahoma>http://www.nzart.org.nz/</FONT></A></P></DIV>
<DIV><BR><BR></DIV></BODY></HTML>