Export undeliverables in a script with watch folders

All things related to the Script feature of AccuZIP6, including the Script Monitor.

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:

Export undeliverables in a script with watch folders

Post by Eric » Fri Jan 30, 2009 11:29 am

Use this two line command to export your undeliverables. This command assumes you have the Script Monitor - Write Input Files command as the second event of your script

Code: Select all

com_InputFilePath=FILETOSTR("Cleanup.ini")
COPY TO (FORCEEXT(com_InputFilePath,"")+"_undeliverable.dbf") FOR dpv_="N"
To export as comma delimited text with the field names added as a header record:

Code: Select all

COPY TO (FORCEEXT(DBF(),"")+"_undeliverable.dbf") FOR dpv_="N" TYPE CSV
To export as comma delimited text with no header record:

Code: Select all

COPY TO (FORCEEXT(DBF(),"")+"_undeliverable.dbf") FOR dpv_="N" TYPE DELIMITED
If you want to export specific fields, use this:

Code: Select all

COPY TO (FORCEEXT(DBF(),"")+"_undeliverable.dbf") FIELDS first,last,zip FOR dpv_="N" TYPE CSV
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply