|
 
Find
us on Facebook and Twitter
|
|
Welcome to the CDXZipStream February 2017 Newsletter
CDXStreamer has been upgraded to include data caching,
in order to prevent identical address requests during an Excel
session. This improves speed and also prevents additional
account debits. A free Excel template that automates address
verification is now also part of the CDXStreamer installation file.
We also review our customization services which cover
one-time analyses, custom Excel templates, application of the
software beyond Excel, and the use of custom databases.
|
|
We've recently upgraded our CDXStreamer product
(2.0.34). For those of you not familiar with it, CDXStreamer is
a Microsoft Excel add-in that verifies and corrects address lists
with US Postal Service databases, and looks up ZIP and ZIP+4 Codes,
all while working entirely within your spreadsheet. Get complete
address data in standardized format. Correct misspellings and
incorrect ZIP Codes, and parse address data into street, city, state
and ZIP Code components.
We've added session caching to the product so that
identical address requests will not re-query our servers. This
can happen unexpectedly when you use address formulas and then sort
or filter a range. This significantly improves speed and will
prevent your account being debited with duplicate requests. You
also now have the ability to switch between different CDXStreamer
logins. Just press the "License" button to log-out
and then press it again to log back in.
We are also now including our Address Verification
template as part of the installation. Just paste your address list
into the template, and press the "Verify Addresses" button.
The template automatically compares each address to the US
Postal Service databases on CDXStreamer servers. Addresses are
returned to the template with correct spellings, abbreviations, and
formatting. ZIP+4 Codes are also returned. Here is a
short tutorial showing how easy it is to use:
|
|
|
Verify Addresses in an Excel Template
|
To try out this latest version, download the free
trial of CDXStreamer.
|
Our Customization Services
 Do
you have a special project that can use our software functionality,
but we don't offer an off-the-shelf database or template that can
quite do the job? Here are some examples of how we can customize our
products for you, to better support your business needs around
address, zip code, and data analysis in general:
Do a one-time analysis: Need to use CDXZipStream functionality
just once? If you are not interested in purchasing the software for
future use, we can provide the hard data that fills your specific
need. This is often an economically attractive alternative,
particularly in lieu of the more expensive demographic versions of
CDXZipStream.
Get a custom Excel template: We can build pre-formatted
templates that perform specific tasks with existing CDXZipStream
functions, often combining multiple functions from CDXZipStream and
Excel to get the final required answer. Tasks can usually be fully
automated so that after data entry, a simple click of a button is all
that's required of the user. We currently offer free, downloadable
templates that perform basic analyses, such as geocoding (getting
latitude/longitude data), route optimization, radius analysis, and
more. But if you have a more complex task, consider a customized
template. This is also a great option if you need to standardize
CDXZipStream applications for less experienced Excel users.
Apply CDXZipStream beyond Excel: We've previously published
the basic programming code that allows CDXZipStream to be applied to
other Office applications beyond Excel. This code is not proprietary
and we invite our clients to use it as they please. Not into
programming? We can do it for you, and get CDXZipStream
functionality, ranging from route optimization to radius analysis,
exactly where you need it.
Use CDXZipStream with a custom database: We've designed
CDXZipStream around the use of address, zip code, and demographic
data, but the concept of selectively taking data from a local
database and putting it in Excel with custom functions can be applied
to a wide variety of data needs. Whether you have a private database
you would like to use more efficiently through a spreadsheet
platform, or want to mine a commercially available set of data that
we don't currently include in our own feeds, we can build a version
of CDXZipStream that will work for you, using our patented
interface.
For more information about CDXZipStream customization, or to request
a free quote, contact us at 1-877-CDX-TEC1 (239-8312) or customsolutions@CDXTech.com.
|
Latest Data
Updates
Canadian and
U.S. data feeds of CDXZipStream were updated as of February 24.
There were 88 changes made to the U.S. database this month.
If you would like to update your database to reflect these
changes, select the "Account" option on the
CDXZipStream commandbar and click on "Check for Available
Database Updates". You can then update each database as
required.
CDXZipStream
updates are a part of the one-year software maintenance
subscription included with your purchase. If you would like to
extend your subscription, please sign in to the CDX Technologies
website and from the account area for CDXZipStream, select "Buy
Data Update".
As always
we hope you find the information here helpful for you and your
organization. You can contact us with your feedback and
suggestions by replying to this email.
The
Team at CDX Technologies
|
|
|
|
|
In
This Issue
CDXStreamer Upgrade
Our Customization Services
Data Updates
|
|
