Support 805.461.7300
Sales
Our Technology. Your Success.
Tech Notes

Add Periodicals Zone Information to Database

The following technote shows you how to add a zone field to your presort file, which will allow you to see Periodicals zone information after you export your data.

  1. Pull down the File menu to Open Database.
  2. Browse to the C:\Program Files\AccuZIP6 5.0\iPresort\Templates folder, then open the presortout.dbf file.
  3. Pull down the Edit menu to Fields, then create a field named zone. Make it a character type field, with a width of 3.
  4. Close the presortout.dbf.
  5. Open the database that you'd like to presort.
  6. Presort the file, and in the Print Presort window, click on the Print Labels button.
  7. In Print Settings, click on the Output pull down menu and choose Disk File. Click Continue.
  8. Click on the Export All Fields box, or choose the fields that you'd like to export. If you're manually selecting fields, make sure you select the Zone field.
  9. Choose an export format from the Export Format pull down menu (choose AccuZIP6 5.x Database if you'll be opening this output file in AccuZIP6), then click Export.
  10. Give the file a name and decide where you want to save it, then click Save.

This output file that you've exported is your database in presort order, with zone information in the file.

« Back to Tech Notes

I am especially motivated to take time to draw attention to Vince. In two instances, we potentially faced loss of product – significant loss, but thanks to everyone’s efforts, most notably Vince’s, we ended up with minor re-work and zero loss of stock. He’s patient and thorough, knowledgeable and resourceful. And he’s patient – A Big Plus when dealing with me. Long story short, the guy was able to not only produce a solution, but to prove to me the veracity of it. I hung up the phone saving thousands of dollars in catalog stock, not lost but salvaged, and my department had to spend just a wee bit of time on job re-work (which I was happy to do, all things considered). But I also hung up with a peculiar urge to write about Vince, incongruent as that may be since I rarely am moved to write letters of this sort. So… In a time of crisis, Vince was a terrific asset and ally. If I were his boss, I’d attempt a merit raise authorization, he was that exceptional.
H.D., Shawnee Mission, KS