Solved

Display opportunity locations on Google map

  • 25 August 2021
  • 5 replies
  • 343 views

Userlevel 3
Badge

A client wishes to display on a Google map the location of each open opportunity in Acumatica.  To be able to visually observe geographicclustering of opportunities.  Any recommendations on how to accomplish this?

icon

Best answer by max75 3 February 2022, 22:29

View original

5 replies

Userlevel 2

I have thought about this -  there is too much heavy lifting for me to do this on my own. 

IF I were to try to do an integration like this, without fully knowing breadth of acumatica - and having some limited programming knowledge myself - I would look to use a tool lIke IBM’s node red. 

This would allow you to login, and perform a cron task I believe.  You would be able to easily check for additions to the file, then could have the flow execute an update.(through a secondary flow) Logs in to acuamtica, and updates the data for you. 

 

I have not used with acuamtica, but have used with other IOT integrations, AWS etc. NODE red is something that would allow you to accomplish what you may not be able to manually code for. Someone more proficient than me could probably create a sample flow that would work for most use cases, changing login info and database and or screen source. 

 

This article below may be a starting point if you are ambitious enough (to be clear I have no affiliation with either node red or below!). 

https://www.cdata.com/kb/articles/apiserver-node-red.rst

Userlevel 3
Badge

@asmith50 @max75 I should have mentioned in my question that I’m looking for a way to automate or semi-automate it.  I too have successfully exported the information from Acumatica and imported it into a Google map.  The result is exactly what I want, similar to the screenshot @max75 posted.  I’ve even configured a dashboard in Acumatica which displays the map.  What I now need to determine is how to periodically refresh the map to reflect changing opportunities in Acumatica.  It need not be realtime, refreshing daily overnight would be suitable.

Userlevel 2

I just tested this  - and it works far better than I thought as straight import. 

 

 

Userlevel 2

In Opportunities: 

  1. Adjust Colum View Screen to show address field, City Zip ETC.
  2. Export to Excel
  3. Import into Google Maps. 

You could probably Set up a Cron Task to export this @ specific frequency, and get a bit more fancy - but this should suffice. 

Userlevel 3
Badge +1

@john55 Did you ever find a solution to this?

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved