Data Testing in Koha

The following list helps you check to make sure that your data has migrated properly. Please take the time to thoroughly check your data before you go live.

Please note that the test site contains a snapshot of your current ILS when you first did the initial data extract.

Borrower fields

1. Search for patrons and take a note of the following:
1. Library branch
2. Patron types or category codes
3. Check whether all the patron information have been mapped correctly
1. Last name and first name
2. Address
3. Email address
4. Phone number
5. Borrower notes and/or messages, if any
6. Borrower debarments or restrictions, if any
7. Borrower attributes, if any
   

Bibliographic records and items

1. Check some of your titles with diacritics and make sure that they migrated properly.
2. Check titles in a series and make sure that series information migrated properly.
3. Search the catalog and make sure the item fields migrated over properly:
1. Item types
2. Item call numbers
3. Shelving locations
4. Collection codes
5. Public notes
6. Non public notes
7. Serials/enumeration (i.e. v.1, v.2, September 2020)
4. Check for the item status and make sure that they migrated correctly.
5. If you are migrating over serials, search for these records in the serials module and confirm that they look right.
6. Check the cataloging process to see if all necessary fields are available.
   

Circulation Transactions (checkouts, holds, and fines)

1. If you've migrated over holds, find borrower/patron accounts that have holds. This is very important. During the migration process, depending on the quality of the data, holds can be a bit "rocky" (so to speak) patch during the migration. If you have any questions as to what to expect, please ask your Educator and/or migration specialist.
1. Check to see if you can view the holds.
2. Check to see if the pickup branches look accurate.
3. Check suspended holds.
4. Did you migrate over waiting/on-the-shelf holds? Check to see how that everything appears to be in order.
2. If you've migrated over fines, find borrower/patron accounts that have fines. Compare the data to what you've initially extracted and check the following:
1. Did the fine types (lost, overdue, etc) migrate over correctly?
2. Are you able to view all the fines?
3. If you've migrated over partially paid fines, are they calculating properly?
   

As you've probably heard by now, the data migration process is a very fluid process. Your data migration specialist can refine your data throughout the migration process, so let them know if there's anything that needs to be updated with the data.

• Related Articles

• Preparing your Data for ILS Migration to Koha

  Once you have decided to switch to Koha, there are a few steps you can follow during your migration process with us to ensure a successful experience for you, your staff, and your library. What happens first? After you have done the initial data ...

• Tips for a successful data migration

  During your migration to Koha, diving deep into your data is one of the most crucial aspects of the process, and there are three things we'd like our onboarding partners to keep in mind: First and foremost, think about patron experience. Streamlining ...

• Record Indexing in Koha

  Koha relies on indexes for search, which also makes a search much faster. Koha uses an indexer to update the index when changes are made to the catalog. Sometimes things go awry or do not happen as quickly as expected. Here are some scenarios and ...

• Koha Glossary of Terms

  Find the basics of Koha's vocabulary here This glossary is in alphabetical order. Use control+F to quickly search this page for specific terms. Authority Record: allows your library to control and search fields in your MARC records such as subject ...

• Koha Development

  <br> How to Start the Process Submit a ticket to ByWater Solutions with your workflow or idea. ByWater Solutions will communicate to the partner, providing options for what we think the development would look like. You can read more about our ...