- Koha - lists.katipo.co.nz

SQL - Library Books Investment by Collection Code
by SATISH 28 Nov '17

28 Nov '17

Hi, As per our Library reporting requirements, I have just prepared SQL on "Library Books investments by Collection Code". I thought of sharing it, because it is useful for Engineering College Libraries in India for AICTE reports preparation. I did not find it in SQL Library and if somebody is already added, kindly share the sql link. ------------------------- SELECT ccode AS Collection Code, COUNT(DISTINCT items.biblionumber) AS 'No of Titles', COUNT(itemnumber) AS 'No of Volumes', SUM(price) AS 'Investment or total expenditure' FROM items GROUP BY ccode ---------------------------- Result: Collection | No of Titles | No of Volumes | Investment or Price CSE | 305 | 2110 | 994267.50 With Thanks Satish MV Librarian Govt. Engineering College, Hassan Karnataka www.gechassan.ac.in --

1 0

RFID fixed readers, Koha and middleware
by Mike D. 28 Nov '17

28 Nov '17

Hello community, is here some library that use fixed RFID readers for extended managements of items or "smart" inventory? We're looking for experiences and best practise based on open source middleware like Rifidi. We would use fixed reader for automatic change of location based of movement of items. We need to collect data from readers and run specific tasks in Koha via API, for expample change of holdingbranch. Use anybody Koha in this way? If yes, which readers (Alien, Zebra, Chafon) and middleware and why? We found some papers about Greek library that experimented with this, but no deeper technical background. Thank you for sharing of experiences. Mike

2 2

Regexp in MARC modification action
by Mark Alexander 27 Nov '17

27 Nov '17

I'm trying to use a MARC modification template to fix the 952$d field in MARC records we receive from our library supply house. This field is supposed to be the acquisition date, but is coming to us in the format YYYY/MM/DD instead of the required YYYY-MM-DD. So I needed to find a way to replace the slashes with dashes. I created a MARC modification template with a simple action that uses the regular expression s/\//-/ig. The UI for creating the action in Koha implies that the "ig" modifiers are always used (though there doesn't seem to be any way to change them). My understanding of the "g" modifier in Perl is that it causes the s// operator to "replace globally, that is, all occurrences". (This is a quote from an old copy of "Programming Perl" by Wall et. al.) Yet it doesn't seem that the "g" modifier is really being used. When I used this template on an imported MARC record, it changed the first slash in 952$d, but not the second one. So, for example, 2017/11/06 got changed to 2017-11/06. I had to add a second action to the template, identical to the first action, to cause the second slash to be replaced. Am I misunderstanding the use of regular expressions in MARC modification templates, and in particular the behavior of the "g" modifier? Or is this a possible bug?

2 2

intro
by Luca Profico 27 Nov '17

27 Nov '17

Hello list, my name is Luca, from Roma, Italia. I am managing a small koha setup for my daughter's school, since march, but just joined the ML. Very happy with koha so far and with the whole community around it, I am spending some time on the IRC channel also, going with the nickname 'stozza'. Have a good day everybody Luca

2 1

Re: [Koha] [Koha-devel] Koha 17.05.05 released
by Fridolin SOMERS 27 Nov '17

27 Nov '17

Hi, Sorry I fergot to push the tag on the community repo. Done now with also v17.05.06. Regards, Le 26/10/2017 à 20:18, Philippe Blouin a écrit : > Hello Fridolin, > > How am I not finding the tag in the git for v17.05.05 ? Am I missing > something? I would have expected the tag to come before the release, > thereof? > > Thanks, > > Philippe Blouin, > Responsable du développement informatique > > Tél. : (833) 465-4276, poste 230 > philippe.blouin(a)inLibro.com <mailto:philippe.blouin@inLibro.com> > > inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com> > On 10/24/2017 03:49 AM, Fridolin SOMERS wrote: >> >> The Koha community is proud to announce the release of Koha 17.05.03. >> >> This is a maintainance release including a few security fixes. >> >> The full release notes are available at >> https://koha-community.org/koha-17-05-05-release/ >> >> Regards, >> > > -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> BibLibre - software and system maintainer

1 0

We request to appear on the list of paid support providers for Koha community.
by contacto＠etxia.com 27 Nov '17

27 Nov '17

We request to appear on the list of paid support providers for Koha community. We are a company that offers hosting of koha, servers with koha and implementation services for Koha, we support with consultancy, guidance, training and technical support in koha for librarians and institutions in Mexico. Company Name: ETXIA S.A.S. DE C.V. (México) Contact Person: David Quetzalcóatl Ortega Ramírez Contact email: contacto(a)etxia.com Website: www.etxia.com Social media: https://www.facebook.com/ETXIA Demo flavor MARC21 STAFF: http://koha.etxia.com/ OPAC: http://koha.etxia.com:8080/ Username: demo Password: demo MARC code organization: MX-MxETX Link to the koha community can be found in the koha community section at the following links: http://www.etxia.com/koha-implementacion/ http://www.etxia.com/koha-cloud/ http://www.etxia.com/koha-appliance/ http://www.etxia.com/koha-server/ -- CONTACTO | ETXIA S.A.S. DE C.V. www.etxia.com

1 0

Koha 16.11.14 released
by Katrin Fischer 26 Nov '17

26 Nov '17

The Koha community is proud to announce the release of Koha 16.11.14. This is a maintenance release of 16.11 and includes 5 enhancements and 23 bugfixes. The full release notes are available at https://koha-community.org/koha-16-11-14-release/ Packages are already available. This is my last release as the 16.11.x Release Maintainer. Thanks to everyone involved in getting these 14 releases out!

4 3

Tag 082 subfields c and d are not linked with 952$o
by Javed Sahil 24 Nov '17

24 Nov '17

Hi everyone, I have implemented koha at our Institution. I want koha tag 082abcd to display call number on OPAC and Staff Client. but 082 subfields a and b are linked with 952$o *and 082 subfields c and d are not linked with 952$o.* how can these tags linked. help plz. -- Regards, Javed Shoukat Management Trainee Officer (MTO) Lahore University of Management Sciences (LUMS), Lahore. Contact #: +92 300 6548748 <+92%20300%206548748> Email: javedshoukat900(a)gmail.com

1 0

Koha 16.05.19 released
by Mason James 24 Nov '17

24 Nov '17

The Koha community is proud to announce the release of Koha 16.05.19. This is a maintenance release of 16.05 and includes 5 enhancements and 15 bugfixes. The full release notes are available at https://koha-community.org/koha-16-05-19-release This will be my last release as the 16.05.x RMaint Thanks to everyone involved, and to Tomas and Jonathan for the new jenkins :0) cheers, Mason

1 0

Problems with the renewals
by vanda koha 24 Nov '17

24 Nov '17

Hi everybody, I'm having some problems with the renewals. When I make a loan the date is automatically calculate by the system (30 days for books, for instance), but when I make a renewal I have to put the new date due myself, because the system does not do it automatically: it actually assumes the date of the day the renweal is made and not the new date due (that is 30 more days) We are using 16.11.04 Koha version. What did I do wrong? Many thanks in advance Vanda

2 2