Scripts Page

This page contains a collection of scripts that can be used to add more functionality to ZonePro. Scripts are actually mini programs that can be executed within ZonePro as needed. Many of these scripts were originally written to solve specific problems for specific customers. You can view the scripts by clicking on the links. You can download the scripts by right-clicking on the links and choosing the "Save Target" option.


USER DEFINED SCRIPTS

The files below are actually older examples. For the latest user scripts see our blog page dedicated to this topic: ZP User Scripts Blog

The following scripts are set up in the Maintenance Options section of ZonePro but run throughout ZonePro. These scripts are powerful ways to add customization to ZonePro.

User Scripts for Screens (ZP32 & ZPSQL)
This PDF document contains sample scripts that show what can be done with the "Screen" option in the User Script Screen. (Updated 06/19/2008)

User Script examples from the Newsletter (ZP32 & ZPSQL)
This PDF document contains examples of the scripts described in the ZP News newsletter which announced the expanded options available in the User Script Screen. (Updated 06/23/2008)

User Script examples from Customers (ZP32 & ZPSQL)
This document contains examples of the scripts that have been requested by customers to solve various issues. (Updated 02/03/2009)

More User Script examples from Customers (ZP32 & ZPSQL)
This document contains more examples of the scripts that have been requested by customers to solve various issues. This document will be added to as more such examples arise. (Updated 01/19/2010)

Internet Link Scripts (ZP32 & ZPSQL)
This document contains a special type of User Defined Script assigned to Internet Link button on the Property Screen. Most of these scripts are county-specific. (Updated 11/20/2008)    TOP

DATABASE BROWSER SCRIPTS

The following scripts are specific to ZonePro 32 and are run from the Database Browser option in the ZP Toolbox Module.

Active Property Records Script (ZP32)
This document contains a script that runs from the Database Browser screen. The script tags every Property record that has at least one Building, Zoning, Housing or Appeals permit attached. (Updated 01/23/2006)

Contractor EOY Script (ZP32)
This document contains a script that runs from the Database Browser screen. The script takes fee information in the Contractor database and copies it to the Notes field. This is useful at the end of the year so that when contractors begin renewing, the old fee information is still available for reference. You'll need to update the year information if you plan to use this script in successive years. (Updated 01/03/2006)

Duplicate Parcel Script (ZP32)
The document contains a script that runs from the Database Browser screen. This script searches through the property database and tags every record that shares a parcel number with any other record. This script uses the Tag field of the Property Screen to mark records. After running the script, you can use the Mailing Labels Screen to produce a list of your duplicate parcel records. (Updated 10/23/2007)

Duplicate Address Script (ZP32)
The document contains a script that runs from the Database Browser screen. This script searches through the property database and tags every record that shares an address with another property. This script uses the Tag field of the Property Screen to mark records. After running the script, you can use the Mailing Labels Screen to produce a list of your duplicate parcel records. This script uses a fancy SQL technique to hunt for duplicates. (Updated 01/07/2009)

Mismatched Building Details Script (ZP32)
This document contains a script that runs from the Database Browser screen. This script is useful if you have mismatched permit type listings in the four main building maintenance databases. It is very unusual that this would happen but the script was written for a customer that managed to do it. (Updated 07/21/2006)

Multiple Record Counting Script (ZP32)
This document contains a script that runs from the Database Browser screen. This script was written for a customer that only wanted to report on properties that had more than one violation over the course of a year. This script tallies up the number of violations for a given date range and plugs that number into a field in the property database. You can then run reports based on the value of that field. (Updated 01/25/2007)

Orphan Hunter Script (ZP32)
This document contains a script that runs from the Database Browser screen. This script is for finding permit records that reference a non-existent property record. These orphaned records should not exist in ZonePro but in the unlikely event that they do this script can find them and remove them. (Updated 11/16/2006)

Property Address2 Script (ZP32)
This document contains a script that runs from the Database Browser screen. The script attempts to fill in any blank City/State/Zip fields for the parcel location in the Property database. It looks to see if the owner lives on the same street as the parcel location and if so it copies the owner's city, state and zip to the location City/State/Zip field. (Updated 10/20/2004)

Property Occupant Name Script (ZP32)
This document contains a script that runs from the Database Browser screen. The script attempts to fill in any blank occupant fields in the Property database based on whether the owner lives at the same address as the parcel location. (Updated 11/08/2004)

Random Sample Script (ZP32)
This document contains a script that runs from the Database Browser screen. The script tags a random sample of Property records for use with surveys, etc.. You can set the number of properties tagged by changing a variable in the script. (Updated 06/21/2005)

Rental Status Script (ZP32)
This document contains a script that runs from the Database Browser screen. Although the rental database allows multiple records per property, only one of those records should have a Rental Status of "Active" an any one time. This script checks the rental database for violators to this rule. (Updated 06/26/2009)    TOP

MISCELLANEOUS SCRIPTS

Custom Button Labels (ZP32 & ZPSQL)
You can change the names of the application buttons that appear on the Property Screen. You do so by adding a text file to your installation folder that tells ZonePro what names to subtitute for the default names. Each application group (Zoning, Building, Housing, General) would have its own text file. You only need a file for the group you wish to change. The text file is a simple list of five applications names, using the percentage sign as a delimiter. This download includes a text file for each group and shows how the file should be formatted. Add one of the text files to your main ZonePro folder and change a label to see how it works. (Updated 2/3/2009)

Multiple Fees Memo Script (ZP32)
This document contains a script that demonstrates how to assign multiple fees to an application record using the Notes fields. See the Training Videos page for a run through of this script. (Updated 03/14/2008)

Name Splitting Script (ZP32 & ZPSQL)
This document contains a script that greatly improves the name splitting efficiency of the Compare Module. You can further customize this script so that it works even better with your specific parcel input file. (Updated 07/21/2006)    TOP