We've previously covered how to install CDXZipStream on new computers the blog article How to Reinstall CDXZipStream on a New Computer. But what procedure should you use when you want to remove and deactivate CDXZipStream?
CDXZipStream is licensed per user and each license includes two activations. This allows you to put CDXZipStream on one main and one backup computer like a laptop. If you have just purchased a new computer and have already used all of your activations you will receive an error from our registration server.
In the past, you would need to contact us at email@example.com to remove older computers. But we've now added a feature to the latest version of CDXZipStream that allows you to handle this. When you press the "Register/Upgrade" button in the CDXZipStream Account menu item in Excel you will see the following dialog:
On activated copies of the program you will now see a "Deactivate This Computer" button. Pressing this button will lead to a prompt for you to enter your cdxtech.com website credentials. After successfully validating your request the computer will be removed from your activation list and the installation deregistered. You can then proceed to uninstall CDXZipStream using the programs feature in the Control Panel of Windows.
There are situations where this feature will not work like on a proxy network where our activation server can't be contacted. You can still proceed with the activation and then contact us at firstname.lastname@example.org to remove the computer.
To get this new feature you need to install CDXZipStream version 18.104.22.168 or better which is the current trial version on our site. This will work with all versions of CDXZipStream.
The new function CDXZip4 is now part of CDXZipStream and provides address correction and USPS Zip+4 approved formatting using our CDXGeoData web service. Available in all versions of CDXZipStream with a CDXGeoData API key, you can now perform address verification and correction using U.S. Postal Service databases. Get address data in standard format and find ZIP+4 Codes even for addresses with missing data.
The CDXZip4 function can be used by right-clicking on any cell in your worksheet and selecting Insert CDXZip4 Function from the new CDXGeoData Functions drop down menu. Provide the input address information as either a single-line or multiple line address. Multiple-line input will look like this:
If parts of the address are unknown, such as state or postal code, they can be omitted from the input data. When specifying what data should be returned, you can request the “fullAddressOut” to return the entire address with all available information. You can also request that just portions of the address be returned, which is useful for identifying a missing ZIP code, for instance, or to accurately parse the address into different worksheet cell
Requests are checked against a USPS database to determine the correct format and if it is deliverable. Addresses not validated with return “Unknown or Invalid Address”. The results should closely match the individual results returned at the USPS site.
To gain access to this functionality you must have a CDXGeoData API Key which is not part of the CDXZipStream license. Tokens are used to access CDXGeoData with different levels for each service request. This Zip+4 address verification will require 5 tokens per request. Any number of users can access the CDXGeodata service with a single API key.
A free CDXGeoData account comes with 1000 tokens that can be used for evaluation, development and non-profit use. If you use up your tokens, your account will be refreshed with up to 1000 additional requests on the monthly anniversary of your account start date. Additional tokens can be purchased on an as needed basis with the following pricing. The tokens are good for up to one year. It’s easy and risk free to get started with our free account.
Bing Maps has recently added new functionality called SnaptoRoad. This feature is useful when you are analyzing GPS data on route or tracking assets. GPS data is not always accurate and may reflect off-road data points. The SnaptoRoad feature will adjust the route data to conform to the road being travelled. Here is a Microsoft article describing this feature in more detail.
The CDXLocateBing function has been updated to return three new data items (SnaptoRoad Street, SnaptoRoad Coordinates, and SnaptoRoad Speed Limit).
It returns the specific street being traveled, the adjusted coordinates of the street or the speed limit if available.
The input data must be in the form of individual latitudes and longitudes. The input can also be in a single worksheet cell using the format Latitude|Longitude. This is the numeric latitude and longitude separated by a pipe character. This is also the output format provided for coordinates. Here is an example formula for SnapToRoad.
Coordinates and SpeedLimit can be obtained by changing 11 in the above formula to 12 or 13.
To get this new feature you need to install CDXZipStream version 22.214.171.124 or better which is the current trial version on our site. Registered users must have the Bing Version of CDXZipStream or better to use this function.
We often get asked how to run radius calculations in bulk. For instance, if you'd like to know all ZIP Codes within a 10 mile radius of a list of ZIP Codes. This information can be used in performing a nearest store report, optimizing a mailing list or other applications. We've previously covered techniques for this as described in the blog post Get Radius Information for a List of ZIP Codes.
To help automate this further we've created a new template to manage the creation of these lists. The free template is available to CDXZipStream users on our website who have the Lite Version of CDXZipStream or better.
Just enter your ZIP Code list in column B. You can use the CDXZipList right-click function to generate a list of zip codes by city, state or county for this input. Use the option to only return the zip code column.
Then specify a radius distance and press "Calculate". Beginning in Column C, all ZIP Codes within that radius will be shown in individual cells. A radius distance up to 200 miles can be specified. You can also choose to return both the zip code and distance by clicking the check box on the right of the screen. Options to use the U.S. or Canadian databases are also available.
We’ve continued to add to our portfolio of cloud based zip code tools. A recent blog article discussed our web based Zip+4 Address Correction tool. This allows you to enter a list of addresses and returns a list of validated address with ZIP+4 information. A new tool has been added to create a detailed demographics report for a list of zip codes.
Just upload a list of zip codes in .csv text or .xlsx Excel format and this application will generate a comprehensive demographics report. The reports contain over 50 key demographic statistics including household income, population, median age and business employment. Most of the data is derived from the 2010 US Census.
To start, just visit our Zip Code Demographics Batch Report.
You will need to place your address data in a Excel .xsls file or in a text csv file. Only a single column is permitted. More information on formatting your data is available on the site. Use a file explorer option to upload your data or drag and drop your file into the indicated area.
Shortly after uploading your file you will be taken to a preview screen. Here you can see the first few results of your input to make sure all is as expected. The report includes all data fields included in our Free Demographics Tool such as population, race and income statistics.
If you data isn’t returning correctly, an option to restart the process is available.
If you would like to process the entire report this can be purchased for .01 per address or by using your CDXStreamer account. Use a CDXStreamer account if you intend to use the site multiple times or if you have a large number of requests where lower costs are available.
After purchasing a progress bar will appear as results are calculated. It may take several minutes for large files to process. When complete a download button will display allowing you to retrieve data in csv format. Contact us at email@example.com if you have any issues downloading the data.
An example of an output data file can be downloaded here. You can analyze the example and other demographic lists created with this tool by downloading our free Demographic Report Template.
That’s all there is to it. Three simple steps with no extra software to install on your system. Please give this a try and let us know if you have any questions or feedback.