Re: [Koha] Background job / Staging MARC import stuck at 0%

2023-03-02 Thread Jonathan Druart 
Hello Michael,
I have just tried on 22.11.03 and it seems to work for me.
Can you try to open a console, watch the logs: tail -f
/var/log/koha/$KOHA_INSTANCE/*.log
Import a file.
Do you see something in the logs?

Otherwise look at the background_jobs.data JSON, you may see an error in
it. But if the status is still "new" I am not expecting an error there.


Le jeu. 2 mars 2023 à 14:50, Michael Brown  a
écrit :

> Greetings:
>
> My name is Michael Brown and I am a professional cataloger and SirsiDynix
> System Admin at the Texas State Library & Archives in Austin (20+ years
> now). I have been using Koha on Arch Linux in my home library for about a
> year now. I am migrating my home server to AlmaLinux and I'm having a
> problem.
>
> I am running Koha 22.11.03.000 Rosalie on AlmaLinux 9.1. Staging a MARC
> file for import gets stuck at 0%. On screen, I am able to select the file
> for import (bib.mrc), review the profile options (but I don't change any
> defaults), and then click on "Stage for import" at the bottom. Next screen
> reads:
>
> The job has been enqueued! It will be processed as soon as possible.
> 0%
> View detail of the enqueued job
>
> After a few seconds, it changes to (and then hangs at):
>
> The job has been enqueued! It will be processed as soon as possible.
> 0% Not started
> View detail of the enqueued job
>
> Clicking on "View detail of the enqueued job" I see:
>
> Details of job #22
>
> Job ID: 22
> Status:New
> Progress:0 / 0
> Type:Staged MARC records for import
> Queued:03/02/2023 05:42
> Started:
> Ended:
>
> Report
> Detailed messages
> Return to the job list
>
> The corresponding entry in mariadb is:
>
> id 22
> status new
> progress NULL
> size 0
> borrowernumber 1
> type stage_marc_for_import
> queue Name of the queue the job is sent to long_tasks
> data {"encoding":"UTF-8","comments":"","basket_id":null...
> context JSON-serialized context information for the job
> {"flags":1,"branch":"ALMA","interface":"intranet",...
> enqueued_on 2023-03-02 05:42:33
> started_on NULL
> ended_on NULL
>
> (If you need to see the full entries for "data" and "context", please let
> me know.)
>
> tmp, koha_upload, and lock directories have been tweaked and fine tuned. I
> was getting early warnings about them not being set in koha-conf.xml so I
> created them (and set correct permissions) and I can see the uploaded file
> (for job 22 the name is 2287629673fb980ad4102f62ebeaa1b9_bib.mrc), so the
> actual upload function appears to be working.
>
> I am getting no apache errors and no other on-screen diagnostics.
>
> I have Koha 22.05.02.000 running on Arch Linux that imports this file just
> fine. Similarly, I have Koha latest running on a Debian VM that can import
> this file just fine, too.
>
> What am I missing?
>
> Details of my system:
>
> Koha version: 22.11.03.000 Rosalie
> OS version ('uname -a'): Linux alma 5.14.0-162.12.1.el9_1.x86_64 #1 SMP
> PREEMPT_DYNAMIC Mon Jan 23 14:51:52 EST 2023 x86_64
> Perl interpreter: /usr/bin/perl
> Perl version: 5.032001
> Perl @INC: /usr/share/koha/lib
> /usr/local/lib64/perl5/5.32
> /usr/local/share/perl5/5.32
> /usr/lib64/perl5/vendor_perl
> /usr/share/perl5/vendor_perl
> /usr/lib64/perl5
> /usr/share/perl5
> /var/lib/koha/plugins
> MySQL version: mysql Ver 15.1 Distrib 10.5.16-MariaDB, for Linux (x86_64)
> using EditLine wrapper
> Apache version: Server version: Apache/2.4.53 (AlmaLinux) Server built: Jul
> 20 2022 00:00:00
> Memcached: Servers: 127.0.0.1:11211 | Namespace: KOHA | Status: running. |
> Config read from: koha-conf.xml
> Zebra version: Zebra 2.2.7 (C) 1994-2023, Index Data Zebra is free
> software, covered by the GNU General Public License, and you are welcome to
> change it and/or distribute copies of it under certain conditions. SHA1 ID:
> ac40f289672405a299436d73c1532f9906774cc6 Using ICU
> Zebra status: Running
> Message broker: Using RabbitMQ
> Date and time: 03/01/2023 16:20
> Time zone: Used: America/Chicago | Config: Undefined | Environment (TZ):
> Undefined
>
> Thanks,
> Michael
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] "[Suspected Spam]" Re: Modify Patron Transaction Invoices and Fee Receipts

2023-03-02 Thread Ms. Naveen Ali 
Dear all, 

I am using Koha 22.05 and trying to modify the ACCOUNT_CREDIT pint slip. 

I would like to add the book information (biblio and lending such as due date 
and return date ) of items included in the receipt. 
I am learning about the Template Toolkit used and have found the following 
documentation 
https://wiki.koha-community.org/wiki/Template_Toolkit_Plugins 
but it is not complete. 

Is the documentation available and accessible? 

Could someone point me in the correct direction please. 


With best regards, 

Naveen Ali 

ITM-JE (EAKL) 
Inst Representative for 
HEC Digital Library Resources. 
NEDUET, Karachi. 


- Original Message -

From: "MASTeR Library"  
To: "Ms. Naveen Ali"  
Cc: "Caroline Cyr La Rose" , "koha" 
 
Sent: Wednesday, 1 March, 2023 12:52:57 PM 
Subject: Re: [Koha] Modify Patron Transaction Invoices and Fee Receipts 

Account payment invoice 
https://libpowertech.blogspot.com/2022/03/how-to-create-email-receipt-template.html?m=1
 

On Wed, 1 Mar 2023, 11:26 am Ms. Naveen Ali, < nav...@neduet.edu.pk > wrote: 


Hi Caroline, 

Thanks a lot for the information. 

I was looking for them in Tools->Notices and slips but was not able to map the 
receipts and invoices. 

The link you mentioned is great. 

I tried using Help on the Koha interface. It took me to this link 

https://koha-community.org/manual//22.05/en/html/tools.html#existing-notices-and-slips
 

where i did not find ACCOUNT_DEBIT and CREDIT you mentioned. 

I believe the manual needs to be updated. 

Thanks a lot for your help and kind support. 

With best regards, 

Naveen Ali 

ITM-JE (EAKL) 
Inst Representative for 
HEC Digital Library Resources. 
NEDUET, Karachi. 


- Original Message - 
From: "Caroline Cyr La Rose" < caroline.cyr-la-r...@inlibro.com > 
To: koha@lists.katipo.co.nz 
Sent: Tuesday, 28 February, 2023 7:20:50 PM 
Subject: Re: [Koha] Modify Patron Transaction Invoices and Fee Receipts 

Hi Naveen, 

Transaction invoice = ACCOUNT_DEBIT 

Transaction receipt = ACCOUNT_CREDIT 

Summary is not customizable... 
( https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11340 ) 

Slip = ISSUESLIP 

Quick slip = ISSUEQSLIP 

Overdues = OVERDUES_SLIP 

Checkin slip = CHECKINSLIP 

Can I ask where you checked? I know most of them are described in the 
manual 
https://koha-community.org/manual/latest/en/html/tools.html#existing-notices-and-slips
 
but it might be missing in crucial places where people would check 
first... So I'd like to add it there. 

Thanks! 

Caroline 


On 2023-02-27 23:33, Ms. Naveen Ali wrote: 
> Dear members, 
> 
> I'd like to modify the Patron Transaction Invoices and Fee Receipts. 
> In fact all the print options available on the Patron Screen (Summary, Slip, 
> Quick Slip, Overdues, Check In Slip) 
> I can't identify them in the Notices and Slips Tool 
> Please provide support. 
> 
> With best regards, 
> 
> Naveen Ali 
> 
> ITM-JE (EAKL) 
> Inst Representative for 
> HEC Digital Library Resources. 
> NEDUET, Karachi. 
> 
> 
> ___ 
> 
> Koha mailing listhttp:// koha-community.org 
> Koha@lists.katipo.co.nz 
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha 
-- 
Logo inLibro < https://inLibro.com > Caroline Cyr-La-Rose 
Bibliothécaire | Responsable de produit 

T 833-INLIBRO (465-4276) , poste 221 
C caroline.cyr-la-r...@inlibro.com 

www.inLibro.com < https://inLibro.com > 
___ 

Koha mailing list http://koha-community.org 
Koha@lists.katipo.co.nz 
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha 
___ 

Koha mailing list http://koha-community.org 
Koha@lists.katipo.co.nz 
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha 




___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Import Unimarc records with items

2023-03-02 Thread Сычев Игорь Алексеевич 
Thanks for the answer.
I didn't change anything.
If I delete $995j, then the item are loaded.
Next, I wanted to add inventory manually, it is not saved.
What else could be the problem?

-Original Message-
From: Koha  On Behalf Of Katrin Fischer
Sent: Sunday, January 1, 2023 10:35 PM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Import Unimarc records with items

Hi Igor,

looking at this I have been wondering:

'stocknumber'

This looks like there could be an additional space that should not be there.

Have you edited the frameworks in some way maybe? I'd check if that space is in 
the bibliographic frameworks you created/use for importing.

Hope this helps,

Katrin

On 30.12.22 16:05, Igor A. Sychev wrote:
> Thanks for the answer.
> Removed $995 and:
> root@koha:/usr/share/koha/bin/migration_tools# perl bulkmarcimport.pl 
> -b -file book-test.mrc -c UNIMARC
> .ERROR: Adding items to bib 1 failed: 
> DBIx::Class::Row::store_column(): No such column 'stocknumber ' on 
> Koha::Schema::Result::Item at /usr/share/koha/lib/Koha/Object.pm line 
> 79 How to fix?
>
> пт, 23 дек. 2022 г. в 03:05, Fridolin SOMERS :
>
>> Indeed,
>> 995$9 is for Koha internal id of item = itemnumber, the primary key 
>> in table items.
>>
>> Le 21/12/2022 à 13:16, gvera...@dataly.gr a écrit :
>>> Remove subfield 9 and it will import
>>>
>>> Παραθέτοντας από "Igor A. Sychev" :
>>>
 Hello!
 There are records with items in UNIMARC format.
 Records are imported.
 Items are not imported.
 Why is this happening?
 Are there other options for importing items?

 Example:
 ...
  
2001-01-01
1
NF
TPU
TPU
13821000185704
95-1389
95-1389
3700,00
BK
  
 ...

 Good Luck!
 ___

 Koha mailing list  http://koha-community.org 
 Koha@lists.katipo.co.nz
 Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>>
>>> ___
>>>
>>> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>> --
>> Fridolin SOMERS  Software and system 
>> maintainer 濾
>> BibLibre, France
>> ___
>>
>> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> ___
>
> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Background job / Staging MARC import stuck at 0%

2023-03-02 Thread Michael Brown 
Thanks, Eric. I appreciate that suggestion, but that didn't work. What
happens now is I click on "Stage for import" at the bottom and I'm thrown
right back to the spot where I'm supposed to upload a file for import,
bypassing the "enqueuement" altogether. However,
/var/log/koha/koha-error_log shows a new error:

Failed to connect: Error connecting to localhost:61613:
Connection refused at /usr/local/share/perl5/5.32/Net/Stomp.pm
line 27.; giving up at /usr/local/share/perl5/5.32/Net/Stomp.pm
line 27.: /usr/share/koha/intranet/cgi-bin/about.pl, referer:
http://192.168.1.254:8080/cgi-bin/koha/mainpage.pl

I added port 61613/tcp to my firewall rules, but lsof doesn't show anything
listening on that port. But that got me thinking that maybe 61613 might
need to be open for rabbitmq to begin with, so I re-enabled rabbitmq and
rebooted with port 61613 open. Now I'm back to hanging at the "0% Not
Started" enqueuement.

Just for grins, I tried completely disabling the firewall. Still no luck.

Another thing I noticed: if I leave the "enqueuement" page open (hanging at
0%...), /usr/share/koha/api/v1/app.pl will keep running, consuming a lot of
my cpu power until I finally navigate away from that page.

I'm going to keep digging, but if you have any other suggestions, I'm all
ears.

Michael

On Thu, Mar 2, 2023 at 11:01 AM Eric Phetteplace 
wrote:

> Hi Michael,
>
> This is not going to be a very informed response, because I don't know
> much about this part of Koha, but based on what you wrote it sounds like it
> might be an error with the messaging queue. The file uploads OK, so that's
> not it, and the version of a package dependency (like RabbitMQ) is the sort
> of thing that's affected by an OS change. You could try changing your
> message broker to SQL polling (I think that involves just removing the
> message_broker setting in koha-conf.xml and restarting) to see if that
> fixes the problem, then investigate RabbitMQ itself e.g. if it has its own
> logs, a debug mode, or use its web UI (on port 15672).
>
> Best,
>
> ERIC PHETTEPLACE Systems Librarian, Libraries (he/him)
>
> ephettepl...@cca.edu
>
>
> *CCA is situated on the traditional unceded lands of the **Chochenyo and
> Ramaytush Ohlone** peoples.*
>
> Black-owned bookstores in Oakland: Ashay by the Bay
> , Marcus Books
> 
>
> :(){ :|: & };:
>
>
> On Thu, Mar 2, 2023 at 5:51 AM Michael Brown 
> wrote:
>
>> Greetings:
>>
>> My name is Michael Brown and I am a professional cataloger and SirsiDynix
>> System Admin at the Texas State Library & Archives in Austin (20+ years
>> now). I have been using Koha on Arch Linux in my home library for about a
>> year now. I am migrating my home server to AlmaLinux and I'm having a
>> problem.
>>
>> I am running Koha 22.11.03.000 Rosalie on AlmaLinux 9.1. Staging a MARC
>> file for import gets stuck at 0%. On screen, I am able to select the file
>> for import (bib.mrc), review the profile options (but I don't change any
>> defaults), and then click on "Stage for import" at the bottom. Next screen
>> reads:
>>
>> The job has been enqueued! It will be processed as soon as possible.
>> 0%
>> View detail of the enqueued job
>>
>> After a few seconds, it changes to (and then hangs at):
>>
>> The job has been enqueued! It will be processed as soon as possible.
>> 0% Not started
>> View detail of the enqueued job
>>
>> Clicking on "View detail of the enqueued job" I see:
>>
>> Details of job #22
>>
>> Job ID: 22
>> Status:New
>> Progress:0 / 0
>> Type:Staged MARC records for import
>> Queued:03/02/2023 05:42
>> Started:
>> Ended:
>>
>> Report
>> Detailed messages
>> Return to the job list
>>
>> The corresponding entry in mariadb is:
>>
>> id 22
>> status new
>> progress NULL
>> size 0
>> borrowernumber 1
>> type stage_marc_for_import
>> queue Name of the queue the job is sent to long_tasks
>> data {"encoding":"UTF-8","comments":"","basket_id":null...
>> context JSON-serialized context information for the job
>> {"flags":1,"branch":"ALMA","interface":"intranet",...
>> enqueued_on 2023-03-02 05:42:33
>> started_on NULL
>> ended_on NULL
>>
>> (If you need to see the full entries for "data" and "context", please let
>> me know.)
>>
>> tmp, koha_upload, and lock directories have been tweaked and fine tuned. I
>> was getting early warnings about them not being set in koha-conf.xml so I
>> created them (and set correct permissions) and I can see the uploaded file
>> (for job 22 the name is 2287629673fb980ad4102f62ebeaa1b9_bib.mrc), so the
>> actual upload function appears to be working.
>>
>> I am getting no apache errors and no other on-screen diagnostics.
>>
>> I have Koha 22.05.02.000 running on Arch Linux that imports this file just
>> fine. Similarly, I have Koha latest running on a Debian VM that can import
>> this file just fine, too.
>>
>> What am I missing?
>>
>> Details

Re: [Koha] How to resolve bug Bug 28267? What must I do in mysql?

2023-03-02 Thread Δημήτρης Δαλαγιώργος 
No I hadn't! I didn't manage to get the script running, but I did log
in to mysql, run the SELECT command, get the list of tables, export
the tables to excel to make the multiple ALTER TABLE queries and
finally run the queries on the mysql server. AND IT WORKED! IHAVE MY
CATALOGUE BACK! I'm so happy! Thanks for your help!

Dimitrios Dalagiorgos
3rd high school of Kozani

Στις Πέμ 2 Μαρ 2023 στις 9:37 π.μ., ο/η Jonathan Druart
 έγραψε:
>
> Did you see comment 20?
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267#c20
>
> Le jeu. 2 mars 2023 à 06:30, Δημήτρης Δαλαγιώργος 
>  a écrit :
>>
>> Dear all,
>>
>> I'm not a developer, and as I mentioned before, I'm stuck with an
>> inoperable library catalogue due to the fact that I can't update to
>> the latest version because "Older databases fail to upgrade due to
>> having a row format other than "DYNAMIC"".
>>
>> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267
>>
>> I've read the comments on this bug but I fail to understand what I
>> should do to fix this. Obviously I must login to mysql and perform
>> some actions. What actions are those? Can someone point me to detailed
>> instructions?
>>
>> Kind regards,
>>
>> Dimitrios Dalagiorgos
>> 3rd high school of Kozani
>> ___
>>
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] The Terrific Every-Other-Thursday Training Videos | jQuery: Hold Dates | S3E13

2023-03-02 Thread BRANNON, CHRISTOPHER 
Hold it! Don't go any further. If you are looking for a way to wrangle your 
holds better around closed libraries, you should check out this video. George 
shows us ways to force "suspend until" dates for particular libraries, as well 
as work around some unexpected bugs with default hold expiration dates in 
current versions of Koha. I can't wait! But your patrons will have to if you 
implement these tweaks.

https://youtu.be/GKrHrtLM5PM

Christopher Brannon
2023 koha-US President
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Internal server error with ISBD detail and making a hold on OPAC

2023-03-02 Thread Paul 
I’m recently started to get internal server errors when looking at ISBD
detail and making a hold when in the OPAC.

We’re using Koha 19.11.22.000 on Debian 9.

I’ve seen a similar problem reported as bug 22735: Resolve internal server
error on missing item type but that was on 18.05 and presumably fixed back
then.

Can anyone offer any fixes please?

Paul Leman

-- 
Paul Leman
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Background job / Staging MARC import stuck at 0%

2023-03-02 Thread Eric Phetteplace 
Hi Michael,

This is not going to be a very informed response, because I don't know much
about this part of Koha, but based on what you wrote it sounds like it
might be an error with the messaging queue. The file uploads OK, so that's
not it, and the version of a package dependency (like RabbitMQ) is the sort
of thing that's affected by an OS change. You could try changing your
message broker to SQL polling (I think that involves just removing the
message_broker setting in koha-conf.xml and restarting) to see if that
fixes the problem, then investigate RabbitMQ itself e.g. if it has its own
logs, a debug mode, or use its web UI (on port 15672).

Best,

ERIC PHETTEPLACE Systems Librarian, Libraries (he/him)

ephettepl...@cca.edu


*CCA is situated on the traditional unceded lands of the **Chochenyo and
Ramaytush Ohlone** peoples.*

Black-owned bookstores in Oakland: Ashay by the Bay
, Marcus Books


:(){ :|: & };:


On Thu, Mar 2, 2023 at 5:51 AM Michael Brown  wrote:

> Greetings:
>
> My name is Michael Brown and I am a professional cataloger and SirsiDynix
> System Admin at the Texas State Library & Archives in Austin (20+ years
> now). I have been using Koha on Arch Linux in my home library for about a
> year now. I am migrating my home server to AlmaLinux and I'm having a
> problem.
>
> I am running Koha 22.11.03.000 Rosalie on AlmaLinux 9.1. Staging a MARC
> file for import gets stuck at 0%. On screen, I am able to select the file
> for import (bib.mrc), review the profile options (but I don't change any
> defaults), and then click on "Stage for import" at the bottom. Next screen
> reads:
>
> The job has been enqueued! It will be processed as soon as possible.
> 0%
> View detail of the enqueued job
>
> After a few seconds, it changes to (and then hangs at):
>
> The job has been enqueued! It will be processed as soon as possible.
> 0% Not started
> View detail of the enqueued job
>
> Clicking on "View detail of the enqueued job" I see:
>
> Details of job #22
>
> Job ID: 22
> Status:New
> Progress:0 / 0
> Type:Staged MARC records for import
> Queued:03/02/2023 05:42
> Started:
> Ended:
>
> Report
> Detailed messages
> Return to the job list
>
> The corresponding entry in mariadb is:
>
> id 22
> status new
> progress NULL
> size 0
> borrowernumber 1
> type stage_marc_for_import
> queue Name of the queue the job is sent to long_tasks
> data {"encoding":"UTF-8","comments":"","basket_id":null...
> context JSON-serialized context information for the job
> {"flags":1,"branch":"ALMA","interface":"intranet",...
> enqueued_on 2023-03-02 05:42:33
> started_on NULL
> ended_on NULL
>
> (If you need to see the full entries for "data" and "context", please let
> me know.)
>
> tmp, koha_upload, and lock directories have been tweaked and fine tuned. I
> was getting early warnings about them not being set in koha-conf.xml so I
> created them (and set correct permissions) and I can see the uploaded file
> (for job 22 the name is 2287629673fb980ad4102f62ebeaa1b9_bib.mrc), so the
> actual upload function appears to be working.
>
> I am getting no apache errors and no other on-screen diagnostics.
>
> I have Koha 22.05.02.000 running on Arch Linux that imports this file just
> fine. Similarly, I have Koha latest running on a Debian VM that can import
> this file just fine, too.
>
> What am I missing?
>
> Details of my system:
>
> Koha version: 22.11.03.000 Rosalie
> OS version ('uname -a'): Linux alma 5.14.0-162.12.1.el9_1.x86_64 #1 SMP
> PREEMPT_DYNAMIC Mon Jan 23 14:51:52 EST 2023 x86_64
> Perl interpreter: /usr/bin/perl
> Perl version: 5.032001
> Perl @INC: /usr/share/koha/lib
> /usr/local/lib64/perl5/5.32
> /usr/local/share/perl5/5.32
> /usr/lib64/perl5/vendor_perl
> /usr/share/perl5/vendor_perl
> /usr/lib64/perl5
> /usr/share/perl5
> /var/lib/koha/plugins
> MySQL version: mysql Ver 15.1 Distrib 10.5.16-MariaDB, for Linux (x86_64)
> using EditLine wrapper
> Apache version: Server version: Apache/2.4.53 (AlmaLinux) Server built: Jul
> 20 2022 00:00:00
> Memcached: Servers: 127.0.0.1:11211 | Namespace: KOHA | Status: running. |
> Config read from: koha-conf.xml
> Zebra version: Zebra 2.2.7 (C) 1994-2023, Index Data Zebra is free
> software, covered by the GNU General Public License, and you are welcome to
> change it and/or distribute copies of it under certain conditions. SHA1 ID:
> ac40f289672405a299436d73c1532f9906774cc6 Using ICU
> Zebra status: Running
> Message broker: Using RabbitMQ
> Date and time: 03/01/2023 16:20
> Time zone: Used: America/Chicago | Config: Undefined | Environment (TZ):
> Undefined
>
> Thanks,
> Michael
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

Koha mailing list

[Koha] Clarification sought on koha-create options

2023-03-02 Thread David Liddle 
Hello! I'm interested in learning more about the following options for
the command koha-create:

  --defaultsql some.sql Specify a default SQL file to be loaded on the DB.
  --configfile cfg_file Specify an alternate config file for
reading default values.

Could these be used in the creation of an instance that is essentially
a clone of another one, for which koha-dump was used with the option
--without-db-name? I'd like to have a smooth way to create instances
in which our librarians can experiment with ideas and features.

Thank you!
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [EXTERNAL] Adding ebook records to koha

2023-03-02 Thread King, Fred 
You do if you want Export data (on the Tools page) to work. You don't need any 
unique information such as a barcode, so you can add the field with MarcEdit. 
This is what mine looks like:

=952  \\$00$10$40$70$8EBOOK$aWHC$bWHC$d2022-11-01$r2022-11-01$w2022-11-01$yEBOOK

We have the R2 library from Rittenhouse, which limits access to three uses. 
(Good for books that one person needs for a short time.) Item type is R2:

=952  \\$00$10$40$70$8R2$aWHC$bWHC$d2022-11-01$r2022-11-01$w2022-11-01$yR2
=856  40$zLimit: 3 uses of this link. If access has expired, please contact the 
Librarian

Change the dates.

Fred King, MSLS, AHIP
Medical Librarian, MedStar Washington Hospital Center
fred.k...@medstar.net
202-877-6670
ORCID -0001-5266-0279
MedStar Authors Catalog: http://medstarauthors.org

You know it's cold outside when you go outside and it's cold.
--NPS Twitter

-Original Message-
From: Koha  On Behalf Of Thomas Vealehse
Sent: Thursday, March 2, 2023 6:47 AM
To: koha@lists.katipo.co.nz
Subject: [EXTERNAL] [Koha] Adding ebook records to koha



**ATTENTION: This email originated from outside the MedStar Health network.
 ** DO NOT CLICK links or attachments unless you recognize the sender and know 
the content is safe.

 

I am interested in the practice for adding ebooks marc records to koha.
In particular, are items records added too?
Is it necessary to have a 952 field?

Thanks
Thomas Veale
___

Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

--
MedStar Health is a not-for-profit, integrated healthcare delivery system, the 
largest in Maryland and the Washington, D.C., region. Nationally recognized for 
clinical quality in heart, orthopedics, cancer and GI.

IMPORTANT: This e-mail (including any attachments) may contain information that 
is private, confidential, or protected by attorney-client or other privilege. 
If you received this e-mail in error, please delete it from your system without 
copying it and notify sender by reply e-mail, so that our records can be 
corrected... Thank you.

Help conserve valuable resources - only print this email if necessary.


___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Background job / Staging MARC import stuck at 0%

2023-03-02 Thread Michael Brown 
Greetings:

My name is Michael Brown and I am a professional cataloger and SirsiDynix
System Admin at the Texas State Library & Archives in Austin (20+ years
now). I have been using Koha on Arch Linux in my home library for about a
year now. I am migrating my home server to AlmaLinux and I'm having a
problem.

I am running Koha 22.11.03.000 Rosalie on AlmaLinux 9.1. Staging a MARC
file for import gets stuck at 0%. On screen, I am able to select the file
for import (bib.mrc), review the profile options (but I don't change any
defaults), and then click on "Stage for import" at the bottom. Next screen
reads:

The job has been enqueued! It will be processed as soon as possible.
0%
View detail of the enqueued job

After a few seconds, it changes to (and then hangs at):

The job has been enqueued! It will be processed as soon as possible.
0% Not started
View detail of the enqueued job

Clicking on "View detail of the enqueued job" I see:

Details of job #22

Job ID: 22
Status:New
Progress:0 / 0
Type:Staged MARC records for import
Queued:03/02/2023 05:42
Started:
Ended:

Report
Detailed messages
Return to the job list

The corresponding entry in mariadb is:

id 22
status new
progress NULL
size 0
borrowernumber 1
type stage_marc_for_import
queue Name of the queue the job is sent to long_tasks
data {"encoding":"UTF-8","comments":"","basket_id":null...
context JSON-serialized context information for the job
{"flags":1,"branch":"ALMA","interface":"intranet",...
enqueued_on 2023-03-02 05:42:33
started_on NULL
ended_on NULL

(If you need to see the full entries for "data" and "context", please let
me know.)

tmp, koha_upload, and lock directories have been tweaked and fine tuned. I
was getting early warnings about them not being set in koha-conf.xml so I
created them (and set correct permissions) and I can see the uploaded file
(for job 22 the name is 2287629673fb980ad4102f62ebeaa1b9_bib.mrc), so the
actual upload function appears to be working.

I am getting no apache errors and no other on-screen diagnostics.

I have Koha 22.05.02.000 running on Arch Linux that imports this file just
fine. Similarly, I have Koha latest running on a Debian VM that can import
this file just fine, too.

What am I missing?

Details of my system:

Koha version: 22.11.03.000 Rosalie
OS version ('uname -a'): Linux alma 5.14.0-162.12.1.el9_1.x86_64 #1 SMP
PREEMPT_DYNAMIC Mon Jan 23 14:51:52 EST 2023 x86_64
Perl interpreter: /usr/bin/perl
Perl version: 5.032001
Perl @INC: /usr/share/koha/lib
/usr/local/lib64/perl5/5.32
/usr/local/share/perl5/5.32
/usr/lib64/perl5/vendor_perl
/usr/share/perl5/vendor_perl
/usr/lib64/perl5
/usr/share/perl5
/var/lib/koha/plugins
MySQL version: mysql Ver 15.1 Distrib 10.5.16-MariaDB, for Linux (x86_64)
using EditLine wrapper
Apache version: Server version: Apache/2.4.53 (AlmaLinux) Server built: Jul
20 2022 00:00:00
Memcached: Servers: 127.0.0.1:11211 | Namespace: KOHA | Status: running. |
Config read from: koha-conf.xml
Zebra version: Zebra 2.2.7 (C) 1994-2023, Index Data Zebra is free
software, covered by the GNU General Public License, and you are welcome to
change it and/or distribute copies of it under certain conditions. SHA1 ID:
ac40f289672405a299436d73c1532f9906774cc6 Using ICU
Zebra status: Running
Message broker: Using RabbitMQ
Date and time: 03/01/2023 16:20
Time zone: Used: America/Chicago | Config: Undefined | Environment (TZ):
Undefined

Thanks,
Michael
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Adding ebook records to koha

2023-03-02 Thread Thomas Vealehse 
I am interested in the practice for adding ebooks marc records to koha.
In particular, are items records added too?
Is it necessary to have a 952 field?

Thanks
Thomas Veale
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [EXTERNAL] Re: Another XSLT question: adding a line break between multiple names

2023-03-02 Thread Bruns, Anke 
Hi,

as I have a similar issue, I've been trying any versions of a line break I - 
and the internet - could come up with (, , ,  \A and several 
codes between a "&" and a ";". None of them worked, when written in the xsl 
file directly; but I may have done something wrong there.

What works well is to define a CSS class within the xsl (if not already 
existent) and then add the line break with a CSS statement in the OPACUserCSS 
or IntranetUserCSS, like this:

.sub_title::before {
  content: "\A";
  white-space: pre;
  }

... sub_title being the CSS class we added for tag 245$b. It also worked with 
an already existent class like holdings_note_data (tag 866).

Hope this helps.

Best regards,
Anke



--
Anke Bruns M.A. (LIS)
Arbeitsgruppe "Anwendungs- und Informationssysteme"
E-Mail: anke.br...@gwdg.de
---
Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG)
Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de

Support: Tel.: +49 551 39-3, URL: https://gwdg.de/support
Sekretariat: Tel.: +49 551 39-30001, E-Mail: g...@gwdg.de

Geschäftsführer: Prof. Dr. Ramin Yahyapour
Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger
Sitz der Gesellschaft: Göttingen
Registergericht: Göttingen, Handelsregister-Nr. B 598
---
Zertifiziert nach ISO 9001
---



> -Ursprüngliche Nachricht-
> Von: Koha  Im Auftrag von Fridolin SOMERS
> Gesendet: Donnerstag, 2. März 2023 06:25
> An: koha@lists.katipo.co.nz
> Betreff: Re: [Koha] [EXTERNAL] Re: Another XSLT question: adding a line break
> between multiple names
>
> Note the ending /
> Tags generated by XSLT must be XTML so no  alone, 
> Otherwise you may do this with  tags and some CSS
>
> Best regards,
>
> Le 24/02/2023 à 08:01, King, Fred a écrit :
> > Yep, that worked. I probably just *thought* I’d tried that.
> >
> > Thanks,
> >
> > --Fred
> >
> > From: Coehoorn, Joel 
> > Sent: Thursday, February 23, 2023 12:02 PM
> > To: King, Fred 
> > Cc: koha-US list ; koha 
> > Subject: [EXTERNAL] Re: [Koha] Another XSLT question: adding a line break
> between multiple names
> >
> >
> > **ATTENTION: This email originated from outside the MedStar Health
> network.
> > ** DO NOT CLICK links or attachments unless you recognize the sender and
> know the content is safe.
> >
> >
> >
> > Try replacing all this:
> >
> >  | 
> >
> > with this:
> >
> > 
> >
> > Joel Coehoorn
> > Director of Information Technology
> > York University
> > Office: 402-363-5603 | jcoeho...@york.edu |
> york.edu
> >
> >
> > On Wed, Feb 22, 2023 at 5:05 PM King, Fred
> mailto:fred.k...@medstar.net>> wrote:
> > Hi everyone,
> >
> > I have another XLST question that I haven't been able to figure out: I'm 
> > using
> the 700 field for authors, and I want to start additional authors on a new 
> line
> instead of separating them by |.
> >
> > This is what I have now:
> >
> >  
> > 
> > 
> > 
> > MedStar authors: 
> > 
> > 
> >/cgi-bin/koha/opac-
> search.pl?q=au:" select="marc:subfield[@code='a']"/>" select="marc:subfield[@code='a']"/>
> > name="href">/cgi-bin/koha/opac-search.pl?q=au search.pl?q=au>:" select="marc:subfield[@code='b']"/>",
> 
> > name="href">/cgi-bin/koha/opac-search.pl?q=au search.pl?q=au>:" select="marc:subfield[@code='c']"/>",
> 
> >class="separator"> | 
> > 
> > 
> > 
> >
> > And it shows on the OPAC details page the way it should:
> > Arthur, King, field_b, field_c | Doyle, Arthur Conan | Arthur, Chester 
> > Alan,
> field_b | Murray, Arthur, field_c
> >
> > But what I'd really like is this:
> > Arthur, King, field_b, field_c
> > Doyle, Arthur Conan
> > Arthur, Chester Alan, field_b
> >Murray, Arthur, field_c
> >
> > Nothing I've tried so far has worked. Any suggestions?
> >
> > Thanks!
> >
> > --Fred
> >
> > Fred King, MSLS, AHIP
> > Medical Librarian, MedStar Washington Hospital Center
> > fred.k...@medstar.net
> > 202-877-6670
> > ORCID -0001-5266-0279
> > MedStar Authors Catalog: http://medstarauthors.org
> >
> > You know it's cold outside when you go outside and it's cold.
> > --NPS Twitter
> >
> > --
> > MedStar Health is a not-for-profit, integrated healthcare delivery system, 
> > the
> largest in Maryland and the Washington, D.C., region. Nationally recognized 
> for
> clinical quality in heart, orthopedics, cancer and GI.
> >
> > IMPORTANT: This e-mail (including any attachments) may contain information
> that is private, confidential, or protected by attorney-client or other 
>

Re: [Koha] Koha Export Data Options

2023-03-02 Thread Ms. Naveen Ali 
Hi.

Sorry for the incomplete information I am using Koha 22.05

Error log shows
[Thu Mar 02 13:00:04.468545 2023] [cgi:error] [pid 40831] [client
192.168.14.235:63827] AH01215: Use of uninitialized value $record_type in
string eq at /usr/share/koha/intranet/cgi-bin/tools/export.pl line 43.:
/usr/share/koha/intranet/cgi-bin/tools/export.pl, referer:
http://192.168.14.237:8001/cgi-bin/koha/tools/tools-home.pl

Thanks.

*With best regards,*

*Naveen Ali*

**
*ITM-JE (EAKL)*
*Inst Representative for *
*HEC Digital Library Resources.*
*NEDUET, Karachi.*



 --
> *From: *"Jonathan Druart" 
> *To: *"Ms. Naveen Ali" 
> *Cc: *"Koha" 
> *Sent: *Thursday, 2 March, 2023 12:43:55 PM
> *Subject: *Re: [Koha] Koha Export Data Options
>
> Hi,
>
> Which version of Koha?
>
> Do you see an error in the Koha log files?
>
> Regards,
> Jonathan
>
> Le mer. 1 mars 2023 à 11:32, Ms. Naveen Ali  a
> écrit :
>
>> Dear All,
>>
>> I use Koha Tools-> Export Data->Export Database Option to download dump
>> of Koha database.
>>
>> I have a large database with over 15 books and 8,000 patron records.
>> The dump was a large file around 400MB.
>>
>> Suddenly the dump file now generated is just 1KB.
>>
>> Sharing contents of file
>> 
>>
>> -- MySQL dump 10.13 Distrib 8.0.32, for Linux (x86_64)
>> --
>> -- Host: localhost Database: koha_library
>> -- --
>> -- Server version 8.0.32-0ubuntu0.20.04.2
>>
>> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
>> /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
>> /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
>> /*!50503 SET NAMES utf8mb4 */;
>> /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
>> /*!40103 SET TIME_ZONE='+00:00' */;
>> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
>> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
>> FOREIGN_KEY_CHECKS=0 */;
>> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
>> */;
>> /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
>>
>> -
>>
>>
>> No data in the file. I can't understand the reason for this. Can you
>> please help.
>>
>> With best regards,
>>
>> Naveen Ali
>>
>> ITM-JE (EAKL)
>> Inst Representative for
>> HEC Digital Library Resources.
>> NEDUET, Karachi.
>>
>>
>> ___
>>
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha Export Data Options

2023-03-02 Thread Jonathan Druart 
Please reply to the list.

Which exact version of Koha? 22.05.XX? It is missing the last part.

Le jeu. 2 mars 2023 à 09:01, Ms. Naveen Ali  a écrit :

> Hi.
> Sorry for the incomplete information I am using Koha 22.05
>
> Error log shows
>
> [Thu Mar 02 13:00:04.468545 2023] [cgi:error] [pid 40831] [client
> 192.168.14.235:63827] AH01215: Use of uninitialized value $record_type in
> string eq at /usr/share/koha/intranet/cgi-bin/tools/export.pl line 43.:
> /usr/share/koha/intranet/cgi-bin/tools/export.pl, referer:
> http://192.168.14.237:8001/cgi-bin/koha/tools/tools-home.pl
>
> Thanks.
>
> *With best regards,*
>
> *Naveen Ali*
>
> **
> *ITM-JE (EAKL)*
> *Inst Representative for *
> *HEC Digital Library Resources.*
> *NEDUET, Karachi.*
>
>
>
> --
> *From: *"Jonathan Druart" 
> *To: *"Ms. Naveen Ali" 
> *Cc: *"Koha" 
> *Sent: *Thursday, 2 March, 2023 12:43:55 PM
> *Subject: *Re: [Koha] Koha Export Data Options
>
> Hi,
>
> Which version of Koha?
>
> Do you see an error in the Koha log files?
>
> Regards,
> Jonathan
>
> Le mer. 1 mars 2023 à 11:32, Ms. Naveen Ali  a
> écrit :
>
>> Dear All,
>>
>> I use Koha Tools-> Export Data->Export Database Option to download dump
>> of Koha database.
>>
>> I have a large database with over 15 books and 8,000 patron records.
>> The dump was a large file around 400MB.
>>
>> Suddenly the dump file now generated is just 1KB.
>>
>> Sharing contents of file
>> 
>>
>> -- MySQL dump 10.13 Distrib 8.0.32, for Linux (x86_64)
>> --
>> -- Host: localhost Database: koha_library
>> -- --
>> -- Server version 8.0.32-0ubuntu0.20.04.2
>>
>> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
>> /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
>> /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
>> /*!50503 SET NAMES utf8mb4 */;
>> /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
>> /*!40103 SET TIME_ZONE='+00:00' */;
>> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
>> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
>> FOREIGN_KEY_CHECKS=0 */;
>> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
>> */;
>> /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
>>
>> -
>>
>>
>> No data in the file. I can't understand the reason for this. Can you
>> please help.
>>
>> With best regards,
>>
>> Naveen Ali
>>
>> ITM-JE (EAKL)
>> Inst Representative for
>> HEC Digital Library Resources.
>> NEDUET, Karachi.
>>
>>
>> ___
>>
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha