Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Is it possible to get the address button (compass) in Customer Maintenance to go to Google maps?

  • 1.  Is it possible to get the address button (compass) in Customer Maintenance to go to Google maps?

    Posted 06-19-2019 16:51
    Customer reporting that Mapquest is giving an error and asking can that be changed to Google Maps?

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------


  • 2.  RE: Is it possible to get the address button (compass) in Customer Maintenance to go to Google maps?

    Posted 06-19-2019 18:10
    No unless they scripted their own solution to use Google Maps API. Besides coding it requires registration / sign-up with Google to use their API and costs money if monthly volume of requests is high enough. Map button not working for me either. The Sage web service services.bestsoftwareinc.com is what sends the address data to Mapquest so that's not in our control. Sage web service itself appears to be OK and in my example for an address in XYZ company receives this URL: 

    http://services.bestsoftwareinc.com/services.asp?sid=4&regid=&address1=8800%20irvine%20center%20drive&address2=&city=irvine&state=ca&zip=92714

    This part is working. It forwards the address fields to the Mapquest API which redirects the URL to mapquest.com. However Mapquest itself is not servicing the request any further so the only thing appearing in your browser is www.mapquest.com (no address tags after it). I'm thinking either the API changed (maybe it now requires registration like Google Maps API) OR their own web service is just down. But try it yourself in Customer Maint to verify.

    ------------------------------
    Alnoor Cassim

    Free Agent Developer and Consultant
    CallForHelp.biz
    Email: alnoor@callforhelp.biz
    Orange County, CA
    ------------------------------



  • 3.  RE: Is it possible to get the address button (compass) in Customer Maintenance to go to Google maps?

    Posted 06-19-2019 19:06
    Edited by Dan Burleson 06-19-2019 19:22
      |   view attached
    The attached Custom Office button script (5 lines) attached to a provided "Compass" image (..\MAS90\Home\_Lib_BMP) works for single line addresses, City State & Zip. WARNING!!! Does not include the Starbucks coffee stop as Steve Malmgren's does.

    Image Provided in ..\Home\Lib\_Bmp

    Google Maps Result

    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------

    Attachment(s)

    txt
    GMaps.txt   336 B 1 version
    Original Message


  • 4.  RE: Is it possible to get the address button (compass) in Customer Maintenance to go to Google maps?

    Posted 06-19-2019 19:25
    Nice! Thanks. I am going to see if I can get this to work. (said the neophyte coder)

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------

    Original Message


  • 5.  RE: Is it possible to get the address button (compass) in Customer Maintenance to go to Google maps?

    Posted 06-20-2019 11:55
    Well the script is pretty much useless if the user doesn't know where to get a quick cup of coffee.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


  • 6.  RE: Is it possible to get the address button (compass) in Customer Maintenance to go to Google maps?

    Posted 06-20-2019 10:49
    Edited by Bob Sosbee 06-20-2019 10:49
    From the MapQuest API FAQs about what happens if Sage exceeds their transaction limit or their key expires:

    Once you reach your monthly transactions limit (using any of the AppKeys associated with the account) any new transactions will fail unless you have opted into overages. Overage plans allow you to go over your monthly quota by purchasing small block of additional transactions. If you are already on the Business Plus plan (the highest Self-Serve plan) and need additional transactions, please contact us to discuss Enterprise Edition licensing options.

    Using the script suggestions works because your customer's volume is unlikely to be high enough to trigger Google's licensing flags.

    ------------------------------
    Bob Sosbee
    Senior Developer
    Accounting Systems, Inc. (ASI)
    Covina CA
    803-252-6154 x245
    ------------------------------

    Original Message


  • 7.  RE: Is it possible to get the address button (compass) in Customer Maintenance to go to Google maps?

    Posted 06-19-2019 18:51
    Here's a couple of screen shots of the code that Steve Malmgren of Sage wrote several years ago and published a video.  You could create your own button script and call the program.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------



  • 8.  RE: Is it possible to get the address button (compass) in Customer Maintenance to go to Google maps?

    Posted 06-20-2019 11:44
    Bob, so Sage pays a set amount for each user?  And this particular user exceeded their limitation?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 9.  RE: Is it possible to get the address button (compass) in Customer Maintenance to go to Google maps?

    Posted 06-20-2019 12:30
    Sage is paying for a Business API license through their web site bestservices.com/services.  Either they haven't paid the renewal or the volume of requests exceeded their quota.  They are aggregating all of the requests through their web site, like they do with iShip and tracking requests.  Which is puzzling, because UPS/FedEx/USPS don't charge for tracking requests, but mapping APIs typically do.

    With the script, I doubt that the end user IP address will trigger the threshold for Google to show a page that says you need to license the API.  MapQuest on the other hand, will trigger almost immediately because you need an API key.

    ------------------------------
    Bob Sosbee
    Senior Developer
    Accounting Systems, Inc. (ASI)
    Covina CA
    803-252-6154 x245
    ------------------------------

    Original Message


  • 10.  RE: Is it possible to get the address button (compass) in Customer Maintenance to go to Google maps?

    Posted 06-20-2019 12:36
    With couriers the tracking links are a perk but they make their money on delivery services.  With mapping, the map is their product, so more controls are understandable.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


Related Content