- Koha - lists.katipo.co.nz

Bill Number and Bill date
by Yatheesh lis 15 Oct '19

15 Oct '19

Hi Can anyone suggest where we have enter this details in koha

2 1

Re: [Koha] Creating Lists of Item Numbers
by Charles Kelley 15 Oct '19

15 Oct '19

Hello, all! In a recent exchange, on 14 Oct 2019, at 07:31 AM, Mark Alexander wrote: I believe that generating of lists is usually done with reports. > See this section of the Koha manual: > > https://koha-community.org/manual/19.05/en/html/reports.html > > Also see this page, which shows many sample reports: > > https://wiki.koha-community.org/wiki/SQL_Reports_Library > You're right! I found the section and I'll be studying it later today. In our latest exchange, on 14 Oct 2019, at 10:05 AM, Eric Phetteplace wrote: > In particular, the SQL you will need is likely: > > SELECT itemnumber > FROM items > WHERE location IS NULL OR location = '' > > That will give you a simple list of item IDs that do not have an associated > shelving location ("location" in the database's terms). If you're on a > modern version of Koha, there will even be a "batch modify" button in the > report results which takes you to exactly the Batch item modification tool > with all of these items ready to be bulk edited. > This really helped. I was able to add the missing shelving location. All is good. Between Eric's SQL statements and Mark's reference to the report sections of the documentation, I'll be in good stead, I think. Thanks, too, for suggesting the NULL data check as well as the empty string check. So often one can miss checking both, especially given the structure and storage of SQL databases. I had forgotten about that. Thanks to you both! -- -- Charles. Charles Kelley, MLS Data Analyst (Library and Information Services) SAIC Reston, VA, USA 1-301-741-7122 [US cell] 011-81-80-4714-5490 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

1 0

Creating Lists of Item Numbers
by Charles Kelley 14 Oct '19

14 Oct '19

Hello, all! Please excuse the use of the terminology from my former ILS, Innovative. I cannot find the analog in Koha. My library and I are new to Koha and are just learning it. I have set up a library with libraries, branches, collections, etc. I now find that I have to do a mass change of empty shelving locations to a general shelving one; i.e., 952$c, previously blank, will be filled with the general shelving code. I have watched several versions of the ByWaters Solutions tutorials on YouTube, and I'm stuck. I understand the proper command is Tools -> Batch item modification. I also understand the need to compile the relevant items into a list of item (ID) numbers. Unfortunately, I cannot find in the documentation instructions on how to compile such a list. I also cannot find instructions through a web search. Can someone help me? Is there a tutorial on compiling item lists, bib. record lists, patron lists, etc.? Thank you very much for your help. -- -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley 1-5-2 Tsukimino #210 Yamato-shi, Kanagawa-ken, 〒242-0002 JAPAN 1-301-741-7122 [US cell] 011-81-80-4714-5490 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

3 2

Searching Error
by Luis Moises Rojas 14 Oct '19

14 Oct '19

Hello everybody, In Circulation Module, when we search we are having the following error: Can't call method "lengthunit" on an undefined value at /usr/share/koha/lib/koha/charges/Fees.pm line 101 This is new. Where using Koha 19.05.02 -- *Luis Moisés Rojas P.*

2 1

Unsubscribes asap
by Priyanka Mishra 13 Oct '19

13 Oct '19

1 0

vendor searching error
by Paweł Niedźwiadek 12 Oct '19

12 Oct '19

Good evening, When I try to search for the vendor I created, I get the error seen below : Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081. I found this https://www.mail-archive.com/koha@lists.katipo.co.nz/msg22857.html , but there is no answer. Koha 19.05, Apache/2.4.29 (Ubuntu), mysql Ver 14.14 Distrib 5.7.27, Perl version 5.026001 Please, help. regards, Paweł Niedźwiadek pawel(a)ictprojekt.pl<mailto:pawel@ictprojekt.pl>

1 0

too many items
by ICTPROJEKT PAWEL NIEDZWIADEK 12 Oct '19

12 Oct '19

Hi everyone, I imported MARC records prepared in MarcEdit into my Koha. Almost everything is ok. But there is a problem with items. When I see bibliographic record, there are 3 items connected with this record: one with price, one with callnumber and third with barcode. I would like to have only one 😊 Any suggestions? Best regards Paweł Niedźwiadek pawel(a)ictprojekt.pl<mailto:pawel@ictprojekt.pl> Poland

3 2

Auto Reminder Through Email
by rizwan qureshi 12 Oct '19

12 Oct '19

Hi Dear, I am working in University Library and using KOHA software for library material management. There is a problem regarding over dues books, I want to send patron over due or long due library material's reminder via email generated by KOHA software. In this regards I need some help from your side. Best Sunny.

2 1

Re: [Koha] koha-elasticsearch --rebuild errors (Fridolin SOMERS)
by Peter Zhao 11 Oct '19

11 Oct '19

Elasticserver version is 5.6.16 and installed ICU plugin. >Hi, > >Which Elasticserver version please ? >And did you install ICU plugin in ES ? > >For UNIMARC config see Bug 20390 > >Regards, > >Le 10/10/2019 à 04:24, Peter Zhao a écrit : >> Hi, I installed a koha and used UNIMARC, zebra index works well but the elastic index cannot work, when I do "sudo koha-elasticsearch --rebuild -b -v library", it shows errors. >> Koha version: 19.05.04.000 >> OS version ('uname -a'): Linux koha 4.15.0-65-generic #74-Ubuntu SMP Tue Sep 17 17:06:04 UTC 2019 x86_64 >> Perl interpreter: /usr/bin/perl >> Perl version: 5.026001 >> ------- >> I'v got the following error message . How to fix this problem? >> Peter >> >> >> >> >> H2NCUzIzMDguQzQ3L0I1IDE5OTMvUkVGH2QyMDA2MDEwNzY1H2U0MR9mMDAxH2cyOB9oMTk5Mx9p >> H2oyMDA2LTAzLTMxH2swNx9sH20eICAfYTIwMDYwMTA3NzkfYjAwMDExH2NCUzIzMDguQzQ3L0I1 >> IDE5OTMvUkVGH2QyMDA2MDEwNzc5H2U0Mx9mMDAxH2cyOB9oMTk5Mx9pH2oyMDA2LTA0LTA0H2sw >> Nx9sH20eICAfY0NOQk9PSx4gIB8wMB8yMB81MjAxOS0wNi0wOR85NzU5MR9iZGVtbx9jZGVtbx9l >> MDAwMDIfZjIwMDYwMTA3NjUfa0JTMjMwOC5DNDcvQjUgMTk5My9SRUYfbzAfckNOQk9PSx4gIB8w >> MB8yMB81MjAxOS0wNi0wOR85NzU5Mh9iZGVtbx9jZGVtbx9lMDAwMTEfZjIwMDYwMTA3Nzkfa0JT >> MjMwOC5DNDcvQjUgMTk5My9SRUYfbzAfckNOQk9PSx4gIB9jNDk0MB9kNDk0MB4d >> ','lf' => ['y'],'ln__sort' => ['chigrk'],'location__facet' => ['00002','00011'],'ctype' => ['B '],'itype__facet' => ['CNBOOK'],'itype' => ['CNBOOK'],'ff8-29__sort' => ['0'],'suppress' => 'false','itype__sort' => ['CNBOOK'],'subject__sort' => ["\x{7ecf}\x{6587}\x{6c47}\x{7f16}"],'local-number' => [4940],'bio__sort' => ['y'],'subject__suggestion' => [{'input' => "\x{7ecf}\x{6587}\x{6c47}\x{7f16}"}],'publisher' => ["\x{57fa}\x{7763}\x{6559}\x{4e09}\x{81ea}\x{7231}\x{56fd}\x{8fd0}\x{52a8}\x{59d4}\x{5458}\x{4f1a}"],'title__suggestion' => [{'input' => "\x{6807}\x{6ce8}\x{539f}\x{6587}\x{5e0c}\x{814a}\x{5b57}\x{7684}\x{65b0}\x{7ea6}\x{5723}\x{7ecf}\x{7ecf}\x{6587}\x{6c47}\x{7f16}"}],'location' => ['00002','00011'],'author__suggestion' => [{'input' => "\x{5468}\x{884c}\x{4e49}, \x{9ec4}\x{5f97}\x{6069}\x{7f16}\x{8457} "}],'lf__sort' => ['y'],'publisher__facet' => ["\x{57fa}\x{7763}\x{6559}\x{4e09}\x{81ea}\x{7231}\x{56fd}\x{8fd0}\x{52a8}\x{59d4}\x{5458}\x{4f1a}"],'date-of-acquisition__sort' => ['2019-06-09'],'date-of-acquisition' => ['2019-06-09'],'local-classification__suggestion' => [{'input' => 'BS2308.C47/B5 1993/REF'}],'title__sort' => ["\x{6807}\x{6ce8}\x{539f}\x{6587}\x{5e0c}\x{814a}\x{5b57}\x{7684}\x{65b0}\x{7ea6}\x{5723}\x{7ecf}\x{7ecf}\x{6587}\x{6c47}\x{7f16}"],'homebranch__facet' => ['demo']},{'index' => {'_id' => '4941'}},{'ta' => ['e'],'marc_format' => 'base64ISO2709','subject' => ["\x{7ecf}\x{6587}\x{6c47}\x{7f16}"],'itemnumber' => ['7593','7594'],'local-classification' => ['BS2308/.C47 B5/INDEX REF'],'date-of-publication' => ['1993'],'holdingbranch' => ['demo'],'title' => ["\x{6807}\x{6ce8}\x{539f}\x{6587}\x{5e0c}\x{814a}\x{5b57}\x{7684}\x{65b0}\x{7ea6}\x{5723}\x{7ecf}\x{7ecf}\x{6587}\x{6c47}\x{7f16} (\x{7d22}\x{5f15})"],'homebranch' => ['demo'],'ff8-29' => ['0'],'notforloan' => ['0'],'date-of-publication__sort' => ['1993'],'ta__sort' => ['e'],'onloan' => 'false','bio' => ['y'],'subject__facet' => ["\x{7ecf}\x{6587}\x{6c47}\x{7f16}"],'author__sort' => ["[\x{5468}\x{884c}\x{4e49}, \x{9ec4}\x{5f97}\x{6069}]\x{7f16}\x{8457} \x{5468}\x{884c}\x{4e49} \x{7f16}\x{8457} \x{9ec4}\x{5f97}\x{6069}"],'publisher__sort' => ["\x{6c5f}\x{82cf}\x{7701}\x{57fa}\x{7763}\x{6559}\x{4e09}\x{81ea}\x{7231}\x{56fd}\x{8fd0}\x{52a8}\x{59d4}\x{5458}\x{4f1a}"],'ln' => ['chi'],'homebranch__facet' => ['demo'],'title__sort' => ["\x{6807}\x{6ce8}\x{539f}\x{6587}\x{5e0c}\x{814a}\x{5b57}\x{7684}\x{65b0}\x{7ea6}\x{5723}\x{7ecf}\x{7ecf}\x{6587}\x{6c47}\x{7f16} (\x{7d22}\x{5f15})"],'local-classification__suggestion' => [{'input' => 'BS2308/.C47 B5/INDEX REF'}],'date-of-acquisition' => ['2019-06-09'],'publisher__facet' => ["\x{6c5f}\x{82cf}\x{7701}\x{57fa}\x{7763}\x{6559}\x{4e09}\x{81ea}\x{7231}\x{56fd}\x{8fd0}\x{52a8}\x{59d4}\x{5458}\x{4f1a}"],'date-of-acquisition__sort' => ['2019-06-09'],'lf__sort' => ['y'],'location' => ['00002','00011'],'author__suggestion' => [{'input' => "[\x{5468}\x{884c}\x{4e49}, \x{9ec4}\x{5f97}\x{6069}]\x{7f16}\x{8457} "}],'title__suggestion' => [{'input' => "\x{6807}\x{6ce8}\x{539f}\x{6587}\x{5e0c}\x{814a}\x{5b57}\x{7684}\x{65b0}\x{7ea6}\x{5723}\x{7ecf}\x{7ecf}\x{6587}\x{6c47}\x{7f16} (\x{7d22}\x{5f15})"}],'publisher' => ["\x{6c5f}\x{82cf}\x{7701}\x{57fa}\x{7763}\x{6559}\x{4e09}\x{81ea}\x{7231}\x{56fd}\x{8fd0}\x{52a8}\x{59d4}\x{5458}\x{4f1a}"],'subject__suggestion' => [{'input' => "\x{7ecf}\x{6587}\x{6c47}\x{7f16}"}],'bio__sort' => ['y'],'local-number' => [4941],'subject__sort' => ["\x{7ecf}\x{6587}\x{6c47}\x{7f16}"],'ff8-29__sort' => ['0'],'suppress' => 'false','itype__sort' => ['CNBOOK'],'itype__facet' => ['CNBOOK'],'itype' => ['CNBOOK'],'ctype' => ['c '],'location__facet' => ['00002','00011'],'ln__sort' => ['chi'],'lf' => ['y'],'author' => ["[\x{5468}\x{884c}\x{4e49}, \x{9ec4}\x{5f97}\x{6069}]\x{7f16}\x{8457} ","\x{5468}\x{884c}\x{4e49}","\x{7f16}\x{8457}","\x{9ec4}\x{5f97}\x{6069}"], >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > >-- >Fridolin SOMERS <fridolin.somers(a)biblibre.com> >BibLibre, France - software and system maintainer >

1 0

Help with being listed
by Anthony Snell 10 Oct '19

10 Oct '19

Hello, We would like to know if anyone can help us by giving the normal wait time from the Koha Team to get approved as a paid provider? Trident Consulting Firm

1 0