Re: [Koha] [EXTERNAL] Re: Prevent specific MARC field from being duplicated?

[Bales (US), Tasha R]

Thank you so much for this information!

Tasha Bales
Product Standards Office | Technical Order Service Center
(480) 509-5415


-Original Message-
From: Koha  On Behalf Of Katrin Fischer
Sent: Saturday, January 13, 2024 10:33 AM
To: koha@lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] Prevent specific MARC field from being 
duplicated?

EXT email: be mindful of links/attachments.



Hi Tasha,

at the moment it's not possible to specify which fields not to copy. But there 
is a bug report requesting this functionality that you could comment on:

*Bug 26071*
<https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26071> - Allow to 
configure fields not to be copied when using "Edit as new (duplicate)" in 
cataloging

Hope this helps,

Katrin

On 03.01.24 16:06, Bales (US), Tasha R wrote:
> Hello, I have not yet found the answer to this question.  We are still 
> running 21.05, but plan to upgrade soon (unsure to what release).
>
> When duplicating a bibliographic record, is it possible to NOT duplicate a 
> specific MARC field from the source record?
>
> In particular, I'd like to avoid duplicating action notes that are in the 583 
> field.  We use dated action notes, and we duplicate lots of records, and 
> information in source records that is not applicable to target records is 
> being saved to them by mistake.
>
> Our use of the field is as follows:  583$a has a default value.  583$c uses 
> the dateaccessioned.pl plugin to enable a date picker/calendar.
>
> Is there a way to "block" certain fields from being duplicated?  Although we 
> could train staff to delete that field with every duplication, I'd prefer to 
> avoid human error and the additional keystrokes.
>
> Thanks in advance for all ideas.  If a JavaScript/jQuery solution is 
> possible, maybe that would work, but I'm not sure how to make it happen.
>
> Tasha Bales
>
>
> ___
>
> Koha mailing listhttp://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] Prevent specific MARC field from being duplicated?

[Bales (US), Tasha R]

Hello, I have not yet found the answer to this question.  We are still running 
21.05, but plan to upgrade soon (unsure to what release).

When duplicating a bibliographic record, is it possible to NOT duplicate a 
specific MARC field from the source record?

In particular, I'd like to avoid duplicating action notes that are in the 583 
field.  We use dated action notes, and we duplicate lots of records, and 
information in source records that is not applicable to target records is being 
saved to them by mistake.

Our use of the field is as follows:  583$a has a default value.  583$c uses the 
dateaccessioned.pl plugin to enable a date picker/calendar.

Is there a way to "block" certain fields from being duplicated?  Although we 
could train staff to delete that field with every duplication, I'd prefer to 
avoid human error and the additional keystrokes.

Thanks in advance for all ideas.  If a JavaScript/jQuery solution is possible, 
maybe that would work, but I'm not sure how to make it happen.

Tasha Bales


___

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: Ideas wanted for cataloging QA utilities

[Bales (US), Tasha R]

Thanks for your input, Alvaro.  I'm not as good with jQuery as I would like to 
be.  I will give this more thought as to when I would run a cron so as to give 
the cataloger time to finish cataloging, avoid inundating people with email, 
etc.  Thanks!


Tasha Bales


From: Alvaro Cornejo 
Sent: Thursday, November 3, 2022 07:45
To: Carlos Lopez 
Cc: Bales (US), Tasha R ; koha@lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] Ideas wanted for cataloging QA utilities
Importance: High


EXT email: be mindful of links/attachments.




Hi Tasha

If you need to do "real time" checking/validation , you need to use 
JQuery/Javascript to insert code at the data input capture field, similar as 
when you enable fields prefill. You will need to add specific code for each 
field you want to validate.

An option would be to have a cron that runs a field validator script that 
issues an error/issues report on a periodic basis. I guess this will be easier 
to maintain/update but will need to have someone correct/edit issues found.

Not sure it would be possible to combine those options in a way that the JQuery 
could run the validation script during field input.

Regards

Alvaro

||
[https://ci3.googleusercontent.com/mail-sig/AIorK4zO0f8Z21m2X0jK3RWGktD8bapLQbsF7Zq7ukeIuapEB3QMlgOXKzxbFPpUQzsex8cwRRihwVw]
 Stay safe / Cuídate/  Reste sécurisé
7 Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à mesure.
 q Recycle always / Recicla siempre / Recyclez toujours
 P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez 
seulement si nécessaire


Le mer. 2 nov. 2022 à 19:12, Carlos Lopez 
mailto:clo...@dml.vic.edu.au>> a écrit :
Hi Tasha

Bite your tongue! Fixing errors in old records kept me busy during the 2020 
lockdowns!

Honestly I think this would be a good idea, even if the interface only showed 
some kind of alert according to a (predefined) set of rules. The MARCEdit 
MARCValidator is a good example (it even reports on invalid tag indicators). As 
you say, we can always write SQL reports to pull individual (repeated) errors, 
but it would be nice to spot these 'live' too.

With kind regards from the Dalton McCaughey Library Team

Carlos Lopez

Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052
Ph: 03 9340  ext.1 | libr...@dml.vic.edu.au<mailto:libr...@dml.vic.edu.au> 
| library.dmlibrary.org.au<http://library.dmlibrary.org.au>

-Original Message-
From: Koha 
mailto:koha-boun...@lists.katipo.co.nz>> On 
Behalf Of Bales (US), Tasha R
Sent: Thursday, 3 November 2022 1:05 AM
To: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>
Subject: [Koha] Ideas wanted for cataloging QA utilities

CAUTION: This email originated from outside of the organization. Do not click 
links or open attachments unless you recognize the sender and know the content 
is safe.


Good morning,

I'm interested to know if anyone has developed tools to help copy catalogers 
quality check their work in real time.

For example, at a long-ago conference, I saw a librarian present Windows batch 
scripts they'd created to check cataloging in Millennium.  I don't recall the 
specifics, but for my purposes, I'd be interested in doing checks such as the 
following:


  *   Compare 260 to 008
  *   Check for the presence or absence of important fields in both bib and 
item record
  *   Check for agreement between item type and notforloan value

I could do the above with SQL, but I'm trying to get closer to first-time 
quality by catching the errors as they occur (maybe I could use jQuery to link 
a prebuilt report that would check the bib I'm currently viewing?).

Options might be Jupyter notebooks, or jQuery.  This is my first time working 
with a staff client that is a web application, so I'm not sure what is 
realistically possible or what anyone has already come up with (Google is not 
helping).

Any food for thought is welcome.  Even if I only "caught" errors such as 
impossible publication dates (e.g., 2039, 202, etc.), that would be a help.

Thanks for your time and consideration,


Tasha Bales


___

Koha mailing list  
https://urldefense.com/v3/__http://koha-community.org__;!!DVrgiXjqvl2yLjg!ZWXEShPXQpMgfNVPNXBmLGI1jXVHXieyFdvpzDpP9v1W5YBw2ROfyN_Un9bLWiEWrRktJE-VEiEVkXRKnleTpherYdgH$<https://urldefense.com/v3/__http:/koha-community.org__;!!DVrgiXjqvl2yLjg!ZWXEShPXQpMgfNVPNXBmLGI1jXVHXieyFdvpzDpP9v1W5YBw2ROfyN_Un9bLWiEWrRktJE-VEiEVkXRKnleTpherYdgH$>
Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz>
Unsubscribe: 
https://urldefense.com/v3/__https://lists.katipo.co.nz/mailman/listinfo/koha__;!!DVrgiXjqvl2yLjg!ZWXEShPXQpMgfNVPNXBmLGI1jXVHXieyFdvpzDpP9v1W5YBw2ROfyN_Un9bLWiEWrRktJE-VEiEVkXRKnleTplSiTy28$<https://urldefense.com/v3/__ht

Re: [Koha] Ideas wanted for cataloging QA utilities

[Bales (US), Tasha R]

Thanks Carlos!  I guess I just need to find the time to work on this idea, and 
will probably do a combination of real-time checking and reports.  At least 
it's easy to avoid leaving mandatory fields blank in Koha!


Tasha Bales


-Original Message-
From: Carlos Lopez  
Sent: Wednesday, November 2, 2022 17:12
To: Bales (US), Tasha R ; koha@lists.katipo.co.nz
Subject: [EXTERNAL] RE: Ideas wanted for cataloging QA utilities

EXT email: be mindful of links/attachments.



Hi Tasha

Bite your tongue! Fixing errors in old records kept me busy during the 2020 
lockdowns!

Honestly I think this would be a good idea, even if the interface only showed 
some kind of alert according to a (predefined) set of rules. The MARCEdit 
MARCValidator is a good example (it even reports on invalid tag indicators). As 
you say, we can always write SQL reports to pull individual (repeated) errors, 
but it would be nice to spot these 'live' too.

With kind regards from the Dalton McCaughey Library Team

Carlos Lopez

Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052
Ph: 03 9340  ext.1 | libr...@dml.vic.edu.au | library.dmlibrary.org.au 

-Original Message-
From: Koha  On Behalf Of Bales (US), Tasha R
Sent: Thursday, 3 November 2022 1:05 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] Ideas wanted for cataloging QA utilities

CAUTION: This email originated from outside of the organization. Do not click 
links or open attachments unless you recognize the sender and know the content 
is safe.


Good morning,

I'm interested to know if anyone has developed tools to help copy catalogers 
quality check their work in real time.

For example, at a long-ago conference, I saw a librarian present Windows batch 
scripts they'd created to check cataloging in Millennium.  I don't recall the 
specifics, but for my purposes, I'd be interested in doing checks such as the 
following:


  *   Compare 260 to 008
  *   Check for the presence or absence of important fields in both bib and 
item record
  *   Check for agreement between item type and notforloan value

I could do the above with SQL, but I'm trying to get closer to first-time 
quality by catching the errors as they occur (maybe I could use jQuery to link 
a prebuilt report that would check the bib I'm currently viewing?).

Options might be Jupyter notebooks, or jQuery.  This is my first time working 
with a staff client that is a web application, so I'm not sure what is 
realistically possible or what anyone has already come up with (Google is not 
helping).

Any food for thought is welcome.  Even if I only "caught" errors such as 
impossible publication dates (e.g., 2039, 202, etc.), that would be a help.

Thanks for your time and consideration,


Tasha Bales


___

Koha mailing list  
https://urldefense.com/v3/__http://koha-community.org__;!!DVrgiXjqvl2yLjg!ZWXEShPXQpMgfNVPNXBmLGI1jXVHXieyFdvpzDpP9v1W5YBw2ROfyN_Un9bLWiEWrRktJE-VEiEVkXRKnleTpherYdgH$
Koha@lists.katipo.co.nz
Unsubscribe: 
https://urldefense.com/v3/__https://lists.katipo.co.nz/mailman/listinfo/koha__;!!DVrgiXjqvl2yLjg!ZWXEShPXQpMgfNVPNXBmLGI1jXVHXieyFdvpzDpP9v1W5YBw2ROfyN_Un9bLWiEWrRktJE-VEiEVkXRKnleTplSiTy28$
___

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

[Koha] Ideas wanted for cataloging QA utilities

[Bales (US), Tasha R]

Good morning,

I'm interested to know if anyone has developed tools to help copy catalogers 
quality check their work in real time.

For example, at a long-ago conference, I saw a librarian present Windows batch 
scripts they'd created to check cataloging in Millennium.  I don't recall the 
specifics, but for my purposes, I'd be interested in doing checks such as the 
following:


  *   Compare 260 to 008
  *   Check for the presence or absence of important fields in both bib and 
item record
  *   Check for agreement between item type and notforloan value

I could do the above with SQL, but I'm trying to get closer to first-time 
quality by catching the errors as they occur (maybe I could use jQuery to link 
a prebuilt report that would check the bib I'm currently viewing?).

Options might be Jupyter notebooks, or jQuery.  This is my first time working 
with a staff client that is a web application, so I'm not sure what is 
realistically possible or what anyone has already come up with (Google is not 
helping).

Any food for thought is welcome.  Even if I only "caught" errors such as 
impossible publication dates (e.g., 2039, 202, etc.), that would be a help.

Thanks for your time and consideration,


Tasha Bales


___

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: Thesaurus not working for "used for/see from"

[Bales (US), Tasha R]

Thank you. I appreciate your replies. Unfortunately I already had that 
preference enabled since we first installed Koha and we’ve reindexed a few 
times since then. We use a Elasticsearch and I did note that the 450 was not 
indexed, but not sure it needed to be. I did index it as both, If I remember 
correctly since I’m having computer issues right now, a “match” and “see from 
match”.  After reindexing bibs and authorities that didn’t seem to have any 
effect on OPAC search, but it did I think have an effect on being able to 
search for terms using the authority browse. Maybe we just have something weird 
with our installation. I don’t think there’s anything else I can figure out to 
do.

Tasha 

> On Aug 21, 2022, at 20:11, Tomas Cohen Arazi  wrote:
> 
> EXT email: be mindful of links/attachments.
> 
> 
> 
> Enabling the syspref requires a full reindex, BTW.
> 
> Good luck
> 
>> El dom, 21 ago 2022 a las 7:34, Katrin Fischer ()
>> escribió:
>> 
>> Hi Tasha,
>> 
>> see from headings are not automatically included in catalog searches.
>> Have a look at the IncludeSeeFromInSearches system preference.
>> 
>> Hope this helps,
>> 
>> Katrin
>> 
>> ||
>> 
>>> On 09.08.22 22:40, Bales (US), Tasha R wrote:
>>> Good afternoon, I'm looking for tips to solve an authority record
>> problem.
>>> 
>>> I noticed that none of my "used for/see from" headings are hyperlinked
>> when I browse authorities in Koha.  If I attempt a search for one of these
>> unlinked terms, no results are found-the thesaurus isn't working.  Surely,
>> something must be wrong with the MARC authority record, but I'm not sure
>> what and I'm looking for suggestions!
>>> 
>>> I load authorities, but don't maintain them.  I'm not sure what the
>> problem could be, after comparing to the MARC standard for authorities and
>> a couple examples in OCLC.  These records functioned fine in Millennium.
>> Does Koha expect/require additional metadata to make these metadata
>> searchable?  Perhaps it is a Global System Preference that is incorrect?
>>> 
>>> Here is an example of a record I just loaded from OCLC, below.  My
>> expectation is that if I search my OPAC subject index for a phrase that is
>> in one of the 450's below, I should retrieve any bib records with a 650
>> field that contains "Brined cheeses", but no results are found.  Maybe I am
>> completely misunderstanding how authority records work?
>>> 
>>> 000
>>> 
>>> 00675cz a2200217n 4500
>>> 
>>> 001
>>> 
>>> oca02939087
>>> 
>>> 003
>>> 
>>> OCoLC
>>> 
>>> 005
>>> 
>>> 20220809013034.0
>>> 
>>> 008
>>> 
>>> 910306i| anannbabn |a ana
>>> 
>>> 010
>>> 
>>> _ash 91000983
>>> 
>>> 040
>>> 
>>> _aDLC
>>> _cDLC
>>> _dDLC
>>> 
>>> 053
>>> 
>>> 0
>>> 
>>> _aSF272.B76
>>> 
>>> 150
>>> 
>>> _aBrined cheeses
>>> 
>>> 450
>>> 
>>> _aBrine-cured cheeses
>>> 
>>> 450
>>> 
>>> _aWhite brine-cured cheeses
>>> 
>>> 450
>>> 
>>> _aWhite brined cheeses
>>> 
>>> 550
>>> 
>>> _wg
>>> _aCheese
>>> _xVarieties
>>> 
>>> 670
>>> 
>>> _aWork cat.: Feta and related cheeses, 1991
>>> _b(white brined cheeses)
>>> 
>>> 670
>>> 
>>> _aRandom House
>>> _b(feta ... white, brine-cured Greek cheese)
>>> 
>>> 670
>>> 
>>> _aWeb. 3
>>> _b(feta ... white cheese ... cured in brine)
>>> 
>>> 675
>>> 
>>> _aCompletely cheese
>>> 
>>> 
>>> 
>>> 
>>> Tasha Bales
>>> 
>>> 
>>> ___
>>> 
>>> Koha mailing listhttp://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
>> 
> 
> 
> -- 
> Tomás Cohen Arazi
> Theke Solutions (http://theke.io)
> ✆ +54 9351 3513384
> GPG: B2F3C15F
> ___
> 
> 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] [EXTERNAL] Archive search

[Bales (US), Tasha R]

Yes, at the bottom of this page, below, try the "MarkMail archive" or 
"Nabble.com archive" links:

https://koha-community.org/support/koha-mailing-lists/


Tasha Bales




-Original Message-
From: Koha  On Behalf Of kolvir73
Sent: Saturday, August 13, 2022 22:33
To: koha@lists.katipo.co.nz
Subject: [EXTERNAL] [Koha] Archive search

EXT email: be mindful of links/attachments.





⁣​Is there a way to search the mailing list archives besides looking at the 
threads month by month?
___

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] Thesaurus not working for "used for/see from"

[Bales (US), Tasha R]

Good afternoon, I'm looking for tips to solve an authority record problem.

I noticed that none of my "used for/see from" headings are hyperlinked when I 
browse authorities in Koha.  If I attempt a search for one of these unlinked 
terms, no results are found-the thesaurus isn't working.  Surely, something 
must be wrong with the MARC authority record, but I'm not sure what and I'm 
looking for suggestions!

I load authorities, but don't maintain them.  I'm not sure what the problem 
could be, after comparing to the MARC standard for authorities and a couple 
examples in OCLC.  These records functioned fine in Millennium.  Does Koha 
expect/require additional metadata to make these metadata searchable?  Perhaps 
it is a Global System Preference that is incorrect?

Here is an example of a record I just loaded from OCLC, below.  My expectation 
is that if I search my OPAC subject index for a phrase that is in one of the 
450's below, I should retrieve any bib records with a 650 field that contains 
"Brined cheeses", but no results are found.  Maybe I am completely 
misunderstanding how authority records work?

000

00675cz a2200217n 4500

001

oca02939087

003

OCoLC

005

20220809013034.0

008

910306i| anannbabn |a ana

010

_ash 91000983

040

_aDLC
_cDLC
_dDLC

053

0

_aSF272.B76

150

_aBrined cheeses

450

_aBrine-cured cheeses

450

_aWhite brine-cured cheeses

450

_aWhite brined cheeses

550

_wg
_aCheese
_xVarieties

670

_aWork cat.: Feta and related cheeses, 1991
_b(white brined cheeses)

670

_aRandom House
_b(feta ... white, brine-cured Greek cheese)

670

_aWeb. 3
_b(feta ... white cheese ... cured in brine)

675

_aCompletely cheese




Tasha Bales


___

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

[Koha] VM move shut-down/start-up activities?

[Bales (US), Tasha R]

Good afternoon,

My IT department will be migrating my Koha installation from one VM to another. 
 They call this a "lift and shift."  I will not be installing Koha or taking 
special steps to migrate the database, they are just moving it all intact to 
another server, same IP address.

I'd like to ask what shut-down or start-up activities you all might recommend.  
FYI, we are not using the Debian packages; we are on Oracle Linux and Koha 
20.11.

With my old Millennium system, it was customary to shut down both the 
application and Apache before database or server maintenance.  Then, you had to 
start those up after the work was complete.

Any recommendations to shut down anything besides Koha? Plack?  On restart, I 
presume I'll need to start the OCLC Connexion daemon, but that's all I expect 
to have to do at this point; presuming Koha and Plack start up on their own.

Thanks for any input you may have.  We are doing the development server first, 
so hopefully that will reveal any problems.


Tasha Bales




___

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: Public list RSS works, but Private list doesn't?

[Bales (US), Tasha R]

Bummer, as I could really use that feature.  However, I'm glad to know it 
appears to be a bug, so that I can hide the button and avoid unhappy users!  
Thank you.


Tasha Bales
Enterprise Services




-Original Message-
From: Owen Leonard  
Sent: Monday, April 25, 2022 10:48
To: Bales (US), Tasha R 
Cc: koha@lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] Public list RSS works, but Private list doesn't?
Importance: High

EXT email: be mindful of links/attachments.



> However, subscribing to Private lists that I've created in my account do not 
> ever deliver results to my email.

I think you've found a bug. It shouldn't be possible to subscribe to a private 
list because you must be logged in to the OPAC to be able to access them. We 
don't have any mechanism for providing a private RSS feed.

The first step towards fixing it will probably be to hide the RSS button when 
looking at a private list.

 -- Owen

--
Web Developer
Athens County Public Libraries
(740) 737-6006
https://www.myacpl.org
___

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

[Koha] Public list RSS works, but Private list doesn't?

[Bales (US), Tasha R]

Good morning,

I'm writing about RSS for private "My Lists" in the patron OPAC account.

In my system, which is Koha 20.11, I've noticed that I can subscribe to RSS for 
Public lists, and I get immediate results in my email (I'm subscribing via 
Microsoft Outlook).  However, subscribing to Private lists that I've created in 
my account do not ever deliver results to my email.

The XML file looks fine and in fact, and it appears that the same OPAC template 
and script are used to generate both the Public and Private list's RSS.  
Instead, it looks like there is something about the fact that one list is 
Public and one is Private that is preventing my feed reader from getting 
results.  Could this be?  Or maybe it is just my system?

Thanks for any tips you might have.

Tasha Bales



___

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: Biblio_metadata timestamps updating for no reason?

[Bales (US), Tasha R]

Thanks for your reply, Tomas.  No in fact.  The first culprit I suspected was 
link_bibs_to_authorities, but that job was not active.  Maybe I somehow got 
confused or there was something running in the background that I didn’t know to 
look for.


Tasha Bales
Enterprise Services





From: Tomas Cohen Arazi 
Sent: Friday, February 18, 2022 12:35
To: Bales (US), Tasha R 
Cc: koha@lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] Biblio_metadata timestamps updating for no 
reason?
Importance: High


EXT email: be mindful of links/attachments.




Hi, don't you have some cron that might be doing it? Like 
link_bibs_to_authorities.pl<http://link_bibs_to_authorities.pl>?

El vie, 18 feb 2022 a las 12:20, Bales (US), Tasha R 
(mailto:tasha.r.ba...@boeing.com>>) escribió:
Good morning,

I’m seeing updated timestamps in biblio_metadata and I can’t figure out why.  
I’m working on a test system where no updates are taking place, and I am not 
running any jobs to link authorities to bib records, or any other jobs that 
should be updating records.  What could be causing biblio_metadata timestamps 
to be updated?

For example, I see 200 records updated in the last 30 minutes, and in the 
Modification Logs for those records, I don’t see any recent logged actions.  
I’m trying to implement a process that depends on timestamps, and this is 
throwing me off.   I’ve used the “ps aux” and “ps aux | koha” command several 
times, but don’t see anything obvious, though I might not know what to look 
for.  If you have any ideas, thank you in advance!  


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/


___

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


--
Tomás Cohen Arazi
Theke Solutions (http://theke.io<http://theke.io/>)
✆ +54 9351 3513384
GPG: B2F3C15F
___

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

[Koha] Equals sign in a macro?

[Bales (US), Tasha R]

I would like to create a Macro that enters the base of a URL.  However, I find 
that I cannot execute the macro due to errors caused by the use of an equals 
sign.  Curly braces also seem to cause a problem.  I played around trying to 
see if I could escape the problem characters, but didn't get anywhere.  I also 
tried substituting in "" and "" , which I think are HTML codes for 
"=", just in case, but both seem to be ignored and don't make it into the 856 
that is created.

Anyone know of a way around this?  Thanks!


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

___

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

[Koha] Biblio_metadata timestamps updating for no reason?

[Bales (US), Tasha R]

Good morning,

I’m seeing updated timestamps in biblio_metadata and I can’t figure out why.  
I’m working on a test system where no updates are taking place, and I am not 
running any jobs to link authorities to bib records, or any other jobs that 
should be updating records.  What could be causing biblio_metadata timestamps 
to be updated?

For example, I see 200 records updated in the last 30 minutes, and in the 
Modification Logs for those records, I don’t see any recent logged actions.  
I’m trying to implement a process that depends on timestamps, and this is 
throwing me off.   I’ve used the “ps aux” and “ps aux | koha” command several 
times, but don’t see anything obvious, though I might not know what to look 
for.  If you have any ideas, thank you in advance!  


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/


___

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

[Koha] Item fields transposed during import?

[Bales (US), Tasha R]

Good afternoon,

Has anyone ever experienced item fields getting transposed during MARC import 
when multiple items are attached to a bib?  It seems like there is no way this 
could happen except for human error, but I've seen it before and can't figure 
out the error.

Today I noticed that some items have the wrong "Not for loan" status.  I've 
provided details below.  I don't expect anyone to solve this, but if you've 
seen this before and are able to share what the root cause was in your case, 
that would be very helpful.  I'm sorry if I've asked this before.  I distinctly 
remember typing up a similar question months ago, but I think I abandoned the 
draft.  --Thank you.

I loaded this data:
=952  
\\$a1F-15E-25-10$t0$pTUST23257507$cTOSTO$4a$f-$1-$y2$d10-03-31
  (this record should NOT have a Not for Loan)
=952  
\\$a1F-15E-25-10$t3$pTOSTH23247507$cTOST$4a$fn$1-$y2$d14-08-05
  (this record should have Not for Loan "8")
=952  
\\$a1F-15E-25-10$t1$pTOSTH23257506$cTOST$4b$fn$1-$y55$d17-07-10
 (this record should have Not for Loan "8")

I have these lines in my modification template:
-- "Move field 952$f to 952$7 if 952$f matches RegEx m/[cdnw]/"
-- "Update existing or add new field 952$7 with value 8 if 952$7 matches n"

In other words, I move 952$f to $7 and if its value is "n", I change "n" to "8".

My record modification log matches the records and shows that two records have 
their Not for Loan values "swapped".  I've included only the problem records 
below:

item $VAR1 = { 'withdrawn' => 0, 'biblioitemnumber' => '878655', 'restricted' 
=> undef, 'coded_location_qualifier' => undef, 'itemlost_on' => undef, 
'notforloan' => '8', 'replacementpricedate' => '2021-12-11', 'itemnumber' => 
'2309607', 'ccode' => undef, 'itemnotes' => undef, 'location' => 'TOSTO', 
'itemcallnumber' => '1F-15E-25-10', 'stack' => undef, 'itemlost' => 0, 
'barcode' => 'TUST23257507'...

item $VAR1 = { 'withdrawn' => 0, 'biblioitemnumber' => '878655', 'restricted' 
=> undef, 'coded_location_qualifier' => undef, 'itemlost_on' => undef, 
'notforloan' => 0, 'replacementpricedate' => '2021-12-11', 'itemnumber' => 
'2309609', 'ccode' => undef, 'itemnotes' => undef, 'location' => 'TOST', 
'itemcallnumber' => '1F-15E-25-10', 'stack' => undef, 'itemlost' => 0, 
'barcode' => 'TOSTH23257506'...


FYI, the source data is from Millennium.  I've verified that I'm not loading 
any subfields or authorized values that aren't defined in Koha.  I did notice 
that the first record has a copy number of "0", and this gets loaded as a blank 
in Koha.


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

___

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: Where to place RSS xml output?

[Bales (US), Tasha R]

Thank you, Tim.  

I was just messing around and found I was also able to place the file into 
koha/opac/htdocs and access it with a URL like this:  http:// 
mycatalog.com/lastAcquired.xml.  That is fantastic.  A dedicated RSS directory 
like you created would probably be better.

However, the XML file that was created by rss.pl and lastAcquired.tt appears to 
be "malformed" and the book titles are all missing (I didn't alter the 
template; the titles should be included).  I imagine this is the reason 
Jonathan stated that the files should be removed from the codebase.   The 
titles all came out empty like this:  ", by "

Having had a look at the output, it looks like it wouldn't be difficult to 
adapt the existing files or come up with our own solution for building an XML 
that contains the fields we need.  Thanks again for your help!


Tasha Bales 
Enterprise Services
http://isesi.web.boeing.com/



Library Services Catalog upgrade is coming!
For the latest news and FAQ regarding the upgrade, see Library Announcements.
Questions?  Please contact libr...@boeing.com.


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Tim McMahon
Sent: Monday, January 3, 2022 16:35
To: koha@lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] Where to place RSS xml output?

EXT email: be mindful of links/attachments.



I tried this about a year ago.  The only way I found to get it to work (on a 
test server) was to create new directory (I named it rss) in koha/opac/htdocs 
and access it with http://mycatalog.com/rss/file.xml.

On 1/1/22 8:43 PM, Bales (US), Tasha R wrote:
> Good evening,
>
> I've been reviewing the sample templates and configuration files for custom 
> RSS.  On my system, these are installed here:  
> /usr/share/koha/bin/cronjobs/rss.  I'm stuck on where to place the XML that 
> is produced in order to make the output accessible/subscribable via the OPAC.
>
> I've tried placing the XML files into koha/opac/cgi-bin/opac and into 
> koha/opac/cgi-bin/opac/rss.  Then, I tried accessing the files (with 
> permissions set to 755) using the following guesses at URL scheme:
>
> http://mycatalog.com/cgi-bin/koha/lastAcquired.xml (results in a blank 
> page that has only the words "not found" in the upper left) 
> http://mycatalog.com/cgi-bin/koha/rss/lastAcquired.xml (results in 500 
> internal server error) http://mycatalog.com/lastAcquired.xml (results 
> in an Error 404 in the OPAC, "Sorry, the requested page is not 
> available")
>
> I'm sure the issue is a matter of ignorance on my part as to what the best 
> and acceptable locations are for placing "local" files.  I apologize for 
> that, but please know I invested a couple hours before asking.  Thanks in 
> advance if anyone has tips as to where to place the files, and then, how to 
> access them.
>
> Excerpt from lastAcquired.conf:
>
> title=Recent Koha Acquisitions
> link=http://www.koha-community.org (<-- I assume this is supposed to 
> be my catalog URL, and I updated accordingly) desc=The 15 most recent 
> acquisitions ...
> title=Koha, the worlds best Open Source Library System 
> url=http://www.koha-community.org/images/foo.jpg
> link=http://www.koha-community.org
> config
> template=lastAcquired.tt
> output=[here I inserted path to destination folder]/lastAcquired.xml
>
>
> Tasha Bales
> Enterprise Services
> http://isesi.web.boeing.com/
>
>
> ___
>
> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
--
*Tim McMahon*
West Liberty Public Library

319-627-2084

___

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] Where to place RSS xml output?

[Bales (US), Tasha R]

Good evening,

I've been reviewing the sample templates and configuration files for custom 
RSS.  On my system, these are installed here:  
/usr/share/koha/bin/cronjobs/rss.  I'm stuck on where to place the XML that is 
produced in order to make the output accessible/subscribable via the OPAC.

I've tried placing the XML files into koha/opac/cgi-bin/opac and into 
koha/opac/cgi-bin/opac/rss.  Then, I tried accessing the files (with 
permissions set to 755) using the following guesses at URL scheme:

http://mycatalog.com/cgi-bin/koha/lastAcquired.xml (results in a blank page 
that has only the words "not found" in the upper left)
http://mycatalog.com/cgi-bin/koha/rss/lastAcquired.xml (results in 500 internal 
server error)
http://mycatalog.com/lastAcquired.xml (results in an Error 404 in the OPAC, 
"Sorry, the requested page is not available")

I'm sure the issue is a matter of ignorance on my part as to what the best and 
acceptable locations are for placing "local" files.  I apologize for that, but 
please know I invested a couple hours before asking.  Thanks in advance if 
anyone has tips as to where to place the files, and then, how to access them.

Excerpt from lastAcquired.conf:

title=Recent Koha Acquisitions
link=http://www.koha-community.org (<-- I assume this is supposed to be my 
catalog URL, and I updated accordingly)
desc=The 15 most recent acquisitions
...
title=Koha, the worlds best Open Source Library System
url=http://www.koha-community.org/images/foo.jpg
link=http://www.koha-community.org
config
template=lastAcquired.tt
output=[here I inserted path to destination folder]/lastAcquired.xml


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/


___

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

[Koha] opac-user.tt, add pub date?

[Bales (US), Tasha R]

Has anyone tweaked opac-user.tt?  I'd love to swap out the Author column in the 
view of checked out items to Publication Date.  Just checking.  I don't expect 
these are easily tweaked, but you never know.

Thanks for your time,


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/


___

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

[Koha] log4j

[Bales (US), Tasha R]

Is Koha impacted by the log4j issue?

https://www.zdnet.com/article/log4j-zero-day-flaw-what-you-need-to-know-and-how-to-protect-yourself/

The Koha Wiki makes minor use of the characters "log4j" in an article about 
Shibboleth configuration.

Apologies if this is an inappropriate email.  I've been advised to either patch 
or turn my server off this week if there is an impact.   I've found various 
advice suggesting to do x, y, z to see if log4j is installed, then contrary 
advice that suggests that x, y, z may not be adequate.   I am wholly 
unqualified to make inferences, so thought it best to ask the "source".

Thanks.


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/



Library Services Catalog upgrade is coming!
For the latest news and FAQ regarding the upgrade, see Library 
Announcements.
Questions?  Please contact libr...@boeing.com.

___

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: Migrate checkouts with koc file

[Bales (US), Tasha R]

Awesome, thank you!   I was overthinking as usual.  I only have one server 
right now and was afraid I might break something terribly if I winged it.


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/



From: Alvaro Cornejo [mailto:cornejo.alv...@gmail.com]
Sent: Friday, December 10, 2021 11:32
To: Bales (US), Tasha R 
Cc: koha@lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] Migrate checkouts with koc file
Importance: High


EXT email: be mindful of links/attachments.




Hi Tasha

By curiosity I checked the master.koc referred and the only content on it is 
this three tab separated values:

Version=1.0

Generator=koct-firefox

GeneratorVersion=0.1


Hope helps

Regards,

Alvaro


||
[https://drive.google.com/uc?id=1lpgSKUunPpKrvmS1rja7umnEgiqBa_vD=download]
 Stay safe / Cuídate/  Reste sécurisé
7 Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à mesure.
 q Recycle always / Recicla siempre / Recyclez toujours
 P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez 
seulement si nécessaire


Le ven. 10 déc. 2021 à 12:47, Bales (US), Tasha R 
mailto:tasha.r.ba...@boeing.com>> a écrit :
Good morning,

I would like to migrate check-outs from Millennium to Koha.  It just occurred 
to me I could probably do this with offline circulation.  I'm writing to ask 
for help creating a properly formatted .koc file that I can upload.  From the 
web, I've gleaned this is just a delimited text file with a special header and 
a .koc extension.

I am not permitted to install the Firefox or Windows utilities for offline circ 
in order to try to generate an example .koc file.  I see a little info the .koc 
file in the Wiki, but I'm not sure if it is current and comprehensive.  In this 
2019 blog, 
http://kohageek.blogspot.com/2019/09/importing-of-check-out-entries.html, I 
found a link to a template for the .koc file, but it's in Google Drive, where I 
also don't have permission to download from.

In short, is there a way to make my own .koc file from scratch by supplying the 
extension, necessary columns, and required header?  Thanks for your time,


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/



Library Services Catalog upgrade is coming!
For the latest news and FAQ regarding the upgrade, see Library 
Announcements<http://library.web.boeing.com/help/announcements.html>.
Questions?  Please contact 
libr...@boeing.com<mailto:libr...@boeing.com><mailto:libr...@boeing.com<mailto:libr...@boeing.com>>.

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz<mailto: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] Migrate checkouts with koc file

[Bales (US), Tasha R]

Good morning,

I would like to migrate check-outs from Millennium to Koha.  It just occurred 
to me I could probably do this with offline circulation.  I'm writing to ask 
for help creating a properly formatted .koc file that I can upload.  From the 
web, I've gleaned this is just a delimited text file with a special header and 
a .koc extension.

I am not permitted to install the Firefox or Windows utilities for offline circ 
in order to try to generate an example .koc file.  I see a little info the .koc 
file in the Wiki, but I'm not sure if it is current and comprehensive.  In this 
2019 blog, 
http://kohageek.blogspot.com/2019/09/importing-of-check-out-entries.html, I 
found a link to a template for the .koc file, but it's in Google Drive, where I 
also don't have permission to download from.

In short, is there a way to make my own .koc file from scratch by supplying the 
extension, necessary columns, and required header?  Thanks for your time,


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/



Library Services Catalog upgrade is coming!
For the latest news and FAQ regarding the upgrade, see Library 
Announcements.
Questions?  Please contact libr...@boeing.com.

___

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

[Koha] Dynamic XSLT labels based on framework "Text for OPAC"?

[Bales (US), Tasha R]

Good afternoon,

I'd like to check my understanding on MARC frameworks.  In my frameworks, I've 
changed the "Text for OPAC" of various fields, and they display as desired in 
the "MARC view", but not in the "Normal view".  I am sure this is occurring 
because these are local 9xx fields; I had to customize the Detail XSLT to get 
them to show up at all in the OPAC.

My question is... how can I get the XSLT to use the text that is defined in the 
Framework for this record?  For instance, I have several frameworks that 
contain a 926 field, but each framework has a different "Text for OPAC".  Is it 
possible to add a test below?  Just now I tried deleting the label text 
entirely to see what would happen, but Ctrl+f5 and/or trying in a new browser 
doesn't reflect my results (a different mystery I am sometimes flummoxed by).  
As always, if this is too complex a question, even a pointer would help.  
Thanks in advance.

Here is my XSLT (sometimes, "Original Release Date" is correct-other times, 
"Date of Basic" is needed-it all depends on the framework):


Original 
Release Date: 



  

a

   
   

;
 


   


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

___

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

[Koha] Classification rules, manual incomplete, keep hyphens?

[Bales (US), Tasha R]

The section of the Koha manual that describes classification filing rules 
appears to be missing a section.  The portion that describes the respective 
rules for Dewey, generic, LCC, ends abruptly when it gets to LCC, as follows:

"The LCC filing routine generates a sorted call number by following these 
rules: " [no rules are given]

See, 
https://koha-community.org/manual/21.05/en/html/administration.html?highlight=classification#classification-filing-rules

Anyone know what text goes there?  Also, has anyone created custom filing 
rules?  Although I can create a new classification source, it looks like a new 
source can only be an amalgamation of the existing filing and splitting rules.  
What I really need is something that does not remove hyphens.  I'm having a 
heck of time getting numbers like this to sort correctly (they just don't):

1F-15A-1
1F-15A-01 (I'd expect this to be first)
1F-15A-1CL-1
1F-15A-06 (This should go after "-01")
1F-15A-6
1F-15A-6CF-1
1F-15A-17
1F-15A-21
1F-15A-4-6 (I'd really like to see this before "-6")

The above is how they sort in the OPAC using an ascending "Call number" sort.  
Assuming all hyphens are stripped out, I can't make sense of the sort.  
However, I did notice that despite all of these items having classification 
scheme set to "generic", the "Other/Generic Classification Scheme" in Koha 
Administration, Classification sources, showed that the "In use" value for that 
scheme was "No".  I changed it to "Yes", but am not sure what to expect after 
having done so.


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

___

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

[Koha] auto_increment DB issue

[Bales (US), Tasha R]

Good morning,

Per our System Information, we are affected by the DBMS auto_increment issue 
described here: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix.  
We didn't (cannot) install from the Debian packages.

I notice the fix involves setting the next auto_increment number to the 
greatest of either the max biblionumber in biblio or deletedbiblio.  However, 
we have been using the cleanup_database cron job to clean out deletedbiblio.

I'd like to check my understanding.  I think in order for the above fix to 
work, we'd need to stop cleaning deletedbiblio.  Is that right?  Otherwise, I 
think we might have a situation where we delete the last biblio, then clean 
deletedbiblio 10 days later, then on the 11th day, we create a new biblio, 
which would get assigned the same number as the record we'd last deleted.  This 
would probably be rare, as long as we cataloged something before deletedbiblio 
got cleaned out, but I just want to be sure I understand.

Thanks for your time!



Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

___

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

Re: [Koha] Avoiding duplicate items during MARC staging/import

[Bales (US), Tasha R]

I'm writing to retract this question.  I don't think the solution I'm looking 
for (being able to remove and replace all item records during a MARC load) 
exists.

To solve my duplicate item records issue, I plan to delete all items that lack 
barcodes, and reload with barcodes.  I'm in between ILS's and am trying to keep 
Koha in sync with changes made in Millennium, where some records lack barcodes. 
 This is why I cannot use Koha item record number as a match point.

Thank you.

Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

From: Bales (US), Tasha R
Sent: Wednesday, October 27, 2021 11:20
To: koha@lists.katipo.co.nz
Subject: Avoiding duplicate items during MARC staging/import

Is there a cheat sheet for staging and loading MARC records?

I keep getting hung up and am creating duplicate item records during loads, 
despite continuing to read the manual closely, and experimenting with different 
options.

I think my problem is with my expectations (coming from Millennium ILS), and my 
interpretation of the menu options that begin with "Add items..."  I only want 
to add items if they don't already exist.  What I really want to do is to 
replace all 952 fields with the new fields I am loading.  However, in practice, 
the option to "Replace items if matching bib was found (only for existing 
items)" doesn't seem to accomplish this.  If my file is a mix of existing and 
new records, it looks like my new records aren't getting items created, 
presumably because those items didn't already exist.

I don't think it will be useful to share all the scenarios and options I've 
tried.  Just hoping someone else has similarly misinterpreted the instructions 
and may have created a "cheat sheet" for which options to select to avoid 
duplicates.

It may be useful to add that the sample record I am working with at the moment 
has no barcode numbers in any of its attached items.  I'd like to be able to 
reload this MARC record and wipe all the items out, replacing with whatever 
items are in my new MARC file, but my actions so far have only loaded more 
items, resulting in duplicates.

Thanks for your time,


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

___

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

[Koha] Avoiding duplicate items during MARC staging/import

[Bales (US), Tasha R]

Is there a cheat sheet for staging and loading MARC records?

I keep getting hung up and am creating duplicate item records during loads, 
despite continuing to read the manual closely, and experimenting with different 
options.

I think my problem is with my expectations (coming from Millennium ILS), and my 
interpretation of the menu options that begin with "Add items..."  I only want 
to add items if they don't already exist.  What I really want to do is to 
replace all 952 fields with the new fields I am loading.  However, in practice, 
the option to "Replace items if matching bib was found (only for existing 
items)" doesn't seem to accomplish this.  If my file is a mix of existing and 
new records, it looks like my new records aren't getting items created, 
presumably because those items didn't already exist.

I don't think it will be useful to share all the scenarios and options I've 
tried.  Just hoping someone else has similarly misinterpreted the instructions 
and may have created a "cheat sheet" for which options to select to avoid 
duplicates.

It may be useful to add that the sample record I am working with at the moment 
has no barcode numbers in any of its attached items.  I'd like to be able to 
reload this MARC record and wipe all the items out, replacing with whatever 
items are in my new MARC file, but my actions so far have only loaded more 
items, resulting in duplicates.

Thanks for your time,


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

___

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

[Koha] MARC modification templates w/ indicators?

[Bales (US), Tasha R]

Do MARC modification templates support changes based on, or to, MARC indicators?

For instance, I'd like to change all instances of 856 _8 to 956 _ _.  However, 
I don't see a clear way to specify or insert indicators w/ or w/o RegEx.  Are 
the indicators considered part of the field data?

I could do this with MarcEdit, but I'd rather just do it here.  Is MarcEdit the 
only option?

Thanks!!


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

___

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

[Koha] Reason to define Koha item type in 942

[Bales (US), Tasha R]

Good afternoon,

I recall reading (in the Koha manual?) the explanation for why it is 
advantageous to define Koha item type in the bib 942 field.  I believe it has 
to do with exporting records, or the scope of records that is included when 
doing some type of report?  I'm trying to locate that information again, but 
can't find it for the life of me.

Does this seem familiar to anyone?  Thanks.


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

___

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: Reports timing out, prevents access to web interfaces

[Bales (US), Tasha R]

Hi Cab, that is in fact helpful feedback.  I've taken queries that we've used 
for years with Millennium and Oracle, and am rewriting them for Koha and MySQL. 
 So far, MySQL does seem pickier.  I have tried using the "EXPLAIN" command to 
help identify inefficient queries, but it didn't really help.  

One tactic we've tried in the past is to create views containing subsets of 
data that we need to frequently iterate over, to help decrease processing time. 
 Maybe that is an approach we could use here, but I am wary of trying to modify 
our database in any way.  Maybe a last resort.  Thanks again.  


Tasha Bales 
Enterprise Services
http://isesi.web.boeing.com/

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Cab Vinton
Sent: Thursday, October 7, 2021 03:49
To: koha 
Subject: [EXTERNAL] Re: [Koha] Reports timing out, prevents access to web 
interfaces

EXT email: be mindful of links/attachments.



I don't have any particularly helpful advice to offer, unfortunately, but I can 
confirm from personal experience that certain queries can indeed bring your 
system to a crawl. I don't think there's a solution to this unless there's a 
way to firewall report queries from the rest of Koha, or to automatically 
throttle misbehaving processes.

In my case, I'd copied & pasted a report from the wiki, but a change in Koha's 
database structure since the report's creation led to, well, very bad results.

I think your best bet is to take a really close look at the report to see if 
there are ways to achieve the same results more efficiently. In our case, this 
means seeking help from folks who are far more experienced with SQL than we are.

Best of luck!

Cab Vinton, Director
Plaistow Public Library
Plaistow, NH
___

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] [EXTERNAL] Re: Reports timing out, prevents access to web interfaces

[Bales (US), Tasha R]

Thanks for your reply, Chris.  One of our team members posited that there might 
be an issue---or something we can tweak--to decrease the priority of 
Reports/MySQL, so that it isn’t sucking the life out of the rest of the 
application.  We’ll keep investigating.


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

From: Chris Brown [mailto:ch...@stayawake.co.uk]
Sent: Wednesday, October 6, 2021 23:40
To: Bales (US), Tasha R ; koha 

Subject: [EXTERNAL] Re: [Koha] Reports timing out, prevents access to web 
interfaces
Importance: High


EXT email: be mindful of links/attachments.




Hi Tasha,

Since I'm guessing you have access to a Linux command prompt on your server, 
you could try running "top". It would at least confirm if the CPU is saturated, 
and which processes are consuming all the CPU.

Best Regards,

Chris Brown




On Wed, Oct 6, 2021 at 10:32 PM Bales (US), Tasha R 
mailto:tasha.r.ba...@boeing.com>> wrote:
Good afternoon,

I'm experiencing an issue where if I'm working in the staff interface and kick 
off a long-running Report, I'm unable to navigate to or use Koha in any other 
browser tab, or in any other browser, either in the staff or public interface.  
I've confirmed that this affects other users working on their own machines too; 
in other words, my report interrupts their access.

I doubt that this is intended behavior.  I'm going to try to do some 
query-tuning (any suggestions for tools to use to optimize/identify inefficient 
queries?).

Any other ideas to troubleshoot this issue?  I found an old list post that 
suggested the Koha Tuning 
Guide<https://wiki.koha-community.org/wiki/Koha_Tuning_Guide> on the Koha Wiki, 
but it isn't entirely clear to me if it is comprehensive, or if all parts are 
relevant to our issue.  I'm hesitant to blindly start changing values.  Before 
we pursue the tuning, are there any other suggestions?  Is this really a 
problem that is expected to happen?

I should add that long queries that need to be run on a routine basis, we'd run 
via cronjob.  However, I'm worried that staff who work solely on the web might 
inadvertently run a big one-off report (or do a huge record load, also a 
problem), and bring down the whole system.

FWIW, we have two processors:  Intel(R) Xeon(R) Silver 4110 CPU @ 2.10GHz.  We 
have about 1.3 million records and the same number of items.  We're using MySQL 
5.7, and Koha 20.11.06.

Regarding RAM, this is the output of the "free" command, if relevant:

totalused  freeshared   
 buff/cache   available
Mem:   65308616   203882041354324  10780021915472 
62437176
Swap:   8257532 7808256752


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz<mailto: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] Reports timing out, prevents access to web interfaces

[Bales (US), Tasha R]

Good afternoon,

I'm experiencing an issue where if I'm working in the staff interface and kick 
off a long-running Report, I'm unable to navigate to or use Koha in any other 
browser tab, or in any other browser, either in the staff or public interface.  
I've confirmed that this affects other users working on their own machines too; 
in other words, my report interrupts their access.

I doubt that this is intended behavior.  I'm going to try to do some 
query-tuning (any suggestions for tools to use to optimize/identify inefficient 
queries?).

Any other ideas to troubleshoot this issue?  I found an old list post that 
suggested the Koha Tuning 
Guide on the Koha Wiki, 
but it isn't entirely clear to me if it is comprehensive, or if all parts are 
relevant to our issue.  I'm hesitant to blindly start changing values.  Before 
we pursue the tuning, are there any other suggestions?  Is this really a 
problem that is expected to happen?

I should add that long queries that need to be run on a routine basis, we'd run 
via cronjob.  However, I'm worried that staff who work solely on the web might 
inadvertently run a big one-off report (or do a huge record load, also a 
problem), and bring down the whole system.

FWIW, we have two processors:  Intel(R) Xeon(R) Silver 4110 CPU @ 2.10GHz.  We 
have about 1.3 million records and the same number of items.  We're using MySQL 
5.7, and Koha 20.11.06.

Regarding RAM, this is the output of the "free" command, if relevant:

totalused  freeshared   
 buff/cache   available
Mem:   65308616   203882041354324  10780021915472 
62437176
Swap:   8257532 7808256752


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

___

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

Re: [Koha] Conference registration, who to contact for help?

[Bales (US), Tasha R]

Thank you very much to those who replied.  It had not been clear to me that 
attendance was free.  I've since received a follow-up email with more 
information about the channels for each track.  Please pardon my ignorance.


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

From: Hernandez, Heather H [mailto:heather_hernan...@nps.gov]
Sent: Monday, September 20, 2021 08:35
To: Bales (US), Tasha R ; koha@lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] Conference registration, who to contact for help?
Importance: High


EXT email: be mindful of links/attachments.




Hi, Tasha--

The Koha-US Conference is going to be livestreamed via YouTube, e.g. here:
https://youtu.be/H5HshJDn8GU
Attending remotely is free, but registering as a remote attendee is 
appreciated, I believe, because it helps the planning.

And you could probably get some assistance via 
i...@koha-us.org<mailto:i...@koha-us.org> or 
secret...@koha-us.org<mailto:secret...@koha-us.org>.  (Yes, the Koha-US website 
seems down right now.)

Cheers,
h2

~~~

Ms. Heather Hernandez (she, her, hers)

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_hernan...@nps.gov<https://webmail.lmi.net/src/compose.php?send_to=heather_hernandez%40nps.gov>

Library catalog: http://keys.bywatersolutions.com/
___

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

[Koha] Conference registration, who to contact for help?

[Bales (US), Tasha R]

Good morning,

I registered for the virtual conference and received a confirmation from the 
Google from.  However, I never received a payment link, or materials indicating 
how to attend the conference.  On my end, the Koha US site appears to be down 
at the moment.

Although this isn't a technical question, I'm writing in hopes someone might 
know of the proper avenue to get help with conference registration follow-up.

Thank you!


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

___

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: JSON report only contains partial results

[Bales (US), Tasha R]

Alvaro, thank you so much!  Adding the LIMIT fixed my issue.

Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

From: Alvaro Cornejo [mailto:cornejo.alv...@gmail.com]
Sent: Thursday, September 16, 2021 12:11
To: Bales (US), Tasha R 
Cc: koha@lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] JSON report only contains partial results
Importance: High


EXT email: be mindful of links/attachments.




Hi Tasha

This is because public reports default to 10 results.

If you need more lines, you should add "LIMIT " to the end of your query. 
Where xxx is the maximum lines you want to get.

Regards,

Alvaro
||
[https://drive.google.com/uc?id=1lpgSKUunPpKrvmS1rja7umnEgiqBa_vD=download]
 Stay safe / Cuídate/  Reste sécurisé
7 Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à mesure.
 q Recycle always / Recicla siempre / Recyclez toujours
 P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez 
seulement si nécessaire


Le jeu. 16 sept. 2021 à 13:49, Bales (US), Tasha R 
mailto:tasha.r.ba...@boeing.com>> a écrit :
Any idea why my public report would return almost 2000 results, but the JSON 
URL for that report (accessed right after I ran the report), would only display 
a list of 9 results?

I've tried reindexing to no avail.  I've also tried duplicating and rerunning 
the report, as well as changing the report category back to "Cataloging" 
instead of the custom category I'd added.

In my initial experimentation with reports and their JSON URL's, everything 
worked perfectly.  Now, besides the above, I'm noticing odd behavior with the 
"=1" parameter, in that if I access the annotated report, then 
subsequently strip off that parameter and navigate again to the report, the 
output is still annotated.  I attributed this to caching, but I get this 
behavior even if I try to access the not annotated URL in a different browser.  
That doesn't seem possible; I presume there is something about JSON I just 
don't understand.


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz<mailto: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] JSON report only contains partial results

[Bales (US), Tasha R]

Any idea why my public report would return almost 2000 results, but the JSON 
URL for that report (accessed right after I ran the report), would only display 
a list of 9 results?

I've tried reindexing to no avail.  I've also tried duplicating and rerunning 
the report, as well as changing the report category back to "Cataloging" 
instead of the custom category I'd added.

In my initial experimentation with reports and their JSON URL's, everything 
worked perfectly.  Now, besides the above, I'm noticing odd behavior with the 
"=1" parameter, in that if I access the annotated report, then 
subsequently strip off that parameter and navigate again to the report, the 
output is still annotated.  I attributed this to caching, but I get this 
behavior even if I try to access the not annotated URL in a different browser.  
That doesn't seem possible; I presume there is something about JSON I just 
don't understand.


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

___

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

[Koha] Elasticsearch error stops bulkmarcimport

[Bales (US), Tasha R]

I've occasionally seen this error when loading MARC record on the command line 
using bulkmarcimport.pl:
Bad response received when submitting request to Elasticsearch.

When it occurs, the bulkmarcimport ceases, interrupting the load.

I've found nothing else in any other logs on the Koha server that help explain 
the error.  I'm not sure what Elasticsearch has to do with my bulkmarcimport, 
unless it is Elasticsearch trying to index records on-the-fly after they are 
loaded?  Is there an easy way to prevent this error from happening?  Perhaps I 
should stop the Elasticsearch process while doing a bulkmarcimport? My 
Elasticsearch servers are external to the Koha environment, and I don't see any 
obvious indexing processes running on my local machine, so I'm not sure how 
best to intervene to prevent the above issue.

I'm currently working my way through loading 1.3 million records, and I've had 
several redo's already as a result of loads being interrupted partway through 
(running bulkmarcimport via a cronjob helped *a lot*, but now I've had two ES 
errors/interruptions in the last day, which has put me a day behind).  I am 
currently working with batches of 200K records or less.

Thanks for any tips you may have!  In the meantime, I will modify my latest 
MARC file to try to remove records already loaded and then resubmit the job (in 
order to save additional hours spent reloading 98K records).


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

___

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: Search/List RSS feeds (trigger? add call number?)

[Bales (US), Tasha R]

Thanks for your reply, Katrin.

Your comments on including a call number in an RSS make perfect sense.  We 
could use a bibliographic attribute instead, such as technical report number in 
027, thus my attempt to sub in "report-number" for isbn. I don't know if I'm on 
the right track with respect to syntax (i.e., what are the possible terms that 
could be subbed in for isbn?), but I haven't tried 001 or 035 yet; I will give 
those a try too.  

I am surprised by the behavior of the "Subscribe to this list" RSS.  I was 
really hoping that would allow for reappearance in the feed if an item in the 
list was edited.  Thanks for your suggestion to file an enhancement request (is 
that just a bug report, or is there a separate option for enhancement 
requests?).  

If anyone has knowledge of what code we would look at in addition to 
opac-opensearch.tt and opac-search.pl, please advise.  Maybe there is something 
we can tweak fundamental to RSS to allow for reporting on records with an 005 
that is >= a specified value.  I believe we could use a custom feed, but I 
think that would only work for users on a case-by-case basis, which would be 
unmanageable.  Thanks again for your time. 


Tasha Bales 
Enterprise Services
http://isesi.web.boeing.com/

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Katrin Fischer
Sent: Monday, August 23, 2021 5:38 AM
To: koha@lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] Search/List RSS feeds (trigger? add call number?)

EXT email: be mindful of links/attachments.



Hi Tasha,

I can't answer all your questions, but maybe I can provide a bit of information.

I think that for the RSS feed on lists the date the record is added to a list 
is used. Would that match with what you see?

I think adding the call number to the RSS feed might not be straight forward, 
because this information would have to be taken from the items instead of the 
record. As there can be many items per record and the call numbers can vary 
between the different branches and locations of a library system, the task of 
displaying this information in a useful and nice way is not an easy one. Maybe 
filing an enhancement request on bugzilla to discuss this more would be a good 
first step to discuss this further.

Hope this helps,

Katrin

On 19.08.21 15:51, Bales (US), Tasha R wrote:
> Good morning,
>
> I'm writing with a couple questions about out-of-the-box RSS feeds for 
> searches.  I'm interested in how to modify them (I really need one or more of 
> our call numbers/classification numbers to be included), and how they are 
> triggered.  I see two types of feeds, below.
>
> "Subscribe to this search"
>
> * The manual says this feed "will allow you to see when a new item is 
> added to the catalog".
>
> * How is a "new item" defined?  I've taken a look at 
> opac-opensearch.tt and opac-search.pl, in order to under how date limiting is 
> coming in to play, specifically (which dates, what comparison, what fields, 
> etc.).  I do see reference to an 005 date "hack" for Atom, but it seems like 
> only the RSS portions of the code are relevant.  I'd like to determine if I 
> can only ever expect newly added records to be returned, or would/could 
> updated records also be returned?
>
> "Subscribe to this list"
>
> * I don't see information about this feed in the manual.
>
> * Since this is a search about already-cataloged, known items, it 
> wouldn't make sense for the RSS to retrieve only newly cataloged records.  
> Therefore, what should trigger a subscriber to receive an update about their 
> list if an item has been updated?  Is it the bib 005, or something else?  
> I've tried editing a few records in a list I am subscribed to, expecting to 
> get a new email, but I didn't receive a message.  Although this last part may 
> sound confusing, I'm leaving as is, as it may help explain context-I've added 
> the feeds to my Microsoft Outlook, where each matching item shows up as a 
> discrete "email" message in my RSS Feeds folder.
>
> Maybe the problem here is my understanding of RSS.  My feeds appear to be 
> refreshed every time I check my mail, but I'm only receiving RSS for newly 
> added records.  I didn't receive a new feed today of records in my "list" 
> that I edited yesterday.
>
> Finally, I find that the RSS output is not usable for my patrons.  We really 
> need call number to be included in the RSS.  It looks like we could modify 
> the template line below to swap out isbn with another identifier, but I'm not 
> sure how to know what term to swap in after "SEARCH_RESULT.":
>
> ISBN:[% SEARCH_RESULT.isbn | html %]
>
> I've tried "report-number", "callnum", &q

[Koha] Search/List RSS feeds (trigger? add call number?)

[Bales (US), Tasha R]

Good morning,

I'm writing with a couple questions about out-of-the-box RSS feeds for 
searches.  I'm interested in how to modify them (I really need one or more of 
our call numbers/classification numbers to be included), and how they are 
triggered.  I see two types of feeds, below.

"Subscribe to this search"

* The manual says this feed "will allow you to see when a new item is 
added to the catalog".

* How is a "new item" defined?  I've taken a look at opac-opensearch.tt 
and opac-search.pl, in order to under how date limiting is coming in to play, 
specifically (which dates, what comparison, what fields, etc.).  I do see 
reference to an 005 date "hack" for Atom, but it seems like only the RSS 
portions of the code are relevant.  I'd like to determine if I can only ever 
expect newly added records to be returned, or would/could updated records also 
be returned?

"Subscribe to this list"

* I don't see information about this feed in the manual.

* Since this is a search about already-cataloged, known items, it 
wouldn't make sense for the RSS to retrieve only newly cataloged records.  
Therefore, what should trigger a subscriber to receive an update about their 
list if an item has been updated?  Is it the bib 005, or something else?  I've 
tried editing a few records in a list I am subscribed to, expecting to get a 
new email, but I didn't receive a message.  Although this last part may sound 
confusing, I'm leaving as is, as it may help explain context-I've added the 
feeds to my Microsoft Outlook, where each matching item shows up as a discrete 
"email" message in my RSS Feeds folder.

Maybe the problem here is my understanding of RSS.  My feeds appear to be 
refreshed every time I check my mail, but I'm only receiving RSS for newly 
added records.  I didn't receive a new feed today of records in my "list" that 
I edited yesterday.

Finally, I find that the RSS output is not usable for my patrons.  We really 
need call number to be included in the RSS.  It looks like we could modify the 
template line below to swap out isbn with another identifier, but I'm not sure 
how to know what term to swap in after "SEARCH_RESULT.":

ISBN:[% SEARCH_RESULT.isbn | html %]

I've tried "report-number", "callnum", "lcn", and "local-classification", which 
all failed to produce results.

Please advise if there are any known examples about customizing the RSS 
templates for the basic searches above (I didn't see anything promising in the 
Wiki, when I searched for "RSS" or "opensearch.tt").

Thanks so much for your time,


Tasha Bales
Enterprise Services
http://isesi.web.boeing.com/

___

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

Re: [Koha] Title search works, but Library catalog search fails in OPAC

[Bales (US), Tasha R]

Thanks Katrin, 

We've determined that toggling OpacSuppression from "Hide" to "Don't Hide" 
"fixes" our inability to search the OPAC for phrases containing punctuation 
when using the "Library catalog" search option.  However, the bibliographic 
records that are hidden are *not* coded to be suppressed and I don't believe 
OpacSuppression should have any bearing on their display.*

Also, thanks for the info about the bug.  I can reproduce that error, but so 
far, only when my search contains a forward slash.  I'll keep an eye on it.

I will keep testing.  Being new to Koha, maybe I am misunderstanding or not 
seeing something.  Thanks again for the help so far!

*Example 942 field:  942 _ _ ‡n0
I've verified that 942 is populated in every record in the system, with either 
0 or 1, using the "SUPPRESS" Authorized Value, which came out-of-the-box on our 
system.  

Incidentally, I see these errors in plack-opac-error.log:
[2021/07/13 09:23:04] [WARN] Use of uninitialized value $f in pattern match 
(m//) at /usr/share/koha/lib/Koha/SearchEngine/Elasticsearch/QueryBuilder.pm 
line 725.
[2021/07/13 09:23:04] [WARN] Use of uninitialized value $f in exists at 
/usr/share/koha/lib/Koha/SearchEngine/Elasticsearch/QueryBuilder.pm line 729.

Tasha Bales 
Business Support Team | Information Services 

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Katrin Fischer
Sent: Sunday, June 27, 2021 1:38 AM
To: koha@lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] Title search works, but Library catalog search 
fails in OPAC

EXT email: be mindful of links/attachments.



Hi Tasha,

there is currently a bug about some punctuation leading to no results in 
Elasticsearch that might relate to your problem:

*Bug 28316*
<https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28316> - Fix ES 
crashes related to various punctuation characters

Hope this helps,

Katrin

On 24.06.21 23:55, Bales (US), Tasha R wrote:
> Follow-up to my problem searching the OPAC for phrases containing punctuation 
> (i.e., Electroactive polymer (EAP) actuators).  This Bywater 
> Solutions<https://bywatersolutions.com/education/elastic-searching> article 
> suggests that the problem is a feature of Elasticsearch.
>
>
>
> FYI, we are using Elasticsearch 6.1.1 on its own dedicated server, and I 
> don’t believe we’ve installed the ICU Analysis plug-in (looks like it’s 
> required for Zebra, but I can’t tell if it’s required for Elasticsearch), 
> which could be a factor.  I couldn’t replicate all aspects of my experience 
> in a sandbox, although searches for phrases containing punctuation still 
> failed in an OPAC “Library Catalog” sandbox search.  I concluded that I 
> needed to review our configuration.
>
>
>
> I’ve been reviewing the Koha Wiki and elastic.co documentation, and comparing 
> to our index_config.yaml.
>
> By chance does anyone know how to interpret the syntax below?  The 
> documentation describes the parameters below, but I don’t see any usage of 
> “-“ before options.  Does the option “- punctuation“ mean “yes, remove 
> punctuation”, or “no, don’t remove punctuation”, or does the phrase refer to 
> some additional configuration file, or perhaps it’s commented out?
>
>
>
>analyzer_phrase:
>
>  tokenizer: keyword
>
>  filter:
>
>- icu_folding
>
>  char_filter:
>
>- punctuation
>
>
>
> Thanks for your time and consideration,
>
>
>
>
>
> Tasha Bales
>
> Business Support Team | Information Services
>
> Enterprise Services | Enterprise Operations, Finance and 
> Sustainability
>
>
>
>
>
> -Original Message-
>
> From: Bales (US), Tasha R
>
> Sent: Tuesday, June 22, 2021 7:54 AM
>
> To: 'Jonathan Druart' 
>
> Cc: Discussion Group Koha 
>
> Subject: RE: [EXTERNAL] Re: [Koha] Title search works, but Library 
> catalog search fails in OPAC
>
>
>
> Jonathan, thank you!
>
>
>
> It does work without the parentheses.
>
>
>
> I would suspect an encoding problem, but for that the problem only manifests 
> in the OPAC, and not the intranet.
>
>
>
> I came across this issue while testing after migrating from MariaDB to 
> Percona MySQL.  Your reply prompted me to check the encoding of the new 
> database, and it's unfortunately Latin-1.  Since these are parentheses and 
> not diacritics, I’m not sure what my expectations should be, but changing to 
> UTF-8 is a place to start.  Httpd.conf does have UTF-8 set as the default.
>
>
>
> FWIW, my source records were encoded in MARC-8.  I used MarcEdit to convert 
> them to UTF-8, and it appears that Koha automatically converts anyway on 
> impo

Re: [Koha] Title search works, but Library catalog search fails in OPAC

[Bales (US), Tasha R]

Follow-up to my problem searching the OPAC for phrases containing punctuation 
(i.e., Electroactive polymer (EAP) actuators).  This Bywater 
Solutions<https://bywatersolutions.com/education/elastic-searching> article 
suggests that the problem is a feature of Elasticsearch.



FYI, we are using Elasticsearch 6.1.1 on its own dedicated server, and I don’t 
believe we’ve installed the ICU Analysis plug-in (looks like it’s required for 
Zebra, but I can’t tell if it’s required for Elasticsearch), which could be a 
factor.  I couldn’t replicate all aspects of my experience in a sandbox, 
although searches for phrases containing punctuation still failed in an OPAC 
“Library Catalog” sandbox search.  I concluded that I needed to review our 
configuration.



I’ve been reviewing the Koha Wiki and elastic.co documentation, and comparing 
to our index_config.yaml.

By chance does anyone know how to interpret the syntax below?  The 
documentation describes the parameters below, but I don’t see any usage of “-“ 
before options.  Does the option “- punctuation“ mean “yes, remove 
punctuation”, or “no, don’t remove punctuation”, or does the phrase refer to 
some additional configuration file, or perhaps it’s commented out?



  analyzer_phrase:

tokenizer: keyword

filter:

  - icu_folding

char_filter:

  - punctuation



Thanks for your time and consideration,





Tasha Bales

Business Support Team | Information Services

Enterprise Services | Enterprise Operations, Finance and Sustainability





-Original Message-

From: Bales (US), Tasha R

Sent: Tuesday, June 22, 2021 7:54 AM

To: 'Jonathan Druart' 

Cc: Discussion Group Koha 

Subject: RE: [EXTERNAL] Re: [Koha] Title search works, but Library catalog 
search fails in OPAC



Jonathan, thank you!



It does work without the parentheses.



I would suspect an encoding problem, but for that the problem only manifests in 
the OPAC, and not the intranet.



I came across this issue while testing after migrating from MariaDB to Percona 
MySQL.  Your reply prompted me to check the encoding of the new database, and 
it's unfortunately Latin-1.  Since these are parentheses and not diacritics, 
I’m not sure what my expectations should be, but changing to UTF-8 is a place 
to start.  Httpd.conf does have UTF-8 set as the default.



FWIW, my source records were encoded in MARC-8.  I used MarcEdit to convert 
them to UTF-8, and it appears that Koha automatically converts anyway on 
import.  When I loaded these records into Koha, I used bulkmarcimport.pl on the 
command line.



I'll ask that the default character set of the database be changed, and see if 
that helps.  Thanks again.  I'm embarrassed that I didn't think to omit the 
parentheses, or rather was belligerently insisting to myself that they should 
not have been a problem,





Tasha Bales

Business Support Team | Information Services Enterprise Services | Enterprise 
Operations, Finance and Sustainability

(480) 509-5415

https://is.web.boeing.com





-Original Message-

From: Jonathan Druart [mailto:jonathan.dru...@bugs.koha-community.org]

Sent: Tuesday, June 22, 2021 12:01 AM

To: Bales (US), Tasha R 

Cc: Discussion Group Koha 

Subject: [EXTERNAL] Re: [Koha] Title search works, but Library catalog search 
fails in OPAC

Importance: High



EXT email: be mindful of links/attachments.







Hello Tasha,



I've created 2 records with

  245$a Electroactive polymer (EAP) actuators as artificial muscles and the 
following query returns the 2 results.

/opac-search.pl?idx==Electroactive%20polymer%20%28EAP%29%20actuators_search=1



Tried on master and 20.11.06.



Maybe a silly idea: does it work without the parenthesis?



Could you try and recreate it on a sandbox

(https://wiki.koha-community.org/wiki/Sandboxes) and provide us a step by step 
plan to reproduce the problem?



Regards,

Jonathan



Le mar. 22 juin 2021 à 00:46, Bales (US), Tasha R  a 
écrit :

>

> Good afternoon,

>

> I’m having trouble with Title vs. Library catalog keyword searching with 
> several example titles.  Searching the same phrase with either method yields 
> different results.  This problem occurs only in the OPAC.  I hope to confirm 
> whether the behavior I’m seeing is intended (i.e., the problem is me) or not. 
>  Thanks in advance.

>

> For example, given the ebook title, Electroactive polymer (EAP)

> actuators as artificial muscles, a Title keyword search in the OPAC is 
> successful, but a plain, Library catalog (i.e., no index specified), keyword 
> search fails.

>

> For reference, the title is recorded in the MARC record as:

> 245 00 - TITLE STATEMENT

>   a Title Electroactive polymer (EAP) actuators as artificial muscles :

>

> Below I’ve copied in my search history as well as the tail of the search URL 
> that shows the search parameters.

>

>

> · Library catalog k

Re: [Koha] [EXTERNAL] Re: Title search works, but Library catalog search fails in OPAC

[Bales (US), Tasha R]

Jonathan, thank you!  

It does work without the parentheses.

I would suspect an encoding problem, but for that the problem only manifests in 
the OPAC, and not the intranet.  

I came across this issue while testing after migrating from MariaDB to Percona 
MySQL.  Your reply prompted me to check the encoding of the new database, and 
it's unfortunately Latin-1.  Since these are parentheses and not diacritics, 
I’m not sure what my expectations should be, but changing to UTF-8 is a place 
to start.  Httpd.conf does have UTF-8 set as the default.

FWIW, my source records were encoded in MARC-8.  I used MarcEdit to convert 
them to UTF-8, and it appears that Koha automatically converts anyway on 
import.  When I loaded these records into Koha, I used bulkmarcimport.pl on the 
command line.  

I'll ask that the default character set of the database be changed, and see if 
that helps.  Thanks again.  I'm embarrassed that I didn't think to omit the 
parentheses, or rather was belligerently insisting to myself that they should 
not have been a problem,


Tasha Bales 
Business Support Team | Information Services 
Enterprise Services | Enterprise Operations, Finance and Sustainability
(480) 509-5415
https://is.web.boeing.com


-Original Message-
From: Jonathan Druart [mailto:jonathan.dru...@bugs.koha-community.org] 
Sent: Tuesday, June 22, 2021 12:01 AM
To: Bales (US), Tasha R 
Cc: Discussion Group Koha 
Subject: [EXTERNAL] Re: [Koha] Title search works, but Library catalog search 
fails in OPAC
Importance: High

EXT email: be mindful of links/attachments.



Hello Tasha,

I've created 2 records with
  245$a Electroactive polymer (EAP) actuators as artificial muscles and the 
following query returns the 2 results.
/opac-search.pl?idx==Electroactive%20polymer%20%28EAP%29%20actuators_search=1

Tried on master and 20.11.06.

Maybe a silly idea: does it work without the parenthesis?

Could you try and recreate it on a sandbox
(https://wiki.koha-community.org/wiki/Sandboxes) and provide us a step by step 
plan to reproduce the problem?

Regards,
Jonathan

Le mar. 22 juin 2021 à 00:46, Bales (US), Tasha R  a 
écrit :
>
> Good afternoon,
>
> I’m having trouble with Title vs. Library catalog keyword searching with 
> several example titles.  Searching the same phrase with either method yields 
> different results.  This problem occurs only in the OPAC.  I hope to confirm 
> whether the behavior I’m seeing is intended (i.e., the problem is me) or not. 
>  Thanks in advance.
>
> For example, given the ebook title, Electroactive polymer (EAP) 
> actuators as artificial muscles, a Title keyword search in the OPAC is 
> successful, but a plain, Library catalog (i.e., no index specified), keyword 
> search fails.
>
> For reference, the title is recorded in the MARC record as:
> 245 00 - TITLE STATEMENT
>   a Title Electroactive polymer (EAP) actuators as artificial muscles :
>
> Below I’ve copied in my search history as well as the tail of the search URL 
> that shows the search parameters.
>
>
> · Library catalog keyword search with 0 results
>
> o   2021-06-21 02:34 PM   Electroactive polymer (EAP) actuators, 
> suppress:false  0
>
> o   
> …opac-search.pl?idx==Electroactive%20polymer%20%28EAP%29%20actuators_search=1
>
>
> · Title keyword search with 2 results
>
> o   2021-06-21 02:34 PM   Electroactive polymer (EAP) actuators, 
> suppress:false  2
>
> o   
> …opac-search.pl?idx=ti=Electroactive+polymer+%28EAP%29+actuators_search=1
>
> As a test, I decided to enclose my Library catalog search terms in quotes, 
> which yielded the desired results.  However, I did not at all anticipate that 
> quotes would be required to get hits:
>
>
> · Library catalog quoted keyword search with 2 results
>
> o   2021-06-21 02:46 PM   "Electroactive polymer (EAP) actuators", 
> suppress:false  2
>
> o   … 
> opac-search.pl?idx==%22Electroactive+polymer+%28EAP%29+actuators%22_search=1
>
> On comparing the above URL query strings, it appears that the unquoted terms 
> in the Library catalog keyword search aren’t “anded” together with a “+” the 
> way other searches are, but I’m not sure what the implications are, if any.  
> Also, the Koha manual indicates the following, which suggests to me that I 
> ought to get hits on the unquoted string:
>
> When you have more than one word in the search box, Koha will still do a 
> keyword search, but a bit differently. Each word will be searched on its own, 
> then the Boolean connector ‘and’ will narrow your search to those items with 
> all words contained in matching records.
>
> I understand and can predict pretty well the way our old ILS (Millennium, if 
> context helps) will perform a keyword search, but I’m a little confused here. 
>  My expectation for th

[Koha] Title search works, but Library catalog search fails in OPAC

[Bales (US), Tasha R]

Good afternoon,

I’m having trouble with Title vs. Library catalog keyword searching with 
several example titles.  Searching the same phrase with either method yields 
different results.  This problem occurs only in the OPAC.  I hope to confirm 
whether the behavior I’m seeing is intended (i.e., the problem is me) or not.  
Thanks in advance.

For example, given the ebook title, Electroactive polymer (EAP) actuators as 
artificial muscles,
a Title keyword search in the OPAC is successful, but a plain, Library catalog 
(i.e., no index specified), keyword search fails.

For reference, the title is recorded in the MARC record as:
245 00 - TITLE STATEMENT
  a Title Electroactive polymer (EAP) actuators as artificial muscles :

Below I’ve copied in my search history as well as the tail of the search URL 
that shows the search parameters.


· Library catalog keyword search with 0 results

o   2021-06-21 02:34 PM   Electroactive polymer (EAP) actuators, 
suppress:false  0

o   
…opac-search.pl?idx==Electroactive%20polymer%20%28EAP%29%20actuators_search=1


· Title keyword search with 2 results

o   2021-06-21 02:34 PM   Electroactive polymer (EAP) actuators, 
suppress:false  2

o   
…opac-search.pl?idx=ti=Electroactive+polymer+%28EAP%29+actuators_search=1

As a test, I decided to enclose my Library catalog search terms in quotes, 
which yielded the desired results.  However, I did not at all anticipate that 
quotes would be required to get hits:


· Library catalog quoted keyword search with 2 results

o   2021-06-21 02:46 PM   "Electroactive polymer (EAP) actuators", 
suppress:false  2

o   … 
opac-search.pl?idx==%22Electroactive+polymer+%28EAP%29+actuators%22_search=1

On comparing the above URL query strings, it appears that the unquoted terms in 
the Library catalog keyword search aren’t “anded” together with a “+” the way 
other searches are, but I’m not sure what the implications are, if any.  Also, 
the Koha manual indicates the following, which suggests to me that I ought to 
get hits on the unquoted string:

When you have more than one word in the search box, Koha will still do a 
keyword search, but a bit differently. Each word will be searched on its own, 
then the Boolean connector ‘and’ will narrow your search to those items with 
all words contained in matching records.

I understand and can predict pretty well the way our old ILS (Millennium, if 
context helps) will perform a keyword search, but I’m a little confused here.  
My expectation for this particular case is that all of the above methods would 
yield results.  If there are any pointers to be had, I thank you if might point 
me to them so that I may be better poised to help users.

I’m using Elasticsearch with Koha 20.11.06.  I reindexed both authorities and 
biblios today, but that didn’t impact my experience.  The records are not newly 
added.

Thanks!


Tasha Bales
Business Support Team | Information Services
Enterprise Services | Enterprise Operations, Finance and Sustainability

___

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

Re: [Koha] [EXTERNAL] Copying Subfields from Field1 to Field2 [Was: Identifying Records with Non-Roman Characters]

[Bales (US), Tasha R]

Hi Charles, 

I have used Tools > Build New Field to accomplish this type of activity, but 
there might be an easier way.

Pattern:
=245  10$6{245$6}$a{245$a} /$c{242$c}

Options:
check the box for "Replace Existing Field"

You'd have to repeat this process to allow for different indicators in the 245, 
or additional subfields in the 245, which is why it probably isn't the most 
efficient method.


Tasha Bales 
Business Support Team | Information Services 
Enterprise Services | Enterprise Operations, Finance and Sustainability


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Charles Kelley
Sent: Thursday, June 10, 2021 12:18 AM
To: Discussion Group Koha 
Subject: [EXTERNAL] [Koha] Copying Subfields from Field1 to Field2 [Was: 
Identifying Records with Non-Roman Characters]

EXT email: be mindful of links/attachments.



Hello, all!

Earlier this week, I wrote about flipping the tags on old 245-246 pairs to 
make them in current 245-880 pairs, e.g.,

=245  10$aВеликая отецественная война 1941-1945 /$cВ. И. Чуйков
=246  11$a Velikaia otechestvennaia voina 1941-1945

=245  10$a英汉常用物理学小词典 /$cYing Li, Lian Wei
=246  11$aYing-Han changyong wulixue xiaocidian

would become

=242  14$aThe Great Patriotic War 1941-1945 /$cV. I. Chuikov.
=245  10$6880-45$a Velikaia otechestvennaia voina 1941-1945
=880  10$6245-45/(N$aВеликая отецественная война 1941-1945 /$cВ. И. Чуйков

=242  10$aEnglish-Chinese dictionary of commonly used words in physics /$cYing 
Li, Lian Wei
=245  10$6880-45$aYing-Han changyong wulixue xiaocidian
=880  10$6245-45/[dollar]1$a英汉常用物理学小词典 /$cYing Li, Lian Wei .

respectively. With help from David Cook and a few tutorials online, we were 
able to accomplish, to our very great surprise.

We now have another problem: copying the existing 242$c or new 880$c into 
the 245$c with the preceding slash. Does anyone have an idea how to do this? I 
have tried MarcEdit's swap field functionality, but I just cannot get it to 
work. It ends up replacing the 245 subfields altogether, leaving behind just 
the indicators and $c prefixed with a slash.

The resulting 245 fields would end up

=245  10$6880-45$a Velikaia otechestvennaia voina 1941-1945 /$cV. I.
Chuikov.
=245  10$6880-45$aYing-Han changyong wulixue xiaocidian /$cYing Li, Lian Wei .

Does anyone have an idea?

Many thanks for your help.

-- 

気を付けて。 /ki wo tukete/ = Take care.

-- Charles.

Charles Kelley, MLS
PSC 704 Box 1029
APO AP 96338

Charles Kelley
Tsukimino 1-Chome 5-2
Tsukimino Gaadenia #210
Yamato-shi, Kanagawa-ken
〒242-0002 JAPAN

+1-301-741-7122 [US cell]
+81-80-4356-2178 [JPN cell]

mnogoja...@aol.com [h]
cmkelley...@gmail.com [p]

linkedin.com/in/cmkelleymls 
Meeting Your Information Needs. Virtually.
___

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] [EXTERNAL] Create new record matching rule - 035a

[Bales (US), Tasha R]

James, 

Have you verified that 035a is indexed in your system?  I have not had success 
in creating matching rules against fields that are not indexed.  In my system, 
the index shows that 035 is indexed, but not 035a.  However, I'm not sure if 
that difference would matter, assuming there are no other subfields of the 035 
present in your data.  


Tasha Bales 
Business Support Team | Information Services 
Enterprise Services | Enterprise Operations, Finance and Sustainability

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of muiru james
Sent: Thursday, June 10, 2021 7:07 AM
To: koha 
Subject: [EXTERNAL] [Koha] Create new record matching rule - 035a

EXT email: be mindful of links/attachments.



Hi,

I've tried creating a new record matching rule to use tag 035a and despite 
trying a lot of things its not working. Field 035a contains a four digit arabic 
number (e.g. 1500).

Someone please help me create the rule.

Regards

James
___

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] [EXTERNAL] Re: Serials, can't add sub ("vendor does not exist")

[Bales (US), Tasha R]

Hi Katrin, thanks for your reply.  

--We are using Koha in English.
--Before clicking on "Next", the vendor information *does* show up on the form.

I also just realized my email subject should have said "can't add vendor", my 
apologies, but I'll leave as is to preserve the thread.


Tasha Bales 
Business Support Team | Information Services 
Enterprise Services | Enterprise Operations, Finance and Sustainability

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Katrin Fischer
Sent: Wednesday, June 2, 2021 5:27 AM
To: koha@lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] Serials, can't add sub ("vendor does not exist")

EXT email: be mindful of links/attachments.



Hi Tasha,

I tested in 21.05 and 20.11.06 and linking the vendor to the subscription 
worked well in both. I could also not find a fixed bug for the problem. :(

To limit the issue a bit more:

- Are you using Koha in English or in another language?
- Before you click on next, does the vendor information show on the form?

Katrin

On 01.06.21 16:23, Bales (US), Tasha R wrote:
> Good afternoon,
>
> I find that I'm unable to associate a vendor with a new or existing 
> subscription record.  Although I am able to search for a vendor on the 
> subscription edit form at serials/subscription-add.pl, saving the form 
> results in "The vendor does not exist."  I'm using  Koha 20.11.02.  Perhaps I 
> am missing something obvious.
>
> I'm doing this:
>
> * Navigate to Home > Serials, and click "New subscription"
>
> * On the form:
>
> o   Search for and select an active vendor record and then a bib record
>
> o   Click "Next"
>
> * Receive error, "The vendor does not exist."
>
> I've verified the following:
>
> * Vendor exists and is active
>
> * Bib record for the serial exists
>
> * Also, "claim serial issue" notice exists (this was the only 
> acq/serial thing I found that was obviously undefined)
>
> I've tried creating a new vendor, and also using different bibs, and making 
> sure their 008's indicate they are continuing resources, just in case.  .
>
> I don't see anything useful in /var/log/koha except a bunch of errors like 
> this that seem to be complaining about collection codes when I look at the 
> problem line in the indicated script:
> [2021/05/28 14:44:33] [WARN] Use of uninitialized value in string comparison 
> (cmp) at /usr/share/koha/intranet/cgi-bin/serials/subscription-bib-search.pl 
> line 221.
>
> Is there anything else I might want to examine that could be causing the 
> problem?  Thanks for your time.
>
>
> Tasha R. Bales | Business Support Team Information Services | 
> Enterprise Services Enterprise Operations, Finance and Sustainability
>
> ___
>
> 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] Serials, can't add sub ("vendor does not exist")

[Bales (US), Tasha R]

Good afternoon,

I find that I'm unable to associate a vendor with a new or existing 
subscription record.  Although I am able to search for a vendor on the 
subscription edit form at serials/subscription-add.pl, saving the form results 
in "The vendor does not exist."  I'm using  Koha 20.11.02.  Perhaps I am 
missing something obvious.

I'm doing this:

* Navigate to Home > Serials, and click "New subscription"

* On the form:

o   Search for and select an active vendor record and then a bib record

o   Click "Next"

* Receive error, "The vendor does not exist."

I've verified the following:

* Vendor exists and is active

* Bib record for the serial exists

* Also, "claim serial issue" notice exists (this was the only 
acq/serial thing I found that was obviously undefined)

I've tried creating a new vendor, and also using different bibs, and making 
sure their 008's indicate they are continuing resources, just in case.  .

I don't see anything useful in /var/log/koha except a bunch of errors like this 
that seem to be complaining about collection codes when I look at the problem 
line in the indicated script:
[2021/05/28 14:44:33] [WARN] Use of uninitialized value in string comparison 
(cmp) at /usr/share/koha/intranet/cgi-bin/serials/subscription-bib-search.pl 
line 221.

Is there anything else I might want to examine that could be causing the 
problem?  Thanks for your time.


Tasha R. Bales | Business Support Team
Information Services | Enterprise Services
Enterprise Operations, Finance and Sustainability

___

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: Install database on different server than Koha?

[Bales (US), Tasha R]

Perfect, thank you so much!


Tasha R. Bales | Business Support Team
Information Services | Enterprise Services
Enterprise Operations, Finance and Sustainability

From: Tomas Cohen Arazi [mailto:tomasco...@gmail.com]
Sent: Friday, May 28, 2021 4:11 AM
To: Bales (US), Tasha R 
Cc: koha 
Subject: [EXTERNAL] Re: [Koha] Install database on different server than Koha?
Importance: High


EXT email: be mindful of links/attachments.




You're correct, you just need to tweak the hostname in the configuration.

El jue., 27 may. 2021 14:22, Bales (US), Tasha R 
mailto:tasha.r.ba...@boeing.com>> escribió:
Good morning,

My team is working on implementing Koha on Oracle Linux and so far it's worked 
out.  We are getting ready to test to see if we can swap out Maria DB with 
Percona MySQL Server, which seems uncomplicated.  I'd like to ask if anyone has 
set up Koha to operate with a database that is on a separate server (separate 
virtual machines on the same network), as opposed to embedded with Koha.  My 
first thought is that it should work if Koha and Percona can talk to each 
other, but how is that achieved?  Perhaps it's a matter of updating a couple 
configuration files, or maybe it's totally impossible.  Any ideas?

Thanks for your time and consideration!


Tasha R. Bales | Business Support Team
Information Services | Enterprise Services
Enterprise Operations, Finance and Sustainability

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz<mailto: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] Install database on different server than Koha?

[Bales (US), Tasha R]

Good morning,

My team is working on implementing Koha on Oracle Linux and so far it's worked 
out.  We are getting ready to test to see if we can swap out Maria DB with 
Percona MySQL Server, which seems uncomplicated.  I'd like to ask if anyone has 
set up Koha to operate with a database that is on a separate server (separate 
virtual machines on the same network), as opposed to embedded with Koha.  My 
first thought is that it should work if Koha and Percona can talk to each 
other, but how is that achieved?  Perhaps it's a matter of updating a couple 
configuration files, or maybe it's totally impossible.  Any ideas?

Thanks for your time and consideration!


Tasha R. Bales | Business Support Team
Information Services | Enterprise Services
Enterprise Operations, Finance and Sustainability

___

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

[Koha] Migrating data from Zebra to Elasticsearch Koha server

[Bales (US), Tasha R]

Good afternoon,

I am working on implementing Koha and need to migrate to a different server.  
My current server is set up for Zebra, but the new server is set up for 
Elasticsearch.  I was planning on copying the entire koha database using 
mysqldump and loading it to the new server.  Now I'm worried that the 
difference in indexes will mess something up or lead to corrupt data on the new 
server.  Because of this, I'm considering importing only specific tables, and 
populating the system preferences by hand.  I will also reload biblios and 
authorities instead of importing them.

Any tips or insight as to whether I am about to corrupt all my data by doing 
this?  Thanks for your time!


Tasha R. Bales | Business Support Team
Information Services | Enterprise Services
Enterprise Operations, Finance and Sustainability
https://is.web.boeing.com

___

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: Newly cataloged materials alerts?

[Bales (US), Tasha R]

Thanks for the info.  I was hoping a similar feature existed and I just missed 
it.

If by chance there are any ideas for how one should best approach approximating 
this functionality, please let me know.  I’m not qualified to develop 
enhancements for the community, but I might be able to piece something together 
to meet our needs once I become more familiar with Koha.  It might be as simple 
as evaluating the lists in their library accounts, but I’m not sure about how 
they’d opt in—I  will pursue filing an enhancement request per your suggestion.

Our specific need is helping users get apprised of revisions to technical 
documentation, which might be thought of as integrating resources.


Tasha R. Bales | Information Services Support

From: Tomas Cohen Arazi [mailto:tomasco...@gmail.com]
Sent: Monday, March 29, 2021 1:02 PM
To: Sue McMillan 
Cc: Bales (US), Tasha R ; koha@lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] Newly cataloged materials alerts?


EXT email: be mindful of links/attachments.




The first step is to file an enhancement request on the community bugzilla, and 
see if others add their thoughts about it. And maybe someone picks that for 
development, or you get funding to get the feature developed by your/some 
vendor.

Best regards

El lun, 29 mar 2021 a las 16:13, Sue McMillan 
(mailto:sue.mcmil...@stdc.govt.nz>>) escribió:
That would be a good enhancement.  In our previous system (Liberty3) that 
feature was available and was well used by customers.

Ngā mihi

Sue McMillan
Kaiārahi Whakarārangi Pukapuka me ngā Whakahaere Pūnaha | Cataloguing and 
Systems Administrator
Te Kaunihera ō Taranaki ki Te Tonga | South Taranaki District Council
46 High Street | Private Bag 902, Hāwera 4640, NZ
Waea/Phone: +64 6 278 0555 | 0800 111 323 | 
www.southtaranaki.com<http://www.southtaranaki.com>

-Original Message-
From: Koha 
mailto:koha-boun...@lists.katipo.co.nz>> On 
Behalf Of Bales (US), Tasha R
Sent: Tuesday, 30 March 2021 7:20 AM
To: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>
Subject: [Koha] Newly cataloged materials alerts?

Does Koha have a feature that allows users to get email alerts about materials 
that are new and/or updated?

I'm looking for something like Millennium/Innovative "Preferred Search", which 
allows users to save a search, and get emailed at regular intervals with 
matching results.

In our current system, the trigger that identifies "new" records is an update 
to the "cat date" field in the record.  Therefore, users get emailed about 
records that are both new and updated/recatalogued.

So far, it looks like Koha would either offer RSS feeds, or else permit using 
an Item Type (this would not work for us-the "trigger" needs to be 
date-dependent), to achieve this kind of functionality.

Are there other options for getting this kind of behavior for individual users 
(perhaps 200 people), who only care about specific call number series, or 
specific items, that have been updated, say, in the last week?  Maybe it exists 
and I just haven't found it yet.

Thanks so much for your time,


Tasha R. Bales | Information Services Support

___

Koha mailing list  http://koha-community.org 
Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz>
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
This e-mail and any attachments may contain confidential and privileged 
information. If you are not the intended recipient, please notify the sender 
immediately by return e-mail, delete this e-mail and destroy any copies. Any 
dissemination or use of this information by a person other than the intended 
recipient is unauthorised and may be illegal. Please note that this 
communication does not designate an information system for the purposes of the 
Contract and Commercial Law Act 2017.
___

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


--
Tomás Cohen Arazi
Theke Solutions (http://theke.io<http://theke.io/>)
✆ +54 9351 3513384
GPG: B2F3C15F
___

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

[Koha] Newly cataloged materials alerts?

[Bales (US), Tasha R]

Does Koha have a feature that allows users to get email alerts about materials 
that are new and/or updated?

I'm looking for something like Millennium/Innovative "Preferred Search", which 
allows users to save a search, and get emailed at regular intervals with 
matching results.

In our current system, the trigger that identifies "new" records is an update 
to the "cat date" field in the record.  Therefore, users get emailed about 
records that are both new and updated/recatalogued.

So far, it looks like Koha would either offer RSS feeds, or else permit using 
an Item Type (this would not work for us-the "trigger" needs to be 
date-dependent), to achieve this kind of functionality.

Are there other options for getting this kind of behavior for individual users 
(perhaps 200 people), who only care about specific call number series, or 
specific items, that have been updated, say, in the last week?  Maybe it exists 
and I just haven't found it yet.

Thanks so much for your time,


Tasha R. Bales | Information Services Support

___

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

[Koha] Run batch_delete_records.pl on server?

[Bales (US), Tasha R]

I'm new to Koha and am having issues with web timeouts when using "Batch record 
deletion", either when uploading a list, or when carrying out the actual 
deletion of records in a loaded list.  When I realized 10K records might be too 
many, I decreased to less than 5K.  In one test, about 1/3 of my records were 
deleted by the time the timeout occurred.  I'm not positive if the delete job 
is still running in the background, despite the web timeout.

I'd like to ask, couldn't the batch deletion be performed by FTP'ing my list to 
the server, and then running batch_delete_records.pl with parameters in order 
to circumvent the web interface entirely?  Maybe at some point, I'll have time 
to figure this out on my own.  Until then, if anyone has figured this out, 
please let me know.

Certainly, I could perform this operation with SQL, but I'm not yet fluent or 
familiar enough with Koha to know how to make sure I do this correctly for 
items, bibs, holds.

Thanks for your time,


Tasha R. Bales

___

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

[Koha] Electronic Collections in Koha (items, holdings, coded?)

[Bales (US), Tasha R]

Good afternoon,

I'm writing to ask how people tend to handle electronic collections in Koha.  
I'm coming from Millennium and also Alma.

Does Koha offer any special advantages or have any idiosyncrasies with respect 
to electronic holdings?  At this point, I assume I will just create item 
records for everything and put URL's in the bib 856.  Is it typical to allow 
the item records to have an "available" status, but just make sure they can't 
be put on hold?

Has anyone taken the approach of not creating item records or else using 
checkin/holdings record instead (not sure if either is even possible in Koha).

Also, if I wanted to create a "scope" of all digital collections to allow 
limiting in the OPAC, is this best done by declaring the collection a 
"library", or by using collection code(s), locations, library groups, or some 
combination of all?  Although we really are only one library, some of our 
collections are so distinct that I've been wondering if I could realize some 
advantage by setting them up as libraries (and then using library groups to 
collocate the digital collections, etc.).

I'm continuing to experiment to see the results in action, but it's been slow 
and unfortunately, I'm working with a deadline, so can't leisurely compare and 
contrast approaches as I would like.  Any advice as to not configure something 
so as to avoid being sorry later is appreciated.  Thank you!

Thanks for your time!


Tasha R. Bales

___

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: Advice for how to update huge numbers of bib records, for former Millennium user

[Bales (US), Tasha R]

I really appreciate your reply Eric, thank you.  I will check out your link.  
Alas, this is also a bit of a disaster.  I see my workload increasing.  ☺

If staff will be using SQL, I have reservations about unintentional changes or 
deletions.  Once a Report is created, are you just using SQL to change field 
data as well, or is there a different tool available that staff may use to 
actually apply their changes?

Thanks for your time,


Tasha R. Bales

From: Eric Phetteplace [mailto:ephettepl...@cca.edu]
Sent: Thursday, January 21, 2021 12:48 PM
To: Bales (US), Tasha R 
Cc: koha@lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] Advice for how to update huge numbers of bib 
records, for former Millennium user


EXT email: be mindful of links/attachments.




Hi Tasha,

We were also a former Millennium library that migrated to Koha, though it's 
been a while (migrated in 2016). Reports are essentially Millennium's "Lists" 
but they require more skill to create. So your example would need to be a SQL 
Report filtering according to the properties you've laid out (e.g. biblios not 
linked to the orders table, with item location in (X, Y, Z), biblio.author != 
'AUTHOR', etc.).

I hosted workshops (here's a recording of one<https://youtu.be/K0zTu4qZ88c>) 
with our catalogers and other technicians on learning basic SQL and I write the 
more sophisticated reports for them. You can use runtime parameters to make the 
reports a little more flexible so that staff can adjust them to changing needs 
but they're not going to be able to accomplish much on their own without an 
understanding of SQL. I never use the guided reports in Koha and my memory of 
the few times I tried was that you couldn't accomplish anything substantial, 
but then again I prefer working in SQL anyways as it's so much more powerful 
than abstractions like Guided Reports or Create Lists.

Best,

ERIC PHETTEPLACE Systems Librarian, Libraries (he/him)

ephettepl...@cca.edu<mailto:ephettepl...@cca.edu> | o 510.594.3660 (cca)

[https://www.cca.edu/sites/default/files/images/cca-logotype-394.png]

5212 Broadway | Oakland, CA | 94618

CCA is situated on the traditional unceded lands of the Ohlone peoples.

Black-owned bookstores in Oakland: Ashay by the 
Bay<https://ashaybythebay.com/>, Marcus 
Books<https://www.facebook.com/marcus.books/>

:(){ :|: & };:


On Thu, Jan 21, 2021 at 10:15 AM Bales (US), Tasha R 
mailto:tasha.r.ba...@boeing.com>> wrote:
What would be the Koha equivalent to Millennium Create Lists* (or Alma 
Normalization Rules and Record Sets)?

So far, I see that lists and carts can be used to update records in Koha, but 
this seems to demand working with a pre-determined list of record numbers, or 
else by manually adding items to a cart.  What if I need to update a huge 
number of "unknown" records meeting specific criteria?

Can anyone suggest what the approach would be to accomplish an objective like 
this:

A non-administrator with limited technical skills needs to gather and update 
40,000 bib records in Koha that can't be identified by any single unifying 
attributes.  My Millennium query might have looked like this:

* Bib record not attached to order AND

* (Location is Y or Location is X or Location is Z) and

* Author is not TODD and

* Note doesn't have FREE

*Millennium Create Lists allows you to create a Boolean Search, with up to 
about 20 statements, to query the entire database (various methods to search 
subsets or existing result sets also exist) and saves it to a file that can 
then be exported, or operated on (to apply global updates to fixed or variable 
fields, for instance).  No knowledge of SQL is needed.

Thanks in advance for any tips.  As an administrator, I could conceivably do 
this with SQL, but that's not feasible for cataloging staff.  We update large 
quantities of records all the time.


Tasha R. Bales
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz<mailto: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] Advice for how to update huge numbers of bib records, for former Millennium user

[Bales (US), Tasha R]

What would be the Koha equivalent to Millennium Create Lists* (or Alma 
Normalization Rules and Record Sets)?

So far, I see that lists and carts can be used to update records in Koha, but 
this seems to demand working with a pre-determined list of record numbers, or 
else by manually adding items to a cart.  What if I need to update a huge 
number of "unknown" records meeting specific criteria?

Can anyone suggest what the approach would be to accomplish an objective like 
this:

A non-administrator with limited technical skills needs to gather and update 
40,000 bib records in Koha that can't be identified by any single unifying 
attributes.  My Millennium query might have looked like this:

* Bib record not attached to order AND

* (Location is Y or Location is X or Location is Z) and

* Author is not TODD and

* Note doesn't have FREE

*Millennium Create Lists allows you to create a Boolean Search, with up to 
about 20 statements, to query the entire database (various methods to search 
subsets or existing result sets also exist) and saves it to a file that can 
then be exported, or operated on (to apply global updates to fixed or variable 
fields, for instance).  No knowledge of SQL is needed.

Thanks in advance for any tips.  As an administrator, I could conceivably do 
this with SQL, but that's not feasible for cataloging staff.  We update large 
quantities of records all the time.


Tasha R. Bales
___

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: Koha web admin changes saved to master *.conf file?

[Bales (US), Tasha R]

Thanks Alvaro.  I’m coming from Millennium, where I know where everything “is”. 
 I’m sure it will just take me some time to explore files and the database to 
see where everything “is” in Koha.  We are currently experimenting in desktop 
VM’s, VirtualBox.  We may not want to or be able to copy anything to our “real” 
server in the cloud on our corporate network.  I may just keep up the 
copy/paste, as there’s not anything incredibly distinct and critical that I 
need to record.

A dumb question: with my old Oracle database, I was accustomed to being able to 
browse tables and just see what was what using Oracle SQL Developer.  Do you 
all use Toad, or some other utility, to query and work with MariaDB in a GUI?

Thank you so much for your time,


Tasha R. Bales

From: Alvaro Cornejo [mailto:cornejo.alv...@gmail.com]
Sent: Wednesday, January 13, 2021 4:41 PM
To: Bales (US), Tasha R 
Cc: koha@lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] Koha web admin changes saved to master *.conf 
file?


EXT email: be mindful of links/attachments.




Hi Tasha

If you do change parameters through the admin interface, you can check the 
audits log in tools menu. There are several things you can check on there. Not 
sure if you need to enable them in system preferences.

All parameters, koha config as well as biblio database are stored into your 
mysql/maría db. So you can "simply" copy the database from your VM to your real 
server and it will be identical in terms of koha info/config but not config 
files or anything related to the server OS.

If you do manually edit any config file, there is no backup/change trace of it. 
You should backup files manually before editing.

Hope this helps.

Regards

Alvaro



||
[https://drive.google.com/uc?id=1lpgSKUunPpKrvmS1rja7umnEgiqBa_vD=download]
 Stay safe / Cuídate/  Reste sécurisé
7 Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à mesure.
 q Recycle always / Recicla siempre / Recyclez toujours
 P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez 
seulement si nécessaire


Le mer. 13 janv. 2021 à 17:27, Bales (US), Tasha R 
mailto:tasha.r.ba...@boeing.com>> a écrit :
Good afternoon,

I'm configuring a new Koha instance and am interested if the changes made via 
the web admin interface, such as Circulation settings, are all saved to a 
consolidated file on the server.  Whatever changes I make, I'd like to 
reproduce them when I have the chance to move from a VM to a real server.  For 
now, I am copying/pasting.  However, I thought perhaps there is an easier, 
neater way to keep track of any changes I make from the defaults.  I'm still 
new to navigating all the documentation, so please pardon me if I've missed the 
obvious.

Thanks for your time!


Tasha R. Bales

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz<mailto: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] Koha web admin changes saved to master *.conf file?

[Bales (US), Tasha R]

Good afternoon,

I'm configuring a new Koha instance and am interested if the changes made via 
the web admin interface, such as Circulation settings, are all saved to a 
consolidated file on the server.  Whatever changes I make, I'd like to 
reproduce them when I have the chance to move from a VM to a real server.  For 
now, I am copying/pasting.  However, I thought perhaps there is an easier, 
neater way to keep track of any changes I make from the defaults.  I'm still 
new to navigating all the documentation, so please pardon me if I've missed the 
obvious.

Thanks for your time!


Tasha R. Bales

___

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

[Koha] Point to Elasticsearch on a different server?

[Bales (US), Tasha R]

We are working to install Koha on Ubuntu.  We already have an Elasticsearch 
server.  I'd like to ask, has anyone pointed their Koha instance to a different 
server running Elasticsearch, or is this a silly idea (i.e., should we just 
install Elasticsearch onto our Koha server?)?

Thanks for your time,


Tasha R. Bales

___

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

[Koha] Searchable list archive?

[Bales (US), Tasha R]

Good afternoon, in order that I can best help myself to answer questions, and 
avoid annoying others, I just want to ask if there is a searchable archive for 
this Koha list, or a way to accomplish the same.  I find I just have to go 
month by month (at https://lists.katipo.co.nz/pipermail/koha/), and scan 
subjects to try to find information.  Perhaps I've missed something.

Note, the following link to "search through the mailing list archive" (per my 
initial mailing list welcome) fails to open, with an Error 522: 
http://dir.gmane.org/gmane.comp.misc.koha

Thanks for your time!


Tasha R. Bales | Technology Integration Team
Information Services | Enterprise Services
Enterprise Operations, Finance and Sustainability
(480) 509-5415
https://is.web.boeing.com

___

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

[Koha] Zebra required if using Elasticsearch?

[Bales (US), Tasha R]

Good afternoon,

I think the answer to the question in my subject is, "yes", but I'd like to 
check my understanding.  After installing Koha in a VM and reviewing various 
documentation, my understanding was that using Zebra or Elasticsearch was an 
either/or choice, you use one or the other.  However, the Elasticsearch entry 
on the wiki suggests that 
eliminating Zebra dependency in favor of going full Elasticsearch is a work in 
progress.  Is this accurate?

I'm asking because I'm anticipate trouble getting access to download RHEL 
packages for Zebra.  I was 
hoping we could entirely avoid it and just use Elasticsearch.

Thanks for your time!!



Tasha R. Bales

___

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: Red Hat 8, installing dependencies

[Bales (US), Tasha R]

If the pain is great, we may be able to argue for an Ubuntu installation 
(Debian is less likely).  Oracle Linux is another alternative that may be 
available, FWIW.


Tasha R. Bales

From: Christian McDonald [mailto:rcmcdonal...@gmail.com]
Sent: Saturday, December 12, 2020 2:50 PM
To: Bales (US), Tasha R 
Cc: koha@lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] Red Hat 8, installing dependencies


This message was sent from outside of Boeing. Please do not click links or open 
attachments unless you recognize the sender and know that the content is safe.




Are you required to deploy on RHEL? The debian repo makes installing on Debian 
painless.

On Sat, Dec 12, 2020 at 4:38 PM Bales (US), Tasha R 
mailto:tasha.r.ba...@boeing.com>> wrote:
Good afternoon,

I'm trying to install the latest version of Koha on Red Hat 8.1, using the Koha 
Wiki 
instructions<https://wiki.koha-community.org/wiki/Koha_on_Redhat_Enterprise_6> 
for Red Hat 6.  Perhaps you can help with a couple questions.

First, the Wiki contains a list of about 70 dependencies that should be 
installed before Koha. Since the Wiki article is dated, is there a method for 
determining whether this list is still accurate for Red Hat 8 and current Koha? 
 Or, would one just need to be on the lookout for inevitable errors and 
complaints about missing dependencies?

Next, I'm limited to working with a corporate repository-I cannot connect to 
the internet--but I was able to install all but 11 of the recommended packages, 
see below.  I don't necessarily know that all of these are critical 
requirements, but some of them seem significant when I Googled them for more 
info.  They are as follows:


*  cloog-ppl

*  ghostscript-devel (I have the non-devel package)

*  gnome-utils-libs (I don't think we need this)

*  ImageMagick

*  ImageMagick-devel

*  Imake (May not need this)

*  jasper-devel (We have jasper-libs)

*  lcms-devel

*  libXdmcp-devel

*  libxml2-python

*  ppl

If you can advise where I ought to look to gain an understanding of whether 
these missing packages are 1) true requirements for Koha 20.x, given I obtained 
them from an older Wiki article; 2) show-stoppers that will prevent using Koha, 
or certain features of Koha, if they are not present.

I appreciate and thank you in advance for any advice you may have.  I am doing 
a good amount of research on the web to try to answer my own questions, but I'm 
a bit out of my league.  Thanks for your time and consideration,


Tasha R. Bales

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz>
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
--
R. Christian McDonald
M: (616) 856-9291
E: rcmcdonal...@gmail.com<mailto:rcmcdonal...@gmail.com>
___

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

[Koha] Red Hat 8, installing dependencies

[Bales (US), Tasha R]

Good afternoon,

I'm trying to install the latest version of Koha on Red Hat 8.1, using the Koha 
Wiki 
instructions 
for Red Hat 6.  Perhaps you can help with a couple questions.

First, the Wiki contains a list of about 70 dependencies that should be 
installed before Koha. Since the Wiki article is dated, is there a method for 
determining whether this list is still accurate for Red Hat 8 and current Koha? 
 Or, would one just need to be on the lookout for inevitable errors and 
complaints about missing dependencies?

Next, I'm limited to working with a corporate repository-I cannot connect to 
the internet--but I was able to install all but 11 of the recommended packages, 
see below.  I don't necessarily know that all of these are critical 
requirements, but some of them seem significant when I Googled them for more 
info.  They are as follows:


*  cloog-ppl

*  ghostscript-devel (I have the non-devel package)

*  gnome-utils-libs (I don't think we need this)

*  ImageMagick

*  ImageMagick-devel

*  Imake (May not need this)

*  jasper-devel (We have jasper-libs)

*  lcms-devel

*  libXdmcp-devel

*  libxml2-python

*  ppl

If you can advise where I ought to look to gain an understanding of whether 
these missing packages are 1) true requirements for Koha 20.x, given I obtained 
them from an older Wiki article; 2) show-stoppers that will prevent using Koha, 
or certain features of Koha, if they are not present.

I appreciate and thank you in advance for any advice you may have.  I am doing 
a good amount of research on the web to try to answer my own questions, but I'm 
a bit out of my league.  Thanks for your time and consideration,


Tasha R. Bales

___

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

[Koha] Advice for hardware/technical requirements for cloud implementation

[Bales (US), Tasha R]

Good morning,

I'd like to ask for suggestions about hardware recommendations for installing 
Koha.  We have about 1.5 million bibliographic records.  Perhaps the reason 
we're not seeing a lot of info is just that Koha/MySQL/Zebra is relatively 
lightweight?  I've done some Googling and quite a bit of inspection of the Wiki 
and documentation, but haven't found anything specific.  I'm an applications 
admin and don't deal with installing and provisioning servers, so pardon my 
ignorance.  I'm anticipating questions from IT-we anticipate hosting in our own 
cloud, on Ubuntu-and want to be prepared.  We don't plan on uploading files to 
any bib records, if that's relevant.

Thanks in advance for any words of wisdom,


Tasha R. Bales

___

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