FAQ

 

Installation

Can I install GeodesiX for all users of my PC?

No, not for the moment.

Excel user-defined functions (UDFs) exist on a per-user basis only. This is by design and applies to all versions of Excel since 2000.

I have created a prototype which allows UDFs to register automatically at logon, but it is not yet ready for distribution.

Do I need administrative privileges to install GeodesiX?

No, GeodesiX is a per-user intall.

However, GeodesiX requires the .Net Framework 4, installing that might require administrative privileges.

Does GeodesiX work behind proxies and/or firewalls?

Yes, GeodesiX connects to GoogleMaps in exactly the same way as your web browser; if you can browse the web with Internet Explorer, GeodesiX will work.

That said, proxies and firewalls can be configured in many devious fashions and there might be situations in which GeodesiX won’t work. If you think that your having proxy/firewall problems, run the Troubleshooter

Usage

I need to (reverse) geocode 27’000 places. Can Geodesix do this?

No.

GeodesiX uses the GoogleMaps geocoding service, which has some usage limits.

In a nutshell, you may not make more than 2’500 geocode requests in a 24-hour period. GeodesiX will enforce these limits, so
please use this free service responsibly.

Can I display more than one place at a time on the map?

Yes. Here’s how:

  1. If the map pane isn’t currently displayed, click on the map icon in the GeodesiX toolbar to make the map pane appear
  2. In the map sheet dropdown, pick an empty worksheet (any old worksheet will do)
  3. When prompted if you want to create and Office Finder, click ‘yes’
  4. A new worksheet will be added to your workbook, containing a sample list, the capitals of the European Union
  5. During a few seconds, you will see the latitude and longitude fields being populated
  6. When they have all displayed, return to the map sheet dropdown and select the name of the worksheet that has just been created. A map of Europe will appear, with the countries’ flags on the capitals
  7. Click on the map to find the 5 nearest capitals. Hover over an orange line to see the distance
  8. Click on a flag to see details about the country

Take a moment to examine the formulas in the spreadsheet that was created for you. They illustrate how you can create maps with your own places, custom icons and popup texts.

Why the long name ‘GreatCircleDistance’ instead of GCD?

Because =GCD() is the Excel function for Greatest Common Divisor

Are there any limits on Geocoding?

Yes. You should read GoogleMaps terms of use, in particular this question.

In a nutshell, you may not make more than 2’500 geocode requests in any 24-hour period and if you make too many requests in quick succession, the service will throttle (slow down).

GeodesiX enforces all the GoogleMaps limits and will slow down and eventually stop if you don’t respect the terms of use.

If you need to geocode large volumes, please don’t contact me, find a bulk geocoding service.

How do I display the map in languages other than English?

On the GeodesiX toolbar, click Options.
Select the Geocoder tab.
Choose the desired language. The map will refresh and display in the new language, if it is available.

As of this writing (April 2011), maps only display in English, Japanese, Korean and Russian.

However, the Geocoder does support most languages, as you can see by looking in the address box.

The map is blank !

This was resolved in release 3.0.2 (at least up to IE8).

  • Start Excel, Geodesix->Options->About and make sure you have version 3.0.2 or later.
  • In the Options->Advanced tab, make sure that the Googlemaps version is 3.6 or earlier.
  • Check these items
  • Browse the samples at Googlemaps API samples and try displaying geocoding-simple. If it doesn’t work, you’re probably using IE9 and I’m afraid I currently don’t have a solution.

Trouble-Shooting

=geocode(“latitude”,”London”) returns #NAME

This is usually due to problems with Regional Settings.

I haven’t managed to identify exactly what makes this happen, but the problem occurs when your Office Primary Editing Language has been changed and/or doesn’t match the Regional Settings in the Control Panel.

First of all, try Geodesix Toolbar -> Options -> Advanced -> Force EN-US and restart Excel.

If that doesn’t solve it, set your Office Primary Language back to it’s original installation value. Do the same with the Windows language, or try EN-US. Or vice-versa. Sorry I can’t be more precise, everybody who’s solved this problem reports a different solution.

Messages

!JSON result hasn’t got a ‘status’ field: ZZZ

GoogleMaps returned an invalid JSON message

!Failed to serialise JSON result: ZZZ

GoogleMaps returned an invalid JSON message

Unknown error (try again?)

GoogleMaps returned “unknown error”. A mystery.

Unexpected status XXX

WebRequest returned a strange HTTP status code XXX.

Unable to start emailer: ZZZ. Copy the details and send them by email to geodesix@calvert.ch

Your MAPI configuration is broken, you’ll have to send the email manually

Unable to set real-time RTDThrottleInterval, XXX. Updates will only occur every 5 seconds

Geodesix tried to set Excel’s real-time throttle to 1 second, to make the interface snappier, and failed. You can ignore this

Unable to detect web proxy configuration

Ensure that your Internet Explorer proxy settings are correct and that you can access the Internet with IE

Unable to delete worksheet XXX : ZZZ

You workbook contains a GeodesiX cache worksheet. The cache is corrupt. Geodesix tried to delete the cache, but couldn’t. You’d better correct or delete it yourself.

Travel(V,W,X,Y) failed ZZZ

A ‘Travel’ request failed. Hopefully ZZZ explains why

Shell “XXX” failed: ZZZ

The DOS box choked on XXX. Hopefully ‘ZZZ’ will explain why

RTD server error: ZZZ

The RTD server is broken. Please email the details to geodesix@calvert.ch

Requesting

Transient message, your request has been sent to GoogleMaps, awaiting the reply

Request denied (sensor missing?)

The sensor=no is missing on the geocode request. Please email the details to geodesix@calvert.ch

refreshing for XXX YYY

Unexpected error connecting to the RTD service XXX. Please email the details to geodesix@calvert.ch

Rate exceeded

You continue making geocode requests too fast and didn’t heed the warnings to slow down. Geodesix has given up.

Quota Exceeded

You are making geocode requests too fast. Geodesix is going to slow them down

Query type ‘XXX’ is invalid

Resolve only accepts query types ‘Geocode’ and ‘Directions’. Correct the request.

PlaceTag XXX exceeds YYY

This is an internal logic error in the Place class. Please email the details to geodesix@calvert.ch

page.htm not found. Please re-install GeodesiX

page.htm’ is a required part of Geodesix. You’ve either deleted or moved it.

Nothing found

GoogleMaps couldn’t find anything corresponding to the address you supplied

No routes found

GoogleMaps couldn’t find a route between the 2 places your supplied

Maximum waypoints exceeded

You supplied too many waypoints

Longitude2 “Z” not numeric

In GreatCircleDistance(W,X,Y,Z), Z is not a number

Longitude1 “Y” not numeric

In GreatCircleDistance(W,X,Y,Z), X is not a number

Latitude2 “X” not numeric

In GreatCircleDistance(W,X,Y,Z), Y is not a number

Latitude1 “W” not numeric

In GreatCircleDistance(W,X,Y,Z), W is not a number

Invalid service XXX

RTD service must be geocode or directions. Correct and re-submit

Invalid request XXX

In ‘=geocode(“XXX”, yyy)’, XXX must be ‘field’, ‘fields’, or the name of a field (‘latitude’, ‘longitude’ etc)

Invalid request (something is missing?)

The request to GoogleMaps is mal-formed. Please email the details to geodesix@calvert.ch

Installed version of Office is XXX. Regional settings are currently YYY. THIS IS NOT SUPPORTED unless you have installed the appropriate Office language pack.

Your regional settings between Office and Windows are incompatible, you must adjust them or GeodesiX won’t work

GetLocations/Routes error: ZZZ

The JSON message from GoogleMaps was incorrectly formatted

Geocode(‘XXX’,’YYY’) failed ZZZ

Geocode request failed. Hopefully ZZZ will explain why

connecting for XXXX YYYY

Unexpected error connecting to the RTD service XXX. Please email the details to geodesix@calvert.ch

#Field number must be numeric#

In ‘=geocode(“field”, NN)’, NN must be an integer greater than zero

#Field number must be greater than zero#

In ‘=geocode(“field”, NN)’, NN must be an integer greater than zero

!Quota totally exceeded. Try again tomorrow >;-)

You have made more than 2’500 geocode requests in a 24-hour period. Geodesix won’t work until tomorrow

!HTTP request to GoogleMaps failed: ZZZ

Communication problem. Check your internet connection

 Posted by on 2011/06/20 at 08:34

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)

*