- Koha - lists.katipo.co.nz

OCLC Connexion users on Mac OS
by Eric Phetteplace 28 Jun '16

28 Jun '16

Hello Collective Wisdom, Is anyone an OCLC Connexion user that also happens to use Mac OS X? We're a Mac school (♥︎) and the desktop client only runs on Windows. But we learned today that the website's export function, which worked fine with our prior ILS Millennium, only exports records in MARC8 encoding and not UTF-8, so Koha doesn't work with it. All our work around options look bleak: using something like WINE to run the client on a Mac, asking our staff to dual boot or run a VM, exporting to a file instead & importing that into Koha. They'll work but they're much more inconvenient than the web client. If anyone has a better idea I'd be grateful. Best, Eric Phetteplace Systems Librarian California College of the Arts libraries.cca.edu | vault.cca.edu 510.594.3660 2>/dev/null

2 2

Round the World Koha Speaking Tour
by Esmael Wan 27 Jun '16

27 Jun '16

Hi Joann, I'm from malaysia and on behalf Koha Community of Malaysia we are very pleased to receive you as a guest to convey information on Koha. We have several sites Koha in academic and public libraries around kuala lumpur and georgetown & we can prepare meeting/presenting/talking to the koha's libraries. As our guest we would like to provide accommodation, travel costs and daily remuneration during their stay. Please let know more details about planning. Regards Esmael

2 1

Round the World Koha Speaking Tour
by Joann Ransom 27 Jun '16

27 Jun '16

Hi everyone, I have a few months available and am planning a round the world speaking tour starting late August this year – so really soon! I would love to visit as many countries as I can with strong Koha presences and I am looking for partners to help make this a viable proposition. What I am seeking your help with is libraries, vendors or individuals who would be willing to ‘host’ me ie accommodation, domestic travel, a bit of hospitality. I don’t need posh – happy to homestay J In exchange I would love to speak on Koha origins, Koha community or Te Takere (which is a truly awesome public library / community centre I have developed over the last 4 years) and / or mix and mingle in gatherings. I’m basically happy to sing for my supper in any way that is required J. My draft itinerary is set out below and if anyone is able to help make this happen personally or by passing this email on to someone who can help that would be awesome. I’m so excited at the thought of meeting many of you in this great global Koha family that we have created. Many thanks Jo. Draft itinerary: (I need to travel in one direction around the globe) Philippines, Malaysia, India, Turkey, Greece, France, Germany, Austria, Czech Republic, Sweden, Norway, UK, Ireland, USA, Colombia, Chile, Argentina. *Joann Ransom* *Chief Executive Officer* *DDI* 06 366 0841 | *Mobile* 027 320 6923 jransom(a)tetakere.org.nz *Ph.* 06 368 1953 *www.tetakere.org.nz* <http://www.tetakere.org.nz/> Chief Executive Te Horowhenua Trust.

7 6

SQL problem- showing results when they are zero.
by Raymund Delahunty 27 Jun '16

27 Jun '16

We have a quite complex budget and funds structure which is making writing reports somewhat challenging. For example, we have struggled at modify the report below, to have it show lines when both Expenditure AND Commitments are zero. When both are zero, the line is simply omitted from the result. We have not seen any results where Expenditure is zero, but where Commitments is not (a possible scenario, of course), so we are not sure if it is the Expenditures being zero that is the underlying problem. For example running the query of the CSM College library shows only 36 lines of results rather than the expected 44. So 8 have zero in both Exp / Comms. Can someone suggest how we might add in the missing 8 lines. SELECT budget_name AS 'Fund Name', sort1 as 'Subject Fund', FORMAT(sum(valSpent),2) AS 'Expenditure', FORMAT(sum(valOnOrder),2) AS 'Commitments' FROM (SELECT b.budget_name, o.sort1, sum(o.unitprice*o.quantity) AS valSpent, 0 AS valOnOrder FROM aqorders o LEFT JOIN aqbudgets b USING (budget_id) WHERE o.datereceived IS NOT NULL AND o.sort1 IN ('CSM Act & Direct','CSM Animation','CSM Architecture','CSM CCC','CSM Ceramic Design','CSM Charges','CSM Collab Perf','CSM Enterprise','CSM Fashion','CSM Film','CSM Fine Art','CSM Foundation','CSM Graphic Design','CSM Innov & Imagin','CSM Jewellery','CSM PDP','CSM Photography','CSM Pro & Indu Des','CSM Qref & General','CSM Replacements','CSM Samples','CSM Textiles','CSM Journals','CSM e-Act & Direct','CSM e-Animation','CSM e-Architecture','CSM e-CCC','CSM e-Ceramic Design','CSM e-Charges','CSM e-Collab Perf','CSM e-Enterprise','CSM e-Fashion','CSM e-Film','CSM e-Fine Art','CSM e-Foundation','CSM e-Graphic Design','CSM e-Innov & Imagin','CSM e-Jewellery','CSM e-PDP','CSM e-Photography','CSM e-Pro & Indu Des','CSM e-Qref & General','CSM e-Replacements','CSM e-Samples','CSM e-Textiles','CSM e-Journals') GROUP BY o.sort1 UNION ALL SELECT b.budget_name, o.sort1, 0 AS valSpent, sum(o.listprice*o.quantity) AS valOnOrder FROM aqorders o LEFT JOIN aqbudgets b USING (budget_id) WHERE o.sort1 IN ('CSM Act & Direct','CSM Animation','CSM Architecture','CSM CCC','CSM Ceramic Design','CSM Charges','CSM Collab Perf','CSM Enterprise','CSM Fashion','CSM Film','CSM Fine Art','CSM Foundation','CSM Graphic Design','CSM Innov & Imagin','CSM Jewellery','CSM PDP','CSM Photography','CSM Pro & Indu Des','CSM Qref & General','CSM Replacements','CSM Samples','CSM Textiles','CSM Journals','CSM e-Act & Direct','CSM e-Animation','CSM e-Architecture','CSM e-CCC','CSM e-Ceramic Design','CSM e-Charges','CSM e-Collab Perf','CSM e-Enterprise','CSM e-Fashion','CSM e-Film','CSM e-Fine Art','CSM e-Foundation','CSM e-Graphic Design','CSM e-Innov & Imagin','CSM e-Jewellery','CSM e-PDP','CSM e-Photography','CSM e-Pro & Indu Des','CSM e-Qref & General','CSM e-Replacements','CSM e-Samples','CSM e-Textiles','CSM e-Journals') and o.datereceived IS NULL and o.orderstatus<>'cancelled' GROUP BY o.sort1) AS CSMorders GROUP BY sort1 ORDER BY budget_name ASC Many thanks. Ray Delahunty r.delahunty(a)arts.ac.uk<mailto:r.delahunty@arts.ac.uk> University of the Arts London . This email and any attachments are intended solely for the addressee and may contain confidential information. If you are not the intended recipient of this email and/or its attachments you must not take any action based upon them and you must not copy or show them to anyone. Please send the email back to us and immediately and permanently delete it and its attachments. Where this email is unrelated to the business of University of the Arts London or of any of its group companies the opinions expressed in it are the opinions of the sender and do not necessarily constitute those of University of the Arts London (or the relevant group company). Where the sender's signature indicates that the email is sent on behalf of London Artscom Limited the following also applies: London Artscom Limited is a company registered in England and Wales under company number 02361261. Registered Office: University of the Arts London, 272 High Holborn, London WC1V 7EY

1 0

Koha 16.05.01 released
by Frédéric Demians 27 Jun '16

27 Jun '16

It is with great pleasure that we announce the release of Koha 16.05.01, a maintenance release of the Koha open source integrated library system. See the full release notes here: https://koha-community.org/koha-16-05-01-released/ Download: http://koha-community.org/download-koha/ Stay tuned for Debian/Ubuntu package availability. -- Frédéric DEMIANS http://www.tamil.fr/fdemians

2 2

Re: [Koha] Can the OPAC home page be configured to display News without logging in?
by Tim Auld 27 Jun '16

27 Jun '16

Thanks Katrin, Using All-Libraries did the trick. The News displays successfully on the home page. Regards ... Tim.

1 0

Can the OPAC home page be configured to display News without logging in?
by Tim Auld 26 Jun '16

26 Jun '16

If you want to display news items on the OPAC home page, can it be configured to do so without the user having to login to see it? Regards, Tim Auld Minnesota

2 1

OCLC Connexion users on Mac OS
by Eric Phetteplace 26 Jun '16

26 Jun '16

Hello Collective Wisdom, Is anyone an OCLC Connexion user that also happens to use Mac OS X? We're a Mac school and the desktop client only runs on Windows. But we learned today that the website's export function, which worked fine with our prior ILS Millennium, only exports records in MARC8 encoding and not UTF-8, so Koha doesn't work with it. All our work around options look bleak: using something like WINE to run the client on a Mac, asking our staff to dual boot or run a VM, exporting to a file instead & importing that into Koha. They'll work but they're much more inconvenient than the web client. If anyone has a better idea I'd be grateful. Best, Eric Phetteplace Systems Librarian California College of the Arts libraries.cca.edu | vault.cca.edu 510.594.3660 2>/dev/null

1 0

After upgrade to 16.5.00.000 - OPAC/Staff Client not showing results
by SATISH 25 Jun '16

25 Jun '16

Dear All, Previously, Koha 3.16 was installed from packages method on ubuntu 12.4 LTS Desktop and was working very fine and did an uprade to 16.5.00.000 today morning, after that, I am unable to search records either in staff client or in opac. I followed, https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages and after upgrade did run 1) koha-rebuild-zebra -v -f gechlibrary 2) cleared all browsing cache and zebra re-indexing is throwing some warning ( ow) ==================================================== root@gechlibrary:/home/satish# koha-rebuild-zebra -v -f gechlibrary Warning: You passed -x which is already the default and is now deprecatedÂ· Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/gechlibrary/biblios Zebra authorities directory = /var/lib/koha/gechlibrary/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/zebra_koha_gechlibrary/rebuild/rebuild..LCK BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ skipping authorities ==================== exporting biblio ==================== 1001................................................................................................... Records exported: 1061 ==================== REINDEXING zebra ==================== 15:27:09-16/06 zebraidx(2466) [warn] Couldn't open collection.abs [No such file or directory] 15:27:29-16/06 zebraidx(2466) [warn] Record didn't contain match fields in (bib1,Local-number) ==================== CLEANING ==================== Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/gechlibrary/biblios Zebra authorities directory = /var/lib/koha/gechlibrary/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/zebra_koha_gechlibrary/rebuild/rebuild..LCK BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ ==================== exporting authority ==================== Records exported: 0 ==================== REINDEXING zebra ==================== skipping biblios ==================== CLEANING ==================== AND when I try to restart apache service, it is throwing following error: (Server version: Apache/2.2.22 (Ubuntu) Server built: Jul 24 2015 17:25:49) APACHE VERSION PROBLEM root@gechlibrary:/# sudo service apache2 restart ERROR: Syntax error on line 5 of /etc/apache2/sites-enabled/gechlibrary.conf: Invalid command '<IfVersion', perhaps misspelled or defined by a module not included in the server configuration Action 'configtest' failed. The Apache error log may have more information. ...fail! Can community, please help me to restore my opac back...?? with thanks Satish MV Librarian Govt. Engineering College, Hassan Karnataka - 573 201 INDIA. --

2 4

Round the World Koha Speaking Tour
by Joann Ransom 25 Jun '16

25 Jun '16

If I say it I have to do it right; I would love to come visit the global Koha community in the next 3 months. Happy to speak and schmooze and whatever else is needed to help make this happen! If you would like to find out more please read more below and get in touch with me. Norway is the first jigsaw piece set for late September and it looks like Kansas is going to be a go. Many thanks Jo. http://library-matters.blogspot.co.nz/2016/06/round-world-koha-speaking-tou… Sent from my Samsung Galaxy smartphone. ##################################################################################### This e-mail message and any attached files may contain confidential information, and may be subject to legal professional privilege. If you are not the intended recipient, please delete. Unless formally stated, this e-mail and any attachments do not necessarily reflect the views of the the The Horowhenua Trust. The Horowhenua Trust takes extensive precautions with the aim of detecting and removing any virus or defects from its e-mail system but accepts no liability for loss or damage should this e-mail not be virus or defect free or should there be any errors in transmission. #####################################################################################

1 0