Search found 28 matches

by Terry
Fri Mar 29, 2013 1:40 pm
Forum: AccuZIP6 Commands
Topic: Generate a Random Number Of Any Length In A List
Replies: 0
Views: 9029

Generate a Random Number Of Any Length In A List

This command will generate a guaranteed Random number in a Character or Numeric Field. Download and unzip the file linked below directly to your C:\Program Files (x86)\AccuZIP6 5.0 folder. Import your list, and create a field that you want the number to be stored in using Edit>Fields. The field LENG...
by Terry
Fri Mar 29, 2013 9:34 am
Forum: AccuZIP6 Commands
Topic: Generate a 4-digit Unique Number In a List
Replies: 0
Views: 8701

Generate a 4-digit Unique Number In a List

The command syntax below will generate what appears to be a random 4-digit number in a field called "record" in your list. If your database has less than 10,000 names, this will create 0001-9999 in the database, with no value appearing twice. In reality it's simply indexing it on the "First" field, ...
by Terry
Fri Mar 08, 2013 10:28 am
Forum: AccuZIP6 Commands
Topic: Merge Fields from Duplicate Records Into One
Replies: 0
Views: 9554

Merge Fields from Duplicate Records Into One

If you have duplicate records in a file that you wish to merge together into a single record, this command and process will do that. This command has a limitation of 5 duplicates per entry, however. For example, if you had a records in your database where the primary information matched, but there w...
by Terry
Wed Jan 18, 2012 12:04 pm
Forum: Printing
Topic: Positioning Issues or Blank Pieces printing
Replies: 0
Views: 9137

Positioning Issues or Blank Pieces printing

This is most commonly associated with printers like the Neoposts and Haslers, which have drivers written by Satori Software. If you use a printer with a driver written by Satori Software (you can check the printer properties' about tab to see if it says Satori on it), there is an issue in how the dr...
by Terry
Mon Mar 01, 2010 9:50 am
Forum: Miscellaneous
Topic: Duplicate Detection Always Finding 0 Records
Replies: 0
Views: 8567

Duplicate Detection Always Finding 0 Records

If you encounter a situation where your duplicate detection always finds no duplicates, and the fields are assigned properly, it's likely one of two things: 1) The formatdups files have become corrupted. These files are saved in the C:\Program Files\AccuZIP6 5.0\Support folder, and will need to be r...
by Terry
Thu Jan 08, 2009 2:00 pm
Forum: Import/Export
Topic: Only Exporting the Endorsement Line at Package Breaks
Replies: 0
Views: 9134

Only Exporting the Endorsement Line at Package Breaks

If you want to export the endorsement information (including tray and package number), but only want it to be populated with each package break, copy and paste the following expression into the "expression" column. You'll need to make sure that the length of that exported field is 40. PADR(IIF(!empt...
by Terry
Mon Jan 05, 2009 1:46 pm
Forum: Miscellaneous
Topic: Find records with certain number of words
Replies: 1
Views: 9827

To further that a bit, you can also use <= or >= for "less than or equal", or "greater than or equal"...

WORDS(address)>=3

...would give you any records that have 3 or more words, as well.
by Terry
Fri Dec 19, 2008 3:35 pm
Forum: Import/Export
Topic: Problems importing data when edited in Office '07?
Replies: 1
Views: 11536

Unfortunately, saving the file as a CSV is the only workaround. Excel files have formatting and structure issues that Excel can easily pick up and work around, but when you leave that environment and bring it into another application (like Microsoft Visual FoxPro, which AccuZIP6 is written in), a lo...
by Terry
Fri Dec 19, 2008 3:01 pm
Forum: Import/Export
Topic: ACCUZIP HEADERS
Replies: 1
Views: 11360

The field names cannot be modified once the file is presorted. You can see the field names that have been assigned within the Print Settings window, in the Database preview area. If you're exporting, you can change field names by first double-clicking your desired field from the field list. That wil...
by Terry
Fri Dec 19, 2008 2:58 pm
Forum: Import/Export
Topic: Exporting Zone Data for Periodicals or Bound Printed Matter
Replies: 0
Views: 9891

Exporting Zone Data for Periodicals or Bound Printed Matter

Some users have requested that the zone information be exported from a BPM presort. AccuZIP6 5.0 doesn't do this by default, but by following a few simple steps, you can get this functionality. 1. Close any databases open in AccuZIP6 5.0. 2. From the File menu, choose Open Database. 3. In the Open W...
by Terry
Mon Jul 07, 2008 1:08 pm
Forum: Printing
Topic: Printing Mail Pieces in AccuZIP6 5.0 in Vista or 7
Replies: 0
Views: 7333

Printing Mail Pieces in AccuZIP6 5.0 in Vista or 7

Follow these instructions to assign a specific printer to your label template: 1. Click on Start>Control Panel. 2. Go to Printers. 3. Find your desired driver. Right click it, and select "Set as Default Printer". 4. Edit your label template in AccuZIP6 5.0. 5. Click on Report>Printer Environment if ...
by Terry
Thu Jan 03, 2008 3:11 pm
Forum: Miscellaneous
Topic: Flash Help File not Displaying
Replies: 0
Views: 8739

Flash Help File not Displaying

The help file within the December/January version of AccuZIP6 5.0 uses Flash to integrate with your web browser. Many users experienced problems getting the flash integration to load correctly, so a non-flash version of the Help File has been posted to the following link: http://www.accuzip.com/webh...
by Terry
Fri Sep 22, 2006 3:38 pm
Forum: AccuZIP6 Future Releases
Topic: Option to export full length
Replies: 4
Views: 18513

A useful suggestion. One thing you may try doing, though, is increasing the width on the first export map that you save. If you're using a common export map, then by increasing the length of that field (sequence_ in this example) to 6 or 7, then the only time you'd run into an issue is if you had mo...