Jump to content
Great War Forum

Remembered Today:

Alecras234

just a thought

Recommended Posts

Alecras234

is this right?  i have 2 files, one called lancashire and this one.   The lancashire won't paste nor can i attach it to heretest.kml

Share this post


Link to post
Share on other sites
WhiteStarLine

Fantastic!  You are so close and I can see the error instantly.  Remember there were several towns that I was unsure of - they had identical names or I could not find a latitude / longitude.  You left them in.

 

Remove them!  Save the file.  You are almost done my friend!!!

 

So, remember there was an error in line 11?  Line 11 has the work Givry.  Nothing else on the line.  Remove it

Now, see line 18 - it just has the word Villers Cotteretts.  Nothing else on the line.  Remove it.

 

Ditto for every blank line.  Then go to Westouter.  That is the last place he visited.  For some reason you've copied the entire file twice.  Delete every line after Westouter.

 

I think it will now work.  However, you've copied the cells with the raw description as well.  Here is line 1:

 

North Camp Farnborough    -0.747945    51.2758547                Rouen        <Placemark><name>North Camp Farnborough</name><Point> etc

It should just read:

<Placemark><name>North Camp Farnborough</name><Point><coordinates> etc

 

You might want to clean this up even though Google Maps is clever enough to work.

 

Let us know how you go - I think we're almost there now.  While you left out the header lines and the footer, it appears that Google Maps will still work.  Otherwise it is 30 seconds to fix.

Share this post


Link to post
Share on other sites
Alecras234

I can't send the excel data, everytime i open or try to attach it, it says saved as wrong file.    This is heavy going, i thought it would be easy.    Is the a video i can watch showing me on youtube?

Edited by Alecras234

Share this post


Link to post
Share on other sites
WhiteStarLine

You told us there was an error in the kml file and Google identified it on line 11.  You attached test.kml.  I told you that the error on line 11 could be fixed by removing the work Givry from line 11 (and removing similar errors).  Then I suggested you save the file and ran it again.  You have returned with a query about Excel data.

 

In another post I told you to copy column K from Excel into Notepad and add a few lines to the top and 2 lines to the bottom.  You copied 4 or 5 columns from Excel file into Notepad but not the top and bottom lines I supplied.

 

So let us start again.  Please open test.kml in Notepad and make the corrections from post #27 and save it.  Import it into Google Maps and let us know how you go.  Please don't open any other file but test.kml.  I am very happy to help and get you going so you are comfortable doing this for other battalions.

Share this post


Link to post
Share on other sites
Alecras234

Ok im sorry, i haven't used excel or notepad, microsoft word in years since i was at school so i have forgotten things.   Here is test.kml file and as you can see all the information is scattered, i cant tell what's what.    Do i need to organize the data so it's easier to read or is it like that anyway?   

test.kml

Share this post


Link to post
Share on other sites
WhiteStarLine

No need to apologise, we are all here to help and it took me a few years to become proficient (and I've still much to learn from members of this forum)!  Do 3 or 4 of these in the next few months and we will be asking you to help us ...

 

I've corrected test.kml by adding 9 lines at the top, 2 at the bottom and then a series of lines in the middle that look like this.

 

Placemark><name>North Camp Farnborough</name><Point><coordinates>-0.747945,51.275855</coordinates></Point><LookAt><longitude>-0.747945</longitude><latitude>51.275855</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>South Farnborough Station</name><Point><coordinates>-0.755726,51.296605</coordinates></Point><LookAt><longitude>-0.755726</longitude><latitude>51.296605</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Port of Southampton</name><Point><coordinates>-1.419944,50.891219</coordinates></Point><LookAt><longitude>-1.419944</longitude><latitude>50.891219</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>

 

Then I tested it in Google Earth and Google Maps.  Here is a link to your file in Google Maps.  Looks good.

 

Here is the corrected test.kml.  Paste it into Notepad or download it.

 

 

<?xml version="1.0" encoding="utf-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2" xmlns:gx="http://www.google.com/kml/ext/2.2">
  <Document>
    <name>Loyal North Lancashire Regimental Journey, Farnborough to Ypres, 1914</name>
    <!-- The long, long trail from England to the Battle of First Ypres in 1914 -->
    <open>1</open>
    <description>
      In Google Earth, click on each placemark to sail to that point.
    </description>
<Placemark><name>North Camp Farnborough</name><Point><coordinates>-0.747945,51.275855</coordinates></Point><LookAt><longitude>-0.747945</longitude><latitude>51.275855</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>South Farnborough Station</name><Point><coordinates>-0.755726,51.296605</coordinates></Point><LookAt><longitude>-0.755726</longitude><latitude>51.296605</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Port of Southampton</name><Point><coordinates>-1.419944,50.891219</coordinates></Point><LookAt><longitude>-1.419944</longitude><latitude>50.891219</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Le Havre</name><Point><coordinates>0.114084,49.484201</coordinates></Point><LookAt><longitude>0.114084</longitude><latitude>49.484201</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Rouen</name><Point><coordinates>1.056068,49.44132</coordinates></Point><LookAt><longitude>1.056068</longitude><latitude>49.44132</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Gare de Saint-Denis</name><Point><coordinates>2.350234,48.94386</coordinates></Point><LookAt><longitude>2.350234</longitude><latitude>48.94386</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Amiens Railway Station</name><Point><coordinates>2.30982,49.88993</coordinates></Point><LookAt><longitude>2.30982</longitude><latitude>49.88993</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Cambrai Railway Station</name><Point><coordinates>3.24129,50.177</coordinates></Point><LookAt><longitude>3.24129</longitude><latitude>50.177</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Le Nouvion</name><Point><coordinates>3.785,50.01722</coordinates></Point><LookAt><longitude>3.785</longitude><latitude>50.01722</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Esquéhéries</name><Point><coordinates>3.74639,49.98389</coordinates></Point><LookAt><longitude>3.74639</longitude><latitude>49.98389</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>La Fontaine</name><Point><coordinates>3.51667,50.63333</coordinates></Point><LookAt><longitude>3.51667</longitude><latitude>50.63333</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Maubeuge Railway Station</name><Point><coordinates>3.96634,50.27251</coordinates></Point><LookAt><longitude>3.96634</longitude><latitude>50.27251</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Villers-sire-Nicole</name><Point><coordinates>4.01379,50.33911</coordinates></Point><LookAt><longitude>4.01379</longitude><latitude>50.33911</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Givry</name><Point><coordinates>4.53694,49.48927</coordinates></Point><LookAt><longitude>4.53694</longitude><latitude>49.48927</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Havay</name><Point><coordinates>3.98366,50.36118</coordinates></Point><LookAt><longitude>3.98366</longitude><latitude>50.36118</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Fiegnies (Feignies)</name><Point><coordinates>3.876752,50.29107</coordinates></Point><LookAt><longitude>3.876752</longitude><latitude>50.29107</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Guise</name><Point><coordinates>3.552745,49.897202</coordinates></Point><LookAt><longitude>3.552745</longitude><latitude>49.897202</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Soissons Railway Station</name><Point><coordinates>3.33833,49.36917</coordinates></Point><LookAt><longitude>3.33833</longitude><latitude>49.36917</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Villers-Cotterêts</name><Point><coordinates>3.035657,49.220175</coordinates></Point><LookAt><longitude>3.035657</longitude><latitude>49.220175</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Priez</name><Point><coordinates>3.252743,49.130824</coordinates></Point><LookAt><longitude>3.252743</longitude><latitude>49.130824</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Moulin</name><Point><coordinates>3.56667,50.71667</coordinates></Point><LookAt><longitude>3.56667</longitude><latitude>50.71667</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Vendresse</name><Point><coordinates>3.66722,49.42722</coordinates></Point><LookAt><longitude>3.66722</longitude><latitude>49.42722</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Troyon</name><Point><coordinates>4.932444,48.999014</coordinates></Point><LookAt><longitude>4.932444</longitude><latitude>48.999014</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Cerny-en-Laonnois</name><Point><coordinates>3.66778,49.44333</coordinates></Point><LookAt><longitude>3.66778</longitude><latitude>49.44333</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Paissy</name><Point><coordinates>3.681886,49.425554</coordinates></Point><LookAt><longitude>3.681886</longitude><latitude>49.425554</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Fismes</name><Point><coordinates>3.667431,49.312549</coordinates></Point><LookAt><longitude>3.667431</longitude><latitude>49.312549</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Gare de Saint-Denis</name><Point><coordinates>2.350234,48.94386</coordinates></Point><LookAt><longitude>2.350234</longitude><latitude>48.94386</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Amiens Railway Station</name><Point><coordinates>2.30982,49.88993</coordinates></Point><LookAt><longitude>2.30982</longitude><latitude>49.88993</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Abbeville</name><Point><coordinates>1.817628,50.10023</coordinates></Point><LookAt><longitude>1.817628</longitude><latitude>50.10023</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Gare de Boulogne</name><Point><coordinates>1.607844,50.714156</coordinates></Point><LookAt><longitude>1.607844</longitude><latitude>50.714156</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Gare de Calais Ville</name><Point><coordinates>1.846983,50.949521</coordinates></Point><LookAt><longitude>1.846983</longitude><latitude>50.949521</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Cassels</name><Point><coordinates>2.481074,50.794556</coordinates></Point><LookAt><longitude>2.481074</longitude><latitude>50.794556</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Steenvorde</name><Point><coordinates>2.58244,50.81046</coordinates></Point><LookAt><longitude>2.58244</longitude><latitude>50.81046</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Poperinghe</name><Point><coordinates>2.6875,50.85488</coordinates></Point><LookAt><longitude>2.6875</longitude><latitude>50.85488</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Boesinghe</name><Point><coordinates>2.854583,50.89568</coordinates></Point><LookAt><longitude>2.854583</longitude><latitude>50.89568</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Pilckem</name><Point><coordinates>2.88562,50.89979</coordinates></Point><LookAt><longitude>2.88562</longitude><latitude>50.89979</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Bixchoote (Bikschote)</name><Point><coordinates>2.86479,50.92557</coordinates></Point><LookAt><longitude>2.86479</longitude><latitude>50.92557</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Ypres</name><Point><coordinates>2.86733,50.85704</coordinates></Point><LookAt><longitude>2.86733</longitude><latitude>50.85704</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Hooge</name><Point><coordinates>2.92377,50.83747</coordinates></Point><LookAt><longitude>2.92377</longitude><latitude>50.83747</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Veldhoek</name><Point><coordinates>3.36023,51.1944</coordinates></Point><LookAt><longitude>3.36023</longitude><latitude>51.1944</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Polygon Wood (near)</name><Point><coordinates>2.98333,50.85</coordinates></Point><LookAt><longitude>2.98333</longitude><latitude>50.85</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Guluveldt [Geluveld]</name><Point><coordinates>2.99343,50.83511</coordinates></Point><LookAt><longitude>2.99343</longitude><latitude>50.83511</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Veldhoek</name><Point><coordinates>3.36023,51.1944</coordinates></Point><LookAt><longitude>3.36023</longitude><latitude>51.1944</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Vlamatinghe</name><Point><coordinates>2.82024,50.85485</coordinates></Point><LookAt><longitude>2.82024</longitude><latitude>50.85485</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
<Placemark><name>Westouter, Heuvelland Belgium</name><Point><coordinates>2.737682,50.797161</coordinates></Point><LookAt><longitude>2.737682</longitude><latitude>50.797161</latitude><altitude>40000</altitude><heading>0</heading><tilt>0</tilt><altitudeMode>absolute</altitudeMode></LookAt></Placemark>
  </Document>
</kml>

 

 

 

test.kml

Share this post


Link to post
Share on other sites
WhiteStarLine

Once you've cracked this, most of us use an editor that makes it visually easy (or use Excel's concatenate feature).  I use Notepad++ a lot as it colours the syntax I need for KML.

 

image.png.c09cf84c4ed44f6d30c5d7abaf55bdeb.png

Share this post


Link to post
Share on other sites
Alecras234

i have copied and pasted the info as test1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...