Introduction

Google maps is a excellent tool to enrich the reporting activities in any company. Normally, when you have to make any Sales Analysis, you use your ERP modules to know the health of your sales resources, then you use the sales reports that any ERP offers but you don`t have any report to 'see' customers, shops, salespersons, etc.. in any map.

Google solves the problem with Google Maps. The glue to join your ERP data with Google Maps is the new JavaScript Class, GClientGeocoder();

The Javascript Class GClientGeocoder(); is a new class in Google Maps Version 2. The use of GClientGeocoder() is very easy.

1. Extract full address to study from your ERP
2. Evaluate that address in Google Maps
3. See it in the map!

In this document, I am going to use Foodmart database to demostrate the use of Google Maps.

To see the data model of the database, See the model

Examples

• Global Sales
• Customers of any Store

Software

The software that you need to use Google Maps:

• XAMPP, http://www.apachefriends.org/en/xampp.html
• MySQL ODBC Driver http://www.mysql.com/
• MySQL Migration toolkit http://www.mysql.com/
• Sales Database foodmart_2000.mdb http://acs.senecac.on.ca/ftp/ms/foodmart_2000.mdb
• Squirrel SQL http://squirrel-sql.sourceforge.net/
• Google Maps http://www.google.com/apis/maps/