Store Locator using Google Maps API

[aem_visi]

Hi All,

We are currently migrating to AEM 6.1. In our current implementation we have a store locator functionality which we need to migrate to AEM. In the current implementation each store details, including lat and lng are stored in a separate database that will be decommissioned

The store data will be available to us in an Excel format and then it will be imported into AEM

Can you please advice on what will be the best approach when it comes to storing the store information in AEM from the excel sheet and also implementing the store locator functionality in AEM using the Google Maps API?

Thanks in advance

[Ratna_Kumar]

Hi,

We have community articles on storing Excel data into AEM(https://helpx.adobe.com/experience-manager/using/creating-custom-excel-service-experience.html) and also Google maps API with AEM(https://helpx.adobe.com/experience-manager/using/integrating-custom-cq-widgets-third-party.html)

My Idea is as from the above requirement(Storing information in AEM from excel sheet and implementing the store locator functionality using Google Maps API):

We can write an AEM component that uses Java to read JCR nodes & encode to JSON and pass the same to this Google map API and then have the Google MAP API to show up in a AEM JSP page.

I will work on this use case, and I will let you know the result once it works.

Thanks,
Ratna Kumar.

[smacdonald2008]

Ratna is correct - you want to write an AEM service that reads JCR nodes where you store Lat and Long values - based on a specific  condition. For example - show me all points between a specific date range. Then the service can format the data to XML or JSON and pass to the front end component that uses Google MAP API that uses the encoded Data to plot data points.  

Be sure to include the Google MAP APIs as discussed one of the articles that Ranta referenced. 

[kautuk_sahni · Accepted solution]

Hi 

If your "store" data is static, then i would recommend you to bring/Import data to JCR.

Example:- JSON to JCR :- http://asserttrue.blogspot.in/2012/05/importing-json-data-into-java-content.html

Now, create a component/Service as per your use. Keeping it in JCR would reduce number of hops, and would increase performance as well.

One very good old post for you reference:- http://help-forums.adobe.com/content/adobeforums/en/experience-manager-forum/adobe-experience-manage...

I hope this would help you.

Thanks and Regards

Kautuk Sahni

[AEM_Forum]

Hi Kautuk/Ratna,

Is there an example implementation of a Store Locator functionality?

Appreciate your guidance.

Thanks,

Rama.