- Koha - lists.katipo.co.nz

Error when reading (or clicking) on message at the main menu
by Luis Moises Rojas 06 Dec '17

06 Dec '17

When we try to reading the message at the botton on the main menu: DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.discharge_id' in 'field list' at /usr/share/koha/lib/Koha/Patron/Discharge.pm line 165 Thanks -- *Luis Moisés Rojas P.* <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> Libre de virus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

2 1

where to set Refund lost item fee
by Admire Mutsikiwa 06 Dec '17

06 Dec '17

Hi I would like to enquire as to where the Refund Lot Item fee is configured. 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>

3 2

Can't run auth_show_hidden_data.pl script
by Prof. Lisandro Laura 06 Dec '17

06 Dec '17

Hi everyone! I was upgrading from 17.05.04 to 17.05.06 and the following showed up: "Bug 18811 fixed an inconsistency in the visibility settings for authority frameworks. It is recommended that you run script misc/maintenance/auth_show_hidden_data.pl to check if you have data in hidden fields and adjust your frameworks accordingly to prevent data loss when editing such records" I was traying to run the script: perl ./usr/share/koha/bin/maintenance/auth_show_hidden_data.pl But I get the following error: "Can't locate Koha/Authorities.pm in @INC (you may need to install the Koha::Authorities module) (@INC contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2 /usr/lib/x86_64-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20 /usr/share/perl/5.20 /usr/local/lib/site_perl .) at ./usr/share/koha/bin/maintenance/auth_show_hidden_data.pl line 28. BEGIN failed--compilation aborted at ./usr/share/koha/bin/maintenance/auth_show_hidden_data.pl line 28." What can I do? Thank you in advance, Lisandro

2 2

MARC field and heading validation with Koha
by Reichert, Kumiko 06 Dec '17

06 Dec '17

Hello all, I apologize for cross-posting. My library's Koha will go live next month, and I am now in training. I hope you don't mind questions from a newbie. How do you validate MARC fields and headings/access points based on the local authority database (1XX, 6XX, 7XX and 8XX) with Koha? If Koha does not have the functionality, how do you manage validation? Sincerely yours, Kumiko Kumiko Reichert Metadata and Cataloging Librarian Maxwell Library Bridgewater State University 10 Shaw Road Bridgewater, MA 02325 kumiko.reichert(a)bridgew.edu<mailto:kreichert@bridgew.edu> 508-531-2665

2 1

Look for records with specific info in a mark field
by Alvaro Cornejo 06 Dec '17

06 Dec '17

Hi How can I do a MySQL search for all the records/items with an specific value in an specific marc field Xx? I've looked at the bilblio and related tables but I'm unable to find a table with marcs fields info. I saw some marcxml fields however; are marc values stored there and I need to xlmparse that info to get an specific value? Regards Alvaro

3 2

Configuring smtp mail server to work with Koha
by Javed Sahil 06 Dec '17

06 Dec '17

Hi Pedro, I am facing a problem with koha notifications similar to that you had been facing in the past, your message details at the end of this email. When I use following commands. 1. koha-shell library 2. export PERL5LIB="/usr/share/koha/lib" 3. export KOHA_CONF="/etc/koha/sites/library/koha-conf.xml" 4. cd /usr/share/koha/bin/cronjobs above all go fine, but when i use following command: 5. ./process_message_queue.pl this error message appears: connect to localhost failed (Connection refused) connect to localhost failed connect to localhost failed (Connection refused) no (more) retries! at ./process_message_queue.pl line 66. Then in patron accounts, email status changes to "failed". Help Plz. Below is your problem detail. Hello, I have solved the problem: Sendmail.pm needs to have smtp => 'localhost' and port => 25 and the e-mail notifications are now working. Thank you, Pedro Amorim 2015-10-30 14:23 GMT-01:00 Pedro Amorim <pjamorim91 at gmail.com>: > Hello Galen, > > Thank you for your reply. > I have changed the Sendmail.pm file to point to smtp.gmail.com instead of > localhost and am now receiving these errors: > > # koha-foreach --enabled --email /usr/share/koha/bin/cronjobs/ > process_message_queue.pl -v > koha: sending email message to patron: Admin at > /usr/share/koha/lib/C4/Letters.pm line 937. > koha: MAIL FROM: error (530 5.7.0 Must issue a STARTTLS command first. > uj4sm7521289wjc.34 - gsmtp > koha: ) > koha: Server said: 530 5.7.0 Must issue a STARTTLS command first. > uj4sm7521289wjc.34 - gsmtp > koha: at /usr/share/koha/bin/cronjobs/process_message_queue.pl line 66 > > I do not know much about configuring mail servers, should I keep the > Sendmail.pm file pointing to localhost and postfix takes care of the > redirecting? > > Thanks again, > > Pedro Amorim -- 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

2 2

Invitation for Libraries using Koha to participate in the 2017 Library Automation Perceptions survey
by Marshall Breeding 06 Dec '17

06 Dec '17

To all libraries using Koha: I'm collecting data for the 2017 International Library Automation Perceptions survey. This survey, now in its eleventh annual iteration, provides an opportunity for libraries to register their perceptions of the strategic automation products they use, organizations that provide these products, and the quality of support delivered. The survey also probes at considerations for migrating to new systems and the level of interest in open source products. As open source software supported both by the general community and by a variety of different service firms, some special considerations apply to Koha. In the libraries.org directory, Koha is represented by a combination of the name Koha and the primary support organization involved. (For example Koha - Catalyst IT, Koha -- ByWater Solutions). Libraries relying entirely on community support or internal resources are represented as Koha - Independent. If there are any special support arrangements not covered by these conventions, just mention that in the comments area of the survey. In this way the survey will be able to reflect both the functionality of the Koha software and the quality of support provided. This model of representing libraries using Koha isn't ideal, but is a pragmatic approach that aggregates all users of Koha while also segregating the different support scenarios. While the numeric rating scales support the statistical results of the study, it's the comments offered that provide the most insight into the current state of library automation satisfaction. Comments will be published in the survey results, redacted to conceal text that might identify the individual or organization responding. The raw data for the survey will not be shared, but reports are available that provide a variety of ways to view results. Please help your fellow librarians who might be in the process of evaluating library automation options by responding to the survey. Any information regarding vendor performance and product quality can be helpful when making strategic decisions regarding automation alternatives. A large number of responses strengthen the impact of the survey and the subsequent report. If you have responded in previous years, please respond again this year to help identify any trends regarding improvement or worsening of the products or support services. For more information about the survey, for instructions on how to participate, and to see results of previous year's survey reports, see: http://librarytechnology.org/web/breeding/AutomationSurvey/ I hope that all libraries using Koha will respond. Feel free to forward this request to any other library-related list. Please let me know if there are any questions regarding the survey. Marshall Breeding Editor, Library Technology Guides www.librarytechnology.org Marshall.breeding(a)librarytechnology.org twitter.com/mbreeding _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Please help this newbie :)
by Johan Seyfferdt 06 Dec '17

06 Dec '17

Hello. Thank you for adding me to this mailing list. I have a question. I am a sysadmin in St Petersburg, Russia and we are in the process of moving to Koha. So I am a newbie :) I chosed the unimarc option as our database is in rusmarc. We have our database in .mrc format, it is about 27 000 books in cyrilic, english and german. I was able to setup koha import that database but the search function does not work. I did a lot of googling, i tried kooha 16.05, 16.11, 17.05 on Debain 8 and 9 but without avail... Any help will be truly appreciated! as i am truly stuck.

4 7

Re: [Koha] koha tag 082, itemcallnumber
by Javed Sahil 06 Dec '17

06 Dec '17

Hi Katrin, Only you have diagnosed my problem, *Bug 9156* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9156> - itemcallnumber not pulling more than 2 subfields Can you help and guide me how it can be fixed/changed in the code?? Javed On Dec 5, 2017 1:26 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. email status changes to "failed". (Javed Sahil) > 2. Re: Does Koha has a web service API or search API for > searching books on different input parameters (Eric Phetteplace) > 3. MARC field and heading validation with Koha (Reichert, Kumiko) > 4. Look for records with specific info in a mark field > (Alvaro Cornejo) > 5. Re: Look for records with specific info in a mark field > (Katrin Fischer) > 6. Re: Please help this newbie :) (Katrin Fischer) > 7. Re: Tag 082, itemcallnumber (Katrin Fischer) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 4 Dec 2017 19:56:37 +0500 > From: Javed Sahil <sahil.ke.paas(a)gmail.com> > To: koha(a)lists.katipo.co.nz > Subject: [Koha] email status changes to "failed". > Message-ID: > <CACtqtZFo8qrA-M2h8ZvfR3aq4icv8JMXTYQmnrc7xJccm7OgTA(a)mail.gm > ail.com> > Content-Type: text/plain; charset="UTF-8" > > Hello everyone! > I want koha to send emails to patrons for circulation transactions > like check out, check in, overdue etc. I have installed postfix. > Everything is set I can send emails from commands line. > > but in patron accounts email status is "pending". > > When I use following commands. > > 1. koha-shell library > 2. export PERL5LIB="/usr/share/koha/lib" > 3. export KOHA_CONF="/etc/koha/sites/library/koha-conf.xml" > 4. cd /usr/share/koha/bin/cronjobs > > above all go fine, but when i use following command: > > 5. ./process_message_queue.pl > > this error message appears: > > connect to localhost failed (Connection refused) > connect to localhost failed > connect to localhost failed (Connection refused) no (more) retries! > at ./process_message_queue.pl line 66. > > > Then in patron accounts, email status changes to "failed". > > Help Plz. > > > ------------------------------ > > Message: 2 > Date: Mon, 4 Dec 2017 09:45:19 -0800 > From: Eric Phetteplace <ephetteplace(a)cca.edu> > To: prachim <prachi.m(a)nextremer.com> > Cc: Koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Does Koha has a web service API or search API for > searching books on different input parameters > Message-ID: > <CACSkZcZZx7CBy=z=ZmKbu3FWVUnBn0=LGm1=uaae1onJ2w9g4Q(a)mail.gm > ail.com> > Content-Type: text/plain; charset="UTF-8" > > Hi Prachi, > > Koha's SRU protocol implementation is probably the closest thing to a > search API: > https://koha-community.org/manual/17.05/html/18_miscellaneou > s.html#using-the-sru-server > > That manual page also describes other web services that Koha provides but > none are specifically search. Is there a reason why searching on the Koha > website couldn't fulfill your client's needs? I must admit I don't really > see the value in designing an app to accomplish something that the website > already does. > > Best, > > ERIC PHETTEPLACE > > Systems Librarian > > > libraries.cca.edu | vault.cca.edu | 510.594.3660 > > 5212 Broadway, Oakland, CA 94618 > > 1111 8th St., San Francisco, CA 94107 > > Preferred Pronoun(s): he/him > > :(){ :|: & };: > > On Sun, Dec 3, 2017 at 5:38 AM, prachim <prachi.m(a)nextremer.com> wrote: > > > Hi, > > > > One of our client is a college. They are already using Koha for their > > library management. > > We are developing an android application for their students using which > > they > > can search for a book in first phase. This android app will send user > > queries to our back-end server, the back-end is developed in Java. > > We are expected to take input criteria specified by student (e.g.title, > > author, publisher etc.) and search for the book and its availability. > > So is there any web service API or search API by Koha for searching books > > on > > different input parameters? > > What kind of authentication need to be provided to access data specific > to > > this college? > > > > > > > > -- > > Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 3 > Date: Mon, 4 Dec 2017 19:43:50 +0000 > From: "Reichert, Kumiko" <KREICHERT(a)bridgew.edu> > To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: [Koha] MARC field and heading validation with Koha > Message-ID: > <SN1PR0801MB166447966C6028280A21A182B53C0(a)SN1PR0801MB1664.na > mprd08.prod.outlook.com> > > Content-Type: text/plain; charset="iso-8859-1" > > Hello all, > > > I apologize for cross-posting. My library's Koha will go live next month, > and I am now in training. I hope you don't mind questions from a newbie. > > > How do you validate MARC fields and headings/access points based on the > local authority database (1XX, 6XX, 7XX and 8XX) with Koha? If Koha does > not have the functionality, how do you manage validation? > > > Sincerely yours, > > Kumiko > > > Kumiko Reichert > > Metadata and Cataloging Librarian > > Maxwell Library > > Bridgewater State University > > 10 Shaw Road > > Bridgewater, MA 02325 > > kumiko.reichert(a)bridgew.edu<mailto:kreichert@bridgew.edu> > > 508-531-2665 > > > ------------------------------ > > Message: 4 > Date: Mon, 4 Dec 2017 15:03:24 -0500 > From: Alvaro Cornejo <cornejo.alvaro(a)gmail.com> > To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: [Koha] Look for records with specific info in a mark field > Message-ID: > <CAO55aG--BCg84v8Ua2umNDJuK_8=E2=_TCAv2tyBv1rWK+d5PA(a)mail.gm > ail.com> > Content-Type: text/plain; charset="UTF-8" > > Hi > > How can I do a MySQL search for all the records/items with an specific > value in an specific marc field Xx? > > I've looked at the bilblio and related tables but I'm unable to find a > table with marcs fields info. I saw some marcxml fields however; are marc > values stored there and I need to xlmparse that info to get an specific > value? > > Regards > > Alvaro > > > ------------------------------ > > Message: 5 > Date: Mon, 4 Dec 2017 21:16:51 +0100 > From: Katrin Fischer <katrin.fischer.83(a)web.de> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Look for records with specific info in a mark > field > Message-ID: <b08151a8-5d42-4522-557e-d345d56d29cd(a)web.de> > Content-Type: text/plain; charset=utf-8; format=flowed > > Hi Alvaro, > > yes, Koha stores the complete record as MARCXML and only some fields are > mapped to database columns. You can see the mappings in Administration > > Koha to MARC mappings. Be careful, after changing it you need to run a > script to populate database fields correctly. The MARC record is stored > in either biblioitems.marcxml (older versions) or > biblio_metadata.metadata (current versions) and can be queried using the > ExtractValue function. You can find examples in the reports library on > the wiki: > > https://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC > > Hope this helps, > > Katrin > > > On 04.12.2017 21:03, Alvaro Cornejo wrote: > > Hi > > > > How can I do a MySQL search for all the records/items with an specific > > value in an specific marc field Xx? > > > > I've looked at the bilblio and related tables but I'm unable to find a > > table with marcs fields info. I saw some marcxml fields however; are marc > > values stored there and I need to xlmparse that info to get an specific > > value? > > > > Regards > > > > Alvaro > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > ------------------------------ > > Message: 6 > Date: Mon, 4 Dec 2017 21:20:51 +0100 > From: Katrin Fischer <katrin.fischer.83(a)web.de> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Please help this newbie :) > Message-ID: <77ccb1ec-43f9-aca0-f7e0-983aadfc0056(a)web.de> > Content-Type: text/plain; charset=utf-8; format=flowed > > Hi Johan, > > with the default configuration Koha won't search for records with > non-latin characters correctly, but this can be fixed - you will have to > switch to ICU for indexing. Instructions can be found on the wiki: > > https://wiki.koha-community.org/wiki/ICU_chains_configuration > > If it doesn't work at all, even for your German and English records, > there might be another problem. Did you specify UNIMARC when creating > the instance (defaults to MARC21)? Or only in the web installer? If the > first was missed, your indexing configuration won't match your data > which could also explain problems. > > Hope this helps, > > Katrin > > > On 04.12.2017 09:35, Johan Seyfferdt wrote: > > Hello. > > > > Thank you for adding me to this mailing list. > > > > I have a question. > > > > I am a sysadmin in St Petersburg, Russia and we are in the process of > > moving to Koha. So I am a newbie :) > > > > I chosed the unimarc option as our database is in rusmarc. We have our > > database in .mrc format, it is about 27 000 books in cyrilic, english > and > > german. > > > > I was able to setup koha import that database but the search function > does > > not work. > > > > I did a lot of googling, i tried kooha 16.05, 16.11, 17.05 on Debain 8 > and > > 9 but without avail... > > > > Any help will be truly appreciated! as i am truly stuck. > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > ------------------------------ > > Message: 7 > Date: Mon, 4 Dec 2017 21:25:40 +0100 > From: Katrin Fischer <katrin.fischer.83(a)web.de> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Tag 082, itemcallnumber > Message-ID: <e501e045-0ba3-ec8e-6a10-5d8580e37e74(a)web.de> > Content-Type: text/plain; charset=utf-8; format=flowed > > Hi Javed, > > I think you have run into an old bug: > > *Bug 9156* > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9156> - > itemcallnumber not pulling more than 2 subfields > > There is nothing you can do with configuration, this has to be > fixed/changed in the code. > > Katrin > > > On 04.12.2017 13:26, Javed Sahil wrote: > > Hi all, > > > > In koha preferences, > > > > itemcallnumber: 082ab works fine. > > > > itemcallnumber: 082cd also works fine. > > > > > > itemcallnumber: 082abcd does not work. > > > > Only first two subfields work with 082 tag. > > > > I wan to use four subfields abcd, > > How it will be possible? > > _______________________________________________ > > 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 146, Issue 8 > ************************************ >

2 2

Re: [Koha] Postfix, gmail, email status failed
by Javed Sahil 05 Dec '17

05 Dec '17

Anybody help plz...... On Tue, Dec 5, 2017 at 7:27 PM, Paul Hoffman <paul(a)flo.org> wrote: > Javed, > > That's strange; Postfix is listening on port 25 but the script you're > running seems to be saying that it isn't. I wonder if there's something > in your system logs that might help (/var/log/*). > > I suggest you resend your reply to the list -- perhaps someone else can > help you. It's always a good idea to direct replies to the list, > anyhow. > > Paul. > > On Tue, Dec 05, 2017 at 10:32:03AM +0500, Javed Sahil wrote: > > Thanx for responding Paul, > > > > > > Here are the results of the commands you required: > > > > > > sudo netstat -tnlp | fgrep master > > > > tcp 0 0 0.0.0.0:25 0.0.0.0:* > > LISTEN 2002/master > > tcp6 0 0 :::25 :::* > > LISTEN 2002/master > > > > > > > > sudo uname -a > > > > > > Linux iolhost 4.4.0-72-generic #93-Ubuntu SMP Fri Mar 31 14:07:41 UTC > 2017 > > x86_64 x86_64 x86_64 GNU/Linux > > > > > > Plz help. > > > > > > > > > > -- > > 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 > > -- > Paul Hoffman <paul(a)flo.org> > Software Manager > Fenway Library Organization > 550 Huntington Ave. > Boston, MA 02115 > (617) 442-2384 (FLO main number) > -- 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