- Koha - lists.katipo.co.nz

combining two subfields using actions in templates
by Mohamad F Barham 02 Mar '22

02 Mar '22

Dears, Im running koha 21.11.03 I have data in 245d and I need to append it to 773g for articles, I am able to copy and create new 773g, but not to append to existing 773g I need your help to get away to append to 773g from 245d about 77000 records need to be edited Mohamad Barham System Engineer | Information Technology Department Birzeit University P.O.Box. 14, Birzeit, Palestine Tel: + 970 22982012 | Mob: +970 597 861929 | Ext: 5616 mbarham(a)birzeit.edu | www.birzeit.edu<http://www.birzeit.edu/> ~~~~~~~~~~~~~~~~~~~~~~~~~~ The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. The University is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. ~~~~~~~~~~~~~~~~~~~~~~~~~~

1 0

combining two subfields using actions in templates
by Mohamad F Barham 02 Mar '22

02 Mar '22

Dears, Im running koha 21.11.03 I have data in 245d and I need to append it to 773g for articles, I am able to copy and create new 773g, but not to append to existing 773g I need your help to get away to append to 773g from 245d about 77000 records need to be edited Mohamad Barham System Engineer | Information Technology Department Birzeit University P.O.Box. 14, Birzeit, Palestine Tel: + 970 22982012 | Mob: +970 597 861929 | Ext: 5616 mbarham(a)birzeit.edu | www.birzeit.edu<http://www.birzeit.edu/> ~~~~~~~~~~~~~~~~~~~~~~~~~~ The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. The University is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. ~~~~~~~~~~~~~~~~~~~~~~~~~~

1 0

koha-US March 2022 Events & Meetings
by Jennifer Marlatt 01 Mar '22

01 Mar '22

koha-US online meetings and events are free and open to all. See our calendar for a full list: http://koha-us.org/calendar/. *Meetings* Board Meeting - Wednesday, March 2 @ 8:30a PT / 11:30a ET / 16:30 UTC - Meeting Link - https://us02web.zoom.us/j/293750042?pwd=SGQzS2pmU3prNFhYRHNaeTFhOHN4QT09 - Agenda - https://docs.google.com/document/d/1_XS1kBCWBrSITJ5o4DJkfdNr3zHbGeRfM5SPLsq… General Meeting - Wednesday, March 9 @ 8:30a PT / 11:30a ET / 16:30 UTC *Special Interest Groups* Cataloging - Thursday, March 3 @ 8:00a PT / 11:00a ET / 16:00 UTC System Administration - Tuesday, March 8 @ 8:00a PT / 11:00p ET / 16:00 UTC Acquisitions - Tuesday, March 15 @ 9:00a PT / 12:00p ET / 16:00 UTC Web Development - Thursday, March 17 @ 10:00a PT / 1:00p ET / 18:00 UTC Demonstration Instance - Tuesday, March 22 @ 8:00a PT / 11:00a ET / 16:00 UTC Books & Crafts - Wednesday, March 23 @ 5:00p PT / 8:00p ET / 1:00 UTC Consortia - Thursday, March 24 @ 8:00a PT / 11:00p ET / 16:00 UTC Circulation - Tuesday, April 5 @ 10:00a PT / 1:00p ET / 18:00 UTC Visit http://koha-us.org/special-interest-groups/ to learn more and sign up for topic-specific mailing lists. Most meetings and events are recorded and made available at https://www.youtube.com/kohaus Jennifer Marlatt koha-US Secretary secretary(a)koha-us.org

1 0

February Cataloging SIG
by Hernandez, Heather H 01 Mar '22

01 Mar '22

Hi, all! The next Koha-US Cataloging Special Interest Group ("Cat SIG") meeting is this Thursday, February 3, 2022, at 8 PT, 9 MT, 10 CT, 11 ET (16:00 UTC) and you don't have to be a member of Koha-US to join us! You don't even need to self-identify as a cataloger! Join us for our usual roundtable of questions, solutions and resource brainstorming, tips, tricks, suggestions, bug & development awareness, and the usual laughter, fun, and fellowship to discuss anything cataloging, authority, or metadata related in Koha. Not sure if it's cataloging related? It probably is! Actual catalogers do attend, as well as the cataloging curious and those who have had cataloging thrust upon them! Information on joining us is on the Koha-US calendar: https://koha-us.org/calendar/ Can't make it? No worries--it will be recorded and available on the Koha-US YouTube Channel: https://www.youtube.com/c/kohaUS/playlists (See the Cataloging Special Interest Group's playlist for more cataloging fun!) As ever, feel free to send me any questions or topics for discussion ahead of time! See you there! --h2 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Ms. Heather Hernandez (she, her, hers) Technical Services Librarian Library catalog: https://keys.bywatersolutions.com/ San Francisco Maritime National Historical Park Research Center 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA 94123-1284 415-561-7032 (office generally M-W, telecommuting Th-F) heather_hernandez(a)nps.gov<https://webmail.lmi.net/src/compose.php?send_to=heather_hernandez%40nps.gov>

1 1

2022 koha-US conference site announcement
by Barbara Johnson 01 Mar '22

01 Mar '22

Hello Koha community, I'm excited to announce that koha-US Members have chosen Lawrence, KS, as the site for the 2022 koha-US conference which will be held from Tuesday, September 20 - Friday, September 23. Here are details regarding the voting: 34 invitations to vote for the koha-US 2022 conference location were sent via SurveyMonkey * 31 of those invitations were opened * 3 went unopened * 28 members responded * 22 of those respondents ranked Lawrence, KS, as their number one choice * 6 ranked 100% online as their number one choice * 6 ranked Lawrence, KS, as their number two choice * 21 ranked 100% online as their number two choice This will be a hybrid conference with live presentations in Lawrence that will be streamed via YouTube Live. So start making your plans to join us in Kansas! And, it's never too early to start thinking about making a conference presentation. Regards, Barbara Glassford Johnson koha-US President - 2022 CONFIDENTIALITY NOTICE: This City of Bedford (CoB) email transmission is intended only for the use of the individual to whom it is addressed and may contain information that is confidential, privileged, and exempt from disclosure. Any use, copying, retention or disclosure by any person other than the intended recipient or the intended recipient's designees is strictly prohibited. If you have received this email in error, please notify the sender immediately by return email and destroy all electronic and paper copies of the original message and any attachments immediately.

1 0

General IRC meeting 2 March 2022
by Fridolin SOMERS 01 Mar '22

01 Mar '22

Hi, We will be pleased to see you at : https://wiki.koha-community.org/wiki/General_IRC_meeting_2_March_2022 Best regards, -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> Software and system maintainer 🦄 BibLibre, France

1 0

Re: [Koha] Enquiry
by Michael Kuhn 28 Feb '22

28 Feb '22

Hi Ah Win Please always answer to the mailing list. In my e-mail from 2020 that you are referring to I was talking about patron data. But you are asking about bibliographic data which is a completely different thing. You need to convert your (Excel resp. CSV) data to MARC or MARCXML before you can load them into your Koha database. Maybe the following articles will help you: https://kohageek.blogspot.com/2018/12/data-migration-unicode-from-excel-to-… https://de.scribd.com/doc/45190252/Data-Migration-Excel-or-CSV-to-MARC 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 mik(a)adminkuhn.ch · W www.adminkuhn.ch Am 28.02.22 um 03:31 schrieb Ah Win: > Dear Michael, > > Greetings from Myanmar! > > I am a librarian who is trying to use Koha. I saw your email concerning > about excel to koha and I would like to request you to guide us about > converting from excel to koha. > We have one books list which has only author, title fields in excel and > we would like to import to koha. I know that iit is not possible to > convert directly. > Since you have a very good knowledge of koha, please guide us for the > process. > > Many thanks in advance. > Best regards, > Ah Win > > On Sun, 26 Jan 2020 at 19:51, Michael Kuhn <mik(a)adminkuhn.ch > <mailto:mik@adminkuhn.ch>> wrote: > > Hi > > > *s their any particular sequence when you fill Excel to import into > > Koha* > > You cannot use MS Excel files to load data into Koha. > > To load user data you can use a CSV file (MS Excel can deal with that) > with a structure depending on your Koha version. The respective > struchture you can find in Koha menu "Tools > Import patrons" - on the > right side you will find the sentence "Download a starter CSV file with > all the columns here." The HERE is clickable and downloading it will > give you the structure valid for Koha 19.11: > > cardnumber,surname,firstname,title,othernames,initials,streetnumber,streettype,address,address2,city,state,zipcode,country,email,phone,mobile,fax,emailpro,phonepro,B_streetnumber,B_streettype,B_address,B_address2,B_city,B_state,B_zipcode,B_country,B_email,B_phone,dateofbirth,branchcode,categorycode,dateenrolled,dateexpiry,date_renewed,gonenoaddress,lost,debarred,debarredcomment,contactname,contactfirstname,contacttitle,borrowernotes,relationship,sex,password,flags,userid,opacnote,contactnote,sort1,sort2,altcontactfirstname,altcontactsurname,altcontactaddress1,altcontactaddress2,altcontactaddress3,altcontactstate,altcontactzipcode,altcontactcountry,altcontactphone,smsalertnumber,sms_provider_id,privacy,privacy_guarantor_fines,privacy_guarantor_checkouts,checkprevcheckout,updated_on,lastseen,lang,login_attempts,overdrive_auth_token,anonymized,relationship,guarantor_id,guarantor_firstname,guarantor_surname > > Be sure to download the correct structure for your own Koha version. > > To load title and/or item data you will need original MARC or MARCXML > files. Unlike to CSV MS Excel is not able to deal with them at all. > > 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 mik(a)adminkuhn.ch > <mailto:mik@adminkuhn.ch> · W www.adminkuhn.ch <http://www.adminkuhn.ch> > _______________________________________________ > Koha mailing list http://koha-community.org <http://koha-community.org> > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > https://lists.katipo.co.nz/mailman/listinfo/koha > <https://lists.katipo.co.nz/mailman/listinfo/koha> >

2 1

Batch modification: Possibility to copy subfield content to another field's fixed positions?
by Bruns, Anke 28 Feb '22

28 Feb '22

Hi, in order to be able to use the search index for publication year, the year must to my knowledge be mentioned in 008, positions 7-10. Is there a way to populate this with the content from 264$c which, in my case, is always a yyyy? In the templates for batch operations I can only find ways to copy into fields with subfields, not into fixed fields. Thank you for any idea in advance, and a good weekend to all! Anke -- Anke Bruns M.A. (LIS) Arbeitsgruppe "Anwendungs- und Informationssysteme" E-Mail: anke.bruns(a)gwdg.de --------------------------------------- Achtung! Neue Kontaktdaten! Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG) Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de Support: Tel.: +49 551 39-30000, URL: https://gwdg.de/support Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg(a)gwdg.de Geschäftsführer: Prof. Dr. Ramin Yahyapour Aufsichtsratsvorsitzender: Prof. Dr. Norbert Lossau Sitz der Gesellschaft: Göttingen Registergericht: Göttingen, Handelsregister-Nr. B 598 --------------------------------------- Zertifiziert nach ISO 9001 ---------------------------------------

5 8

Koha Community Newsletter: February 2022
by Koha Newsletter 27 Feb '22

27 Feb '22

The Koha Community Newsletter for february 2022 is here: https://koha-community.org/koha-community-newsletter-february-2022/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to email me with any corrections or suggestions. -- Michael Kuhn Editor, Koha Community Newsletter

1 0

Elasticsearch: [query_string] cannot use [fields] parameter in conjunction with [default_field]; in Koha 19.05 with Elasticsearch 6.
by Simon Hohl 26 Feb '22

26 Feb '22

Hello everybody, in light of the Log4j debacle last year, I am currently trying to update Elasticsearch to the current version of 6, from our old version 5. I read in the wiki (https://wiki.koha-community.org/wiki/Elasticsearch) that > Note: As of 20.05.00, 19.11.05 and 19.05.10 releases, we recommend > Elasticsearch 6.x We are at 19.05.17. I updated accordingly and did a complete re-index, but I get the appended error for searches. Did I miss something? An upgrade to the current Koha version is planned for later this year, but will require more testing to make sure all our local changes get re-applied after upgrading via package. Kind regards Simon > [2022-02-17T07:50:10,007][DEBUG][o.e.a.s.TransportSearchAction] > [vgY4zBy] All shards failed for phase: [query] > org.elasticsearch.index.query.QueryShardException: failed to create > query: { > "query_string" : { > "query" : "(_all:A*)", > "default_field" : "_all", > "fields" : [ > "_all^1.0" > ], > "type" : "best_fields", > "default_operator" : "and", > "max_determinized_states" : 10000, > "enable_position_increments" : true, > "fuzziness" : "AUTO", > "fuzzy_prefix_length" : 0, > "fuzzy_max_expansions" : 50, > "phrase_slop" : 0, > "analyze_wildcard" : true, > "lenient" : true, > "escape" : false, > "auto_generate_synonyms_phrase_query" : true, > "fuzzy_transpositions" : true, > "boost" : 1.0 > } > } > at > org.elasticsearch.index.query.QueryShardContext.toQuery(QueryShardContext.java:335) > ~[elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.index.query.QueryShardContext.toQuery(QueryShardContext.java:318) > ~[elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.search.SearchService.parseSource(SearchService.java:806) > ~[elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.search.SearchService.createContext(SearchService.java:653) > ~[elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.search.SearchService.createAndPutContext(SearchService.java:604) > ~[elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.search.SearchService.executeQueryPhase(SearchService.java:388) > ~[elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.search.SearchService.access$100(SearchService.java:127) > ~[elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.search.SearchService$2.onResponse(SearchService.java:360) > [elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.search.SearchService$2.onResponse(SearchService.java:356) > [elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.search.SearchService$4.doRun(SearchService.java:1129) > [elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:37) > [elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.common.util.concurrent.TimedRunnable.doRun(TimedRunnable.java:41) > [elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.common.util.concurrent.ThreadContext$ContextPreservingAbstractRunnable.doRun(ThreadContext.java:778) > [elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:37) > [elasticsearch-6.8.23.jar:6.8.23] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > [?:1.8.0_322] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > [?:1.8.0_322] > at java.lang.Thread.run(Thread.java:750) [?:1.8.0_322] > Caused by: org.elasticsearch.index.query.QueryValidationException: > Validation Failed: 1: [query_string] cannot use [fields] parameter in > conjunction with [default_field]; > at > org.elasticsearch.index.query.QueryValidationException.addValidationError(QueryValidationException.java:43) > ~[elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.index.query.AbstractQueryBuilder.addValidationError(AbstractQueryBuilder.java:183) > ~[elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.index.query.QueryStringQueryBuilder.doToQuery(QueryStringQueryBuilder.java:977) > ~[elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.index.query.AbstractQueryBuilder.toQuery(AbstractQueryBuilder.java:106) > ~[elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.index.query.QueryShardContext.lambda$toQuery$2(QueryShardContext.java:319) > ~[elasticsearch-6.8.23.jar:6.8.23] > at > org.elasticsearch.index.query.QueryShardContext.toQuery(QueryShardContext.java:331) > ~[elasticsearch-6.8.23.jar:6.8.23] > ... 16 more

2 1