Question: How can I find out what version of Koha I am using?

Answer: The easiest way to find out your Koha version is taking a look at the About page of the staff interface.

You can also find out from the OPAC by taking a look at the HTML source. It will look something like:

<meta name="generator" content="Koha 18.1200000" /> <!-- leave this for stats -->

Question: Should I use the Debian packages or the tarball to install Koha?

Answer: For the beginning user, it is highly recommended to use the package install of Koha - it provides many simple commands to do powerful things to your Koha installation. Packages should almost always be your choice of install on an ordinary production Koha install. A relative minimum of system administration skill is required to install Koha using the Debian packages.

Instructions for using the packages with Debian.

Installing from tarball or git is the only option for people not installing on Debian or Ubuntu.

Developers should give the KohaDevBox a look, it’s the easiest, quickest way to get a Developer instance of Koha going.

OPAC and staff interface

Question: What cookies does Koha use?

Answer: The cookies Koha uses on the OPAC and in the staff interface are documented in the Koha Community wiki:




問: 可以客製化自己的館藏類型 (或容許值) 圖示嗎?

**答:**一定可以的。新增一個資料夾於 koha-tmpl/intranet-tmpl/prog/img/itemtypeimg/ 與 koha-tmpl/opac-tmpl/prog/itemtypeimg 內,再把新增的圖示置入其中。您的圖示將顯示在新的分頁裡。

  • 說明

    記兩個地方都要放圖示 (OPAC 與館員介面)。

客製化 Koha 圖示

:可以客製化 OPAC 內的圖片嗎?

:一定可以的。Koha 預設若干圖片供您選用。置於 misc/interface_customization/ 資料夾內。

OPAC 顯示欄位

:可以在 Koha 的 OPAC 顯示不同的 MARC 欄位嗎?

:必須設定 XSLT 偏好才能顯示以下的欄位

OPAC 結果頁面顯示:

  • 245

  • 100, 110, 111

  • 700, 710, 711

  • 250

  • 260

  • 246

  • 856

OPAC 詳情頁面顯示:

  • 245

  • 100, 110, 111

  • 700, 710, 711

  • 440, 490

  • 260

  • 250

  • 300

  • 020

  • 022

  • 246

  • 130, 240

  • 6xx

  • 856

  • 505

  • 773

  • 520

  • 866

  • 775

  • 780

  • 785

  • 加在下方 『附註』 分頁顯示所有的 5xx 欄位



:預設是不行,但修改讀者紀錄的幾個地方後就能讓條碼欄位顯示在 OPAC 內讀者借出摘要欄內。設定 讀者屬性 中 SHOW_BCODE 的值與 容許值 中 YES_NO 的值就可以。


然後在 讀者紀錄設定值 裡把 SHOW_BCODE 設為 yes。


將在 OPAC 新增借出摘要欄,顯示借出館藏的條碼。


按 『逾期』 分頁將祗顯示逾期的館藏。


Fees and fines

Question: Why am I getting fined 5.00 for every loan?

Answer: The money you are seeing on your patron’s account isn’t a fine, but a rental fee. The optional default item types that come with the Koha sample data might contain a rental fee. To remove this fee, do the following:

  • Click More > Administration

  • Click Item types

  • Note which item types have a 5.00 fee associated with them, select them for editing

  • Remove the fee, and save the item type

Book drop


:假設,圖書館關閉四天重新裝潢,還書箱實際上開放超過一天。您必須設定擲入還書箱的日期為上個圖書館的開放日 (定義在圖書館行事曆內) 因為無法得知在 4 天的閉館期該館藏實際投入的日期。改變實質擲入還入箱日期的方法是修改行事曆。

可以用 SpecifyReturnDate 系統偏好設定不同的還入日期。根據任何日子及逾期罰款金額,重新計算金額。


預約佇列 報告與 取出預約 報告有何不同?

:取出預約報告是一個清單,取出可用的館藏供預約之用。它顯示資料庫的 『活性』 資料,可以立即顯示新的預約。顯示所有圖書館可供預約的每筆資料。


The holds queue report is generated by the build_holds_queue.pl cron job. By default it runs hourly, but it might be changed to run at any other interval. There are various configuration options to determine the library to provide the item. For example:




Additionally the overdue notice cron job has a setting to generate the overdue notices as HTML for printing. An example of this usage would be:


overdue_notices.pl -t -html /tmp/noticedir -itemscontent issuedate,date_due,title,barcode,author

在此例中,我們在通知內祗使用館藏的特定欄位,因此指定 itemscontent 欄位於排程款目內;這個不是必備的功能。

命令列需要指明列印通知時用到的網頁可及的資料夾 – 像這樣的檔名 notices-2018-11-24.html (或 holdnotices-2018-11-24.html)。逾期通知本身可以格式化為 Z-mailer。在通知檔內,文字經過調整可以適當地列印。以腳本包裝通知檔告知 HTML 遵守此格式,並在各通知間分頁。所以,館員才能一頁頁地列印它們。系統偏好 PrintNoticesMaxLines 用於設定頁面長度,以符合借出筆館藏讀者的需要。此系統偏好可截切列印通知為一頁的長度,並說明可從 OPAC 查看完整的逾期通知。

The cron entry is gather_print_notices.pl /tmp/noticedir


:我們想為讀者續借。其中一個館藏被別人預約無法續借,另兩個館藏沒人預約卻不能續借。我想啟用凌駕續借限制功能,卻得到 「續借失敗」 訊息。怎麼辦?

Answer: At the very least you will need to set an absolute default circulation rule. This rule should be as standard rule for all libraries, 『All』 itemtype』, and 『All』 patron category. That will catch anyone who doesn’t match a specific rule. Patrons who do not match a specific rule will get blocked from placing holds or renewing items, since there was no baseline number of holds or renewals to utilize.



Answer: You probably need to set a default circulation rule in your Circulation and fines rules. At the very least you will need to set a default circulation rule. his rule should be as standard rule for all libraries, 『All』 itemtype』, and 『All』 patron category. That will catch all instances that do not match a specific rule.

The ability to place holds also depends on the 『On shelf holds allowed』 setting in the used circulation rule. Depending on the setting, it might not be possible to place a hold, unless all or at least one item of the record is checked out.



:可以使用以下的鍵盤熱鍵在螢幕上方的搜尋盒分頁間移動 (若定位鍵可用):

  • 按著Alt+q,進入搜尋目錄

  • 按 Alt+u 進入借出

    • 麥金塔電腦不能使用此功能

  • 按著Alt+w,進入續借分頁

  • 按著Alt+r,進入還入


    麥金塔電腦以 OPTION 鈕取代 Alt

SMS 通知/訊息

:讓 Koha 以 SMS 方式送出通知,怎麼做?

:首先選定Koha使用的SMS服務商。有個清單在此:http://search.cpan.org/search?query=sms%3A%3Asend&mode=all 並非所有的SMS服務商提供圖書館所需的Perl驅動程式,應再次確認清單的正確性。不行的話,換服務商。美國常用到的服務商(提供Perl驅動程式)如下:

Alternatively you can configure Koha to send SMS via Email. In order to use this feature you need to set the SMSSendDriver system preference to 『Email』 and confiugre the email gateways for the different SMS cellular providers of your patrons.

In any case you might want to check if sending SMS to your patrons is legal in your location.


Answer: India does not yet have too many options here. This is partly due to the Telecom regulatory authority’s (TRAI) stipulations about transactional SMSes and limits on the number of SMSes that may be sent/received per users per day. India specific drivers include:

Email notices/messages

Question: How do I prevent my libraries notices ending up marked as spam?

Answer: This is a complicated topic, but thankfully Koha gives you a good degree of control via various system preferences.

For every email sent out from Koha there are three important addresses for the system to get correct, From, Reply-to and Sender. These are configurable at both the system and library level and should fallback in a suitable manor if any of them are not defined.

  • KohaAdminEmailAddress - This will act as the From address and should be an address in the same domain as the koha server [for example noreply@koha-hosting.org]

  • ReplytoDefault - This will act as the Reply-to address and can be in any domain [for example librarian@mylibrary.com] and this is the address which will be used if/when a patron hits 『Reply』 in their email client. Note: This will fall back to KohaAdminEmailAddress when it is not set.

  • ReturnpathDefault - This will act as the Sender address and also needs to be within the koha/email servers domain [for example postmaster@koha-hosting.org] and this is the address which will be used to report if an email bounces for any reason.

There are parallels to all the above preferences at the per branch level which fall back in the same order as mentioned aboved before falling back to the system level preferences above when required.

If you have the above configured correctly and your emails are still being treated as spam then you likely need to contact your email service provider/dns provider and look into MX, SPF and DKIM records.



問: 為什麼不能在我的目錄紀錄裡編輯 1xx、6xx、或 7xx 等欄位?

答: 這些欄位是權威控制用,您可能把 BiblioAddsAuthorities 偏好設為 「不允許」。設為 「不允許」 時,這些欄位就被鎖住,指定搜尋現有的權威紀錄使用。必須把 BiblioAddsAuthorities 偏好設為 『允許』 就能編輯這些欄位。




Question: Can I use Koha without creating authority records?

Answer: If you don’t want to create authorities for your reacords at all, you can remove the authority link by blanking the Thesaurus setting for the fields in your MARC bibliographic frameworks. See also: Edit framework subfields

Koha to MARC mapping

Question: What’s the relationship between 『Koha to MARC mapping』 and 『MARC bibliographic frameworks』?

Answer: Mappings can be defined through 『MARC bibliographic frameworks』 OR 『Koha to MARC mapping』. 『Koha to MARC mapping』 is just a shortcut to speed up linkage. If you change a mapping in one of these modules, the mapping will change in the other as well. In other words, the two modules 『overwrite』 each other in order to prevent conflicts from existing in Koha.

Number of items per bibliographic record


Answer: There is no limit to the number of items you can attach to a bibliographic record. For records with a big number of items exporting the MARC record as ISO 2709 might be problematic as this format has a size limit. Item numbers somewhere between 600 and 1000 items on a 『normal』 bibliographic record should be ok.


Question: I am using the EasyAnalyticalRecords feature, but my links in the OPAC and Staff client to 『Show analytics』 are not working.

:使用 EasyAnalyticalRecords 功能前,先設定 UseControlNumber 偏好為 「不使用」,就可避免破碎的連結。


Planning categories



假設計畫在一月使用 $1000、二月使用 $1000、三月使用 $3000 等。就可依月份規畫它。


  • 小於 1 個月

  • 小於 6 個月

  • 小於 1 年

  • 小於 3 年

  • 小於 10 年

  • 大於 10 年

The list is meant to represent when the books acquired were published. Then you plan for it, saying: we want to spend at least 40% of our budgets on books published less than a year ago, 10% on books more than 10 years old, etc.

Upon acquiring new material, you’ll be able to select, for a given item, a value from this list in a drop down. Then, after the material has been acquired, at the end of the year, you’ll be able to compare the goals set with what’s been achieved.


Advanced patterns

:在進階期刊模式介面裡 『內部計數器』 是什麼?



  • 第一期的出版年:2010 年 4 月

  • 編碼:{X}號,{Y}年

  • 第一期:4 號,2010 年

對 Y 年而言:您需要在 2011 年元月變更它

所以,Y 的進階模式將是:

  • 增加:1

  • Every : 12

  • When more than: 9999999

  • Inner counter: 3

  • Set back to: 0

  • Begins with: 2010

Year is going to change after 12 received issues from April 2010, that is in April 2011 if you don’t set inner counter. Set inner counter to 3 will say to Koha: change year after 12-3 = 9 received issues.

內部計數器告訴 Koha 把第一期的出版月份納入考量,即使沒有簽收亦然。若第一期從一月開始可以設定為 0 或不設定。


SQL help

Question: I don’t know SQL, but I want to write a report that does X. Can you tell me how?

Answer: The Koha reports library on the Koha wiki is a good starting point and contains a lot of SQL reports shared by other libraries that can be reused and adapted.

Koha’s database schema is also publicly documented and contains helpful notes on how the columns in the various tables are used.

If you get stuck people on the community mailing lists will often be willing to help you.

Codes stored in the database

Statistics table

詢問: 統計表格裡類型欄位代碼是什麼?


  • localuse

    • 若館藏已被統計讀者 (類型 = 『X』) 借出,登記為還回

  • 還入

  • 續借

  • 核銷

  • 付款

  • CreditXXX

    • 以 XXX 代表不同類型的罰款額度,所以詢問時將包括像這樣的句子 「type LIKE 『Credit%』」

Reserves table

詢問:在 reserves 與 old_reserves 表單裡可能的代碼為何?


  • NULL:表示讀者要求第 1 個可用的館藏,我們沒有選擇該館藏

  • T = Transit: the hold is linked to an item but is in transit to the pickup library

  • W = Waiting: the hold is linked to an item, is at the pickup library, and is waiting on the hold shelf

  • F = 完成:完成保留並做好

Reports dictionary table

詢問:在 reports_dictionary 表單裡可能的區域代碼為何?


  • 1 = 流通

  • 2 = 目錄

  • 3 = 讀者

  • 4 = 採訪

  • 5 = 帳號

Messages table

詢問:在訊息表單的 message_type 欄位裡可能的代碼為何?


  • L = 圖書館員

  • B = 供讀者之用

Serial table



  • 1 = 預期

  • 2 = 到館

  • 3 = 遲到

  • 4 = 遺失

  • 5 = 不可得

  • 6 = 刪除

  • 7 = 催缺

  • 8 = 停訂

  • 41 = 遺失 (未簽收)

  • 42 = 遺失 (售完)

  • 43 = 遺失 (毀損)

  • 44 = 遺失 (不見)

Borrowers table

Question: What are the possible codes for the privacy field in the borrowers and deleted_borrowers tables?


  • 0 = 永遠

  • 1 = 預設

  • 2 = 永不

Patron categories table

Question: What are the possible codes for the category types?


  • A = Adult

  • C = Child

  • I = Organization

  • P = Professional

  • S = Staff

  • X = Statistical

Messaging preferences

: borrower_message_preferences 表單的 message_attribute_id 欄位裡有那些代碼?


  • 2 = 進階通知

  • 6 = 借出館藏

  • 4 = 預約到館

  • 1 = 館藏到期

  • 5 = 館藏還入

Runtime parameters

:可以在執行前篩選客製化的 SQL 報表嗎?

Answer: If you want to make your reports easy to reuse with different filters and date ranges, you can add runtime parameters to your query. Runtime parameters basically make a filter appear before the report is run.

There is a specific syntax that Koha will understand as 『ask for values when running the report』. The syntax is <<Question to ask[|type]>>.

  • << 與 >> 祗是區隔符號。必須鍵入 << 於參數前並鍵入 >> 於結尾處

  • The 『Question to ask』 will be displayed as a label before the form field.

  • The type can be omitted if you want a free text input field. If it contains an authorized value category, 『branches』 (libraries), 『itemtype』 (itemtypes), 『categorycode』 (patron categories), or 『biblio_framework』 (MARC bibliographic frameworks), a pull down will be displayed with the options from your configuration instead of a free text field.

  • When using 『date』 as type, the date picker will be displayed to help with entering dates. The date will be automatically changed to the ISO date needed for the SQL query, while you can enter it according to your dateformat system preference setting.

  • Note that you can have more than one parameter in one SQL query. If you need the same value multiple times in your SQL query, make sure you use the same label. This will make the form field only appear once.

  • 執行時未鍵入資料,難以預測執行結果。被視為 「空白值」 而不是 「忽略此參數」。如,在 : 「title=<<Enter title>>」 未鍵入資料,則顯示為 with title=』』 (no title)。若想要有些非必備的資料,則使用 「title like <<Enter title>>」 再鍵入 % 符號,不要使用空白。


  • SELECT surname,firstname FROM borrowers WHERE branchcode=<<Enter patrons library|branches>> AND surname like <<Enter filter for patron surname (% if none)>>

  • SELECT * FROM items WHERE homebranch = <<Pick your branch|branches>> and barcode like <<Partial barcode value here, use % to truncate>>

  • SELECT title, author FROM biblio WHERE frameworkcode=<<Enter the frameworkcode|biblio_framework>>



    You have to use 『like』 in your SQL query and put 「%」 in a text box to 『leave it blank』. Otherwise, it literally looks for 「」 (empty string) as the value for the field.


Wildcard searching

:使用 『*』 (星號) 與使用 『%』 (百分號) 的鍵詞搜尋有何不同?搜尋目錄時,兩者送回不同的結果。為什麼?

:可用四個萬用字元 (*、?、%、.) 代表英文字裡的一個或多個字母。Koha 祗使用星號 (『*』) 與百分號 (『%』) 兩個萬用字元。然而,這兩個字元在搜尋時作用不同。

星號 『*』 取代在 『*』 之後的字元。搜尋時祗要前幾個字元相同,星號就可取代無限制的字元。例如,搜尋作者,Smi*,將搜尋 Smith、Smithers、Smithfield、Smiley 等,在資料庫裡的作者。

百分號 『%』 將輸入的鍵詞視為 「是這樣」。所以搜尋 Smi% 會搜尋出像 Smi 的鍵詞。此結果與搜尋清單大為不同。例如,搜尋 Smi% 將送回資料庫裡包括 Smothers、Smith、Smelley、Smithfield 與其他鍵詞。

The bottom line in searching with wildcards: 『*』 is more exact while 『%』 searches for similar terms.

Title searching

:為什麼我的 Zebra 題名搜尋 『Help』,在第一頁的搜尋結果,找不到 『The help』 呢?

Answer: In general, the more terms you enter, the better your results will be. Koha doesn’t use stop words, so searching for 「the」 and 「an」 will work just fine. So 「the help」 shoudl bring better results than just a title search for help. Also using 「Title, phrase」 would further improve the results as it means that these terms have to appear in this sequence and with no other terms in between.

Some system preferences are known to affect relevancy ranking negatively. These are QueryAutoTruncate and UseICU. With the latter also requiring the server setup to actually use ICU for indexing.

Note: If multiple results have the same relevancy score, they will be sorted by biblionumber as second criteria.

重設 Zebra 索引

執行以下的指令以重設 Zebra 的權威與書目索引。

$ zebraidx -c /etc/koha/zebradb/zebra-authorities-dom.cfg -g iso2709 -d authorities init
$ zebraidx -c /etc/koha/zebradb/zebra-biblios.cfg -g iso2709 -d biblios init

執行套件安裝時,需執行下列指令以重設 Zebra 權威與書目索引:

$ sudo zebraidx -c /etc/koha/sites/YOURLIBRARY/zebra-authorities-dom.cfg  -g iso2709 -d authorities init
$ sudo zebraidx -c /etc/koha/sites/YOURLIBRARY/zebra-biblios.cfg  -g iso2709 -d biblios init

以安裝 Koha 時的名稱取代 YOURLIBRARY。

Enhanced content


All Amazon content

:我打開 Amazon 所有的偏好,且鍵入我的密碼,但沒有任何內容顯示在系統內,為什麼?

:Amazon 的 API 檢查所有詢問的伺服器時間,若沒有適當的設定伺服器時間,不會回應詢問。祗要妥當地設定系統時間,就可解決此問題。改變後,Amazon 內容應會立即出現。

Debian 的指令是 date -s 「2010-06-30 17:21」 (就是您時區的日期與時間)。

Amazon also requires an ISBN for displaying book covers - make sure that you have the correct ISBN for your title. If you are having trouble with a book that seems like it should have a cover but doesn’t turn one up, give it a try with the 10 digit ISBN in the first 020a. If you have a 10 digit and it’s not turning up, try with the 13 digit ISBN in the first 020a.

Server administration

Making Z39.50 target public

Question: How can I configure Zebra to make my database searchable via Z39.50?

:編輯 KOHA_CONF 檔案。其 publicserver 列如下:

<!– <listen id=」publicserver」 >tcp:@:9999</listen> –>


<listen id=」publicserver」 >tcp:@:9999</listen>

然後重新啟動 zebasrv 並連結至指定的埠 (9999)。

Shelving location authorized values


Answer: One possible reason is that you created the location in the LOC authorized value category with the code 『』 or 0 (zero). This will be treated as 『no location』 and not display correctly.

Why do I need authorized values?

詢問:為什麼要在 MARC 欄位中設定容許值?

Answer: Authorized values create a 『controlled vocabulary』 for your staff. As an example, let us assume that your Koha installation is used by several libraries, and you use MARC 21. You might want to restrict the 850a MARC subfield to the institution codes for just those libraries. In that case, you could define an authorized values category (perhaps called 「INST」) and enter the institution codes as the authorized values for that category.


Koha 自動設定館藏類型與分館代碼的容許值範疇,且在設定 MARC 欄位結構時把這些容許值連結至 MARC 分欄。



Answer: You can regularly run the cleanup database cron job.

或在執行備份指令 (mysqldump) 前,先切截活動表單:

mysql -u<kohauser -p<password <koha-db-name -e 'TRUNCATE TABLE sessions'


Barcode scanners

:那種條碼掃瞄器適用於 Koha?

Answer: The simple rule of thumb is: does it act like a keyboard device? If so, it will work. (i.e. can you take the scanner, scan a barcode and have it show up in a text editor.)

檢查的重點是,它和您的 PC 可以輕鬆地連結 (經由 USB 或 「鍵盤機制」 就是與鍵盤連在一起,舊型電腦用這種方法),且可掃瞄您使用的條碼類型。

測試 『使用中』 的條碼不失為好主意,可以讀出資料就可以。大部份的掃瞄器可以讀取多種格式的條碼 – 有很多,且列出可以讀者的規格。或許需要稍為調整設定,前置或後置字元,或同時送出 『歸位』 字元。

還有一點 - 某些機種可以設為 『總是開啟』 且有支架,有些在把手下有個按鈕,有些在上方有個鈕,有些看起來像隻筆。以館員工作的舒適度為選取的依據,錯誤位置的鈕使用起來很怪。


Koha 圖書館使用的印表機

General rule of thumb here is that if you can print with the printer from your browser, it will work with Koha.

  • POS-X 收條印表機

  • Star Micronics 列表機 (正確型號不詳) 含通用/文字驅動程式。

  • Star SP2000 (Nelsonville)

  • Star TSP-100 futurePRINT (Geauga)

    • 「我知道收條印表很有問題,所以提供我的經驗。我們試過 Star TSP-100 futurePRINT。該款印表機很容易組態給 Koha 使用。甚至在每個收條加上我們系統的標籤 (一個 .gif 檔案)。也可在收條最後加上若干連絡資訊、開館時間與圖書館網址等與借出有關的資料」。

  • Epson TM 88 IIIP 熱感應收條印表機

  • Epson TM-T88IV

  • Dymolabelwriter 印表機用的 1x1 書標

Braille support

Question: Are there any braille embossers or printers which have inbuilt braille converters and are accessible within the UNIX environment?

Answer: You may want to look into BRLTTY.