- Koha - lists.katipo.co.nz

is koha right for our project run by volunteers?
by Rebecca Shtasel 14 Mar '17

14 Mar '17

Hello We are a small group of volunteers (one of whom is a retired school librarian) who run our synagogue's library in the UK. We would like to produce an online catalogue and are interesting in using Koha for this purpose as we haven't much money. The library has about 4000 books covering a variety of classifications (fiction, history etc) all related to Judaism. The original accessions book was lost when the library had to be moved a year ago and we have a notebook with handwritten entries for the accessions we have received since the library moved to its new home. Looking at the information to do with koha it appears very technical and we are wondering if we will be able to use it for our catalogue. We would literally be taking books off the shelves to input their information, not importing the data from elsewhere and none of us has anything more than basic computing knowledge. Given this, do you think koha is too complicated for us to use or amongst all the information related to using koha is there a very basic guide that would suit beginners like us? If you think we would struggle using koha, could you advise us on software that you think would be more user-friendly and is not too expensive? Thanking you all very much in advance for any advice you can give. Rebecca (on behalf of the group)

9 8

Award to Article on Koha
by vinod mishra 14 Mar '17

14 Mar '17

Dear All It gives me a great pleasure to inform you that a paper entitled *“KOHA Web OPAC- Customising it to make a Library Portal: A case study of Assam University Library / by Dr. A K Sharma, Mr. D P Tripathi and Mr. Vinod K Mishra”* has been awarded as best paper (*DLA- Dr Ramesh Chandra Vashishth Best Paper in Library Herald Award-2016*). The details are available at: http://mishravk.com/2017/03/award-koha/ With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 Website: http://mishravk.com/ *"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi*

4 3

How to Link my Koha to my College website
by Javed Sahil 14 Mar '17

14 Mar '17

Hello! I am new to koha. I have installed Ubuntu 16.04 and koha 16.11 as instructed on the following link: https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_ packages It is working fine on my LAN, but I want to link this Ubuntu Koha server with my college website, (www.iol.edu.pk) So that everyone can access oever the internet. Please guide me, I shall be thankful. Regards, Javed Shoukat Librarian. -- Regards, Javed Shoukat Librarian 68 C/1 Model Town, Lahore. Contact #: +92 300 6548748 <+92%20300%206548748> Email: javedshoukat900(a)gmail.com

2 1

The same search result in Arabic book
by Mutasem Al Shami 14 Mar '17

14 Mar '17

Hi, When i search in Arabic book in all the time the result search the same, Koha (16.11). How can i sol this problem. Regards, Mutasem -- ------------------------------ Disclaimer: This message and its attachment, if any, are confidential and may contain legally privileged information. If you are not the intended recipient, please contact the sender immediately and delete this message and its attachment, if any, from your system. You should not copy this message or disclose its contents to any other person or use it for any purpose. Statements and opinions expressed in this e-mail are those of the sender, and do not necessarily reflect those of Al Maarefa College (MCST). All opinions and/or views expressed in this email are solely those of the author and do not necessarily represent those of MCST, MCSTaccepts no liability for damage caused by any virus transmitted by this email. تنويه: هذه الرسالة ومرفقاتها (إن وجدت) تمثل وثيقة سرية قد تحتوي على معلومات تتمتع بحماية وحصانة قانونية. إذا لم تكن الشخص المعني بهذه الرسالة يجب عليك تنبيه المُرسل بخطأ وصولها إليك، وحذف الرسالة ومرفقاتها. ولا يجوز لك نسخ هذه الرسالة أو مرفقاتها أو أي جزء منها، أو البوح بمحتوياتها لأي شخص أو استعمالها لأي غرض. علماً بأن الآراء والإفادات التي تحويها هذه الرسالة تعبر فقط عن رأي المُرسل وليس بالضرورة رأي كلية المعرفة، ولا تتحمل كلية المعرفة أي مسئولية عن الأضرار الناتجة عن أي فيروسات قد يحملها هذا البريد.

2 2

Change Item Status of All Items
by Ma. Victoria H. Silva-Manuel 14 Mar '17

14 Mar '17

Is there a way to edit "7 - Not for Loan" in field for all items encoded in Koha? -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

2 1

Fwd: Table issue always Loading
by Abdulsalam Yousef 13 Mar '17

13 Mar '17

Revise your database tables encodings, Should be the same encoding, /for example (utf8_unicode_ci) Regards.

1 0

My Zebra keeps dying
by i.pratt＠zigzagee.com 13 Mar '17

13 Mar '17

Hi, Sounds like a sad problem I know but on our Koha test server (16.05) Zebra keeps dying. Since Zebra affects the catalog search, the problem is you type something in the search field and its "No result found" If you perform a koha-restart-zebra instance then the search is back up and running again. This wouldn't be a problem if it occurred rarely but it seems to happen 2 or 3 times a week. How can I stop this from happening ? Regards, Ian -- ________________________________________________ Dr. Ian Pratt B.Eng Ph.D C.Eng MIET MIEEE Director - ZigZagee Ltd. Email: i.pratt(a)zigzagee.com Landline: + 44 (0) 1509 276251 Mobile: + 44 (0) 7796331815 Web: www.zigzagee.com ________________________________________________

2 1

Koha 16.05 - Changing Material Type Values with JQuery?
by Craig Butosi 13 Mar '17

13 Mar '17

Hi all, Koha 16.05 on Ubuntu 14.04 (package install). Has anyone successfully changed the Material Type field values (set by LDR/06) found in the XSLT templates using JQuery? I'd rather not edit templates directly. I am trying to change the default value "Music" for bib records that are set to LDR/06 - j - Musical Sound Recording to read "Sound Recordings" instead. I.e.,: $(".results_material_type:contains('Music')").text("Sound recording"); At the risk of stating the obvious, I am, of course, placing this script in OPACUSERJS. Would a kind soul have any suggestions? Unsure where I'm going wrong here. Apologies if this is too off-topic. Many thanks, Craig Butosi, MA, MLIS, B Mus (Hons.) LIBRARY SERVICES MANAGER the royal conservatory TELUS Centre for Performance and Learning 273 Bloor Street West Toronto, ON M5S 1W2 416.408.2824 x338 www.rcmusic.ca<http://www.rcmusic.ca/> Note: This email message and any attachments are intended only for the use of the individual to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the recipient of this email is not the intended recipient (or the employee or agent responsible for delivering the email to the intended recipient), you are hereby notified that any review, dissemination, distribution or copying or other use of this message is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email and delete this message and attachments from your system, thank you.

3 3

Re: [Koha] Koha Digest, Vol 137, Issue 19
by Abdullah Al-Modabber 12 Mar '17

12 Mar '17

Walaikumussalam You can call her to Imo app of your mobile. She uses IMO. Abdullah al-Modabber Assistant Librarian South Asian University Akbar Bhawan (Near Yashwant Place) Chanakyapuri, New Delhi 110021, India Email almodabber(a)gmail.com, modabber(a)yahoo.com, modabber(a)sau.int Phone Office +91-11-24195210 Mobile +919717993711, +8801819695123 Web http://library.sau.ac.in Social Networking Facebook https://www.facebook.com/almodabber Google https://plus.google.com/+abdullahalmodabberbd Twitter https://twitter.com/almodabber LinkedIn http://in.linkedin.com/in/modabber On Sunday, 12 March 2017, 4:30, "koha-request(a)lists.katipo.co.nz" <koha-request(a)lists.katipo.co.nz> wrote: Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit https://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: SQL Help - Daily (on Monthly basis) & Monthly (on Yearly basis) Transactions Counts (Circulation) (SATISH) ---------------------------------------------------------------------- Message: 1 Date: Sat, 11 Mar 2017 12:36:33 +0530 From: SATISH <lis4satish(a)gmail.com> To: Koha <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] SQL Help - Daily (on Monthly basis) & Monthly (on Yearly basis) Transactions Counts (Circulation) Message-ID: <CAJkM6UG=P_EKxyDP9yVBs4X96EVaykTiUbKKfi9joDOJBeSrJQ(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Hi, Please find the SQL reports wiki page is updated today for (1) Month wise circulation report (counts) for a specific year <https://wiki.koha-community.org/wiki/SQL_Reports_Circulation#COUNT_-_Month_…> & (2) Date wise daily circulation report (counts) for a specific month of an year <https://wiki.koha-community.org/wiki/SQL_Reports_Circulation#COUNT_-_Date_w…> With Thanks Satish MV Librarian Govt. Engineering College, Hassan Karnataka. www.gechassan.ac.in ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ End of Koha Digest, Vol 137, Issue 19 *************************************

1 0

Re: [Koha] SQL Help - Daily (on Monthly basis) & Monthly (on Yearly basis) Transactions Counts (Circulation)
by SATISH 12 Mar '17

12 Mar '17

HI I have compiled Date wise daily transactions/circulation report which I had asked in my previous mails. Thanks to Barton Chittenden and Mark Alexander for quick response. Please also advice me, how to add this in the sql wiki library. 1. Date wise daily Transactions (Issue, Renewal, Return) stats for a specific month & year --------------------------------------------------------------------------------------------------------------------------------------------------- SELECT DATE(datetime) AS DATE, SUM( IF(type = 'issue', 1, 0 )) as Issues, SUM( IF(type = 'renew', 1, 0 )) as Renewals, SUM( IF(type = 'return', 1, 0 )) as Returns, COUNT(statistics.type) AS 'Total Transactions' FROM statistics WHERE YEAR(datetime) = <<Enter Year YYYY>> AND MONTH(datetime) = <<Enter Month MM>> GROUP BY DATE(datetime) ------------------------------------------------------------------------------------------------------------------------------------------------ Example : YYYY = 2017, MM = 3 (for March) Result looks like: DATEIssuesRenewalsReturnsTotal Transactions 2017-03-01 46 0 13 59 2017-03-02 43 0 9 52 2017-03-03 80 0 2 82 2017-03-04 25 0 5 30 2017-03-06 44 102 30 176 2017-03-07 30 52 46 128 2017-03-08 50 139 55 244 and I am looking help for my second query - i.e, 2. Monthly transactions / circulation report for an entire year : example: for the year 2017 Month | Issues | Renewals | Returns ---------------------------------------------------------- January 55 45 50 February 50 45 35 so on .. until December I did compile to some extent, but request some experts to modify sql for me as I desired. sql is as follows; ---------------------------------------------------------------- SELECT monthname(datetime) AS month, year(datetime) AS year, count(*) AS count FROM statistics WHERE statistics.type IN ('issue') and year(datetime) = <<Year>> GROUP BY month(datetime) -------------------------------------------- Example for the YYYY = 2016, results looks like: monthyearcount July 2016 22 August 2016 41 September 2016 1447 October 2016 538 November 2016 1174 December 2016 977 But I am looking in following format, Month | Issues | Renewals | Returns ---------------------------------------------------------- January 55 45 50 Please share your ideas. With Thanks Satish MV Librarian Govt. Engineering College, Hassan Karnataka. www.gechassan.ac.in

2 2