- Koha - lists.katipo.co.nz

Koha offline circulation tool (firefox plugin) documentation
by Francois Charbonnier 11 May '12

11 May '12

Hi folks, how are you doing? As requested earlier this week on the IRC, here is the Koha Offline Circulation Tool documentation that the (Koha) world is waiting for! ;^) 1. Humm, but what is it for? Sometimes, you are at the circulation desk and your internet connection goes down. Good news, it may not be as terrible as it seems. If your twitter followers can wait your next tweets, it may not be an option for your patrons. There is already an offline circulation tool that works with Koha but if you want to use an easy to install offline circulation tool (no technical skills are required), you can try this one. It's quite easy to use even if some explanation might be necessary to fully understand everything. 2. Download and installation : First thing : this tool is a firefox plugin you need to download and install on your firefox brownser. To do so, just go to the https://addons.mozilla.org/en/firefox/addon/koct/ page and click on the "install now" button. You may have to confirm the installation, just click on "install now" and then restart firefox to complete the installation. The download and the installation will take you a few seconds, it's very quick. Once you installed the plugin and restarted firefox, you have the koha logo in the add-on bar at the bottow of firefox. A click on the logo will open the tool in its own window. 3. Set up : The first thing you want to do then is to set up the plugin. The set up constists on 4 parameters to enter into the plugin. * Go to the "Param" tab and fill up the following information : - Server = the URL of the librarian interface. - Branch Code = the branch you would log in if the internet connection was working. - Username = your librarian account login - Password = your librarian account password * To save the settings, you will have to close the plugin window and re-open it by clicking again on the koha logo in the add-on bar. Tips : You can create a librarian account dedicated to the offline circulation. So that, no matter which librarian is at the check-in/check-out desk, they won't have to use their collegue account or set up the plugin again. 4. Ergonomy : The plugin consists of four tabs which are quite self explanatory! ;^) * "Check Out" to check-out items * "Check In" to check-in items * "Log" to keep track of every transaction the librarian did * "Param" to set up the plugin How it works : * To check out items, go to the "Check out" tab and : - scan the patron barcode - then the item barcode - and click "save" * To check in items, go to the "Check In" tab and : - scan the item barcode - and click "save" Each time, you check out or check in an item, a new transaction is recorded in the local plugin database and you will see, at the bottom of the plugin how many transactions has been made during the offline circulation. For example, "10 Row(s) Added" means you did 10 transactions. * Then, if you want an overview of every transactions, go to the "log" tab. This tab will show you the recordings in the plugin database and each row will give you the following information : - the transaction timestamp - the transaction type : "issue" or "return" - the borrower cardnumber for the issues only - the item barcode - the transaction status The status will be "Local." as long as you are offline and don't process the transactions into Koha. 5. My internet connection is back, what do I do now? Well, first thing "Breathe!", everything is going to be fine... ;^) Then, what you want is to process every transaction in Koha database. To do so, go to the "log" tab where two options are available for you. You can "Commit to koha" or "Apply directly" the transactions into Koha. It depends on how you manage the check in / check out during the offline period. 5.1. If you checked in/out on more than one computer at the same time, what you want is to process every transaction consistently. Let's say for instance that one patron checked a book out on one computer and then checked the same book in on another computer. To be consistent, you need to record the check out first and then the check in. Not the opposite! To do so, you need to group every transactions in one place, sort them all and then, process everything. So, you need to "Commit to koha" the transactions from every plugins you worked with. This way, every issues and returns will goes to Koha in the "Offline circulation page" and be sorted out. The transaction status in the log will the following value : * "Authentification failed." if the plugin can not connect to your koha. If you encounter this problem, check the set up and be sure that every 4 field is correctly filled. If the problem persists, you may still be offline... ;^) * "Added." which means the transaction has been added to the offline circulation page list. Then, to process the transactions from koha. Go to the the offline circulation page from the circulation home page. You will see every transactions listed and you will be able to check them all or select just those you want to process into koha. Click on the "process" button and Koha will record every sorted transaction one by one. For each transaction, the status will change to : * "Success." if the transaction was processed correctly. * "Borrower not found." if the borrower card number is incorrect. * "Item not found." if the item barcode is wrong. * "Item not issued." if you check in an available item. 5.2. If you checked in/out on only one computer, every transactions are already sorted out by timestamp. So, you can "Apply directly" the transaction clicking the "Apply directly" button. For each transaction, the status (in the 'log' tab) will change to the same value that those give above for the "Commit to Koha option" : * "Authentification failed." if the plugin can not connect to Koha. * "Borrower not found." if the borrower card number is incorrect. * "Item not found." if the item barcode is wrong. * "Item not issued." if you check in an available item. 6. What if : 6.1 The item checked in has hold ? The hold is kept on the item. Since, you can't confirm holds found during the processing of every check in, the holds stay on the item and will be manage later. Depending on how many books you checked in during the offline period, you can either checked them again to find the books with holds you would have confirmed in a normal situation. If too many books has been checked in, it's maybe more relevant to use the report module to find every books with holds that should have been processed. 6.2 The borrower account is expired ? Even if the check out is impossible in this situation, the transaction will be forced and recorded on this patron account. So that, you won't lost any transactions. If you want to control this situation, you can always use the report module to find every borrowers with expired account where items had been checked out during the offline operation. 7. What next? Once every transaction has been processed into koha, you can either "Clear" the "log" tab within the offline circulation tool or just close it. If you didn't "Clear" the transactions recorded in the local plugin database, when you will reopen it, this message will show up and say "The offline circulation database contains X rows. Do you want to delete this rows?" A check box that says "I want to delete these rows." will allow you to confirm that you want to delete these rows. ----------------------- If you still have trouble using this plugin, drop me an email. And Nicole, if you want me to give you more explanation for the manual or if you want to correct my broken english to copy/paste it in the manual, everything is good with me! Currently, I'm in a train and my battery is almost down but later, I can give you screenshots of you want to. Just tell me what you need! ;^) See ya! François -- François Charbonnier http://www.biblibre.com/ Expert en Logiciels Libres pour l'info-doc Tél: 06 17 45 57 76

1 0

Koha offline circulation tool (firefox plugin) documentation
by Francois Charbonnier 11 May '12

11 May '12

Hi folks, how are you doing? As requested earlier this week on the IRC, here is the Koha Offline Circulation Tool documentation that the (Koha) world is waiting for! ;^) 1. Humm, but what is it for? Sometimes, you are at the circulation desk and your internet connection goes down. Good news, it may not be as terrible as it seems. If your twitter followers can wait your next tweets, it may not be an option for your patrons. There is already an offline circulation tool that works with Koha but if you want to use an easy to install offline circulation tool (no technical skills are required), you can try this one. It's quite easy to use even if some explanation might be necessary to fully understand everything. 2. Download and installation : First thing : this tool is a firefox plugin you need to download and install on your firefox brownser. To do so, just go to the https://addons.mozilla.org/en/firefox/addon/koct/ page and click on the "install now" button. You may have to confirm the installation, just click on "install now" and then restart firefox to complete the installation. The download and the installation will take you a few seconds, it's very quick. Once you installed the plugin and restarted firefox, you have the koha logo in the add-on bar at the bottow of firefox. A click on the logo will open the tool in its own window. 3. Set up : The first thing you want to do then is to set up the plugin. The set up constists on 4 parameters to enter into the plugin. * Go to the "Param" tab and fill up the following information : - Server = the URL of the librarian interface. - Branch Code = the branch you would log in if the internet connection was working. - Username = your librarian account login - Password = your librarian account password * To save the settings, you will have to close the plugin window and re-open it by clicking again on the koha logo in the add-on bar. Tips : You can create a librarian account dedicated to the offline circulation. So that, no matter which librarian is at the check-in/check-out desk, they won't have to use their collegue account or set up the plugin again. 4. Ergonomy : The plugin consists of four tabs which are quite self explanatory! ;^) * "Check Out" to check-out items * "Check In" to check-in items * "Log" to keep track of every transaction the librarian did * "Param" to set up the plugin How it works : * To check out items, go to the "Check out" tab and : - scan the patron barcode - then the item barcode - and click "save" * To check in items, go to the "Check In" tab and : - scan the item barcode - and click "save" Each time, you check out or check in an item, a new transaction is recorded in the local plugin database and you will see, at the bottom of the plugin how many transactions has been made during the offline circulation. For example, "10 Row(s) Added" means you did 10 transactions. * Then, if you want an overview of every transactions, go to the "log" tab. This tab will show you the recordings in the plugin database and each row will give you the following information : - the transaction timestamp - the transaction type : "issue" or "return" - the borrower cardnumber for the issues only - the item barcode - the transaction status The status will be "Local." as long as you are offline and don't process the transactions into Koha. 5. My internet connection is back, what do I do now? Well, first thing "Breathe!", everything is going to be fine... ;^) Then, what you want is to process every transaction in Koha database. To do so, go to the "log" tab where two options are available for you. You can "Commit to koha" or "Apply directly" the transactions into Koha. It depends on how you manage the check in / check out during the offline period. 5.1. If you checked in/out on more than one computer at the same time, what you want is to process every transaction consistently. Let's say for instance that one patron checked a book out on one computer and then checked the same book in on another computer. To be consistent, you need to record the check out first and then the check in. Not the opposite! To do so, you need to group every transactions in one place, sort them all and then, process everything. So, you need to "Commit to koha" the transactions from every plugins you worked with. This way, every issues and returns will goes to Koha in the "Offline circulation page" and be sorted out. The transaction status in the log will the following value : * "Authentification failed." if the plugin can not connect to your koha. If you encounter this problem, check the set up and be sure that every 4 field is correctly filled. If the problem persists, you may still be offline... ;^) * "Added." which means the transaction has been added to the offline circulation page list. Then, to process the transactions from koha. Go to the the offline circulation page from the circulation home page. You will see every transactions listed and you will be able to check them all or select just those you want to process into koha. Click on the "process" button and Koha will record every sorted transaction one by one. For each transaction, the status will change to : * "Success." if the transaction was processed correctly. * "Borrower not found." if the borrower card number is incorrect. * "Item not found." if the item barcode is wrong. * "Item not issued." if you check in an available item. 5.2. If you checked in/out on only one computer, every transactions are already sorted out by timestamp. So, you can "Apply directly" the transaction clicking the "Apply directly" button. For each transaction, the status (in the 'log' tab) will change to the same value that those give above for the "Commit to Koha option" : * "Authentification failed." if the plugin can not connect to Koha. * "Borrower not found." if the borrower card number is incorrect. * "Item not found." if the item barcode is wrong. * "Item not issued." if you check in an available item. 6. What if : 6.1 The item checked in has hold ? The hold is kept on the item. Since, you can't confirm holds found during the processing of every check in, the holds stay on the item and will be manage later. Depending on how many books you checked in during the offline period, you can either checked them again to find the books with holds you would have confirmed in a normal situation. If too many books has been checked in, it's maybe more relevant to use the report module to find every books with holds that should have been processed. 6.2 The borrower account is expired ? Even if the check out is impossible in this situation, the transaction will be forced and recorded on this patron account. So that, you won't lost any transactions. If you want to control this situation, you can always use the report module to find every borrowers with expired account where items had been checked out during the offline operation. 7. What next? Once every transaction has been processed into koha, you can either "Clear" the "log" tab within the offline circulation tool or just close it. If you didn't "Clear" the transactions recorded in the local plugin database, when you will reopen it, this message will show up and say "The offline circulation database contains X rows. Do you want to delete this rows?" A check box that says "I want to delete these rows." will allow you to confirm that you want to delete these rows. ----------------------- If you still have trouble using this plugin, drop me an email. And Nicole, if you want me to give you more explanation for the manual or if you want to correct my broken english to copy/paste it in the manual, everything is good with me! Currently, I'm in a train and my battery is almost down but later, I can give you screenshots of you want to. Just tell me what you need! ;^) See ya! François -- François Charbonnier http://www.biblibre.com/ Expert en Logiciels Libres pour l'info-doc Tél: 06 17 45 57 76

1 0

Publication dates in Koha
by Tobin, Jessica L 11 May '12

11 May '12

Greetings, What is the difference between biblio.copyrightdate and biblioitems.publicationyear? Where does the metadata that populates these columns come from? Thanks, Jess ________________________________________ Jessica L. Tobin Technical Services & Systems Librarian Arnold Library | Fred Hutchinson Cancer Research Center | Seattle, WA jtobin(a)fhcrc.org | tel 206.667.6846 | fax 206.667.4737

4 7

Software error
by glernil evangelista 11 May '12

11 May '12

After upgrading our Koha installation from 3.6 to 3.8, an error occurred (as shown below) upon logging in. Any idea how to fix this? Software error: Cannot determine local time zone For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. -- Glernil B. Evangelista Faculty St. Bridget College - College Department M.H. Del Pilar St., Batangas City Batangas, Philippines 4200

2 1

Deleting Authorized Values set
by Lenora Oftedahl 10 May '12

10 May '12

how do we delete an authorized values set? Lenora StreamNet Regional Librarian Columbia River Inter-Tribal Fish Commission http://www.streamnetlibrary.org

1 0

Pls any know about this, help
by Dagne Woldie 10 May '12

10 May '12

Dear all please Can anyone direct me to instructions on how to batch delete biblio records . I managed to batch delete the items attached to the records and now I need to delete the records themselves, but I really don't want to do this one at a time for over 1100 records . …Or have I misunderstood the process entirely. Dagne Woldie ICS Addis Library

1 0

SQL help needed: borrower info needed in 2 contexts
by Steve Campbell 09 May '12

09 May '12

Here's one for you SQL hotshots. We took a report from the library and modified it slightly. It shows all items that are checked out and also have holds on them. Here it is: SELECT b.title, i.itemcallnumber AS "Call Number", i.barcode AS "Barcode", date(r.timestamp) AS "Hold Date", bo.cardnumber AS "Held For", bo.firstname, bo.surname FROM reserves r LEFT JOIN biblio b ON (r.biblionumber=b.biblionumber) LEFT JOIN items i ON (i.biblionumber=b.biblionumber) LEFT JOIN borrowers bo ON (r.borrowernumber=bo.borrowernumber) WHERE i.itemnumber IN (SELECT issues.itemnumber FROM issues) ORDER BY r.timestamp ASC It works as it is, but we would like to add something. It already tells us who has the hold on the item, but we would also like to see the borrower cardnumber, firstname, and surname for the patron who has the item checked out, i.e. in issues. How would we do that? Steve Campbell Converse Free Library Lyme, New Hampshire, USA

1 0

opac-topissues not working for some specific parameter settings
by Paul Poulain 09 May '12

09 May '12

Hello Koha, We have one customer that has the following configuration, and his opac-topissue don't work when he tried to filter by item types (for example "books acquired by any libraries in the last 6 months) : * item-level_itypes = active * advancedSearchTypes = ccode BUT, for this customer, the ccode is AT BIBLIO LEVEL. This works well, except for opac-topissues. If anyone has the same configuration and can confirm it has the same problem... -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

1 0

Want to add more feature or module in koha
by sunil sharma 09 May '12

09 May '12

Dear All, I am Sunil from India and I want to start my carrier with koha, open-source Integrated Library System. I am working at koha from last 4 months and currently at some developing level, I observe all the feature of koha but I want to add some more feature in koha-community's koha like in liblime koha, which are: 1. Libraries can create new receipt templates for reach library by clicking New Receipt Template in the Receipt Template Manager which we add in any sys pref i.e. at Tools. (in other words: Koha will features customizable print slips and a management interface for the creation, alteration, saving, and deleting of customize print slips & circulation receipts). 2. Koha features a rich set of features around holds: including: - Ability to fill local holds first (thus reducing transportation costs) - Enriched holds queue report, including sort and pagination support for large list printing and functionality so a hold can be filled (triggered) or passed to another library directly from the report - New hold notices – for holds canceled and/or expired 3. the last I want to generate my report in word format also, as by default it is in csv format. Hope the community help me on these topics. Thanks in Advance, Sunil

2 1

KohaCon 2013 Wiki Reminder
by BWS Johnson 08 May '12

08 May '12

Salvete! A while back, a mess of folks expressed interest over the listserv in bidding for KohaCon 2013. This is great. :) What is not great is that the folks that proclaimed their love of hosting over the listserv do not match with this wiki page: http://wiki.koha-community.org/wiki/Kohacon2013 So if you're earnest, please edit it, and soonish that way we can generate a proper ballot. Cheers, Brooke

1 0