Welcome to the CDXZipStream February 2014 Newsletter

New Geocoding Template Supports Country Input

 

Our Microsoft Excel geocoding template now can handle country input, and also allows the user to select a default country when country information is not provided with each address.

 

Geocoding (getting latitude and longitude) for a list of addresses is a valuable tool, since latitude and longitude provide a very accurate and unambiguous description of geographic location that can be used, for example, for subsequent routing analysis or even as input to GPS devices.  Our template uses CDXZipStream and Microsoft MapPoint running in the background to automatically find geocoordinates for long lists of addresses. Just copy and paste your list into the template, and select the country of interest.  The selected country will be used if no country is present as part of an address, and will also override the country default setting in MapPoint.  

 

Note that the MapPoint default country can be set by manually opening MapPoint and performing (and saving) a successful address search; the default country contains this address.  The new features of this template make manually setting unnecessary.  

CDXZipStream 11.2.7

 

Reducing Data Requests from CDXStreamer

 

CDXStreamer is our Excel add-in designed to correct mailing address information and streamline access to Zip+4 data.  Since CDXStreamer is priced based on the number of data requests (either monthly or as a one-time purchase) it's important to avoid situations where data could be lost, such as when Excel crashes or freezes.

 

We highly recommend that when performing address verification for large data sets, our clients use the "Set Array to Values" option.  This avoids Excel being overwhelmed with a large number of CDXStreamer formulas filling a worksheet.  Some other good tips:

 

- From the Excel File tab, select Options, then Save to enable autosave and autorecovery.  (In older versions of Excel, this is accessed from the Tools menu.)  If Excel goes down, having these enabled will help minimize lost data.

 

- To avoid unnecessary recalculation of many CDXStreamer formulas (which can also cause Excel to freeze), turn off automatic recalculation. You can then choose to recalculate a worksheet or workbook when it's convenient for you by using keyboard shortcuts.  More information on manual recalculation is provided from Microsoft here.  You can also easily remove unnecessary formulas by copying them to values.

 

- Make saving your file a frequent habit by using the keyboard shortcut CTRL-S or the Excel Save button at the top of your screen.

Latest Data Updates

 

Canadian and U.S. data feeds were updated as of February 19.  There were 58 changes made to the U.S. database this month.  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