Like us on FacebookFollow us on Twitter  Find us on Facebook and Twitter





Welcome to the CDXZipStream October 2012 Newsletter


It must be that time of year when old computers get changed out for new, because we've had lots of questions about new computer installations lately.  We cover here the most common questions that come up with new computers, and also discuss how MapPoint handles ambiguous address and country default data.


Here are our latest blog posts:


When You Get That New Computer 


We've had lots of inquiries lately about installing (or reinstalling) CDXZipStream on a new

New Computercomputer.  Here's a roundup of the questions that come with that shiny new box ...


1.  Do I need to buy again?  No additional purchase is necessary, since CDXZipStream is licensed on a per user (not per computer) basis, you can generate a new keycode free of charge to use on a new computer. 


2.  How do I do it?  Download and install the CDXZipStream demo on the new computer. When installation is complete and Microsoft Excel opens, press the third button on the CDXZipStream toolbar named "Licenses and Software Updates". (If you are using Excel 2007 or 2010, the CDXZipStream toolbar is located under the "Add-Ins" menu.) Then press the "Buy Now" button followed by pressing "Generate KeyCode" and log into our web site using the username and password you received with your original purchase. If you did not retain your original purchase information please contact us at


A web page allowing you to generate a new keycode should appear with your new Computer ID automatically entered. This Computer ID is unique for each PC and your registration code is based on it. Then press "Next" to generate your new registration key.

Copy your new keycode from the box that appears and then press the "x" in the upper right corner and minimize your browser. Then paste the copied code into the "Keycode" section of the "CDXZipStream Purchase and Registration" box and press "OK". (This is the box where you pressed the "Generate Keycode" button.) CDXZipStream will now be fully activated on your computer.


3.  Why doesn't it work?  CDXZipStream, like virtually all Office add-ins (including those offered by Microsoft) is currently not compatible with 64-bit Excel.  It can be run with no problem on a 64-bit Windows operating system, but it must be run with 32-bit Excel.  Unfortunately, our plans to offer a 64-bit CDXZipStream have been put on hold since Microsoft issued their newest version of MapPoint (2013), which supports many CDXZipStream functions, with no 64-bit option.  


So what can you do if you have a new 64-bit computer?  Microsoft provides both 32 and 64-bit versions as part of the license for Office 2010, so you can pick and choose the version you want to run, although you can't install both versions on the same machine. If installing 32-bit Excel 2010 is not an option, you can also install an older version of Excel (2007 or 2003) on the same computer with Office 2010 64-bit and successfully run that with CDXZipStream and other common add-ins.    


About Ambiguous Addresses in Microsoft MapPoint


Sometimes MapPoint can't definitively find an address, but has a couple of good guesses it would like you to choose from.  When inputting an address manually into MapPoint, an ambiguous result like this will bring up a box showing you the possible choices;  Microsoft calls this process disambiguation.


Disambiguation isn't quite practical with a long list of addresses, so when you use the CDXZipstream CDXLocateMP function for a list in Excel, you can select a checkbox called "Allow ambiguous data"  that allows MapPoint to make the choice for you.  In many cases we have found that the choices are very close to each other geographically, and not surprsingly may be caused by incomplete address address information (e.g. no street number) where even manual inspection may not be able to find a definitive choice. 


In our CDXZipStream templates, such as for geocoding and route optimization, you will sometimes see "Allow Ambiguous" as a match type for those addresses where an exact match wasn't found.  In these cases the geocoding or route optimization will proceed with the first choice found by MapPoint, but you may also want to double-check these cases for applications where accuracy is critical.



Using the MapPoint Country Default


If you ever go into MapPoint manually to enter an address, it will store the last country searched and use that country for any future addresses that do not contain country information.  For example, search for the address "56 Bayfield Street, Barrie, ON L4M 3A5, Canada", close MapPoint (North America), then open again and search for "355 Fifth Avenue, New York City, NY 10118". An error occurs because it assumes the address is in Canada, which is now the current country default.  This happens in both MapPoint NA and Europe, and can affect the behavior of CDXZipStream.  If the country default is changed because of a manual address search in MapPoint, i.e. a Canadian address is searched as in the prior example, CDXZipStream formulas will now require that all U.S. addresses in Excel contain "USA".  You can use this to your advantage if you need to search for addresses with CDXZipStream in a single country and don't want to include country information - just search for for an address in that country manually in MapPoint, and CDXZipStream functions will work solely for that country in Excel.


Latest Data Updates


Canadian and U.S. data feeds were updated as of October 3.  There were 40 changes made to the U.S. data feed.  If you would like to update your database to reflect these changes, click on the "License Information and Software Updates" icon on the CDXZipStream toolbar, and select "Data Updates" to login to your account.


We hope you find the information here helpful for you and your organization.  Please contact us with your feedback and suggestions by replying to this email.


The Team at CDX Technologies 


October 2012



Map of the World


In This Issue

 When You Get that New Computer


About Ambiguous Addresses in Microsoft MapPoint


Using the MapPoint Country Default


 Latest Data Updates







CDX Technologies | 2 West Hanover Avenue | Suite 212 | Randolph | NJ | 07869