Re: [Koha] How to reinstate the field 650 in default framework

[Elaine Bradtke]

You can export the framework and edit it offline as a csv.
Or you could rename it if you want to keep it and install an un edited
default framework.
It's best to avoid editing the default framework and instead create a new
framework.
There are some useful frameworks here:
https://wiki.koha-community.org/wiki/MARC_frameworks
Check the manual for your version of Koha under Catalog administration for
more information on adding and editing frameworks
Elaine
VWML 



On Mon, Feb 26, 2024 at 5:34 AM Tahir Jan, Assistant Librarian, Central
Library, UoP  wrote:

> Dear All
> Hope you this email finds you well.
> I deleted 650 field in the default framework.
> Now I need this field again to make enteries in same. Please help in this
> matter.
> ___
>
> 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] The "one manual" idea

[Elaine Bradtke]

In principle, it's an excellent idea.  It will be a very big editing job
(that's an understatement).  We run on the latest stable release, and often
I find the answers to my questions in older versions of the manual.  How
would you retain the old information alongside the updates?  Each section
in release order? Highlight changes?  It will be tricky to set up. But once
it's done, it will be easier to maintain.
I'm intrigued, and possibly interested in helping out.
Elaine
VWML 



On Thu, Sep 7, 2023 at 7:38 AM Charillon, Aude <
aude.charil...@ptfs-europe.com> wrote:

> Hello,
>
> In the Koha Documentation team, we have been discussing whether we
> still need one version of the manual per Koha version. The idea being
> mooted is that having only one manual for all versions in the future
> may be better.
>
> It's an idea that is still at the exploration stage; at this point we
> would like to get feedback from a wider group of people, hence this
> message! I included further down a summary of what has been raised so
> far. We are particularly interested in your thoughts on the following:
>
> - What would be impacted if we decided to move to one manual - that we
> haven't considered yet (see summary)? What issues may arise, who would
> they affect, what are your suggestions to solve them?
> - Are there any specific considerations for translated versions of the
> manual?
> - Are there any technical considerations that us non-developers
> haven't thought of?
>
> If you have questions, concerns or just think it's a good idea, it
> would also be nice to hear from you :-)
>
> Thanks,
>
> Aude [aude_c on Koha IRC]
> Documentation Manager for the 23.11 cycle
>
>
> Issues with the current situation
> - The documentation cycle doesn't match the Koha development cycle. It
> is near impossible for the Documentation team to document all the new
> features before the new Koha version is released. The manual published
> alongside the new Koha version is always behind.
> - When the manual is updated, the update is made to the master branch
> - the one that matches the numbering of the Koha version currently in
> development. This master branch isn't visible (unless you know where
> to find it). It is possible to "backport" updates to older versions of
> the manual but this is not straightforward. Because we are behind with
> documenting features, some updates would have to go back through
> several older versions of the manual, making the process even less
> straightforward. I'll be honest: it's rare these days when we backport
> to older versions.
> - For library teams, that means the explanation of a feature in their
> Koha version is more likely to be in a newer version of the manual
> (than in the one they'll land on when clicking the Help button).
>
> One manual - why it would be beneficial
> - Everything in one place: all the latest additions and improvements
> to the manual available straight away to everyone everywhere.
> - Translated manuals: only one version to keep on top of.
> - Easier to manage by the community.
>
> How it could work; questions and concerns identified
> - What if something changes in a newer version of Koha / only exists
> in some versions but not others? Wouldn't that be confusing in one
> manual?
> We would need to clearly mark sections with the Koha versions it
> applies to, e.g. "until 22.11", "from 23.05".
>
>
> Aude Charillon
> Customer Services Consultant
> PTFS Europe
> aude.charil...@ptfs-europe.com
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] 23.05 Multiple items - some items display incorrect shelving locations

[Elaine Bradtke]

Nearly all the records that have this display problem include home library,
current library and shelving locations. I'll be interested to see if the
bugfix solves the problem. Thanks!
Elaine
VWML <https://vwml.org>



On Wed, Aug 9, 2023 at 10:34 AM Katrin Fischer 
wrote:

> Hi Elaine,
>
> you might see side effects of this bug:
>
> *Bug 34086*
> <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34086> - On
> detail.tt if item.permanent_location is NULL no shelving location will
> show
>
> It's a display issue where when there are some items with and some
> without location the permanent location will display for items where
> it's not set.
>
> The bugfix was just released and hopefully should resolve any issues.
>
> Hope this helps,
>
> Katrin
>
> On 28.07.23 02:10, Elaine Bradtke wrote:
> > Koha 23.05
> > When looking at bib records that include multiple items with different
> > locations, we sometimes see the following:
> >
> > - The results list shows the correct information.
> > - The bib record holdings view gives the shelving location of one
> item
> > in the list for some  subsequent items.
> > - Edit items displays the correct locations.
> > - The OPAC record displays correctly.
> >
> > This does not happen with all the records that have multiple items with
> > different shelving locations. In some cases only one or two items in the
> > holdings list are displayed incorrectly.  I have not been able to
> discover
> > why it happens to some records and not others.
> > Link to three screenshots:https://photos.app.goo.gl/ocFn48hF6E9GiszQ6
> The
> > bib record with incorrect location display, edit items with correct
> > location information and OPAC view with correct information.
> >
> > It is similar, but not the same as bug 34122
> > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34122  -
> > The records concerned have not been updated / edited;  the information is
> > correct in the database, but displaying incorrectly in some views.
> >
> > The location that seems to be misbehaving  (but possibly because it's the
> > easiest error to detect) is "Off-site" appearing where it shouldn't.
> Would
> > the - be causing a problem?
> >
> > Has anyone else seen something like this?
> >
> > Elaine Bradtke
> > VWML<https://www.vwml.org>
> > English Folk Dance and Song Society<https://www.efdss.org>
> > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> > Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance
> and
> > Song Society in London, England. If you wish to phone me personally, send
> > an e-mail first. I work off site)
> >
> --
> > Registered Company No. 297142
> > Charity Registered in England and Wales No. 305999
> > ___
> >
> > 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

Re: [Koha] [EXTERNAL] Re: Clearing of users

[Elaine Bradtke]

I think Fred's proposal is good.  I often batch change groups of patrons
from one category to another. Works well for us.
Elaine
VWML 



On Wed, Aug 2, 2023 at 7:23 AM King, Fred  wrote:

> Could you make a new patron category that isn't allowed to check out
> books? You could add a notice on the checkout screen: "No checkouts." You
> can probably do it with the tool Batch Patron Modification, though I've
> never used it myself.
>
> Fred King, MSLS, AHIP
> Medical Librarian, MedStar Washington Hospital Center
> fred.k...@medstar.net
> 202-877-6670
> ORCID -0001-5266-0279
> MedStar Authors Catalog: http://medstarauthors.org
>
> Anything that thinks logically can be fooled by something else that thinks
> at least as logically as it does.
> --Douglas Adams
>
> -Original Message-
> From: Koha  On Behalf Of Tom Obrien
> Sent: Wednesday, August 2, 2023 4:26 PM
> To: Ketan Kulkarni 
> Cc: koha 
> Subject: [EXTERNAL] Re: [Koha] Clearing of users
>
>
>
> **ATTENTION: This email originated from outside the MedStar Health network.
>  ** DO NOT CLICK links or attachments unless you recognize the sender and
> know the content is safe.
>
>
>
> Hi Ketan,
> Not really. I am looking for a situation whereby once a user have been
> cleared in the Koha, the person who has been cleared cannot borrow books
> from the system. When such a person attempts to borrow a book, the system
> will deny him/her.
> Regards
>
> On Tue, Aug 1, 2023 at 9:21 PM Ketan Kulkarni  wrote:
>
> > If I understand correctly, you would like to disallow a batch of users
> > from logging into OPAC but the staff users should still be able to
> > checkout/checkin books to those users. Is that right ?
> >
> > A script will be needed to make this work.
> >
> > Warm regards,
> > Ketan
> >
> > On Wed, Aug 2, 2023 at 9:40 AM Ruqaiya Said Alfarsi <
> > ruqaiya.alfa...@unizwa.edu.om> wrote:
> >
> >> It’s a good question, also I need same solution
> >>
> >> في ثلاثاء، 1 أغسطس، 2023 في 8:53 م، كتب Tom Obrien  >:
> >>
> >> > Hi all,
> >> > I work in an academic Library. I would like to put a provision for
> >> clearing
> >> > users who have completed their studies without deleting their account.
> >> How
> >> > do I deactivate their accounts  so that one can use the account to
> >> borrow
> >> > books.
> >> > Looking forward for your advice.
> >> > Thank you.
> >> >
> >> > Tom
> >> > ___
> >> >
> >> > Koha mailing list
> >> > https://urldefense.com/v3/__http://koha-community.org__;!!D7IIWT94A
> >> > A!9RI3bbiuZMzYBQLQTL0IFUyiBB0gq0htR4aGljQMcQTS9rWetTMAXQRRxDVN9ek1r
> >> > weDxtDOFy9wQZL-Fw$
> >> > Koha@lists.katipo.co.nz
> >> > Unsubscribe:
> >> > https://urldefense.com/v3/__https://lists.katipo.co.nz/mailman/list
> >> > info/koha__;!!D7IIWT94AA!9RI3bbiuZMzYBQLQTL0IFUyiBB0gq0htR4aGljQMcQ
> >> > TS9rWetTMAXQRRxDVN9ek1rweDxtDOFy9fib5JOw$
> >> >
> >> --
> >>
> >> --
> >>
> >>  >> A!9RI3bbiuZMzYBQLQTL0IFUyiBB0gq0htR4aGljQMcQTS9rWetTMAXQRRxDVN9ek1rwe
> >> DxtDOFy_HMM1iBA$ >
> >>  >> T94AA!9RI3bbiuZMzYBQLQTL0IFUyiBB0gq0htR4aGljQMcQTS9rWetTMAXQRRxDVN9ek
> >> 1rweDxtDOFy_VLb76nA$ >
> >>  >> WT94AA!9RI3bbiuZMzYBQLQTL0IFUyiBB0gq0htR4aGljQMcQTS9rWetTMAXQRRxDVN9e
> >> k1rweDxtDOFy9-uX8h5g$ >
> >>  >> ium=copy_link__;!!D7IIWT94AA!9RI3bbiuZMzYBQLQTL0IFUyiBB0gq0htR4aGljQM
> >> cQTS9rWetTMAXQRRxDVN9ek1rweDxtDOFy-oe_Q1_A$ >
> >>  >> !D7IIWT94AA!9RI3bbiuZMzYBQLQTL0IFUyiBB0gq0htR4aGljQMcQTS9rWetTMAXQRRx
> >> DVN9ek1rweDxtDOFy_MeXSR5w$ >
> >>  >> T94AA!9RI3bbiuZMzYBQLQTL0IFUyiBB0gq0htR4aGljQMcQTS9rWetTMAXQRRxDVN9ek
> >> 1rweDxtDOFy9YF8xehg$ >
> >>
> >>
> >>
> >> ___
> >>
> >> Koha mailing list
> >> https://urldefense.com/v3/__http://koha-community.org__;!!D7IIWT94AA!
> >> 9RI3bbiuZMzYBQLQTL0IFUyiBB0gq0htR4aGljQMcQTS9rWetTMAXQRRxDVN9ek1rweDx
> >> tDOFy9wQZL-Fw$
> >> Koha@lists.katipo.co.nz
> >> Unsubscribe:
> >> https://urldefense.com/v3/__https://lists.katipo.co.nz/mailman/listin
> >> fo/koha__;!!D7IIWT94AA!9RI3bbiuZMzYBQLQTL0IFUyiBB0gq0htR4aGljQMcQTS9r
> >> WetTMAXQRRxDVN9ek1rweDxtDOFy9fib5JOw$
> >>
> >
> ___
>
> Koha mailing list
> https://urldefense.com/v3/__http://koha-community.org__;!!D7IIWT94AA!9RI3bbiuZMzYBQLQTL0IFUyiBB0gq0htR4aGljQMcQTS9rWetTMAXQRRxDVN9ek1rweDxtDOFy9wQZL-Fw$
> Koha@lists.katipo.co.nz
> Unsubscribe:
> https://urldefense.com/v3/__https://lists.katipo.co.nz/mailman/listinfo/koha__;!!D7IIWT94AA!9RI3bbiuZMzYBQLQTL0IFUyiBB0gq0htR4aGljQMcQTS9rWetTMAXQRRxDVN9ek1rweDxtDOFy9fib5JOw$
> 

[Koha] 23.05 Multiple items - some items display incorrect shelving locations

[Elaine Bradtke]

Koha 23.05
When looking at bib records that include multiple items with different
locations, we sometimes see the following:

   - The results list shows the correct information.
   - The bib record holdings view gives the shelving location of one item
   in the list for some  subsequent items.
   - Edit items displays the correct locations.
   - The OPAC record displays correctly.

This does not happen with all the records that have multiple items with
different shelving locations. In some cases only one or two items in the
holdings list are displayed incorrectly.  I have not been able to discover
why it happens to some records and not others.
Link to three screenshots: https://photos.app.goo.gl/ocFn48hF6E9GiszQ6 The
bib record with incorrect location display, edit items with correct
location information and OPAC view with correct information.

It is similar, but not the same as bug 34122
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34122 -
The records concerned have not been updated / edited;  the information is
correct in the database, but displaying incorrectly in some views.

The location that seems to be misbehaving  (but possibly because it's the
easiest error to detect) is "Off-site" appearing where it shouldn't.  Would
the - be causing a problem?

Has anyone else seen something like this?

Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

[Koha] Lists not downloading from OPAC

[Elaine Bradtke]

Koha 22.11.04
Lists work as expected in the staff interface. But in the OPAC, the email
and print features work, but the download does not.  We get a 500 error
message.
I can save the information directly to Zotero, but attempting to download a
list, in any format, gives the same error.

I searched the system settings for lists and download, and even ISBD, but
found nothing useful.  Suggestions?

Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] Report generation

[Elaine Bradtke]

Warning: what I don't know about SQL queries would fill a book, but I've
adapted one that works for us.

SELECT biblionumber, ExtractValue(`metadata`,'//datafield[@tag="521"]/*')
FROM `biblio_metadata` WHERE
ExtractValue(`metadata`,'count(//datafield[@tag="521"])>0')

If that works you could also do a similar thing for 526 by changing the tag
numbers
Elaine
VWML 



On Tue, Mar 28, 2023 at 12:54 AM zen zenitram  wrote:

> We need cataloging report thats shows Tag 521 or Tag 526.
>
> On Tue, Mar 28, 2023 at 12:54 PM Ketan Kulkarni 
> wrote:
>
> > What kind of report are you trying to generate ?
> > You can get many here
> > https://wiki.koha-community.org/wiki/SQL_Reports_Library
> >
> > Ketan
> >
> > On Tue, Mar 28, 2023 at 9:47 AM zen zenitram 
> > wrote:
> >
> >> Hello
> >>
> >> Any one know how to create report in sql, of your collection that has
> Tag
> >> 521 and 526 in your output.
> >>
> >> Thank you!
> >> ___
> >>
> >> Koha mailing list  http://koha-community.org
> >> Koha@lists.katipo.co.nz
> >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> >
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Record import fails in 22.11

[Elaine Bradtke]

For the sake of anyone who might encounter this problem in future, I asked
my IT person to explain what he did.

Rabbitmq is the queueing service that is used to queue jobs like staging
and importing records.
By default rabbitmq will create listing ports for the Stomp plugin on both
IPv4 and IPv6 addresses.
Our server (a virtual server) is not configured for IPv6.  Creating the
IPv6 port on our server was failing with "Address not available".
I fixed the issue by configuring rabbitmq to only create an IPv4 port:

Added to /etc/rabbitmq/rabbitmq.conf:
stomp.listeners.tcp.1 = 127.0.0.1:61613
#stomp.listeners.tcp.2 = ::1:61613

The first line (...tcp.1) is the IPv4 address.
The second line (commented out with #) is the IPv6 line.

I made this change and restarted both services:

systemctl restart rabbitmq-server

systemctl restart koha-common

After that, all was working fine.
Elaine
VWML <https://vwml.org>



On Sat, Jan 14, 2023 at 6:21 PM Elaine Bradtke  wrote:

> This problem is resolved, seemed to be a local networking issue.
> Elaine
> VWML <https://vwml.org>
>
>
>
> On Tue, Jan 10, 2023 at 10:24 AM Elaine Bradtke  wrote:
>
>> When importing MARC records, after  selecting the file and uploading and
>> setting the parameters for import, once I hit the Stage for import button,
>> Koha jumps back to the page that says choose file.
>> I've tried this with a large batch of authority records and a small (7
>> records) batch of biblio records (both files were downloaded from Koha,
>> edited in MarcEdit) and it failed both times. The biblio file at least
>> works in our production site which is on 22.05.
>> Elaine Bradtke
>> VWML <https://www.vwml.org>
>> English Folk Dance and Song Society <https://www.efdss.org>
>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance
>> and Song Society in London, England. If you wish to phone me personally,
>> send an e-mail first. I work off site)
>> --
>> Registered Company No. 297142
>> Charity Registered in England and Wales No. 305999
>>
>
___

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

Re: [Koha] Record import fails in 22.11

[Elaine Bradtke]

This problem is resolved, seemed to be a local networking issue.
Elaine
VWML <https://vwml.org>



On Tue, Jan 10, 2023 at 10:24 AM Elaine Bradtke  wrote:

> When importing MARC records, after  selecting the file and uploading and
> setting the parameters for import, once I hit the Stage for import button,
> Koha jumps back to the page that says choose file.
> I've tried this with a large batch of authority records and a small (7
> records) batch of biblio records (both files were downloaded from Koha,
> edited in MarcEdit) and it failed both times. The biblio file at least
> works in our production site which is on 22.05.
> Elaine Bradtke
> VWML <https://www.vwml.org>
> English Folk Dance and Song Society <https://www.efdss.org>
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send
> an e-mail first. I work off site)
> --
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
>
___

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

[Koha] Record import fails in 22.11

[Elaine Bradtke]

When importing MARC records, after  selecting the file and uploading and
setting the parameters for import, once I hit the Stage for import button,
Koha jumps back to the page that says choose file.
I've tried this with a large batch of authority records and a small (7
records) batch of biblio records (both files were downloaded from Koha,
edited in MarcEdit) and it failed both times. The biblio file at least
works in our production site which is on 22.05.
Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] Upgrade to 22.11 System Prefernces

[Elaine Bradtke]

I just changed the language setting to  English (en) and removed the
(eng-GB) translation.  Now the menus are correct in the system preferences.
Our production system is running 22.05.05 and it also has the same problem
with menus (the test site is on 22.11).
Is there a bug already filed?
I wonder if this happens in other languages or is it just en-GB

Thanks, at least I know our system isn't fatally corrupted.
I've got a partial list of the affected menu items if that's any use.
Elaine
VWML <https://vwml.org>



On Sun, Dec 18, 2022 at 11:34 PM Katrin Fischer 
wrote:

> Hi Elaine,
>
> you mention problems with the translations - does everything work ok
> with English (en) or are the problems with the system preferences also
> present there?
>
> If the problem is present without translations too, could you create a
> report and show the results?
>
> SELECT * from systempreferences where variable = "name of preference";
>
> Hope this helps,
>
> Katrin
>
> On 13.12.22 20:55, Elaine Bradtke wrote:
> > Something is weird about the System Preferences after upgrading (using
> the
> > latest version of Chrome).  The contents of the pulldown menus in some
> > preferences are just odd.
> >   For instance:  Share anonymous Koha usage data with the Koha community:
> >No religious organisationNo, let me
> think
> > about it   .
> > If that doesn't display it says Share anonymous Koha usage data with the
> > Koha community: religious organisation
> >
> > When we upgraded our test site, the language preference changed back to
> > English (eng) though it had been set to English United Kingdom (eng-GB).
> It
> > says you can reorder the language choices, but that doesn't seem to work.
> > I don't know if it's a translation problem or what?
> > Elaine Bradtke
> > VWML<https://www.vwml.org>
> > English Folk Dance and Song Society<https://www.efdss.org>
> > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> > Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance
> and
> > Song Society in London, England. If you wish to phone me personally, send
> > an e-mail first. I work off site)
> >
> --
> > Registered Company No. 297142
> > Charity Registered in England and Wales No. 305999
> > ___
> >
> > 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] Problem with System Preferences (was Upgrade to 22.11 )

[Elaine Bradtke]

Lots of the system preferences are displaying incorrect menu items. For
instance the pulldown menu for UsageStatsCountry  the list is almost
entirely 'religious organization'.
The OPAC and staff interface seem to be unaffected. I wanted to implement
some new features, which is how I discovered it.
I managed to get five minutes with our volunteer IT wizard and he says it
looks like a problem with the database, and not necessarily related to the
upgrade.
How can we fix this?

Elaine
VWML <https://vwml.org>



On Tue, Dec 13, 2022 at 11:55 AM Elaine Bradtke  wrote:

> Something is weird about the System Preferences after upgrading (using the
> latest version of Chrome).  The contents of the pulldown menus in some
> preferences are just odd.
>  For instance:  Share anonymous Koha usage data with the Koha community:
>   No religious organisationNo, let me
> think about it   .
> If that doesn't display it says Share anonymous Koha usage data with the
> Koha community: religious organisation
>
> When we upgraded our test site, the language preference changed back to
> English (eng) though it had been set to English United Kingdom (eng-GB). It
> says you can reorder the language choices, but that doesn't seem to work.
> I don't know if it's a translation problem or what?
> Elaine Bradtke
> VWML <https://www.vwml.org>
> English Folk Dance and Song Society <https://www.efdss.org>
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send
> an e-mail first. I work off site)
> --
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
>
___

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

[Koha] Upgrade to 22.11 System Prefernces

[Elaine Bradtke]

Something is weird about the System Preferences after upgrading (using the
latest version of Chrome).  The contents of the pulldown menus in some
preferences are just odd.
 For instance:  Share anonymous Koha usage data with the Koha community:
  No religious organisationNo, let me think
about it   .
If that doesn't display it says Share anonymous Koha usage data with the
Koha community: religious organisation

When we upgraded our test site, the language preference changed back to
English (eng) though it had been set to English United Kingdom (eng-GB). It
says you can reorder the language choices, but that doesn't seem to work.
I don't know if it's a translation problem or what?
Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] Google Analytics 4 and Koha 22.05, help needed

[Elaine Bradtke]

We're on 22.05
 I'm looking in koha/tools/additional-contents.pl and still not seeing
"opaccredits"
There is an option to add a new entry. Should I do that?
Elaine
VWML <https://vwml.org>



On Tue, Nov 15, 2022 at 9:45 AM Katrin Fischer 
wrote:

> Hi Elaine,
>
> opaccredits was moved to HTML customizations or if you are on an older
> version to the News tool.
>
> Hope this helps,
>
> Katrin
>
> On 15.11.22 18:41, Elaine Bradtke wrote:
> > "No system preferences matched your search for: opaccredits"
> >
> > Elaine
> > VWML <https://vwml.org>
> >
> >
> >
> > On Tue, Nov 15, 2022 at 9:39 AM Tomas Cohen Arazi 
> > wrote:
> >
> >> Put it in the opaccredits.
> >>
> >> El mar, 15 nov 2022 a las 14:35, Elaine Bradtke ()
> escribió:
> >>
> >>> We haven't been using Google Analytics on Koha, but we thought we would
> >>> try
> >>> it to see if it throws up any useful data. They're switching to a new
> >>> system (Analytics 4). I thought I'd start there, but I haven't had any
> >>> success in implementing it.  Has anyone done this in 22.05 and if so
> could
> >>> you help me out? I know nothing about JavaScript.
> >>>
> >>> Here's what I've tried so far:
> >>> I looked at Koha Geek's tip where it suggests we paste the site tag
> into
> >>> opaccredits, but this doesn't seem to be System preference anymore
> >>> http://kohageek.blogspot.com/2019/01/google-analytics-koha.html
> >>>
> >>>   From Bywater (
> >>>
> >>>
> https://bywatersolutions.com/education/setting-up-google-analytics-with-koha
> >>> ) – add the following to opacuserjs – change the track id to your
> Google
> >>> ID
> >>>
> >>>
> >>> //Begin Google Analytics script
> >>>
> >>>
> >>>
> >>>
> (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
> >>>
> >>> (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new
> >>> Date();a=s.createElement(o),
> >>>
> >>>
> >>>
> m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
> >>>
> >>> })(window,document,'script','
> >>> https://www.google-analytics.com/analytics.js
> >>> ','ga');
> >>>
> >>>
> >>> ga('create', 'trackID', 'auto');
> >>>
> >>> ga('send', 'pageview');
> >>>
> >>>
> >>> //End Google Analytics script
> >>>
> >>>
> >>> This throws up syntax errors about missing semicolons, and 'expected an
> >>> assignment of function call and instead saw an expression'
> >>>
> >>>
> >>>
> >>>  From new Google analytics – (our ID is xed out) - this throws up error
> >>> messages about identifiers, operators and an unrecoverable syntax
> error.
> >>>
> >>>
> >>> 
> >>>
> >>> https://www.googletagmanager.com/gtag/js?id=XXX</a>
> >>> ">
> >>>
> >>> 
> >>>
> >>> window.dataLayer = window.dataLayer || [];
> >>>
> >>> function gtag(){dataLayer.push(arguments);}
> >>>
> >>> gtag('js', new Date());
> >>>
> >>>
> >>> gtag('config', 'XXX');
> >>>
> >>> 
> >>>
> >>>
> >>> Thanks for any help you can offer
> >>>
> >>> Elaine Bradtke
> >>> VWML <https://www.vwml.org>
> >>> English Folk Dance and Song Society <https://www.efdss.org>
> >>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> >>> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance
> and
> >>> Song Society in London, England. If you wish to phone me personally,
> send
> >>> an e-mail first. I work off site)
> >>>
> --
> >>> Registered Company No. 297142
> >>> Charity Registered in England and Wales No. 305999
> >>> ___
> >>>
> >>> 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
>
___

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

Re: [Koha] Google Analytics 4 and Koha 22.05, help needed

[Elaine Bradtke]

"No system preferences matched your search for: opaccredits"

Elaine
VWML <https://vwml.org>



On Tue, Nov 15, 2022 at 9:39 AM Tomas Cohen Arazi 
wrote:

> Put it in the opaccredits.
>
> El mar, 15 nov 2022 a las 14:35, Elaine Bradtke () escribió:
>
>> We haven't been using Google Analytics on Koha, but we thought we would
>> try
>> it to see if it throws up any useful data. They're switching to a new
>> system (Analytics 4). I thought I'd start there, but I haven't had any
>> success in implementing it.  Has anyone done this in 22.05 and if so could
>> you help me out? I know nothing about JavaScript.
>>
>> Here's what I've tried so far:
>> I looked at Koha Geek's tip where it suggests we paste the site tag into
>> opaccredits, but this doesn't seem to be System preference anymore
>> http://kohageek.blogspot.com/2019/01/google-analytics-koha.html
>>
>>  From Bywater (
>>
>> https://bywatersolutions.com/education/setting-up-google-analytics-with-koha
>> ) – add the following to opacuserjs – change the track id to your Google
>> ID
>>
>>
>> //Begin Google Analytics script
>>
>>
>>
>> (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
>>
>> (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new
>> Date();a=s.createElement(o),
>>
>>
>> m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
>>
>> })(window,document,'script','
>> https://www.google-analytics.com/analytics.js
>> ','ga');
>>
>>
>> ga('create', 'trackID', 'auto');
>>
>> ga('send', 'pageview');
>>
>>
>> //End Google Analytics script
>>
>>
>> This throws up syntax errors about missing semicolons, and 'expected an
>> assignment of function call and instead saw an expression'
>>
>>
>>
>> From new Google analytics – (our ID is xed out) - this throws up error
>> messages about identifiers, operators and an unrecoverable syntax error.
>>
>>
>> 
>>
>> https://www.googletagmanager.com/gtag/js?id=XXX</a>
>> ">
>>
>> 
>>
>> window.dataLayer = window.dataLayer || [];
>>
>> function gtag(){dataLayer.push(arguments);}
>>
>> gtag('js', new Date());
>>
>>
>> gtag('config', 'XXX');
>>
>> 
>>
>>
>> Thanks for any help you can offer
>>
>> Elaine Bradtke
>> VWML <https://www.vwml.org>
>> English Folk Dance and Song Society <https://www.efdss.org>
>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
>> Song Society in London, England. If you wish to phone me personally, send
>> an e-mail first. I work off site)
>> --
>> Registered Company No. 297142
>> Charity Registered in England and Wales No. 305999
>> ___
>>
>> 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] Google Analytics 4 and Koha 22.05, help needed

[Elaine Bradtke]

We haven't been using Google Analytics on Koha, but we thought we would try
it to see if it throws up any useful data. They're switching to a new
system (Analytics 4). I thought I'd start there, but I haven't had any
success in implementing it.  Has anyone done this in 22.05 and if so could
you help me out? I know nothing about JavaScript.

Here's what I've tried so far:
I looked at Koha Geek's tip where it suggests we paste the site tag into
opaccredits, but this doesn't seem to be System preference anymore
http://kohageek.blogspot.com/2019/01/google-analytics-koha.html

 From Bywater (
https://bywatersolutions.com/education/setting-up-google-analytics-with-koha
) – add the following to opacuserjs – change the track id to your Google ID


//Begin Google Analytics script


(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){

(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new
Date();a=s.createElement(o),

m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)

})(window,document,'script','https://www.google-analytics.com/analytics.js
','ga');


ga('create', 'trackID', 'auto');

ga('send', 'pageview');


//End Google Analytics script


This throws up syntax errors about missing semicolons, and 'expected an
assignment of function call and instead saw an expression'



From new Google analytics – (our ID is xed out) - this throws up error
messages about identifiers, operators and an unrecoverable syntax error.




https://www.googletagmanager.com/gtag/js?id=XXX</a>
">



window.dataLayer = window.dataLayer || [];

function gtag(){dataLayer.push(arguments);}

gtag('js', new Date());


gtag('config', 'XXX');




Thanks for any help you can offer

Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] Edited authorities not updating in recently edited biblio records

[Elaine Bradtke]

We're on 22.05.01, using Zebra, and I'm beginning to think it's a network
issue on our end.  Sometimes it's very, very slow.
Elaine
VWML <https://vwml.org>



On Mon, Aug 29, 2022 at 9:59 AM Elaine Bradtke  wrote:

> Thanks for the information.
> We're using Zebra and it's no more than ten biblios.
> Elaine
> VWML <https://vwml.org>
>
>
>
> On Thu, Aug 25, 2022 at 11:38 PM Marcel de Rooy 
> wrote:
>
>> Hi Elaine,
>> Please check bug 30883.
>> This fix is in: 22.11.00, 22.05.01, 21.11.10, 21.05.17
>> Questions here are: Are you using ElasticSearch? And does the number of
>> touched biblio records exceed the merge limit ?
>>
>> Regards,
>> Marcel
>>
>> 
>> Van: Koha  namens Elaine Bradtke <
>> e...@efdss.org>
>> Verzonden: donderdag 25 augustus 2022 19:56
>> Aan: koha 
>> Onderwerp: [Koha] Edited authorities not updating in recently edited
>> biblio records
>>
>> I'm in the process of adding some 610 fields to catalogue records. These
>> are linked to existing authority records.  If I then edit the existing
>> authority record (usually to add (Musical group) to the 110) it doesn't
>> update 610 in the biblio record in which I just added the 610.  However,
>> it
>> updates other records linked to that authority.
>> I think this is a timing issue; it will eventually update - possibly
>> related to
>> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D25324data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C45649f4e6aba4229fa8a08da86c35519%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637970470763177952%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7Csdata=BLbZvRu6iJhzhwIrhXuJPxHGujSEYrOYr5JzvG4Pqz8%3Dreserved=0
>>
>> Elaine Bradtke
>> VWML <
>> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.vwml.org%2Fdata=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C45649f4e6aba4229fa8a08da86c35519%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637970470763177952%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7Csdata=VlhTOzD%2BwpwDUfBFfYE%2BwuQYUYvCqs3IQsj3oOKuWSo%3Dreserved=0
>> >
>> English Folk Dance and Song Society <
>> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.efdss.org%2Fdata=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C45649f4e6aba4229fa8a08da86c35519%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637970470763177952%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7Csdata=y2oWxUm%2B%2F10Pg8hHJmjpKWIEtJOoHFlRwZ5fybLSSTk%3Dreserved=0
>> >
>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
>> Song Society in London, England. If you wish to phone me personally, send
>> an e-mail first. I work off site)
>> --
>> Registered Company No. 297142
>> Charity Registered in England and Wales No. 305999
>> ___
>>
>> Koha mailing list
>> https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha-community.org%2Fdata=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C45649f4e6aba4229fa8a08da86c35519%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637970470763177952%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7Csdata=%2BP2Fyb8jAAtCNsYzMJTGi%2Fcf8nZuCA2P5RrgC4t3Upc%3Dreserved=0
>> Koha@lists.katipo.co.nz
>> Unsubscribe:
>> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.katipo.co.nz%2Fmailman%2Flistinfo%2Fkohadata=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C45649f4e6aba4229fa8a08da86c35519%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637970470763177952%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7Csdata=nvSiB2PnG%2Fm2U0LViJvOn%2BmPf03qiOJ5Vd1Jd%2BPs6rY%3Dreserved=0
>> ___
>>
>> 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] Edited authorities not updating in recently edited biblio records

[Elaine Bradtke]

Thanks for the information.
We're using Zebra and it's no more than ten biblios.
Elaine
VWML <https://vwml.org>



On Thu, Aug 25, 2022 at 11:38 PM Marcel de Rooy 
wrote:

> Hi Elaine,
> Please check bug 30883.
> This fix is in: 22.11.00, 22.05.01, 21.11.10, 21.05.17
> Questions here are: Are you using ElasticSearch? And does the number of
> touched biblio records exceed the merge limit ?
>
> Regards,
> Marcel
>
> ________
> Van: Koha  namens Elaine Bradtke <
> e...@efdss.org>
> Verzonden: donderdag 25 augustus 2022 19:56
> Aan: koha 
> Onderwerp: [Koha] Edited authorities not updating in recently edited
> biblio records
>
> I'm in the process of adding some 610 fields to catalogue records. These
> are linked to existing authority records.  If I then edit the existing
> authority record (usually to add (Musical group) to the 110) it doesn't
> update 610 in the biblio record in which I just added the 610.  However, it
> updates other records linked to that authority.
> I think this is a timing issue; it will eventually update - possibly
> related to
> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fbugs.koha-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D25324data=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C45649f4e6aba4229fa8a08da86c35519%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637970470763177952%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7Csdata=BLbZvRu6iJhzhwIrhXuJPxHGujSEYrOYr5JzvG4Pqz8%3Dreserved=0
>
> Elaine Bradtke
> VWML <
> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.vwml.org%2Fdata=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C45649f4e6aba4229fa8a08da86c35519%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637970470763177952%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7Csdata=VlhTOzD%2BwpwDUfBFfYE%2BwuQYUYvCqs3IQsj3oOKuWSo%3Dreserved=0
> >
> English Folk Dance and Song Society <
> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.efdss.org%2Fdata=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C45649f4e6aba4229fa8a08da86c35519%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637970470763177952%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7Csdata=y2oWxUm%2B%2F10Pg8hHJmjpKWIEtJOoHFlRwZ5fybLSSTk%3Dreserved=0
> >
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send
> an e-mail first. I work off site)
> --
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
> ___
>
> Koha mailing list
> https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha-community.org%2Fdata=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C45649f4e6aba4229fa8a08da86c35519%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637970470763177952%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7Csdata=%2BP2Fyb8jAAtCNsYzMJTGi%2Fcf8nZuCA2P5RrgC4t3Upc%3Dreserved=0
> Koha@lists.katipo.co.nz
> Unsubscribe:
> https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.katipo.co.nz%2Fmailman%2Flistinfo%2Fkohadata=05%7C01%7Cm.de.rooy%40rijksmuseum.nl%7C45649f4e6aba4229fa8a08da86c35519%7C635b05eb66c748e1a94fb4b05a1b058b%7C0%7C0%7C637970470763177952%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7Csdata=nvSiB2PnG%2Fm2U0LViJvOn%2BmPf03qiOJ5Vd1Jd%2BPs6rY%3Dreserved=0
> ___
>
> 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] Edited authorities not updating in recently edited biblio records

[Elaine Bradtke]

I'm in the process of adding some 610 fields to catalogue records. These
are linked to existing authority records.  If I then edit the existing
authority record (usually to add (Musical group) to the 110) it doesn't
update 610 in the biblio record in which I just added the 610.  However, it
updates other records linked to that authority.
I think this is a timing issue; it will eventually update - possibly
related to https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25324

Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

[Koha] Error message on upgrade

[Elaine Bradtke]

We're not sure what this means, and or what we need to do to correct it, if
anything.

Upgrade to 22.05.02.000  [18:18:02]: Koha 22.05.02 release
DEV atomic update
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/
bug_30899.pl  [18:18:02]: Bug 30899 - Check borrower_attribute_types FK
constraint (30449 follow-up)
NO PLURAL FORM HEADER FOUND - DEFAULTING TO 2

Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

[Koha] OPAC Keyword search via API ?

[Elaine Bradtke]

We have a very large and complex archives catalogue our web people want to
design a joint search box that would query both Koha and the archives
catalouge (which is currently a custom system that they have to redo).
Has anyone done this with API?
We could use some advice.

Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

[Koha] Patron Self registration system preferences

[Elaine Bradtke]

Koha 21.11.o5
I'm finding contradictory information regarding Patron self registration
with email verification.
What I would like to do - be able to delete self registrations that are not
completed (not verified by email) using a cron job.
What I don't want to do - delete patron accounts that are in the default
self registered category, that have completed the email verification.
The manual says:
"Do not use a regular patron category for this, as any patron who has not
completed the registration verification process will be deleted by the
cleanup_database.pl script after the number of days indicated in
PatronSelfRegistrationExpireTemporaryAccountsDelay, including regular
patrons who have not registered online."
Meanwhile the system preference says:
"*Delete users still in the category indicated by
PatronSelfRegistrationDefaultCategory"*
So what does this really do?
Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] Patron logins, self registration and existing accounts

[Elaine Bradtke]

Thanks for that.
I've been experimenting in our test site.  When I merged the existing
(which didn't have an email) with the self registered (which did)  it
didn't copy over the email address or the password.  That means if I merge
the two, the next time the person logs in, it will fail.
Doesn't seem like that will work for us.

Elaine
VWML <https://vwml.org>



On Mon, May 23, 2022 at 12:26 PM Sue McMillan 
wrote:

> Good morning Elaine,
>
> We are a public library who use Koha version 20.11.17.000.  We do allow
> patrons to self-register via our online OPAC.
>
> The library had CatalystNZ work on the self-registration model so that
> customers could immediately access our online services (ebooks, newspapers,
> etc).  Previous to the update customers were not given a valid barcode
> number which prevented access to these services. Now Koha assigns a valid
> barcode number to the customer. The card number populates both the card
> number and username fields.  Customers choose their own password.
>
> You can use the settings under administration to stop people registering
> using an email address that already exists in Koha, but apart from that
> there are no controls over stopping existing customers from creating a new
> card - which they frequently do.  I just merge the self-registration card
> with their existing card.
>
> We do get some strange and funny self-registrations.   But they make for
> an interesting day.
>
>
> 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
>
> -Original Message-
> From: Koha  On Behalf Of Elaine Bradtke
> Sent: Tuesday, 24 May 2022 6:58 AM
> To: koha 
> Subject: [Koha] Patron logins, self registration and existing accounts
>
> -
> Caution: This email originated from outside of STDC.
> Do not click links or open attachments,
> unless you recognise the sender and know the content is safe.
> -
>
> We're  a research library. Only members of the Society have borrowing
> privileges and very few borrow items. All current members have patron
> accounts.  We're looking at the simplest way to implement user logins. I'm
> trying to understand how self registration and existing patrons work
> together (or not)  in regards to user logins.
> Two questions:
> 1) Every member has a membership id number, a combination of numbers and
> letters (different from their borrowed number).  It would be a simple thing
> to use their membership id number as their temporary password (allowing
> them to change the password once they've logged in).  Does this make sense?
> 2) We  have visiting researchers who aren't members and would like to
> allow them to self-register. If we enable self-registration, what happens
> if someone with an existing (member) account attempts to self-register?
> Would it detect the possible duplicate?  Will it create a second account?
> If there are duplicates, is it possible to merge them?
>
> Just trying to anticipate what will happen before we commit one way or the
> other.
>
>
> Elaine Bradtke
> VWML <https://www.vwml.org>
> English Folk Dance and Song Society <https://www.efdss.org> Cecil Sharp
> House, 2 Regent's Park Road, London NW1 7AY
> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send
> an e-mail first. I work off site)
> --
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
> ___
>
> Koha mailing list  http://koha-community.org 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
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Patron logins, self registration and existing accounts

[Elaine Bradtke]

We're  a research library. Only members of the Society have borrowing
privileges and very few borrow items. All current members have patron
accounts.  We're looking at the simplest way to implement user logins. I'm
trying to understand how self registration and existing patrons work
together (or not)  in regards to user logins.
Two questions:
1) Every member has a membership id number, a combination of numbers and
letters (different from their borrowed number).  It would be a simple thing
to use their membership id number as their temporary password (allowing
them to change the password once they've logged in).  Does this make sense?
2) We  have visiting researchers who aren't members and would like to allow
them to self-register. If we enable self-registration, what happens if
someone with an existing (member) account attempts to self-register?  Would
it detect the possible duplicate?  Will it create a second account?
If there are duplicates, is it possible to merge them?

Just trying to anticipate what will happen before we commit one way or the
other.


Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] OPACnavright in additional contents tool

[Elaine Bradtke]

We still don't know why it happened, but our IT guru managed to fix it by
manually deleting it from the database.
Elaine
VWML <https://vwml.org>



On Mon, May 16, 2022 at 12:00 PM Elaine Bradtke  wrote:

> I've tried again in the test site, and I think the problem may have to do
> with not having text in the default tab? I only entered text in the
> English United Kingdom tab when I broke it. If I add the text in all three
> tabs (default, English and English GB), it works.  However, the editing
> window does not open, I have to force it to open by inserting a line. Still
> need help in deleting the item that doesn't show up in the list. (No, it's
> not expired).
>
> Elaine
> VWML <https://vwml.org>
>
>
>
> On Mon, May 16, 2022 at 10:55 AM Elaine Bradtke  wrote:
>
>> 21.11.05.
>> I encountered a few problems in adding a new item to the right column in
>> the OPAC. First, I noticed there were no options to edit the HTML, just
>> plain text. Then when I saved it, the text repeated itself on the OPAC
>> see https://catalogue.efdss.org/
>> When I look at the /koha/tools/additional-contents the item is not there
>> at all.  I can't find it to edit or delete it.  But it still displays on
>> the OPAC
>> This may be complicated by the fact that we use the English United
>> Kingdom translation (en-GB).
>> Are there some settings I should look at or is this a bug?
>> And if it's a bug, how can I delete the problem text?
>> Thanks!
>> Elaine Bradtke
>> VWML <https://www.vwml.org>
>> English Folk Dance and Song Society <https://www.efdss.org>
>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance
>> and Song Society in London, England. If you wish to phone me personally,
>> send an e-mail first. I work off site)
>> --
>> Registered Company No. 297142
>> Charity Registered in England and Wales No. 305999
>>
>
___

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

Re: [Koha] OPACnavright in additional contents tool

[Elaine Bradtke]

I've tried again in the test site, and I think the problem may have to do
with not having text in the default tab? I only entered text in the
English United Kingdom tab when I broke it. If I add the text in all three
tabs (default, English and English GB), it works.  However, the editing
window does not open, I have to force it to open by inserting a line. Still
need help in deleting the item that doesn't show up in the list. (No, it's
not expired).

Elaine
VWML <https://vwml.org>



On Mon, May 16, 2022 at 10:55 AM Elaine Bradtke  wrote:

> 21.11.05.
> I encountered a few problems in adding a new item to the right column in
> the OPAC. First, I noticed there were no options to edit the HTML, just
> plain text. Then when I saved it, the text repeated itself on the OPAC
> see https://catalogue.efdss.org/
> When I look at the /koha/tools/additional-contents the item is not there
> at all.  I can't find it to edit or delete it.  But it still displays on
> the OPAC
> This may be complicated by the fact that we use the English United Kingdom
> translation (en-GB).
> Are there some settings I should look at or is this a bug?
> And if it's a bug, how can I delete the problem text?
> Thanks!
> Elaine Bradtke
> VWML <https://www.vwml.org>
> English Folk Dance and Song Society <https://www.efdss.org>
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send
> an e-mail first. I work off site)
> --
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
>
___

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

[Koha] OPACnavright in additional contents tool

[Elaine Bradtke]

21.11.05.
I encountered a few problems in adding a new item to the right column in
the OPAC. First, I noticed there were no options to edit the HTML, just
plain text. Then when I saved it, the text repeated itself on the OPAC
see https://catalogue.efdss.org/
When I look at the /koha/tools/additional-contents the item is not there at
all.  I can't find it to edit or delete it.  But it still displays on the
OPAC
This may be complicated by the fact that we use the English United Kingdom
translation (en-GB).
Are there some settings I should look at or is this a bug?
And if it's a bug, how can I delete the problem text?
Thanks!
Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

[Koha] Report help needed

[Elaine Bradtke]

Forwarding this to the list.  Joel's suggestion fixed the problems.
Elaine
VWML <https://vwml.org>



-- Forwarded message -
From: Coehoorn, Joel 
Date: Tue, May 10, 2022 at 11:20 AM
Subject: Re: [Koha] Report help needed
To: Elaine Bradtke 


It could just be my email client, but I see line endings in the wrong
place. It works on my system (in that at least I see data) if I don't
change any code other than fixing formatting and line endings:

SELECT authid, datecreated, authtypecode,
concat(ExtractValue(`marcxml`,'//datafield[@tag="100"]/*'), --
PERSO_NAME
ExtractValue(`marcxml`,'//datafield[@tag="110"]/*'), -- CORPO_NAME
ExtractValue(`marcxml`,'//datafield[@tag="111"]/*'), -- MEETI_NAME
ExtractValue(`marcxml`,'//datafield[@tag="130"]/*'), -- UNIF_TITLE
ExtractValue(`marcxml`,'//datafield[@tag="148"]/*'), -- CHRON_TERM
ExtractValue(`marcxml`,'//datafield[@tag="150"]/*'), -- TOPIC_TERM
ExtractValue(`marcxml`,'//datafield[@tag="151"]/*'), -- GEOGR_NAME
ExtractValue(`marcxml`,'//datafield[@tag="155"]/*')  -- GENRE/FORM
) main_heading
FROM `auth_header`
WHERE datecreated BETWEEN <<(from -mm-dd)>> AND <<(to -mm-dd)>>
ORDER BY datecreated, authtypecode, main_heading


Note that MySql is picky about double-dash (--) comments, and requires
whitespace after the comment characters.

Joel Coehoorn
Director of Information Technology
York College of Nebraska


On Tue, May 10, 2022 at 12:42 PM Elaine Bradtke  wrote:

> I imported the following report from Mana, but it doesn't work as is.  I
> tried changing `marcxml` to `metadata` but it still didn't work. The error
> message (You have an error in your SQL syntax; check the manual that
> corresponds to your MariaDB server version for the right syntax to use near
> '' at line 1) isn't specific enough for my limited abilities.  I'd be
> grateful for your help.
>
> Here's the original:
> SELECT authid, datecreated, authtypecode,
> concat(ExtractValue(`marcxml`,'//datafield[@tag="100"]/*'), --
> PERSO_NAMEExtractValue(`marcxml`,'//datafield[@tag="110"]/*'), --
> CORPO_NAMEExtractValue(`marcxml`,'//datafield[@tag="111"]/*'), --
> MEETI_NAMEExtractValue(`marcxml`,'//datafield[@tag="130"]/*'), --
> UNIF_TITLEExtractValue(`marcxml`,'//datafield[@tag="148"]/*'), --
> CHRON_TERMExtractValue(`marcxml`,'//datafield[@tag="150"]/*'), --
> TOPIC_TERMExtractValue(`marcxml`,'//datafield[@tag="151"]/*'), --
> GEOGR_NAMEExtractValue(`marcxml`,'//datafield[@tag="155"]/*')  --
> GENRE/FORM) main_headingFROM `auth_header`WHERE datecreated BETWEEN <<(from
> -mm-dd)>> AND <<(to -mm-dd)>>ORDER BY datecreated, authtypecode,
> main_heading
>
> Elaine Bradtke
> VWML <https://www.vwml.org>
> English Folk Dance and Song Society <https://www.efdss.org>
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send
> an e-mail first. I work off site)
> --
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
> ___
>
> 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] Export tool failure Koha 21.11.03.000

[Elaine Bradtke]

I just tested it (21.11.05) with Authorities, giving a specific number and
a range of record numbers (1, and then 50 records) both worked. Tried both
XML and MARC.  We are not using AWS.
Elaine
VWML 



On Mon, May 2, 2022 at 3:23 AM Katrin Fischer 
wrote:

> Hi Evan,
>
> there have been no bug reports about the export not working.
>
> Are you exporting authority or bibliographic records?
>
> Which settings do you use?
>
> Does it also happen when you try to export a single or very few records,
> for example by biblionumber range?
>
> Hope this helps,
>
> Katrin
>
>
> On 28.04.22 13:43, Evan Stewart wrote:
> > Hi all,
> >
> > Has anyone else experienced errors with the Export tool in the Tools
> menu?
> >
> > -Evan Stewart
> >
> > On Wed, Apr 13, 2022 at 3:09 AM Evan Stewart 
> > wrote:
> >
> >> Hello,
> >>
> >> I seem to be having a problem with the Export data tool (Tools > Export
> >> Data).  When I click the Export link, I get a "503 Service Unavailable"
> >> message.  All other tools I try are working fine. I'm running Koha on
> AWS
> >> (see details below).
> >>
> >> My local server versions of Koha (running on Debian) are working fine.
> >> Just the AWS install is having the export tool failure.
> >>
> >> Has anyone experienced this problem with exporting data?
> >>
> >> Hosting Environment: AWS Lightsail, 2GB RAM
> >> OS: Debian 10
> >> Koha: 21.11.04.001
> >> Server: Apache 2.4.38
> >>
> >> Any thoughts on how to troubleshoot to discover the cause?
> >>
> >> Thanks,
> >> Evan Stewart
> >>
> >>
> >>
> > ___
> >
> > 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] Report help needed

[Elaine Bradtke]

I imported the following report from Mana, but it doesn't work as is.  I
tried changing `marcxml` to `metadata` but it still didn't work. The error
message (You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'' at line 1) isn't specific enough for my limited abilities.  I'd be
grateful for your help.

Here's the original:
SELECT authid, datecreated, authtypecode,
concat(ExtractValue(`marcxml`,'//datafield[@tag="100"]/*'), --
PERSO_NAMEExtractValue(`marcxml`,'//datafield[@tag="110"]/*'), --
CORPO_NAMEExtractValue(`marcxml`,'//datafield[@tag="111"]/*'), --
MEETI_NAMEExtractValue(`marcxml`,'//datafield[@tag="130"]/*'), --
UNIF_TITLEExtractValue(`marcxml`,'//datafield[@tag="148"]/*'), --
CHRON_TERMExtractValue(`marcxml`,'//datafield[@tag="150"]/*'), --
TOPIC_TERMExtractValue(`marcxml`,'//datafield[@tag="151"]/*'), --
GEOGR_NAMEExtractValue(`marcxml`,'//datafield[@tag="155"]/*')  --
GENRE/FORM) main_headingFROM `auth_header`WHERE datecreated BETWEEN <<(from
yyyy-mm-dd)>> AND <<(to -mm-dd)>>ORDER BY datecreated, authtypecode,
main_heading

Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

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

[Elaine Bradtke]

My best guess would be export the data  and use MarcEdit to do it there.
Here's an old video that discusses a feature under development in 2011.
https://www.youtube.com/watch?v=dhx_hpdPZFI
Elaine
VWML 



On Mon, Feb 21, 2022 at 12:25 AM Bruns, Anke  wrote:

> Hi,
>
> thanks for the replies! As I understand, we should, instead of
> "physically" copying the content to the fixed field, map the search index
> differently.
>
> Personally, I would prefer a copy possibility, as probably the year index
> was meant by Koha developers to search 008 for a reason (wasn't it?). And
> wouldn't a change of the index be overwritten with a new Koha upgrade?
>
> The copy possibility into specified positions of fixed fields would come
> in handy for some other purposes as well, so is there really no way to do
> it?
>
> Have a good week,
> Anke
>
>
>
> --
> Anke Bruns M.A. (LIS)
> Arbeitsgruppe "Anwendungs- und Informationssysteme"
> E-Mail: anke.br...@gwdg.de
> ---
> Achtung! Neue Kontaktdaten!
>
> Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG)
> Burckhardtweg 4, 37077 Göttingen, URL: https://gwdg.de
>
> Support: Tel.: +49 551 39-3, URL: https://gwdg.de/support
> Sekretariat: Tel.: +49 551 39-30001, E-Mail: g...@gwdg.de
>
> Geschäftsführer: Prof. Dr. Ramin Yahyapour
> Aufsichtsratsvorsitzender: Prof. Dr. Norbert Lossau
> Sitz der Gesellschaft: Göttingen
> Registergericht: Göttingen, Handelsregister-Nr. B 598
> ---
> Zertifiziert nach ISO 9001
> ---
>
>
>
>
>
> > -Ursprüngliche Nachricht-
> > Von: Stowasser Rainer 
> > Gesendet: Freitag, 18. Februar 2022 13:04
> > An: Bruns, Anke 
> > Cc: Thomas Klausner ; koha@lists.katipo.co.nz
> > Betreff: Re: [Koha] Batch modification: Possibility to copy subfield
> content to
> > another field's fixed positions?
> >
> > Dear Anke
> >
> > same answer ;-)
> >
> > but a little more work
> >
> >
> > https://wiki.koha-community.org/wiki/Understanding_Zebra_indexing
> >
> > Kind regards
> >
> > Hofrat Mag. Rainer Stowasser
> > Head of Library and Archives ZAMG
> >
> >
> >   Am 18.02.2022 um 12:34 schrieb Bruns, Anke  >  >:
> >
> >   Hi,
> >
> >   thanks! However, alas, we are on Zebra.
> >
> >   Good luck with your solution!
> >
> >   Regards,
> >   Anke
> >
> >
> >
> >
> >
> >
> >   -Ursprüngliche Nachricht-
> >   Von: Koha mailto:koha-
> > boun...@lists.katipo.co.nz> > Im Auftrag von Thomas Klausner
> >   Gesendet: Freitag, 18. Februar 2022 12:31
> >   An: koha@lists.katipo.co.nz  koha@lists.katipo.co.nz>
> >   Betreff: Re: [Koha] Batch modification: Possibility to copy
> > subfield content to
> >   another field's fixed positions?
> >
> >   Hi!
> >
> >   On Fri, Feb 18, 2022 at 11:12:22AM +, Bruns, Anke
> wrote:
> >
> >
> >
> >   in order to be able to use the search index for
> > publication year, the year
> >   must to my knowledge be mentioned in 008, positions
> > 7-10.
> >   Is there a way to populate this with the content
> from
> > 264$c which, in my
> >   case, is always a ? In the templates for batch
> > operations I can only
> >   find ways to copy into fields with subfields, not
> into
> > fixed fields.
> >
> >
> >
> >   If you're using ElasticSearch, you could change the
> > Elasticsearch
> >   mappings to use 264$c for date-of-publication (instead of
> the
> > default
> >   008_/7-10). Though I haven't tested that yet, but we've
> just had
> > a
> >   meeting where we decided to try it this way... :-)
> >
> >   Not really an answer to your question, but if you're only
> asking
> > the
> >   question to get the data searchable, it should be still
> usable.
> >
> >   Greetings,
> >   domm
> >
> >   --
> >   #!/usr/bin/perl
> https://domm.plix.at
> >   for(ref
> bless{},just'another'perl'hacker){s-:+-$"-g&$_.$/}
> >   ___
> >
> >   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  > community.org/>
> >   Koha@lists.katipo.co.nz 
> >   Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >   EXTERNAL EMAIL: Do not click any links or open any attachments
> unless
> > you trust the sender and know the content is safe.
> >
>

Re: [Koha] Special character

[Elaine Bradtke]

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

*Bug 28316*
 - Fix
ES crashes related to various punctuation characters
Elaine
VWML 



On Tue, Jan 18, 2022 at 9:22 AM Victor Barroso Oliveira 
wrote:

> Hi,
> On Ubuntu 18 and Koha 21.05.08 with portuguese BR language
> When we searched the OPAC for a book entitled "A sunny day?" OPAC does not
> find because it has the special character "?"
> How can I resolve this?
> Thanks,
> Victor
> ___
>
> 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] Volume and Issue Numbering in Journals

[Elaine Bradtke]

Charles
We're in a similar situation of just starting to look at the serials module.
I can only speak for 21.11.
You need to create an appropriate numbering formula, or borrow one from the
wiki. Pattern library:
https://wiki.koha-community.org/wiki/Serial_Pattern_Library
There are three variables, so volume / issue is not a problem.
https://koha-community.org/manual//21.11/en/html/serials.html
It's a little tricky, but thankfully there's a test button that will show
you what Koha will do with the info you entered.

Elaine Bradtke
VWML <https://vwml.org>



On Tue, Jan 11, 2022 at 6:08 PM Charles Kelley 
wrote:

> Hi, all!
>
> My library is implementing the serials module. We have been watching
> video tutorials, especially this one by ByWater Solutions: Deep Dive:
> Serials in Koha (https://www.youtube.com/watch?v=DFnS7BK5aPM=27s). It
> seems easy enough -- yes, famous last words, comparable to Innovative
> Interfaces, Inc. and other ILS serial modules.
>
> However, the tutorial is clearly for single-number periodicals, i.e.,
> each issue is its own issue number. Using the tutorial example, Martha
> Stewart Living, no. 390, no. 391, no. 392, etc. How does Koha handle
> two-number  and three-number periodicals, i.e., a journal with a volume and
> issue number, e.g., The Journal of the American Medical Association with
> vol. 3:no. 6, vol. 3:no. 7, etc.?
>
> Many thanks, all!
>
> --
>
> よろしくお願いします。
>
> -- 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 <http://www.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

[Koha] 21.05 update: link from staff interface biblio to OPAC

[Elaine Bradtke]

More a caution than a problem.  If you've been running Koha for a long
time,  the OPACBaseURL may  be "http", rather than https.
Our test OPAC requires a user login.  The link between a biblio record and
the OPAC won't work if the OPACBaseURL says http and the actual url is
https.  The logins keep failing.
Luckily it's an easy fix.

Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] Bug 14689 search on 648

[Elaine Bradtke]

It would certainly be useful.  Depending on the library's collection this
is an important field to help filter search results.

Elaine Bradtke
VWML <https://vwml.org>



On Sat, Nov 6, 2021 at 1:16 AM Fridolin SOMERS 
wrote:

> Hi,
>
> One of our MARC21 customer noticed that MARC field 648 in not searchable
> as subject.
>
> I see this is reported in :
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14689
>
> Should I create a patch to add indexing in "Subject" ?
>
> Best regards,
>
> --
> Fridolin SOMERS 
> Software and system maintainer 濾
> BibLibre, France
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Records visible to those who login

[Elaine Bradtke]

Yes, it's possible.  Helpful video here:
https://bywatersolutions.com/education/hiding-items-on-the-opac
Elaine
VWML 



On Wed, Oct 27, 2021 at 2:01 AM Toni Afandi  wrote:

> Dear All,
>
> If we make OPAC accessible to the public, could we hide some records and
> make them visible to those who login.
>
> Thank you in advance,
>
> *Toni Afandi*
> *Librarian*
> *STT SAAT*
> *(Southeast Asia Bible Seminary)*
> Jl. Bukit Hermon No 1, Tidar Atas
> Malang, Jawa Timur 65151
> Indonesia
> www.seabs.ac.id
> ___
>
> 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] Off-site storage

[Elaine Bradtke]

Belatedly I discovered that only one status will display and the restricted
status field hides 'not for loan'.  Though the information is still there
in the staff interface.  I don't think this will be a problem. But you
folks on the coal face may feel differently.
Elaine
VWML <https://vwml.org>



On Thu, Oct 21, 2021 at 10:12 AM Elaine Bradtke  wrote:

> I would like to ask how other libraries are handling material in remote
> storage.  Currently, we only have a location code for off-site material.
> However, it seems we need a  way to clearly indicate that the material must
> be requested a certain amount of time in advance.
>
> Do you use the holds module for these items?  We haven't used patron
> logins, or holds because it's primarily a reference collection.
> Do you treat remote storage as a branch?
> So many options, please tell me what works best for you.
>
> Elaine Bradtke
> VWML <https://www.vwml.org>
> English Folk Dance and Song Society <https://www.efdss.org>
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send
> an e-mail first. I work off site)
> --
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
>
___

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

Re: [Koha] Off-site storage

[Elaine Bradtke]

Thank you, that is very helpful.  I will experiment with our test instance.
Elaine
VWML <https://vwml.org>



On Thu, Oct 21, 2021 at 9:47 PM Charles Kelley 
wrote:

> Hi, Elaine et al!
>
> In our latest exchange, on 22 Oct. 2021 at 08:01 [JST], I received
> this from Elaine Bradtke :
>
> I would like to ask how other libraries are handling material in remote 
> storage.
>> Currently, we only have a location code for off-site material. However,
>> it seems we need a way to clearly indicate that the material must be
>> requested a certain amount of time in advance.
>>
>> Do you use the holds module for these items?  We haven't used patron logins,
>> or holds because it's primarily a reference collection. Do you treat
>> remote storage as a branch? So many options, please tell me what works
>> best for you.
>>
>
> Yes, after a fashion, we use a branch. Here's what I mean.
>
>- We made a library for offsite storage. Here are the Koha values we
>filled in.
>   - Code = OFF
>   - Name = Offsite Storage
>   - OPAC Info = To get this work, please place a hold for it or
>   contact the library staff.
>
> Please allow approximately 7-10 days.
>
>- All the other fields are left empty so that other libraries can use
>   the OFF library.
>
>
>- In the item record, we change 952 $b to OFF (Offsite Storage). It's
>the only subfield we have to change.
>
>
>- In the system preferences, we make sure both the home library and
>the current library are to be displayed (OPACLocationBranchToDisplay).
>
> Why this arrangement?
>
>- It shows that the library still owns at least one copy, and it came
>from the XXX collection in the YYY shelving location.
>- It shows that the copy has been put in storage.
>- The rollover (mouseover, balloon tag or help tag if you prefer)
>instructs how to get the work and approximately how long it ought to
>take.
>
> We usually go to storage to retrieve materials twice a week (Mondays and
> Thursdays), so an estimate of 7-10 days probably lengthens the
> expectations, so that patrons are pleased, to paraphrase Scotty's "How do
> think I keep my reputation as a miracle worker," when the work comes 3-4
> days later instead. Of course, in the long term, the general expectations
> will shorten to reflect reality.
>
>- The library staff will not have to record the XXX collection and YYY
>shelving location in 952 $x in case the work is reintegrated into the
>collection. It's a simple change of copying the home library into the
>current library.
>- The wording is to allow other libraries and branches to use the same
>code if they need it.
>
> I have to state that no procedure is perfect. But it, along with
> patron education, works reasonably well, and that's usually enough for the
> library staff and our patrons.
>
> If you have questions, please may you be encouraged to ask.
>
> --
>
> 気を付けて。 /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 <http://www.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] Off-site storage

[Elaine Bradtke]

I would like to ask how other libraries are handling material in remote
storage.  Currently, we only have a location code for off-site material.
However, it seems we need a  way to clearly indicate that the material must
be requested a certain amount of time in advance.

Do you use the holds module for these items?  We haven't used patron
logins, or holds because it's primarily a reference collection.
Do you treat remote storage as a branch?
So many options, please tell me what works best for you.

Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] Local use preference OPACviewMARC doesn't switch off?

[Elaine Bradtke]

As I said before, we don't customize Koha.  It's there, we didn't add it.
Elaine
VWML 



On Tue, Oct 19, 2021 at 11:36 AM Owen Leonard  wrote:

> > It is, however, listed under the Local use tab.
>
> I somehow missed this part of your original message. Preference can
> show up under Local use if they're not officially part of Koha. If you
> had a customization at one time which included that preference it
> would make sense that it is still around even if the customization is
> long gone.
>
> It's not part of Koha.
>
>  -- Owen
>
___

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

Re: [Koha] Local use preference OPACviewMARC doesn't switch off?

[Elaine Bradtke]

It's not a local customization.  It is, however, listed under the Local use
tab.  It's a toggle switch.  see
https://drive.google.com/file/d/1B9B0jpJAp3yc-oFzGFYWjrQadT3qGgHv/view?usp=sharing

For what it's worth, the ISBD switch doesn't appear to do anything either.

Because we're unsupported, and our IT guru is a volunteer, we try very hard
not to do any add-on tweaks that will break when we upgrade.  I'd much
prefer to use the built in systems. . . when they work.
Elaine
VWML 



On Tue, Oct 19, 2021 at 4:26 AM Owen Leonard  wrote:

> > However, when I switched OPACviewMARC off and saved the change, it didn't
> > seem to make a difference.
>
> In my system there is no OPACviewMARC system preference. Could this be
> a local customization?
>
>  -- 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

Re: [Koha] Framework Reports : The Next Iteration

[Elaine Bradtke]

I gather from this that
a) there are biblios in the catalogue without a framework
b) this causes the report without the null statement to fail.
Interesting.
Elaine
VWML 



On Tue, Oct 5, 2021 at 9:08 PM Charles Kelley  wrote:

> Hi again, all!
>
> I found a workaround for my library's problem with the empty downloads
> of bib. records compiled by
>
> SELECT biblio.biblionumber AS 'Bib. Record No.', biblio.author AS
>> 'Author', biblio.title AS 'Title'
>> FROM biblio
>> WHERE biblio.frameworkcode = <>
>> ORDER BY biblio.biblionumber ASC
>>
>
> In a duplicate of the report above, I changed the WHERE clause to
>
> WHERE biblio.frameworkcode = '' OR biblio.frameworkcode IS NULL
>>
>
> The new report becomes
>
> SELECT biblio.biblionumber AS 'Bib. Record No.', biblio.author AS
>> 'Author', biblio.title AS 'Title'
>> FROM biblio
>> WHERE WHERE biblio.frameworkcode = '' OR biblio.frameworkcode IS NULL
>> ORDER BY biblio.biblionumber ASC
>>
>
> While it is not ideal, it works well enough for my library's purposes
> (counts, identification of bib. records, etc.).
>
> We still welcome suggestions on how to exterminate this bug if you
> have any. But for the time being, the interim solution above will do.
>
> -
>
> -- 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

Re: [Koha] Excluding fields from the OPAC search

[Elaine Bradtke]

Sometimes you really do need human readable non-public information.
Especially if you have a collection like ours, with a lot of unique
material, stashed all over the building. We have information the staff
needs that we don't necessarily want publicly available.  For instance,
locations of rare and valuable material.  Though our OPAC says 'storage'
for these, if you know what to search for they will come up in a keyword
search.
Non public notes and the ability to really obscure certain things in the
OPAC are in MARC for a reason, it can be a security issue.

I would be interested to know if this is also happening with
elasticsearch.  We haven't made the switch, but if elasticsearch does the
right thing in this respect, it would be worth it to change over.

Elaine
VWML 



On Wed, Oct 6, 2021 at 4:18 AM Katrin Fischer 
wrote:

> Hi,
>
> unfortunately the problem is a bit more complicated. :(
>
> I think since our switch from grs-1 to dom indexing, the kw index
> includes the whole record, where before that switch it was 'everything
> that is indexed'. So changing the configuration of individual
> fields/indexes won't make a difference. See:
>
> *Bug 15050*
>  -
> Nonpublic note searchable from OPAC
>
> I am not sure if this is solved already with Elasticsearch.
>
> Some things you could do to avoid issues is linking 952$e to a vendor
> record using the id. I've been thinking it would be nice if we had a
> value builder to do this for a while. If you add items from acquisition
> it will also fill source of acquisition with the id, so that would make
> things more consistent.
>
> For internal notes I think a good rule of thumb would be to avoid using
> personal names whenever possible. For some use cases internally agreed
> on codes or the cardnumber might work. Having a separate feature for
> adding notes that don't end up in the MARC records (and possible
> exports, OAI etc.) might be a good idea anyway.
>
> Hope this helps
>
> Katrin
>
> On 06.10.21 13:04, Owen Leonard wrote:
> >> (e. g.
> >> MARC 952$e the source of acquisition, or MARC 952$x the non-public note)
> > If these are indexed by default I think that should be considered a bug.
> >
> >   -- Owen
> >
> ___
>
> 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] Framework Reports

[Elaine Bradtke]

We're on 21.05
Elaine
VWML 



On Tue, Oct 5, 2021 at 6:31 PM Charles Kelley  wrote:

> Hello, Elaine, et al!
>
> In our latest exchange, on 6 Oct. 2021 at 05:50 [JST], I received the
> following through the Koha Discussion Group:
>
> Thank you for your reply.
>
> ODS worked for me, I haven't tried the other two.  Which version of Koha
>> are you using?
>> Elaine
>> VWML 
>>
>
> Koha 20.05. We will begin migrating to 20.11 in a month or so, first
> on the development machine, then on the production machine.
>
> --
>
> 気を付けて。 /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

Re: [Koha] Framework Reports

[Elaine Bradtke]

ODS worked for me, I haven't tried the other two.  Which version of Koha
are you using?
Elaine
VWML 



On Sun, Oct 3, 2021 at 7:03 PM Charles Kelley  wrote:

> Hi, all!
>
> In our latest exchange, on 3 Oct. 2021 at 08:01 [JST], I received this
> through the Koha Discussion Group:
>
> for the existing runtime parameters you can refer to the manual:
> >
> >
> >
> https://koha-community.org/manual//21.05/en/html/reports.html#report-from-sql
> >
> > The one for frameworks is <>
> >
>
> Thank you for the advisement. My report works properly now excepting
> for one problem: While I now get a proper list, when I press the Download
> button, I get only the header. The actual downloaded report is empty
> excepting for the header. Worse, the downloaded report is empty only when
> the selected framework is the default. The reports for the other
> frameworks, e.g., BK (for textual materials), do indeed download the
> biblionumber, author, and title.
>
> Here's the SQL instruction in its entirety:
>
> SELECT biblio.biblionumber AS 'Bib. Record No.', biblio.author AS 'Author',
> > biblio.title AS 'Title'
> > FROM biblio
> > WHERE biblio.frameworkcode = <>
> > ORDER BY biblio.biblionumber ASC
> >
>
> This happens to all three download file options: CSV, TAB, and ODS.
>
> Any advice on fixing this? Is this a bug? I didn't see such a bug on
> Bugzilla, so I submitted one, by the way.
>
> --
>
> 気を付けて。 /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] Display issue: IntranetNav in 21.05.02.003

[Elaine Bradtke]

Thanks!  That works brilliantly.  My HTML skills date from the last
century. . . .and I think I forgot most of what I knew.
Elaine
VWML <https://vwml.org>



On Tue, Aug 31, 2021 at 11:07 AM Lucas Gass 
wrote:

> Hi Elaine,
>
> In the IntranetNav system pref the , , and  tags are all
> unnecessary.
> It is also best if you wrap your links in HTML  elements. I would try
> replacing your current HTML with this:
>
> http://paste.koha-community.org/2551
>
> Cheers,
>
> On Tue, Aug 31, 2021 at 11:46 AM Elaine Bradtke  wrote:
>
>> Here's what we have at the moment:
>> 
>> 
>> 
>> Test navigator bar staff client
>> 
>> 
>> > href="https://sites.google.com/a/efdss.org/library-staff-koha-manual/
>> ">Manual
>> |  http://koha.randomnotes.org/;>OPAC
>> |  > href="
>> http://kohaadmin.randomnotes.org/cgi-bin/koha/cataloguing/addbooks.pl
>> ">New
>> Biblio
>> |  > href="
>>
>> http://kohaadmin.randomnotes.org/cgi-bin/koha/authorities/authorities-home.pl
>> ">Authorities
>> |  http://catalogue-admin.efdss.org/;>Main site |
>>  > href="
>>
>> https://sites.google.com/a/efdss.org/library-staff-koha-manual/home/cataloguing/classification-scheme
>> ">Classification
>> Scheme
>> |
>> 
>> 
>>
>> It was longer - I cut out the part that said* THIS IS THE TEST SITE*
>> With that there, it pushed the More menu right off the edge of the window.
>> It seems to me the IntranetNav window is a tad too small, and or it
>> doesn't
>> adapt to the size of the window.
>> Elaine
>> VWML <https://vwml.org>
>>
>>
>>
>> On Tue, Aug 31, 2021 at 1:41 AM Jonathan Druart <
>> jonathan.dru...@bugs.koha-community.org> wrote:
>>
>> > Hi Elaine,
>> >
>> > How many links do you have? Can you share your IntranetNav content?
>> > I do see the overlap described on 23840 but the "More" moving all
>> around.
>> > It appears on a separate line if the line is too long for the window,
>> > but it's the best we can do, in my opinion.
>> >
>> > Regards,
>> > Jonathan
>> >
>> >
>> > Le lun. 30 août 2021 à 20:35, Elaine Bradtke  a écrit :
>> > >
>> > > Our test site is on  21.05.02.003 .  Our production site is 21.05.00
>> The
>> > > problem is in  21.05.02.003
>> > > We have some extra links in the IntranetNav There seems to be a limit
>> to
>> > > how much you can put to the left of the More menu.
>> > > Once exceeded, the More menu ends up on the next line, but in an odd
>> > place.
>> > > In this case on the very far left of the page:
>> > >
>> >
>> https://drive.google.com/file/d/1AWF36xmnYSkvsxT-n7a9a4N6W2kGPFNn/view?usp=sharing
>> > > When the More menu is clicked, it actually falls off the edge of the
>> > page -
>> > > there's no way to bring it into view.
>> > >
>> >
>> https://drive.google.com/file/d/19fb6nR21jWKJG1-4WObawP4vBrCGoOX-/view?usp=sharing
>> > > By cutting down on the number of characters that display, I managed to
>> > > bring it into view, More is still on the next line, despite the fact
>> that
>> > > there is plenty of room for it above.
>> > > Weirdly (and I struggle with left and right, so I never thought about
>> it
>> > > before), the production site running the older version puts our added
>> > links
>> > > to the RIGHT of the More menu, but on the same line.
>> > >
>> > > I'm not sure if it's related to bug 23840
>> > > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23840> or
>> if
>> > > it's a new problem.
>> > >
>> > > Elaine Bradtke
>> > > VWML <https://www.vwml.org>
>> > > English Folk Dance and Song Society <https://www.efdss.org>
>> > > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>> > > Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance
>> > and
>> > > Song Society in London, England. If you wish to phone me personally,
>> send
>> > > an e-mail first. I work off site)
>> > >
>> >
>> --
>> > > Registered Company No. 297142
>> > > Charity Registered in England and Wales No. 305999
>> > > ___
>> > >
>> > > 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
>>
>
>
> --
> Lucas Gass
> Web Developer
>
>
___

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

Re: [Koha] Display issue: IntranetNav in 21.05.02.003

[Elaine Bradtke]

Here's what we have at the moment:



Test navigator bar staff client


https://sites.google.com/a/efdss.org/library-staff-koha-manual/
">Manual
|  http://koha.randomnotes.org/;>OPAC
|  http://kohaadmin.randomnotes.org/cgi-bin/koha/cataloguing/addbooks.pl
">New
Biblio
|  http://kohaadmin.randomnotes.org/cgi-bin/koha/authorities/authorities-home.pl
">Authorities
|  http://catalogue-admin.efdss.org/;>Main site |
 https://sites.google.com/a/efdss.org/library-staff-koha-manual/home/cataloguing/classification-scheme
">Classification
Scheme
|



It was longer - I cut out the part that said* THIS IS THE TEST SITE*
With that there, it pushed the More menu right off the edge of the window.
It seems to me the IntranetNav window is a tad too small, and or it doesn't
adapt to the size of the window.
Elaine
VWML <https://vwml.org>



On Tue, Aug 31, 2021 at 1:41 AM Jonathan Druart <
jonathan.dru...@bugs.koha-community.org> wrote:

> Hi Elaine,
>
> How many links do you have? Can you share your IntranetNav content?
> I do see the overlap described on 23840 but the "More" moving all around.
> It appears on a separate line if the line is too long for the window,
> but it's the best we can do, in my opinion.
>
> Regards,
> Jonathan
>
>
> Le lun. 30 août 2021 à 20:35, Elaine Bradtke  a écrit :
> >
> > Our test site is on  21.05.02.003 .  Our production site is 21.05.00  The
> > problem is in  21.05.02.003
> > We have some extra links in the IntranetNav There seems to be a limit to
> > how much you can put to the left of the More menu.
> > Once exceeded, the More menu ends up on the next line, but in an odd
> place.
> > In this case on the very far left of the page:
> >
> https://drive.google.com/file/d/1AWF36xmnYSkvsxT-n7a9a4N6W2kGPFNn/view?usp=sharing
> > When the More menu is clicked, it actually falls off the edge of the
> page -
> > there's no way to bring it into view.
> >
> https://drive.google.com/file/d/19fb6nR21jWKJG1-4WObawP4vBrCGoOX-/view?usp=sharing
> > By cutting down on the number of characters that display, I managed to
> > bring it into view, More is still on the next line, despite the fact that
> > there is plenty of room for it above.
> > Weirdly (and I struggle with left and right, so I never thought about it
> > before), the production site running the older version puts our added
> links
> > to the RIGHT of the More menu, but on the same line.
> >
> > I'm not sure if it's related to bug 23840
> > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23840> or if
> > it's a new problem.
> >
> > Elaine Bradtke
> > VWML <https://www.vwml.org>
> > English Folk Dance and Song Society <https://www.efdss.org>
> > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> > Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance
> and
> > Song Society in London, England. If you wish to phone me personally, send
> > an e-mail first. I work off site)
> >
> --
> > Registered Company No. 297142
> > Charity Registered in England and Wales No. 305999
> > ___
> >
> > 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] Display issue: IntranetNav in 21.05.02.003

[Elaine Bradtke]

Our test site is on  21.05.02.003 .  Our production site is 21.05.00  The
problem is in  21.05.02.003
We have some extra links in the IntranetNav There seems to be a limit to
how much you can put to the left of the More menu.
Once exceeded, the More menu ends up on the next line, but in an odd place.
In this case on the very far left of the page:
https://drive.google.com/file/d/1AWF36xmnYSkvsxT-n7a9a4N6W2kGPFNn/view?usp=sharing
When the More menu is clicked, it actually falls off the edge of the page -
there's no way to bring it into view.
https://drive.google.com/file/d/19fb6nR21jWKJG1-4WObawP4vBrCGoOX-/view?usp=sharing
By cutting down on the number of characters that display, I managed to
bring it into view, More is still on the next line, despite the fact that
there is plenty of room for it above.
Weirdly (and I struggle with left and right, so I never thought about it
before), the production site running the older version puts our added links
to the RIGHT of the More menu, but on the same line.

I'm not sure if it's related to bug 23840
<https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23840> or if
it's a new problem.

Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

[Koha] 590 local note public and non public notes not displaying properly

[Elaine Bradtke]

We use a 590 local note for some material.
There is a subfield x Non Public Note which contains information for the
staff regarding the content of the work, and a subfield z Public note that
contains a generic statement governed by an authorized value.

What we see in the normal view in both the staff interface and the OPAC is
the Non Public note and the code for the authorized value for the public
note.
In the OPAC, it displays correctly in labeled MARC. In plain MARC it only
displays the authorized value code.  See
https://catalogue.efdss.org/cgi-bin/koha/opac-detail.pl?biblionumber=65305
for an example.

Non public notes seem to work as expected in the item records.
This worked before we upgraded to 21.05

Should I file a bug?
Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

[Koha] Staff interface requests multiple logins

[Elaine Bradtke]

We're running 20.11.06 on our test site.  In the staff interface searching,
and editing a found record work fine.  The problem occurs when I try to use
authorities (any step of the process from searching, to looking at one, to
editing one, or any method used to create a new biblio.

authorities/authorities-home.pl
authorities/
authorities-home.pl?op=do_search=intranet==mainmainentry_or=and==contains=harmonica=HeadingAsc
authorities/authorities.pl?authid=11041
cataloguing/addbooks.pl
cataloguing/z3950_search.pl?biblionumber==Default
cataloguing/addbiblio.pl?frameworkcode=BKS

We can't find anything suspicious in the log files.  It happens on chrome
and firefox (running windows). I don't know if this makes a difference, but
the test site is http not https.
Any ideas what we should look for?

Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

[Koha] Using API to import borrower data

[Elaine Bradtke]

I'm not the technical half of the team, so I'm learning as I go along.  Has
anyone used API to import borrower records from another source?

Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

[Koha] Connecting to an outside database for borrower info

[Elaine Bradtke]

Members of our Society have the ability to borrow items from the library.
I am given a quarterly update of the membership list that I convert into a
file that will upload to Koha.  My colleagues were wondering if there was a
way to avoid this process and connect directly to the membership database
(Spektrix).  It's new, and I don't have access to it, so I don't know
anything about it.

It seems to me that this won't work because the loan information is stored
in Koha.

Has anyone tried to connect to an outside database for borrowers? I'm
imagining this would involve a complicated interface.

Elaine Bradtke
VWML <https://www.vwml.org>
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] Btach Modification for Barcode

[Elaine Bradtke]

It may be simpler to edit them offline, by downloading and using MarcEdit.
https://marcedit.reeset.net/downloads  Then upload them, overwriting the
originals.
Elaine
VWML 



On Mon, Apr 19, 2021 at 9:38 AM Himanshu Aggarwal 
wrote:

> I have extra 00s in almost 100 records. How can I modify it in a simplest
> manner.
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Koha wiki update/replacement

[Elaine Bradtke]

I agree with Galen, that a combination of archiving and migration is best.
The trick is winnowing out what is obsolete and keeping what is relevant.
This could get pretty granular - for instance, the reports - some of them
are non-functional due to changes in Koha over time.  I wouldn't want to
completely dump them, but it would be a lot of work to clear out the broken
ones.

Elaine
VWML 



On Wed, Mar 10, 2021 at 9:15 AM Galen Charlton 
wrote:

> Hi,
>
> On Wed, Mar 10, 2021 at 11:48 AM Caroline Cyr-La-Rose <
> caroline.cyr-la-r...@inlibro.com> wrote:
> >
> > - Should we continue with a more recent version of MediaWiki or change
> > the software?
>
> I can commit to doing an in-place MediaWiki upgrade over the next six
> weeks, but, read on...
>
> > It has been argued that maybe MediaWiki is a bit to complex for our
> > needs. DokuWiki (https://www.dokuwiki.org/dokuwiki) was cited as an
> > option, but it's apparently too light and one needs to learn the special
> > syntax.
>
> In the long run, I'd be in favor of our giving serious consideration to
> migrating to DokuWiki.
>
> > - Would you be in favor of starting over?
>
> I think there would be a lot of benefit to archiving the current wiki and
> starting fresh, but there's definitely some content that should not only be
> brought over to a new platform, but have URL redirects put in place. I'm
> thinking of things like the SQL and jQuery libraries in particular.
>
> Regards,
>
> Galen
> --
> Galen Charlton
> Implementation and Services Manager
> Equinox Open Library Initiative
> phone:  1-877-OPEN-ILS (673-6457)
> email:  g...@equinoxinitiative.org
> web:  https://equinoxInitiative.org
> direct: +1 770-709-5581
> cell:   +1 404-984-4366
> ___
>
> 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] linking bibliographic records to authority records

[Elaine Bradtke]

Indeed there is a way to do this!
You might find this useful:
https://bywatersolutions.com/education/authorities-town-hall-recap
Elaine
VWML 



On Mon, Mar 8, 2021 at 1:52 PM David Lesniaski 
wrote:

> Hi everyone,
>  Just by way of introduction, I teach in the MLIS program at St. Catherine
> Univ., St. Paul, MN, USA.  We use KOHA in our program as a "sandbox" for
> students to experiment with in their cataloging, systems, and collection
> development courses.
>
> I have one somewhat involved question.
> We are running version   17.11.05
>
> If I upload a batch of bibliographic records and a separate batch of
> authority records that match the authority controlled fields in the bib
> records, how do I link the two data sets without going into each bib
> record?  That is, if I upload the marc subject authority record for
> "Gourmet cooking" and then upload a bib record with that as a 650, how do I
> get the bib 650 to connect to the authority 150 automatically?
>
> I find that if I load the authorities, then upload the bib records, when I
> go into/edit each bib record and save it (even if I don’t change any of the
> bib data), it will link to the proper authority records.  Is there any way
> to connect the records without going into each bib record?
>
> I’ve tried a few different settings but without success.
>
> In system preferences/authorities I now have (my configuration in CAPS)
> - AuthorityMergeMode: When updating biblio records from an attached
> authority record ("merging"), handle subfields of relevant biblio record
> fields in LOOSE mode.
> - AutoCreateAuthorities: When editing records, GENERATE authority records
> that are missing
> - BiblioAddsAuthorities: When editing records, ALLOW them to automatically
> create new authority records if needed, …
> …
> LinkerModule: Use the DEFAULT linker module for matching headings to
> authority records.
> LinkerOptions: Set the following options for the authority linker
> “BROADER_HEADINGS (separate options with |)
>
> What am I missing?
>
> Any suggestions you might have are very welcome.  I have a huge batch of
> bib & related authorities to add, and the thought of having to call up each
> bib record to activate the link … well … life isn’t that long!
>
> Many thanks,
>
> -- David
>
> Dr. David Lesniaski
> Associate Professor
> MLIS Program
> St. Catherine University
> 2004 Randolph Ave. #4125
> St. Paul, MN 55105
> dalesna...@stkate.edu
> he, him, his
> ___
>
> 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] Fwd: SQL Report Coding need.

[Elaine Bradtke]

I'm a cut and paste report writer, I think you need someone who really
understands SQL.  Forwarding to the list.
Elaine
VWML <https://vwml.org>



-- Forwarded message -
From: MAMCET Library 
Date: Sat, Jan 16, 2021 at 7:30 PM
Subject: Re: [Koha] SQL Report Coding need.
To: Elaine Bradtke 


This report genereted but not out put ples help.
Koha version 20.4

This report run Error in "T1.accounttype "

SELECT
CONCAT("http://boraccount.pl/?borrowernumber=>", T1.borrowernumber, "\"
target=\"_blank\">View Transaction") AS 'Click to view'
, DATE_FORMAT(DATE(T1.timestamp), "%d/%m/%Y") AS 'Txn Date'
, T2.cardnumber AS 'Lib Card No.'
, CONCAT(T2.surname) AS 'Students Name'
, T3.description AS 'Category'
  , T2.borrowernotes AS 'Dapartment'
, CONCAT(LPAD(REPLACE(ROUND(T1.amount, 2),"-", ""), 8, " ")) AS 'Paid
Amount'
FROM
`accountlines` T1
 LEFT JOIN borrowers T2 USING (borrowernumber)
LEFT JOIN categories T3 USING (categorycode)
WHERE
T1.accounttype="PAY"
AND
   DATE(T1.timestamp) BETWEEN <> AND <>
ORDER BY DATE(T1.timestamp)

On Wed, 13 Jan 2021, 11:49 pm Elaine Bradtke,  wrote:

> Do any of the reports here come close to what you need?
> https://wiki.koha-community.org/wiki/SQL_Reports_Patrons
> Elaine
> VWML <https://vwml.org>
>
>
>
> On Tue, Jan 12, 2021 at 10:28 PM MAMCET Library <
> mamcet.librar...@gmail.com> wrote:
>
>> Dear all good morning
>>  Please send the SQL Patrons Fine payment date wise report coding.
>> Koha version 20.5
>>
>> --
>>  Thanking you..
>>
>> Librarian,
>> MAMCET <http://mamcet.com/>
>> Trichy-Chennai Trunk Road,
>> Siruganur, Tiruchirappalli-621 105.
>> ___
>>
>> 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] Report help needed

[Elaine Bradtke]

Removing the comma fixed it!
It was built off another report with a lot more fields.  I'm a proud
graduate of the cut and paste school of report writing. ;-)
Elaine
VWML <https://vwml.org>



On Tue, Jan 5, 2021 at 11:38 AM Lisette Scheer 
wrote:

> Elaine,
> There is a comma after AS sub3 that is not needed.
> I was able to get the report to run on my system after taking out the ,
> Lisette
> -Original Message-
> From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Elaine
> Bradtke
> Sent: Tuesday, January 5, 2021 11:10 AM
> To: koha 
> Subject: [Koha] Report help needed
>
> I'm trying to find records lacking 300 fields. The following keeps
> failing.  Any help would be appreciated. Thanks!
>
> SELECT CONCAT(' ',biblionumber,'\">',biblionumber,'')
> AS bibnumber
> FROM
> (SELECT biblionumber,
> ExtractValue(metadata,'//datafield[@tag="300"]/subfield[@code>="a"]') AS
> suba,
> ExtractValue(metadata,'//datafield[@tag="300"]/subfield[@code>="b"]') AS
> subb,
> ExtractValue(metadata,'//datafield[@tag="300"]/subfield[@code>="3"]') AS
> sub3, FROM biblio_metadata) AS subfields WHERE suba = ""
> AND subb = ""
> AND sub3 = ""
>
> Elaine Bradtke
> VWML <https://www.vwml.org>
> Our income is severely diminished in these exceptionally uncertain times.
> Please help us to survive beyond this national crisis. Donate now <
> https://www.efdss.org/support-us>.
> English Folk Dance and Song Society <https://www.efdss.org> Cecil Sharp
> House, 2 Regent's Park Road, London NW1 7AY
> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send
> an e-mail first. I work off site)
> --
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
> ___
>
> 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] Report help needed

[Elaine Bradtke]

I'm trying to find records lacking 300 fields. The following keeps
failing.  Any help would be appreciated. Thanks!

SELECT CONCAT('',biblionumber,'')
AS bibnumber
FROM
(SELECT biblionumber,
ExtractValue(metadata,'//datafield[@tag="300"]/subfield[@code>="a"]') AS
suba,
ExtractValue(metadata,'//datafield[@tag="300"]/subfield[@code>="b"]') AS
subb,
ExtractValue(metadata,'//datafield[@tag="300"]/subfield[@code>="3"]') AS
sub3,
FROM biblio_metadata) AS subfields
WHERE suba = ""
AND subb = ""
AND sub3 = ""

Elaine Bradtke
VWML <https://www.vwml.org>
Our income is severely diminished in these exceptionally uncertain times.
Please help us to survive beyond this national crisis. Donate now
<https://www.efdss.org/support-us>.
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

[Koha] Fields in item record entry form are too small in 20.11

[Elaine Bradtke]

I'm just testing  20.11.00.000.  Looking at the item record entry form, I
find some of the fields are too small.  Smaller than 20.05.05. Just to be
sure it wasn't a fluke, I compared them using the same browser (chrome) on
the same screen.  I also compared it to how it looks on Firefox and it's
still  too small, smaller than the older version.
Subfields a and b are so small that VWML only displays as V..
and j shelving control number is only an arrow.
This could be an annoyance in a large branch system.
Should I file a bug?  Or is it only our system that's doing this?
Elaine Bradtke
VWML <https://www.vwml.org>
Our income is severely diminished in these exceptionally uncertain times.
Please help us to survive beyond this national crisis. Donate now
<https://www.efdss.org/support-us>.
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] Batch import of MARC fails

[Elaine Bradtke]

Well that was tedious, but it was a single bad record.
Lacking both 001 and 003
But why did Koha spit out so many error messages?
I also wonder why MarcEdit didn't catch it - or does it only look at syntax
and not whether or not required fields are present?
Elaine
VWML <https://vwml.org>



On Tue, Dec 8, 2020 at 11:17 AM Elaine Bradtke  wrote:

> We're running 20.05.05
> A batch of staged MARC records failed to import, getting stuck at  %90. I
> checked the records and validated the MARC in MarcEdit and tried again.
> They stage and they look fine, but the import still gets stuck at 90%.
>  These are 883 records that were downloaded from our catalogue, edited and
> then staged for import. Just last week an export / import of twice that
> size worked just fine.
> The main difference is these are being imported with a different framework.
>
> From the log:
> Error message (one of many identical)[Mon Dec 07 20:06:48.546903 2020]
> [cgi:error] [pid 8587] [client 97.113.80.105:60555] AH01215: [Mon Dec 7
> 20:06:48 2020] stage-marc-import.pl: Invalid normalization routine
> required (biblionumber) at /usr/share/koha/lib/C4/Matcher.pm line 856.:
> /usr/share/koha/intranet/cgi-bin/tools/stage-marc-import.pl, referer:
> https://catalogue-admin.efdss.org/cgi-bin/koha/tools/stage-marc-import.pl
>
>
> Also, when it eventually times out, in the staff interface I get: 'Can't
> call method "results" on an undefined value at
> /usr/share/koha/intranet/cgi-bin/tools/manage-marc-import.pl line 363.'
>
> I'm going to try splitting the file to see if there's a bad record
> somewhere, but it seems to me with the many many identical error messages,
> that it's not a bad record.
>
> Elaine Bradtke
> VWML <https://www.vwml.org>
> Our income is severely diminished in these exceptionally uncertain times.
> Please help us to survive beyond this national crisis. Donate now
> <https://www.efdss.org/support-us>.
> English Folk Dance and Song Society <https://www.efdss.org>
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send
> an e-mail first. I work off site)
> --
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
>
___

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

[Koha] Batch import of MARC fails

[Elaine Bradtke]

We're running 20.05.05
A batch of staged MARC records failed to import, getting stuck at  %90. I
checked the records and validated the MARC in MarcEdit and tried again.
They stage and they look fine, but the import still gets stuck at 90%.
 These are 883 records that were downloaded from our catalogue, edited and
then staged for import. Just last week an export / import of twice that
size worked just fine.
The main difference is these are being imported with a different framework.

From the log:
Error message (one of many identical)[Mon Dec 07 20:06:48.546903 2020]
[cgi:error] [pid 8587] [client 97.113.80.105:60555] AH01215: [Mon Dec 7
20:06:48 2020] stage-marc-import.pl: Invalid normalization routine required
(biblionumber) at /usr/share/koha/lib/C4/Matcher.pm line 856.:
/usr/share/koha/intranet/cgi-bin/tools/stage-marc-import.pl, referer:
https://catalogue-admin.efdss.org/cgi-bin/koha/tools/stage-marc-import.pl

Also, when it eventually times out, in the staff interface I get: 'Can't
call method "results" on an undefined value at
/usr/share/koha/intranet/cgi-bin/tools/manage-marc-import.pl line 363.'

I'm going to try splitting the file to see if there's a bad record
somewhere, but it seems to me with the many many identical error messages,
that it's not a bad record.

Elaine Bradtke
VWML <https://www.vwml.org>
Our income is severely diminished in these exceptionally uncertain times.
Please help us to survive beyond this national crisis. Donate now
<https://www.efdss.org/support-us>.
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] Items moved to News are not displaying

[Elaine Bradtke]

Well, that's interesting.
I added another test news item, it still didn't display.
I checked the log through the staff interface for the past 24 hours.
The only thing that shows up are a bunch of cron jobs.
I've CC'd our tech expert on this one.

Elaine
VWML <https://vwml.org>



On Mon, Nov 16, 2020 at 7:11 AM Jonathan Druart <
jonathan.dru...@bugs.koha-community.org> wrote:

> Hum, just noticing something however.
> I did specify an expiration date from the UI, but it's not in the DB table.
> The "news" is not updated if I keep the "number" field blank.
> Did you make sure the changes were applied correctly?
>
> Le lun. 16 nov. 2020 à 16:09, Jonathan Druart
>  a écrit :
> >
> > Hi Elaine,
> >
> > Do you see an error in the Koha log files?
> >
> > I've tried with:
> >  idnew: 3
> > branchcode: NULL
> >  title: test
> >content: test
> >   lang: OpacMainUserBlock_en
> >  timestamp: 2020-11-16 00:00:00
> > expirationdate: NULL
> > number: 0
> > borrowernumber: 51
> >
> > And I do see "test" on the OPAC home page. Tested on 20.05.05
> >
> > Cheers,
> > Jonathan
> >
> > Le ven. 13 nov. 2020 à 20:26, Elaine Bradtke  a écrit :
> > >
> > > Things I have tried:
> > > Changing the date to an earlier date
> > > Changing to All libraries
> > > Creating a plain text message
> > > Nothing worked.
> > > Ours is a pretty plain version of Koha, no special JSS, and just a
> colour
> > > stylesheet so it blends in with the rest of the organisation's website.
> > >
> > > Elaine
> > > VWML <https://vwml.org>
> > >
> > >
> > >
> > > On Thu, Nov 12, 2020 at 11:43 PM Katrin Fischer <
> katrin.fischer...@web.de>
> > > wrote:
> > >
> > > > Hi Elaine,
> > > >
> > > > Remove the VWML in the second column by setting the pull down to 'all
> > > > libraries'. If a news item is set to a specific library, even if you
> only
> > > > have one, the news entry will only show if users are logged in.
> > > >
> > > > Also try to set the publication date to an earlier one to see if that
> > > > changes things.
> > > >
> > > > Hope this helps,
> > > >
> > > > Katrin
> > > > On 13.11.20 03:01, Elaine Bradtke wrote:
> > > >
> > > > OPAC (en) VWML 6 12/11/2020 31/12/2020 Closed 2 Dr Elaine Bradtke The
> > > > Vaughan Williams Memorial Library is currently closed to the public.
> Our
> > > > online resources will continue to be available and the Library staff
> will
> > > > attempt to answer correspondence by email. Stay safe and well.
> > > >
> > > > Thinking there might be something wrong in the html in the above,  I
> > > > created a new one called 'test' with plain text.  It didn't work
> either.
> > > > Nothing in News displays.
> > > >
> > > > Elaine
> > > > VWML <https://vwml.org>
> > > >
> > > >
> > > >
> > > > On Thu, Nov 12, 2020 at 12:19 PM Katrin Fischer <
> katrin.fischer...@web.de>
> > > > wrote:
> > > >
> > > >> Hi Elaine,
> > > >>
> > > >> can you share the settings and content of one of the 'moved to news'
> > > >> entries that you think should be displaying?
> > > >>
> > > >> Katrin
> > > >>
> > > >> On 12.11.20 19:48, Elaine Bradtke wrote:
> > > >> > I changed the system preference: OpacNewsLibrarySelect to enable
> the
> > > >> choice
> > > >> > of library news to display.
> > > >> > Now the OPAC displays a message that says: No news to display.  -
> > > >> Despite
> > > >> > there being several things to display.
> > > >> > Elaine
> > > >> > VWML <https://vwml.org>
> > > >> >
> > > >> >
> > > >> >
> > > >> > On Thu, Nov 12, 2020 at 10:40 AM Elaine Bradtke 
> wrote:
> > > >> >
> > > >> >> I just tried that, but it didn't work.
> > > >> >> Elaine
> > > >> >> VWML <https://vwml.org>
> > > >> >>
> > > >> >>
> > > >> >>
> > > >> >>

Re: [Koha] Items moved to News are not displaying

[Elaine Bradtke]

Things I have tried:
Changing the date to an earlier date
Changing to All libraries
Creating a plain text message
Nothing worked.
Ours is a pretty plain version of Koha, no special JSS, and just a colour
stylesheet so it blends in with the rest of the organisation's website.

Elaine
VWML <https://vwml.org>



On Thu, Nov 12, 2020 at 11:43 PM Katrin Fischer 
wrote:

> Hi Elaine,
>
> Remove the VWML in the second column by setting the pull down to 'all
> libraries'. If a news item is set to a specific library, even if you only
> have one, the news entry will only show if users are logged in.
>
> Also try to set the publication date to an earlier one to see if that
> changes things.
>
> Hope this helps,
>
> Katrin
> On 13.11.20 03:01, Elaine Bradtke wrote:
>
> OPAC (en) VWML 6 12/11/2020 31/12/2020 Closed 2 Dr Elaine Bradtke The
> Vaughan Williams Memorial Library is currently closed to the public. Our
> online resources will continue to be available and the Library staff will
> attempt to answer correspondence by email. Stay safe and well.
>
> Thinking there might be something wrong in the html in the above,  I
> created a new one called 'test' with plain text.  It didn't work either.
> Nothing in News displays.
>
> Elaine
> VWML <https://vwml.org>
>
>
>
> On Thu, Nov 12, 2020 at 12:19 PM Katrin Fischer 
> wrote:
>
>> Hi Elaine,
>>
>> can you share the settings and content of one of the 'moved to news'
>> entries that you think should be displaying?
>>
>> Katrin
>>
>> On 12.11.20 19:48, Elaine Bradtke wrote:
>> > I changed the system preference: OpacNewsLibrarySelect to enable the
>> choice
>> > of library news to display.
>> > Now the OPAC displays a message that says: No news to display.  -
>> Despite
>> > there being several things to display.
>> > Elaine
>> > VWML <https://vwml.org>
>> >
>> >
>> >
>> > On Thu, Nov 12, 2020 at 10:40 AM Elaine Bradtke  wrote:
>> >
>> >> I just tried that, but it didn't work.
>> >> Elaine
>> >> VWML <https://vwml.org>
>> >>
>> >>
>> >>
>> >> On Thu, Nov 12, 2020 at 10:33 AM Michael Kuhn 
>> wrote:
>> >>
>> >>> Hi Elaine
>> >>>
>> >>>   > We recently updated our system to 20.05.05.
>> >>>   > I understand some OPAC system preferences regarding the display
>> have
>> >>>   > moved to the News tool.  But the following aren't displaying:
>> >>>   > OPAC (opacheader_en), OPAC (OpacMainUserBlock_en), OPAC
>> >>>   > (OpacNavRight_en), OPAC (en)
>> >>>   > Our OPAC front page is quite bare, and I'd really like to have the
>> >>>   > "Library is Closed to the Public, etc." message displaying.
>> >>>   > I've tried  editing them - adding a title when needed and saving,
>> but
>> >>>   > it didn't make a difference. Any thoughts on what to do?
>> >>>
>> >>> Check in Koha menu "Tools > News" for the said parameters what is
>> >>> standing in column "Library". Try to change it if there is a specific
>> >>> library name resp. "All libraries". At least this helped when we
>> >>> encountered such a problem some weeks ago.
>> >>>
>> >>> Hope this helps.
>> >>>
>> >>> Best wishes: MIchael
>> >>> --
>> >>> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg.
>> Fachausweis
>> >>> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
>> >>> T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
>> >>> ___
>> >>>
>> >>> Koha mailing list  http://koha-community.org
>> >>> Koha@lists.katipo.co.nz
>> >>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>> >>>
>> > ___
>> >
>> > Koha mailing list  http://koha-community.org
>> > Koha@lists.katipo.co.nz
>> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>> ___
>>
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
___

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

Re: [Koha] Items moved to News are not displaying

[Elaine Bradtke]

OPAC (en) VWML 6 12/11/2020 31/12/2020 Closed 2 Dr Elaine Bradtke The
Vaughan Williams Memorial Library is currently closed to the public. Our
online resources will continue to be available and the Library staff will
attempt to answer correspondence by email. Stay safe and well.

Thinking there might be something wrong in the html in the above,  I
created a new one called 'test' with plain text.  It didn't work either.
Nothing in News displays.

Elaine
VWML <https://vwml.org>



On Thu, Nov 12, 2020 at 12:19 PM Katrin Fischer 
wrote:

> Hi Elaine,
>
> can you share the settings and content of one of the 'moved to news'
> entries that you think should be displaying?
>
> Katrin
>
> On 12.11.20 19:48, Elaine Bradtke wrote:
> > I changed the system preference: OpacNewsLibrarySelect to enable the
> choice
> > of library news to display.
> > Now the OPAC displays a message that says: No news to display.  - Despite
> > there being several things to display.
> > Elaine
> > VWML <https://vwml.org>
> >
> >
> >
> > On Thu, Nov 12, 2020 at 10:40 AM Elaine Bradtke  wrote:
> >
> >> I just tried that, but it didn't work.
> >> Elaine
> >> VWML <https://vwml.org>
> >>
> >>
> >>
> >> On Thu, Nov 12, 2020 at 10:33 AM Michael Kuhn  wrote:
> >>
> >>> Hi Elaine
> >>>
> >>>   > We recently updated our system to 20.05.05.
> >>>   > I understand some OPAC system preferences regarding the display
> have
> >>>   > moved to the News tool.  But the following aren't displaying:
> >>>   > OPAC (opacheader_en), OPAC (OpacMainUserBlock_en), OPAC
> >>>   > (OpacNavRight_en), OPAC (en)
> >>>   > Our OPAC front page is quite bare, and I'd really like to have the
> >>>   > "Library is Closed to the Public, etc." message displaying.
> >>>   > I've tried  editing them - adding a title when needed and saving,
> but
> >>>   > it didn't make a difference. Any thoughts on what to do?
> >>>
> >>> Check in Koha menu "Tools > News" for the said parameters what is
> >>> standing in column "Library". Try to change it if there is a specific
> >>> library name resp. "All libraries". At least this helped when we
> >>> encountered such a problem some weeks ago.
> >>>
> >>> Hope this helps.
> >>>
> >>> Best wishes: MIchael
> >>> --
> >>> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg.
> Fachausweis
> >>> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> >>> T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
> >>> ___
> >>>
> >>> Koha mailing list  http://koha-community.org
> >>> Koha@lists.katipo.co.nz
> >>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >>>
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Items moved to News are not displaying

[Elaine Bradtke]

I changed the system preference: OpacNewsLibrarySelect to enable the choice
of library news to display.
Now the OPAC displays a message that says: No news to display.  - Despite
there being several things to display.
Elaine
VWML <https://vwml.org>



On Thu, Nov 12, 2020 at 10:40 AM Elaine Bradtke  wrote:

> I just tried that, but it didn't work.
> Elaine
> VWML <https://vwml.org>
>
>
>
> On Thu, Nov 12, 2020 at 10:33 AM Michael Kuhn  wrote:
>
>> Hi Elaine
>>
>>  > We recently updated our system to 20.05.05.
>>  > I understand some OPAC system preferences regarding the display have
>>  > moved to the News tool.  But the following aren't displaying:
>>  > OPAC (opacheader_en), OPAC (OpacMainUserBlock_en), OPAC
>>  > (OpacNavRight_en), OPAC (en)
>>  > Our OPAC front page is quite bare, and I'd really like to have the
>>  > "Library is Closed to the Public, etc." message displaying.
>>  > I've tried  editing them - adding a title when needed and saving, but
>>  > it didn't make a difference. Any thoughts on what to do?
>>
>> Check in Koha menu "Tools > News" for the said parameters what is
>> standing in column "Library". Try to change it if there is a specific
>> library name resp. "All libraries". At least this helped when we
>> encountered such a problem some weeks ago.
>>
>> Hope this helps.
>>
>> Best wishes: MIchael
>> --
>> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
>> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
>> T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
>> ___
>>
>> 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] Items moved to News are not displaying

[Elaine Bradtke]

I just tried that, but it didn't work.
Elaine
VWML 



On Thu, Nov 12, 2020 at 10:33 AM Michael Kuhn  wrote:

> Hi Elaine
>
>  > We recently updated our system to 20.05.05.
>  > I understand some OPAC system preferences regarding the display have
>  > moved to the News tool.  But the following aren't displaying:
>  > OPAC (opacheader_en), OPAC (OpacMainUserBlock_en), OPAC
>  > (OpacNavRight_en), OPAC (en)
>  > Our OPAC front page is quite bare, and I'd really like to have the
>  > "Library is Closed to the Public, etc." message displaying.
>  > I've tried  editing them - adding a title when needed and saving, but
>  > it didn't make a difference. Any thoughts on what to do?
>
> Check in Koha menu "Tools > News" for the said parameters what is
> standing in column "Library". Try to change it if there is a specific
> library name resp. "All libraries". At least this helped when we
> encountered such a problem some weeks ago.
>
> Hope this helps.
>
> Best wishes: MIchael
> --
> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
> ___
>
> 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] Items moved to News are not displaying

[Elaine Bradtke]

I've also tried adding news items and they don't display either.
Elaine
VWML <https://vwml.org>



On Thu, Nov 12, 2020 at 10:14 AM Elaine Bradtke  wrote:

> We recently updated our system to 20.05.05.
> I understand some OPAC system preferences regarding the display have moved
> to the News tool.  But the following aren't displaying:
> OPAC (opacheader_en), OPAC (OpacMainUserBlock_en), OPAC (OpacNavRight_en),
> OPAC (en)
> Our OPAC front page is quite bare, and I'd really like to have the
> "Library is Closed to the Public, etc." message displaying.
> I've tried  editing them - adding a title when needed and saving, but it
> didn't make a difference. Any thoughts on what to do?
> Elaine Bradtke
> VWML <https://www.vwml.org>
> Our income is severely diminished in these exceptionally uncertain times.
> Please help us to survive beyond this national crisis. Donate now
> <https://www.efdss.org/support-us>.
> English Folk Dance and Song Society <https://www.efdss.org>
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send
> an e-mail first. I work off site)
> --
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
>
___

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

[Koha] Items moved to News are not displaying

[Elaine Bradtke]

We recently updated our system to 20.05.05.
I understand some OPAC system preferences regarding the display have moved
to the News tool.  But the following aren't displaying:
OPAC (opacheader_en), OPAC (OpacMainUserBlock_en), OPAC (OpacNavRight_en),
OPAC (en)
Our OPAC front page is quite bare, and I'd really like to have the "Library
is Closed to the Public, etc." message displaying.
I've tried  editing them - adding a title when needed and saving, but it
didn't make a difference. Any thoughts on what to do?
Elaine Bradtke
VWML <https://www.vwml.org>
Our income is severely diminished in these exceptionally uncertain times.
Please help us to survive beyond this national crisis. Donate now
<https://www.efdss.org/support-us>.
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] OPAC 404 errors after upgrading to 20.05

[Elaine Bradtke]

This seems to be a really common problem. We've experienced it ourselves.
Perhaps we need a statement in the manual? Or a better error message?
Otherwise Katrin has to keep repeating the same message. . .
Thank you Katrin!
Elaine
VWML 



On Fri, Nov 6, 2020 at 12:47 AM Father Vlasie  wrote:

> Thank you Katrin!
>
> Yes, you are right, other frameworks did not have the visibility set and
> changing it solved the problem.
>
> What a relief! :)
>
> FV
>
> > On 6 Nov 2020, at 12:38 am, Katrin Fischer 
> wrote:
> >
> > Hi,
> >
> > Jonathan's link only points to the default framework, if you are using
> multiple frameworks please check all of them and make sure it is the field
> linked to biblio.biblionumber. We are positive that this should fix it, as
> the problem has appeared a few times already.
> >
> > Hope this helps,
> >
> > Katrin
> >
> >> Gesendet: Freitag, 06. November 2020 um 09:26 Uhr
> >> Von: "Father Vlasie" 
> >> An: "Jonathan Druart" 
> >> Cc: "koha" 
> >> Betreff: Re: [Koha] OPAC 404 errors after upgrading to 20.05
> >>
> >> Thank you Jonathan!
> >>
> >> The subfield in question is already marked as visible in the OPAC.
> >>
> >> The problem only seems to occur with catalog search results (in both
> OPAC and intranet as it turns out), all other links work as far as I can
> tell.
> >>
> >> It is very strange...
> >>
> >> FV
> >>
> >>
> >>> On 6 Nov 2020, at 12:18 am, Jonathan Druart <
> jonathan.dru...@bugs.koha-community.org> wrote:
> >>>
> >>> Hello Father,
> >>>
> >>> Make sure the MARC subfield linked with the biblionumber DB field is
> >>> visible at the OPAC.
> >>>
> >>> Should be at $INTRANET_URL/cgi-bin/koha/admin/
> marc_subfields_structure.pl?op=add_form=999=#subcfield
> >>>
> >>> Regards,
> >>> Jonathan
> >>>
> >>> Le ven. 6 nov. 2020 à 05:09, Father Vlasie  a écrit :
> 
>  Hello again!
> 
>  It seems the problem is with the URL generated by the search results:
> 
>  /cgi-bin/koha/
> opac-detail.pl?biblionumber=_desc=kw%2Cwrdl%3A%20Kang
> 
>  You can see there is no biblionumber specified!
> 
>  I am not sure how to troubleshoot this...
> 
>  FV
> 
> > On 4 Nov 2020, at 9:09 am, Father Vlasie  wrote:
> >
> > Hello Alvaro,
> >
> > Thank you very much for your reply.
> >
> > This 404 page I am seeing is coming from Koha:
> https://library.spots.school/cgi-bin/koha/errors/404.pl
> >
> > Nothing is showing in the Apache logs. ( I have checked both access
> and error logs. )
> >
> > Any other ideas?
> >
> > Thank you,
> >
> > FV
> >
> >> On 3 Nov 2020, at 9:10 pm, Alvaro Cornejo 
> wrote:
> >>
> >> Hi
> >>
> >> 404 means the requested page is not available or can not be found.
> Either because the page does not exist or the user running apache does not
> have the right permissions.
> >>
> >> Can you check apache access log? there shall be the exact url you
> are trying to hit and gives you a more detailed idea of where the issue is.
> >>
> >> you can run the following comand to find the related lines:
> >>
> >> # sudo more /var/log/apache2/access.log |grep 404
> >>
> >> Hope this helps.
> >>
> >> Regards,
> >>
> >> Alvaro
> >>
> ||
> >> 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 mar. 3 nov. 2020 à 22:24, Father Vlasie  a
> écrit :
> >> Hello everyone,
> >>
> >> After upgrading to version 20.05.05 from 19 I am getting 404 errors
> ("Sorry, the requested page is not available Error 404 This message can
> have the following reason(s):...") when clicking on titles in search
> results in the OPAC. The OPAC error log is showing a lot of uninitialised
> values:
> >>
> >> [Tue Nov 03 17:21:14.194405 2020] [cgi:error] [pid 5557] [client
> 192.168.2.30:54618] AH01215: [Tue Nov  3 17:21:14 2020] opac-search.pl:
> Use of uninitialized value $query in pattern match (m//) at
> /usr/share/koha/lib/C4/Search.pm line 1330.:
> /usr/share/koha/opac/cgi-bin/opac/opac-search.pl
> >> [Tue Nov 03 17:21:14.194635 2020] [cgi:error] [pid 5557] [client
> 192.168.2.30:54618] AH01215: [Tue Nov  3 17:21:14 2020] opac-search.pl:
> Use of uninitialized value $_ in substitution (s///) at
> /usr/share/koha/lib/C4/Search.pm line 1603.:
> /usr/share/koha/opac/cgi-bin/opac/opac-search.pl
> >> [Tue Nov 03 17:21:14.194821 2020] [cgi:error] [pid 5557] [client
> 192.168.2.30:54618] AH01215: [Tue Nov  3 17:21:14 2020] opac-search.pl:
> Use of uninitialized value in subroutine entry at
> /usr/share/perl5/URI/Escape.pm line 

Re: [Koha] [koha-US Mailing List] CHAT: A gift to the world from Tom Lehrer

[Elaine Bradtke]

That's wonderful news.  For some reason my parents were oblivious to Tom
Lehrer, but my father-in-law and husband are both tremendous fans. I do
love the 'Irish Ballad', because as a specialist in English folk music,
I've often jokingly referred to the ballad genre as death and dismemberment
songs. . . ;-)
I also take gruesome delight in 'Poisoning Pigeons in the Park'
be well,
*Elaine*


On Fri, Oct 23, 2020 at 8:47 AM King, Fred  wrote:

> (I posted this to MEDLIB-L, so apologies to the Koha medical librarians
> and others who receive duplicate e-mails.)
>
>
>
> Esteemed Colleagues,
>
>
>
> Chances are that if you are of A Certain Age or a computer geek (I'm both,
> so don't take umbrage), you grew up listening and quite often memorizing
> the songs of Tom Lehrer. I am delighted to say that not only is he still
> alive at the age of 92, he has also posted the following on his web site,
> https://tomlehrersongs.com/:
>
>
>
>I, Tom Lehrer, and the Tom Lehrer Trust 2000, hereby grant the
> following permission:
>
>All the lyrics on this website, whether published or unpublished,
> copyrighted or uncopyrighted, may be downloaded and used in any manner
> whatsoever, without requiring any further permission from me or any payment
> to me or to anyone else.
>
>Some lyrics written by Tom Lehrer to copyrighted music by others are
> included herein, but of course such music may not be used without
> permission of the copyright owners. (The translated songs may be found in
> their original languages on YouTube.)
>
>In other words, all the lyrics herein should be treated as though they
> were in the public domain.
>
>
>
> It continues, but that's the gist of it. I knew all of the songs that
> appeared on his albums, plus a few extras like the Subway Song, but a lot
> of them were new to me. The site shuts down at the end of 2024, so download
> them while you can!
>
>
>
> And if you're unfamiliar with Tom Lehrer, see
> https://www.youtube.com/user/6funswede. NOW!
>
>
>
> (My favorite, I think, is the Irish Ballad, which I learned when I was
> maybe nine years old—My parents had his original record. How about you?)
>
>
>
> Fred King, MSLS, AHIP
>
> Medical Librarian, MedStar Washington Hospital Center
>
> fred.k...@medstar.net
>
> 202-877-6670
>
> ORCID -0001-5266-0279
>
> MedStar Authors Catalog: http://medstarauthors.org
>
>
>
> Suddenly virologists are cool. This is a bad sign.
>
> --Paul Offit
> --
> MedStar Health is a not-for-profit, integrated healthcare delivery system,
> the largest in Maryland and the Washington, D.C., region. Nationally
> recognized for clinical quality in heart, orthopedics, cancer and GI.
>
>
> IMPORTANT: This e-mail (including any attachments) may contain information
> that is private, confidential, or protected by attorney-client or other
> privilege. If you received this e-mail in error, please delete it from your
> system without copying it and notify sender by reply e-mail, so that our
> records can be corrected... Thank you.
>
>
> Help conserve valuable resources - only print this email if necessary.
>
> --
> You received this message because you are subscribed to the Google Groups
> "koha-US Mailing List" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to koha-us+unsubscr...@koha-us.org.
> To view this discussion on the web visit
> https://groups.google.com/a/koha-us.org/d/msgid/koha-us/MN2PR13MB29582D18127D9B837E0A96F4E31A0%40MN2PR13MB2958.namprd13.prod.outlook.com
> 
> .
>
___

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

Re: [Koha] Holds and quarantine

[Elaine Bradtke]

Take this with a grain of salt, as we rarely circulate material. . .
You could create an account called quarantine - ignore the holds for the
first checkin, and check it out to quarantine, and then when it's ready to
go back into circulation check it in and 'confirm'.
I know, extra steps.
Elaine
VWML 



On Tue, Sep 15, 2020 at 1:16 PM Mark Alexander  wrote:

>
> I've tried to search my Koha mailing list archives, and studied the
> 19.05 manual for a solution to the following problem, but I'm either
> overlooking something or the problem hasn't been discussed.
>
> Our little library has a pandemic protocol where books that are returned
> (in
> a drop box) are checked in twice a week, then put on a special quarantine
> table.
> On Sunday a volunteer comes in and sanitizes the books.  Then they can be
> checked out again.
>
> The problem has to do with holds.  When a book with a hold is checked in,
> the librarian has to respond to Koha's popup in one of two ways: press
> "Confirm",
> or press "Ignore":
>
> 1. If the librarian presses "Confirm", then the patron will eventually
> notice when they log into to their account that the book is ready
> for pickup, when in fact it is on the quarantine table and is NOT
> ready.
>
> 2. If the librian presses "Ignore", then the patron won't get notified
> that their book is ready for pickup.  Instead, their hold is
> still pending and the book is seen as available in the catalog.
>
> Either choice isn't quite right.  What we'd like to have happen is for
> the patron somehow to be informed that their book is ready for pickup
> not when it's checked in, but AFTER it's gone through the quarantine
> process, which takes an unpredictable amount of time.
>
> I don't see how the CART shelving location functionality and cron job
> can deal with both holds and unpredictable quarantine times.
>
> Thanks in advance for any ideas!
> ___
>
> 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] Going back to Results from a record doesn't always work

[Elaine Bradtke]

Yes Katrin
 offset=... param at the end that has a higher value than the
total of results to the search

I'm glad someone else is seeing this - makes me feel a bit less like we're
doing it all wrong.

Elaine
VWML <https://vwml.org>



On Mon, Sep 14, 2020 at 12:54 PM Katrin Fischer 
wrote:

> Hi Elaine,
>
> I think you could have run into something I just reported the other day
> - I can reproduce it with the sample data in the kohadevbox, so hope
> others will be able to:
>
> *Bug 26445*
> <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26445> -
> Search results browser in staff has broken link back to results
>
> When you check the link that leads to the blank result list - does it
> have an offset=... param at the end that has a higher value than the
> total of results to your search?
>
> Hope this helps,
>
> Katrin
>
>
> On 14.09.20 21:21, Elaine Bradtke wrote:
> > I'm hoping  someone else has seen this, or even better, knows how to fix
> it.
> > I think it happened somewhere in the upgrade to 20 (we're on 20.05 but
> I'm
> > not sure if was going on during the earlier version of 20, as our small
> > staff has been cycling on and off furlough and I've only recently gotten
> a
> > detailed enough description of the problem to reproduce it).
> > The problem *only* happens in the staff interface, and *only for certain
> > records. * I haven't spotted the pattern yet.
> >
> > With a list of search results, clicking on a title takes us to the bib
> > record as expected, but when we click results to go back to the list, we
> > get a blank results page. No error message, just no titles listed.
> > If we sort the results list, the titles appear.
> > As I said above, it only happens to certain records, which leads me to
> > suspect there's a problem in the MARC somewhere.  Experimenting with one
> of
> > them, I've tried the following:
> > 1) Checked the record in MarcEdit - it didn't flag up any problems.
> > 2) Replaced the offending record with a Z39.50 download from LC
> > 3) Deleted the record and re-catalogued it using a template that we have.
> > 4) Catalogued it completely from scratch - without a template  (the
> > template has the same problem!).
> >
> > No change.  We still get the blank results page.
> >
> > Here are two records, volume 1 and volume 2 of a pair published and
> > catalogued in different years. The first was produced as part of a data
> > conversion project, the second one was catalogued in Koha.  Though that
> > *doesn't* seem to be the defining difference.
> > In the first record, the link back to the results list doesn't work.  In
> > the second one it does.
> > =LDR  01007nam a22002651a 4500
> > =001  04068
> > =003  UkLoVW
> > =005  20200914194455.0
> > =008  121030s1996stkgr\001\0\eng\d
> > =020  \\$a1897976119
> > =040  \\$aUkLoVW$beng$cUkLoVW
> > =099  \\$aMPS 60 (22)
> > =245  10$aAndrew Crawfurd's collection of ballads and songs /$cedited by
> E.
> > B. Lyle.$bVolume 2
> > =260  \\$aEdinburgh :$bThe Scottish Text Society,$c1996.
> > =300  \\$aix, 265 p. ;$c23 cm.
> > =490  \\$aScottish Text Society. ; Fourth series ; $v24
> > =500  \\$aNo music but there are references to relevant tunes, from
> Bronson
> > and other sources.
> > =650  \7$2UkLoVW$aFolk songs$9202
> > =650  \7$2UkLoVW$aScotland$9461
> > =700  \\$919389$aCrawfurd, Andrew$d1786-1854
> > =700  1\$91452$aLyle, Emily B.
> > =850  \\$aUkLoVW
> > =942  \\$2VWML$cBK$hMPS 60 (22)$n0$6MPS0060  (00022)
> > =999  \\$c16320$d16320
> > =952
> >
>  \\$00$10$2VWML$40$6MPS_00060_22$71$916978$aVWML$bVWML$d1998-01-01$l0$oMPS
> > 60 (22)$p13972$r2012-10-31$w2012-10-31$yBK
> >
> > =LDR  00966nam a22002651a 4500
> > =001  201508181250.nw
> > =003  UkLoVW
> > =005  20200809133340.0
> > =008  121030s1975stkag\\gr\000\0\eng\d
> > =020  \\$a1897976119
> > =040  \\$aUkLoVW$beng$cUkLoVW
> > =099  \\$aMPS 60 (22)
> > =245  10$aAndrew Crawfurd's collection of ballads and songs /$cedited by
> E.
> > B. Lyle.$bVolume 1
> > =260  \\$aEdinburgh :$bThe Scottish Text Society,$c1975.
> > =300  \\$alvii, 244 p. :$bill., music ;$c22 cm.
> > =490  \\$aScottish Text Society. ; Fourth series ; $v9
> > =588  \\$aCardbox (1998)
> > =650  \7$2UkLoVW$aFolk songs$9202
> > =650  \7$2UkLoVW$aScotland$9461
> > =700  \\$919389$aCrawfurd, Andrew$d1786-1854
> > =700  1\$91452$aLyle, Emily B.
> > =850  \\$aUkLoVW
> > =942  \\$2VWML$cBK$hMPS 60 (22)$n0$6MPS0060  (00022)
> > =999  \\$c66698

[Koha] Going back to Results from a record doesn't always work

[Elaine Bradtke]

I'm hoping  someone else has seen this, or even better, knows how to fix it.
I think it happened somewhere in the upgrade to 20 (we're on 20.05 but I'm
not sure if was going on during the earlier version of 20, as our small
staff has been cycling on and off furlough and I've only recently gotten a
detailed enough description of the problem to reproduce it).
The problem *only* happens in the staff interface, and *only for certain
records. * I haven't spotted the pattern yet.

With a list of search results, clicking on a title takes us to the bib
record as expected, but when we click results to go back to the list, we
get a blank results page. No error message, just no titles listed.
If we sort the results list, the titles appear.
As I said above, it only happens to certain records, which leads me to
suspect there's a problem in the MARC somewhere.  Experimenting with one of
them, I've tried the following:
1) Checked the record in MarcEdit - it didn't flag up any problems.
2) Replaced the offending record with a Z39.50 download from LC
3) Deleted the record and re-catalogued it using a template that we have.
4) Catalogued it completely from scratch - without a template  (the
template has the same problem!).

No change.  We still get the blank results page.

Here are two records, volume 1 and volume 2 of a pair published and
catalogued in different years. The first was produced as part of a data
conversion project, the second one was catalogued in Koha.  Though that
*doesn't* seem to be the defining difference.
In the first record, the link back to the results list doesn't work.  In
the second one it does.
=LDR  01007nam a22002651a 4500
=001  04068
=003  UkLoVW
=005  20200914194455.0
=008  121030s1996stkgr\001\0\eng\d
=020  \\$a1897976119
=040  \\$aUkLoVW$beng$cUkLoVW
=099  \\$aMPS 60 (22)
=245  10$aAndrew Crawfurd's collection of ballads and songs /$cedited by E.
B. Lyle.$bVolume 2
=260  \\$aEdinburgh :$bThe Scottish Text Society,$c1996.
=300  \\$aix, 265 p. ;$c23 cm.
=490  \\$aScottish Text Society. ; Fourth series ; $v24
=500  \\$aNo music but there are references to relevant tunes, from Bronson
and other sources.
=650  \7$2UkLoVW$aFolk songs$9202
=650  \7$2UkLoVW$aScotland$9461
=700  \\$919389$aCrawfurd, Andrew$d1786-1854
=700  1\$91452$aLyle, Emily B.
=850  \\$aUkLoVW
=942  \\$2VWML$cBK$hMPS 60 (22)$n0$6MPS0060  (00022)
=999  \\$c16320$d16320
=952
 \\$00$10$2VWML$40$6MPS_00060_22$71$916978$aVWML$bVWML$d1998-01-01$l0$oMPS
60 (22)$p13972$r2012-10-31$w2012-10-31$yBK

=LDR  00966nam a22002651a 4500
=001  201508181250.nw
=003  UkLoVW
=005  20200809133340.0
=008  121030s1975stkag\\gr\000\0\eng\d
=020  \\$a1897976119
=040  \\$aUkLoVW$beng$cUkLoVW
=099  \\$aMPS 60 (22)
=245  10$aAndrew Crawfurd's collection of ballads and songs /$cedited by E.
B. Lyle.$bVolume 1
=260  \\$aEdinburgh :$bThe Scottish Text Society,$c1975.
=300  \\$alvii, 244 p. :$bill., music ;$c22 cm.
=490  \\$aScottish Text Society. ; Fourth series ; $v9
=588  \\$aCardbox (1998)
=650  \7$2UkLoVW$aFolk songs$9202
=650  \7$2UkLoVW$aScotland$9461
=700  \\$919389$aCrawfurd, Andrew$d1786-1854
=700  1\$91452$aLyle, Emily B.
=850  \\$aUkLoVW
=942  \\$2VWML$cBK$hMPS 60 (22)$n0$6MPS0060  (00022)
=999  \\$c66698$d66698
=952  \\$00$10$2VWML$40$6MPS0060
 (00022)$71$926287$aVWML$bVWML$d2015-08-18$l0$oMPS 60
(22)$p8052$r2015-08-18$w2015-08-18$yBK

Any help would be appreciated.
Thanks!
Elaine Bradtke
VWML <https://www.vwml.org>
Our income is severely diminished in these exceptionally uncertain times.
Please help us to survive beyond this national crisis. Donate now
<https://www.efdss.org/support-us>.
English Folk Dance and Song Society <https://www.efdss.org>
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] [EXTERNAL] Remove Not For Loan / Available distinctions

[Elaine Bradtke]

We have a new Library Director, and the question has come up again.
But now, I can't find
"Home > Administration > Columns settings
OPAC
OPAC table, biblio detail
 item_status (check in the box to make it hidden by default) "

I also looked under OPAC and couldn't find anything to change the columns.
Where has it moved to?
Elaine Bradtke
VWML
Our income is severely diminished in these exceptionally uncertain times.
Please help us to survive beyond this national crisis. Donate now
<https://www.efdss.org/support-us>.
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Tue, Oct 15, 2019 at 12:48 PM Hernandez, Heather <
heather_hernan...@nps.gov> wrote:

> Hi, Elaine--
>
> We're in a similar situation--all our items are available for use in our
> Reading Room, and a select few are eligible for interlibrary loan or our
> staff might check them out.  So I recently suppressed that "status" from
> displaying in the OPAC via:
>
> Home > Administration > Columns settings
> OPAC
> OPAC table, biblio detail
>  item_status (check in the box to make it hidden by default)
>
> If something's checked out, a due date still displays, e.g.:
>
> https://keys.bywatersolutions.com/cgi-bin/koha/opac-detail.pl?biblionumber=13857
> <https://keys.bywatersolutions.com/cgi-bin/koha/opac-detail.pl?biblionumber=13857>
>
>
> Maybe worth trying?  Or maybe you've already tried this?
>
> Hope this is helpful!
> --h2
> ~~
> 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
> 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] Windows 10 causing trouble with upgrade to 20.05

[Elaine Bradtke]

I noticed this problem when we were testing the upgrade before installing
it in the production site.  I thought it was a fluke with the PC I tested
it on, but now a colleague is reporting the same problem - with a
windows 10 OS.
Searches seem to proceed normally, until you click through to the biblio
record and then it says 'not found'. This problem could not be replicated
on a mac.

Things we tried that did not make a difference. In Chrome: Clearing browser
history / cache, browsing anonymously, and a completely new installation of
Firefox (had never been installed on this computer).

What appears to have fixed it:  Windows update.
Our working theory is that the update cleared some cache somewhere on the
PC.

Has anyone else seen this?  And if so, is there a better way to fix it
instead of waiting for an update?

Elaine Bradtke
VWML
Our income is severely diminished in these exceptionally uncertain times.
Please help us to survive beyond this national crisis. Donate now
<https://www.efdss.org/support-us>.
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] Linking fields 770 and 772

[Elaine Bradtke]

Check your framework to make sure it is set to display in OPAC and Staff
interface?
Though maybe Katrin has more insight - as there is a bug for the 770 field
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20200

Elaine Bradtke
VWML
Our income is severely diminished in these exceptionally uncertain times.
Please help us to survive beyond this national crisis. Donate now
<https://www.efdss.org/support-us>.
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Wed, Jul 29, 2020 at 6:16 AM  wrote:

>
> Hi. I am working with serials, trying to link a parent record to a
> supplement record using 770 and 772 fields and it seems not to be
> working. In spite of using 772 0# in the supplement record and 770 0#
> in the parent one (using $w for linking records) no linking note
> appears to be displaying and no relation seems to be establishing. I´m
> using Koha version 19.11.
> I ´d greatly appreciate your feedback on this.
>
> Regards,
> Paola V. Cruciani
>
>
> ___
>
> 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] Problems with sound recording records not displaying

[Elaine Bradtke]

Thanks Katrin, I think that fixed the problem!  Phew.
Elaine Bradtke
VWML
Our income is severely diminished in these exceptionally uncertain times.
Please help us to survive beyond this national crisis. Donate now
<https://www.efdss.org/support-us>.
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Mon, Jul 13, 2020 at 11:52 AM Katrin Fischer 
wrote:

> Hi Elaine,
>
> check your framework for sounds recordings and make sure that the
> biblionumber in 999 is not set to be hidden in the OPAC.
>
> Hope this helps,
>
> Katrin
>
> On 13.07.20 20:48, Elaine Bradtke wrote:
> > We've just installed Koha 20.05.01 in our test system and have a problem
> > with our sound recordings records.  They show up fine in the hit list,
> but
> > when the link is clicked to display the bib record, it fails with a 404
> > error message.  If I hover the mouse over the link, the bar on the bottom
> > of the page that shows the URL gives a blank where the biblionumber
> should
> > be.  If searched by biblionumber, they come up, and the record displays
> > normally.
> >
> > We have a lot of non-book material in our collection, but the problem is
> > only with the sound recordings.  It appears to be an HTML /CSS problem?
> > We're using Koha straight out of the box, no special CSS.
> >
> > As we have thousands of sound recordings in the collection, this is a
> > serious issue, any help would be appreciated!
> >
> >
> > Here's an example of one of the records
> >
> >
> >
> >   000 - LEADER
> >
> > @ 01642njm a2200253 a 4500
> >
> > 001 - CONTROL NUMBER
> >
> > @ SR06655
> >
> > 003 - CONTROL NUMBER IDENTIFIER
> >
> > @ UkLoVW
> >
> > 005 - DATE AND TIME OF LATEST TRANSACTION
> >
> > @ 20200713112316.0
> >
> > 006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL
> > CHARACTERISTICS--GENERAL INFORMATION
> >
> > @ j| | || 0
> >
> > 007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION
> >
> > @ sd bmmennm||nu
> >
> > 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
> >
> > @ 160809s1965 enkfmz eng d
> >
> > 028 ## - PUBLISHER NUMBER
> >
> > a Publisher number CLP 1910
> >
> > b Source His Master's Voice
> >
> > 040 ## - CATALOGING SOURCE
> >
> > a Original cataloging agency UkLoVW
> >
> > b Language of cataloging eng
> >
> > c Transcribing agency UkLoVW
> >
> > d Modifying agency UkLoVW
> >
> > 099 ## - LOCAL CALL NUMBER
> >
> > a Classification number SAD 1345
> >
> > 245 00 - TITLE STATEMENT
> >
> > a Title Folksound of Britain :
> >
> > b Remainder of title recorded live during the concert presented by the
> > English Folk Dance & Song Society at the Royal Festival Hall on 4th June
> > 1965. Dominic Behan introduces: /
> >
> > 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)
> >
> > b Name of publisher, distributor, etc His Master's Voice,
> >
> > c Date of publication, distribution, etc 1965.
> >
> > 300 ## - PHYSICAL DESCRIPTION
> >
> > a Extent 1 sound disc :
> >
> > b Other physical details analog, 33 1/3 rpm
> >
> > c Dimensions 12 in.
> >
> > 500 ## - GENERAL NOTE
> >
> > a General note Sound disc, analog.
> >
> > a General note Recorded under the auspices of EFDSS.
> >
> > 505 0# - FORMATTED CONTENTS NOTE
> >
> > a Formatted contents note Side 1: 1. Three Irish polkas / Rakes -- 2. The
> > Verdant braes of Screne / The McPeakes -- 3. Chevy Chase; The waters of
> > Tyne / Jack Armstrong and Patricia Jennings -- 4. Derwentwater's
> farewell /
> > Louis Killen -- 5. The College Valley Hunt / Louis Killen -- 6. The white
> > cockade / Bob Davenport with the Rakes -- 7. The banks of the Dee/ Jack
> > Elliott -- 8. Jowl and listen lad/ Jack Elliott -- Side 2: 1. Three
> > whiskies / The Countryside Players -- 2. Kissin' in the dark / Dave
> > Campbell -- 3. The broken token / Winnie Campbell -- 4. The ploughboy /
> The
> > Watersons -- 5. The wedding song/ Bob and John Copper -- 6. The three
> > huntsmen / Cyril Ta

Re: [Koha] OPACReportProblem Koha 20.05

[Elaine Bradtke]

Thanks, we'll check on that.  Meanwhile, a notice did show up on the
homepage of the staff interface.  So the message did go through that way.
But the email seems to have gone into a black hole.
Elaine Bradtke
VWML
Our income is severely diminished in these exceptionally uncertain times.
Please help us to survive beyond this national crisis. Donate now
<https://www.efdss.org/support-us>.
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Mon, Jul 13, 2020 at 10:10 AM Alvaro Cornejo 
wrote:

> Hi Elaine,
>
> Emails are handled by a cron. I guess the ones you mention also.
>
> Have you checked the mail log (/var/log/mail.log)  to see if your messages
> are being processed by your smtp server? are other mails are being sent?
>
> Regards,
>
> Alvaro
>
> ||
>  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 lun. 13 juil. 2020 à 11:38, Elaine Bradtke  a écrit :
>
>> It hasn't come through. Any ideas where I should check to see why it's not
>> working?  The messages should be coming to this email address (and yes, I
>> checked the spam folder).
>> Thanks!
>> Elaine Bradtke
>> VWML
>> Our income is severely diminished in these exceptionally uncertain times.
>> Please help us to survive beyond this national crisis. Donate now
>> <https://www.efdss.org/support-us>.
>> English Folk Dance and Song Society | http://www.efdss.org
>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
>> Song Society in London, England. If you wish to phone me personally, send
>> an e-mail first. I work off site)
>> ----------
>> Registered Company No. 297142
>> Charity Registered in England and Wales No. 305999
>>
>>
>> On Thu, Jul 9, 2020 at 12:33 PM Elaine Bradtke  wrote:
>>
>> > Question about this new system preference:
>> > How long does it take for the message to come through?  Does it depend
>> on
>> > a cronjob?Just testing it out, and waiting for the message. . . .
>> > Elaine Bradtke
>> > VWML
>> > Our income is severely diminished in these exceptionally uncertain
>> times.
>> > Please help us to survive beyond this national crisis. Donate now
>> > <https://www.efdss.org/support-us>.
>> > English Folk Dance and Song Society | http://www.efdss.org
>> > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>> > Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance
>> and
>> > Song Society in London, England. If you wish to phone me personally,
>> send
>> > an e-mail first. I work off site)
>> >
>> --
>> > Registered Company No. 297142
>> > Charity Registered in England and Wales No. 305999
>> >
>> ___
>>
>> 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] Problems with sound recording records not displaying

[Elaine Bradtke]

We've just installed Koha 20.05.01 in our test system and have a problem
with our sound recordings records.  They show up fine in the hit list, but
when the link is clicked to display the bib record, it fails with a 404
error message.  If I hover the mouse over the link, the bar on the bottom
of the page that shows the URL gives a blank where the biblionumber should
be.  If searched by biblionumber, they come up, and the record displays
normally.

We have a lot of non-book material in our collection, but the problem is
only with the sound recordings.  It appears to be an HTML /CSS problem?
We're using Koha straight out of the box, no special CSS.

As we have thousands of sound recordings in the collection, this is a
serious issue, any help would be appreciated!


Here's an example of one of the records



 000 - LEADER

@ 01642njm a2200253 a 4500

001 - CONTROL NUMBER

@ SR06655

003 - CONTROL NUMBER IDENTIFIER

@ UkLoVW

005 - DATE AND TIME OF LATEST TRANSACTION

@ 20200713112316.0

006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL
CHARACTERISTICS--GENERAL INFORMATION

@ j| | || 0

007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION

@ sd bmmennm||nu

008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION

@ 160809s1965 enkfmz eng d

028 ## - PUBLISHER NUMBER

a Publisher number CLP 1910

b Source His Master's Voice

040 ## - CATALOGING SOURCE

a Original cataloging agency UkLoVW

b Language of cataloging eng

c Transcribing agency UkLoVW

d Modifying agency UkLoVW

099 ## - LOCAL CALL NUMBER

a Classification number SAD 1345

245 00 - TITLE STATEMENT

a Title Folksound of Britain :

b Remainder of title recorded live during the concert presented by the
English Folk Dance & Song Society at the Royal Festival Hall on 4th June
1965. Dominic Behan introduces: /

260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)

b Name of publisher, distributor, etc His Master's Voice,

c Date of publication, distribution, etc 1965.

300 ## - PHYSICAL DESCRIPTION

a Extent 1 sound disc :

b Other physical details analog, 33 1/3 rpm

c Dimensions 12 in.

500 ## - GENERAL NOTE

a General note Sound disc, analog.

a General note Recorded under the auspices of EFDSS.

505 0# - FORMATTED CONTENTS NOTE

a Formatted contents note Side 1: 1. Three Irish polkas / Rakes -- 2. The
Verdant braes of Screne / The McPeakes -- 3. Chevy Chase; The waters of
Tyne / Jack Armstrong and Patricia Jennings -- 4. Derwentwater's farewell /
Louis Killen -- 5. The College Valley Hunt / Louis Killen -- 6. The white
cockade / Bob Davenport with the Rakes -- 7. The banks of the Dee/ Jack
Elliott -- 8. Jowl and listen lad/ Jack Elliott -- Side 2: 1. Three
whiskies / The Countryside Players -- 2. Kissin' in the dark / Dave
Campbell -- 3. The broken token / Winnie Campbell -- 4. The ploughboy / The
Watersons -- 5. The wedding song/ Bob and John Copper -- 6. The three
huntsmen / Cyril Tawney -- 7. Young Rambleway / Cyril Tawney -- 8. How
pleasant and delightful / Charlie Bate -- 9. The Padstow May Song / The
Hobby Horse Party.

850 ## - HOLDING INSTITUTION

a Holding institution UkLoVW

942 ## - ADDED ENTRY ELEMENTS (KOHA)

2 Source of classification or shelving scheme VWML

c Koha [default] item type Sound Recordings

h Class mark SAD 1345

n Hide in OPAC Show in OPAC



Elaine Bradtke
VWML
Our income is severely diminished in these exceptionally uncertain times.
Please help us to survive beyond this national crisis. Donate now
<https://www.efdss.org/support-us>.
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] OPACReportProblem Koha 20.05

[Elaine Bradtke]

It hasn't come through. Any ideas where I should check to see why it's not
working?  The messages should be coming to this email address (and yes, I
checked the spam folder).
Thanks!
Elaine Bradtke
VWML
Our income is severely diminished in these exceptionally uncertain times.
Please help us to survive beyond this national crisis. Donate now
<https://www.efdss.org/support-us>.
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Thu, Jul 9, 2020 at 12:33 PM Elaine Bradtke  wrote:

> Question about this new system preference:
> How long does it take for the message to come through?  Does it depend on
> a cronjob?Just testing it out, and waiting for the message. . . .
> Elaine Bradtke
> VWML
> Our income is severely diminished in these exceptionally uncertain times.
> Please help us to survive beyond this national crisis. Donate now
> <https://www.efdss.org/support-us>.
> English Folk Dance and Song Society | http://www.efdss.org
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send
> an e-mail first. I work off site)
> --
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
>
___

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

[Koha] OPACReportProblem Koha 20.05

[Elaine Bradtke]

Question about this new system preference:
How long does it take for the message to come through?  Does it depend on a
cronjob?Just testing it out, and waiting for the message. . . .
Elaine Bradtke
VWML
Our income is severely diminished in these exceptionally uncertain times.
Please help us to survive beyond this national crisis. Donate now
<https://www.efdss.org/support-us>.
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] Frameworks and Their Purpose

[Elaine Bradtke]

If you can see the 949$c in MarcEdit, you can change it there.  I'm pretty
sure I did this to a batch of records, but it was quite a while ago.

Elaine Bradtke
VWML
Our income is severely diminished in these exceptionally uncertain times.
Please help us to survive beyond this national crisis. Donate now
<https://www.efdss.org/support-us>.
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Thu, Jul 9, 2020 at 12:19 AM Charles Kelley 
wrote:

> Hello again, all!
>
> In an earlier exchange, on 7 July 2020 at 09:51, I wrote:
>
> I do have a follow-up question: Is it possible in Koha to change a
> framework
> > of a group records en masse? For example, if I have a group of 747 maps
> > (949 $c = "MAP") but their framework is BKS, can I change the framework
> > to MAP through Koha in one fell swoop (and if so, how so); or must I
> > painstakingly change them one at a time?
> >
> > I have tried exporting them into MarcEdit and importing them anew
> into
> > Koha while selecting "Import this batch into the catalog" with "Add new
> bibliographic
> > records into this framework:" (select from the dropdown menu), but the
> > framework for each record remains as it was before the exporting and
> > importing.
> >
>
> On 6 July 2020, at 21:14, Eric Bégin  replied:
>
>
> > As far as I know, there is no way to change the records framework in
> batch
> > editing.
> >
> > If I had to do it, I would update the data directly in the database.
> >
> > The framework is defined as the 'frameworkcode' column of the 'biblio'
> > table.
> >
>
> I was afraid of that. Thanks for the reply.
>
> --
>
> 気を付けて。 /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 <http://www.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] Questions about creating a new framework

[Elaine Bradtke]

I found duplicating  an existing framework and editing it within Koha
worked best.  The imported ones always seemed to have problems, possibly
from my overzealous editing techniques.  Though that was back in Koha 3
something, so things may be different now.
Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Tue, Jun 2, 2020 at 11:51 PM yeung yc  wrote:

> *Hi guys, I am creating a new MARC framework, which restores the below
> tags:*
>
> tagfield liblibrarian libopac repeatable mandatory authorised_value
> ind1_defaultvalue ind2_defaultvalue frameworkcode
> 000 LEADER LEADER 0 1 # # # #
> 003 CONTROL NUMBER IDENTIFIER CONTROL NUMBER IDENTIFIER 0 1 # # # #
> 005 DATE AND TIME OF LATEST TRANSACTION DATE AND TIME OF LATEST TRANSACTION
> 0 1 # # # #
> 006 FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS
> FIXED-LENGTH
> DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS 1 0 # # # #
> 008 FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION FIXED-LENGTH DATA
> ELEMENTS--GENERAL INFORMATION 0 1 # # # #
> 040 CATALOGING SOURCE CATALOGING SOURCE 0 1
> # # #
> 041 LANGUAGE CODE LANGUAGE CODE 1 0 # # # #
> 045 TIME PERIOD OF CONTENT TIME PERIOD OF CONTENT 0 0 # # # #
> 100 MAIN ENTRY--PERSONAL NAME MAIN ENTRY--PERSONAL NAME 0 0
> # # #
> 245 TITLE STATEMENT TITLE STATEMENT 0 1 # # # #
> 260 PUBLICATION, DISTRIBUTION, ETC. PUBLICATION, DISTRIBUTION, ETC. 1 0
> # # #
> 300 PHYSICAL DESCRIPTION PHYSICAL DESCRIPTION 1 0
> # # #
> 500 GENERAL NOTE GENERAL NOTE 1 0
> # # #
> 563 BINDING INFORMATION BINDING INFORMATION 1 0
> # # #
> 650 SUBJECT ADDED ENTRY--TOPICAL TERM SUBJECT ADDED ENTRY--TOPICAL TERM 1 0
> # # #
> 710 ADDED ENTRY--CORPORATE NAME ADDED ENTRY--CORPORATE NAME 1 0
> # # #
> 856 ELECTRONIC LOCATION AND ACCESS ELECTRONIC LOCATION AND ACCESS 1 0
> # # #
> 942 ADDED ENTRY ELEMENTS (KOHA) ADDED ENTRY ELEMENTS (KOHA) 0 0 # # # #
> 952 LOCATION AND ITEM INFORMATION (KOHA) LOCATION AND ITEM INFORMATION
> (KOHA) 1 0 # # # #
>
> *Surprisingly, after importing the framework in ods format, it only shows
> part of the tags:*
>
> 000 LEADER No Yes
>
>
>
>
> 003 CONTROL NUMBER IDENTIFIER No Yes
>
>
>
>
> 005 DATE AND TIME OF LATEST TRANSACTION No Yes
>
>
>
>
> 006 FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS Yes No
>
>
>
>
> 008 FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION No Yes
>
>
>
>
> 041 LANGUAGE CODE Yes No
>
>
>
>
> 045 TIME PERIOD OF CONTENT No No
>
>
>
>
> 245 TITLE STATEMENT No Yes
>
>
>
>
> 942 ADDED ENTRY ELEMENTS (KOHA) No No
>
>
>
>
> 952 LOCATION AND ITEM INFORMATION (KOHA) Yes No
>
>
>
> *And I cannot see anything when creating a new record using this new
> framework. Is there any restriction of creating new framework? Also, I
> would like to add some tags, such as number of pages, institution storing
> the item, country that the item is stored, link to remote material,
> observations and so on. I wonder how the sql works if I add these tags.
> Will the add action automatically create a field in db? Will these item
> show properly in the opac searching result page? Thank you for your time.
> Appreciate for any help!*
> ___
>
> 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] [Cataloging] Notes from Cat-SIG, June 4, 2020

[Elaine Bradtke]

I would just like to say, I wish we'd had this SIG back when we first
started using Koha! I was lucky to be able to spend an afternoon with a
Koha user who helped me understand some of the basics, and got me started,
but the  knowledge base in this group is astounding.
Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Thu, Jun 4, 2020 at 10:17 AM 'Hernandez, Heather H' via Cataloging
Special Interest Group  wrote:

> Hi, all--
>
> Our Koha-US Cataloging SIG meeting on June 4 was not recorded, but here
> are the notes from the meeting:
>
> Information on the Koha-US Cataloging SIG is here, open to everyone (you
> don't need to be a Koha-US member to join):
> http://koha-us.org/special-interest-groups/
>
> MarcEdit and batch processes:
> The process in our May meeting for verifying & downloading authority
> records, recorded here https://youtu.be/J2WddLD41uQ , was correct.
> Subsequent testing has shown that sometimes you do get a file full of free
> authority records downloaded from the Library of Congress, but sometimes
> you don't--it seems that sometimes LC is responsive, sometimes it's not.
> Participants have found this also with batch searching/download of
> bibliographic records as well, but more testing is needed.  The question
> was asked if LC throttles numbers of records at one time?  We don't know at
> this point.
> MarcEdit is available here: https://marcedit.reeset.net/
> Fred played a short video of his use of MarcEdit to batch search and
> download records.   If you're new to MarcEdit, there is a good "101 series"
> of videos here: https://marcedit.reeset.net/marcedit-101-workshop
> And Terry Reese (the MarcEdit developer) has posted a lot of updated
> how-to videos on his YouTube channel:
> https://www.youtube.com/channel/UC7OLudoObYgiN_EmyDtZ_DQ
>
> Record templates:
> I created a page on the Koha wiki with a template for a "good enough"
> bibliographic record, with a link to download this record in MARC:
> https://wiki.koha-community.org/wiki/Good_enough_biblio_record/
> It currently doesn't have a subject heading field, but I'll add that.
> I'll also add a link on the Koha wiki to the Library of Congress' MARC21
> page for those who would like to find out more about MARC.
> It was also mentioned that one library has a lot of template records in
> their Koha catalog and that they hide them.
>
> Elaine shared a link to a .pdf file that she created with tons of useful
> resources that includes many of the resources mentioned here, in addition
> to other great resources:
>
> https://drive.google.com/file/d/108VI7xdMQo0QpGYZ43Wy-hKl9FbUinn3/view?usp=sharing
>
> Many of us viewed the ByWater video on setting up Z39.50 servers in Koha:
> https://youtu.be/HxZHekLGWxA
> This video mentions the IRSpy directory of Z39.50 targets--you can add
> your catalog to it, too:
> http://irspy.indexdata.com/
> You can also find Z39.50 targets (and add your catalog) to the Koha wiki:
> https://wiki.koha-community.org/wiki/Koha_Open_Z39.50_Sources
>
> Authorities:
> Experiences with authority records and authorities workflows were
> shared--some libraries outsource this (one library uses Backstage Library
> Works), some do it in house.  Thomas shared this link
> http://www.loc.gov/cds/products/marcDist.php to the MARC record
> distributing from the Library of Congress.  Some libraries are cleaning up
> local authority files migrated into Koha from previous systems (and use
> reports available from the Koha wiki
> http://wiki.koha-community.org/wiki/SQL_Reports_Library and/or imported
> from Mana, a capability in later versions of Koha).  ByWater did a video of
> how to add reports to the Koha wiki:
> https://www.youtube.com/watch?v=lHlGjszH5Zo
> And also did a video on editing reports from Mana:
> https://www.youtube.com/watch?v=AVmw7f1hL8g
>  Some libraries are also working on correcting/updating headings in their
> bibliographic records.  Sharing workflows is encouraged, especially for
> working remotely--we can share these workflows via email and/or in the
> Cataloging Training Resources area of the Koha wiki,
> https://wiki.koha-community.org/wiki/Training_resources#Cataloging ,
> and/or at our future Cataloging SIG meetings (which will be recorded).
>
> Some folks communicate additions/changes for headings/authority records to
> the Library of

Re: [Koha] Batch import of patrons fails in 19.11.05

[Elaine Bradtke]

This went offlist for a bit, but the gist of it is, userid is required even
though it's not listed as a requirement in the notes on the Import patrons
field.   I've filed a bug to update the information on the Patron Import
page to reflect this. 25657
<https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25657>
Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Mon, Jun 1, 2020 at 4:29 PM Eric Phetteplace 
wrote:

> I assume seeing the batch import data will help clear this up. Could you
> share an anonymized sample? It seems like Koha is thinking that your userid
> is the one to use for all the incoming patrons, which to me seems like
> something that might happen if you ommitted userid in the import file. I
> believe it's a required field. But that is pure speculation, obviously.
>
> Best,
> Eric Phetteplace
> Systems Librarian
> California College of the Arts
>
> On Mon, Jun 1, 2020, 3:26 PM Elaine Bradtke  wrote:
>
>> That's not news in itself, it's easy enough to get something wrong, but
>> the
>> error message I  got back is rather curious.
>> Error analysis:
>>
>>- Userid elaine.bradtke is already used by another patron.
>>- Userid elaine.bradtke is already used by another patron.
>>- Userid elaine.bradtke is already used by another patron.
>>- Userid elaine.bradtke is already used by another patron.
>>- Userid elaine.bradtke is already used by another patron.
>>- Userid elaine.bradtke is already used by another patron.
>>- Userid elaine.bradtke is already used by another patron.
>>- Userid elaine.bradtke is already used by another patron.
>>- Userid elaine.bradtke is already used by another patron.
>>- Userid elaine.bradtke is already used by another patron.
>>- Userid elaine.bradtke is already used by another patron.
>>    - Userid elaine.bradtke is already used by another patron.etc. for all
>>2000+ records.
>>
>>
>>Any thoughts on this?
>>
>> Elaine Bradtke
>> VWML
>> English Folk Dance and Song Society | http://www.efdss.org
>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
>> Song Society in London, England. If you wish to phone me personally, send
>> an e-mail first. I work off site)
>> --
>> Registered Company No. 297142
>> Charity Registered in England and Wales No. 305999
>> ___
>>
>> 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] Batch import of patrons fails in 19.11.05

[Elaine Bradtke]

That's not news in itself, it's easy enough to get something wrong, but the
error message I  got back is rather curious.
Error analysis:

   - Userid elaine.bradtke is already used by another patron.
   - Userid elaine.bradtke is already used by another patron.
   - Userid elaine.bradtke is already used by another patron.
   - Userid elaine.bradtke is already used by another patron.
   - Userid elaine.bradtke is already used by another patron.
   - Userid elaine.bradtke is already used by another patron.
   - Userid elaine.bradtke is already used by another patron.
   - Userid elaine.bradtke is already used by another patron.
   - Userid elaine.bradtke is already used by another patron.
   - Userid elaine.bradtke is already used by another patron.
   - Userid elaine.bradtke is already used by another patron.
   - Userid elaine.bradtke is already used by another patron.etc. for all
   2000+ records.


   Any thoughts on this?

Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] Report help needed

[Elaine Bradtke]

Not condescending at all, the things I don't know about reports would fill
a book.
Interesting report you have there by the way.
The purpose for mine is to double check the position 06 against the 942 $c
because there is a bug 19419 that seems to cause trouble with the 008 if
the Leader 06 is not set correctly for the format (still trying to verify
that's what's going on).  I wanted to find any records that didn't have the
appropriate Leader 06 for a given format as specified in the 942.
Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Wed, May 27, 2020 at 2:00 PM Michael Sutherland  wrote:

> Elaine,
>
> Maybe this would be helpful for those codes -
> https://www.loc.gov/marc/bibliographic/bdleader.html
>
> And, to break it down for those that do not know and are interested, (at
> the risk of condescending, which is not my intention, please, please, I
> hope you do not take it that way)
>
> in the expression - SUBSTRING(ExtractValue(metadata,'//leader'),7,1) AS
> "Position06"
>
> you are wanting to extract a piece (substring) from the entire leader
> string - metadata,'//leader' - the 7 is the value that specifies the
> initial position from which the characters can be extracted. The first
> position of the expression starts with 1. But, in MARC the first position
> is 0 (zero). The next value is a positive integer value that specifies the
> ending limit and determines how many characters are going to be
> extracted from the given expression in this case '1', which will give you
> the single letter code in the leader 06, or the seventh position, however
> you choose to look at it.
>
> So, in collaboration with ByWater Solutions, I have co-written the
> following report, which I use to report collection statistics by itemtype
> to ACRL and ARL on our collection sans suppressed records from the OPAC. It
> takes the combination of the leader 06 and 07 to determine itemtype and
> count them.
>
> SELECT
> CASE SUBSTR(metadata,282,2)
>   WHEN ' m' THEN 'Book'
>   WHEN '2m' THEN 'Book'
>   WHEN 'am' THEN 'Book'
>   WHEN 'aa' THEN 'Book'
>   WHEN 'ac' THEN 'Book'
>   WHEN 'ad' THEN 'Book'
>   WHEN 'ai' THEN 'Book'
>   WHEN 'as' THEN 'Journal'
>   WHEN 'cc' THEN 'Music Score'
>   WHEN 'cm' THEN 'Music Score'
>   WHEN 'dm' THEN 'Music Score'
>   WHEN 'ei' THEN 'Map'
>   WHEN 'em' THEN 'Map'
>   WHEN 'es' THEN 'Map'
>   WHEN 'ga' THEN 'Video recording and motion pictures'
>   WHEN 'gs' THEN 'Video recording and motion pictures'
>   WHEN 'gc' THEN 'Video recording and motion pictures'
>   WHEN 'gi' THEN 'Video recording and motion pictures'
>   WHEN 'gm' THEN 'Video recording and motion pictures'
>   WHEN 'ic' THEN 'Non-music sound recording'
>   WHEN 'im' THEN 'Non-music sound recording'
>   WHEN 'is' THEN 'Non-music sound recording'
>   WHEN 'jm' THEN 'Music sound recording'
>   WHEN 'jc' THEN 'Music sound recording'
>   WHEN 'ji' THEN 'Music sound recording'
>   WHEN 'kc' THEN '2D image'
>   WHEN 'km' THEN '2D image'
>   WHEN 'ma' THEN 'Computer file'
>   WHEN 'mi' THEN 'Computer file'
>   WHEN 'mm' THEN 'Computer file'
>   WHEN 'ms' THEN 'Computer file'
>   WHEN 'oc' THEN 'Kit'
>   WHEN 'om' THEN 'Kit'
>   WHEN 'pc' THEN 'Mixed material'
>   WHEN 'pm' THEN 'Mixed material'
>   WHEN 'rc' THEN '3D Object'
>   WHEN 'rm' THEN '3D Object'
>   WHEN 'tc' THEN 'Manuscript'
>   WHEN 'tm' THEN 'Manuscript'
>   ELSE 'unknown' END AS Type,
> COUNT(DISTINCT biblionumber) AS Titles,
> COUNT(itemnumber) AS Volumes
> FROM biblio_metadata
> LEFT JOIN items USING (biblionumber)
> WHERE
>  ExtractValue(metadata,'//datafield[@tag="942"]/subfield[@code="n"]')
> != 1
> GROUP BY Type
> WITH ROLLUP
>
> which generates the following
>
> TypeTitlesVolumes
> 2D image 65 92
> 3D Object 21 21
> Book 1193934 1329489
> Computer file 630 1555
> Journal 38568 542424
> Kit 41 66
> Manuscript 5461 14120
> Map 4754 5770
> Mixed material 253 2517
> Music Score 11948 15757
> Music sound recording 9193 9766
> Non-music sound recording 613 818
> unknown 1018 214
> Video recording and motion pictures 15246 17090
> 1281745 1939699
> titles is th

Re: [Koha] Report help needed

[Elaine Bradtke]

Yes, I think I've got it now.  Thanks for your help.  The hard part was
figuring out where to find the itemtype in the bib record.
SELECT biblio.biblionumber,
SUBSTRING(ExtractValue(metadata,'//leader'),7,1) AS "Position06"
FROM biblio
LEFT JOIN biblio_metadata USING (biblionumber)
WHERE ExtractValue( metadata, '//datafield[@tag="942"]/subfield[@code="c"]'
) = <>
Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Wed, May 27, 2020 at 10:50 AM Elaine Bradtke  wrote:

> It doesn't throw up error messages, but what I really need is a list of
> biblio numbers, with the info in position 6 of the leader and the itemtype
> from the bib record, but also choose a specific itemtype (not books).  I'm
> going to try to mash up what you did with another report and see what
> happens.
> Elaine Bradtke
> VWML
> English Folk Dance and Song Society | http://www.efdss.org
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send
> an e-mail first. I work off site)
> --
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
>
>
> On Wed, May 27, 2020 at 1:51 AM Jonathan Druart <
> jonathan.dru...@bugs.koha-community.org> wrote:
>
>> Hi Elaine,
>>
>> The biblioitems.marcxml field has been moved to biblio_metadata.metadata.
>>
>> Does this query work as you want:
>> SELECT CONCAT('> href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=
>> ',b.biblionumber,'\">',b.biblionumber,'')
>>  AS biblionumber
>> FROM biblio b
>> LEFT JOIN biblioitems bi ON b.biblionumber= bi.biblionumber
>> LEFT JOIN biblio_metadata bm ON b.biblionumber=bm.biblionumber
>> WHERE bi.itemtype = 'BK' AND SUBSTR(bm.metadata,INSTR(bm.metadata,
>> "")+8+6,1) = 'a';
>>
>> Regards,
>> Jonathan
>>
>> Le mar. 26 mai 2020 à 20:35, Elaine Bradtke  a écrit :
>> >
>> > What I'd like it to do - give a list of biblio numbers for records with
>> a
>> > particular itemtype, and the information found in the Leader *06 - Type
>> of
>> > record *field.
>> > I found the following in the reports library as something that could be
>> > modified to fit my needs.  But it doesn't work  I get the following
>> > message: Unknown column 'marcxml' in 'field list'
>> > Please check the log for further details.
>> > Also, I don't understand how to indicate Leader position 06
>> >
>> >  SELECT CONCAT('> detail.pl?biblionumber=
>> > ',biblionumber,'\">',biblionumber,'')
>> >
>> > AS biblionumber
>> >
>> > FROM biblioitems,
>> >
>> > (SELECT biblioitemnumber, SUBSTR(marcxml,INSTR(marcxml,
>> "")+8+6,1)
>> >
>> > AS leader6 FROM biblioitems)
>> >
>> > AS leaders
>> >
>> > WHERE biblioitems.biblioitemnumber=leaders.biblioitemnumber AND
>> > leaders.leader6 = 'a'
>> >
>> > AND itemtype = <>
>> >
>> > Any help would be appreciated
>> >
>> > stay safe,
>> >
>> > Elaine Bradtke
>> > VWML
>> > English Folk Dance and Song Society | http://www.efdss.org
>> > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>> > Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance
>> and
>> > Song Society in London, England. If you wish to phone me personally,
>> send
>> > an e-mail first. I work off site)
>> >
>> --
>> > Registered Company No. 297142
>> > Charity Registered in England and Wales No. 305999
>> > ___
>> >
>> > 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] Report help needed

[Elaine Bradtke]

What I'd like it to do - give a list of biblio numbers for records with a
particular itemtype, and the information found in the Leader *06 - Type of
record *field.
I found the following in the reports library as something that could be
modified to fit my needs.  But it doesn't work  I get the following
message: Unknown column 'marcxml' in 'field list'
Please check the log for further details.
Also, I don't understand how to indicate Leader position 06

 SELECT CONCAT('',biblionumber,'')

AS biblionumber

FROM biblioitems,

(SELECT biblioitemnumber, SUBSTR(marcxml,INSTR(marcxml, "")+8+6,1)

AS leader6 FROM biblioitems)

AS leaders

WHERE biblioitems.biblioitemnumber=leaders.biblioitemnumber AND
leaders.leader6 = 'a'

AND itemtype = <>

Any help would be appreciated

stay safe,

Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

[Koha] Bad 008 fields - how to find them

[Elaine Bradtke]

An unknown number of biblios in our catalogue have bad 008 fields.  I'd
like to be able to fix them, but how do I find  them?
Two things I've noticed about the bad 008s, some lack a date, some have
invalid codes in various positions.
I'd  like to produce a list of biblionumbers of records that are missing
dates, or have invalid codes.  Or possibly two lists one for dates, one for
invalid codes.  Is it possible to do this with a report?  It's beyond my
minimal skills in that area.

Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___

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

Re: [Koha] (no subject)

[Elaine Bradtke]

What field is your acc. no. in?  Ours is actually in the barcode field - if
that's the case, bc: in front of the number will work. If it's the biblio
number you are looking for sn: will work.
Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Thu, Feb 20, 2020 at 2:05 AM Kumari Dissanayake <
dissanayakekuma...@gmail.com> wrote:

>  Search facility in Koha
>
> I have tried to search koha catalogues using ACC.No.  But it didnot work.
>
> In Koha catalogue can we use Inventory Number or Acc.No of a book as a
> search key factor (may be normal search or advanced search key factor
> except title, author, bar code number. isbn no etc..
>
> Please send me relevant options to follow.  An early reply is very much
> appreciated.
>
> thanks
>
> kumari
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Job opening at a Koha library

[Elaine Bradtke]

We're looking for a new Library Director
Please pass the information along to any interested parties.
https://www.efdss.org/images/present/Jobs/VWML_Library__Archives_Director_JD_Jan_2020.pdf?fbclid=IwAR2bLZrndSjAkgp-8_uZhCO67sHGR6jf4FXbEaWnKbTBSeEXJemuA3aGxb8
Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Where has "OpacNavRight" gone?

[Elaine Bradtke]

Must have been something in the air this week, I was looking for that too.
Thank you whoever put the info in the wiki!  I do read the release notes,
but that doesn't mean I remember everything!

https://wiki.koha-community.org/wiki/Koha_simple_themeing_guide
Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Mon, Jan 27, 2020 at 7:17 AM Owen Leonard  wrote:

> The plan is to move all HTML content preferences into the news system.
> The OpacNavRight switch was just the first. However, things have
> stalled a bit since then. I'm still waiting for folks to test the next
> bug in the series, Bug 22880:
>
> Convert opacheader system preference to news block
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22880
>
> If that meets with approval it will lay the groundwork for the rest:
> OpacMainUserBlock, OpacNav, OpacCredits, etc.
>
> Please test if you can!
>
> Thanks,
>
>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
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Books Copies MARC21

[Elaine Bradtke]

The barcode information may not be in the right fields in the imported MARC
record.
https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx)
Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Thu, Nov 14, 2019 at 8:12 AM Mahmoud  wrote:

> Hallo all,
>
> Second question is I am just importing some books from SRU server after
> connecting our university's Koha library to the main country's library in
> Germany which is K10plus. The main point is that Koha is not reading the
> barcode of the books from the MARC data that comes out in not creating book
> copies (we have from every book more than one copy with different
> signature,
> already in the MARC data).
>
> Thank you
> Best regards
>
>
>
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Duplicate ID

[Elaine Bradtke]

Bar codes, patron ID numbers and  001 - CONTROL NUMBER all have to be
unique.  I am not sure which ID number the warning is for, but check those
numbers for duplicates.  Does it happen with every item you check out or
just the one?


Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Fri, Nov 15, 2019 at 9:27 AM Davide Spanu  wrote:

> Good evening,
>
> we are starting to use the koha catalog for loans and we realized that when
> checking out of the copy after booking, when entering the copy code, the
> system generates this error:
>
>
>
>
> Software error:
>
> Duplicate ID
>
> For help, please send mail to the webmaster, giving this error message and
> the time and date of the error.
>
>
>
>
>
> Is there a way to correct this problem?
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Item search

[Elaine Bradtke]

So it appears it's being attacked from two different angles.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23543 to make it
one of the search fields
 and <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23847> - to
fix a problem with search fields with a value of "0" .
This is really excellent news.  I am so grateful for the way the Koha
Community works!
Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Sun, Oct 20, 2019 at 11:18 PM Katrin Fischer 
wrote:

> Hi Elaine,
>
> I've used the custom search fields for other things like vendor
> information and notes fields successfully, but I think you are right,
> that it's not working for withdrawn. I just tested on master and it
> didn't work for me.
>
> I've filed a bug:
> *Bug 23847*
> <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23847> -
> Custom item search fields don't work for Withdrawn
>
> In 19.11, withdrawn will be added to the standard search options and
> this worked well in my tests.
>
> Katrin
>
> On 17.10.19 19:21, Elaine Bradtke wrote:
> > I'd attempted an item search for items marked withdrawn. I added an item
> > search field (Home › Administration › Item search fields) to search on
> 952
> > $0 using the authorised values for withdrawn.
> > But when I run a search using that field, it turns up nothing. I know
> there
> > are at least 11 items in the catalogue marked withdrawn (trying to double
> > check I'm not missing any).
> > I've run a similar search using built in search fields and it works fine.
> > I did make sure the home library was chosen.
> > Thoughts?  Has anyone successfully used a custom search field?
> >
> >
> > Elaine Bradtke
> > VWML
> > English Folk Dance and Song Society | http://www.efdss.org
> > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> > Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance
> and
> > Song Society in London, England. If you wish to phone me personally, send
> > an e-mail first. I work off site)
> >
> --
> > Registered Company No. 297142
> > Charity Registered in England and Wales No. 305999
> > ___
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Item search

[Elaine Bradtke]

I'd attempted an item search for items marked withdrawn. I added an item
search field (Home › Administration › Item search fields) to search on 952
$0 using the authorised values for withdrawn.
But when I run a search using that field, it turns up nothing. I know there
are at least 11 items in the catalogue marked withdrawn (trying to double
check I'm not missing any).
I've run a similar search using built in search fields and it works fine.
I did make sure the home library was chosen.
Thoughts?  Has anyone successfully used a custom search field?


Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [EXTERNAL] Remove Not For Loan / Available distinctions

[Elaine Bradtke]

Thanks again Heather! I found that while digging around. The OPAC looks
pretty good.  But the staff interface is rather untidy.  I think we'll just
have to live with it that way.
Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Tue, Oct 15, 2019 at 12:48 PM Hernandez, Heather <
heather_hernan...@nps.gov> wrote:

> Hi, Elaine--
>
> We're in a similar situation--all our items are available for use in our
> Reading Room, and a select few are eligible for interlibrary loan or our
> staff might check them out.  So I recently suppressed that "status" from
> displaying in the OPAC via:
>
> Home > Administration > Columns settings
> OPAC
> OPAC table, biblio detail
>  item_status (check in the box to make it hidden by default)
>
> If something's checked out, a due date still displays, e.g.:
>
> https://keys.bywatersolutions.com/cgi-bin/koha/opac-detail.pl?biblionumber=13857
> <https://keys.bywatersolutions.com/cgi-bin/koha/opac-detail.pl?biblionumber=13857>
>
>
> Maybe worth trying?  Or maybe you've already tried this?
>
> Hope this is helpful!
> --h2
> ~~
> 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
> Library catalog: http://keys.bywatersolutions.com/
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Remove Not For Loan / Available distinctions

[Elaine Bradtke]

We've been running Koha for a while, but have a new person in charge and
they (correctly) pointed out that displaying Available / Not Available
status for a collection that's 99% reference only is useless and possibly
confusing.
Is there an easy way to switch this display off? A quick look round the
preferences didn't show anything. We're trying to avoid custom
configurations because we've got very minimal, volunteer support.

Right now, just about everything shows up as 'not available'  even though
it's sitting right there on the shelf.
Thanks!
Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Deleted biblio still appearing in search results staff interface

[Elaine Bradtke]

We're running 19:05.02

The problem is with Biblio 13267   A selection of some less known folk
songs, vol. 2
<http://catalogue-admin.efdss.org/cgi-bin/koha/catalogue/detail.pl?biblionumber=13267>
and related name authority record 1493 Winn, Cyril

In the staff interface, if Winn, Cyril is used as a search term, the
results include  A selection of some less known folk songs, vol. 2
<http://catalogue-admin.efdss.org/cgi-bin/koha/catalogue/detail.pl?biblionumber=13267>
-
biblio 13267. It shouldn't be there, it's been deleted.
When the title is clicked on, the answer is: The record you requested does
not exist (13267).

In the OPAC (https://catalogue.efdss.org) when we search on the title, A
selection of some less known folk songs, vol. 2
<http://catalogue-admin.efdss.org/cgi-bin/koha/catalogue/detail.pl?biblionumber=13267>
or
the name Winn, Cyril, or the biblio number the answer that comes up is:

Internal Server Error

We've run a zebra index and it didn't make any difference.
Any ideas on what's causing the problem? Where we should look?
I just did a couple batch edits and uploads, but this particular record was
not in either of those batches.

Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha