Search found 481 matches

by Eric
Wed Sep 27, 2006 8:24 am
Forum: File Conversions
Topic: Spreadsheet or Table Format .DOC files
Replies: 3
Views: 16110

Spreadsheet or Table Format .DOC files

When I mention a Spreadsheet or Table Format file, I'm talking about tabular data that has each field in a separate column and each record in a separate row, like you see in AccuZIP6 or Excel. AccuZIP6 cannot currently open this type of file, or .doc files (Word documents) in general. But when you h...
by Eric
Wed Sep 27, 2006 8:08 am
Forum: File Conversions
Topic: File Conversion Service: $10 Per File
Replies: 0
Views: 8665

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: 7870

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: 15567

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: 8270

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: 7988

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: 20734

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: 8869

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: 8160

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: 8482

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: 11033

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: 7404

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: 10202

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: 12998

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: 6006

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...