* A Plugin for a CSV Spreadsheet for Google Earth

[ColinBeaver]

This posting is a continuation from my posting on the General Usage Forum Creating CSV Spreadsheet for Importing into Google Earth (13845).

With the help of Mike Tatewise I have to create a

Fact Query
provides the Name, Record Number, Relationship, Fact, Fact Date & Location (Address + Place).

Repository Query
Output from the Map Life Facts is used to provide the Latitude & Longitude.

Using mail merge and capitalising the first letter in the "Relationship", produces an output via KML into Google Earth

Name - RecordID, Name & Relationship

Description - Fact, Fact Date @ Location

As someone with programming experience but a LUA novice, I am now looking to design a Plugin to automate this process. My first thought is to amended the Map Life Fact Plugin to output the data in tabular form.

Any help, suggestions or advice would be welcome.

[tatewise]

Colin, especially as a novice, I advise you do not attempt to customise my Map Life Facts Plugin, because it is very complex.

Start with plugins:index|> Family Historian Plugins under Developer Guide especially plugins:getting_started|> Getting Started Writing Plugins and the FH Tools » Plugins » More » How to Write Plugins plus the http://www.lua.org/manual/5.1/.

You can plagiarise any of the Plugins in the Plugin Store and the Forums plus the plugins:code_snippets:index|> Code Snippets.

The design will mimic the Fact Query and Repository Query to create data tables.
Capitalising the Relationship is straightforward and updates the data tables.
The KML file(s) can be written with data compiled from the the tables.
It may also be possible to send each KML file to Google Earth.

Once you have got past the basics, I am happy to advise on Lua techniques.
BTW: Do not underestimate Lua tables that are extremely powerful and flexible.

[ColinBeaver]

Back in 2016 I was able to upload my Family Tree Location in full.

It was rather labourious and I never found the time to write a LUA Plugin.

I have recently found the following website

https://myengineeringworld.net/2014/06/ ... e-api.html

This gives a VBA programme, which I have successfully inserted into my spread sheet to generate the Latitudes and Longitudes.

Like the plugin Life Facts you need an api key.

Also your address field has to have sufficient detail, for example all my Church entries give the street name etc.

You will have the usual errors if the street does not exist or in one of my addresses North Carr is listed by Google earth as N Carr.
ps if you are running Excel prior to 2013, you need to remove the Encode URL