Re: [Koha] A more complete report on lost documents
Thanks Michael, It was a simple problem with a comma on line 5: ExtractValue(bi.marcxml, '//datafield[@tag="210"]/subfield[@code="d"]') as Date*,* After correcting the problem, it worked just fine :) All the best, Vanda 2018-02-28 10:23 GMT+00:00 Michael Kuhn : > Hi Vanda Koha > > You wrote: > > > *The following error was encountered:* The database returned the > > following error: > > You have an error in your SQL syntax; check the manual that > > corresponds to your MariaDB server version for the right syntax to use > > near 'FROM items i LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) > LEFT JOIN b' at line 6 > > Please check the log for further details. > > I omitted some errors and then tested the following SQL statement using > the Biblibre demo installation of Koha 16.11 ( > http://intranet-demo.biblibre.com/ ) and it reported no more errors: > > SELECT i.itemnumber, b.title, b.author, i.itemcallnumber, i.barcode, > v.lib, ExtractValue(bi.marcxml,'//datafield[@tag="205"]/subfield[@code="a"]') > as Edition, > ExtractValue(bi.marcxml,'//datafield[@tag="210"]/subfield[@code="c"]') > as Publisher, > ExtractValue(bi.marcxml,'//datafield[@tag="210"]/subfield[@code="d"]') > as Date > FROM items i > LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) > LEFT JOIN biblioitems bi ON (i.biblioitemnumber=bi.biblioitemnumber) > LEFT JOIN authorised_values v ON (i.itemlost=v.authorised_value) > WHERE i.itemlost != 0 AND v.category='LOST' > > In the demo insrtallation no matches were found but in your own database > this would be different, I guess. > > Hope this helps. > > Best wishes: Michael > -- > Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis > Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz > T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] A more complete report on lost documents
Hi Eric, Good news! Your query had only a small problem: a comma on line 5: ExtractValue(bi.marcxml, '//datafield[@tag="210"]/subfield[@code="d"]') as Date*,* As soon as I removed the comma, it worked just fine! :) So I'll leave here the right query: it may be useful for someone else: SELECT i.itemnumber, b.title, b.author, i.itemcallnumber, i.barcode, v.lib, ExtractValue(bi.marcxml, '//datafield[@tag="205"]/subfield[@code="a"]') as Edition, ExtractValue(bi.marcxml, '//datafield[@tag="210"]/subfield[@code="c"]') as Publisher, ExtractValue(bi.marcxml, '//datafield[@tag="210"]/subfield[@code="d"]') as Date FROM items i LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) LEFT JOIN authorised_values v ON (i.itemlost=v.authorised_value) LEFT JOIN biblioitems bi ON (i.biblioitemnumber=bi.biblioitemnumber) WHERE i.itemlost != 0 AND v.category='LOST' Thanks a lot for your help and your explanation. Without it I wouldn't be able to find the answer. All the best, Vanda 2018-02-28 9:47 GMT+00:00 vanda koha : > Hi Eric, > Thanks for your help. > > I tried your query but it didn't work. The Koha showed the following: > > > > *The following error was encountered:* The database returned the > following error: > You have an error in your SQL syntax; check the manual that corresponds to > your MariaDB server version for the right syntax to use near 'FROM items i > LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) LEFT JOIN b' at > line 6 > Please check the log for further details. > > > Any ideas? > > Thanks again, > > Vanda > > 2018-02-27 16:28 GMT+00:00 Eric Phetteplace : > >> Hi Vanda, >> >> You need to connect to the biblioitems table which holds the MARC record >> in its "marcxml" field, then use the SQL ExtractValue >> <https://mariadb.com/kb/en/library/extractvalue/> function to pull out >> these specific MARC fields. This process is necessary because not every >> single MARC tag is in its own database field, you have to get most of the >> data out of the field that storess the full record. So a report like this >> should accomplish what you want: >> >> SELECT i.itemnumber, b.title, b.author, i.itemcallnumber, >>i.barcode, v.lib, >>ExtractValue(bi.marcxml, >> '//datafield[@tag="205"]/subfield[@code="a"]') >> as Edition, >>ExtractValue(bi.marcxml, >> '//datafield[@tag="210"]/subfield[@code="c"]') >> as Publisher, >>ExtractValue(bi.marcxml, >> '//datafield[@tag="210"]/subfield[@code="d"]') >> as Date, >> FROM items i >> LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) >> LEFT JOIN biblioitems bi ON (i.biblioitemnumber=bi.biblioitemnumber) >> LEFT JOIN authorised_values v ON (i.itemlost=v.authorised_value) >> WHERE i.itemlost != 0 AND v.category='LOST' >> >> The three ExtractValue lines pull out the fields you specified while the >> one additional join adds the biblioitems table to the query. >> >> Note that, in newer Koha versions starting with 17.05 the MARCXML record >> is stored in the biblio_metadata >> <http://schema.koha-community.org/17_05/tables/biblio_metadata.html> >> table and so the report would look just slightly different. >> >> >> >> Best, >> >> ERIC PHETTEPLACE >> >> Systems Librarian >> >> >> libraries.cca.edu | vault.cca.edu | 510.594.3660 <(510)%20594-3660> >> >> 5212 Broadway, Oakland, CA 94618 >> <https://maps.google.com/?q=5212+Broadway,+Oakland,+CA+94618&entry=gmail&source=g> >> >> 8th St., San Francisco, CA >> <https://maps.google.com/?q=+8th+St.,+San+Francisco,+CA%C2%A0+94107&entry=gmail&source=g> >> 94107 >> <https://maps.google.com/?q=+8th+St.,+San+Francisco,+CA%C2%A0+94107&entry=gmail&source=g> >> >> Preferred Pronoun(s): he/him >> >> :(){ :|: & };: >> >> On Tue, Feb 27, 2018 at 2:03 AM, vanda koha wrote: >> >>> Hi everybody, >>> >>> We are using 16.11.04 Koha version and I need to have a list of all my >>> Lost >>> documents, so I am running the following report: >>> >>> >>> SELECT i.itemnumber, b.title, b.author, i.itemcallnumber, >>>i.barcode, v.lib >>> FROM items i >>> LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) >>&
Re: [Koha] A more complete report on lost documents
Hi Eric, Thanks for your help. I tried your query but it didn't work. The Koha showed the following: *The following error was encountered:* The database returned the following error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM items i LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) LEFT JOIN b' at line 6 Please check the log for further details. Any ideas? Thanks again, Vanda 2018-02-27 16:28 GMT+00:00 Eric Phetteplace : > Hi Vanda, > > You need to connect to the biblioitems table which holds the MARC record > in its "marcxml" field, then use the SQL ExtractValue > <https://mariadb.com/kb/en/library/extractvalue/> function to pull out > these specific MARC fields. This process is necessary because not every > single MARC tag is in its own database field, you have to get most of the > data out of the field that storess the full record. So a report like this > should accomplish what you want: > > SELECT i.itemnumber, b.title, b.author, i.itemcallnumber, >i.barcode, v.lib, >ExtractValue(bi.marcxml, '//datafield[@tag="205"]/subfield[@code="a"]') > as Edition, >ExtractValue(bi.marcxml, '//datafield[@tag="210"]/subfield[@code="c"]') > as Publisher, >ExtractValue(bi.marcxml, '//datafield[@tag="210"]/subfield[@code="d"]') > as Date, > FROM items i > LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) > LEFT JOIN biblioitems bi ON (i.biblioitemnumber=bi.biblioitemnumber) > LEFT JOIN authorised_values v ON (i.itemlost=v.authorised_value) > WHERE i.itemlost != 0 AND v.category='LOST' > > The three ExtractValue lines pull out the fields you specified while the > one additional join adds the biblioitems table to the query. > > Note that, in newer Koha versions starting with 17.05 the MARCXML record > is stored in the biblio_metadata > <http://schema.koha-community.org/17_05/tables/biblio_metadata.html> > table and so the report would look just slightly different. > > > > Best, > > ERIC PHETTEPLACE > > Systems Librarian > > > libraries.cca.edu | vault.cca.edu | 510.594.3660 <(510)%20594-3660> > > 5212 Broadway, Oakland, CA 94618 > <https://maps.google.com/?q=5212+Broadway,+Oakland,+CA+94618&entry=gmail&source=g> > > 8th St., San Francisco, CA > <https://maps.google.com/?q=+8th+St.,+San+Francisco,+CA%C2%A0+94107&entry=gmail&source=g> > 94107 > <https://maps.google.com/?q=+8th+St.,+San+Francisco,+CA%C2%A0+94107&entry=gmail&source=g> > > Preferred Pronoun(s): he/him > > :(){ :|: & };: > > On Tue, Feb 27, 2018 at 2:03 AM, vanda koha wrote: > >> Hi everybody, >> >> We are using 16.11.04 Koha version and I need to have a list of all my >> Lost >> documents, so I am running the following report: >> >> >> SELECT i.itemnumber, b.title, b.author, i.itemcallnumber, >>i.barcode, v.lib >> FROM items i >> LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) >> LEFT JOIN authorised_values v ON (i.itemlost=v.authorised_value) >> WHERE i.itemlost != 0 AND v.category='LOST' >> >> >> However this is a little incomplete, because I need also the information >> about the *Edition Statement*, *Publisher Name *and the *Date of >> Publication *to appear in the results. We use Unimarc and the fields I >> also >> need to show up in the results are: >> >> 205 a (Edition Statement) >> 210 c (Publisher Name) >> 210 d (Date of Publication). >> >> Can anyone help me with this SQL query? >> >> Many thanks in advance >> >> Vanda >> ___ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] A more complete report on lost documents
Hi everybody, We are using 16.11.04 Koha version and I need to have a list of all my Lost documents, so I am running the following report: SELECT i.itemnumber, b.title, b.author, i.itemcallnumber, i.barcode, v.lib FROM items i LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) LEFT JOIN authorised_values v ON (i.itemlost=v.authorised_value) WHERE i.itemlost != 0 AND v.category='LOST' However this is a little incomplete, because I need also the information about the *Edition Statement*, *Publisher Name *and the *Date of Publication *to appear in the results. We use Unimarc and the fields I also need to show up in the results are: 205 a (Edition Statement) 210 c (Publisher Name) 210 d (Date of Publication). Can anyone help me with this SQL query? Many thanks in advance Vanda ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Losing access to Koha
Hi everybody! We are using koha version 16.11.04. Since last week we have lost access to koha at least once a day. It shows the following message: *Software error:* DBIx: :Class: : Storage: :DBI: : catch {...} () : DBI Connection failed: Can´t connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /us Compilation failed in require at /usr/share/koha/intranet/cgi-bin/ mainpage.pl line 31. BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/ mainpage.pl line 31 Until last wednesday this has never happened before. And we haven't done anything diferent to cause this problem. Do you have any idea what might be wrong? Has it ever happened to anyone of you? Any help would be very appreciated. Thanks Vanda ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problems with circulation history
Thanks a lot Jonathan, I will give that information to my IT colleagues Regards, Vanda 2018-01-02 14:15 GMT+00:00 Jonathan Druart < jonathan.dru...@bugs.koha-community.org>: > Hi Vanda, > > Yes, it's a known bug. > You should read the following wiki page https://wiki.koha-community. > org/wiki/DBMS_auto_increment_fix,implement the fix and upgrade to a more > recent version. > > Regards, > Jonathan > > On Tue, 2 Jan 2018 at 08:56 vanda koha wrote: > >> Hi everybody! >> >> We are using koha version 16.11.04. >> I´ve recently detected a problem with circulation history. The program >> cheks out and cheks in all items quite well, but it frequently does not >> keep track of all the loans. After checking in a book when I run the >> report >> to see what was checked in the book does not appear in the results and >> when >> I check the patron circulation history it shows no loans (It shows: "This >> patron has no circulation history"). When we look in to the checkout >> history of the item it says the book has never been checked out before. >> It is as if the item had never been checked out. To make it even more >> strange let me tell you that this happens in a regular basis, but not >> everytime. I was not able to understand why this only happens every now >> and >> then. What do you think might be the problem? How can we solve it? >> Has it ever happened to anyone of you? >> Any help would be very welcomed. >> >> Thanks >> >> Vanda >> ___ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Problems with circulation history
Hi everybody! We are using koha version 16.11.04. I´ve recently detected a problem with circulation history. The program cheks out and cheks in all items quite well, but it frequently does not keep track of all the loans. After checking in a book when I run the report to see what was checked in the book does not appear in the results and when I check the patron circulation history it shows no loans (It shows: "This patron has no circulation history"). When we look in to the checkout history of the item it says the book has never been checked out before. It is as if the item had never been checked out. To make it even more strange let me tell you that this happens in a regular basis, but not everytime. I was not able to understand why this only happens every now and then. What do you think might be the problem? How can we solve it? Has it ever happened to anyone of you? Any help would be very welcomed. Thanks Vanda ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problems with the renewals
Hello Bob, Thanks for your help! It was, indeed, a problem in my circulation rules. It was such a simple thing but it was causing a lot of problems... Thank you once again. Vanda 2017-11-24 0:46 GMT+00:00 Bob Birchall : > The problem is almost certainly in your circulation rules. For the precise > library/borrower/item type combination, are renewals allowed and if so what > period is specified? > > Always remember that Koha applies the rules from the most specific to the > most general. So look for 'hidden' exceptions. For example, sometimes rules > exist for a specific library but you may be examining the 'all libraries' > rules. > > I hope this helps, > Bob Birchall > Calyx > > > On 24/11/17 01:24, vanda koha wrote: > >> 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 >> ___ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Problems with the renewals
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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Help - Patrons Deletions- best practice
Hi Satish, I have worked in a College library and we have never erased the patrons from our databese: we just blocked the students access when they finished their course. As simple as that. I think that's the best policy. Imagnie that later on they decide to attend another course: you'll just have to enable them/give them access to circulation, you do not have to register them all over again. Besides, at any moment you may want to extract some statistics from your database, and those patrons whether they have finissed their course or not are part of your library history. Best regards Vanda 2017-03-21 7:35 GMT+00:00 SATISH : > Hi, > > Your answers will be highly appreciated. Kindly share your best practices. > > On 17 March 2017 at 12:41, SATISH wrote: > > > Hi, > > > > Currently With Koha 16.5/Package Installation/ Ubuntu 14.04 Desktop / > > > > Since last six months I am using Koha (production / live) in the > Library. > > Now, one batch of students are going to complete their course on coming > > May 2017. > > I have to stop/ block such students' access for circulation facility. > > (anyhow, expiration date exist for the batch) > > > > What are the standard procedures across the libraries following .. > > > > 1. Do you delete the patrons when students complete their course ? > > > > 2. If retained, what could be the problems? / Or Should not be deleted? > > > > 3. If some verification needed in circulation history, will it be > > available in future as well? > > > > 4. Or any other best practice with patron management that you follow, > > kindly share ? > > > > > > > > With Thanks > > Satish MV > > Librarian > > Govt. Engineering College, Hassan > > Karnataka > > > > > > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] SQL Report: List of all authority records created
Hi Jane and Stefano, Many thanks for your help! It is exactly what I was looking for ;). Best regards, Vanda 2017-03-09 2:29 GMT+00:00 Jane Cothron : > Here's one that we got from ByWater: > select authid, datecreated, > ExtractValue( marcxml, '//datafield[@tag="100"]/*') AS Personal_Name, > ExtractValue( marcxml, '//datafield[@tag="110"]/*') AS Corporate_Name, > ExtractValue( marcxml, '//datafield[@tag="111"]/*') AS Conference_Name, > ExtractValue( marcxml, '//datafield[@tag="130"]/*') AS Uniform_Title > FROM auth_header > WHERE date(datecreated) BETWEEN <> AND < (-mm-dd)>> ORDER by authid > > On Wed, Mar 8, 2017 at 6:17 AM, vanda koha wrote: > >> Hi everybody, >> >> Does anyone know how to do a SQL Report in order to get a list of all the >> authority records we have already created in a period of time? And can we >> sort >> it by alphabetical order? >> >> Many thanks. >> >> Vanda >> ___ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > > > > -- > Jane Cothron > Cataloger > Lincoln County Library District > P.O. Box 2027 > Newport, Oregon 97365 > 541-265-3066 <(541)%20265-3066> (phone & fax) > jcoth...@lincolncolibrarydist.org > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] SQL Report: List of all authority records created
Hi everybody, Does anyone know how to do a SQL Report in order to get a list of all the authority records we have already created in a period of time? And can we sort it by alphabetical order? Many thanks. Vanda ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Where can we find e-mail notices ready to be sent
François, Mercy beaucoup! Thanks! I had already set everything in Tools > Overdue notices/status trigger. Maybe as you wrote, it has something to do with the cronjobs on our server. I will ask my computer colleagues to see if that is the case. Best regards, Vanda 2017-03-08 12:37 GMT+00:00 Francois Charbonnier < francois.charbonn...@inlibro.com>: > Hi Vanda, > > If you haven't found what you were looking for yet, have a look under > "Tools > Notices & slips". You'll also want to look at "Tools > Overdue > notices/status trigger". You may have to set up a couple of cronjobs on > your server as well (overdue_notices.pl, advance_notices.pl, > gather_print_notices.pl, process_message_queue.pl). They are under [your > installation]/misc/cronjobs on your server. > > For more information, the documentation is a good entry point : > https://koha-community.org/manual/16.11/html/ch03.html#notices > > Hope this helps! > > Cheers!! > > François Charbonnier, > Bibl. prof. / Chef de produits > > Tél. : (888) 604-2627 > francois.charbonn...@inlibro.com <mailto:francois.charbonn...@inlibro.com> > > inLibro | Spécialistes en technologies documentaires | www.inLibro.com < > http://www.inLibro.com> > > Le 2017-03-03 à 07:24, vanda koha a écrit : > >> Hi everybody, >> >> I have properly set the circulation rules, the item circulation alerts, >> defined e-mail notices and set notice/status triggers for overdue items. >> But now I have a doubt: where can I find the list of all notices >> (specially >> overdue notices, but also renewals, holds ready to be picked up, etc) that >> are ready to be sent to our users? I know some users have overdues, but I >> don't know where to look for the notices. Can anyone help me, please? >> Many thanks, >> >> Vanda >> ___ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] is koha right for our project run by volunteers?
Hello Rebecca, I work in a small library in a govermental institution, and we have adopted just now Koha. I must say that once it is implemented it is very easy to work with. The most difficult part is that you really need to have someone with very good knowledge of Linux language, otherwise you won't be able to make it work. My computer collegues installed the program, but it wasn't very easy for them to do so. We had some problems with the advanced search and authorities. They had to reinstall the program to make it function, and even now I am not able to send emails to users through koha. They haven't figured that out yet, and they have computer experience. You must also keep in mind that in Koha everything must be set by you, from MARC bibliographic framework to Patron categories, Item types, and so on. It is a huge project, believe me, I know, I have done all that. That being said, I think it is a good choice because it is user friendly. Wishing you all the best Vanda 2017-03-07 14:29 GMT+00:00 Rebecca Shtasel : > Hello > > We are a small group of volunteers (one of whom is a retired school > librarian) who run our synagogue's library in the UK. We would like to > produce an online catalogue and are interesting in using Koha for this > purpose as we haven't much money. The library has about 4000 books > covering a variety of classifications (fiction, history etc) all related to > Judaism. The original accessions book was lost when the library had to be > moved a year ago and we have a notebook with handwritten entries for the > accessions we have received since the library moved to its new home. > Looking at the information to do with koha it appears very technical and we > are wondering if we will be able to use it for our catalogue. We would > literally be taking books off the shelves to input their information, not > importing the data from elsewhere and none of us has anything more than > basic computing knowledge. > > Given this, do you think koha is too complicated for us to use or amongst > all the information related to using koha is there a very basic guide that > would suit beginners like us? > If you think we would struggle using koha, could you advise us on software > that you think would be more user-friendly and is not too expensive? > > Thanking you all very much in advance for any advice you can give. > > Rebecca (on behalf of the group) > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Where can we find e-mail notices ready to be sent
Hi everybody, I have properly set the circulation rules, the item circulation alerts, defined e-mail notices and set notice/status triggers for overdue items. But now I have a doubt: where can I find the list of all notices (specially overdue notices, but also renewals, holds ready to be picked up, etc) that are ready to be sent to our users? I know some users have overdues, but I don't know where to look for the notices. Can anyone help me, please? Many thanks, Vanda ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days
Jessica and Liz, Thanks a lot :) That's exactly what I was looking for. It was a great help! Regards, Vanda 2017-03-01 16:53 GMT+00:00 Tobin, Jessica L : > Hi Vanda, > We run this report daily to keep up with holds that are languishing > on the pick-up shelves for too long: > > > SELECT biblio.title AS 'title', p.surname, p.firstname AS 'first name', > p.email, p.cardnumber AS 'patron barcode', h.waitingdate AS 'hold available > date', i.barcode AS 'item barcode' > FROM reserves h > LEFT JOIN borrowers p USING (borrowernumber) > LEFT JOIN items i ON (h.biblionumber=i.biblionumber) > LEFT JOIN biblio ON (i.biblionumber=biblio.biblionumber) > WHERE date (h.waitingdate) = DATE_SUB(CURRENT_DATE(),INTERVAL 7 DAY) OR > date (h.waitingdate) = DATE_SUB(CURRENT_DATE(),INTERVAL 14 DAY) > ORDER BY h.waitingdate > > > It shows the date that the hold became available. Also, it gives us a > heads-up on holds that have been available for either 7 or 14 days, but you > could remove the OR statement to just show 7 day-old holds. > > Hope this helps! :) > Jess > > Jessica L. Tobin > Technical Services & Systems Librarian > Arnold Library > Office 206.667.6846 > Library Main 206.667.4314 > jto...@fredhutch.org > > Fred Hutchinson Cancer Research Center > 1100 Fairview Ave. N., Mail Stop B1-010 > Seattle, WA 98109 > > FRED HUTCH / CURES START HERE > fredhutch.org<http://www.fredhutch.org/> > > > > > Date: Wed, 1 Mar 2017 10:16:06 + > > From: vanda koha mailto:vandak...@gmail.com>> > > To: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> > > Subject: [Koha] SQL report for holds waiting for pickup longer than > > the ReservesMaxPickupDelay number of days > > Message-ID: > > gmail.com<mailto:CAOTDiOPtTBs5EXuS7o7cqQp1ioZO_Zv9+ds0eC=N=T > d4say...@mail.gmail.com>> > > Content-Type: text/plain; charset=UTF-8 > > > > Hi everybody, > > > > I would like to run a report that would show me all the users, their > e-mail adresses, titles and barcodes of items whose holds have been > waiting for pickup longer than the ReservesMaxPickupDelay number of days > (in our case 7 days). Can anyone please help me with the SQL Report? It > would be great if the report showed the number of days or the hold > expiration date. > > > > Many thanks, > > > > Vanda > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] SQL report for holds waiting for pickup longer than the ReservesMaxPickupDelay number of days
Hi everybody, I would like to run a report that would show me all the users, their e-mail adresses, titles and barcodes of items whose holds have been waiting for pickup longer than the ReservesMaxPickupDelay number of days (in our case 7 days). Can anyone please help me with the SQL Report? It would be great if the report showed the number of days or the hold expiration date. Many thanks, Vanda ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Search not working
Hi Katrin, Thanks for your tips. We already have done that. It must be something else that we are missing... Regards, Vanda 2017-02-19 22:08 GMT+00:00 Katrin : > Hi Vanda, > > when using UNIMARC you will have to choose it in 2 places, maybe one was > missed? > > Before the instance is created, you need to tell Koha that it will be > using UNIMARC. You can do so by changing ZEBRA_MARC_FORMAT="marc21" in > /etc/koha/koha-sites.conf to "unimarc". This will affect the indexing > configuration and can be the cause of why your search might not work, when > the records itself look correct. > > Then, when running the web installer, you also need to make sure UNIMARC > is selected there. This will affect which cataloguing frameworks (MARC > field and subfield definitions) are installed. > > Hope this helps, > > Katrin > > > On 17.02.2017 13:19, vanda koha wrote: > >> Hello Ian, >> >> We are still unable to solve our problem. We have done everything we were >> told to do, including what you mention in your message. Unfortunately >> nothing worked. >> >> And yes, we chose UNIMARC when the package installation was performed. My >> computer collegues say that we also have some references to MARC21 in >> the the koha-conf.xml file and apparently it is supposed to be that way. >> Still loking for an answer... >> >> Regrads >> >> Vanda >> >> 2017-02-16 19:13 GMT+00:00 i.pr...@zigzagee.com : >> >> Vanda, >>> >>> Just out of interest, did you choose UNIMARC when the package >>> installation >>> was performed ? >>> >>> I did and I'm facing the same search problems as you. I note the >>> koha-conf.xml file seems to >>> have a lot of MARC21 references. Not sure if this needs to change to >>> UNIMARC. This was just the template file that was generated through the >>> installation. >>> >>> I tried the koha-rebuild-zebra -f -a -b -v $instance approach recommended >>> but that didn't >>> fix the search problems. if you want to know where it is just use >>> >which >>> koha-rebuild-zebra >>> >>> Regards, >>> Ian >>> >>> -- >>> >>> >>> Dr. Ian Pratt B.Eng Ph.D C.Eng MIET MIEEE >>> Director - ZigZagee Ltd. >>> Email: i.pr...@zigzagee.com >>> Landline: + 44 (0) 1509 276251 >>> Mobile: + 44 (0) 7796331815 >>> Web: www.zigzagee.com >>> >>> >>> >>> ___ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Search not working
Hello Ian, We are still unable to solve our problem. We have done everything we were told to do, including what you mention in your message. Unfortunately nothing worked. And yes, we chose UNIMARC when the package installation was performed. My computer collegues say that we also have some references to MARC21 in the the koha-conf.xml file and apparently it is supposed to be that way. Still loking for an answer... Regrads Vanda 2017-02-16 19:13 GMT+00:00 i.pr...@zigzagee.com : > Vanda, > > Just out of interest, did you choose UNIMARC when the package installation > was performed ? > > I did and I'm facing the same search problems as you. I note the > koha-conf.xml file seems to > have a lot of MARC21 references. Not sure if this needs to change to > UNIMARC. This was just the template file that was generated through the > installation. > > I tried the koha-rebuild-zebra -f -a -b -v $instance approach recommended > but that didn't > fix the search problems. if you want to know where it is just use >which > koha-rebuild-zebra > > Regards, > Ian > > -- > > > Dr. Ian Pratt B.Eng Ph.D C.Eng MIET MIEEE > Director - ZigZagee Ltd. > Email: i.pr...@zigzagee.com > Landline: + 44 (0) 1509 276251 > Mobile: + 44 (0) 7796331815 > Web: www.zigzagee.com > > > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Fwd: Fwd: No results with the advanced search
Thank you very much Jonathan. Vanda 2017-02-09 12:38 GMT+00:00 Jonathan Druart < jonathan.dru...@bugs.koha-community.org>: > Hi Vanda, > > The item search is not using Zebra but requests the database directly. > You should fully rebuild your zebra index using `rebuild-zebra.pl -f -a -b > -v` > > Regards, > Jonathan > > On Thu, 9 Feb 2017 at 13:16 vanda koha wrote: > > > -- Forwarded message -- > > From: vanda koha > > Date: 2017-02-09 10:58 GMT+00:00 > > Subject: Re: [Koha] No results with the advanced search > > To: Chris Cormack > > > > > > Hi Chris, > > > > I was informed by my computer colleagues that the installation was done > via > > packages. And Zebra seems to be running fine... > > The strange thing is that when we use itemsearch we get the results: the > > records appear just fine. But the advanced search isn't working at all. > > > > Vanda > > > > 2017-02-08 19:32 GMT+00:00 Chris Cormack : > > > > > > > > > > > On 09/02/17 02:39, vanda koha wrote: > > > > Hi everybody, > > > > > > > > I'm working in a small library and we have installed koha version > > > 16.11.03, > > > > but we are having some problems with the search. > > > > We only recover information when we use the itemsearch. Whenever we > use > > > the > > > > advanced search we get no results at all, regardless the term we use > > > > (title, author, subject, keyword, etc). > > > > The message we get is this: No results found > > > > > > > > No results match your search for 'ti,wrdl: manual' in Biblioteca > > catalog. > > > > > > > > What are we doing wrong? Can anyone please help us? > > > > > > How did you install Koha, via the packages or via the tarball? > > > > > > It sounds like zebra either isn't running, or you haven't indexed your > > > collection. How to do this depends on how you installed Koha though > > > > > > Chris > > > > > > > > > > > Many thanks in advance, > > > > > > > > Vanda > > > > ___ > > > > Koha mailing list http://koha-community.org > > > > Koha@lists.katipo.co.nz > > > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > > > > > > > ___ > > > Koha mailing list http://koha-community.org > > > Koha@lists.katipo.co.nz > > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > > ___ > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Fwd: No results with the advanced search
-- Forwarded message -- From: vanda koha Date: 2017-02-09 10:58 GMT+00:00 Subject: Re: [Koha] No results with the advanced search To: Chris Cormack Hi Chris, I was informed by my computer colleagues that the installation was done via packages. And Zebra seems to be running fine... The strange thing is that when we use itemsearch we get the results: the records appear just fine. But the advanced search isn't working at all. Vanda 2017-02-08 19:32 GMT+00:00 Chris Cormack : > > > On 09/02/17 02:39, vanda koha wrote: > > Hi everybody, > > > > I'm working in a small library and we have installed koha version > 16.11.03, > > but we are having some problems with the search. > > We only recover information when we use the itemsearch. Whenever we use > the > > advanced search we get no results at all, regardless the term we use > > (title, author, subject, keyword, etc). > > The message we get is this: No results found > > > > No results match your search for 'ti,wrdl: manual' in Biblioteca catalog. > > > > What are we doing wrong? Can anyone please help us? > > How did you install Koha, via the packages or via the tarball? > > It sounds like zebra either isn't running, or you haven't indexed your > collection. How to do this depends on how you installed Koha though > > Chris > > > > > Many thanks in advance, > > > > Vanda > > ___ > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] No results with the advanced search
Hi everybody, I'm working in a small library and we have installed koha version 16.11.03, but we are having some problems with the search. We only recover information when we use the itemsearch. Whenever we use the advanced search we get no results at all, regardless the term we use (title, author, subject, keyword, etc). The message we get is this: No results found No results match your search for 'ti,wrdl: manual' in Biblioteca catalog. What are we doing wrong? Can anyone please help us? Many thanks in advance, Vanda ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha