Cities and Towns in Koha

Cities and Towns in Koha

Koha can define cities or towns so staff have a standard list to pick from when registering a patron.

Setup

From your staff client, navigate to the More dropdown menu and select Administration > Patrons and circulation > Cities and towns.
  1. To add a new city, click the ‘New city’ button at the top of the page and enter the city name, state, zip/postal code, and country.
  2. city and zipcode are required
  3. Click submit. The city/town will be saved and will be listed on the city dropdown menu when creating a new patron.

Patron Registration Form

Once you have defined cities and towns in administration, staff will see those cities and towns in a pulldown menu to make city selection easy in the patron registration form.



If a patron does not live in any of the pre-defined cities/towns listed, a staff member can manually add one into their record. This can be done by typing in the City box instead of choosing an option from the dropdown.


Cleaning up your data

If a library is looking to transition to using cities/towns but wants to clean up the data in their database first, here is a handy SQL report to use:

Info
SELECT city, state, zipcode
FROM borrowers
ORDER by city

The results will be organized by city - which will make data adjustments easier!