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-requ...@lists.katipo.co.nz> wrote: > Send Koha mailing list submissions to > koha@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-requ...@lists.katipo.co.nz > > You can reach the person managing the list at > koha-ow...@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.p...@gmail.com> > To: koha@lists.katipo.co.nz > Subject: [Koha] email status changes to "failed". > Message-ID: > <cactqtzfo8qra-m2h8zvfr3aq4icv8jmxtyqmnrc7xjccm7o...@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 <ephettepl...@cca.edu> > To: prachim <prach...@nextremer.com> > Cc: Koha <koha@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=uaae1onj2w9...@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 <prach...@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@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" <kreich...@bridgew.edu> > To: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> > Subject: [Koha] MARC field and heading validation with Koha > Message-ID: > <sn1pr0801mb166447966c6028280a21a182b5...@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.reich...@bridgew.edu<mailto:kreich...@bridgew.edu> > > 508-531-2665 > > > ------------------------------ > > Message: 4 > Date: Mon, 4 Dec 2017 15:03:24 -0500 > From: Alvaro Cornejo <cornejo.alv...@gmail.com> > To: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> > Subject: [Koha] Look for records with specific info in a mark field > Message-ID: > <CAO55aG--BCg84v8Ua2umNDJuK_8=E2=_tcav2tybv1rwk+d...@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...@web.de> > To: koha@lists.katipo.co.nz > Subject: Re: [Koha] Look for records with specific info in a mark > field > Message-ID: <b08151a8-5d42-4522-557e-d345d56d2...@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@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...@web.de> > To: koha@lists.katipo.co.nz > Subject: Re: [Koha] Please help this newbie :) > Message-ID: <77ccb1ec-43f9-aca0-f7e0-983aadfc0...@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@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...@web.de> > To: koha@lists.katipo.co.nz > Subject: Re: [Koha] Tag 082, itemcallnumber > Message-ID: <e501e045-0ba3-ec8e-6a10-5d8580e37...@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@lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Koha mailing list > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > > > ------------------------------ > > End of Koha Digest, Vol 146, Issue 8 > ************************************ > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha