Dupl Address Report

Circulation can create a report listing all duplicate addresses in the Circulation database. Using the report, you can locate problem addresses, and run Duplicate Address Edit more efficiently. The criteria for determining duplicate addresses is the same in both functions (see the table on Dupl Address Edit).

To create this report:

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

• Select Add and enter the ID of the first address number you want included in the report in Starting Address. Also indicate whether the report should include only exact matches.

• Select Continue to process the report.

Example—Duplicate Address Report

Dupl Address Purge

Duplicate Address Purge allows you to remove all duplicate addresses after a specified address number, at one time. The address with the lowest address number is retained, and occupant and subscription information associated with duplicate addresses is automatically assigned to the remaining address. If duplicate occupants are encountered (i.e., first name, last name, and phone are a perfect match), the oldest occupant record is kept.

To qualify as duplicate addresses, two addresses must have the same:

• Zip

• Street

• House #

• House Modifier (for example, “a” in 401a Portland Ave”)

• Street Prefix (“North” in “36 North Portland Ave”)

• Street Suffix (“North” in “36 Portland Ave North”)

• Street Type (“Ave” in “36 Portland Ave”)

• Unit #

Note: Use Duplicate Address Purge only if you want to get rid of all duplicate addresses within the database. For example, if many of your addresses have rural routes, you should not use this option.

To purge duplicate addresses:

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

  
• Select Add. In Starting Address, enter the ID of the address where purging should begin (addresses with a lower ID number will be skipped). Also indicate whether the report should include only exact matches (exact matches must match on all of the items listed on Dupl Address Edit).

• Select Continue to begin purging duplicate addresses. In this process, Circulation automatically reassigns all information associated with each address in a set of duplicates to the one retained address. For example, if the addresses whose IDs are 45, 2615, and 10045 are duplicates, only address 45 is retained in the database and all information associated with addresses 2615 and 10045 is assigned to address 45.

• As part of the purge process, the Duplicate Address Purge report will be created.

Example—Duplicate Address Purge Report