Methodology of producing the Google Map with all the Customer points plotted

After the research at the store

Recorded the longitudes and latitudes from Google Earth in a spreadsheet for each customer point

Only needed the seconds because the minutes and degrees were all the same.

Converted the seconds recorded in to decimal longitudes and latitudes

Longitude = -2.5833333 + (seconds / 3600) and Latitude = 51.45 + (seconds/3600) where -2.5833333 and 51.45 are the constants for every point.Then saved the spreadsheet as a CSV file

Wrote and host the php file that reads the CSV file and outputs the KML.

XML file outputed by the code below

CSV file

			
<?php
echo ‘<?xml version=“1.0” encoding=“UTF-8”?><kml xmlns="http://www.opengis.net/kml/2.2”><Document>’;
	$file = fopen(“competitor_positions1.csv”, “r”);
		if (!$file) {echo ‘Error getting menu data’;}
		while($map_item = fgetcsv($file,1000)){
			echo “<Placemark<>name>”;
			echo $map_item[0];
			echo ‘</name><description>’;
			echo ‘<![CDATA[<p><img style=“float:right;” src=“http://www.martinfrancis.org/addon_uwe/friska_2.0/friska_competitors_small/’ . $map_item[5] .  ‘.jpg” /></p>]]>’;
			echo ‘</description>Point<<coordinates>’;
			echo $map_item[4] . ‘,’ . $map_item[2] . ‘,50’;
			echo “</coordinates></Point>/Placemark<”;
		}
		fclose($file);
echo ‘</Document></kml>';
?> 


			

Copied and pasted the URL of the php file into Google Maps

The result of which can be seen above