- Koha - lists.katipo.co.nz

Re: [Koha] Koha Digest, Vol 146, Issue 14
by Hirak Jyoti Hazarika 06 Dec '17

06 Dec '17

On Dec 6, 2017 9:50 PM, <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. Re: Look for records with specific info in a mark field > (Barton Chittenden) > 2. Re: KOCT 0.4.5 (Tomas Cohen Arazi) > 3. Re: Can't run auth_show_hidden_data.pl script (Mark Alexander) > 4. Re: MARC field and heading validation with Koha > (Hernandez, Heather) > 5. Re: Can't run auth_show_hidden_data.pl script > (Prof. Lisandro Laura) > 6. where to set Refund lost item fee (Admire Mutsikiwa) > 7. Re: where to set Refund lost item fee (Jonathan Druart) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 6 Dec 2017 09:45:07 -0500 > From: Barton Chittenden <barton(a)bywatersolutions.com> > To: Katrin Fischer <Katrin.Fischer.83(a)web.de> > Cc: koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Look for records with specific info in a mark > field > Message-ID: > <CAMSJbVuS5HmAKFJib6WzytUNDrvnVaYC14hgpi0N+YroV3iBHQ@mail. > gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Good answer, Katrin! > > On Dec 4, 2017 15:17, "Katrin Fischer" <katrin.fischer.83(a)web.de> wrote: > > > 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 > >> > > > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > ------------------------------ > > Message: 2 > Date: Wed, 06 Dec 2017 14:50:16 +0000 > From: Tomas Cohen Arazi <tomascohen(a)gmail.com> > To: Matthias Meusburger <matthias.meusburger(a)biblibre.com> > Cc: Koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] KOCT 0.4.5 > Message-ID: > <CABZfb=XxrRm68QxTTwXvyMwFkPojqmeuHHzR30JbiRP9Js6tAg@mail. > gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Excelent work, Matthias! > > El mié., 6 dic. 2017 a las 9:27, Matthias Meusburger (< > matthias.meusburger(a)biblibre.com>) escribió: > > > Hi everyone, > > > > We had a "Ship it" day during this Biblibre winter camp, and I chose to > > work on KOCT. > > > > So here's what's new in v0.4.5: > > > > - Add a "configuration test" button which will check if koha host, > > username and password are ok > > > > > > - Retrieve branchnames and branchcodes as a dropdown list > > > > (when https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16497 is > > available, adresses > > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19689 ) > > > > > > - Cleaner error handling > > > > (when https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19752 is > > available) > > > > > > - Add data export in Koc format > > > > (see > > https://wiki.koha-community.org/wiki/Koha_offline_ > circulation_file_format > > ) > > > > > > - Add a button to jump to the configuration page. > > > > > > This new version should be available at Mozilla's in a couple of days. > > > > Enjoy :) > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > -- > Tomás Cohen Arazi > Theke Solutions (https://theke.io <http://theke.io/>) > ✆ +54 9351 3513384 > GPG: B2F3C15F > > > ------------------------------ > > Message: 3 > Date: Wed, 06 Dec 2017 09:51:39 -0500 > From: Mark Alexander <marka(a)pobox.com> > To: Prof. Lisandro Laura <prof.llaura(a)gmail.com> > Cc: koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Can't run auth_show_hidden_data.pl script > Message-ID: <1512571828-sup-6391@t60p> > Content-Type: text/plain; charset=UTF-8 > > Excerpts from Prof. Lisandro Laura's message of 2017-12-06 11:41:57 -0300: > > 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 > > This sounds familiar. Try running the following command first: > > koha-shell LIBRARY > > where LIBRARY is your Koha instance name. After that, the various > Koha shell scripts should work. > > > ------------------------------ > > Message: 4 > Date: Wed, 6 Dec 2017 07:26:01 -0800 > From: "Hernandez, Heather" <heather_hernandez(a)nps.gov> > To: "Reichert, Kumiko" <KREICHERT(a)bridgew.edu> > Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz>, ByWater > Partners <partners(a)bywatersolutions.com> > Subject: Re: [Koha] MARC field and heading validation with Koha > Message-ID: > <CADiPvh=zsi3r-CyFb-En_pk0PMPsbMHbn+wvZtaHTVW4VpH+qA@ > mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Hi, Kumiko-- > > I'm not sure our workflow would be applicable since we're a very > specialized museum library, but maybe you'll get some ideas? > > We lacked a lot of authority capabilities in our previous catalog software > (Athena), so our headings were & are pretty messy. I'm in the middle of a > project to clean up the authority file and then the remaining authority > controlled fields in the bib records. So, that said: > > I catalog on OCLC (Connexion Client) but am experimenting with creating > original records in Koha with the Advanced Editor. I manually search every > single authority controlled field in the Koha authority file, and download > new authority records from OCLC (or for locally created name, series, etc., > records, key them very laboriously into Koha since there's no Advanced > Editor for authority records--I so dearly hope one is developed!). > > If I have reason to substantially edit a bib record, I'll manually search > all the authority controlled fields that lack a $9 authority record link--I > have to do this manually because our Koha installation doesn't validate any > headings that have subfields that are not present in an authority > record--that is, only authority-controlled bib fields that match every, > single subfield in the authority record will validate & link. So, e.g., in > our catalog, this heading in a bib record will validate & link to an > authority record (which one can see with the $9): > 650 _ 0 $a Women sailors. $9 17788 > > But this heading will not validate & link (so lacks the $9), because > authority records are not created with headings with free-floating > subdivisions such as "$v Fiction:" > 650 _ 0 ‡aWomen sailors‡vFiction. > > So with us, authority control is still a human function. We thought > briefly about using a vendor for the initial cleanup (I've had this done at > previous jobs & it's worked very well), but we lack the funds for such a > project. > > One feature that is beautiful is that *if* headings are linked to an > authority record, once the authority record is edited or overlaid with a > newer imported version, the linked headings are pretty instantly changed. > Then it's just a matter of some searching & manual editing to update the > headings that aren't linked because they have, e.g., free-floating > subdivisions. Or typos...sigh...:) > > Our catalog is hosted and supported by ByWater & we've chatted a bit about > how we might experiment with some changes that might improve heading > linking, but haven't yet got beyond that--we have yet to upgrade beyond > 17.05, so have yet to implement ElasticSearch which, I imagine, might > impact indexing/linking. > > Hope this is helpful! Cheerio, > h2 > ~~~~~~~~~~~~~~ > Heather Hernandez > Technical Services Librarian > San Francisco Maritime National Historical Park Research Center > 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 > 415-561-7032, heather_hernandez(a)nps.gov > https://www.nps.gov/safr/learn/historyculture/research-center.htm > > > ------------------------------ > > Message: 5 > Date: Wed, 6 Dec 2017 12:51:12 -0300 > From: "Prof. Lisandro Laura" <prof.llaura(a)gmail.com> > To: Mark Alexander <marka(a)pobox.com> > Cc: koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Can't run auth_show_hidden_data.pl script > Message-ID: > <CAJoiCcmR1ysfZoXYq7ox3uxBN5xpt+XTcDx7b-Rqd7q8D7aNgA@mail. > gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Perfect! > That works > Thank you, > Lisandro > > 2017-12-06 11:51 GMT-03:00 Mark Alexander <marka(a)pobox.com>: > > Excerpts from Prof. Lisandro Laura's message of 2017-12-06 11:41:57 > -0300: > >> 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 > > > > This sounds familiar. Try running the following command first: > > > > koha-shell LIBRARY > > > > where LIBRARY is your Koha instance name. After that, the various > > Koha shell scripts should work. > > > ------------------------------ > > Message: 6 > Date: Wed, 6 Dec 2017 17:56:52 +0200 > From: "Admire Mutsikiwa" <amutsikiwa(a)uzlib.uz.ac.zw> > To: <koha(a)lists.katipo.co.nz> > Subject: [Koha] where to set Refund lost item fee > Message-ID: <00b201d36eaa$d5844ef0$808cecd0$(a)uzlib.uz.ac.zw> > Content-Type: text/plain; charset="us-ascii" > > 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> > > > > > > ------------------------------ > > Message: 7 > Date: Wed, 06 Dec 2017 16:19:44 +0000 > From: Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> > To: Admire Mutsikiwa <amutsikiwa(a)uzlib.uz.ac.zw> > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] where to set Refund lost item fee > Message-ID: > <CAJzKNY4_u41r_9X-hUDyMtdmu3Ew7CuM1f_ > AoG2OQ6ytLXrkZg(a)mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Hi Admire, > See on the circulation rules page: "Default lost item fee refund on return > policy" > > As well as the "Processing fee (when lost)" value when you edit item types. > > Regards, > > Jonathan > > On Wed, 6 Dec 2017 at 12:56 Admire Mutsikiwa <amutsikiwa(a)uzlib.uz.ac.zw> > wrote: > > > 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 <+263%204%20303%20276> > > > > Mob:+263771117777 <+263%2077%20111%207777> > > > > > > > > "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> > > > > > > > > _______________________________________________ > > 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 14 > ************************************* >

1 0

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