Frequently Asked Questions


You can access CDXStreamer from the main CDXStreamer commandbar, by right-clicking on any worksheet cell, or by directly entering a CDXStreamer function in a worksheet formula.

From the Commandbar: The CDXStreamer commandbar at the top of your worksheet includes all functionality as well as access to the help file, license information, data usage, and settings. To obtain data for a list of ZIP+4 Codes, for example, use your cursor to select the first ZIP Code in the list, click on the CDXStreamer button on the commandbar, and the main CDXStreamer interface will appear:

CDXStreamer FAQ Question 1

Here you can select the data feed and data fields to import. Then click Get Data and CDXStreamer does the rest.

Right-click: Right-click your mouse on any worksheet cell, and from the drop-down list select CDXStreamer. You can then select Insert CDXStreamer Data or Address Verification and proceed from there.

Enter a worksheet formula: You can also use any CDXStreamer function or data feed by directly entering it in a worksheet formula.

CDXStreamer is compatible with all Microsoft Excel 32- and 64-bit versions for Windows, beginning with Excel 2002.

The recommended system configuration is a computer running Microsoft Windows® XP Professional or higher with a Pentium IV processor and 512 megabytes (MB) of RAM. Minimum system requirements for Office products are available here from the Microsoft website.

The free 7-day trial of CDXStreamer includes all functionality, with address verification and access to all data. It can provide up to a total of 1000 data requests.

Please refer to this document CDXStreamer Data Feeds and Definitions.pdf for a complete listing of all available data.

ZIP+4, TIGER/ZIP+4, and address verification applies only to U.S. addresses.

Canadian postal code data covers all Canadian provinces.

You can purchase a block of data requests which are available for a period of one year. One-time block purchases have a one-time charge and do not automatically renew.

CDXZipStream has a much wider variety of location-based functionality, but both CDXZipStream and CDXStreamer perform address ZIP Code lookup and address verification. If these are your primary interests, which software do you choose?

CDXZipStream is a one-time, single license purchase that includes one year of data updates. CDXStreamer is a monthly, subscription-based service. CDXZipStream can use either Bing Maps or Microsoft MapPoint as the source of address data and postal code data, and covers the U.S. and other countries. CDXStreamer uses U.S. Postal service databases, and covers only the U.S. CDXStreamer also provides ZIP+4 data which is not included in CDXZipStream. We generally recommend using CDXStreamer when high address accuracy and/or ZIP+4 data in the U.S. is required.

ZIP+4, TIGER/ZIP+4, and data associated with address verification are provided by the U.S. Postal Service. Canadian postal code data is provided by a licensee of Canada Post.

Street address correction in CDXStreamer follows the US Postal Service one component failure rule to find a correct address match. If not more than one address component mismatch exists, where a component is defined as a predirectional, street name, street suffix, or a postdirectional, then a correct address can be returned. For instance, the address 500 North Main Street West has four components. If one of the components has to be added, changed, or deleted to achieve a unique match, CDXStreamer will correct the address and return the ZIP+4 Code. If more than one component is incorrect, no match is allowed. Also, no match can be returned if adding, changing or deleting a component results in multiple matches. The priority is to add a suffix first before adding a directional. If no match exists, the suffix is changed or deleted, and then the directional.

If there is not an exact match within the city, the one component failure rule is applied within the input ZIP Code. If there is still no match, the rule is applied to all addresses within the postal finance number, and is only considered invalid if there is no match within that.

To verify a list of addresses, use your cursor to select an empty cell next to the list, and then click on the Address Verification button on the CDXStreamer commandbar. The address verification interface will appear:

CDXStreamer FAQ Question 10

After specifying the location of the first address in this list (for this case, in cell A1) and the desired data field (Full_Address_Out), we also suggest enabling Autocopy and Set Array to values for long data lists. These options will automatically return data for the entire list (until the first occurrence of an empty row), and return values instead of formulas. Then click OK and CDXStreamer will return to your worksheet the corrected, standardized addresses for the entire list.

We offer a free Excel template that completely automates address verification and parsing. Please see the CDXStreamer template page for more information.

Address verification can also be performed when street, city, state and ZIP Code data are in separate columns. In this case just specify the Multi-Line Address format, and fill in the cell locations for each component of the first address.

For an address list that has missing or possibly incorrect ZIP or ZIP+4 Codes, use your cursor to select an empty cell next to the list, then click on the Address Verification button on the commandbar. The address verification interface will appear:

CDXStreamer FAQ Question 11

For this case we specify the location of the first address in cell A1, and the desired data field 9digit_zip for a ZIP+4 Code. (We could specify just the 5-digit ZIP as well.) We also suggest enabling Autocopy and Set Array to values for long data lists. These options will automatically return data for the entire list (until the first occurrence of an empty row), and return values instead of formulas. Then click OK and CDXStreamer will return to your worksheet correct ZIP+4 Codes for the entire list.

You can also get ZIP and ZIP+4 Codes when street, city, state and ZIP Code data are in separate columns. In this case just specify the Multi-Line Address format, and fill in the cell locations for each component of the first address.

To obtain data for a list of ZIP+4 Codes, use your cursor to select the first ZIP Code in the list, click on the CDXStreamer button on the commandbar, and the main CDXStreamer interface will appear:

CDXStreamer FAQ Question 12

Here select the CDXZIP4 Data feed and one or more desired data fields, such as Carrier_RouteID. Then click Get Data and CDXStreamer will return the selected data fields for every ZIP+4 Code in the list, until the first occurrence of an empty row.

To parse an address list into its different components, use your cursor to select an empty cell next to the list, and then click on the Address Verification button on the CDXStreamer commandbar. The address verification interface will appear:

CDXStreamer FAQ Question 13

For this case we specify the location of the first address in cell A1, and the desired data field Address_Out for the street address. We also suggest enabling Autocopy and Set Array to values for long data lists. These options will automatically return data for the entire list (until the first occurrence of an empty row), and return values instead of formulas. Then click OK and CDXStreamer will return to your worksheet the street addresses for the entire list. Then just repeat the process for the other components (city, state, ZIP or ZIP+4 Code).

We offer a free Excel template that completely automates address verification and parsing. Please see the CDXStreamer template page for more information.

Have a question or concern?

support@cdxtech.com
1-877-CDX-TEC1 (239-8321)