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(“customer_map_positions.csv”, “r”);
				if (!$file) {echo ‘Error getting map data’;}
				while($map_item = fgetcsv($file,1000)){
					echo “<Placemark><name>”;
					echo $map_item[0];
					echo ‘</name><description>’;
					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