This is part of the Step by Step Guides
to get started with some of the more complex topics on this site. The full story on marker parameters can be found at Complete Excel Address Data with Google Mapping API
What you needGoogleMapping.xlsm
from the Download Complete Projects
To be able to modify parameters according to How to put markers on maps
Mapping activities, are controlled
by 2 parameter sheets. One is general, and tells the procedures how to
deal with the data returned from the various mapping providers
(geoCodingParameters worksheet) and the other is specific to particular
sets of data or desired results (in this case 'step by step parameters')
to the geoCoding parameters sheet. You will see that the blocks of parameters are divided up into sections separated by a blank line. In general there is not much here you need to change, as most of it is specifiying how to handle the data that comes back from the Mapping API.
- Getting your own Key. If you are using Bing or Yahoo for geoCoding, you will need to get your own API key and modify the appropriate parameter section.
- I recommend that you leave all the other geoCoding parameters alone. For advanced usage see GeoCoding
Mapping Parameters - geoCoding parameter sheet
Mapping Parameters - project specific sheet
- In addition to the geoCoding specific parameters, this parameter sheet also contains common code, parameters and data. The markers section defines in which column in your input sheet to find the data required for mapping.
- Filenames can also be set here. These are the names of the .html files to generate. For example, this specifies where to put any KML files that you choose to generated and where to put them
- For mapping purposes, each project has its own parameter sheet in addition to the shared geoCoding parameter sheet. In this case our sheet is called Step by Step Parameters. Go there to look at the project specific parameters
- This sheet contains mainly parameters for the Data Driven Mapping applications which we will cover in a later step by step tutorial. However there are some mapping and geocoding parameters here too. These fields must be present in any dataset needing geoCoded. You can modify the Column Name to match your data if necessary.
- This defines the name of the worksheet containg the data to be mapped, along with the unique ID column for the data that you specified above.
No more steps. That's all the parameters that apply to geoCoding and Mapping
What just happened ?
All the parameters needed to support How to Geocode addresses using Google Maps
and How to put markers on maps
are now related to your data.
Read more about the detail of how all this works and walk through the source code at Mapping and adding markers to maps
or see some more Step by Step Guides
. In the meantime why not join our forum
,follow the blog
or follow me on twitter
to ensure you get updates when they are available.