Skip to main content
Solved

Display opportunity locations on Google map


Forum|alt.badge.img

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?

Best answer by max75

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. 

View original
Did this topic help you find an answer to your question?

5 replies

asmith50
Jr Varsity III
Forum|alt.badge.img+1
  • Jr Varsity III
  • 67 replies
  • February 3, 2022

@john55 Did you ever find a solution to this?


max75
Freshman II
  • Freshman II
  • 10 replies
  • Answer
  • February 3, 2022

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. 


max75
Freshman II
  • Freshman II
  • 10 replies
  • February 3, 2022

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

 

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • 24 replies
  • February 9, 2022

@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.


max75
Freshman II
  • Freshman II
  • 10 replies
  • February 9, 2022

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings