<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body>A new request with request id 18814 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is : <br><br>Title : Koha-devel Digest, Vol 185, Issue 24<br>Category : <br>Description : <div>Send Koha-devel mailing list submissions to<br> koha-devel@lists.koha-community.org<br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>or, via email, send a message with subject or body 'help' to<br> koha-devel-request@lists.koha-community.org<br><br>You can reach the person managing the list at<br> koha-devel-owner@lists.koha-community.org<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Koha-devel digest..."<br><br><br>Today's Topics:<br><br> 1. Re: bulkmarcimport.pl ... re-import/update existing records<br> (Katrin Fischer)<br> 2. Re: Deleting entries from language_descriptions<br> (dcook@prosentient.com.au)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Sun, 25 Apr 2021 13:03:30 +0200<br>From: Katrin Fischer <katrin.fischer.83@web.de><br>To: koha-devel@lists.koha-community.org<br>Subject: Re: [Koha-devel] bulkmarcimport.pl ... re-import/update<br> existing records<br>Message-ID: <9e2e1bad-c9aa-a7be-6d88-10679a55094b@web.de><br>Content-Type: text/plain; charset="utf-8"; Format="flowed"<br><br>Hi David,<br><br>I see that you haven't received any replies on the list yet. Sadly I am<br>not sure what is causing the issues you have.<br><br>For the matching I found an older mail thread, suggesting a different<br>syntax for the match parameter:<br><br>http://koha.1045719.n5.nabble.com/bulkmarcimport-problems-td5492136.html<br><br>./bulkmarcimport.pl -d -fk -match=barcode,999c -commit 1000 -v -file<br>/tmp/newer40_77000.mrc<br><br> From that, maybe try: -match=Control-umber,001<br><br>If you are stuck, stepping into #koha IRC can be also a good idea:<br><br>https://koha-community.org/get-involved/irc/<br><br>Often people will be able to help you to get to the root of an error<br>message there.<br><br>Katrin<br><br><br>On 22.04.21 11:02, David Schmidt wrote:<br>> Hello koha folks,<br>><br>> ###<br>> I hope this is the correct list for this kind of email<br>> ###<br>><br>><br>> We are currently exporting about 500k recods from a dabis system into<br>> a new koha installation.<br>><br>> the export file (MARCXML) goes through some transformations using<br>> catmandu.<br>><br>> I imported the first 25k records using this command:<br>><br>> ```<br>> bulkmarcimport.pl -M MARCXML -file tmp/marc_001.xml<br>> ```<br>><br>> after inspecting the records some of the catmandu fixes had to be<br>> updated and now im trying to update the existing koha records with the<br>> new marc_002.xml file.<br>><br>> ```<br>> bulkmarcimport.pl -M MARCXML -update -isbn -file tmp/marc_002.xml<br>> ```<br>><br>> this gives me alot of these errors:<br>> ```<br>> WARNING: Updating record failed at<br>> /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 470,<br>> <GEN24> line 190.<br>> ..Use of uninitialized value $originalid in concatenation (.) or<br>> string at /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line<br>> 470, <GEN24> line 194.<br>> WARNING: Updating record failed at<br>> /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 470,<br>> <GEN24> line 194.<br>> ```<br>><br>> I also tried using -match but I havent figured out how the parameters<br>> for -match are supposed to look like<br>> ```<br>> bulkmarcimport.pl -m MARCXML -update -match="001" -file tmp/marc_002.xml<br>> ```<br>><br>> ```<br>> .Use of uninitialized value $recorddata in pattern match (m//) at<br>> /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 603,<br>> <GEN24> line 2.<br>> unable to search the database for duplicates : No query entered at<br>> /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 323,<br>> <GEN24> line 2.<br>> ```<br>><br>> help or pointers are appreciated.<br>><br>> cheers<br>> david<br>><br>> _______________________________________________<br>> Koha-devel mailing list<br>> Koha-devel@lists.koha-community.org<br>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>> website : https://www.koha-community.org/<br>> git : https://git.koha-community.org/<br>> bugs : https://bugs.koha-community.org/<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20210425/9d6e5fef/attachment-0001.htm><br><br>------------------------------<br><br>Message: 2<br>Date: Mon, 26 Apr 2021 10:36:43 +1000<br>From: <dcook@prosentient.com.au><br>To: "'Katrin Fischer'" <katrin.fischer.83@web.de>,<br> <koha-devel@lists.koha-community.org><br>Subject: Re: [Koha-devel] Deleting entries from language_descriptions<br>Message-ID: <021e01d73a34$3b673950$b235abf0$@prosentient.com.au><br>Content-Type: text/plain; charset="utf-8"<br><br>Hi Katrin,<br><br> <br><br>I was thinking it would be good to change the structure to make it easier for translators, although that could also make it significantly harder for libraries to add missing languages too. <br><br> <br><br>I have a library that wanted to add Bosnian and Maltese, so I was able to just give them some SQL queries to do the trick. <br><br> <br><br>I suppose another way of doing it would be to have a database table of language codes with the native name and then use per-language templates to provide the translated names of the languages. <br><br> <br><br>I’ll comment on the Bug, although I don’t imagine this will change any time soon…<br><br> <br><br>David Cook<br><br>Software Engineer<br><br>Prosentient Systems<br><br>Suite 7.03<br><br>6a Glen St<br><br>Milsons Point NSW 2061<br><br>Australia<br><br> <br><br>Office: 02 9212 0899<br><br>Online: 02 8005 0595<br><br> <br><br>From: Koha-devel <koha-devel-bounces@lists.koha-community.org> On Behalf Of Katrin Fischer<br>Sent: Saturday, 24 April 2021 6:45 PM<br>To: koha-devel@lists.koha-community.org<br>Subject: Re: [Koha-devel] Deleting entries from language_descriptions<br><br> <br><br>Hi David,<br><br>it seems likely that these are unused. It would be nice to update our structure there, especially for easier translations. Bernardo has been working on something for this in the past:<br><br> <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12017> Bug 12017 - Move language description out of database<br><br>Katrin<br><br>On 23.04.21 04:38, dcook@prosentient.com.au <mailto:dcook@prosentient.com.au> wrote:<br><br>Hi all,<br><br> <br><br>I was looking at how to add languages to the Languages drop down in the OPAC advanced search and went down an unpleasant C4::Languages rabbithole…<br><br> <br><br>But looking at language_descriptions, I’m wondering if perhaps we could delete the following data, as I imagine it’s very outdated and unused:<br><br> <br><br>MySQL [koha_kohadev]> select * from language_descriptions;<br><br>+----------+----------+------+---------------------------------------+-----+<br><br>| subtag | type | lang | description | id |<br><br>+----------+----------+------+---------------------------------------+-----+<br><br>| opac | i | en | OPAC | 1 |<br><br>| opac | i | fr | OPAC | 2 |<br><br>| opac | i | de | OPAC | 3 |<br><br>| intranet | i | en | Staff Client | 4 |<br><br>| intranet | i | fr | Client personnel | 5 |<br><br>| intranet | i | de | Dienstoberfläche | 6 |<br><br>| prog | t | en | Prog | 7 |<br><br>| prog | t | fr | Prog | 8 |<br><br>| prog | t | de | Prog | 9 |<br><br> <br><br>At the moment, it looks like adding a language requires manual SQL queries to language_subtag_registry, language_descriptions, and language_rfc4646_to_iso639. It’s a shame there is no native interface for updating it. I imagine a plugin could work out well for it, although I think for the library in mind they’ll probably just do a manual insert, as it’s not worth the development cost…<br><br> <br><br>David Cook<br><br>Software Engineer<br><br>Prosentient Systems<br><br>Suite 7.03<br><br>6a Glen St<br><br>Milsons Point NSW 2061<br><br>Australia<br><br> <br><br>Office: 02 9212 0899<br><br>Online: 02 8005 0595<br><br> <br><br><br><br><br><br>_______________________________________________<br>Koha-devel mailing list<br>Koha-devel@lists.koha-community.org <mailto:Koha-devel@lists.koha-community.org> <br>https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>website : https://www.koha-community.org/<br>git : https://git.koha-community.org/<br>bugs : https://bugs.koha-community.org/<br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20210426/1ee40c2c/attachment.htm><br><br>------------------------------<br><br>Subject: Digest Footer<br><br>_______________________________________________<br>Koha-devel mailing list<br>Koha-devel@lists.koha-community.org<br>https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>website : https://www.koha-community.org/<br>git : https://git.koha-community.org/<br>bugs : https://bugs.koha-community.org/<br><br><br>------------------------------<br><br>End of Koha-devel Digest, Vol 185, Issue 24<br>*******************************************<br></div><br><br>NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.<br></body></html>