Company truncating to 50 characters after validation

Support information relating to the CASS Certification process of AccuZIP6. More information can be found in the NCOALink forum.

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Eric
Moderator
Posts: 1909
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Company truncating to 50 characters after validation

Post by Eric » Thu May 17, 2012 7:37 am

The CASS Engine can take up to 50 characters, so the truncation of the company field occurs during the validation process. Prior to validation, you can pull down the Edit menu to Command and run this command, which will copy your company data into a field named company. After validation is run, you can run a second command that will copy the data from company2 back into company.

After you import your list into AccuZIP6, pull down the Edit menu to Command. Run the following command:

Code: Select all

ON ERROR com_Mesg=MESSAGE()
SET SAFETY OFF
ALTER TABLE ALIAS() ADD COLUMN company2 C(254) 
Replace All company2 with ALLT(company)
Click Run, then close the Command window.
Validate your list. After NCOALink has finished, pull down the Edit menu to Command, and run this command:

Code: Select all

Replace All company with ALLT(company2)
Close the command window after running it, and your Company names will be back to normal.
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

User avatar
Eric
Moderator
Posts: 1909
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Post by Eric » Tue Jun 16, 2015 1:51 pm

The CASS Engine can take up to 50 characters, so the truncation of the address field occurs during the validation process.

My recommendation will be to perform a one-time change in the Properties section of AccuZIP6, which increases the original size of the address and oaddress fields to 100 characters. After validation, you’ll run a command that will copy the original address into the address field, replacing the truncated data.

Pull down the File menu to Properties.
Click on the Fields Tab.
Click on Default Field Widths and Attributes.
Change the width of address to 100. Do the same to oaddress.
Click OK. Click Yes. Click OK to get out of the Properties window.

Open your list in AccuZIP6, and assign your fields as usual.

In the Validate Records window, check the Preserve Original Address box.

After validation is run, you can run a command that will copy the data from oaddress back into address:

After you import your list into AccuZIP6, pull down the Edit menu to Command. Run the following command:

Code: Select all

Replace All address with ALLT(oaddress)FOR LEN(ALLT(oaddress))>50
Close the command window after running it, and your addresses that were longer than 50 characters in length will be returned to their original condition.
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

User avatar
Eric
Moderator
Posts: 1909
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Post by Eric » Tue Jun 16, 2015 1:51 pm

The CASS Engine can take up to 50 characters, so the truncation of the address field occurs during the validation process.

My recommendation will be to perform a one-time change in the Properties section of AccuZIP6, which increases the original size of the address and oaddress fields to 100 characters. After validation, you’ll run a command that will copy the original address into the address field, replacing the truncated data.

Pull down the File menu to Properties.
Click on the Fields Tab.
Click on Default Field Widths and Attributes.
Change the width of address to 100. Do the same to oaddress.
Click OK. Click Yes. Click OK to get out of the Properties window.

Open your list in AccuZIP6, and assign your fields as usual.

In the Validate Records window, check the Preserve Original Address box.

After validation is run, you can run a command that will copy the data from oaddress back into address:

After you import your list into AccuZIP6, pull down the Edit menu to Command. Run the following command:

Code: Select all

Replace All address with ALLT(oaddress)FOR LEN(ALLT(oaddress))>50
Close the command window after running it, and your addresses that were longer than 50 characters in length will be returned to their original condition.
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply