To create a new Finalist database for selected states, follow these steps:
- Build a State List containing the names of the states you want to include in your new Finalist database.
- Define the Path to the Finalist Database Files. The State Cut feature will get the data for your selected states from these database files. You must specify the location for both the City database and the ZIP + 4 database.
- Define a name and path for the Finalist database files you want to create to contain the data for the states you selected in step 1.
- Run the State Cut program to build your new database files.
To create a new Finalist database for your selected states, follow these steps.
- Start the Finalist Workbench.
- From the Tools menu, click Run Distribution or click the DIST icon on the Workbench toolbar. The State Cut Process dialog box displays.
-
To build a list of states to be included in the new database file, select states for the State List using one of the following options:
- Single-click the state abbreviation and name in the left-side State List box. Click on the right arrow button.
- Double-click the state abbreviation and state name in the State List box.
- With the mouse cursor active in the State List box, type in the state abbreviation of the state you want to select. The state abbreviation and name appears in a highlighted mode. Click the right arrow button to move the selected state to the Selected State box.
The selected state appears in the Selected State box for selected states. Repeat for each state you want to include in the new database file to be created.
-
To remove states from the list of selected states in the
Selected State box, use one of these options:
- Single-click the state abbreviation and name in the Selected State box. Click on the left arrow button.
- Double-click the state abbreviation and state name in the Selected State box.
- To empty all selected files from the Selected State box, click Clear.
- Click Save to save your state list file. The Open dialog pop-up appears. Use the Open dialog pop-up to create a new file or overwrite an existing file.
-
To load the your newly created state list, follow these steps:
- From State Cut Process Dialog Box, click Load.
- Use the Open dialog box to locate and select the state list file containing the states you want in your new Finalist database file. Your state list file appears in the Selected State box. After loading the file, you may remove or add states and save your new selections before running the state cut program.
-
To define the path to the Finalist database files to use for building your state database, follow these steps:
- In the City Base field, use the Browse button to identify the location of the Finalist City database file.
- In the Zip4 Base field, use the Browse button to identify the location of the Finalist ZIP + 4 database file.
-
To define a location and file name for the your state database file, follow these steps:
- In the New City Base field, use the Browse button to identify the name and location of the Finalist City database file.
- In the New Zip4 Base field, use the Browse button to identify the name and location of the Finalist ZIP + 4 database file.
-
After building and loading your state list file, defining the path to the Finalist database files, and defining the name and path for the state database file you want to create, you are ready to run the State Cut program. Click the Run button.
If you decide not to run the state cut program, click Cancel to return to the Finalist Workbench window.
Note: If the mouse cursor is active in one of the State List boxes, the run command will also be initiated when you click Enter on the keyboard.