Search found 480 matches

by Eric
Wed Sep 27, 2006 8:08 am
Forum: File Conversions
Topic: File Conversion Service: $10 Per File
Replies: 0
Views: 7283

File Conversion Service: $10 Per File

AccuZIP Inc offers a file conversion service where, for $10 per file, you can email files that you cannot open successfully in AccuZIP6, and an AccuZIP6 technician will convert the file to a format that you can open successfully in AccuZIP6. Email your files to support@accuzip.com and in the email, ...
by Eric
Tue Sep 26, 2006 11:58 am
Forum: AccuZIP6 Commands
Topic: Insert Commas into proper places within a number
Replies: 0
Views: 7051

Insert Commas into proper places within a number

The following command will insert a comma into a number for numbers as large as 999999999. In that example, it'll change that field to 999,999,999. Before running the command, pull down the Edit menu to Fields and make sure your field is wide enough to hold the command. Replace all amount with IIF(L...
by Eric
Tue Sep 26, 2006 9:56 am
Forum: Upcoming Regulations Changes
Topic: Aug 3 article: Four-State Barcode Mandatory in 2009
Replies: 2
Views: 13830

Aug 3 article: Four-State Barcode Mandatory in 2009

http://www.usps.com/communications/news/press/2006/pr06_023.gif http://www.dmnews.com/cms/dm-news/direct-mail/37735.html Speaker Says Four-State Barcode Will Be Mandatory for Automation Discounts WASHINGTON -- A postal official said yesterday the 4-state barcode will be required in order to receive...
by Eric
Tue Sep 26, 2006 9:52 am
Forum: AccuZIP6 Commands
Topic: Change the name and/or width of a field
Replies: 0
Views: 7407

Change the name and/or width of a field

The following command changes the name of the field named zipcode to zip.

Code: Select all

ALTER TABLE ALIAS() RENAME COLUMN zipcode to zip
If you want to change the width of a field, here's a command that changes the ZIP field to a width of 10

Code: Select all

ALTER TABLE ALIAS() ALTER COLUMN zip C(10)
by Eric
Tue Sep 26, 2006 9:36 am
Forum: AccuZIP6 Commands
Topic: Fill Leading Zeros into the ZIP field
Replies: 0
Views: 7112

Fill Leading Zeros into the ZIP field

Use this command before you validate your database when you're importing an Excel file that has east coast or Puerto Rican addresses (ZIP Codes that have leading zeros). When you open the Excel file in AccuZIP6, the leading zeros that were part of the Excel formatting (but not part of the Excel data...
by Eric
Fri Sep 22, 2006 3:43 pm
Forum: AccuZIP6 Future Releases
Topic: Option to export full length
Replies: 4
Views: 18489

The current beta version of AccuZIP6 5.0 creates a sequence field for the presort file that is a width of 7, regardless of the amount of records in your database. If you have 1000 records and you export the presorted data, your sequence field will look like 0001000. Record 10000 will have 0010000 in...
by Eric
Fri Sep 22, 2006 9:01 am
Forum: AccuZIP6 Commands
Topic: Copy a field from one list to another when records match
Replies: 0
Views: 8009

Copy a field from one list to another when records match

If you want to compare two databases and, when there are matches between records in the two databases, take the contents of a field (or fields) from one database and add it to the matching records of the other database, use this command. SET SAFETY OFF SELECT("databaseWithInfo") INDEX ON ALLT(UPPER(...
by Eric
Fri Sep 22, 2006 8:50 am
Forum: AccuZIP6 Commands
Topic: Insert slashes into a field that contains a date
Replies: 0
Views: 7334

Insert slashes into a field that contains a date

Assuming the format of the date is MMDDYYYY or MMDDYY, here is a command that will insert slashes so the end results looks like: MM/DD/YYYY or MM/DD/YY

Code: Select all

Replace all date with LEFT(ALLT(date),2)+"/"+SUBSTR(ALLT(date),3,2)+"/"+SUBSTR(ALLT(date),5)
by Eric
Fri Sep 22, 2006 8:46 am
Forum: AccuZIP6 Commands
Topic: Export your file as a csv using the Command feature
Replies: 0
Views: 7693

Export your file as a csv using the Command feature

Code: Select all

COPY TO C:\TEST.CSV TYPE CSV
Where I have C:\TEST.CSV, enter the complete path of where you want your csv file saved, and the name that you're giving the .csv file.
by Eric
Fri Sep 22, 2006 8:41 am
Forum: Import/Export
Topic: Getting Variable TRAYNO not found when I export my presort
Replies: 0
Views: 9689

Getting Variable TRAYNO not found when I export my presort

You're getting that error message because you're using an export map from version 4.0 that included the trayno field, which is a field that held your tray number information in version 4. In version 5.0, the tray numbers are in the field named CONT_ID. Two more changes: The sequence numbers are in a...
by Eric
Fri Sep 22, 2006 8:35 am
Forum: Presorting
Topic: Not getting Incounty zones on Periodicals Mailings?
Replies: 0
Views: 6592

Not getting Incounty zones on Periodicals Mailings?

With your database open, pull down the Special menu to Validate Records. In the Output section of the Validate window, check the County Code (FIPS) and the County Name boxes. Click Validate. With county information added to your database, pull down the Sort menu to Presort Mail. Make sure the Incoun...
by Eric
Fri Sep 22, 2006 8:29 am
Forum: AccuZIP6 Commands
Topic: When you have Address, City, State, and ZIP all in one field
Replies: 0
Views: 9279

When you have Address, City, State, and ZIP all in one field

Use the following command to move the address info into the Address field, the city information into city, states into st, and the ZIP Codes into zip. Before running this command, the address, city, st, and ZIP information should be in the field named Address. use in iif(used('_uszips'),select('_usz...
by Eric
Thu Sep 21, 2006 10:58 am
Forum: AccuMUV NCOALink Unlimited Access and ANKLink
Topic: Transfer NCOA Service to a different computer
Replies: 0
Views: 11634

Transfer NCOA Service to a different computer

Click Here to transfer your NCOA Service from one computer to another.

Upon submitting the form on that page, you'll be sent an email from our AccuMuv (NCOALink) Department that will allow you to transfer your NCOA service to a different computer.
by Eric
Wed Sep 20, 2006 3:29 pm
Forum: Printing
Topic: Microplex F24 Driver for continuous feed printing
Replies: 0
Views: 5042

Microplex F24 Driver for continuous feed printing

The Microplex F24 is a laser printer that can print continuous feed labels, but in AccuZIP6, the driver that comes with the F24 has built in margins that cause the last line in the 11th label to be skipped, no matter what you do in the label template. Install this driver and use it for the Microplex...
by Eric
Tue Sep 19, 2006 4:42 pm
Forum: AccuZIP6 Commands
Topic: Posting Commands Rules
Replies: 0
Views: 11508

Posting Commands Rules

When typing a command, please put the command within the Code tag. There are two ways to use the Code tag. 1. Type out your command, highlight it, then click on the Code button above. 2. Click on the Code button, type the command, then click on the Code button again, or the Close Tags link above. By...