Dupl Address Edit

About Duplicate Addresses

Circulation enables you to enter more than one occupant for the same address—several coworkers in one office, for example. Sometimes, however, the same address is mistakenly entered twice. Select Duplicate Address Edit to compare duplicate addresses and decide which addresses, if any, should be removed.

Business Rules determine whether Circulation accepts a duplicate address and whether a warning appears.

Note:

Two addresses are duplicates only if they have the same Zip code, street name, house number, house modifier and unit number (they can have different street suffixes, prefixes, and street types). These criteria are summarized in following table (in Dupl Addr Purge all items except occupant must be identical in order for two addresses to be considered duplicates). Also, military and foreign addresses (where all of the street address fields are blank) will be skipped. See Address for more information about addresses.

Are the same in duplicates	Can be different in duplicates
Zip code	Street suffix (for example, “North” in “30th Ave North”)
Street name	Street prefix (for example, “North” in “North 30th Ave”)
House number	Street type (for example, “Ave” in “North 30th Ave”)
House modifier (for example, “a” in “23a Portland Ave”)	Occupant name
Unit #

Editing Duplicate Addresses

To help you execute your decisions more quickly on screen, duplicate addresses are printed in the Duplicate Address Report the same as they appear when you select Dupl Address Edit.

Use the following procedure to edit duplicate addresses:

• Select Dupl Address Edit from the Subscription/Address menu to display the Duplicate Address Edit screen.

• Select Add. In Starting Address, enter the ID of the first address to check for duplicates. (When an address is brought into the Circulation database, either by operator entry or via conversion from an old data system, Circulation assigns it a unique numeric ID.) Also indicate whether the report should include only exact matches (exact matches must match on all of the items listed in the above table).

Note:

The first time you select this option, accept the default value of zero in Starting Address. If you need to stop checking address duplicates for one reason or another, you can continue later where you left off by entering in Starting Address the ID of the last address you checked.

• Select Continue to begin the edit process. Circulation will check the database for duplicates of the first address (from Starting Address). It will then check for duplicates of the next address, moving up by address ID. If there is more than one duplicate for an address, the address will be paired with the best match. This means you may have to run Duplicate Address Edit more than once to find all duplicate addresses.

• Circulation will display the first duplicate address match.

• You will have four options with this set of duplicate addresses:

  • Keep address 1 (enter “1”)

  • Keep address 2 (enter “2”)

  • Keep both addresses (enter “n”)

  • Quit the edit process (enter “q”)

  If both addresses have occupants, you will have the same options available for editing the occupants (except for Quit). If you delete one address but keep both occupants, the occupants will be listed together under the remaining address. Subscription information is never deleted, just reassigned to the retained occupant/address.

• Continue with the edit until all addresses have been reviewed or you are ready to quit. A report will appear, listing information about the addresses you edited (the standard viewing and printing options are available).

Example—Duplicate Address Edit Report