An extension that will permit us to geolocalize our clients, potentials, tickets or any module with an address using Google Maps or OpenStreetMaps integration.
The coreBOSCRM GeoLocalization Map extension will permit you to locate your clients on a map, searching by different criteria, making programming a route of sales visits, localizing a technician to send to an emergency, or simply finding a set of potential clients for a campaign an easy task.
This is a list of some of the features of the extension:
Let's look into some of these features in detail.
The options in this search tab will permit us to select any combination of existing filters available for each of the three supported modules and have the values marked on the map.
If more than one filter is selected each filter will have a different colored marker and those entities that appear in more than one filter will have their own special colored marker. On the upper right panel of the map section you will find a legend with the different colors assigned.
As an additional helper for searching on the modules, each filter set is followed by a user select box which shows all the subordinated users of the currently logged in user. If a user is selected this condition is ADDED to the selected filters, so they will only show the records that fulfill the filter AND belong to the selected user. This makes it easy to select those records assigned to oneself or to anther given user without having to create specific filters.
The ticket tab will permit us to search for account and contacts associated to trouble tickets. As with the filter tab we are presented with a set of filters that exist on the trouble ticket entity and we can select one or more to have the associated accounts and contacts marked on the map. Also, we find a user capture box where we can restrict the trouble tickets, not only to the conditions of the selected filter but also of the chosen user.
With this setup, for example, we could easily create a filter with open tickets to visit “today” (which would be a custom field) and then search the accounts and contacts that any given user has to see in one day. This is the use case that produced this tab, whereas a company needs to know which technician is around a certain area when an emergency arises.
In this scenario, the technician himself could enter the application. The map extension will automatically center on his position and he could select the new ticket on the map and ask for driving directions with just a few clicks:
This tab is for searching the calendar events. With the different options available we will be able to select a date range and a user to have all those accounts, contacts and leads associated to that user with an event in the selected date range marked on the map.
We can also indicate the entities we want to have shown by clicking on the checkboxes.
This is an easy and powerful way to search for additional clients to visit on certain days that the agenda needs filling. Once you have located some of the clients you can execute an adhoc radius search to see if there is anybody else you could go and visit.
The direct radius search will permit us to find a set of accounts, contacts and leads within a certain circle centered on any latitude and longitude given. Thus the parameters for the search are exactly those: latitude, longitude and radius of the circle. Since the normal situation will be to center the circle on some given entity, we have added an entity capture. If any entity is selected and the latitude and longitude fields are empty, the system will use the coordinates of the selected entity. We have also added a quick capture button with which the user will be able to fill in the latitude and longitude fields using the entity and then adjust accordingly if necessary.
Each marker can be clicked on to obtain a set of information about the entity positioned there. This popup window will contain the name, address and contact information and some action links to work on:
The set of results is shown in a grid list in the right panel, inside the results tab. At the top of the tab we see the full count of results found followed by the grouping option and finally the list of all the records found.
Finally, clicking on the name of the entity will take us to it's detail view inside vtiger CRM.
This tab gives us access to a few variables that we can set on a per user basis. The variables are:
The extension will silently look for the geo position of any record it needs to mark on the map and cache this information forever. All subsequent searches for this record will be read from the cache and never looked up again. This is rather drastic but acceptable in general as it is rare for a company to change their address.
To attend to those situations where a company does change their address and for the situation of new entities that have been created in the application we have created a cron service that will be executed once a day and that will do three tasks:
In other words, thanks to the cron service we can basically forget about the state of the information as it will take care of itself.
This service is automatically installed and configured during the normal installation of the extensions, so all you have to do to get it working is have the base vtiger CRM cron service executed every 15 minutes.
I would like to thank Alan Lord of Libertus for sharing his code as it was a sort of template for us when we got to that point of our development.
We have basically rewritten the whole extension, converting it into an extension and not a module, following vtiger CRM programming guidelines for database access and security, cleaning up the code and adding new user interface and functionality.
In this process we have changed the internal name of the extension and the database tables used to avoid conflict with the open source version of this extension. If you have either the open source version or our previous version you must execute the migration script to copy the geo position data into the new structure.
This is one simple command that must be executed in the browser like this:
This extension is on sale at SIMPLE & LIBRE - VTIGER CRM, Géolocalisation des prospects avec filtrage et sélection autour de "xxx" kms
and directly from us at our online shop EVOSHOPS
This extension is in continuous development with changes to adapt to different requirements of our clients and we are very comfortable with the technology so contact us with your needs and we will do our best to help you.
We are currently developing a new tab for a real estate company, where they will be able to launch a radius search centered on a certain location a client is looking for apartments with certain conditions that the apartments must fulfill. These apartments are products, once we find them we locate them on the map.