This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
If you need more geographical information on a coordinate, try converting it into a spatial object and using the Find Nearest Tool to find coinciding Experian geographical data from an Allocate Input Tool.
You know what really stinks? Working with addresses that aren’t standardized or verified. Whether human-input, or one of the many address formatting standards in the U.S., being stuck with an address you can’t either (1) identify or (2) ensure it exists can be a real pain in the… well…
CASS is here to help!
Have some Latitude/Longitude points and not much else? Working with Spatial Objects and need more information than a simple map point? Time to call in the Reverse Geocoding macro. Reverse Geocoding can give some robust information to help make important business decisions when working with spatial data. Case in point: Your “friend” has hacked the Pokémon Go APK and hands you a list of Pokémon with the associated Latitude/Longitude. You can’t make an informed decision on your next weekend Poke-session without first understanding more than just the location on a map!
Where can I find the latest CASS dataset?? Help!
The most recent CASS datasets are available online through the Licensing and Download Portal which can be accessed at http://licenses.alteryx.com. For information on how to access the licensing portal and download the data you are licensed for, click on the below link -
Question: A data artisan isn't receiving notifications of CASS updates. How can they be added to the CASS list? Or how can someone be removed from the notification list? Since CASS expires every 2 months, being notified is important.
Answer: Send an email to email@example.com with the email addresses for inclusion or removal
The US and CA Data and Spatial Bundles contains many datasets, including the Melissa Data CASS engine. While the US and CA Data Bundles are updated every quarter, CASS is updated every 2 months. Luckily, the install file size for CASS is just over 1gb, so we are able to provide this update as a download. Once downloaded, a few simple steps will get you on your way to using the most updated version of CASS. On occasion though, users have reported a few issues with being unable to utilize CASS. Because of this, we have decided to provide full download and install instructions, with a final portion of frequent questions and issues. To install the latest CASS:
Download the latest version of CASS. This is sent via email from Alteryx Products on a bi-monthly basis and will be in the format of the following:
YY is the current year and MM is the current month release of CASS.
Double-click on the .exe file. This starts the 7-Zip Self-Extractor. Choose a location where you would like to extract the install files.
IMPORTANT: This does not actually install the files, it only extracts the install files.
Once the install files have been extracted, located and double-click the file DataInstall.exe. This will be in the directory you just extracted to in the previous step.
When the install dialogue pops up, check the box to accept the license agreement and click Next.
The next screen allows you to select datasets to install. Depending on which install you've chosen, you will see the option to install US, Canada, or both versions of CASS. Check all boxes, then click Next.
This screen displays all current datasets installed on your machine. Checking any box here will uninstall the dataset. By default, the previous version of CASS will be checked for uninstall. Make sure all prior versions of CASS are checked, then click Next.
IMPORTANT: You must uninstall all previous versions of CASS during this process. If you have any expired versions of CASS on your local machine, no other versions of CASS will work properly.
Browse to the directory you wish to install CASS to, then click Finish.
Once the above steps have been completed, you will be able to use CASS on your local machine. FAQ/Common Errors:
Error: CASS (2): CASS is not installed properly or it has expired. Please contact your reseller or Client Services at 1-866-516-2400 1-866-516-2400 FREE to receive an updated CASS database.
This is often because a prior version of CASS is still installed. Re-run DataInstall.exe and make sure all prior versions of CASS are checked in the Uninstall screen.
CASS was installed on a network drive and permissions are not allowing you to see it. Try re-running DataInstall.exe and install CASS on a local drive.
Error: CASS (1): The Melissa Data CASS engine appears to not be installed (can't find dll).
This is often the result of mismatched registry entries or install folders. Please contact firstname.lastname@example.org for resolution.
In most cases, the solutions for error 1 above will resolve your issue, but if not please don't hesitate to reach out to email@example.com for handling. Thanks, and until next time! Chad Follow me on Twitter! @AlteryxChad
Symptoms This note is to alert users of Alteryx 8.6 to 10.5 of an error message that may appear if a user previously installed the combined US and Canada CASS dataset and then in subsequent data updates separately installs CASS for a single country.
Some clients reported receiving a message in the Alteryx Designer that “CASS is not installed properly or it has expired.” Once CASS is installed for both countries, supporting program files continue to look for the combined dataset even if CASS is uninstalled and a single country is reinstalled.
Diagnosis The instigating files are identified and a resolution is being explored, however, this error appears to be inherent to the source data itself.
Solution Action required: 1. Close open instances of Alteryx 2. Delete the CASS.ini file which in most cases resides on the user’s local drive (C:\ProgramData\Alteryx\DataProducts\DataSets\CASS\CASS.ini) 3. Locate the most recent CASS installs and re-run the installation executables 4. Relaunch Alteryx and verify the CASS tool is no longer reporting an error
This note is to alert users of Alteryx 8.6 to 10.1 of a potential message window that may appear after updating the US and Canadian CASS engine. Subsequent to completing the CASS installation and closing the installer, some clients have reported receiving a message window stating that the program may not have been installed correctly. This message can be disregarded and will not impact dataset functionality.
The source of the problem is being identified and a fix will be included in future Alteryx software releases.
Action Simply choose ‘Cancel’ to close the Program Compatibility Assistant window. Alteryx can then be opened and workflows can be run as normal.
Was the installation of CASS successful? Yes, CASS was installed fully and all scripts have finished running.
Will this message impact my installation or existing workflows? This message is entirely cosmetic; there are no impacts to the installation or workflows.
Symptoms Multiple users reported problems when installing CASS (US and Canada) to the same file folder where the executable is saved. When registering the CASS data, an error message appears and installation cannot continue.
Diagnosis Users extracting and installing files to the same network folder can create conflicts. During the install and registration process Alteryx identifies files as being in use and cannot continue with the final registration of data. If you receive no errors when installing CASS, no action is needed. If an error is encountered during the Prepare a Network Install step, consider file cleanup and a reinstall of the data. The attached document displays an example of the installation error.
Solution What’s the typical network install process?
Start with a CASS executable to extract the install files to a temporary location
Install CASS files to a different directory or network location than where extracted
Register the extracted data. As a best practice, avoid installing the CASS data to the same file directory where CASS is initially extracted. Also ensure you have administrative permissions to write to this location of your C: drive - C:\ProgramData\Alteryx\DataProducts\DataSets\CASS since this is where a required Alteryx instruction file is written.
Ensure you have write permissions to C:\ProgramData\Alteryx\DataProducts\DataSets\CASS
Delete the CASS files initially downloaded and installed
Download and extract the CASS install files to a location with at least 1.2 GB available space
Navigate to the extracted file location, double click DataInstall.exe
Select Prepare a Network Install for the CASS data, ensure the install directory is different from the extracted files directory. Complete the install.
Navigate to the new install directory, double click DataInstall.exe, follow the prompts then select Register from a Network Location to complete the install.
If you have other concerns or need assistance with these instructions, please contact our Customer Support team at firstname.lastname@example.org .
In a situation with a large database of thousands of records, some addresses may not be valid. Inevitably, CASS will output the bad addresses along with the good addresses. The issue is that certain addresses double up on the suite. Since, in this example, the input file had address and suite in the same line the file looked similar to this: The CASS output would actually find the suite, but not add it to the CASS_Suite output. This normally would not be an issue, but it actually would add it to the CASS_AddressPlusSuite field, creating a file that in fact looked like the following: This issue is inherent to the MelissaData engine which drives the CASS tool. The best way to address the issue is to include the CASS_Results field in the output from the CASS Tool. This will give a code that notifies the user of the CASS match level. Good addresses will have a match level of AS01 or AS02, whereas bad addresses will have different codes. The entire listing of all possible CASS_Results codes is available in the Help File by searching for CASS Results. Eliminating the codes that highlight bad addresses will alleviate this issue.