- Koha - lists.katipo.co.nz

Koha reports
by Evan Mungai Njoroge 04 Jul '13

04 Jul '13

Colleagues, I want to get a report of all my overdue books; I ran the report yesterday got the printout verified with the shelves and returned a number of books. Running the report again today; I expectedit to remove the patrons who have already returned them but I can still see them on the list. Kindly help. This is the report I used. Overdue materials - *Developer:* Sharon Moreland - SELECT borrowers.surname, borrowers.firstname, borrowers.phone, borrowers.cardnumber, borrowers.address, borrowers.city, borrowers.zipcode, issues.date_due, (TO_DAYS(curdate())-TO_DAYS( date_due)) AS 'days overdue', items.itype, items.itemcallnumber, items.barcode, items.homebranch, biblio.title, biblio.author FROM borrowers LEFT JOIN issues ON (borrowers.borrowernumber=issues.borrowernumber) LEFT JOIN items ON (issues.itemnumber=items.itemnumber) LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) WHERE (TO_DAYS(curdate())-TO_DAYS(date_due)) > '30' AND issues.branchcode = <<Issuing branch|branches>>ORDER BY borrowers.surname ASC, issues.date_due ASC

4 3

additional languages
by Araik Manukyan 04 Jul '13

04 Jul '13

Hi list. I installed koha 3.12.01 version. After that I tried activate Armenian language via koha-translate -list command according this http://wiki.koha-community.org/wiki/Installation_of_additional_languages_for _OPAC_and_INTRANET_staff_client documentation But I received error *********************** kohakoha-translate: command not found ************************* Where is located that command I can not find them Any suggestion Araik

3 2

Re: [Koha] Thoughts on volunteering (Jared Camins-Esakov)
by Mesfin Teshome 04 Jul '13

04 Jul '13

Jared and the team, My deepest appreciations to you and the rest of the Koha team. You might not know how much you have done especially for Libraries in Africa which cannot afford commercial Library Systems and even if they do the running costs of those systems are overkill. I can attest to that as I work for a University which initially bought a very expensive system with a grant but the running costs and costs of additional modules were too much for my university. When I discovered Koha it was a blessing. I took sometime learning it but when we finally implemented it, it was worth all the time I spent learning it. I am trying to learn one or two programming langauges myself so that I can contribute positively to the open source community. Mesfin ________________________________ From: "koha-request(a)lists.katipo.co.nz" <koha-request(a)lists.katipo.co.nz> To: koha(a)lists.katipo.co.nz Sent: Thursday, July 4, 2013 3:00 AM Subject: Koha Digest, Vol 93, Issue 5 Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://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. Learn and Get Koha Live DVD as per your Need (Vinod Kumar Mishra) 2. Thoughts on volunteering (Jared Camins-Esakov) ---------------------------------------------------------------------- Message: 1 Date: 3 Jul 2013 17:30:25 -0000 From: "Vinod Kumar Mishra" <vinod_librarian(a)rediffmail.com> To: <lis-forum(a)ncsi.iisc.ernet.in>, <nmlis(a)yahoogroups.com>, <iatlis(a)yahoogroups.com>, <libtech(a)yahoogroups.com>, <Koha(a)lists.katipo.co.nz> Subject: [Koha] Learn and Get Koha Live DVD as per your Need Message-ID: <20130703173025.22736.qmail(a)f5mail-224-142.rediffmail.com> Content-Type: text/plain; charset="UTF-8" Dear All, With my continues efforts to provide services to LIS community free of cost i would like to inform you that many professionals are willing to implement Koha at their Institute (Particularly New)but they feels helpless. Therefore i would like to inform you that you can personally contact me to learn the same and i will provide you the Pre Configured Live DVD of koha exactly as per your requirements in such a way that you can immediately automate your library with few click of mouse free of cost and make beautiful Library website also. in case of further problem you may get remote support from my side and other community. Please note that all the above process will run perfectly as i have already implemented it at IIT Roorkee Saharanpur Campus and it is running without any problem since one year. Dear friends now a days many new govt and private organizations came into existence so this is right time to prove yourself as a good librarian and play effective role in their setup in a cost effective manner. You start with OSS and later on decide what will suit future requirement. For more details feel free to contact. Koha live DVD: http://sourceforge.net/projects/vkmkoha/?source=navbar Thanking You. With regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librarian(a)rediffmail.com : mishravk79(a)gmail.com ------------------------------ Message: 2 Date: Wed, 3 Jul 2013 18:34:32 -0400 From: Jared Camins-Esakov <jcamins(a)cpbibliography.com> To: Koha <koha(a)lists.katipo.co.nz> Subject: [Koha] Thoughts on volunteering Message-ID: <CALVDfQxfDPKxspZVP8gfx1SdkMWorpY8OPr1ZAVMcaEQv3SbBQ(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Greetings, fellow members of the Koha community, My name is Jared Camins-Esakov. There are two reasons that name might sound familiar. The first is that in my day job I do a lot of work with Koha (hosting, support, bespoke development, and all that jazz). The second is that just over a month ago I finished my term as Release Manager for Koha 3.12. I am very proud of what we did during my six month term. Koha has more features and works better for more libraries than ever before. I think that's a big deal. During those six months, I spent a lot of time working on Koha, as my wife can attest. I think I could count on my fingers the number of days in the entire release cycle (more than six months!) that I didn't do _anything_ related to the Koha release. I did this because I believe that Koha is important, and a better Koha is better for all of us. >From a business point of view, volunteering my time was a good investment because I am now selling and supporting a better system. But you know what? I don't expect to be paid for all that time I spent volunteering my time for the community. Volunteering my time to build Koha 3.12 was its own (sometimes frustrating) reward. That's what Open Source is all about*, and I am proud to be a member of a community that understands this. Regards, Jared Camins-Esakov *Not to say that you can't or shouldn't make money from working on Open Source projects. I believe strongly that you can and should (and, of course, my company does), but contributing to an Open Source project like Koha is about more than just money. P.S. Also, I'd like to take this opportunity to ask everyone in the Koha community to take a moment to thank your friends and family for sharing you with us. -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins(a)cpbibliography.com (web) http://www.cpbibliography.com/ ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 93, Issue 5 ***********************************

2 1

Thoughts on volunteering
by Jared Camins-Esakov 04 Jul '13

04 Jul '13

Greetings, fellow members of the Koha community, My name is Jared Camins-Esakov. There are two reasons that name might sound familiar. The first is that in my day job I do a lot of work with Koha (hosting, support, bespoke development, and all that jazz). The second is that just over a month ago I finished my term as Release Manager for Koha 3.12. I am very proud of what we did during my six month term. Koha has more features and works better for more libraries than ever before. I think that's a big deal. During those six months, I spent a lot of time working on Koha, as my wife can attest. I think I could count on my fingers the number of days in the entire release cycle (more than six months!) that I didn't do _anything_ related to the Koha release. I did this because I believe that Koha is important, and a better Koha is better for all of us. >From a business point of view, volunteering my time was a good investment because I am now selling and supporting a better system. But you know what? I don't expect to be paid for all that time I spent volunteering my time for the community. Volunteering my time to build Koha 3.12 was its own (sometimes frustrating) reward. That's what Open Source is all about*, and I am proud to be a member of a community that understands this. Regards, Jared Camins-Esakov *Not to say that you can't or shouldn't make money from working on Open Source projects. I believe strongly that you can and should (and, of course, my company does), but contributing to an Open Source project like Koha is about more than just money. P.S. Also, I'd like to take this opportunity to ask everyone in the Koha community to take a moment to thank your friends and family for sharing you with us. -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins(a)cpbibliography.com (web) http://www.cpbibliography.com/

2 1

Learn and Get Koha Live DVD as per your Need
by Vinod Kumar Mishra 03 Jul '13

03 Jul '13

Dear All, With my continues efforts to provide services to LIS community free of cost i would like to inform you that many professionals are willing to implement Koha at their Institute (Particularly New)but they feels helpless. Therefore i would like to inform you that you can personally contact me to learn the same and i will provide you the Pre Configured Live DVD of koha exactly as per your requirements in such a way that you can immediately automate your library with few click of mouse free of cost and make beautiful Library website also. in case of further problem you may get remote support from my side and other community. Please note that all the above process will run perfectly as i have already implemented it at IIT Roorkee Saharanpur Campus and it is running without any problem since one year. Dear friends now a days many new govt and private organizations came into existence so this is right time to prove yourself as a good librarian and play effective role in their setup in a cost effective manner. You start with OSS and later on decide what will suit future requirement. For more details feel free to contact. Koha live DVD: http://sourceforge.net/projects/vkmkoha/?source=navbar Thanking You. With regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librarian(a)rediffmail.com : mishravk79(a)gmail.com

1 0

Another Koha library goes live
by King, Fred 03 Jul '13

03 Jul '13

MedStar Washington Hospital Center in Washington, DC, went live with Koha yesterday. We've been using the staff client for a couple of weeks, but now our catalog link points to Koha as well. I don't think anyone's noticed yet, but it's nice to be off our old Horizon system. Sorry I can't provide a link-we're on an intranet behind a firewall. Fred King Medical Librarian, MedStar Washington Hospital Center fred.king(a)medstar.net 202-877-6221 CONFIDENTIAL: The information contained in this communication, including its attachments, may contain confidential information and is intended only for the individual(s) or entity(ies) to whom it is addressed. The information contained in this communication may also be protected by legal privilege, federal law or other applicable law. If you are not the intended recipient of this communication, you are hereby notified that any distribution, dissemination or duplication of this communication is strictly prohibited. If you have received this communication in error, please immediately delete and destroy all copies of this message and please immediately notify us of the error by separate communication. Thank you.

1 0

3.14 RM update #1 posted
by Galen Charlton 03 Jul '13

03 Jul '13

Hi, I've posted my first formal update to the Koha community at: http://koha-community.org/koha-3-14-release-managers-update-1/ I won't copy and paste the whole thing here, but if there is anything that might make future updates more useful, please let me know. Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc(a)esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org

1 0

Data conversion
by Esmael Wan 03 Jul '13

03 Jul '13

Anyone offer services to convert/migrate data originally from older library system to marc (iso2709). The original data is in mysql, total bib is around 21K and copies around 41K ... pls tell the cost expected, email me personally if interested esmael

2 1

Koha: Customized Live DVD Update
by Vinod Kumar Mishra 02 Jul '13

02 Jul '13

Dear All, Thanks for lot of appreciations and more than 700 downloads of My Koha: Customized Live DVD (3.9.8) now i have uploaded the latest most/old stable release (3.10.7) with lot of customization of Koha OPAC home page. This DVD provides features which can convert your Koha OPAC into a beautiful library website. Therefore you can use this live DVD for automation and creation of your Library website in a single server.Simply you need to edit the text and links given in the codes in koha "GLOBAL SYSTEM PREFERENCES' option or you can delete all to add your own codes. You may also refer other koha live dvd made by Mr. Vimal Kumar (http://vimalkumar.org/koha) Download Koha live DVD : http://sourceforge.net/projects/vkmkoha/files/ Installation Video : http://www.youtube.com/watch?v=2mg8h394E28 Please feel free to contact in case of any query or difficulty. "I MAY NOT BE GOOD FOR ANY INDIVIDUAL BUT VERY USEFUL FOR INSTITUTION/COUNTRY" With regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librarian(a)rediffmail.com : mishravk79(a)gmail.com

1 0

Request to get enlisted as a Koha Support Provider
by Avior Technologies Pvt. Ltd 02 Jul '13

02 Jul '13

Dear Sir/s, We from Avior Technologies Private Limited would like to be enlisted in your website as a KOHA Support Provider. Avior Technologies was incepted with the sole objective of enabling organizations to effectively manage their Library with the use of Open Source Software, KOHA. Having started the organization last year, we have received great response from librarians from different institutes & organizations not only from West Bengal but also from Orissa & North East India. We would be really obliged if enlisted in your website as a KOHA Support Provider as the same would help us to increase the outreach of Koha to many more libraries. Please find below our contact information and services offered by us: Company Name: Avior Technologies Private Limited Contact Person: Mr.Abhishek Kumar Shaw Contact email: mail(a)aviortechnologies.com Website: www.aviortechnologies.com Telephone: +91 8583963471 Address: Sukantanagar, Sector-IV, Salt Lake, Kolkata 700098. West Bengal. India. Short description of our services: · Koha with support · Library Services (Classification, Cataloguing, Bar-coding, Shelving, ) · Customized solutions · D-Space with support · FEDENA with support · Support Services -- Regards, Avior Technologies Pvt. Ltd. P-329, Sukanta Nagar 2nd Floor, Saltlake Sector IV. Kolkata - 700098 Mobile: 8583963369, 8583963471/72 Website: www.aviortechnologies.com

1 0