[Koha] Migrating authorities

2021-04-28 Thread Thomas Klausner
somewhere that does that? I found this rather old thread: http://koha.1045719.n5.nabble.com/Building-authority-records-after-data-migration-td5758845.html which seems to indicate that there are no onboard Koha tools for such a migration. But as this post is from 2013 I hope that in the meanti

Re: [Koha] Migrating authorities

2021-04-28 Thread Thomas Klausner
script as a good base (and/or extend it). > More information on this and more topics about authorities you will find at > https://bywatersolutions.com/news/authorities-town-hall-recap Seems very helpful at a first glance, will take a closer look later. Thanks a lot! Greetings, Thomas Kl

[Koha] Bulk-import authorities via SRU/Z39.50?

2021-05-06 Thread Thomas Klausner
Mode=true&query=nid%3D118590359 and create a new authority record in Koha. I can of course hack up such a script (or extend an existing one), but before starting from scratch I thought I'd ask for prior art... Greetings, Thomas Klausner -- #!/usr/bin/perl ht

Re: [Koha] Bulk-import authorities via SRU/Z39.50?

2021-05-07 Thread Thomas Klausner
Hi! On Fri, May 07, 2021 at 01:08:54PM +0200, Katrin Fischer wrote: > I am not aware of any script to get the data from the DNB directly. But > if you can create a file with valid MARC data, the bulkmarcimport and > the staged tools will be able to import it. ok, so I will write a script that g

[Koha] SRU Config

2021-05-07 Thread Thomas Klausner
Hi! (reposting from IRC, where I got warnocked): Can somebody help me setting up a Z39.50/SRU server config? We want to query https://services.dnb.de/sru/authorities, but I don't get any results, because it seems Zoom gets a 400 error (which is not reported to the UI) I assume that dnb.de ret

Re: [Koha] SRU Config

2021-05-07 Thread Thomas Klausner
Hi! I figured it out (with a little off-list help by Stefan Kugler - thanks!!) My working config now is: Hostname: services.dnb.de Port: 80(instead of 443) Database: sru/authorities (remove slash at the start) Database: sru/accessToken~TOKEN/authorities (though it seems

Re: [Koha] SRU Config

2021-05-10 Thread Thomas Klausner
Hi! I have now figured out a few SRU-Mappings for services.dnb.de authorpersonal = BBG="Tp*" and dnb.per authorcorp = BBG="Tb*" and dnb.koe title = BBG="Tu*" and dnb.tit https://www.dnb.de/DE/Professionell/Metadatendienste/Datenbezug/SRU/sru_node.html https://services.dnb.de/sru/dnb

Re: [Koha] [German] 3. virtuelles Koha-D-A-CH-Anwendertreffen am 9.6.2021

2021-05-18 Thread Thomas Klausner
Hi! On Tue, May 18, 2021 at 01:11:10PM +0200, Fischer, Katrin wrote: > +++ This announcement addresses German-speaking Koha users as the user > meeting will be held in German +++ Interesting, but unfortunately this clashes with "The Perl and Raku Conference in the Cloud" (though I'm not sure ho

[Koha] Recursive auth import via SRU

2021-10-05 Thread Thomas Klausner
Hi! When we catalouge a new book by importing it via SRU, various authorities are created (based on BiblioAddsAuthorities/AutoCreateAuthorities), but only with the minimal data available in the bibliographic record we're importing: For example, a book might have an author: 100 1 _0(DE-588)133

[Koha] ElasticSearch faceted search

2021-10-11 Thread Thomas Klausner
Hi! I'm trying to add a new facet, but it seems that the field names available for faceted search are hardcoded in the source code in Koha::SearchEngine::Elasticsearch->get_facetable_fields It also seems that any changes I make via the UI in admin/searchengine/elasticsearch/mappings.pl are not

Re: [Koha] Koha versions

2021-11-17 Thread Thomas Klausner
Hi! On Wed, Nov 17, 2021 at 10:41:43PM -0600, Marcos René Álvarez Moreno wrote: > I have seen many versions of koha today. > Such as 19.xx, 20.xx, 21.xx, even bug fixes for certain versions of koha. > > What is the latest stable version of koha including its fixes? Do these link help? https:/

[Koha] Linking via 830$w

2021-12-21 Thread Thomas Klausner
Hi! We have encountered an interesting behaviour and are not sure if it's a bug in Koha, in our data, or something else: We have a bibliographic record A where 830$w points to another record B (to the other records' 001 value, to be precise): A: 830$w = 12345 B: 001 = 12345 When Koha renders

Re: [Koha] Linking via 830$w

2022-01-03 Thread Thomas Klausner
Hi! On Sat, Jan 01, 2022 at 01:56:31PM +0100, Katrin Fischer wrote: > is this an 830 from a traced series entry? Yes. > The 830 here is used for a traced series entry in combination with a 490 > ind. 1 = 1. Not sure what you mean by "490 ind". But the relationship is definitly not 1:1, but n

[Koha] Elasticsearch sorting broken

2022-02-09 Thread Thomas Klausner
Hi! (I did not want to file a bug yet, because maybe we're doing something stupid on our side...) We're using Elasticsearch for searching, but when using a non-default sort, the results are not really sorted: https://katalog.landesbibliothek.steiermark.at/cgi-bin/koha/opac-search.pl?idx=&q=ari

Re: [Koha] Batch modification: Possibility to copy subfield content to another field's fixed positions?

2022-02-18 Thread Thomas Klausner
Hi! On Fri, Feb 18, 2022 at 11:12:22AM +, Bruns, Anke wrote: > 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

[Koha] C4::Heading::MARC21

2022-02-21 Thread Thomas Klausner
Hi! A few days ago I asked this in IRC, but got no response, so I'm trying here: I have a question regarding C4::Heading::MARC21: https://github.com/Koha-Community/Koha/blob/master/C4/Heading/MARC21.pm#L49 and #167 define some hardcoded mappings which subfields to include/display eg in the popup

Re: [Koha] C4::Heading::MARC21

2022-03-03 Thread Thomas Klausner
us to add > these to the default mappings. > > Katrin > > > On 21.02.22 15:34, Thomas Klausner wrote: > > Hi! > > > > A few days ago I asked this in IRC, but got no response, so I'm trying > > here: > > > > I have a question rega

Re: [Koha] Alternate Graphic Representation (880 Tag) Information Details stored in which Koha Database Tables?

2022-03-07 Thread Thomas Klausner
Hi! On Mon, Mar 07, 2022 at 04:47:31PM +0530, Sambhunath Sahoo wrote: > I had already checked the Table "biblio_metadata". It has the following > columns: id, biblionumber, format, schema, metadata, timestamp. The 880 > fields data is not visible (may be included in the metadata column?). > Pleas

Re: [Koha] [Koha-devel] Switching Koha to ElasticSearch... any problems?

2022-03-31 Thread Thomas Klausner
Hi! On Thu, Mar 31, 2022 at 03:52:45PM +1300, Mason James wrote: > does anyone have any experience running Koha with ES? > > i've done some basic testing (on 20.11) - it seems to work well and its speed > is impressive! (🦄 + 🌈) > > - is it generally safe to run in production? > - any major pro

Re: [Koha] SMTP configuration error

2022-06-13 Thread Thomas Klausner
Hi! On Mon, Jun 13, 2022 at 02:21:06PM -0500, Coehoorn, Joel wrote: > What you will likely need to do instead is set-up a Per-App password > for Koha. One thing that took me a while to figure out (in a non-Koha context[0]) is that you have to

Re: [Koha] koha gmail sending problem (Google no longer supports the use of third-party apps or devices )

2022-06-16 Thread Thomas Klausner
Hi! On Thu, Jun 16, 2022 at 12:27:52PM +0530, MASTeR Library wrote: > Hello Team, > Due to the below reason koha gmail getting problem (Problem in sending mail > kindly rectify the problem as soon as possible, If it is getting late to > solve the problem as soon as possible. Aiter some other solut

Re: [Koha] Need help to reconfigure Koha Mail with Gmail

2022-06-20 Thread Thomas Klausner
Hi! On Mon, Jun 20, 2022 at 06:40:58PM +0100, Chris Brown wrote: > Our koha mail system is set up to use a gmail account to process outbound > email, using the "less secure apps" option in the gmail account. This has > stopped working for us (and I'm sure for many others) now that Google have >

Re: [Koha] Question on OPACUserCSS

2022-10-27 Thread Thomas Klausner
Hi! On Thu, Oct 27, 2022 at 02:25:48PM +, Bruns, Anke wrote: > we are struggling with a background image for the OPAC pages. > > The description of the parameter OPACUserCSS says " Include the following > CSS on all pages in the OPAC". However, the style declaration > > body { > backgrou

Re: [Koha] Template toolkit puzzle 1.

2022-12-01 Thread Thomas Klausner
Hi! On Fri, Dec 02, 2022 at 06:31:31AM +, Raymund Delahunty wrote: > But when I try to use a TT rule in the ODUE message, no email is sent at all- > there appears to be an error: > [% IF (borrower.dateexpiry == CURDATE() %] Hot sure how much pseudocode this is, but you're missing a closing

Re: [Koha] Koha Spool folder issue

2023-02-09 Thread Thomas Klausner
Hi! On Fri, Feb 10, 2023 at 08:24:32AM +0100, Russel G. P. Shihepo wrote: > Does anyone know the significance of the spool directory of koha? > /var/spool/koha AFAIK backups & db-dumps generated by Koha are stored there. Greetings, domm -- #!/usr/bin/perl https://

Re: [Koha] koha index issue

2023-07-19 Thread Thomas Klausner
s then causes either the search string or the data in the index to interpreted the wrong way? Greetings, domm -- Thomas Klausner domm https://domm.plix.at Just another ( Perl | Postgres | Bicycle | Food | Photo | Vinyl ) Hacker Building a mushroom-delimited Perl veg

Re: [Koha] Error 500 when opening records with attached items

2023-09-05 Thread Thomas Klausner
columns. Greetings, domm -- Thomas Klausner domm https://domm.plix.at Just another ( Perl | Postgres | Bicycle | Food | Photo | Vinyl ) Hacker A not-so-short list of things I learned at PerlKohaCon #Perl #Koha [ 2023-08-19 10:00 >

[Koha] bulkmarcimport.pl with Record Matching Rules?

2023-10-06 Thread Thomas Klausner
, it's a match and should update the old record instead of creating a new one) Greetings, domm -- Thomas Klausner domm https://domm.plix.at Just another ( Perl | Postgres | Bicycle | Food | Photo | Vinyl ) Hacker A not-so-short list of things I learned at PerlKo

Re: [Koha] bulkmarcimport.pl with Record Matching Rules?

2023-10-06 Thread Thomas Klausner
ou will have to define an authority index on 024$a and index, or check the > name of the existing index if any. > > Then you could try like this : --match=IndexName,024a Yeah, I'm right now playing around with defining a new ES search field for 024$a and indexing it :-) Thanks! -

Re: [Koha] Working with nginx and installing on URL prefixes

2023-10-06 Thread Thomas Klausner
inx as a frontend (or maybe they can also be made to work with nginx?) But maybe I also remeber this wrong, but I think we decided to keep Apache (even though I'd rather use nginx) because of these issues... Hope that helps, Greetings, domm -- Thomas Klausner domm

Re: [Koha] Working with nginx and installing on URL prefixes

2023-10-06 Thread Thomas Klausner
zy to do (esp as it's mostly QA work), and instead implemented the aforementiones rewrite hack. But if there were people working on it, I would definitly join! Greetings, domm -- Thomas Klausner domm https://domm.plix.at Just another ( Perl | Postgres | Bicy

Re: [Koha] Elasticsearch in Debian 12

2023-10-23 Thread Thomas Klausner
won't connect to an older Elasticsearch Server (older = before the Licence switch). see here https://opensearch.org/blog/community-clients/ But maybe there are other issues... I hope to get some time this week to take a closer look. Greetings, domm -- Thomas Klausner do

Re: [Koha] Elasticsearch in Debian 12

2023-10-26 Thread Thomas Klausner
csearch version required--this is only version 7.717.` if necessary, downgrade `cpanm Search::Elasticsearch~"< 8.00"` For us, downgrading "solved" the ES problems with newer Debians. -- Thomas Klausner domm https://domm.plix.at Ju

Re: [Koha] Data migration to new koha instance

2024-08-30 Thread Thomas Klausner
ou get to MARC21 first and the run bulkmarcimport.pl For some of the other data (eg patron) there are importers available in Koha, but probably not for all. In those cases you would have to figure out how to import your old data directly into the Koha MySQL DB. Greetings, domm -- Thomas Klaus

Re: [Koha] Reindex ElasticSearch

2024-09-21 Thread Thomas Klausner
ing like: curl http://localhost:9200/{instance}_biblios/_doc/{biblionumber} Of course you have to set your actual ES URL, the instancename and the biblionumber you want to try. You could then pack this into a script... (but in a script I'd rather use LWP::UserAgent instead of `curl`)

Re: [Koha] Securing opac-search

2025-03-19 Thread Thomas Klausner
sues/2025-03-17-git.sr.ht-llms/ and a rather long thread on lobsters, which contains some solution ideas (and a lot of general LLM discussions): https://lobste.rs/s/dmuad3/mitigating_sourcehut_s_partial_outage But yes, currently it sucks... Greetings, domm -- Thomas Klausner d

Re: [Koha] export_records.pl

2025-02-14 Thread Thomas Klausner
gt; --filename=koha-bibs.mrc Do you need to export as USMARC? It is (IMO) a very horrible format, and MARCXML (while also horrible) is less so. Greetings, domm -- Thomas Klausner domm https://domm.plix.at Just another ( Perl | Postgres | Bicycle | Food | Photo |

Re: [Koha] Slowness & outages

2025-07-11 Thread Thomas Klausner
hed a nice post, with a bit more background info: https://openfifth.co.uk/fighting-the-ai-bots/ Greetings, domm (HKS3) -- Thomas Klausner domm https://domm.plix.at Just another ( Perl | Postgres | Koha | Bicycle | Food | Photo | Vinyl ) Hacker Today I man