[Koha] Fwd: Inventory "problem" column definitions

[Caroline Cyr-La-Rose]

Hello all,

I'm trying to figure out what the "problems" in my inventory output 
mean. I'm using the barcode file input and the CSV output with Koha 
16.05. I extrapolated some definitions, but I can't figure out "item not 
scanned" and "change item status". Please don't hesitate to correct my 
definitions if they are wrong!


 * missing item: item is in the database, but not in the barcode file
 * barcode not found: barcode is not in the database
 * wrong place: item should be in another location
 * item not scanned: item is in the database, but not in the barcode
   file (what is the difference between this and "missing item"?)
 * change item status: ??

Are there other "problems" other than these five?

I will make sure to add the definitions to the wiki, since they are not 
there nor in the manual.


Thanks everybody!


Caroline Cyr La Rose, MLIS
Head of training and support, inLibro
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Fwd: Inventory "problem" column definitions

[Caroline Cyr-La-Rose]

16.05


On 10/31/2017 09:03 AM, Marcel de Rooy wrote:


Which version are you using ?


*Van:* Koha  namens Caroline 
Cyr-La-Rose 

*Verzonden:* vrijdag 27 oktober 2017 01:20:50
*Aan:* koha@lists.katipo.co.nz
*Onderwerp:* [Koha] Fwd: Inventory "problem" column definitions
Hello all,

I'm trying to figure out what the "problems" in my inventory output
mean. I'm using the barcode file input and the CSV output with Koha
16.05. I extrapolated some definitions, but I can't figure out "item not
scanned" and "change item status". Please don't hesitate to correct my
definitions if they are wrong!

  * missing item: item is in the database, but not in the barcode file
  * barcode not found: barcode is not in the database
  * wrong place: item should be in another location
  * item not scanned: item is in the database, but not in the barcode
file (what is the difference between this and "missing item"?)
  * change item status: ??

Are there other "problems" other than these five?

I will make sure to add the definitions to the wiki, since they are not
there nor in the manual.

Thanks everybody!


Caroline Cyr La Rose, MLIS
Head of training and support, inLibro
___
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] HTML5 video embedding returns software error

[Caroline Cyr-La-Rose]

Hello all,

I'm trying to test the HTML5 video embedding functionality (sys pref 
HTML5MediaEnable is "in OPAC and staff client" and HTML5MediaYouTube is 
"embed").


I put a youtube link in the 856 $u and either when I try to save the 
record in Cataloguing or when I try to access the record in the OPAC, I 
get a software error :


garbage after JSON object, at character offset 57801 (before ";ytplayer.load = 
fun...") at /usr/share/perl5/WWW/YouTube/Download.pm line 226.

This is the exact link I put in 856$u: 
https://www.youtube.com/watch?v=iTzaK4l3UJY


I'm using Koha 16.05 with Firefox Quantum.

What am I doing wrong?

Thanks!

Caroline Cyr La Rose, M.S.I.
Bibl. prof. / Chargée de la formation et du soutien

Tél.  : 1 (833) 465-4276
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>

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

Re: [Koha] HTML5 video embedding returns software error

[Caroline Cyr-La-Rose]

Paul and Tomas

Yes, as mentioned by Tomas, I wanted it to embed, like in the manual 
http://translate.koha-community.org/manual/16.05/en/html-desktop/index.html#html5


It's supposed to add a tab an embed the video in it.

If I change the sys pref HTML5MediaYouTube to "Don't embed", it works 
just like in your example, i.e. add a link to the record. But that's not 
what I wanted... :/


Caroline Cyr La Rose, M.S.I.
Bibl. prof. / Chargée de la formation et du soutien

Tél.  : 1 (833) 465-4276
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>

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

Re: [Koha] Screenshots internationalization for the manual (and acceptance tests?)

[Caroline Cyr-La-Rose]

Hi Jonathan,

I'm not sure I understand everything in your email. Let me know if I'm 
understanding this right. What you are asking is if we (the 
non-technical ppl) would be willing to write up "steps" for each of the 
1300+ screenshots in the manual so that developers can translate those 
into code to automate the screenshot-taking and deploy it across all 
manuals and all languages.


Do we have enough developers in the community to do that? I don't want 
to speak for the whole documentation team, but I think that if we do it 
little by little (when we review a section or sub-section for example), 
it is feasible. It might take a couple of years to go through the 1300+ 
pictures, though. And we would need to have a way to know which 
screenshot has been automated and which is still manual (ideally, 
directly in the manual, maybe with a comment?).


When we want to add a screenshot, let's say for a new feature, how does 
the workflow go? Do we take a manual screenshot first and write up the 
steps? Or just write the steps and wait for the developer to take the 
screenshot?


What about when we want to add squares or circles to point out a 
specific button (do we do that in the manual?) or add numbers like in 
this example you sent : 
http://download.koha-community.org/manual/wip_screenshots/en/html/_images/marc21_basic_setup.png 
?


I hope this helps your reflection

Caroline Cyr La Rose, M.L.I.S.
Head of training and support, inLibro

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

[Koha] Bath edit record to change one character in a control field

[Caroline Cyr-La-Rose]

Hi all,

Is there a way to use the batch record edit / MARC modification template 
tools to change specific characters in the leader or other control fields?


I want to add audience information to a bunch of records. When I try to 
make my MARC modification template, I can't enter let's say "Add/Update 
fields 008/22 with value j". The "Field" field is limited to 3 
characters, so I can't write 008/22 and the "subfield" field is limited 
to 1 character so I can't write 22.


Thanks for your help!

--
Caroline Cyr La Rose, M.S.I.
Bibl. prof. / Chargée de la formation et du soutien

Tél.  : 1 (833) 465-4276
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Anonymous Search History

[Caroline Cyr-La-Rose]

Hi All,

I'm trying to figure out the search_history table in Koha. Are anonymous 
OPAC searches ever added to that table? My EnableOpacSearchHistory 
syspref is set to "Keep" and my AnonymousPatron syspref is set to 21. I 
see in the C4::Search::History that if a user is not logged in, the 
search history is saved in a cookie. But is it ever saved in the database?


I'd like to know what words patrons use when they are searching, 
regardless of if they are logged in or not.


Thanks!

Caroline Cyr La Rose, MLIS
Head of training and support, inLibro

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

Re: [Koha] Cataloging Error

[Caroline Cyr-La-Rose]

Hi Ashley!

I've never used 3.18, so my answer might not be 100% right.

I often get that error if I don't fill out the control fields (000, 003, 
008, and especially 005 which I always forget).


If you want to see which fields are mandatory, go to Administration > 
MARC bibliographic framework. Be sure to check the right framework you 
were using while cataloging (to check that, click on the Settings button 
in the cataloging form https://snag.gy/cNuFsB.jpg)


Once you're in the right framework, there is a column that says 
"Mandatory". This applies to the entire field. So for example, 000 is 
mandatory. However, subfields also have a "mandatory" flag. I'm not sure 
if you can have a mandatory subfield in a non mandatory field (not sure 
that makes sense), but I'd check that too. For example, 245 might not be 
mandatory, but 245 $a might be mandatory.


If you don't want to check all the 999+ subfields manually, you can 
export your framework in Excel or equivalent and check the mandatory 
column for 1's.


Let me know if you need more help!

Caroline

Caroline Cyr La Rose, M.L.I.S.
Head of training and support, inLibro


Le 2018-07-23 à 20:00, koha-requ...@lists.katipo.co.nz a écrit :

Send Koha mailing list submissions to
koha@lists.katipo.co.nz

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.katipo.co.nz/mailman/listinfo/koha
or, via email, send a message with subject or body 'help' to
koha-requ...@lists.katipo.co.nz

You can reach the person managing the list at
koha-ow...@lists.katipo.co.nz

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha digest..."


Today's Topics:

1. Re: Drawing Software - Floor Mapping Library's Collections
   (Magnus Enger)
2. Re: Drawing Software - Floor Mapping Library's Collections
   (Owen Leonard)
3. Re: Drawing Software - Floor Mapping Library's Collections
   (Indranil Das Gupta)
4. Re: Drawing Software - Floor Mapping Library's Collections
   (Barton Chittenden)
5. Koha 18.05.02 released (Martin Renvoize)
6. Cataloging Error (Ashley Bassett (RMUoHP))
7. Re: Koha 18.05.02 released (Michael Kuhn)


--

Message: 1
Date: Mon, 23 Jul 2018 09:17:14 +0200
From: Magnus Enger 
To: Koha list 
Subject: Re: [Koha] Drawing Software - Floor Mapping Library's
Collections
Message-ID:

Content-Type: text/plain; charset="UTF-8"

On Tue, 17 Jul 2018 at 23:07, Indranil Das Gupta  wrote:

This might be interesting if we are looking for OSS solutions
https://wiki.openstreetmap.org/wiki/Indoor_Mapping

There is also this library, which might prove useful:
https://leafletjs.com/
It can be used with custom images (e.g. a floorplan of a library).

I think a mapping function for Koha, where we could show the
(approximate) location of an item on a map, would be super useful. I
guess there are three ways to do it:

- Build it right into Koha
- Build it as a plugin for Koha
- Build a free standing web thingy that can work with Koha (through a
link from Koha to a map)

If anyone is interested in collaborating on this please let me know!

Best regards,
Magnus
Libriotech


--

Message: 2
Date: Mon, 23 Jul 2018 08:30:40 -0400
From: Owen Leonard 
To: Koha list 
Subject: Re: [Koha] Drawing Software - Floor Mapping Library's
Collections
Message-ID:

Content-Type: text/plain; charset="UTF-8"


I think a mapping function for Koha, where we could show the
(approximate) location of an item on a map, would be super useful.

I don't know anything about how an implementation would work, but I'd
like to put in my vote for a solution that uses SVG. There are perl
libraries for generating SVG, so it might be possible to overlay a
dynamically-generated marker onto a custom SVG library map.

  -- Owen



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

Re: [Koha] Report help

[Caroline Cyr-La-Rose]

Hi David,

Did you try with the statistics wizards? If you go in Reports > 
Statistics wizards > Patrons and then choose your first attribute "CC" 
as a row and "CD" as a column, it should give you a table with all the 
different combinations and the count of patrons with that combination.


Caroline

Caroline Cyr La Rose, M.S.I.
Bibl. prof. / Chargée de la formation et du soutien

Tél.  : 1 (833) 465-4276
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
Le 2018-08-03 à 11:57, David Hughes a écrit :

Hi,

I want to create a report that gives a grand total of records with various
combinations of two different patron attributes.

I have two different borrower_attributes.code values "CC" and "CD" and I
want to output the grand totals of records with all permutations of
borrower_attributes.attribute that have these codes.  So if
borrower_attributes.code CC has values 1, 2, 3 etc and
borrower_attributes.code CD has values A, B C  I'd want to output the grand
totals of all records having

CC value "1" CD value "A"
CC value "1" CD value "B"
CC value "1" CD value "C"
..
CC value "2" CD value "A"
CC value "2" CD value "B"

etc

This is outwith the scope of my very limited SQL, so I'd appreciate any
help that the community would be able to offer.  Thanks.

Kind regards

David Hughes

Systems Librarian
Dublin Business School
13-14 Aungier St.
Dublin 2
Ireland

00 353 1 417 8744

david.hug...@dbs.ie
*http://library.dbs.ie <http://library.dbs-students.com/>*



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

Re: [Koha] Mapping MARC21 to Advanced Search

[Caroline Cyr-La-Rose]

Hi Rubén!

In the manual, there is a kind of mapping section for searches that 
gives you the indexes for each marc field: 
https://koha-community.org/manual/18.05/en/html/searching.html#koha-search-indexes


If you want to know what index is used for each search limit, you can 
make a search in Koha and look in the breadcrumbs for "Search for 
'...'". This will give you the index used for the search. For example, 
if I search with Danish in the language limit, it returns 'ln,rtrn:dan'. 
According to the manual, the 'ln' index is mapped to 008, position 
35-37, and 041.


I hope this helps.

Maybe it could be more explicit in the manual. I will look into that!

Caroline


Caroline Cyr La Rose, M.S.I.
Bibl. prof. / Chargée de la formation et du soutien

Tél.  : 1 (833) 465-4276
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
Le 2018-08-12 à 15:52, Rubén Fernández Asensio a écrit :


Hello all,
I'm trying to plan the cataloguing requirements for our Esperanto 
library, and since we don't have to follow any other library's 
standards, we don't want to type more that strictly needed. My goal is 
cataloguing according to the information our own users will be able to 
retrieve from the Koha OPAC, no more, no less.


However, the mapping of MARC21 fields to Advanced Search Options seems 
to be undocumented.


For example, what field is used to search by language or publisher 
location? Why the "Content" option doesn't match character 33 of field 
008? In the search field, what's the exact meaning of "Subject and 
broader terms", "Subject and narrower terms", "Subject and related 
terms", and "Curriculum"? Where are you supposed to input that when 
cataloguing?


Sorry if my questions are naive, I'm just an amateur sysad and amateur 
librarian working in my spare time for a nonprofit.


Rubén Fernández
___
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] Vote for the KohaCon 2019 location now!

[Caroline Cyr-La-Rose]

Hello everyone!


The vote for the location of KohaCon19 is now open!

The proposals are available on the wiki: 
https://wiki.koha-community.org/wiki/KohaCon19_Proposals



The rules for voting are the following:

* Everyone can vote

* One vote per person

* You must first register with your e-mail address (preferably your 
institutional e-mail)


* You will receive an e-mail with the link to the survey

* You must rank both options, with your first choice on top


To vote, go to http://kohacon19.inlibro.net


The vote is open until September 30, 2018, 23:59 UTC. The winner will be 
announced during the October General IRC meeting and also here on the 
mailing list.



On behalf of the whole community, I thank both groups for offering to 
host KohaCon19 and I wish them good luck!



Caroline Cyr La Rose, MLIS
Head of training and support, inLibro
caroline.cyr-la-r...@inlibro.com

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

[Koha] Should XSLT add punctuation?

[Caroline Cyr-La-Rose]

Hello everyone!

I have a question regarding the XSLT stylesheets (for MARC21). Is it 
supposed to change the punctuation when displaying the record?


For instance, I have a record where there is a period (.) at the end of 
100$e. So in MARC, it looks like


100 1#
a Goscinny, René,
d 1926-1977-,
e author.

In intranet details, it looks like

Goscinny, René, 1926-1977- [author.].

There are two periods (and no comma after the date).

In the 260 field, the opposite happens. There is a period at the end of 
260$c in MARC, but nothing is appearing in intranet results.


260 ##
a Paris :
b Gallimard jeunesse,
c [2014].

In the intranet details, it looks like

Paris : Gallimard jeunesse, [2014]

There is no period after the date.

It's not clear what the XSLT is trying to do. On one hand, it looks like 
it's trying to complete the punctuation, but it removes it sometimes.


My knowledge of AACR2 rules for punctuation was wiped from my brain the 
second I graduated ~10 years ago (maybe even before, if I'm being really 
honest!), so I'm not even sure what the right punctuation is supposed to 
be.


But my question is if the XSLT is supposed to mess with the punctuation 
or not? And if the answer is yes, shouldn't it look first in leader/18 
to see if the record already has punctuation?



Thank you for your help koha!

Caroline


Caroline Cyr La Rose, M.L.I.S.
Librarian, Head of training and support
inLibro

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

Re: [Koha] Optional authority control in MARC21 700 field

[Caroline Cyr-La-Rose]

Hi Rubén,

I don't think there is a way to optionally use authorities in one field. 
However, you can use the BiblioAddsAuthorities system preference to 
allow catalogers to freely enter names in the 700 field. That way, they 
don't have to search for existing authorities. You also have to set 
AutoCreateAuthorities to "do not generate" so that the names the 
catalogers enter don't create new authorities.


The only downside is that those system preferences apply to *all* 
fields. So you can't force authorities in the 100 field but not in the 
700 field, for example.


I hope that helps,

Caroline

--

Caroline Cyr La Rose, M.L.I.S.
Librarian, Head of Training and Support
inLibro

Le 2018-08-23 à 05:05, Rubén Fernández Asensio a écrit :


Hello all,
In my library, we've decided to do authority control for added entries 
only for personal names meeting certain requirements. (We're probably 
in violation of all cataloguing rules, but we just haven't got the 
time and means to control all secondary authors, and yet don't want to 
fully renounce authority control; there must be a middle ground.)
However, there's no way to activate the authority thesaurus only 
optionally and allow free text typing instead. I've tried adding a 
second 700 field with different requirements but it's not added. A new 
700a subfield simply replaces the previous one.
Is there a technical way around this? Or else, a better way of 
achieving this, and allowing one single record to have different 700 
fields with authority control and without it? What would you do?


Rubén
___
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] Don't forget to vote for the KohaCon19 location!

[Caroline Cyr-La-Rose]

Hello everyone!


For those who haven't gotten around to it, don't forget to vote for the 
KohaCon19 location!


To vote, go to http://kohacon19.inlibro.net


The proposals are available on the wiki: 
https://wiki.koha-community.org/wiki/KohaCon19_Proposals



A reminder of the rules for voting:

* Everyone can vote

* One vote per person

* You must first register with your e-mail address (preferably your 
institutional e-mail)


* You will receive an e-mail with the link to the survey

* You must rank both options, with your first choice on top


The vote is open until September 30, 2018, 23:59 UTC. The winner will be 
announced during the October General IRC meeting and also here on the 
mailing list.



Again, on behalf of the whole community, I thank both groups for 
offering to host KohaCon19 and I wish them good luck!



Caroline Cyr La Rose, MLIS
Head of training and support, inLibro
caroline.cyr-la-r...@inlibro.com

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

Re: [Koha] Reindex (Authorities & Bibliographic Records)

[Caroline Cyr-La-Rose]

Hi drojup,

I didn't see any answer on the list, but someone may have already 
answered you.


The zebra reindexing command is the following:

./misc/migration_tools/rebuild_zebra.pl -a -b -v -r

-a : reindex authorities

-b : reindex biblios

-v : verbose

-r : reset indexes (erase and rebuild from zero)

Depending on the number of records, this may take a while.

I don't know if this will resolve your sorting issue.

Caroline

Caroline Cyr La Rose, M.L.I.S.
Librarian / Head of training and support

Tél.  : 1 (833) 465-4276
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
Le 2018-09-21 à 07:44, drojup a écrit :

Hi there,

I noticed that sorting in alphabetical order by title doesn't seem to be
right. (I am aware about the 245 indicator).

I was thinking to execute a reindexing command but I am not sure which is
the right command.

I use Zebra.

Any ideas?

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] Reindex (Authorities & Bibliographic Records)

[Caroline Cyr-La-Rose]

Hi,

I think that has to do with ICU.

You can look on the wiki for more information on configuring ICU :

- https://wiki.koha-community.org/wiki/ICU_chains_configuration

- https://wiki.koha-community.org/wiki/ICU_Chains_Library

Caroline

Caroline Cyr La Rose, M.L.I.S
Librarian / Head of training and support

Tél.  : 1 (833) 465-4276
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
Le 2018-09-21 à 15:12, drojup a écrit :

Hi Caroline,

Thank you very much for your help.

I executed the following command and I was able to reindex my records.
sudo koha-rebuild-zebra -f -v  instancename

I just found that the problem is related only to Greek characters. The
English titles can be sorted in alphabetical order as it should. But when
the titles are in Greek the sorting doesn't seem to work. Maybe a bug?

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

[Koha] One week left to vote for the KohaCon19 location!

[Caroline Cyr-La-Rose]

Hello everyone!


There is only **one week** left to vote for the KohaCon19 location! Vote 
now of forever hold your peace!


To vote, go to http://kohacon19.inlibro.net


The proposals are available on the wiki: 
https://wiki.koha-community.org/wiki/KohaCon19_Proposals



A reminder of the rules for voting:

* Everyone can vote

* One vote per person

* You must first register with your e-mail address (preferably your 
institutional e-mail)


* You will receive an e-mail with the link to the survey

* You must rank both options, with your first choice on top


The vote is open until September 30, 2018, 23:59 UTC. The winner will be 
announced during the October General IRC meeting and also here on the 
mailing list.



Again, on behalf of the whole community, I thank both groups for 
offering to host KohaCon19 and I wish them good luck!



Caroline Cyr La Rose, MLIS
Head of training and support, inLibro
caroline.cyr-la-r...@inlibro.com
--
Caroline Cyr La Rose, M.S.I.
Bibl. prof. / Chargée de la formation et du soutien

Tél.  : 1 (833) 465-4276
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Check out restriction to category / branch for School Libraries

[Caroline Cyr-La-Rose]

Did you enable the UseTransportCostMatrix system preference?

Caroline

Caroline Cyr La Rose, M.S.I.
Bibl. prof. / Chargée de la formation et du soutien

Tél.  : 1 (833) 465-4276
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
Le 2018-10-02 à 10:43, anjoze a écrit :

Thank you for your suggestion.
Didn't worked.
I've changed to 999 between the public and school
and 0 between school libraries.
Nothing happens.
On manual
(https://koha-community.org/manual/18.05/en/html/administration.html#transport-cost-matrix)
just says: " The transport cost matrix lets a library system define relative
costs to transport books to one another "
Maybe this is just to statistics...




-
Koha version:   16.05.05
- -
José Anjos
--
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] REPORT 100 AND 700 MARC TAG

[Caroline Cyr-La-Rose]

Hi Hans,

I'm no SQL expert either, but I usually use CONCAT_WS to have the 100 
and 700 authors appear in the same column.


Also, check your mappings in Administration > Koha to MARC mapping. You 
may be able to use biblio.author instead of ExtractValue for the 100 field.


So something like

SELECT CONCAT_WS(biblio.author, ExtractValue(metadata, 
'//datafield[@tag="700"]/subfield[@code="a"]')) FROM biblio_metadata 
JOIN biblio USING (biblionumber)


(metadata is used instead of marcxml in more recent versions of Koha)

Good luck!

Caroline

Caroline Cyr La Rose, M.S.I.
Bibl. prof. / Chargée de la formation et du soutien

Tél.  : 1 (833) 465-4276
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
Le 2018-10-04 à 04:53, Hans Manrique a écrit :

Hello everyone,

I would like to have a report of only fields 100 and 700 in a single
column. I'm a student and I do not understand much about sql, but I've
managed to get a 100 report through ExtractValue syntax queries (marcxml,
xpath). But I do not know how to get one of the fields 100, 700 in a single
report and in a column. Is that possible?

Hans Manrique
___
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] KohaCon19 location vote results

[Caroline Cyr-La-Rose]

Hello everyone!

As most of you know, Interleaf Technologies, Dublin Business School and 
PTFS-Europe won the KohaCon19 bid, which will be held in Dublin from May 
20 to May 26 2019.


During the meeting, I didn't have the exact numbers on hand. Here they 
are now. These are the results for 1st choice:


- Dublin 208 votes, 52.13%

- Stockholm 153 votes, 38.35%

- No vote* 38 votes, 9.52%

* people who registered, but didn't vote, for any number of reasons.


Caroline

--
Caroline Cyr La Rose, M.L.I.S.
Librarian / Head of Training and Support, inLibro

caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

www.inLibro.com <http://www.inLibro.com>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Request For CATALOGING TAG NO

[Caroline Cyr-La-Rose]

Hi Rajesh,

The loc.gov/marc page is the official documentation. You can use it at 
all times for reference.


To save you time, since you seem to be in a rush and MARC documentation 
can be quite daunting, here are the tags you are looking for:



- ISBN: 020 $a (http://www.loc.gov/marc/bibliographic/bd020.html)

- Author name (person*): 100 $a (if more than one, put the others in 700 
$a) (http://www.loc.gov/marc/bibliographic/bd100.html and 
http://www.loc.gov/marc/bibliographic/bd700.html)


* check the other 1XX and 7XX tags if the author is not a person, but an 
organization or something else


- Book title: 245 $a (http://www.loc.gov/marc/bibliographic/bd245.html)

- Edition: 250 $a (http://www.loc.gov/marc/bibliographic/bd250.html)

- Place of publication: 264 $a 
(http://www.loc.gov/marc/bibliographic/bd264.html)


- Publisher name: 264 $b (http://www.loc.gov/marc/bibliographic/bd264.html)

- Date of publication: 264 $c 
(http://www.loc.gov/marc/bibliographic/bd264.html)


- Nb. of pages: 300 $a (http://www.loc.gov/marc/bibliographic/bd300.html)

- Book price: either 020 $c, 037 $c or 541 $h on biblio level or 952 $g 
on item level (http://www.loc.gov/marc/bibliographic/bd020.html, 
http://www.loc.gov/marc/bibliographic/bd037.html, 
http://www.loc.gov/marc/bibliographic/bd541.html or 
https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx))


- Subject: depending on the type of subject, any of the 6XX tags. The 
most used is 650 for topical terms 
(http://www.loc.gov/marc/bibliographic/bd6xx.html)


- Accession date: 005 or 541 $d on biblio level or 952 $d on item level 
(http://www.loc.gov/marc/bibliographic/bd005.html,http://www.loc.gov/marc/bibliographic/bd541.html 
or https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx))


- Name of supplier: 037 $b or 541 $a on biblio level or 952 $e on item 
level (http://www.loc.gov/marc/bibliographic/bd037.html, 
http://www.loc.gov/marc/bibliographic/bd541.html or 
https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx))


- Bill no.: I don't think this information is cataloged in the record or 
the item. You'd have to go through the acquisitions module to add the 
bill number. However, there are always local note fields that you can 
add, 59X


- Library barcode: 952 $p 
(https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx))


- Call number: 050 $a for LC classification, 060 $a for NLM 
classification, 070 $a for NAL classification, 080 $a for UDC 
classification, 082 $a for DDC classification, 084 $a for other 
classification or 09X for local call numbers on biblio level or 952 $o 
on item level (http://www.loc.gov/marc/bibliographic/bd01x09x.html or 
https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx))


- Bill date: I don't think this information is cataloged in the record 
or the item. You'd have to go through the acquisitions module to add the 
bill number. However, there are always local note fields that you can 
add, 59X


- Library actual location: 952 $b (holdingbranch) or 952 $c (shelving 
location)


- Status: 952 $0 (withdrawn status), 952 $1 (lost status), 952 $4 
(damaged status) or 952 $7 (not for loan status) 
(https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx))


- Type: 942 $c on biblio level and 952 $y on item level 
(https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx))



Regards,

Caroline

Caroline Cyr La Rose, M.L.I.S.
Librarian / Head of Training and Support

Tel.  : 1 (833) 465-4276
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
Le 2018-10-15 à 03:42, vinod mishra a écrit :

Read below:

http://www.loc.gov/marc/

With Regards,

Vinod Kumar Mishra,
Assistant Librarian,
Biju Patnaik Central Library (BPCL),
NIT Rourkela,
Sundergadh-769008,
Odisha,
India.
Mob:91+9439420860
Website: http://mishravk.com/
ORCID ID: http://orcid.org/-0003-4666-7874

*"Spiritual relationship is far more precious than physical. Physical
relationship divorced from spiritual is body without soul" -- Mahatma
Gandhi*


On Mon, Oct 15, 2018 at 1:05 PM Rajesh Shelar  wrote:


Please Send Me TAG NO.
1.ISBN NO.
2.AUTHOR NAME
3.BOOK TITLE
4.EDITION
5.PLACE OF PUBLICATION
6.PUBLISHER NAME
7.PUBLISH DATE.
8.NO.OF PAGES
9.BOOK PRICE
10.SUBJECT
11.ACCESSION DATE
12.NAME OF THE SUPPLIER
13.BILL NO.
14.LIBRARY BARCODE NO.
15.CALL NO.
16.BILL DATE
17.LIBRARY ACTUAL LOCATION
18.STATUS
19.TYPE
I Request Please send me this tag No Because my Cataloging entry pending in
Koha software. so please send as early as possible.




--
*Thanks & Regards*



*Mr. Rajesh R.Shelar*
*Sadhu Vaswani Institute Of Management Studies For Girl's ( MBA )*
*Koregaon Road,Pune*
*Mob.No.8380941380*

*Save Water..Conserve Life.*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.

Re: [Koha] Static and calculated fields in new authorities not shown until you click on them

[Caroline Cyr-La-Rose]

Hi Theodoros,

What I usually do is put default information in the field in the MARC 
framework.


I'll do the example for 003, but it would work with any field (maybe not 
005 though).


1- Go in Administration > MARC bibliographic framework (for 
bibliographic records) or Administration > Authority types (for 
authority records)


2- Next to the framework you want to change, click on "Action" and 
choose "MARC structure"


3- Next to the 003 field, click on "Action" and choose "Subfields"

4- Click on "Edit"

5- Click on "Advanced constraints"

6- In "Default value", enter the value you want filled in by default

7- Click on "Save changes"


Also check the following system preferences:

-  DefaultCountryField008

-  DefaultLanguageField008

-  MARCOrgCode

-  MARCAuthorityControlField008


I hope this helps,

Caroline



Caroline Cyr La Rose, M.L.I.S.
Librarian / Head of Training and Support

Tel.  : 1 (833) 465-4276
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
Le 2018-10-15 à 07:19, Theodoros Theodoropoulos a écrit :

Dear all,

We're using Koha 17.11.06 (USMarc) and our cataloguers have the 
following request:


When creating a new authority, some static fields [like Control Number 
Idenifier (003)] as well as some 00x fields that are calculated 
on-the-fly [like Leader(000), Date and time of last transaction (005), 
Fixed length data elements (008), etc] are not shown until you click 
on them. I have created a short video to demonstrate this: 
https://imgur.com/a/dRDhFKr


Although this has always been the default behaviour for new bibs, I 
vaguely remember that the authority fields where shown prefilled by 
default in old 3.x Koha versions.


So, our cataloguers asked if there is an easy way (ie a javascript 
snippet) to have all required (static and dynamically calculated) 
fields prefilled and shown by default when creating a new authority 
(and biblio) because it save them a few 'unnecessary' clicks.


Also, this is the default behavior for advanced editor. Maybe you 
could consider making this the default behavior for the 'classic' 
biblio/authority editor as well?


If you think any of the above requests is valid (and does not conflict 
with general directions/best practices you might have set), I could 
create an enhancement request in BZ case to better keep track of it.


Best regards,
Theodoros Theodoropoulos

___
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] Unable to enter Data in 100$a

[Caroline Cyr-La-Rose]

Hi Rajesh,

There are several options for using authorities when cataloging. Your 
settings are now at option 1, which is the safest, in my opinion.



1) Only allow existing authorities in authority controlled fields

Pros: ensures you don't have duplicate author names or subject terms

Cons: takes a bit longer to catalog since you have to search for the 
authority record


Settings:

- BiblioAddsAuthorities: don't allow

Steps to catalog:

- When you want to enter data in 100$a for example, it will be locked. 
You need to click on the little rectangle with a pen to the right of the 
field.


- From there, you will be able to search for an authority (or create a 
new authority)


- Once you have found the authority you need, click on "Choose". The 
data will be entered automatically and the biblio record will be linked 
to the authority record.



2) Allow catalogers to enter data in authority controlled fields and 
create authority records from that data


Pros: Use authority records to link biblio records

Cons: Will create duplicates if catalogers are not careful

Settings:

- BiblioAddsAuthorities: allow

- AutoCreateAuthorities: generate

Steps to catalog:

- When you need to enter data in 100$a for example, click on the little 
rectangle with a pen to the right of the field and search your 
authorities to see if the author's name already exists


- If it does exist, click on "Choose"

- If it doesn't already exist, you can type in the name of the author 
directly in the cataloging form



3) Don't use authority records at all

Pros: Fast and easy cataloging

Cons: Biblio records will not be linked together; if you need to change 
an author's name for example, you will need to change each biblio record 
individually; if you click on a author's name in the OPAC, it will make 
a search with that exact name, so if other records have a slightly 
different orthograph, they will not be found


Settings:

- BiblioAddsAuthorities: allow

- AutoCreateAuthorities: do not generate

Steps to catalog:

- When you need to enter data in 100$a for example, simply enter the 
name in the box



I think that's all of it.


Regards,

Caroline


Caroline Cyr La Rose, M.S.I.
Bibl. prof. / Chargée de la formation et du soutien

Tél.  : 1 (833) 465-4276
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
Le 18-10-22 à 04 h 33, vikram zadgaonkar a écrit :

Hi,
You need to update setting in koha administration. Search for authority and
update as generate.

On Mon, 22 Oct 2018, 2:01 pm takan bhatt,  wrote:


Sir/Madam

Currently I am using Koha 18.05 in Ubuntu 16.04. I have imported data and
successfully running. Now, I got new books for that I have to enter data.
But field no 100$a is locked, it went to authority. How to solve
this problem?

Kindly Guide me.


Rajesh Bhatt
GRIMS, MBA College,  VAPI
India
+919824925609 (whatsapp)
___
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

Re: [Koha] Handling for items lost in transit

[Caroline Cyr-La-Rose]

Hi Martin and Alex,

Here's my take on the whole thing, for what it's worth.

1) I think this is a bug and should not be switched on or off by a 
system preference.


2) The holding library should revert back to the one it was before the 
transfer.


3) I'm not sure if we should erase the old transfers at upgrade. 
Personally, if I worked in a library, I'd like to have a report of lost 
items currently in transfer and decide what I want to do with them (are 
they reserved? do I have more than one copy? how long ago were they 
declared lost? etc.)


I think bugs 20844 
(https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20844) and 
21754 (https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21754) 
should continue their QA process and hopefully be added in 18.11 before 
release.


However, I think we should discuss the handling of holds and transfers 
throughout Koha regardless of how the lost status is set. I noticed you 
mentioned batchmod, pendingreserves and longoverdue. Whatever the way an 
item was marked as lost, whether manually or a cron or a batch 
modification, the management of pending reserves, waiting reserves, 
transfers or pending transfers should not differ.


At the time it was marked as lost, if the item's status was :

- waiting reserve, this case should be handled bu 20844

- pending reserve, show an alert or have a report for problematic 
reserves. If there is more than one item, it's not a problem as the hold 
will be filled by another item; however, if the record only has one 
item, the library needs to call the user and/or request an ILL or 
whatever their process is for unfillable holds.


- currently in transit, this case should be handled by 21754. (Does this 
also handle reserves that have "T" in the "found" column? I'm guessing 
yes, but just making sure.)


- pending transfer, show an alert or have a report for problematic 
reserves, same as pending reserves.


I didn't touch on rotating collections and stock rotation as I'm not 
sure how these affect transfers.


I hope this helps your cogitation :)


Regards,

Caroline

Caroline Cyr La Rose, M.L.I.S.
Librarian / Head of Training and Support, inLibro

caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>


Le 18-11-01 à 04 h 03, Renvoize, Martin a écrit :

Hi all,

I'm seeking some thoughts regarding 'Bug 21732 - If an item is marked as
lost, any outstanding transfers should be cancelled
<https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21732>'.

Currently, there is no thought given to transfers when an item is marked as
lost, an as such you may have lost items in the transfers queue.  This bug
aims to solve this by triggering a cancellation of the transfer at the
point an item is marked as lost.

We have a few questions:

1) Should this be treated as an enhancement or a bug (If it's an
enhancement then we would enable/disable it's functionality based upon a
system preference. If it's a bug (as I advocate), then it would be always
enabled and no system preference would be added)
2) If the items is 'in transit' where should the items holding library be
set to when it is marked as lost (the from or to library).
3) If we consider this a bug, should we add handling for cleaning up the
transfers table at upgrade time for any lost items.

Many thanks for your help,

*Martin Renvoize*

<https://www.ptfs-europe.com>

Development Team Manager





*Phone:* +44 (0) 1483 378728

*Mobile:* +44 (0) 7725 985 636

*Email:* martin.renvo...@ptfs-europe.com

*Fax:* +44 (0) 800 756 6384


www.ptfs-europe.com







Registered in the United Kingdom No. 06416372   VAT Reg No. 925 7211 30

The information contained in this email message may be privileged,
confidential and protected from disclosure. If you are not the intended
recipient, any dissemination, distribution or copying is strictly
prohibited. If you think that you have received this email message in
error, please email the sender at i...@ptfs-europe.com
___
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] Import/Export authority frameworks

[Caroline Cyr La Rose]

Hi Italo,  

Check the manual, it explains how to export and import frameworks: 
https://koha-community.org/manual/18.11/en/html/administration.html#import-export-frameworks

Caroline Cyr La Rose  
Head of Training and Support, inLibro

Le 12 novembre 2018 à 09:06:31, Italo Brasileiro 
(italo.barbosa.brasile...@gmail.com(mailto:italo.barbosa.brasile...@gmail.com)) 
a écrit:

> Hello everyone. In Koha, is it possible to import/export authority MARC
> frameworks? If so, could anyone tell me how? Thanks!
>  
> --
> Ítalo Barbosa Brasileiro
> ___
> 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] Setting of Library Opening Hours for Closed Reserve

[Caroline Cyr-La-Rose]

Hi all,

We use this calendar in production with all our clients and it allows 
the setting of opening hours.


Bug 17015 New Koha Calendar 
<https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17015>


It is currently in "Need Signoff", if you'd like to test it.

Caroline Cyr La Rose, M.L.I.S.
Librarian/ Head of Training and Support

Phone : 1 (833) 465-4276
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
Le 18-12-05 à 05 h 46, Katrin Fischer a écrit :

Hi Peter,

at the moment you can only set closed days in Koha, but not the 
opening hours.


There are some bugs open related to adding this feature. A quick 
search brought up those:


*Bug 8133* 
<https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8133> - 
hourly loans doesn't know when library closed
*Bug 6796* 
<https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6796> - 
Overnight circulation of reference books


Hope this helps,

Katrin

On 04.12.18 05:13, Peter Lau wrote:
I would like to know how to set the library opening hours as we’re 
going to

have closed reserve with hourly loans for our collections.

Thanks & regards,

*Peter Lau*

Librarian

Tel: (852) 3977 9868 | Email: peter@yccece.edu.hk | Fax: (852) 
23384320


  [image:
https://docs.google.com/uc?export=download&id=1wiYZQsqhNTJZjyNbLJx-6ODZyoYE5NNu&revid=0BzpPRj4UE0XeT1R2WUt2dnhmTFBBeEpVR3dqcU5QbnF6NVg4PQ] 



2 Tin Wan Hill Road, Tin Wan, Aberdeen

*YCCECE, Here We Grow Our Future | *www.yccece.edu.hk
___
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

Re: [Koha] Adding pre-defined Manual Invoice Types

[Caroline Cyr-La-Rose]

Hi Admire,

You can add those in the Authorized values section of the Administration 
module.


1) Go to Administration > Authorized values

2) Select the MANUAL_INV category

3) Add your invoice types : Put the description in the Authorized value 
field and the amount in the description field (not intuitive, I know)


Regards,

Caroline Cyr La Rose, M.L.I.S.
Librarian / Head of Training and Support

Phone  : 1 (833) 465-4276
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
Le 18-12-06 à 04 h 53, Mutsikiwa Admire a écrit :

I would like to add pre-defined Manual Invoices Types. For instance,
Miscellaneous -$2,  Cell Phone use - $5; where do I add theses values ?

  


Kind Regards,

  


Admire Mutsikiwa

ICT Projects Manager

Libraries

University of Zimbabwe

   Tel:+263-4-303276

"It is easy to dodge our responsibilities, but we cannot dodge the
consequences of dodging our responsibilities."  Josiah Charles Stamp,
1880-1941, former director of the Bank of England

  


___
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] Tag Cloud tab

[Caroline Cyr-La-Rose]

Hello Peter,

Koha has a tagging function where patrons are able to add tags (or 
keywords) to records in the catalog.


There are several system preferences that control the behaviour of this 
functionality (see Administration > Global system preferences > Enhanced 
content > Tagging) :


 * TagsEnabled (this is the one you want to disable if you want to
   remove the "tag cloud" link on the catalog)
 * TagsExternalDictionary
 * TagsInputOnDetail
 * TagsInputOnList
 * TagsModeration
 * TagsShowOnDetail
 * TagsShowOnList

Best regards,

Caroline


Caroline Cyr La Rose, M.L.I.S.
Librarian / Head of Training and Support

Phone : 1 (833) 465-4276
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com>
Le 18-12-19 à 03 h 51, Peter Lau a écrit :

What is the meaning of Tag Cloud tab, which is next to the Authority Search
tab in Koha?



After clicking the Tag Cloud tab, I can see the following:



Tags to show from other users :



Thanks & regards,

*Peter Lau*

Librarian

Tel: (852) 3977 9868 | Email: peter@yccece.edu.hk | Fax: (852) 23384320

  [image:
https://docs.google.com/uc?export=download&id=1wiYZQsqhNTJZjyNbLJx-6ODZyoYE5NNu&revid=0BzpPRj4UE0XeT1R2WUt2dnhmTFBBeEpVR3dqcU5QbnF6NVg4PQ]

2 Tin Wan Hill Road, Tin Wan, Aberdeen

*YCCECE, Here We Grow Our Future | *www.yccece.edu.hk
___
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] Course Reserve information from customized report

[Caroline Cyr La Rose]

Hi Peter,

Try this

SELECT  
courses.course_number AS "Course code",
courses.course_name AS "Course",
CONCAT(borrowers.surname, ', ', borrowers.firstname, ' (', 
borrowers.cardnumber, ')') AS "Course teacher",
biblio.title AS "Title",  
biblio.author AS "Author",
biblioitems.isbn AS "ISBN",
items.itype AS "Item type",
items.itemcallnumber AS "Item callnumber",
items.barcode AS "Item barcode"
FROM course_items
LEFT JOIN items USING (itemnumber)  
LEFT JOIN biblio USING (biblionumber)  
LEFT JOIN biblioitems USING (biblionumber)
LEFT JOIN course_reserves USING (ci_id)  
LEFT JOIN courses USING (course_id)
LEFT JOIN course_instructors USING (course_id)
LEFT JOIN borrowers USING (borrowernumber)

Adapted from 
https://wiki.koha-community.org/wiki/SQL_Reports_Library#All_course_reserve_items

-- 
Caroline Cyr La Rose, M.L.I.S
Librarian | Product Manager, inLibro

Le 19 janvier 2019 à 01:19:40, Peter Lau (peter@yccece.edu.hk) a écrit:

I would like to draw a list of all items cataloged under Course Reserve
including the Course Code, Course teacher (if input), Bib title, Bib
author, ISBN etc.

I don't know how to draw them easily from the report function.

Thanks and regards,

*Peter Lau*

Librarian

Tel: (852) 3977 9868 | Email: peter@yccece.edu.hk
 | Fax: (852) 23384320



2 Tin Wan Hill Road, Tin Wan, Aberdeen

*YCCECE, Here We Grow Our Future | *www.yccece.edu.hk
___
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] Removing items + biblio records

[Caroline Cyr-La-Rose]

Hi Joel,

In the batch item delete tool, you can specify to delete the record if 
there are no more items attached to it. This only applies to the records 
for the items you are deleting, so it won't affect you digital materials 
records.


Caroline

Le 19-01-23 à 10 h 42, vinod mishra a écrit :

When we delete an item, what happens to the bibliographic record? Is it
removed, too? Is the tool smart enough to only remove the record after the
last item is removed?

Yes its smart😊

On Wed, 23 Jan 2019 20:54 Coehoorn, Joel,  wrote:


We're removing a large amount of material from our holdings to make room
for an upcoming renovation, and I have a question about how the batch item
deletion tool works.

When we delete an item, what happens to the bibliographic record? Is it
removed, too? Is the tool smart enough to only remove the record after the
last item is removed?

We don't want to leave bibliographic records behind for stuff that is no
longer in the library. At the same time, we also have a large number of
"empty" bibliographic records in koha related to licensed digital
materials, and we can't just automatically clean out any biblio without an
item record.


Joel Coehoorn
Director of Information Technology
402.363.5603
*jcoeho...@york.edu *

*Please contact helpd...@york.edu  for technical
assistance.*


The mission of York College is to transform lives through
Christ-centered education and to equip students for lifelong service to
God, family, and society
___
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


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Head of Training and Support

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] Help with SQL report

[Caroline Cyr-La-Rose]

Hi Christopher,

Do you use the acquisitions module? If not, what MARC field is your 
vendor information in?


If you use the acquisitions module, you can try this

SELECT
    biblionumber AS ""
FROM
    aqorders
LEFT JOIN aqbasket USING (basketno)
LEFT JOIN aqbooksellers ON (aqbasket.booksellerid=aqbooksellers.id)
WHERE aqbooksellers.name LIKE <>

If your vendor information is in a MARC field, you need to change the 
table biblioitems in the FROM and JOIN sections to biblio_metadata (as 
well as changing the marcxml to metadata). Your query should look like


SELECT CONCAT('href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\">',biblio.biblionumber,'') 
AS biblionumber, biblio.title, biblio.author

FROM biblio_metadata
JOIN biblio ON (biblio_metadata.biblionumber = biblio.biblionumber)
WHERE ExtractValue(metadata, "//datafield[@tag=<< Field 
(XXX)>>]/subfield[@code=<>]")

LIKE <>

Finally, if you only need a list of biblionumbers for batch delete, you 
can remove the superfluous information in the SELECT section :


SELECT biblio.biblionumber AS ""
FROM biblio_metadata
JOIN biblio ON (biblio_metadata.biblionumber = biblio.biblionumber)
WHERE ExtractValue(metadata, "//datafield[@tag=<< Field 
(XXX)>>]/subfield[@code=<>]")

LIKE <>

N.B. When I want a list for batch modification/delete, I always put 
SELECT biblionumber AS "". That way, you don't have the pesky error 
message saying Koha didn't find the biblionumber "biblionumber"...


Good luck!

Caroline Cyr La Rose, M.L.I.S.
Product Manager, inLibro

Le 19-01-24 à 16 h 58, Christopher Davis a écrit :

Greetings Colleagues,

I have been attempting to use the "Biblios with like data in a 
subfield of a field" report which is found within the Koha reports 
library at 
https://wiki.koha-community.org/wiki/SQL_Reports_Library#Biblios_with_like_data_in_a_subfield_of_a_field; 
however, no matter what values I input into the report dialog boxes, I 
still get a long list of my system's complete holdings instead of a 
much shorter list of records from a certain vendor. I did notice that 
I needed to change the "marcxml" on line four of the SQL code to 
"metadata" or else the report failed to run. What am I doing wrong?


I am just trying to get a list of bibliographic records from a certain 
vendor so that I can then feed the record numbers into the Batch 
Record Deletion tool. Maybe there's a better report to use than this one?


Many thanks,
*
*
*Christopher Davis, MLS*
Systems & E-Services Librarian
Uintah County Library
204 E 100 N
Vernal, UT 84078
phone: (435) 789-0091 ext. 261 
email: cgda...@uintah.utah.gov <mailto:cgda...@uintah.utah.gov>
web: uintahlibrary.org <https://uintahlibrary.org>
catalog: basinlibraries.org <https://basinlibraries.org>
facebook.com/uintahcountylibrary 
<https://facebook.com/uintahcountylibrary>
instagram.com/uintahcountylibrary 
<https://instagram.com/uintahcountylibrary>

___
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] How to receive reports to email

[Caroline Cyr-La-Rose]

There is already the runreport.pl cronjob that can do this.

https://koha-community.org/manual/18.11/en/html/cron_jobs.html#run-report

Le 19-02-15 à 10 h 28, Alvaro Cornejo a écrit :

Hi Satish

Always CC koha list so you can have more feedbacks  and others can profit
from discussion.

You can start with the example Paul provided. I don't know perl but seems
complete; however you need to define/create your query. If you don't know
perl, you can use any language you know.

You can place it in any where you want -you must add-its path to the cron
line-. Koha have a cgi-script folder you might want to use or create one
for your specific scripts. It must also have the permissions required for
it to be run by your cron and access your database.

As Paul said, once you have your script ready you need to add a line in
your daily cron for it to execute.

Regards,

Alvaro
|-|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
y GPRS online
   Visitenos en www.perusms.com


Le ven. 15 févr. 2019 à 01:16, SATISH  a écrit :


Hi Alvaro,

Thank you for your email, could you please do little elaborate on how to
write a script or could share some
example script. Where this script should be placed (path) and permissions.

Tks.
Satish

On Thu, 14 Feb 2019 at 19:03, Alvaro Cornejo 
wrote:


Hi

If already have an report for this, you can define it as public and
create a small script -in the language of your choice- that runs it and
insert an entry in cron jobs.

You can even create the whole report in your script accessing directly to
your database.

Regards,

Alvaro



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


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] OPAC research does not work

[Caroline Cyr-La-Rose]

Hi David,

I didn't notice if someone already answered you.

You need to build your search indexes before being able to find anything 
in the OPAC.


Do you have access to your server?

If you use Zebra (you probably do, but just to make sure, check the 
system preference SearchEngine in Administration > Global system 
preferences), you need to run the script rebuild_zebra.pl on your 
server. The script has the following arguments :


-b to index bibliographic record

-a to index authority records

-r to reset your indexes (this will erase everything and rebuild from zero)

-v for verbose

-z to rebuild only what was changed since the last indexing

So for a first run, I would do ./rebuild_zebra.pl -a -b -r -v

Then you need to add rebuild_zebra in your crontab so that it runs 
regularly (on our servers we run it every minute) . In the crontab, you 
need to use the -a -b and -z arguments.


I hope that makes sense. :)

Good luck!

Caroline

Caroline Cyr La Rose, M.L.I.S.
Product Manager, inLibro

Le 19-02-22 à 12 h 21, Davide Spanu a écrit :

Hello,
I'm having problems configuring Koha. I've uselessly tried solving the issue on 
my own and also browsing forums. After the install I started cataloging, 
inserting titles and texts. However once inserted for some reason they don't 
appear in the OPAC. I can't figure out what I'm doing wrong and need assistance.
Thank you in advance

___
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] how to index a Journal/ PERIODICAL

[Caroline Cyr La Rose]

Hi Nalisha,

I think the functionality you need is Analytical records. You can use the 
EasyAnalyticalRecords system preference to make it easier.

1. Activate that system preference
2. Create a record for your journal
3. Optional : In serials, create a subscription for the journal and receive 
items
4. If you skip step three, you must create items in your record
5. In the record, click on « New » and choose « Analyze items » 
6. This will guide you to create a new record for the article, that will be 
linked to an issue of the journal

I hope this helps you. 

Anyone feel free to correct me if I made a mistake...

-- 
Caroline Cyr La Rose
Librarian | Product Manager
inLibro

Le 3 avril 2019 à 01:53:05, Nalisha Tamang (n...@ptsindia.com) a écrit:

Dear all,
Would you please help me to index a Journal with its articles manually..
Apart from the computer we have to maintain an index file for journals.
Thanks in advance
___
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] How to enable books cover on staff client interface

[Caroline Cyr La Rose]

Hi Yatheesh,

Did you look at the following system preferences?

- AmazonCoverImages
- LocalCoverImages  

-- 
Caroline Cyr La Rose
Librarian | Product Manager
inLibro

Le 3 avril 2019 à 10:05:05, Yatheesh lis (yathee...@gmail.com) a écrit:

Dear all

How to enable books cover on staff client interface koha 18.5
___
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] How to enable books cover on staff client interface

[Caroline Cyr-La-Rose]

I think there is no way to enable Google Jackets in the staff client...

You should file a bug in bugzilla : 
https://bugs.koha-community.org/bugzilla3/


On 2019-04-03 2:35 p.m., vinod mishra wrote:

Hi

Can you let us know the purpose and benefits of doing this?

On Wed, 3 Apr 2019 19:35 Yatheesh lis,  wrote:


Dear all

How to enable books cover on staff client interface koha 18.5
___
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

Re: [Koha] Problematic barcode behavior...

[Caroline Cyr-La-Rose]

Hi Allen,

The plugin looks for the biggest number in the database and adds 1. 
There is probably somewhere in your database a barcode that was added 
manually and doesn't match your regular barcodes.


You can check the barcodes in your database by going into Reports, 
Create from SQL and paste the following query :


SELECT barcode FROM items ORDER BY barcode DESC LIMIT 10

This will show you the 10 "largest" barcode numbers from your database.

Good luck!

Caroline

Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager
inLibro

On 19-04-03 18 h 35, abraz...@buttepubliclibrary.info wrote:
We have always generated barcodes from within Koha and when we are 
adding items to the catalog, with the plugin (barcode.pl) for the 
barcode field (952$p), it is no longer populating with the desired 
barcode. It used to work fine set as "generating in the form 1,2,3".  
Now, it populates the field with a barcode that we do not want to use.


Note, if we do assign that reoccurring problem barcode (x) to an item, 
the next barcode generated is the next consecutive problem barcode 
(x+1). The behavior of the plugin works fine. But, if I manually 
assign the right barcode to an initial item (y), the next barcode that 
is auto-generated is not (y+1), but is back to the problem barcode (x).



Any ideas out there?

Allen
___
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] double fines

[Caroline Cyr-La-Rose]

I've noticed this in the past too. I always tell administrators to 
choose EITHER


 * finesMode set to "Calculate and charge", with fines.pl set to run
   nightly, OR
 * CalculateFinesOnReturn set to "Do"

Both turned on always gave me trouble. I thought it was meant to be a 
choice between calculating fines nightly with the cron or calculate on 
return.


Caroline


On 19-04-14 22 h 02, vikram zadgaonkar wrote:

Hi,
I am also facing same problem. I have enabled calculate fine on return.


On Mon 15 Apr, 2019, 12:10 AM Katrin Fischer, 
wrote:


Hi Margo,

I am not aware of any known bugs that fit your description. :(

Maybe it could help to see the 2 lines in accountlines (F and FU) and
compare these.

Do you have |CalculateFinesOnReturn enabled?|

|Katrin
|


On 10.04.19 20:01, Margo Duncan wrote:

Good afternoon,

Recently we have some patrons that are being double charged fines.  It

looks like when the item is turned in, the accruing fine (FU) remains and a
fine (F) for the same amount is added as a second line. It doesn't appear
to be happening to all patrons and I cannot determine a pattern.

We are on version 18.11.02.

Has anyone had this problem?  Or any suggestions where to start looking?
Thank you!
Margo

Margo Duncan, MLS
Head of Library Systems
Robert R. Muntz Library
The University of Texas at Tyler
903.566.7174 | mdun...@uttyler.edu<mailto:mdun...@uttyler.edu>

___
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
--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com 
<mailto:caroline.cyr-la-r...@inlibro.com>


INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] Edit Sort 1 & Sort 2 fields in Patron record

[Caroline Cyr-La-Rose]

Hi Peter,

I'm not sure if somebody answered you.

You can change the values in Administration - Authorized values, and the 
categories are Bsort1 and Bsort2.


Click on "New authorized value for BsortX" to add a value.

Regards,

Caroline

--

Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>



On 19-04-26 03 h 09, Peter Lau wrote:

I would like to know how to modify the list of permissible values in Sort 1
& Sort 2 in patron records.

Thanks & regards,

*Peter Lau*

Librarian

Tel: (852) 3977 9868 | Email: peter@yccece.edu.hk | Fax: (852) 23384320

  [image:
https://docs.google.com/uc?export=download&id=1wiYZQsqhNTJZjyNbLJx-6ODZyoYE5NNu&revid=0BzpPRj4UE0XeT1R2WUt2dnhmTFBBeEpVR3dqcU5QbnF6NVg4PQ]

*YCCECE, Here We Grow Our Future | *www.yccece.edu.hk

2 Tin Wan Hill Road, Tin Wan, Aberdeen

*YCCECE is a member of YCEF, and both are registered non-profits in Hong
Kong*
___
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] Why people' are using the term Koha as KOHA?

[Caroline Cyr-La-Rose]

Fred! Your emails always bring sunshine in my days!

Any chance we'll get poetry soon?

Caroline

On 19-05-02 12 h 39, King, Fred wrote:

And it's a WONDERFUL ILS! Its existence should be PROCLAIMED FROM EVERY 
ROOFTOP! 😊

Anybody else going to the Medical Library Association conference in Chicago 
tomorrow/next week? E-mail me and maybe we can get together for tea.

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

I like a teacher who gives you something to take home to think about besides 
homework.
--Lily Tomlin (attrib.)

-Original Message-
From: Koha  On Behalf Of Michael Kuhn
Sent: Thursday, May 02, 2019 12:34 PM
To: koha@lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] Why people' are using the term Koha as KOHA?

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

  > Why people' are using the term Koha as KOHA?
  > It is a simple word, not any acronym.

Some people like majuscules. Some people are just wrong. Some don't even care.

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 
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.adminkuhn.ch&d=DwIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=gFWkGD8xY8R9hbjs06JWYXFVMxiIZ1sYXDwJoh25aa4&s=tVCwhViIJAyiWUmVk6DWilg5lFWsk_J3HC_j0oR0pWw&e=
___
Koha mailing list  
https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.org&d=DwIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=gFWkGD8xY8R9hbjs06JWYXFVMxiIZ1sYXDwJoh25aa4&s=-eD-fXQ-fcd54QvLdtUGMF7HDH2W0GbTIcfFMH2_Qrw&e=
Koha@lists.katipo.co.nz
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.nz_mailman_listinfo_koha&d=DwIGaQ&c=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M&r=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI&m=gFWkGD8xY8R9hbjs06JWYXFVMxiIZ1sYXDwJoh25aa4&s=p2hCbi4aUXmBdbeToWl7SccaMfR-59GqKO0a6z9m55g&e=

--
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, orthopaedics, cancer and GI.

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

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


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


--
Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] On shelf holds

[Caroline Cyr-La-Rose]

Hi Chris,

That is exactly what it means. :)

Caroline

On 19-05-06 04 h 06, Chris Brown wrote:

Hello,

I have a really dumb question: what is meant by an "on-shelf hold"?

I take it to mean placing a hold on a book that is actually in the library
rather than checked out to a patron. Is that right?

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


--
Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

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

[Koha] Education meeting date poll

[Caroline Cyr-La-Rose]

Hello everyone!

During this morning's General meeting 
(https://wiki.koha-community.org/wiki/General_IRC_meeting_5_June_2019), 
a meeting for educators/trainers to exchange ideas, best practices, 
materials and other experiences was proposed. This meeting would be for 
all community members who have a hand in training new Koha users, or in 
continuing education for current Koha users, and who are interested in 
sharing experiences with colleagues. (Note that this is not a training 
meeting, but a meeting for educators.) If you would like to attend the 
very first meeting, please fill in the date poll available here : 
https://framadate.org/Y2p9c5PVIXuOP8Kg


The meeting will be held by video conference. So far, NEKLS and ByWater 
Solutions have both offered to host the first meeting using Zoom. George 
and Donna, can you insert your room's availability as a "person" in the 
poll? I will make sure one of the rooms can attend when deciding the date :)


The poll closes on June 12. So answer as soon as possible. I will send 
the details and agenda on the list when a date is picked.


Thank you everyone!

--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

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

[Koha] Education meeting date

[Caroline Cyr-La-Rose]

Hello everyone!

The education meeting will take place on June 27, at 14 UTC (I apologize 
to our colleagues in Oceania). Donna, can you reserve the zoom room on 
that date and send us the link?


Here is a preliminary agenda, let me know if there is anything you want 
to add.


1. Presentation
2. Collaboration for training, propositions
 * Wiki?
 * Mailing list?
 * other means?
 * Are there things that we can share? Or things we should develop
   as a community?
3. Best practices
 * If anyone wants to share one thing that they do that works
   wonderfully, go ahead :)

Thank you everyone!

Caroline


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

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

[Koha] Education meeting

[Caroline Cyr-La-Rose]

Hello everyone!

Just a quick reminder that the community education meeting is taking 
place THIS Thursday, June 27, at 14 UTC.


ByWater Solutions offered their Zoom room so that we can all meet. Click 
on this link to access it: https://zoom.us/j/545232903 You can try it in 
advance to make sure it works for you.


Here is the agenda again. And again, I invite you to email me or the 
list if you want to add points to it. :)


1. Presentation
2. Collaboration for training, propositions
 * Wiki?
 * Mailing list?
 * other means?
 * Are there things that we can share? Or things we should develop
   as a community?
3. Best practices
 * If anyone wants to share one thing that they do that works
   wonderfully, go ahead :)

See you then!

Caroline

--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

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

[Koha] Education: Koha education meeting highlights and recording

[Caroline Cyr-La-Rose]

Hello everyone!

The first community education meeting took place earlier today. There 
were a dozen in attendance and we had a great chat.


For those who couldn't make it, and for the curious, here is the 
recording 
https://drive.google.com/file/d/147jzhaEZJdsNsFFxXzb8SUvGj1T5ulRP/view 
there is also the transcript of the chat 
https://drive.google.com/open?id=1xb8TjtrDaIdZPrVUekueqzRYz4StLip8


Thanks again to ByWater Solutions who hosted the meeting.

Here are some highlights from the meeting:

 * We created a wiki page to share our training material
   https://wiki.koha-community.org/wiki/Training_resources
 o Feel free to add to this wiki page, I already started with some
   resources that were shared during the meeting
 o If you add something, make sure to write the version of Koha it
   applies to. This is just to keep it the most up-to-date possible.
 * We also created a wiki page for how-to's or "step by step"'s
   https://wiki.koha-community.org/wiki/How-to
 o These will live along side the manual for people who need more
   structured instructions on how to do things in Koha
 o It's easier to edit than the manual, so more people can contribute
 o There is still the need to find a way to translate these if they
   are to be included in the manual eventually
 * We decided against creating a new mailing list for education and
   training as most of us are already swamped in emails and subscribed
   to too many listservs
 o We will use the regular Koha mailing list
 o However, it was suggested that we add "Education: " before the
   subject of the email. That way those of us who are interested in
   this topic will know to read those emails, and those of us who
   aren't interested in education/training can disregard the email
   or even create a rule in their email client to delete them
   automatically
 * Eventually, there will be example MARC records for all types of
   materials to help us with non-librarian library staff who do
   cataloging.
 * We also shared some best practices
 o We all loved koha-US' learning page, which organizes the
   community information in a more visual manner
   https://koha-us.org/learn-from-koha-us/
 o ByWater do a "policy call" before the training to understand the
   library's setting and needs. This also helps with configuration.
   They have a survey that they use with that call to collect hard
   data from their clients for the configuration of Koha
 o Most support companies do the training on a test environment
   with the library's own data. This is kept until go-live so staff
   can practice. Some keep the test environment after go-live for
   tests, practice and training new staff.
 o ByWater tries to cater to all learning styles by giving the same
   information in different ways (videos, step-by-steps, in person
   training, etc.)

I think that covers everything. For those who were there, don't hesitate 
to respond if you think I forgot anything.


Next meeting will take place on November 19 at 19 UTC. It will still be 
hosted by ByWater and this is the link to access it 
https://zoom.us/j/392843340


Thank you everyone!

Caroline

--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] Koha Not calculating and charging overdue fines

[Caroline Cyr-La-Rose]

Hello,

I need more information about your problem.

Is the fines.pl cron job running?

Is this a new Koha installation or did it stop calculating fines after 
an upgrade? Which version are your running?


Which system preferences did you set and what was their value?

Thanks!

Caroline

On 19-07-31 06 h 35, muirunyeri wrote:

Dear team,
My system is not charging nor calculating overdue fines.
I have set the circulation preferences as they should.
Kindly assist

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


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] Koha Not calculating and charging overdue fines

[Caroline Cyr-La-Rose]

Hello!

I'm not a system administrator, so I'm not sure what I do will work for 
you. Maybe someone else on the list can correct me if this is not the 
right way to do it.


What I do to check my crons is go on my server and type crontab -l  
(dash small "L" for "list"). This gives me the list of all the crons 
that are running on my server.


If the fines.pl script is not there, you will have to add it. So type 
crontab -e (dash small "E" for "edit").


On the next available line, add in your cron. This is what I use to 
remember the order : https://devhints.io/cron


Normally, you want your fines.pl script to run once daily. We run ours 
during the night. So something like


0 1 * * * misc/cronjobs/fines.pl

will make the script run everyday at 1 am

I hope this helps

Caroline

On 19-08-01 04 h 53, muirunyeri wrote:

Hi Carolyne,

I'm not sure if the fines.pl cron job is running. If you could guide 
me on how to check I'd be very grateful.


The system is new and has been in use for about 6 months and not an 
upgrade but a clean install.


The circulation system pref are set as
1. Checkin policy- calculate fines on return= Do
2. Fines policy- fines mode= calculate and charge.

Thanking you for your assistance

Warm regards



Sent from my Samsung Galaxy smartphone.
---- Original message 
From: Caroline Cyr-La-Rose 
Date: 31/07/2019 16:29 (GMT+03:00)
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Koha Not calculating and charging overdue fines

Hello,

I need more information about your problem.

Is the fines.pl cron job running?

Is this a new Koha installation or did it stop calculating fines after
an upgrade? Which version are your running?

Which system preferences did you set and what was their value?

Thanks!

Caroline

On 19-07-31 06 h 35, muirunyeri wrote:
> Dear team,
> My system is not charging nor calculating overdue fines.
> I have set the circulation preferences as they should.
> Kindly assist
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com
<http://www.inLibro.com>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] Koha Not calculating and charging overdue fines

[Caroline Cyr-La-Rose]

Hi,

You have to use the "root" account I think.

I know when I try to do it with my own account, it says I have no 
crontab, but when I switch to the root account, they are all there.


Caroline

On 19-08-06 05 h 26, muirunyeri wrote:

Hello Carolyne,

Sorry I have not gotten back to you on this issue.

I think this' where my solution lies however the cron -l command 
replies no cron command for my user account. I have 2 accounts showing 
i.e. the admin account and the koha_instance account.


I hope i was supposed to run it thru the main account coz thats where 
I log in.


Or what might I be doing wrong? I believe the cron list should have 
something. Please advise.


Thanking you heartily



Sent from my Samsung Galaxy smartphone.
 Original message 
From: Caroline Cyr-La-Rose 
Date: 01/08/2019 17:32 (GMT+03:00)
To: muirunyeri , koha@lists.katipo.co.nz
Subject: Re: [Koha] Koha Not calculating and charging overdue fines

Hello!

I'm not a system administrator, so I'm not sure what I do will work 
for you. Maybe someone else on the list can correct me if this is not 
the right way to do it.


What I do to check my crons is go on my server and type crontab -l  
(dash small "L" for "list"). This gives me the list of all the crons 
that are running on my server.


If the fines.pl script is not there, you will have to add it. So type 
crontab -e (dash small "E" for "edit").


On the next available line, add in your cron. This is what I use to 
remember the order : https://devhints.io/cron


Normally, you want your fines.pl script to run once daily. We run ours 
during the night. So something like


0 1 * * * misc/cronjobs/fines.pl

will make the script run everyday at 1 am

I hope this helps

Caroline

On 19-08-01 04 h 53, muirunyeri wrote:

Hi Carolyne,

I'm not sure if the fines.pl cron job is running. If you could guide 
me on how to check I'd be very grateful.


The system is new and has been in use for about 6 months and not an 
upgrade but a clean install.


The circulation system pref are set as
1. Checkin policy- calculate fines on return= Do
2. Fines policy- fines mode= calculate and charge.

Thanking you for your assistance

Warm regards



Sent from my Samsung Galaxy smartphone.
 Original message 
From: Caroline Cyr-La-Rose 
Date: 31/07/2019 16:29 (GMT+03:00)
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Koha Not calculating and charging overdue fines

Hello,

I need more information about your problem.

Is the fines.pl cron job running?

Is this a new Koha installation or did it stop calculating fines after
an upgrade? Which version are your running?

Which system preferences did you set and what was their value?

Thanks!

Caroline

On 19-07-31 06 h 35, muirunyeri wrote:
> Dear team,
> My system is not charging nor calculating overdue fines.
> I have set the circulation preferences as they should.
> Kindly assist
>
> ___
> Koha mailing list http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha

--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com 
<mailto:caroline.cyr-la-r...@inlibro.com>


INLiBRO | Document Technologies Specialists | www.inLibro.com
<http://www.inLibro.com>
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com 
<mailto:caroline.cyr-la-r...@inlibro.com>


INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>


--
Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] Groups of schools using Koha

[Caroline Cyr-La-Rose]

Hi Katryn,

They are not schools, so I don't know if this is relevant, but we have 
two projects where independent organizations share one Koha 
installation. We also support schools using Koha, but they are either 
school councils (where they share one Koha for the council) or private 
schools (where they each have their own Koha), not independent schools 
using the same Koha.


We offer something like this for very small municipalities (population 
under 5000). We had to do some development, especially around system 
preferences, because there are some things that I consider to be 
policies that can be specific for each library (like maxfine, 
noissuescharge, etc.). We also blocked the more "advanced" Koha modules 
(Serials, Acquisitions, Administration, etc.). They each have their own 
OPAC and the patrons can only search their library's collection. In the 
Intranet, library staff and volunteers can see the other libraries' 
collections. This helps for cataloguing. They do not however have access 
to the other libraries' patrons, of course.


We have two libraries running in production on this system and another 
one will be added in September.


We also have a Koha installation that is shared by two (soon to be three 
also) genealogy societies. In this case, they also each have their own 
OPAC, but the patrons can see the other collections. This is something 
they agreed on at the beginning of the project. These institutions do 
not loan out materials, so the need for specific sysprefs, and hiding 
patron information form one another was not necessary.


Regards,

Caroline

On 19-08-14 18 h 06, Kathryn Tyree wrote:

Hi everyone,

I hope you're having a good week so far.

I would love to hear about any examples where multiple schools share a Koha 
instance or some other arrangement to work together using Koha. Many thanks to 
anyone that could take a moment to share
their example.

Best wishes,
Kathryn


Kathryn Tyree // Project and Account Manager - Libraries
Catalyst IT  Limited

DDI // +64 4 803 2414
kath...@catalyst.net.nz


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


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] Error when adding new authorities record

[Caroline Cyr-La-Rose]

Hi Keith,

Did you try entering something in 150$a? That is the field that is 
copied in the bibliographic record.


Caroline

On 19-08-21 04 h 09, ksorbo wrote:

Using Koha 17.11, Ubuntu 16

I am getting an error when I attempt to add a new authorities record:

1. On the biblio cataloging page, click the button next to 650 a tag to add
a topical subject tracing
2. Pops up search for authority, nothing found
3. Click create authority
4. On authorities record, fixed length 001 003 005 008, autopopulate
5. Enter new term in 450 a - Click save.
6. It asks if this is  a duplicate (the term shown in the duplicate message
is completely different than the one being added)
7. Click No Save as New Authority
Error:
*Can't call method "subfields" on an undefined value at
/usr/share/koha/intranet/cgi-bin/authorities/blinddetail-biblio-search.pl
line 86.*

Am I getting this error because I am failing to enter something I should be
entering in the new authorities record?



--
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


--
Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] Report help needed - lost items

[Caroline Cyr-La-Rose]

Hello Elaine,

from what I understand, you want bibliographic information on lost items?

I'd need to know exactly the purpose of the report to help you more as 
there are things in there I don't understand (like why select barcode, 
when afterwards you group by biblionumber, or why the title is there twice).


First, instead of selecting from the biblio table, I would go the other 
way and select from the items table. That way, you are sure of getting 
only things that have an item.


If you want to limit by itemtype, you can add WHERE itype = <type|itemtypes>> in your query to have the ability to choose your 
itemtype upon executing your report.


I cleaned your query up a little bit, but like I mentioned before, as I 
don't know the purpose, it might not be what you need.


SELECT
CONCAT(
'',
title,
''
) AS Title,
biblionumber,
barcode,
ccode,
onloan AS 'Checkout date'
FROM
items
JOIN biblio USING (biblionumber)
WHERE itemlost != 0
  AND itype = <>

Let us know if this works.
Caroline


On 19-08-23 15 h 00, Mark Alexander wrote:

Excerpts from Elaine Bradtke's message of 2019-08-23 11:32:44 -0700:

I've got the following adapted from one in the reports library.  But I need
to limit it by item type, or not return everything that doesn't have an
item record attached. We've got lots of components in our catalogue that
don't have items and it's returning all of them:

SELECT
 CONCAT(
 '',
 bib.title,
 ''
 ) AS Title,
 bib.title,
 bib.biblionumber,
 lostitems.barcode,
 lostitems.ccode,
 lostitems.onloan AS 'Checkout date'
FROM
 biblio bib
 LEFT JOIN items ON (bib.biblionumber = items.biblionumber AND
items.itemlost = 0)
 LEFT JOIN items AS lostitems ON (bib.biblionumber =
lostitems.biblionumber AND lostitems.itemlost != 0)
GROUP BY bib.biblionumber
HAVING count(items.itemnumber) = 0

While I'm not an SQL expert by any means, I think I was able to get
this to work on my catalog by removing the HAVING clause and
putting "WHERE items.itemnumber IS NULL" before the GROUP clause:

SELECT
 CONCAT(
 '',
 bib.title,
 ''
 ) AS Title,
 bib.title,
 bib.biblionumber,
 lostitems.barcode,
 lostitems.ccode,
 lostitems.onloan AS 'Checkout date'
FROM
 biblio bib
 LEFT JOIN items ON (bib.biblionumber = items.biblionumber AND
items.itemlost = 0)
 LEFT JOIN items AS lostitems ON (bib.biblionumber =
lostitems.biblionumber AND lostitems.itemlost != 0)
WHERE items.itemnumber IS NULL
GROUP BY bib.biblionumber
___________
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


--
Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] Wordpress "Search this site/Search our catalog" code

[Caroline Cyr-La-Rose]

This is what we have. It's a simple bit of html that is used on the page 
where you want the search box to be.


You have to change opacbaseurl for your own. Let me know if it works :)



action="https://opacbaseurl/cgi-bin/koha/opac-search.pl"; id="searchform">

    
    
    Keyword
    Title
    Author
    Subject
    ISBN
    Series
    Call number
    
    


On 19-08-30 09 h 02, Owen Leonard wrote:

Does anyone have any code for creating a single search box on a Word
Press site that can switch between "Search our website" and "Search our
catalog?"

This is what we have in our modified Wordpress template
(https://www.myacpl.org/):

https://gitlab.com/snippets/1890638

The 

Re: [Koha] Uploaded file "not found" in staff client

[Caroline Cyr-La-Rose]

Hi Michael,

are the OPACBaseURL and StaffClientBaseURL configured correctly? If yes, 
what is the URL of the "not found" page?


Caroline

On 19-09-05 10 h 53, Michael Kuhn wrote:

Hi

We configured Koha to upload files, e. g. a PDF file is uploaded onto 
thehost running Koha via MARC field 856 $u: first selected, then 
uploaded, then chosen, so field 856 $u is filled with the following:


/cgi-bin/koha/opac-retrieve-file.pl?id=5228ccd12bb0d5f002c804effe0680fe

The PDF file then is visible in table "uploaded_files" as well as in 
directory "/var/lib/koha//uploads/koha_upload". In the 
OPAC when clicking on link "Click here to access online" the file is 
showing up all right.


When clicking the respective link in the staff client, instead of the 
file there appears a white screen saying "not found".


We have tested this in Koha 18.11 and 19.05. Is there something more 
to configure or is this maybe a bug?


Best wishes: Michael


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

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

[Koha] Lost item refund

[Caroline Cyr-La-Rose]

Hello everyone,

My questions are for libraries who use the refund feature for returned 
lost items. Do you actually reimburse the money to the patron? If so, 
how do you enter that in Koha?


Several libraries have brought this problem to me, and I can't figure 
out how to make it work in Koha.


Here's what I've got right now :

1. (A very honest) User comes to the circ desk, and says they lost an item

2. I go to the item record and declare it lost

3. The replacement fee and processing fee are added to the patron's account

4. Later, the patron comes back with the item (they found it under the 
car seat, even though they swore they looked there before)


5. I "check in" the item

6. The replacement fee is credited to the user's account

7. I take the money from the cash register and give it back to them

This is where I'm stumped. How do I tell Koha that this money is no 
longer in the cash register AND that this patron DOES NOT have a credit?


I tried creating a manual invoice. This puts the balance at 0, but it 
says the user owes money, which is not true.


Note that our libraries are still using 18.05. We haven't migrated them 
to 19.05 yet. I know the ability to use credits to pay for charges was 
added in 18.11. But I'm not even sure it answers their needs exactly...


If you could share your procedures, I would be very grateful!

Thank you!

Caroline


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] Lost item refund

[Caroline Cyr-La-Rose]

Hi Andreas!

Thanks for spotting that. Yes, the user has paid the item at step 3. :) 
This is the crux of the problem.


Caroline

On 19-10-04 03 h 20, Andreas Hedström Mace wrote:

Hi Caroline!

Is there a step missing from your list? Are the fees added to the account in 
step 3 actually paid by the patron? Otherwise I do not understand why any money 
would be given back to the patron... (and the credit should apply to the fees 
automatically, right? unless they have already been paid for.)

Best regards,
Andreas Mace
Stockholm University Library

-Ursprungligt meddelande-
Från: Koha  För Caroline Cyr-La-Rose
Skickat: den 1 oktober 2019 18:52
Till: Koha mailing list 
Ämne: [Koha] Lost item refund

Hello everyone,

My questions are for libraries who use the refund feature for returned lost 
items. Do you actually reimburse the money to the patron? If so, how do you 
enter that in Koha?

Several libraries have brought this problem to me, and I can't figure out how 
to make it work in Koha.

Here's what I've got right now :

1. (A very honest) User comes to the circ desk, and says they lost an item

2. I go to the item record and declare it lost

3. The replacement fee and processing fee are added to the patron's account

4. Later, the patron comes back with the item (they found it under the car 
seat, even though they swore they looked there before)

5. I "check in" the item

6. The replacement fee is credited to the user's account

7. I take the money from the cash register and give it back to them

This is where I'm stumped. How do I tell Koha that this money is no longer in 
the cash register AND that this patron DOES NOT have a credit?

I tried creating a manual invoice. This puts the balance at 0, but it says the 
user owes money, which is not true.

Note that our libraries are still using 18.05. We haven't migrated them to 
19.05 yet. I know the ability to use credits to pay for charges was added in 
18.11. But I'm not even sure it answers their needs exactly...

If you could share your procedures, I would be very grateful!

Thank you!

Caroline


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com> ___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha


--
Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] Holds issue after recent upgrade

[Caroline Cyr-La-Rose]

Hi Steve,

To me, it looks like the item doesn't have a not for loan status. My 
first instinct would be to look in the database to make sure the 
items.notforloan field contains something and that that something is in 
fact in the authorised_values table.


Hope this helps...

Caroline

On 19-10-22 14 h 25, Steve Nickerson wrote:

After recently upgrading to the packaged version of 19.05.04.000 on Debian,
we can no longer cancel any holds.   We get the following Software error in
the Staff client:

Can't call method "notforloan" on an undefined value at
/usr/share/koha/lib/C4/Reserves.pm line 1171.

  


Any ideas?

  


Thanks!

Steve

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


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

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

[Koha] Education: Meeting next week!

[Caroline Cyr-La-Rose]

Hello everyone!

Just a quick reminder that trainers, educators and curious community 
members are invited to an Education meeting to discuss training 
strategies for Koha.


The Zoom room is provided by Bywater Solutions : https://zoom.us/j/392843340

Agenda:

1. Review of resources created for the community

* Wiki page: https://wiki.koha-community.org/wiki/Training_resources

* How-to's: https://wiki.koha-community.org/wiki/How-to

2. Review of Documentation Plan 
(https://wiki.koha-community.org/wiki/Documentation_-_Plan) and how the 
education community can participate


3. Free discussion of best practices and tips

See you then!

Caroline

--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] Education: Meeting next week!

[Caroline Cyr-La-Rose]

The meeting is on Tuesday, November 19 at 19 UTC (2pm EST).

I apologize for the omission! Thanks Jonathan for pointing it out to me!

Caroline

On 19-11-12 09 h 30, Caroline Cyr-La-Rose wrote:

Hello everyone!

Just a quick reminder that trainers, educators and curious community 
members are invited to an Education meeting to discuss training 
strategies for Koha.


The Zoom room is provided by Bywater Solutions : 
https://zoom.us/j/392843340


Agenda:

1. Review of resources created for the community

* Wiki page: https://wiki.koha-community.org/wiki/Training_resources

* How-to's: https://wiki.koha-community.org/wiki/How-to

2. Review of Documentation Plan 
(https://wiki.koha-community.org/wiki/Documentation_-_Plan) and how 
the education community can participate


3. Free discussion of best practices and tips

See you then!

Caroline



--
Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] Education: Meeting next week!

[Caroline Cyr-La-Rose]

The original email said 19UTC. Because of the daylight saving time 
change, it's 2pm EST.


On 19-11-12 09 h 46, Kelly McElligott wrote:

Thanks, Caroline!
This meeting is scheduled for Tuesday, November 19th at 3pm ET.

Kelly

On Tue, Nov 12, 2019 at 9:30 AM Caroline Cyr-La-Rose 
<mailto:caroline.cyr-la-r...@inlibro.com>> wrote:


Hello everyone!

Just a quick reminder that trainers, educators and curious community
members are invited to an Education meeting to discuss training
strategies for Koha.

The Zoom room is provided by Bywater Solutions :
https://zoom.us/j/392843340

Agenda:

1. Review of resources created for the community

* Wiki page: https://wiki.koha-community.org/wiki/Training_resources

* How-to's: https://wiki.koha-community.org/wiki/How-to

2. Review of Documentation Plan
(https://wiki.koha-community.org/wiki/Documentation_-_Plan) and
how the
education community can participate

3. Free discussion of best practices and tips

See you then!

Caroline

    -- 
    Caroline Cyr La Rose, M.L.I.S.

Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com
<mailto:caroline.cyr-la-r...@inlibro.com
<mailto:caroline.cyr-la-r...@inlibro.com>>

INLiBRO | Document Technologies Specialists | www.inLibro.com
<http://www.inLibro.com>
<http://www.inLibro.com>
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
https://lists.katipo.co.nz/mailman/listinfo/koha



--
Kelly McElligott, MLIS
Educator
ByWater Solutions <http://www.bywatersolutions.com>
Phone:(888)900-8944 
What is Koha? <http://bywatersolutions.com/what-is-koha/>




--
Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

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

[Koha] Education meeting summary

[Caroline Cyr-La-Rose]

Hello everyone!

We had an interesting meeting today with colleagues who do training or 
who are interested in Koha education.


Here are the main points we talked about :

- None of us have used the training resources wiki pages we created last 
time, but we figured we'd leave them there as reference in case other 
people are using them.


- We talked about how the Documentation Plan might support training and 
the production of training material.


    - We would like to be able to easily reuse the manual as training 
manual; David Nind will do a test with something simple like loans to 
see if we can export the manual as custom training material


    - David Nind will also check about how licensing can affect this 
process.


    - Ideally, we would like to reformat the manual to make it easily 
reusable as training material by taking different approaches (such as 
how-to's for single tasks, reference sections, concept explanations and 
troubleshooting sections) and also cater to different learning styles by 
incorporating screenshots, (links to) videos if available, and text.


    - Also, we would like the docs team to find a way to create 
permanent links to topics in the manual in order to refer to those 
topics regardless of the version in blog posts or other materials.


    - Finally, it was suggested that we incorporate a Glossary in the 
manual to make searching easier when users are not sure of the terminology.


- And lastly, though it is not directly tied to training, we talked 
about the idea of creating promotional texts or FAQ's for decision 
makers looking to switch to Koha.



The next meeting will take place on April 14 at 19 UTC.


Thanks to all those who participated and thanks to ByWater Solutions for 
hosting the meeting in Zoom!



--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] CHAT/POETRY: exporting records cataloged on a certain date

[Caroline Cyr-La-Rose]

I love it Fred!!

My fave:

I fashioned into format MARC
So they can shine out in the dark

<3

Caroline

On 19-12-06 12 h 25, King, Fred wrote:

Esteemed colleagues:

PLEASE NOTE: this entirely frivolous; please hit the delete key if you wish. 
Any opinions expressed here are mine and mine only, not necessarily shared by 
my employer, the Koha community, koha-US, or any poultry that might be 
associated with me.

A while back I was trying to figure out a way to export records that I had just uploaded 
to Koha so I could get information in the 999 field. (So I could build a new RSS file 
with links to the bib in the MedStar Authors' Catalog, but that doesn't really matter at 
the moment.) "Export Data" wasn't working-the export files had zero bytes.

While I was pondering a possible solution, the muse grabbed me by the keyboard and we 
produced a litter of couplets. Then someone (Katrin, was it you?) suggested unchecking 
the "With items owned by the following libraries" box, and it worked like a 
charm.

That left me with an obsolete poem.

I hate waste.

What to do? Well, I added a few more couplets below the "-" as an appendix 
wherein I reveal the solution. The meter gets a bit twisty in places, but it really does 
scan. I won't attest to the accuracy of all the information presented.

I upload records by the score
Into Koha's reservoir

 From "Manage Records" dialog
Import into the catalog

Rebuild Zebra then I look
To see what's new, with bib as hook.

To find one is no chore at all
Search for bib number? What a doll

My Koha is! if only one
Bib record I want and I'm done

But now I want to see the batch
That with my Koha I did hatch

I want to see all that is new
But soon I'm mired deep in glue

Perhaps Reports will now display
The records that I've done today.

The Koha SQL collection
Might point me in the right direction.

Alas, I get an error message!
It doesn't work! There's no expressage!

Then from the menu Main I go
To menu Tools, because I know

That in the column Catalog
Export Data, like a dog

Has served me faithfully before
And helped me through the catalog's door.

Export records by the date
they're cataloged? No bytes, not great.

Export records by bib range?
Still no bytes, it's very strange.

If these don't work, what can I do
To see my MARC creations new?

Can I put them in a cart?
All bibs selected, part by part?

That seems to work; they are just fine
Complete with MARC tag 999.

But now I want to add a date
260$c--is it too late?

I add the line and recompile
Then upload the replacement file

Check dups on field 097
A field I added--plucked from heaven

Still I'd like to understand
What happens to my little band

Of records new that with my hand
 From Reference Manager so grand

I fashioned into format MARC
So they can shine out in the dark

To show the world what we have done
In MedStar's realm of medicine

Does anybody have some thoughts?
I'd sure appreciate them, lots.

For curiosity, you know,
Librarians do not forgo.



BUT WAIT! I think I found a way
To find additions for the day

Most likely other specs as well
But on this point I shall not dwell.

 From Export Data uncheck the box
For owning lib'ry, that unlocks

The filter that prevents me from
A happy, joyous MARC outcome.

And if you have more than one branch
"Clear all" allows the avalanche

Without a lot of extra clicking.
Make haste! I hear the clock is ticking.

And that, my friends, is my solution
That works well at my institution.

And I'm reminded every day
Where there's a Koha, there's a way.

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

As we neared our sixties the cloaks we had wrapped about our essential selves 
were wearing thin.
--Robertson Davies, Fifth Business

--
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, orthopaedics, cancer and GI.

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

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


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


--
Caroline Cyr La Rose, M.S.I.
Biblio

Re: [Koha] Status "in transit" after checking in

[Caroline Cyr La Rose]

Hi Michael,  
Why do some items belong to branch B if they’re never going there?
I’m asking because there is an option in the circulation rules to « float » 
your collection, meaning that wherever the item is returned, it will stay at 
whichever branch it was checked in at.  

https://koha-community.org/manual/18.11/en/html/administration.html#default-checkout-hold-and-return-policy
  

I *think* this doesn’t affect the homebranch (your item would have homebranch 
B, holdingbranch A), but I’m not 100% sure. Thats why I was asking why some 
items belong to branch B.  

Hope this helps!
--  
Caroline Cyr La Rose, M.L.I.S.  
Librarian, Product Manager
Solutions inLibro  


Le 29 janvier 2020 à 05:58:05, Michael Kuhn 
(m...@adminkuhn.ch(mailto:m...@adminkuhn.ch)) a écrit:

> Hi
>  
> Our library is financed by two organisations. Thus we have one Koha
> 18.11 instance with two separate branches, but only one circulation
> counter where we are checking in the items.
>  
> Say we are logged in at the counter with branch A and checking in an
> item belonging to branch B - this will result in the following status
> message for the item: "In transit from branch A to branch B since
> 26/01/2020". To set this status to "Available" we need to log in as
> branch B and to check in the item once more.
>  
> We would better like if the status could just go to "Available" since in
> fact there is no transport necessary.
>  
> After some fruitless reading of the manual I came up with the idea to
> just delete the content of table "branchtransfers" every minute via cronjob:
>  
> DELETE FROM branchtransfers;
>  
> The status is then "Available", as desired.
>  
> Is this possible/advisable, or do you know a better way?
>  
> 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
> 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] Introduction: New Koha Manager

[Caroline Cyr-La-Rose]

Welcome Michael!

I'm sure you know the SQL library for SQL reports : 
https://wiki.koha-community.org/wiki/SQL_Reports_Library


I have that in my favourites for easy access. It's so useful!

If you need to tweak some of those reports for your particular 
organization, and you're not sure how to do it, you can ask the list or 
on the chat (https://koha-community.org/get-involved/irc/).


If you are on Koha-US mailing lists, you've probably seen the Koha 
Administration Special Interest Group meeting that's coming up next 
week. Could be interesting for you. 
http://koha-us.org/special-interest-groups/


And if you find that the manual is lacking on a particular topic, don't 
hesitate to report it in bugzilla with the keyword Documentation. The 
documentation team looks at those (sometimes!).


Welcome to the community!

Caroline

On 20-02-06 15 h 04, Michael Adamyk wrote:

Hello everyone, my name is Michael Adamyk and I began working at the
Central Kansas Library System (CKLS) in the United States last month as the
new Koha manager. When I joined the Koha Mailing List it encouraged an
introductory email, so... here it is! :-)

Our system is a consortium of about 50 public and school libraries that use
Koha, and CKLS manages the software. ByWater Solutions provides
development, support, and hosting for us.

I worked with Koha in a public library in circulation and cataloging, but
am new to the software management side of things, so have a lot to learn.
I've found the Koha manual and am part of several Koha-US mailing lists.
I'm looking forward to working with all of you and sharing ideas, tips,
etc. Eventually I'm hoping to get into a bit of development, but that's
probably sometime down the road.

Up to now I've been mainly learning through videos I can find, the Koha
manual, and just playing around with things (we have a test server which
really helps the experimentation process). Any other tips anyone has for
learning Koha, particularly administration and reports, would be awesome.

Thanks everyone, and it's great to "meet" you!



--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

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

Re: [Koha] Restrictions on 9XX Fields

[Caroline Cyr-La-Rose]

Hi Charles,

As far as I know, Koha only uses those three MARC fields (942, 952 and 999).

Also, have you looked at the following system preferences 
MarcFieldForCreatorId, MarcFieldForCreatorName, MarcFieldForModifierId 
and MarcFieldForModifierName? You can enter your local 9XX fields in there.


Best,

Caroline

On 20-03-01 22 h 29, Charles Kelley wrote:

Hi, all!

 I'd like to thank everyone for the help I have received in the past.

 My library would like to begin tracking changes we make to the catalog
records. I already know Koha does keep track of changes, for when I click
on "Modification Logs", I see a rich history.

 What I had in mind was something that we did in another library job of
mine: rededicated a 9XX field to log a brief synopsis of the changes we
made. Mostly just the cataloger's name or initials, timestamp, and a few
words, e.g.,

949  \\ $a Kelley, Charles. $b 2020-02-28 $c Added subject field. $c
Romanized Cyrillic title.
949  \\ $a Sloshkin, Victoria. $b 2020-02-29 $c Added editor [700]. $c
Added series title.
949 \\ $a Watanabe, Junko. $b 2020-02-30 $c Fixed title indicators.
949 \\ $a Watanabe, Junko. $b 2020-02-31 $c OK.

 Nothing more involved or detailed than the illustrations. If we really
need the detail, we'll look at the modification logs.

 I know the 9XX fields are locally defined, but as far as I can
determine, Koha uses the 942, 952, and 999 fields and they are to be
avoided. Are there other 9XX fields that we ought to avoid? I have added to
the avoidance list the CANMARC fields and the other fields in the Koha
default framework.

 I understand I'll have to add the brief change log field (949 in my
examples)and its subfields to the frameworks.

 Many thanks for your help.



--
Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Log access from intranet

[Caroline Cyr-La-Rose]

Hi Alvaro,

I looked in my koha-conf file and I have the following lines

 

 
/public/v1905/intranet/notifications/
 

Good luck!

Caroline

On 20-04-07 13 h 10, Alvaro Cornejo wrote:

Hi,

I´m trying to access /tools/AccessFiles but I get the error message:

Error: Files could not be found because the "access_dir" option was not set
in "koha-conf.xml". Contact your system administrator to add this option.

I looked to koha-conf file in /etc/koha/blibioteca/ but file does not have
any information about where to place that info.

Any idea of how to configure it?

Regards

Alvaro


||
*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
___

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


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

[Koha] Education: Education meeting TODAY!

[Caroline Cyr-La-Rose]

Hello everyone!

A quick reminder that there is an education meeting today at 19UTC (3pm 
EDT). This meeting is open to everyone who is interested in training or 
education for Koha.


Here is the summary of the last meeting we had in November: 
https://lists.katipo.co.nz/public/koha/2019-November/053887.html


The meeting will take place in Zoom, graciously provided by ByWater 
Solutions


https://zoom.us/j/95356522383

See you then!

--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Bad 008 fields - how to find them

[Caroline Cyr-La-Rose]

Hi Elaine,

It is possible to query MARC control fields in reports. I have done it 
in the past to find badly coded records.


The command to query MARC control fields is a bit tricky, but once you 
understand it, it's easy to adapt to your needs.


For example, the query is to show the publication date is

SELECT
    biblionumber,
    SUBSTRING(EXTRACTVALUE(metadata, '//controlfield[@tag="008"]'),8,4) 
AS "Publication date"

FROM biblio_metadata

- SUBSTRING means you're getting just a part of the string of characters 
that is in 008, specifically, we start at the 8th character and we get 4 
characters. This is tricky to remember because it's not the same as the 
positions we're used to. The publication date is usually 008/07-10. But 
here, you have to add 1, so it's 8-11. (It has to do with starting to 
count at 0 or at 1; positions start at 0 but character count starts at 1).


- EXTRACTVALUE is used to search for specific MARC fields, in this case, 
we will look in the metadata field for the 008 MARC field


So you can play with this query keeping in mind that you have to add 1 
to the 008 position.


SUBSTRING(EXTRACTVALUE(metadata, '//controlfield[@tag="008"]'),16,3) for 
publication place (008/15-17)


SUBSTRING(EXTRACTVALUE(metadata, '//controlfield[@tag="008"]'),36,3) for 
language (008/35-37)


etc.

Reference: 
https://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC


I hope this helps!

Caroline

On 20-04-14 13 h 58, Elaine Bradtke wrote:

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


--
Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] opacNavRight OPAC Preferences Problem

[Caroline Cyr-La-Rose]

Hi Benjade,

OpacNavRight was moved to the News tool.

Tools > News and then in the location, you can choose OpacNavRight.

Regards,

Caroline

On 20-05-08 09 h 42, Benjade Palmero wrote:

Hello All,

I can’t seem to find the opacNavRight OPAC Preference option in my 19.11 
version.
How can I edit my existing contents in that section in my OPAC Page?

All the best,

Benjade T. Palmero
University of Mindanao

Sent from Mail for Windows 10

___

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


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

[Koha] Documentation Team, where you at?

[Caroline Cyr-La-Rose]

Hi Everyone!

The vote for roles for the 20.11 cycle is happening tomorrow May 13 (or 
later today, if you live in the future a.k.a. Oceania). But no one 
signed up for the Documentation Team... :(


Joining the Documentation Team is a great way for librarians and Koha 
end-users to get involved in the Koha Community as it doesn't require 
any programming knowledge. It's also a great way to learn about new 
features!


If you are unsure how to contribute, there is information on the wiki 
https://wiki.koha-community.org/wiki/Editing_the_Koha_Manual and there 
is also a virtual hackfest presentation 
https://bywatersolutions.com/education/koha-virtual-hackfest-documentation


Also, if you're afraid that signing up for the team is too big a 
commitment, don't worry about it. There is no quota or anything! Even if 
you contribute only casually, you can still be part of the team.


The Documentation Team meets once a month over IRC to discuss progress 
and set priorities for the month. If you're not sure if you're 
interested, you can come and observe a meeting to see how it goes. The 
IRC channel can be found here 
https://koha-community.org/get-involved/irc/ and the next Documentation 
meeting is on June 4 at 19 UTC https://koha-community.org/calendar/


If you want to sign up, go to 
https://wiki.koha-community.org/wiki/Roles_for_20.11 and add your name.


I hope to see you there!

Caroline

--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

[Caroline Cyr-La-Rose]

Hi Charles,

Frameworks are cataloguing "forms". You can use many different ones or 
just the default one.


The advantage of using different ones is that you can show different 
MARC fields and add default values.


For example, you can have one 'Book' framework, where you would show 020 
(ISBN), and put the default rda material/support/media codes for printed 
material in 336, 337 and 338. And you can have a 'DVD' framework, where 
you would show 024 (CUP), but not 020 and put the default rda 
material/support/media codes for projected visual in 336, 337 and 338.


Caroline

On 20-07-06 01 h 09, Charles Kelley wrote:

Hi, all!

 I have been looking for an answer to the following question, but I've
been unable to find one: What are the purpose and use of the frameworks?

 I just don't understand. When I cataloged in a previous library job, I
didn't have frameworks. I just cataloged what I needed and if I didn't need
something, I didn't use it.

 So can someone answer the question, please?

 Many thanks.



--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Bulk upload of book cover images

[Caroline Cyr-La-Rose]

Hi Vincent,

Check the Koha manual: 
https://koha-community.org/manual/20.05/en/html/tools.html#upload-local-cover-image 



In that section, there is the procedure to upload images in batch.

Regards,

Caroline

On 20-08-24 17 h 40, Vincent Van Gogh wrote:

How to upload images to Koha in bulk. Is there any procedure/technique or
any App to take images of book covers and upload them to koha.


Vincent Van Gogh
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com 
<mailto:caroline.cyr-la-r...@inlibro.com>


INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] some documentation (19.11 and 20.05) pages are slightly outdated

[Caroline Cyr-La-Rose]

Hello Quynh,

Can you report it as a bug on bugs.koha-community.org? Make sure to 
choose the "Documentation" component when filing the bug.


The documentation team will check it out.

Thank you for spotting/reporting this!

Caroline

On 20-09-17 02 h 05, Quỳnh Vũ Đỗ wrote:

Hello
I have been using Koha documentation to extend Koha 19.11 as a CMS and
followed instructions given on the following page:
https://koha-community.org/manual/19.11/en/html/extending_koha.html#using-koha-as-a-content-management-system-cms

*Under the section "Editing the pages template" it is written as follows:*
- Copy /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/modules/
opac-main.tt to /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/modules/
pages.tt
- Edit /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/modules/pages.tt
- At approximately line 61, change this:
[% IF ( OpacMainUserBlock ) %][%
OpacMainUserBlock %][% END %]
- To this:
[% IF ( page_test ) %][% page_test %][%
END %]

*But in the pages.tt <http://pages.tt> file (copied from opac-main.tt
<http://opac-main.tt>) and where modifications are to be carried out, the
line shows not at approximately line 61 but at line 152 and is written as:*
  [% IF ( OpacMainUserBlock ) %][%
OpacMainUserBlock | $raw %][% END %]

It is of course a very minor difference but for the sake of exactitude, it
would be nice to have these differences corrected (line number and code)

*There is however a bigger issue with the following content:*

Remark: You may wish to disable your News block of these CMS style pages
e.g. when you do not want it displayed on the CMS style pages or where the
News block is long enough that it actually makes the ‘page_test’ include
scroll outside the default viewport dimensions. In that case, remove the
following code from your pages.tt template.

[% IF ( koha_news_count ) %]
 
 
 [% FOREACH koha_new IN koha_news %]
   [% koha_new.title %]
   [% koha_new.new %]
   (published on [% koha_new.newdate
%])
 [% END %]
 
 
[% END %]


*Because the code to be researched as above has been completely modified
and spans from line 72 to 102 (30 lines of code) and even further.*

The same remarks stand also for 20.05 documentation (
https://koha-community.org/manual/20.05/en/html/extending_koha.html#using-koha-as-a-content-management-system-cms
)

To whom shall we report this, else than in this mailing list?

Kind regards
Quynh
=
M. Vũ Đỗ Quỳnh (Ph.D)
Trường Đại học Thăng Long - Université de Thang Long - Thang Long
University (Hanoi, Vietnam)
Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération
internationale - Vice-Rector in charge of International Cooperation
Web: http://thanglong.edu.vn/
___

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


--
Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Making a field into a drop down menu

[Caroline Cyr-La-Rose]

Hi John,

I looked in my db and noticed there was an entry "itemtypes" in the 
table "authorised_value_categories". Do you also have this? I'm not sure 
how item types as authorised values are managed since it is not a real 
authorised value category.


Caroline


On 20-10-04 07 h 01, John Fawcett wrote:

Hi

first of all let me say I'm completely new to Koha and am taking a look
at it potentially to use in a school library. So thanks to all the
people that have contributed to making the software what it is today.

It's been a bit of a learning curve. First off, I tried and abandoned
the idea of installing on my existing Centos 8 server and took the
easier path of using the packaged install on latest Ubuntu release on a
new dedicated server, following this link:

https://wiki.koha-community.org/wiki/Debian

I did find an issue that stopped me installing mariadb due to
incompatible versions, but mysql installed without problems.

Needing to use Italian, I did run into some issues in the provided sql
which I had to tweak in order to get the install to correctly finish
without violating not null constraints (on the 307 record in the
marc_subfield_structure).

So now I've got an up and running installation which I'm trying out, but
one thing which I cannot work out.

After adding a Unimarc record, I'm on the editor for adding items.
There's a field 995 r "Type of item and material" (or in my version
"Tipo della copia e materiale". This is a free input text field, not a
drop down menu limited to a list of predefined values.

In the Italian translation this field did not have any
"authorised_value" in the table marc_subfield_structure. I've modified
with the value itemtypes. However for some reason this does not seem to
make the field into a drop down menu in the staff GUI. So my  question
to more experienced users are: after changing the "authorised_value" do
I need to run a script or restart something in order to get the free
text field to change into a drop down menu?

Or is there a different way of doing that?

thanks for any help.

John


___

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


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Mapping Authority & Bibliographic Records

[Caroline Cyr-La-Rose]

Hi,

Maybe someone else on the list can contradict me, but I don't think that 
is possible. Authority fields are only copied in matching biblio fields 
(eg. in MARC 21, authority 100 fields are copied into biblio fields 100, 
600, 700 or 800). Since 082 is outside those, it won't be copied.


If you think this could be an enhancement, you should add it to 
bugs.koha-community.org.


Regards,

Caroline

On 20-10-04 21 h 50, Ma. Victoria H. Silva-Manuel wrote:

Hi.

We are using Cutter-Sanborn and place it in authority 082$b. I wanted to
map it to biblio 082$b.
Is this possible and how?

Thank you.



--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

[Koha] Documentation Live Stream

[Caroline Cyr-La-Rose]

Hello everyone!

As part of the Koha DIY/hackfest part of Kohacon20, I will be live 
streaming while I edit the Koha manual. I will be using my workflow and 
narrating as I do things.


This will take place in the Big Blue Button Online Workshop room 
(https://bigbb.catalyst.net.nz/gl/ale-5xr-qjl-3uq) tomorrow, Saturday, 
October 25, at 9 am NZST (Friday, October 23, at 4 pm EST).


Note that this will *not* be a 'getting started' workshop. David Nind is 
already doing this today at 11 am NZST (see 
https://wiki.koha-community.org/wiki/Documentation_Workshop_KohaCon20).


See also everything else that will be happening during the Koha 
DIY/hackfest on the wiki : 
https://wiki.koha-community.org/wiki/Koha_DIY_2020#Projects


And if there's something you want to work on, please add it to the wiki 
page!


See you there!


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Spine labels in other languages

[Caroline Cyr-La-Rose]

Hello,

I'm not sure what you mean by printing spine labels in other languages? 
The spine labels use the information of the item, such as the call 
number, location, branch, etc. These will print in the language they are in.


I guess if you wanted spine labels with the same location in different 
languages, that is not possible as authorized values are not yet 
translatable. Is that what you were asking?


Regards,

Caroline Cyr La Rose

On 20-11-18 08 h 55, Rizwan Majeed wrote:

Dear All

Is it possible to print spine labels in other languages?

Regards!
___

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


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

[Koha] Bidding open for KohaCon21 hosts!

[Caroline Cyr-La-Rose]

Hello dear Koha community,

This "special" year is coming to an end. It's time to turn our attention 
to the new year that's coming up, full of possibilities!


Catalyst IT and their partners did a great job offering us a hybrid 
KohaCon this year, where people in COVID-free New Zealand could attend 
in person and people outside New Zealand could still attend from their 
homes or offices across the world through streaming. Videos of all talks 
are available on the community's Youtube channel 
https://www.youtube.com/c/KohaILS. It was proposed that we continue this 
tradition even in a(n eventually) COVID-free world so that everyone can 
attend and learn from each other no matter their availability, ability 
to travel, or budget.


If you or your organization would like to organize KohaCon21, please 
enter all relevant information on this wiki page : 
https://wiki.koha-community.org/wiki/KohaCon21_Proposals (if you do not 
already have an account to edit the wiki, you can request one, it is 
usually pretty fast to get your access). Know that the community stands 
behind anyone who volunteers to organize and that help is always 
available if you're unsure how to proceed.


Call for proposals will end on January 15, 2021 at 23:50 UTC. If there 
is more than one proposal, we will organize a vote, which will be 
announced on this mailing list.


In the mean time, I wish you all a happy new year (and end of year 
holidays if you celebrate them)!


Best regards,

Caroline Cyr La Rose


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Add 4 days to <>

[Caroline Cyr-La-Rose]

Hi Christopher,

What I would do in that situation is check in the item, if there is a 
hold, click "Ignore", put the item in quarantine, when it gets out of 
quarantine, check it in again and confirm the hold. That way, the item 
is removed from the previous patron's file, but no email is sent out 
right away.


Otherwise, I don't think it's possible to change the waiting date.

Best regards,

Caroline

On 20-12-07 11 h 31, Chris Davis wrote:

Dear Colleagues,

At present, when an item is checked back into our library branch, Koha 
sends out hold-available notices to our patron who have a hold on that 
item. That same day, the item begins a four-day quarantine; therefore, 
we must indicate in the aforementioned hold-available notices that the 
item will be available in four days from the <> 
which is found within the notices.


I KNOW THAT PATRONS SHOULD READ THE NOTICE MORE CAREFULLY, BUT is 
there a way to configure Koha to add four days to the 
<>? That way we could just put something like 
"your hold will be available for pick up on (<> 
+ 4)" to indicate the future date.


Many thanks,

*Christopher Davis, MLS*
Systems & E-Services Librarian
Uintah County Library
204 E 100 N, Vernal, UT 84078 
<https://www.openstreetmap.org/node/4375922503>

cgda...@uintah.utah.gov <mailto:cgda...@uintah.utah.gov>
+1 (435) 789-0091 ext. 261 
uintahlibrary.org <https://uintahlibrary.org>
catalog.uintahlibrary.org <https://catalog.uintahlibrary.org>
facebook.com/uintahcountylibrary 
<https://facebook.com/uintahcountylibrary>
instagram.com/uintahcountylibrary 
<https://instagram.com/uintahcountylibrary>

___

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


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Elasticsearch 6 on Koha 20.05 - Reindexing Failure

[Caroline Cyr-La-Rose]

Hi Craig,

I faced this recently and it ended up being because I was missing some 
authority types.


- CHRON_SUBD (182)

- FORM_SUBD (185)

- GEN_SUBDIV (180)

- GEO_SUBDIV (181)

Just adding those four authority types in Administration > Authority 
types solved the problem for me. I don't know if it's the same problem 
for you, though.


Caroline

On 20-12-08 10 h 07, Craig Butosi wrote:

Hi all,

Running Koha 20.05.06 on Ubuntu 18.04 with Elasticsearch 6.8.13:

I have 318 bib records; ~420,000 authority records

When running the following reindexing command (authorities only):

koha-elasticsearch --rebuild -d -v -a library2

I get the following error just before it commits 10,000 records:

[27771] Indexing authorities
[27771] 1000 records processed
[27771] 2000 records processed
[27771] 3000 records processed
[27771] 4000 records processed
[27771] 5000 records processed
[27771] Committing 5000 records...
[27771] Commit complete
[27771] 6000 records processed
[27771] 7000 records processed
[27771] 8000 records processed
[27771] 9000 records processed
[27771] 1 records processed
[27771] Committing 5000 records...
Use of uninitialized value $tag in hash element at
/usr/share/perl5/MARC/Record.pm line 202.
Use of uninitialized value $tag in regexp compilation at
/usr/share/perl5/MARC/Record.pm line 206.
Use of uninitialized value $tag in hash element at
/usr/share/perl5/MARC/Record.pm line 207.
Can't call method "tag" on an undefined value at
/usr/share/koha/lib/C4/Heading.pm line 71.
Something went wrong rebuilding indexes for library2

At this point, I can confirm that 5000 authority records have been indexed,
but that's about 415,000 short :S

A couple other things:

- My node is running when I curl localhost:9200. Top also shows ES
running.
- I have the ICU analysis plugin installed as well.


Never seen this error before. I was running ES 5.x but upgraded to 6.x
recently. Could the error above be related to 6.x? If so, can the errors be
resolved?

Any help would be much appreciated!

C


Craig Butosi, MA, MLIS, B Mus (Hons)
Library: library.craigbutosi.ca
___

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


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Framework ACQ causes mutilated special characters

[Caroline Cyr-La-Rose]

Hi Michael,

When I had this problem, had to do with the leader (field 000) the the 
ACQ framework. The leader (position 9) indicates the character encoding. 
If it's not there, Koha freaks out and mangles the special characters.


So to solve your problem, add field 000 in your ACQ framework.

Regards,

Caroline

On 21-02-03 15 h 46, Michael Kuhn wrote:

Hi

We have tested the following with Koha 18.11.03 and 20.11.00, both on 
Debian 9.


We are using framework ACQ (downloaded from 
https://wiki.koha-community.org/wiki/MARC_frameworks ) and have 
activated Koha system preference "UseACQFrameworkForBiblioRecords".


In Koha menu "Acquisitions > Vendor > New basket > Add order to 
basket: From a new (empty) record" we can see the MARC fields from 
framework ACQ. Now if we enter for example "Mäuse und Vögel" in MARC 
245 $a an order is created which shows the correct title "Mäuse und 
Vögel" in column "Order".


But when clicking this title to open the cataloging view we see the 
title is actually mutilated to "Mũse und Vg̲el". Or in other words, 
Unicode strings "äu" (octal 303 244 165) and "ög" (octal 303 266 147) 
have become octal 165 314 203 and 147 314 262.


Can anyone please confirm this? Is there a solution for this problem 
or should we open a bug report for this?


Many thanks in advance.

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


--
Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Framework ACQ causes mutilated special characters

[Caroline Cyr-La-Rose]

Hi Michael,

Unfortunately, I don't remember which library had this problem (I work 
for a company that supports over 40 libraries), so I'm not sure I could 
find the framework again to export it.


However, I did find the bug report that I filled way back when I had 
this problem. 
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23675


You can read what I did (I mention a default value, maybe that's the 
crux of the problem).


Regards,

Caroline

On 21-02-03 16 h 30, Michael Kuhn wrote:

Hi Caroline

> When I had this problem, had to do with the leader (field 000) the the
> ACQ framework. The leader (position 9) indicates the character
> encoding.
> If it's not there, Koha freaks out and mangles the special characters.
>
> So to solve your problem, add field 000 in your ACQ framework.

This was my first idea as well but unfortunately it didn't change the 
behavior. Also field 000 isn't shown in the section "Catalog details" 
when creating a new order. But it is shown when opening Koha menu 
"Administration > MARC frameworks > ACQ".


When opening the record with framework ACQ no field 000 is shown.

When opening the record with standard framework (what happens when 
showing the cataloging view directly after creating an order) field 
000 is there with correct value "a" in position 9.


But in both cases special characters in MARC 245 $a are mutilated.

May I ask you to export and send me the CSV file of framework ACQ you 
have created? Maybe there is some difference in our frameworks.


Best wishes: Michael


--
Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

___

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

[Koha] Koha wiki update/replacement

[Caroline Cyr-La-Rose]

Hello Koha community!

There has been discussion about updating or replacing the wiki 
(https://wiki.koha-community.org). The software behind the current wiki 
is out of date and we need to upgrade it. Or we could replace it with 
something more lightweight or more user-friendly. The current wiki is a 
gold mine of information, but that good information is hard to find.


This email is an attempt to start a conversation about the best plan of 
action to upgrade our wiki.


The main argument for changing is that the MediaWiki version we are 
using is obsolete.


- Should we continue with a more recent version of MediaWiki or change 
the software?


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.


- If we change the software, do you have a suggestion?

Some have suggested that we simply archive the current wiki and start 
fresh with a new one.


- Would you be in favor of starting over?


I'm sure I'm forgetting things, but my hope is only to get the ball 
rolling and that this project does not fall in the cracks once again. If 
you have any suggestion, comment, or concern about this project, please 
voice them by replying to this email.


If you'd rather discuss "live" about this issue, the wiki question is 
often on the Development IRC meetings agenda. Next meeting is on March 
24, 2021 at 20 UTC 
https://wiki.koha-community.org/wiki/Development_IRC_meeting_24_March_2021


Thank you for your input!

Caroline

--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

[Koha] KohaCon21 hosting organization announced!

[Caroline Cyr-La-Rose]

Hello dear Koha Community!

Today at the General meeting, it was announced that the Koha Pakistan 
Community and the National Library of Pakistan will be hosting KohaCon21!


The proposed dates for the conference are November 14 to 30, 2021 and 
will be organized as a hybrid in-person/online conference. For those who 
are able to travel, the in-person conference will be held at the 
National Library of Pakistan, in Islamabad.


The Pakistani community has a lot of experience in organizing 
conferences as they have been organizing Open Source Summits and Koha 
Conferences for the past several years with great success. I'm sure 
KohaCon21 will not be an exception!


You can find all the information about their proposal on the Koha wiki : 
https://wiki.koha-community.org/wiki/KohaCon21_Proposals#Hosting_organization


The Koha Pakistan Community will keep us updated on the details in the 
upcoming months.


Thank you all!

Caroline

--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] BULK IMPORT REPORTS

[Caroline Cyr-La-Rose]

Hello James,

I suggest you search Google for mysqldump.

it's usually something like mysqldump -u yourusername -p 
your_koha_database table > file.sql


so for me, exporting my reports would look like

mysqldump -u caroline -p koha_v20_inlibro_dev saved_sql > reports.sql

Then you can import this sql file as is into your new installation (this 
will overwrite any reports that are already in your new installation)


Something like

mysql -u yourusername -p your_koha_database < file.sql

If you don't want to overwrite the existing reports, you'd have to edit 
the sql file to remove everything except the "insert into" line. Save 
the file and then import it.


I hope this helps,

Caroline

On 21-03-27 03 h 27, muiru james wrote:

Hello Katrin,

Any help you offer will be greatly appreciated on how to go about it.

Regards James

On Thu, 25 Mar 2021, 00:29 Katrin Fischer,  wrote:


Hi James,

if you are not comfortable with SQL it's quite hard to explain how to do
this from scratch. At least I am not sure how to explain it well.

Sorry!

Katrin
On 13.03.21 13:47, muiru james wrote:

Thanks Katrin for your reply.

Could you give me more details on how to go about it so that I can give it
a try?

Most appreciated

Regards
James

On Sat, Mar 13, 2021 at 2:46 PM Katrin Fischer 
wrote:


Hi,

at the moment it's not possible to export/import reports from the staff
interface/GUI. You could try and use SQL to do it server side. All
reports can be found in the table saved_sql.

Hope this helps,

Katrin

On 13.03.21 10:07, muiru james wrote:

Hi,

Is there a way to add export reports from one system and add them in

bulk

to a new server?

Regards
James
___

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

___

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


___

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


--
Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

___

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

[Koha] Getting guarantor information in notices

[Caroline Cyr-La-Rose]

Hello dear community!

I'm wondering if it's possible to access guarantor information for 
notices? We recently upgraded our Kohas to 20.05 from 19.05. One of the 
notices goes like this


    <> <>
[% IF borrower.guarantorid %] C/O [% borrower.contactfirstname %] [% 
borrower.contactname %][% END %]

    <> <>
    <> (<>) <>

The second line is if the patron has a guarantor, write Care of (C/O) 
the guarantor's name. This is for Overdues notices sent by mail to 
patrons. It is not logical for us to send overdue notices to children, 
so we write Care of the parent.


In 20.05, the database structure changed to accommodate multiple 
guarantors per guarantee.


Does anyone know if there is a way to access the guarantor information 
in notices? I'm not very familiar with TT syntax so I have no idea how 
to indicate this "borrower" is the guarantee and this other "borrower" 
is the guarantor...


Thank you so much!

Caroline


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] convert from Handy Library Manager

[Caroline Cyr-La-Rose]

I have never done a conversion from this software. If HLM can export 
bibliographic records in some type of MARC format, and other data in 
CSV, I think you should be able to convert your data and import it into 
Koha.


There is a section on data migration in the manual: 
https://koha-community.org/manual/20.11/en/html/implementation_checklist.html#data-migration


Good luck!

Caroline

On 21-04-19 17 h 23, Maintenance wrote:

I might  have already asked this... however

Can KOHA convert a "Handy Library Manager" (HLM) into itself and replace it?

I'd like to move from our current Handy Library Manager to an open source
system and Koha was presented.

Please let me know if Koha can be use to move from HLM system.

Thanks
Jason
___

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


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Opac display

[Caroline Cyr-La-Rose]

Hi Carlo,

If you use XSLT for your OPAC display (search system preferences for 
XSLT), these labels don't have any impact since the display is managed 
by the XSLT.


I think the labels might appear in the MARC view, though.

Caroline

On 21-06-09 04 h 46, c.dumon...@btinternet.com wrote:

I'm new to Koha and I would be grateful for some help.

  


The name in the "Label for opac" in the MARC framework does not correspond
to the actual label on the opac.

For example:

  


In the Admin module one of our frameworks has the following labels for 246:
"Label for Lib" = Variant title ;  "Label for Opac" = Variant title.

But in the Opac display the label in fact reads: "Other title".

  


In which part of the Admin module do I tweak with these labels? Why the
discrepancy? Is there any video online where this topic is covered? (I could
not find any).

Many thanks for your help.

  


Carlo

___

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


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Frameworks

[Caroline Cyr-La-Rose]

Hello Carlo,

The only way I know of is to modify the records that use the frameworks.

To do it in the staff interface, you can follow these steps (they are in 
French, maybe you can read it, your surname sounds French :) otherwise, 
I'm sure Google Translate will manage to make it readable for you): 
https://inlibro.com/knowledge-base/impossible-de-supprimer-une-grille-de-catalogage/


If you have access to the database, you can try an update, something like:

UPDATE biblio SET frameworkcode = "" where frameworkcode IN 
("list","of","unwanted","frameworks");


I hope this helps,

Caroline

On 21-06-23 10 h 54, Carlo Dumontet wrote:

A plea for help to the Koha pundits.

My Library has far too many bib frameworks.

Koha does not allow me to delete the unwanted ones because they have all
been used (sometimes only once).

Is there a way of by-passing this restriction?

Many thanks for your help

Carlo

___

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


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Field 830v won't display

[Caroline Cyr-La-Rose]

Hi Javi,

Sounds like the subfield is missing or hidden in the framework. You can 
check in Administration > MARC bibliographic frameworks.


Action > MARC structure

Search for 830

Actions > Edit subfields

Click on v

Make sure it is "Managed in tab"  8 and Editor is checked.


Good luck!

Caroline

On 21-06-30 10 h 23, Javi Legido wrote:

Hi there.

=Steps to reproduce=

1. Login admin interface

2. Click 'Cataloging'

3. Click 'New record' button

4. Click 'Default framework'

5. Click '8' tab

6. Click '830 SERIES ADDED ENTRY...' to expand it

=Expected behavior=

Find a text box with 'v Volume/sequential designation', as per:

https://www.loc.gov/marc/bibliographic/bd830.html

=Found behavior=

Missing that field

=Errors=

None

Any guidance will be appreciated.

Thanks.
___

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


--
Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technologies Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] [koha] Authorized value for category_types

[Caroline Cyr-La-Rose]

Hello James!

You can look at the SQL library on the Koha wiki. In the first sections, 
there is one about runtime parameters that explains it very well. 
https://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Parameters


I think there are a couple of options you can use.

1) Create your own authorized values list

As it is possible to use any authorized values list as runtime 
parameter, you can create an AV list just for this report. Since the 
codes aren't likely to change, this could be a good option.


- Go to Administration > Authorized values

- Click on New category

- Create a code for your category (e.g. BORCAT)

- Click on New authorized value for XX

- Add the authorized values for the category types, for example

Authorized value = A

Description = Adult

The other category types are

C = Child

I = Organization

P = Professional

S = Staff

X = Statistical

(see 
https://koha-community.org/manual/latest/en/html/faq.html#patron-categories-table)


- In your report, add the runtime parameter just like you would for 
itemtypes for example


WHERE category_type = <>

I just tried it in 20.05 and it works.


2) Add a simple text field as runtime parameter

I think this was Owen's suggestion.

- In your report, add a runtime parameter without av list, for example

WHERE category_type = <>

- As previously mentioned, users will have to know the specific codes to 
enter in the field (A, C, I, P, S or X), otherwise the report will not 
give any results.


- As of version 21.05, there is an option to make a text field a text 
area for several values 
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27380


Regards,

Caroline

On 2021-08-12 10 h 30, muiru james wrote:

Hi Owen and All,

Thank you for your quick reply and very good advice. I will follow your
idea on good documentation in the report.
I have no knowledge on runtime parameters but thanks for that pointer too.

If you can increase my knowledge on how to tell an authorized value or
where to look I'd be grateful. I have used the 'itemtypes' authorized value
(as copied from the koha reports library) but I'm always curious to learn
more about it or at least understand it better. (-- WHERE items.itype=
<>)

Thanks a lot

Regards
James

On Thu, Aug 12, 2021 at 3:24 PM Owen Leonard  wrote:


WHERE  categories.category_type= <>

category_type is an odd one. It's not an authorized value. In fact I
don't think they're defined anywhere in the database at all, just
hard-coded into templates and scripts. They're intended to be fixed
values, not ones which can be modified.

I don't think there's any way to get an SQL report to generate a set
of options based on these values. It would be nice if one could supply
a set of user-defined options in a runtime parameter, e.g. <> but that would be complicated for
users. I think in your case you might have to rely on good
documentation in the report notes to let the user know which
category_type codes are valid.

  -- Owen

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


___

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

___

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

Re: [Koha] For Category

[Caroline Cyr-La-Rose]

Hello,

There are no "subcategories" in Koha. However, you can use the Bsort1 or 
Bsort2 authorized values categories. Those are linked to the Sort 1 and 
Sort 2 fields in the patron file.


Alternatively, you can use extended patron attributes to indicate the year.

Regards,

Caroline

On 2021-08-12 13 h 58, Himanshu Aggarwal wrote:

I have students that belong to First Year to the third Year and then
Masters Degree. In Koha can we create a subcategory under Student..First
Year Second Year and so on.


Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technology Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Batch edit to control fields?

[Caroline Cyr-La-Rose]

Hi Cab,

Unfortunately, Koha's MARC modification tool cannot do any changes in 
control fields, AFAIK.


I usually tell people to use MarcEdit to do such batch changes. Here's a 
procedure I wrote (in French, but I'm sure Google can translate it for 
you) : 
https://inlibro.com/knowledge-base/modification-en-lot-des-zones-de-controle-avec-marcedit-1-lieu-de-publication-008-15-17/


I hope it helps,

Caroline

On 2021-08-24 11 h 38, Cab Vinton wrote:

Hi, All --

Does anyone know if the Batch record modification tool can handle
control fields? -- specifically, changes to various positions in the
leader, 008, etc. We're trying to update the 008/33 in a large number
of records.

I've tried creating an action for this under a MARC modification
template, but it seems to be expecting standard fields & subfields
(i.e., it won't accept a 2 digit number to represent a position).

We can always export to MarcEdit, but if we can do this from within
Koha, that would be great.

All best,

Cab Vinton, Director
Plaistow Public Library
Plaistow, NH
___

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

Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technology Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Batch edit to control fields?

[Caroline Cyr-La-Rose]

There is a particularity with substring and control fields in SQL.

The difference has to do with the starting character of the substring, 
i.e. the 33 in the following sequence


SUBSTRING(ExtractValue(metadata,'//controlfield[@tag=008]'),33,1)

MARC starts counting at 1, whereas SQL starts counting at 0. Or it might be the 
reverse, I don't remember exactly. Anyway, the thing is that you can't use the 
MARC character position (in this case 33 because you're looking for 008/33), 
directly in the substring statement. You have to add 1.

So to look for 008/33 you have to use

SUBSTRING(ExtractValue(metadata,'//controlfield[@tag=008]'),34,1)

to look for 008/15-17, like in the example in the link I sent, you have to use

SUBSTRING(ExtractValue(metadata,'//controlfield[@tag=008]'),16,3)

Does that make sense?

Caroline

On 2021-08-24 12 h 13, Cab Vinton wrote:

Thanks so much, Caroline! Good excuse to brush up on my French.

Have used MarcEdit before, but not for this, so your instructions will
be vachement utiles :-)

Btw, we've been using the report below to identify which records have
issues w/ the 008/33. However, the ExtractValue statement is pulling
spaces rather than the actual values.

Would be grateful for any suggestions on why the SUBSTRING &
ExtractValue statements don't appear to be working well together.

All best,

Cab Vinton, Director
Plaistow Public Library

SELECT SUBSTRING(ExtractValue(metadata,'//controlfield[@tag=008]'),33,1)
AS LitForm, i.itemcallnumber, i.itype, i.ccode, CONCAT('', biblionumber, '' ) AS bibnumber
FROM biblio_metadata
LEFT JOIN items i USING (biblionumber)
ORDER BY i.biblionumber DESC, i.itemcallnumber

Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Open Ended Due Dates, Permanent Loans, Etc.

[Caroline Cyr-La-Rose]

Hi Charles,

Maybe you could do something like that with automatic renewals?

In circulation rules, you could have a "regular" loan period, but many 
renewals, e.g. 99.


Set up automatic renewals. Koha will renew automatically, as long as the 
item is not on hold, the patron's membership is not expired, etc.


Caroline

On 2021-09-15 21 h 37, Charles Kelley wrote:

Hi, all!

 Is there a way to make an open ended due date? That is, if a person
checks out a book, Koha does not assign a due date, *per se*, rather it
merely marks it checked-out. I guess this be might be considered a
permanent or semi-permanent loan but it would not be a transfer.

 Mind you, if a patron puts a hold on such a book, the patron who
checked out the book would have to surrender it. The book would still be
one of the library's holdings so that the library can avail it to the
patrons and track it for property management reasons.

 (The OPAC would list it only *CHECKED OUT* or *BORROWED*.)

 Mind you, I am trying to avoid a proliferation and plethora of LOCs and
CCODEs.

 I know this is a nightmare and it defeats the purpose of a library of
shareable works. It would be rarely used, of course, but I can imagine a
scenario in which it would arise.

 Many thanks, all!


Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technology Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] serials management - numbering pattern

[Caroline Cyr-La-Rose]

Hi Nalisha,

If it doesn't ever go back to 1, you shouldn't need to put anything in 
the inner counter. The inner counter serves only to tell Koha where how 
many issues have already been published in the cycle. If there is no 
cycle, there is no need for the inner counter.


Caroline

On 2021-09-22 03 h 24, Nalisha Tamang wrote:

Dear all,
  WE have the journal "BibliothecaSacra" from 1962 Vol.119 no.474 till 1986
Vol.143 no.569 now how do i set the numbering pattern for this journal as I
add 'begins with' v.119 no.474 but confused regarding what number to add in
the  inner counter. As this is quarterly published and the volume and the
number keeps increasing we can't set back to 1 or any number. IF I HAVE TO
CHANGE IN THE NUMBERING PATTERN PLEASE HELP ME OUT I'M NEW In this area.


Thank you
Nalisha
___

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

Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Reason to define Koha item type in 942

[Caroline Cyr-La-Rose]

Hello!

I'd like to add to Indranil's explanation.

952$y is mandatory for circulation IF item-level_itypes is set to 
"specific item". Otherwise, 942$c is used as the item type for circulation.


Another thing that I have observed about 942$c is that it is indexed for 
the search in the same way as 952$y. So if you have records without 
items (for journal articles, websites or ebooks for example), these will 
still be searchable through the item type filter.


Also, if 942$c and 952$y are not the same in one record (for example, 
942$c is Book and 952$y is Reference), they will show in the results of 
a search for either type.


I'm making a note to compile all our comments to add into the manual, 
since that's where you searched for the information first. 
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29252


Best regards,

Caroline

On 2021-10-15 10 h 02, Indranil Das Gupta wrote:

Hi Tasha,

942$c - defines the type of material the bibliographic record represents,
sort of like it's GMD (general material description). Has no bearing on
circulation of material. Stored as marcxml in biblio_metadata.

952$y - defines the item-level item, and is used mandatorily for Koha's
circulation rules which work as a permutation of (a) branchcodes (b) patron
categories and (c) item-level item types. Stored as itype column in items
table.

Hope this helps
Indranil

On Fri, 15 Oct, 2021, 12:44 am Bales (US), Tasha R, <
tasha.r.ba...@boeing.com> wrote:


Good afternoon,

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

Does this seem familiar to anyone?  Thanks.


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

___

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


___

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

Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

___

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?

[Caroline Cyr-La-Rose]

Same, I don't see it.

I usually use this JQuery to hide the MARC tab from the OPAC :

https://wiki.koha-community.org/wiki/JQuery_Library#Hide_Marc_.26_ISBD_view_from_OPAC

Caroline

On 2021-10-19 07 h 26, 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


Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

___

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

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

[Caroline Cyr-La-Rose]

Hi Tasha,

I confess, I'm the one guilty of that section... I unfortunately never 
learned LC in school or in work (I've only worked with Dewey), and I 
tried to read the code for the LC filing routine and didn't understand a 
word. Ideally someone with knowledge of perl (or whatever language it is 
written in) and LC should look at the filing rule code and either write 
the section or tell someone on the docs team how it works so they can 
write it.


As for your 2nd question, I don't think there is a way to create custom 
filing rules in Koha (unless you do it through coding, if you know how 
to code, I think pretty much anything is doable).


Caroline

On 2021-11-23 20 h 26, Bales (US), Tasha R wrote:

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

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

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

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

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

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


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

___

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

Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] How can I insert the item information on the spine label?

[Caroline Cyr-La-Rose]

Hi Victor,

- In Tools > Label creator > Manage > Layouts

- Choose the layout in which you want to add the copy number

- In the section Bibliographic data to print, choose List fields

- A new text input will appear, where you can add copynumber (e.g. 
itemcallnumber, enumchron, copynumber)


You have to make sure that 952$t is mapped to items.copynumber. It 
should be by default, but it doesn't hurt to check.


- In Administration > Koha to MARC mapping

- Search for copynumber

- Make sure items.copynumber is mapped to 952$t

- If not, click Add

- In the text box, enter "952,t" (without the quotation marks, just 
952,t); the comma is important


Changes in Koha to MARC mapping are applied to new records and items 
only. If you want to print labels for future items, you don't need to do 
anything further. But if you changed Koha to MARC mapping and need to 
print labels for existing items, you will need to run 
batchRebuildItemsTables.pl


I hope this helps,

Caroline

On 2021-11-27 08 h 54, Victor Barroso Oliveira wrote:

Hello,
I would like to insert the copy number information on the spine label,
however when I have to customize the layout with the 952t field I cannot
generate the label with the copy number information.
How can I insert the item information on the spine label?
Thanks,
Victor
___

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

Caroline Cyr La Rose, M.L.I.S.
Librarian | Product Manager

Phone: 1-833-465-4276, ext. 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Document Technology Specialists | www.inLibro.com 
<http://www.inLibro.com>

___

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

Re: [Koha] Adding a repeated subfield with a MARC modification template

[Caroline Cyr-La-Rose]

Hello Mathieu,

Since you use "Update existing or add new" in both rules, the first is 
overwritten by the second. I suggest you use simply "Add new". This will 
add the subfield without checking if it already exists first.


Caroline

On 2022-01-03 12 h 46, Mathieu Saby wrote:

Hi

I tried to add a repeated subfield with a MARC modification template, but I
failed to achieve the wanted result (demo instance 20.11.02) .  Could you
please tell me if this operation is possible ?


The subfield 099$t is repeatable in my framework

What I expect is to create a 099$t and add two $t subfields :

*099*

*_tBOOK_t*CD



But the result I obtain is

*099 _t*CD

(only the 2d occurence is added)


I used these 2 rules :

Update existing or add new field 099$t with value *BOOK*

Update existing or add new field 099$t with value *CD*




Regards,


Caroline Cyr La Rose, M.S.I.
Bibliothécaire | Responsable de produit

Tél. : 1-833-465-4276, poste 221
caroline.cyr-la-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>

___

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