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@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-request@lists.katipo.co.nz

You can reach the person managing the list at koha-owner@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@gmail.com> To: koha@lists.katipo.co.nz Subject: [Koha] email status changes to "failed". Message-ID: <CACtqtZFo8qrA-M2h8ZvfR3aq4icv8JMXTYQmnrc7xJccm7OgTA@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@cca.edu> To: prachim <prachi.m@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=uaae1onJ2w9g4Q@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@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" <KREICHERT@bridgew.edu> To: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> Subject: [Koha] MARC field and heading validation with Koha Message-ID: <SN1PR0801MB166447966C6028280A21A182B53C0@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@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@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+d5PA@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@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-d345d56d29cd@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.83@web.de> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Please help this newbie :) Message-ID: <77ccb1ec-43f9-aca0-f7e0-983aadfc0056@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.83@web.de> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Tag 082, itemcallnumber Message-ID: <e501e045-0ba3-ec8e-6a10-5d8580e37e74@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 ************************************