- Koha - lists.katipo.co.nz

KOha Release - 18.11.07
by Lucas Gass 02 Jul '19

02 Jul '19

The Koha community is proud to announce the release of Koha 18.11.07 This is a maintenance release with 1 security bugfix. The full release notes are available at at: https://koha-community.org/koha-18-11-07-release/ Debian packages are up. Thanks to everyone involved, Lucas

1 0

How do I reduce decimal digits of prices in order notice?
by Boettcher, Uwe 02 Jul '19

02 Jul '19

Dear all, configuring the ACQORDER notice, I keep getting too many decimal digits at the price output. Example: <order> Title: <<biblio.title>><br> ... bla Price: <<aqorders.listprice>> <<aqorders.currency>><br> </order> keeps producing an output like this: Title: Test title ... bla Price: 18.000000 EURO Is there any way of reducing the 6 decimal digits to two? Many thanks in advance, and kind regards Uwe __________________________________________________________________ (Mr.) Uwe Boettcher Director Library WHU – Otto Beisheim School of Management Campus Vallendar, Burgplatz 2, 56179 Vallendar, Germany Tel.: +49 261 6509-550 ; Fax: +49 261 6509-559 uwe.boettcher(a)whu.edu ; www.whu.edu ___________________________________________________________________

1 0

Super User Records
by RAGHAV ARORA 02 Jul '19

02 Jul '19

Hello everyone, Is there a way I can view the activities of various admin users who have special access to the koha portals. By activities, I mainly need the record of creating/modifying patrons, adding new books, creating/modifying /modifying vendors, creating/modifying baskets, orders, subscription to journals, etc. Can this be done? Thanks in advance Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761, 8474975691 Personal Email <raghavarora999(a)yahoo.in> | University Email <f20171016(a)pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031

1 0

Re: [Koha] [EXTERNAL] Re: New Koha staff theme plugin
by Fridolin SOMERS 02 Jul '19

02 Jul '19

Here it is : https://github.com/biblibre/koha-plugin-theme-intranet-lsd/blob/master/Scre… Spoiler : Its main purpose is to create on a test/dev server an explicit visual difference with production server Best regards, Le 19/06/2019 à 19:00, King, Fred a écrit : > I was hoping for the same thing. Looks too scary for the likes of me. :-) > > Fred King > Medical Librarian, MedStar Washington Hospital Center > fred.king(a)medstar.net > 202-877-6670 > ORCID 0000-0001-5266-0279 > MedStar Authors Catalog: http://medstarauthors.org > > Honey, courage is just a lack of options. > --Fannie Lou Hamer > > -----Original Message----- > From: Koha <koha-bounces(a)lists.katipo.co.nz> On Behalf Of Jonathan Druart > Sent: Wednesday, June 19, 2019 11:11 AM > To: Fridolin SOMERS <fridolin.somers(a)biblibre.com> > Cc: koha-devel <koha-devel(a)lists.koha-community.org>; koha(a)lists.katipo.co.nz > Subject: [EXTERNAL] Re: [Koha] New Koha staff theme plugin > > ** ATTENTION: This email originated from outside the MedStar network. ** DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe. > > Hi Frido, > Do you have screenshots? :) > Cheers, > Jonathan > > Le mer. 19 juin 2019 à 08:42, Fridolin SOMERS <fridolin.somers(a)biblibre.com> a écrit : >> >> Hi >> >> I'm proud to give you a new Koha staff theme plugin : >> https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_biblib >> re_koha-2Dplugin-2Dtheme-2Dintranet-2Dlsd&d=DwIGaQ&c=RvBXVp2Kc-itN3g6r >> 3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EP >> RI&m=3-g9EE1ciZ6Ju5FFNho6VUlxfYYmrVty2XHMIcVCVCU&s=FSHnmEJENDw9uUPdoiL >> wClDExUiVUxO-NGj6glk3IHs&e= >> >> You should read the README ;) >> >> Have fun XD >> >> -- >> Fridolin SOMERS <fridolin.somers(a)biblibre.com> BibLibre, France - >> software and system maintainer >> _______________________________________________ >> Koha mailing list >> https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.o >> rg&d=DwIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjy >> C51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=3-g9EE1ciZ6Ju5FFNho6VUlxfYYmrVty2X >> HMIcVCVCU&s=F0cZrDFCbgJo4P8KOQLIyAjy-NAHy9T2TKToxsrir5g&e= >> Koha(a)lists.katipo.co.nz >> https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.n >> z_mailman_listinfo_koha&d=DwIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVx >> j8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=3-g9EE1ciZ6Ju >> 5FFNho6VUlxfYYmrVty2XHMIcVCVCU&s=LyaGIEHLxUZAUm4vtqBmrbpwLr00Kynq2w1nz >> lwqbYI&e= > _______________________________________________ > Koha mailing list https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.org&d=… > Koha(a)lists.katipo.co.nz > https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.nz_mai… > > ---------------------------------------------------------------------- > MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopaedics, cancer and GI. > > IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you. > > Help conserve valuable resources - only print this email if necessary. > > -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> BibLibre, France - software and system maintainer

1 0

July 2019 koha-US meeting dates
by Jason Robb 01 Jul '19

01 Jul '19

*koha-US meetings are open to any and all.* *Board Meeting -* When: Wednesday, July 3rd at 10:30 am CDT (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+board+mee…> ) Where: https://kslib.zoom.us/j/450230564 Agenda: https://docs.google.com/document/d/1Fc-EA8nSgkADW67xW3a95EAd3kBD3D_ykYyuwRa… *Board meetings* focus on business-related matters and topics that would otherwise slow down general meetings. *General Meeting* - When: Wednesday, July 10th at 10:30 am CDT (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+general+m…> ) Where: https://kslib.zoom.us/j/110290143 *General meetings* put an emphasis on Koha -- bugs, issues, development ideas, workflows -- bring your problems and questions so we can discuss! These meetings also include major organizational decisions and reports from various committees. Meetings are held via Zoom video conferencing. A microphone and camera are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops and Android and iOS on mobile devices. For help getting started, visit: *https://support.zoom.us/hc/en-us/categories/200101697 <https://support.zoom.us/hc/en-us/categories/200101697>* If you have topics for discussion at either meeting, please send them to secretary(a)koha-us.org. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

Extracting Frequency of a Serial From metadata
by RAGHAV ARORA 01 Jul '19

01 Jul '19

Hello everyone, The SQL query to get the frequency for different serials was given on the KOHA SQL Library as : SELECT IF ( LOCATE('<datafield tag="310"', biblio_metadata.metadata) = 0 OR LOCATE('<subfield code="a">', biblio_metadata.metadata, LOCATE('<datafield tag="310"', biblio_metadata.metadata)) = 0 OR LOCATE('<subfield code="a">', biblio_metadata.metadata, LOCATE('<datafield tag="310"', biblio_metadata.metadata)) > LOCATE('</datafield>', biblio_metadata.metadata, LOCATE('<datafield tag="310"', biblio_metadata.metadata)), '', SUBSTRING( biblio_metadata.metadata, LOCATE('<subfield code="a">', biblio_metadata.metadata, LOCATE('<datafield tag="310"', biblio_metadata.metadata)) + 19, LOCATE('</subfield>', biblio_metadata.metadata, LOCATE('<subfield code="a">', biblio_metadata.metadata, LOCATE('<datafield tag="310"', biblio_metadata.metadata)) + 19) - (LOCATE('<subfield code="a">',biblio_metadata.metadata, LOCATE('<datafield tag="310"', biblio_metadata.metadata)) + 19) ) ) AS FREQUENCY When I run this query, it gives the output like 54/yr for some journals, which is correct, but for some, it returns something like 'M', '0', 'FN', 'SM', '#N/A', etc. Can someone please help me understand what should be the correct SQL query? Thanks in advance Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761, 8474975691 Personal Email <raghavarora999(a)yahoo.in> | University Email <f20171016(a)pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031

1 0

Setup library check-out computer for students to use
by L. Smith 30 Jun '19

30 Jun '19

Dear All, I need some help please. I would like to set up a self-issue computer for our students so that they can issue their own items using their student/library card. I have checked the Koha manual, but couldn't find the instructions on how to setup the screen to self-issue (check-out) mode. I just want the computer to check out items. Your help would be much appreciated. Kind regards, Lizelle Smith Registrar / Manager of Library Services _____________________________________ Suite 18, 7 Aberdeen Street, Perth WA 6000 PO Box D178 Perth BC 6849 T [ callto:08%209221%208170 | 08 9221 8170 ] E lsmith(a)sheridan.edu.au W sheridan.edu.au

2 1

Export database to koha and installing Koha
by Paula Marina Gutiérrez 30 Jun '19

30 Jun '19

Dear Colleages, I need guidance with this problem: I have a winisis database with CEPAL format. I am willing to export it to Koha. How can I do it.I am eager to install Koha but when I get to the webinstaller it seems that I lost a step, that I don't know how to configure it. Thanks in advance,Paula GutiérrezLibrarian

2 1

Error message shown during web installation
by Indranil Baruah 30 Jun '19

30 Jun '19

Following error is shown during web installation of Koha 19.05 on Lubuntu 19.04. The installation however completes but the speed of the application is slow even with Memcached running. ________________________________________________________ Mandatory data added subtag_registry.sql auth_val_cat.sql message_transport_types.sql sample_notices_message_attributes.sql sample_notices_message_transports.sql auth_values.sql * authorities_normal_marc21.sql* * [Fri Jun 14 19:07:09 2019] install.pl <http://install.pl>: DBD::mysql::st execute failed: Incorrect integer value: '' for column 'linkid' at row 148 at /usr/share/perl5/DBIx/RunSQL.pm line 278, <$args{...}> chunk 1.* class_sources.sql marc21_framework_DEFAULT.sql sample_frequencies.sql sample_notices.sql sample_numberpatterns.sql _______________________________________________________________ <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_cam…> Virus-free. www.avg.com <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_cam…> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

3 2

Notify the borrower when a hold is placed
by BOUIS Sonia 30 Jun '19

30 Jun '19

Hi, We would like to allow our university teacher to have very long loan period. We would like to notify them when a hold is placed on a book that they have checked out. Do you know if it's possible ? Thanks Cheers Sonia BOUIS ------------------------------------------------------ Responsable du Service des applications documentaires Bibliothèques universitaires Université Jean Moulin Lyon 3 ADRESSE GÉOGRAPHIQUE > Manufacture des Tabacs | 6 cours Albert Thomas | LYON 8e ADRESSE POSTALE > Bibliothèque de la Manufacture | 1C avenue des Frères Lumière | CS 78242 - 69372 LYON CEDEX 08 Ligne directe : 33 (0)4 78 78 79 03 http://bu.univ-lyon3.fr<http://bu.univ-lyon3.fr/>| Suivez-nous > Facebook<https://www.facebook.com/bulyon3/> | Twitter<https://twitter.com/bulyon3>| Instagram<https://www.instagram.com/bu.lyon3/?hl=fr> --------------------------------------------------- L'Université Jean Moulin est membre de l'Université de Lyon

4 4