Database Code Tips

Database Code Tips

During a migration to Koha you may have to create new item types, collection codes, and shelving locations. When you add a new item type, collection code, or shelving location to your Koha system you have to decide what the database back end code will be and the description both you and your patrons will see. Feel free to make those descriptions as full as possible! On the otherhand, although it can be tempting to make the database codes as descriptive as your full descriptions it is better to keep those codes short and sweet! Here are a few rules that I use when helping our partners create new item type code, collection codes, and shelving location codes.

Tips

  1. Keep those codes at 10 characters or less
  2. Alphanumeric, always - no special characters (& _ - /)
  3. No spaces! Use 'EBOOK' instead of 'E BOOK'
Although this list of tips is short, it will ensure that your database is speaking properly to your staff client and OPAC. When we introduce incorrectly formatted codes to your system, searching is not as accurate and your patrons will not see the full benefits of your catalog.

If you have further questions about the codes you use feel free to reach out to your data specialist (if you are migrating) or your support vendor to provide more information!

    • Related Articles

    • 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 ...

    • 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 ...

    • 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 ...

    • 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 ...

    • 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 ...