Using Mana to Import Reports into Koha

Using Mana to Import Reports into Koha

The Koha community shares reports through Mana-kb. The setup is the same as for Serials and adds a Mana link in the Reports Module.

Using Mana in the Reports Module

When creating a SQL report, there is a an option in the dropdown - “New SQL from Mana”. Choosing “New SQL from Mana” will allow the user to see if Mana has a report that already exists from the database. This will take away the need to write the report or go into the Koha report library!


A pop-up box will appear and a keyword/s can be entered to search the Mana database. This search appears to look in the report name, notes and the actual SQL itself.



Another search “Lost”:


If the notes are too long, there will be a Show More button to see all the notes. Also, if you hover in the notes column, the SQL will appear in a informational box, so you can see what the report looks like.

Once the report that is desired is found, the option on the right, “Import” will be used to import the report into the library’s report library. Importing will eliminate the need to create a name for this report because it will generate the SQL into the box. All the user has to do is Save the report and Run. There may be space issues with how it imports, so it will be important to look at the SQL to eliminating errors when running the report.

The report is saved in the library’s Koha Report Library for future needs. Feel free to edit this SQL, add a Report Group, change the name or add different Notes. The report is now the library’s report.

Sharing your Report in Mana

If your library would like to share an existing report from their own report library, this is also just as easy. From the Saved Report page, in the column of a specific report- where you would run the report, there is an additional option, “Share” :



Choosing “Share” will create a popup box to show the entire report, title, notes, and SQL. All that is needed to share this into the Mana Knowledgebase, is to hit “Share”.

Tutorial Video


    • Related Articles

    • Creating and Running Reports

      Koha uses SQL (Structured Query Language) for reports. Basically, you are asking, via SQL, to select certain information from specific fields, where the information matches specified criteria. Of course, libraries who are comfortable with SQL can ...

    • Using Mana for Serial Subscriptions

      Mana-kb is a knowledge base for serial subscription patterns that is shared with the Koha community. This means a library can set up their Koha to integrate with Mana-kb and search for Serial patterns within Mana-kb and also share their own patterns ...

    • Koha Item Status Reports

      In another article, there was a discussion of a variety of item statuses and how their behavior can be customized in Koha. That article covered everything that is a “status” in Koha: Withdrawn, Lost, Damaged, Restricted, and Not For Loan. However, ...

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

    • Import Profiles

      An import profile will save the fields that are listed in the import tool, comments, record type, character encoding, format, recording matching rule, action if matching record is found, action if no match is found, check for item embedded data, and ...