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!



    • Related Articles

    • Authorized Values in Koha

      Authorized values can be used in several areas of Koha. They are what generally populate dropdown menus in Koha. Your system has pre-defined values that your library uses like LOST, Collection Codes, Shelving Locations, Not For Loan Values. ...
    • Item Types in Koha

      One of the key components of your library's collection will be the Item Type designation. Item types are a way for your patrons to identify what the item is and more importantly to Koha how this item circulates in your library. Here is a link to the ...
    • Cover Images in Koha

      Cover images can come from multiple sources in Koha including third-party sources or locally provided. Koha has several options when it comes to displaying cover images on the OPAC. System Preferences Users can choose from these system preferences ...
    • Creating a New Branch in Koha

      A new branch can be added to Koha at any time. <br> Adding a Branch Go to Administration > Libraries. An option to add a new branch will exist on the top of the page. Then the form will appear. The only required fields are Library code ...
    • Koha Calendar Options

      Calendars play a part in our everyday workflow. From events to who is covering the desk and more. This article covers everything from the staff interface to the OPAC. The calendar plays a centerpiece of the Koha Administration. Everything from ...