- Koha - lists.katipo.co.nz

Re: [Koha] Publisher as authority
by Randy Smith 19 Aug '16

19 Aug '16

Adam Goforth <definingcode(a)gmail.com> wrote: > There is one thing we're having trouble figuring out: cataloging the > publisher name and location as an authority value. We've tried using > the Corporate Name authority, but it didn't work because the subfields > don't match between MARC fields 260 and 110. I also found the "Create > new authority type" page on the wiki, but I'd prefer not to maintain a > patch set I would need to apply after each Koha upgrade, so that > method isn't really optimal. > > It seems like this would be a fairly common use case, so I wonder if > I'm just missing something basic. How do most libraries catalog > publisher information? Adam, We also trace publisher and place of publication, as well as, printer and place of printing (often, this can be one and the same for many of the rare books we catalog). Publisher/printer is controlled in the 710 field. If an authority does not exist in LC, we will then search our OPAC for to make sure we have not already traced it. If it has not, we will create a new authority based on NACO standards (but since we are not NACO certified, the authority does not get sent to LC). As for location, that information we trace in field 752 <http://www.loc.gov/marc/bibliographic/bd752.html>. However, Bryan mentioned using 751 and that looks like it would work as well. Randy Smith Image technician | Metadata librarian Peter H. Raven Library Missouri Botanical Garden randy.smith(a)mobot.org | Peter H. Raven Library <http://explore.searchmobius.org/search~S1> | Botanicus <http://botanicus.org/> | Biodiversity Heritage Library <http://biodiversitylibrary.org/>

1 0

Re: [Koha] Koha Digest, Vol 130, Issue 31
by shankar reddy Kolle 19 Aug '16

19 Aug '16

Please see the output buntu:~$ sudo su [sudo] password for cohklib: root@ubuntu:/home/cohklib# cat /etc/apt/sources.list.d/koha.list wget -O- http://debian.koha-community.org/koha/gpg.asc clear root@ubuntu:/home/cohklib# wget -O- http://debian.koha-community. org/koha/gpg.asc | sudo apt-key --2016-08-15 08:33:19-- http://debian.koha-community.org/koha/gpg.asc Resolving debian.koha-community.org (debian.koha-community.org) Usage: apt-key [--keyring file] [command] [arguments] Manage apt's list of trusted keys apt-key add <file> - add the key contained in <file> ('-' for stdin) apt-key del <keyid> - remove the key <keyid> apt-key export <keyid> - output the key <keyid> apt-key exportall - output all trusted keys apt-key update - update keys using the keyring package apt-key net-update - update keys using the network apt-key list - list keys apt-key finger - list fingerprints apt-key adv - pass advanced options to gpg (download key) If no specific keyring file is given the command applies to all keyring files. 67.220.127.145 Connecting to debian.koha-community.org (debian.koha-community.org)|67.220.127.145|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 59549 (58K) [text/plain] Saving to: ‘STDOUT’ 0% [ ] 0 --.-K/s in 0s Cannot write to ‘-’ (Broken pipe). root@ubuntu:/home/cohklib# add -sudo apt-get update No command 'add' found, did you mean: Command 'tdd' from package 'devtodo' (universe) Command 'ad' from package 'netatalk' (universe) Command 'dd' from package 'coreutils' (main) Command 'amd' from package 'am-utils' (universe) Command 'ddd' from package 'ddd' (universe) Command 'ldd' from package 'libc-bin' (main) Command 'adb' from package 'android-tools-adb' (universe) Command 'hadd' from package 'root-system-bin' (universe) Command 'atd' from package 'at' (main) Command 'adbd' from package 'android-tools-adbd' (universe) Command 'and' from package 'and' (universe) Command 'axd' from package 'afnix' (universe) Command 'aid' from package 'id-utils' (universe) add: command not found root@ubuntu:/home/cohklib# On Mon, Aug 15, 2016 at 5:30 AM, <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: unable to locate koha-common (Dalton Fury) > 2. Re: Restrict access to SCO (Katrin Fischer) > 3. Re: IP restrictions not taking effect (Katrin Fischer) > 4. Re: customizing self check out cgi-bin/koha/sco/sco-main.pl > help message (Katrin Fischer) > 5. Wipe Out of Data on Koha Demo Site- reg (Mohd. Azim) > 6. Re: Koha: Wipe Out of Data on Koha Demo Site- reg (Arslan Farooq) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sun, 14 Aug 2016 10:54:31 +0530 > From: Dalton Fury <daltonfury42(a)gmail.com> > To: Mark Tompsett <mtompset(a)hotmail.com> > Cc: KOHA <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] unable to locate koha-common > Message-ID: > <CALH0Xhmf2n5Kra=syeA4NdEi3ZUYCdYt_B0KUQZUAuo8B26ZbA@mail. > gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Please post the output of the following three commands: > > 1) cat /etc/apt/sources.list.d/koha.list > 2) wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key > add - > 3) sudo apt-get update > > On Sat, Aug 13, 2016 at 8:57 PM, Mark Tompsett <mtompset(a)hotmail.com> > wrote: > > > Greetings, > > > > The instructions are very clear. > > > > Open a terminal window > > $ sudo ls > > [output cut – will need to type a password] > > $ echo deb http://debian.koha-community.org/koha stable main | sudo tee > > /etc/apt/sources.list.d/koha.list > > [output cut] > > $ wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key > > add - > > [output cut] > > $ sudo apt-get update > > [output cut ] > > $ sudo apt-get upgrade > > [output cut – clearly the answer is yes for an initial install] > > $ sudo apt-get clean > > [don’t think there is output, but it is cut, if there is any] > > $ sudo apt-get install koha-common > > > > Did any of these commands fail? > > Is the machine properly networked? > > > > The general goal of the Ubuntu package instructions ( > > https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages) was that > > a cut and paste (except for editing files) of the boxes (they are blue in > > my browser) should get you a working base install, from which you could > > tweak the apache settings latter if you wanted to go live to the > internet. > > > > Perhaps you could explain exactly what steps you are taking? > > > > GPML, > > Mark Tompsett > > > > From: shankar reddy Kolle<mailto:stkolle@gmail.com> > > Sent: Saturday, August 13, 2016 4:39 AM > > To: Mark Tompsett<mailto:mtompset@hotmail.com> > > Subject: Re: [Koha] unable to locate koha-common > > > > Dear sir, > > > > I tried using 14.04 also again same problem i am facing. "unable to > locate > > koha-common" > > > > > > Thanking you, > > > > yours sincerely, > > > > Shankar Reddy > > > > On Sat, Aug 13, 2016 at 10:10 AM, shankar reddy Kolle <stkolle(a)gmail.com > > <mailto:stkolle@gmail.com>> wrote: > > Dear sir, > > > > Thank you i will try with ubuntu 14.04 and thanks for information > > > > > > On Sat, Aug 13, 2016 at 10:05 AM, Mark Tompsett <mtompset(a)hotmail.com > > <mailto:mtompset@hotmail.com>> wrote: > > Greetings, > > > > shankar reddy Kolle<stkolle(a)gmail.com<mailto:stkolle@gmail.com>> wrote: > > > I have installed Ubuntu 12.0.4 for installation of Koha using package > > > method. > > > > Currently, Ubuntu 14.04 LTS is the recommendation for Koha, not Ubuntu > > 12.04 > > LTS. > > (https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_ > > packages#Introduction) > > > > > > shankar reddy Kolle<stkolle(a)gmail.com<mailto:stkolle@gmail.com>> wrote: > > > but i got the error "unable to locate koha-common " while > > > installation process. > > > > Next, did you add the appropriate repositories? > > https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_ > > packages#Add_A_Koha_Community_Repository > > > > > > shankar reddy Kolle<stkolle(a)gmail.com<mailto:stkolle@gmail.com>> wrote: > > > Please let me know, how to fix it. > > > > Hope these links provide you the information to address your issues. > > > > > > GPML, > > Mark Tompsett > > > > > > > > > > -- > > Best regards > > Dr. Shankar Reddy Kolle > > Assistant Librarian > > (University of Horticultural Sciences, Bagalkot) > > College of Horticulture, Kolar > > Cell no.9742749018<tel:9742749018> > > > > > > > > -- > > Best regards > > Dr. Shankar Reddy Kolle > > Assistant Librarian > > (University of Horticultural Sciences, Bagalkot) > > College of Horticulture, Kolar > > Cell no.9742749018 > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 2 > Date: Sun, 14 Aug 2016 09:56:18 +0200 > From: Katrin Fischer <Katrin.Fischer.83(a)web.de> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Restrict access to SCO > Message-ID: <27d69b64-696e-109a-28e2-46ef4b3d2b5f(a)web.de> > Content-Type: text/plain; charset=utf-8 > > Hi Clint, > > I don't know how to do this with Apache, but there is an open bug > related to this, that might be interesting for you: > > Bug 14407 - Limit web-based self-checkout to specific IP addresses > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14407 > > Hope this helps, > > Katrin > > > Am 13.08.2016 um 01:34 schrieb clint.deckard: > > I would like to restrict access to the Self Checkout to just a single ip > > address. > > I believe the Apache mod_authz_host module is the answer but am unsure > > just how to implement it in a multi-instance set-up. > > > > I would appreciate any tips on how to do it. > > > > Thank you, > > Clint Deckard. > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > ------------------------------ > > Message: 3 > Date: Sun, 14 Aug 2016 10:40:42 +0200 > From: Katrin Fischer <Katrin.Fischer.83(a)web.de> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] IP restrictions not taking effect > Message-ID: <b12b5dce-6830-2ca1-e706-acbba5e235e1(a)web.de> > Content-Type: text/plain; charset=utf-8 > > Hi, > > did you also set the AutoLocation system preference to "Require"? > > http://translate.koha-community.org/manual/master/ > en/html-desktop/#AutoLocation > > Hope this helps, > > Katrin > > Am 10.08.2016 um 13:40 schrieb Dalton Fury: > > Hi, > > > > I am trying to restrict staff logins to one subnet. What I tried is to > set" > > IP" field in "Modify Library" to "192.168.56.*". But to our dismay, this > > did not have any effect. We even tried restricting staff logins to a > > particular IP, but even that did not work. > > > > What am I missing here? > > > > Thanks! > > Navaneeth K > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > ------------------------------ > > Message: 4 > Date: Sun, 14 Aug 2016 10:42:43 +0200 > From: Katrin Fischer <Katrin.Fischer.83(a)web.de> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] customizing self check out > cgi-bin/koha/sco/sco-main.pl help message > Message-ID: <9262eee1-b388-85c9-88ce-1e275f6444c9(a)web.de> > Content-Type: text/plain; charset=utf-8 > > Thx for sharing your solution! > > Am 13.08.2016 um 09:05 schrieb schnydszch: > > I was able to resolve this and I'm sharing it so that those who will be > doing > > similar things can take a look at this thread. First and foremost, there > is > > SCOUserJS in order that the interface in Self Check out be further > > customized, there is even SCOUserCSS. Well, the key was to find the > correct > > divs in order to insert some HTMLs. The self check out guide which can > only > > be seen if Help was clicked was added through this: > > $("#masthead").append('<div><br><div class="box rounded"> > > Self Checkout Step-by-Step Guide > > <br></div> > > Step one: Scan your ID card barcode number > > Step two: Scan the barcode of each book (one at a time) > > <p>Scan one barcode number and wait for the page to reload before > scanning > > the next barcode. The checked-out item should appear in your checkout > > list.</p> > > Step three: Click the "Finish" button > > <p>If you do not click the "Finish" button, your session will > automatically > > expire in 60 seconds.</p></div>'); > > Other things were also done such that links aren't clickable in the SCO: > > > > /* Remove the tabs in SCO > > --------------------------------------*/ > > $(document).ready(function(){ > > $("ul#head-nav").hide(); > > }); > > > > /* Remove h1 in SCO > > --------------------------------------*/ > > $(document).ready(function(){ > > $("h1").hide(); > > }); > > > > /* Disable all links in SCO ---------------------*/ > > $(document).ready(function(){ > > $('a').removeAttr('href'); > > }); > > > > /* Hide ?Help in SCO ---------------------*/ > > $(document).ready(function(){ > > $('i.icon.help').hide(); > > $("a:contains('Help')").text(""); > > }); > > > > I can't remove the footer in SCO (I don't know why?) so I added the > > following below in OPACUserJS > > /* Remove footer in SCO ---------------------*/ > > $(document).ready(function(){ > > if(/sco-main/.test(self.location.href)){ > > $("#footer-texts.pull-left").remove(); > > } > > }); > > > > Well that's all. Cheers and have nice day! > > > > > > > > -- > > View this message in context: http://koha.1045719.n5.nabble. > com/customizing-self-check-out-cgi-bin-koha-sco-sco-main-pl-help-message- > tp5898007p5899599.html > > Sent from the Koha-general mailing list archive at Nabble.com. > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > ------------------------------ > > Message: 5 > Date: Fri, 12 Aug 2016 10:28:09 +0530 > From: "Mohd. Azim" <azeemalig.khan(a)gmail.com> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] Wipe Out of Data on Koha Demo Site- reg > Message-ID: > <CAEJYVPXvL2G7RTwKiB3w8vZnR4t=Etw90BXF1+Y3bEfctPCQbQ@mail. > gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Dear All, > > A very Good Morning to all of you. I have a query regarding the Demo of > koha, I am using the Demo site of koha on Koha Community website but all my > data (Patrons, Libraries, Members etc) wiped out from the server on next > day. > > Can anyone tell me how I can save my data for few days or for few months on > the Demo site of koha for testing purpose only. > > Thanks. > > -- > > > *Best Regards* > > > > *Mohd. Azim* > > Semi Professional > > Maulana Azad Library > > Aligarh Muslim University > > Aligarh, India-202002 > > Mob: +91 8439129662 > > Website: > http://www.amu.ac.in/amulibshowfacultydata2.jsp?did=10066&eid=10061263 > > ****************************** > > > ------------------------------ > > Message: 6 > Date: Sat, 13 Aug 2016 12:25:02 +0500 > From: Arslan Farooq <arslanone(a)gmail.com> > To: "Mohd. Azim" <azeemalig.khan(a)gmail.com> > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Koha: Wipe Out of Data on Koha Demo Site- reg > Message-ID: > <CAFqgOiLTU4g3bD50beRsQofgf8GmSgETOvPeTL-KA0y7N3nPZA@mail. > gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Hi, > > All demos usually reset data daily or at some interval. > > Arslan > > On Aug 13, 2016 9:48 AM, "Mohd. Azim" <azeemalig.khan(a)gmail.com> wrote: > > > Dear All, > > > > A very Good Morning to all of you. I have a query regarding the Demo site > > of koha, I am using the Demo site of koha on Koha Community website but > all > > my data (Patrons, Libraries, Members etc) wiped out from the server on > > next day. > > > > Can anyone tell me how I can save my data for few days or for few months > on > > the Demo site of koha for testing purpose only. > > > > Thanks. > > > > > > -- > > > > > > *Best Regards* > > > > > > > > *Mohd. Azim* > > > > Semi Professional > > > > Maulana Azad Library > > > > Aligarh Muslim University > > > > Aligarh, India-202002 > > > > Mob: +91 8439129662 > > > > Website: > > http://www.amu.ac.in/amulibshowfacultydata2.jsp?did=10066&eid=10061263 > > > > ****************************** > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > 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 130, Issue 31 > ************************************* > -- Best regards Dr. Shankar Reddy Kolle Assistant Librarian (University of Horticultural Sciences, Bagalkot) College of Horticulture, Kolar Cell no.9742749018

1 1

Publisher as authority
by Adam Goforth 19 Aug '16

19 Aug '16

Hi All, I'm new to the Koha community, so first a brief introduction: I'm the IT administrator at the International English Library in Düsseldorf, Germany. We migrated to Koha a couple of weeks ago and we're quite happy with all the improvements over our previous ILS. There is one thing we're having trouble figuring out: cataloging the publisher name and location as an authority value. We've tried using the Corporate Name authority, but it didn't work because the subfields don't match between MARC fields 260 and 110. I also found the "Create new authority type" page on the wiki, but I'd prefer not to maintain a patch set I would need to apply after each Koha upgrade, so that method isn't really optimal. It seems like this would be a fairly common use case, so I wonder if I'm just missing something basic. How do most libraries catalog publisher information? Thanks in advance for any help you can offer. Adam

3 3

Upgrading Ubuntu Kernel
by Bortel, Gary 18 Aug '16

18 Aug '16

Running Koha 3.22.09 Debian package & Unbuntu 14.04 The last I heard, Ubuntu 14.04 is still the recommended version of that OS for hosting Koha. Will upgrading the kernel from 3.16 to Xenial (4.4) cause issues? I seem to recall reading somewhere that Biblibre was planning to do this earlier this month. gcb

2 1

Call for News: August 2016 Newsletter
by kohanews 18 Aug '16

18 Aug '16

Fellow Koha users ~ I'm collecting news for the August newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: * - Please include dates for past events. If I can't find dates I may not add it. * - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon * - For past events -- **** one month back is the cut-off ***. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. -- Chad Roseburg Editor, Koha Community Newsletter

1 0

Deletion of Multiple item Records
by Admire Mutsikiwa 18 Aug '16

18 Aug '16

Hi I have a user who have attached a number of multiple records in the cataloguing Module using the Add Multiple Item button. I would like an SQL command that will enable us to delete both the items and biblioitems records in a range. Kind Regards, Admire Mutsikiwa (Mr) ICT Manager Libraries University of Zimbabwe Tel:+263-4-303276 Mob:+263771117777 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp <http://www.goodreads.com/author/show/4867406.Josiah_Charles_Stamp>

2 1

Marcedit and Libreoffice
by Nombre 18 Aug '16

18 Aug '16

Hello. Is there anybody out there (Pink Floyd) using Marcedit in Ubuntu with ODS spreadsheets from Libreoffice? First of all, I tried to use directly xls format, but not possible. I've tried with csv format but only one record was translated. Regards

2 1

IP restrictions not taking effect
by Dalton Fury 18 Aug '16

18 Aug '16

Hi, I am trying to restrict staff logins to one subnet. What I tried is to set" IP" field in "Modify Library" to "192.168.56.*". But to our dismay, this did not have any effect. We even tried restricting staff logins to a particular IP, but even that did not work. What am I missing here? Thanks! Navaneeth K

3 3

Don't allow check in unless dues are cleared.
by Dalton Fury 18 Aug '16

18 Aug '16

Hi all, We have migrated to koha a month ago and are very happy ever since. We have a policy that if a book has some fine, the patron must pay it at the time of returning the book. Unless he clears the due, he should not be allowed to return the book. How do I enforce this in koha? Regards, Navaneeth Kishore

4 6

SQL Help - Add barcode column to SQL query that searches subject keywords
by Jorge de Cardenas 17 Aug '16

17 Aug '16

I think will work for you: SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber= ',biblionumber,'\">',biblionumber,'</a>') AS bibnumber, lcsh,* barcode* FROM (SELECT biblionumber, *barcode*, EXTRACTVALUE(marcxml,'//datafield[@tag="690"]/subfield[@code>="a"]') AS lcsh FROM biblioitems LEFT JOIN items USING(biblionumber)) AS subjects WHERE lcsh LIKE <<Enter keyword surrounded BY %>> >Hi all, > >I'm trying to get the barcodes column from the items database to display on the results page after running the following SQL query: > >SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber= ',biblionumber,'\">',biblionumber,'</a>') >AS bibnumber, lcsh >FROM >(SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="690"]/subfield[@code>="a"]') >AS lcsh FROM biblioitems) >AS subjects >WHERE lcsh >LIKE <<Enter keyword surrounded BY %>> >WHERE biblionumber.biblionumber=items.barcode > > >The above I found on the Koha SQL library, but this query only displays the biblionumber and keyword query results in 690a. I'd like to add the barcodes column to the report. Can't seem figure out how to do this in this query. Help, please :) > >Many thanks! > >C > >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/ -- Jorge de Cardenas | Head Systems Administrator 3512 Darrow Road, Stow, OH 44224 330 688-3295, ext 106 | FAX 330 688-0448 | www.smfpl.org | <http://www.facebook.com/SMFPL> <http://twitter.com/smfpl> <http://pinterest.com/smfpl/boards> If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the institution.

1 0