How do I update street order fields?

Master Records

Use this routine to split the address that is saved in the Address field into a apartment/unit, house number suffix, street, and street direction. Making this change to the address field means the address will use the same format in the application so you can sort records more efficiently, standardize the addresses that print on reports and forms, link records to a master contact, and so on.

	Apartment/Unit	House Number Suffix	Street	Street Direction
180 S Commerce Ave		180	Commerce Ave	S
1944 S Lake Rd #100	#100	1944	Lake Rd	S
555 Oak Hills Dr apt D3	apt D3	555	Oak Hills Dr

Contents

How do I update street order fields?
1. Before you get started
1. Updating street order fields

Before you get started

Back up the database. See the help topic titled How do I back up a database?

Updating street order fields

1. Open Connect System Management > Master Records > Update Street Order Fields.

2. Select the Application.

Use the Application drop-down list to select the application that has the street order field that you want to parse into apartment/unit, house number suffix, street, and street direction.

Selecting Utility Management application

3. Set up the Selection Criteria.

Select the address field name to parse. You need to know the table name and the field name that is assigned to the address field in the table. For example, "Location.Street address" will select the values in the field titled Street Address in the Location table.

Double-click on the column heading titled Column.

Column header

Use the Selection form to find the address field name in the Available Criteria Fields list, and then double-click it.

Location.Service Address field

Click OK.

The address field name displays in the Selection Criteria.

Selection Criteria

4. Set up the checkbox titled Replace Existing Information.

When you run Update Street Order Fields, Connect splits the value in the address field into the apartment/unit, house number suffix, street, and street direction. Use this option to replace the values saved in the apartment/unit, house number suffix, street, and street direction with the new values.

What do you want to do?

I only want to parse addresses that haven't been parsed before. Do not select the checkbox titled Replace Existing Information.
I want to replace values for all addresses. Click to select the checkbox titled Replace Existing Information. If you run this routine and you want to revert to the previous values, use the backup file.

5. Click GO (CTRL+G).

The routine reviews the addresses in the selected address field and splits the address into the apartment/unit, house number suffix, street, and street direction. The routine saves the parsed address. You can use the routine in the application that uses the addresses field to review the parsed values and make updates to addresses that were parsed incorrectly.