Re: [Koha] Koha Digest, Vol 126, Issue 46

[kinby elly]

Thank you for inviting me .as long as possible try to give me the rules
On Apr 30, 2016 2:54 AM,  wrote:
>
> 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. Merge Records via List not working in Koha 3.22.x (Sunil Sharma)
>2. Search By Barcode having 1, 2 or 3 digit not working in Koha
>   3.20 or in 3.22 (Sunil Sharma)
>3. Re: Search By Barcode having 1, 2 or 3 digit not working in
>   Koha 3.20 or in 3.22 (Katrin Fischer)
>4. Re: Best practices for koha - journal migration using
>   marcedit (Karl Holten)
>5. Error thrown when updating items (wildness)
>6. Re: Error thrown when updating items (Indranil Das Gupta)
>7. Re: Error thrown when updating items (wildness)
>
>
> --
>
> Message: 1
> Date: Fri, 29 Apr 2016 16:39:36 +0530
> From: Sunil Sharma 
> To: koha 
> Subject: [Koha] Merge Records via List not working in Koha 3.22.x
> Message-ID:
> <
caczw6wvxsjydfljobyznddo5sdiplxtjd1f-fnxiffec8ah...@mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Hello Friends,
>
> I am using Koha 3.22.5 on Debian 8 OS.
>
> I have many duplicate title in my catalog, So I want to merge such records
> through Koha List module using merge function, At the end of the process
it
> will show succesfully merged. But in actual it will neither merge items
> from source to destination record nor it will delete the other records
> except reference as it worked in previous version Koha 3.18 or koha 3.20.
>
> Any pointers would be of help.
>
> --
> Thanking you,
> Sunil Sharma
>
>
> --
>
> Message: 2
> Date: Fri, 29 Apr 2016 16:46:14 +0530
> From: Sunil Sharma 
> To: koha 
> Subject: [Koha] Search By Barcode having 1, 2 or 3 digit not working
> in Koha 3.20 or in 3.22
> Message-ID:
> <
caczw6wvsuxabuzjppng_fo96ptgy8-4qqtsrs8weyzwwrte...@mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Hello Friends,
>
> I checked both Koha 3.20.x as well as Koha 3.22.x on Debian 8 OS, Zebra
> version 2.0.61. My other search is working fine but when I search any
> barcode having 1, 2 or 3 digit, the search result page will not reflect
> proper search result both in Koha OPAC as well as on Staff-Admin page.
>
> For example, when I search 123 it will give the records having barcode as
> 1231, 1232, 1233, same as if I will search for barcode 121 then it will
> give result for biblio having accession no. 121220, 121121 and so on. Even
> these barcodes (121 or 123) are present in Koha.
>
> Any pointers would be of help.
>
> --
> Thanks & Regards
> Sunil Sharma
>
>
> --
>
> Message: 3
> Date: Fri, 29 Apr 2016 16:11:09 +0200
> From: Katrin Fischer 
> To: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Search By Barcode having 1, 2 or 3 digit not
> working in Koha 3.20 or in 3.22
> Message-ID: <57236b7d.2030...@web.de>
> Content-Type: text/plain; charset=utf-8
>
> Hi,
>
> How are you searching for the barcode?
> Did you turn on the QueryAutoTruncate system preference?
>
> Hope this helps,
>
> Katrin
>
> Am 29.04.2016 um 13:16 schrieb Sunil Sharma:
> > Hello Friends,
> >
> > I checked both Koha 3.20.x as well as Koha 3.22.x on Debian 8 OS, Zebra
> > version 2.0.61. My other search is working fine but when I search any
> > barcode having 1, 2 or 3 digit, the search result page will not reflect
> > proper search result both in Koha OPAC as well as on Staff-Admin page.
> >
> > For example, when I search 123 it will give the records having barcode
as
> > 1231, 1232, 1233, same as if I will search for barcode 121 then it will
> > give result for biblio having accession no. 121220, 121121 and so on.
Even
> > these barcodes (121 or 123) are present in Koha.
> >
> > Any pointers would be of help.
> >
>
>
>
> --
>
> Message: 4
> Date: Fri, 29 Apr 2016 18:06:54 +
> From: Karl Holten 
> To: Paul A , koha
> 
> Subject: Re: [Koha] Best practices for koha - journal migration using
> marcedit
> Message-ID:
> <
dm2pr0501mb1310c00218989f1e3515b919a7...@dm2pr0501mb1310.namprd05.prod.outlook.com
>
>
> Content-Type: text/plain; charset="utf-8"
>
> As far as I know, Koha converts the MRC file into MARCXML 

Re: [Koha] Search By Barcode having 1, 2 or 3 digit not working in Koha 3.20 or in 3.22

[Sunil Sharma]

Hi Katrin,

Yes, when I check this system preference it is set on as "automatically".
When I changed it to "Only if * added" search is performing fine. Thanks
for the help.

On Fri, Apr 29, 2016 at 7:41 PM, Katrin Fischer 
wrote:

> Hi,
>
> How are you searching for the barcode?
> Did you turn on the QueryAutoTruncate system preference?
>
> Hope this helps,
>
> Katrin
>
> Am 29.04.2016 um 13:16 schrieb Sunil Sharma:
> > Hello Friends,
> >
> > I checked both Koha 3.20.x as well as Koha 3.22.x on Debian 8 OS, Zebra
> > version 2.0.61. My other search is working fine but when I search any
> > barcode having 1, 2 or 3 digit, the search result page will not reflect
> > proper search result both in Koha OPAC as well as on Staff-Admin page.
> >
> > For example, when I search 123 it will give the records having barcode as
> > 1231, 1232, 1233, same as if I will search for barcode 121 then it will
> > give result for biblio having accession no. 121220, 121121 and so on.
> Even
> > these barcodes (121 or 123) are present in Koha.
> >
> > Any pointers would be of help.
> >
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>



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

[Koha] Koha Community Newsletter: April 2016

[kohanews]

Fellow Koha users:

The Koha Community Newsletter for April 2016 is here:
https://koha-community.org/koha-community-newsletter-april-2016/

Many thanks to the folks who submitted articles and news to this month's 
newsletter.


Please feel free to email me with any corrections or suggestions.

Thanks!

--
Chad Roseburg
Editor, Koha Community Newsletter

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

Re: [Koha] Error thrown when updating items

[Indranil Das Gupta]

Hi,

Just a hunch... did you by any chance edit / change your marc
framework or edit the xsl files or upgrade your Koha, before this
error started showing up?

regards
-idg




On Sat, Apr 30, 2016 at 4:09 AM, wildness  wrote:
> Hi,
>   I'm running Koha 3.18.12.000 and I can this error when I try to update
> items for a record:
>
> :21: parser error : Opening and ending tag mismatch: record line 6 and
> datafield
> 
> ^
> :22: parser error : Opening and ending tag mismatch: collection line 2 and
> record
> 
>  ^
> :23: parser error : Extra content at the end of the document
> 
>
> the url pattern is something like this:
> ../cgi-bin/koha/cataloguing/additem.pl?op=edititem=''=''#edititem
>
> When I edit one of the fields on this screen it throughs the error above.
> It seems like a xml error, but after some internet sleuthing I came up with
> nothing.  Can anyone help me out?  Thanks!
>
>
>
> --
> View this message in context: 
> http://koha.1045719.n5.nabble.com/Error-thrown-when-updating-items-tp5886331.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha



-- 
Indranil Das Gupta

Phone : +91-98300-20971
Blog: http://indradg.randomink.org/blog
IRC  : indradg on irc://irc.freenode.net
Twitter : indradg

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-
Please exchange editable Office documents only in ODF Format. No other
format is acceptable. Support Open Standards.

For a free editor supporting ODF, please visit LibreOffice -
http://www.documentfoundation.org
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Error thrown when updating items

[wildness]

Hi,
  I'm running Koha 3.18.12.000 and I can this error when I try to update
items for a record:

:21: parser error : Opening and ending tag mismatch: record line 6 and
datafield

^
:22: parser error : Opening and ending tag mismatch: collection line 2 and
record

 ^
:23: parser error : Extra content at the end of the document


the url pattern is something like this:
../cgi-bin/koha/cataloguing/additem.pl?op=edititem=''=''#edititem

When I edit one of the fields on this screen it throughs the error above. 
It seems like a xml error, but after some internet sleuthing I came up with
nothing.  Can anyone help me out?  Thanks!



--
View this message in context: 
http://koha.1045719.n5.nabble.com/Error-thrown-when-updating-items-tp5886331.html
Sent from the Koha-general mailing list archive at Nabble.com.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Best practices for koha - journal migration using marcedit

[Karl Holten]

As far as I know, Koha converts the MRC file into MARCXML format and populates 
the MySQL database with the information in it. So perhaps he wouldn't need to 
compile to MRC at all if he went that route. 

If I'm reading schemaspy right, MySQL has a hard limit of 2147483647 bytes, 
which is good enough for anyone's needs, I would hope. Zebra has a lower 
ceiling. I don't know what that is, but we ran into it after migration when we 
discovered that large serials were not showing up in search results. We deleted 
some legacy data, which pushed us below that size limit. We're moving to 
ElasticSearch soon enough and I'm hoping it's not going to be an issue there. 
(Knock on wood)

Regards,
Karl Holten
Systems Integration Specialist
SWITCH Inc
414-382-6711

-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Paul A
Sent: Thursday, April 28, 2016 5:44 PM
To: koha 
Subject: Re: [Koha] Best practices for koha - journal migration using marcedit

At 09:39 PM 4/28/2016 +, Karl Holten wrote:
>The MARC format has an individual record size limit of 9 bytes, but 
>big serials in Koha can eclipse that size. The result is that really 
>big serials don't compile as valid MARC if you have a ton of items 
>attached to them.

Thanks for the comment. I think that Indranil Das Gupta was proposing a direct 
intervention at MySQL level -- that's certainly what I am looking for.

I'm uncertain as to _where_ the limit of 9 bytes applies; it's the formal 
definition and MarcEdit probably respects that (I only have a very old version, 
and know very little about it, so cannot properly verify) but I don't think 
MySQL has any hard limits, nor has Koha unless I'm mistaken. 
Not at all sure about Zebra...

I've just looked at one rather large record 

but it has only 94 items (and MarcEdit swallows it, but it's only 31242 bytes, 
so nowhere near "the limit."

We're looking at quite a few serial runs of over 100 years of monthly issues! 
already in ODS format so a direct import into MySQL might be the fastest way. I 
keep pushing this project to the back of the queue, but will have to face it 
sooner or later.

Paul


>You could try compiling to MARCXML, but I don't think the file importer 
>for Koha can handle MARCXML.
>
>The closest I got to creating a massive MRC serials record was to use 
>YAZ-MARCDUMP (http://www.indexdata.com/yaz/doc/yaz-marcdump.html) to 
>convert the big MARCXML record into MARC21. It seemed to compile but it 
>was hard to tell. It wasn't valid MARC after all, and I couldn't 
>exactly look at it in MARCEDIT.
>
>Regards,
>Karl Holten
>Systems Integration Specialist
>SWITCH Inc
>414-382-6711
>
>-Original Message-
>From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Paul A
>Sent: Thursday, April 28, 2016 2:39 PM
>To: koha 
>Subject: Re: [Koha] Best practices for koha - journal migration using 
>marcedit
>
>At 08:24 PM 4/28/2016 +0530, Indranil Das Gupta wrote:
>[snip
> > > I would like to know how to covert excel data of journals 
> > > especially with large number of issues(having more than 600 
> > > issues) for each journal. Tried using marcedit and it is giving 
> > > error - 501 when trying to covert mrk to mrc format.
>[snip]
> > > Is there any other way how I can covert this data to mrc format.
> >
> >Yes, if you do programming or have access to a programmer adept at 
> >handling MARC21 data, you can.
>
>If you have details, please make them available. We looked into this 
>(again after MarcEdit attempts), but ran into problems (from memory,
>more_subfields_xml) ... and we've got about .25 million items to add 
>;=}
>
>Thanks -- Paul
>
>___
>Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
>https://lists.katipo.co.nz/mailman/listinfo/koha

---
Maritime heritage and history, preservation and conservation, research and 
education through the written word and the arts.
 and 

___
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] Search By Barcode having 1, 2 or 3 digit not working in Koha 3.20 or in 3.22

[Katrin Fischer]

Hi,

How are you searching for the barcode?
Did you turn on the QueryAutoTruncate system preference?

Hope this helps,

Katrin

Am 29.04.2016 um 13:16 schrieb Sunil Sharma:
> Hello Friends,
> 
> I checked both Koha 3.20.x as well as Koha 3.22.x on Debian 8 OS, Zebra
> version 2.0.61. My other search is working fine but when I search any
> barcode having 1, 2 or 3 digit, the search result page will not reflect
> proper search result both in Koha OPAC as well as on Staff-Admin page.
> 
> For example, when I search 123 it will give the records having barcode as
> 1231, 1232, 1233, same as if I will search for barcode 121 then it will
> give result for biblio having accession no. 121220, 121121 and so on. Even
> these barcodes (121 or 123) are present in Koha.
> 
> Any pointers would be of help.
> 

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

[Koha] Search By Barcode having 1, 2 or 3 digit not working in Koha 3.20 or in 3.22

[Sunil Sharma]

Hello Friends,

I checked both Koha 3.20.x as well as Koha 3.22.x on Debian 8 OS, Zebra
version 2.0.61. My other search is working fine but when I search any
barcode having 1, 2 or 3 digit, the search result page will not reflect
proper search result both in Koha OPAC as well as on Staff-Admin page.

For example, when I search 123 it will give the records having barcode as
1231, 1232, 1233, same as if I will search for barcode 121 then it will
give result for biblio having accession no. 121220, 121121 and so on. Even
these barcodes (121 or 123) are present in Koha.

Any pointers would be of help.

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

[Koha] Merge Records via List not working in Koha 3.22.x

[Sunil Sharma]

Hello Friends,

I am using Koha 3.22.5 on Debian 8 OS.

I have many duplicate title in my catalog, So I want to merge such records
through Koha List module using merge function, At the end of the process it
will show succesfully merged. But in actual it will neither merge items
from source to destination record nor it will delete the other records
except reference as it worked in previous version Koha 3.18 or koha 3.20.

Any pointers would be of help.

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

Re: [Koha] Documentation for SIP2 support

[Chris Cormack]

On 29 April 2016 at 19:46, Hans Hvelplund Odborg
 wrote:
> Thanks.
>
> There's not much information about what fields KOHA supports on those pages.
>
> If anyone can point me to further documentation as to what is support I would 
> be grateful.
> E.g
> Which of the optional fields are supported, in the different type of messages,
> Explanation of non-standard fields?
>

Hi Hans

Have a look at
http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=C4/SIP/Sip/Constants.pm;h=fb48c333c6c0b78f96690e502ae7935a59a6c16f;hb=2026be47fd79fb15f1e9fb83be34403e8eb18079

and

http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=C4/SIP/Sip/MsgType.pm;h=7728ed43d40d4181181a4fec4f0c2327d3717499;hb=2026be47fd79fb15f1e9fb83be34403e8eb18079

For a canonical list, hopefully that helps

BTW It is Koha (a word not an acronym ;))

Chris


>
> Hans Hvelplund Odborg
> VP Software Development
> e: h.h.odb...@bibliotheca.com
> t: +45 30 23 59 40 | m: +45 30 23 59 40
> linkedIn | facebook | youtube | website
> Vallensbækvej 22A, 2. th. | DK – 2605 Brøndby | Danmark
>
> bibliotheca
> -Original Message-
> From: Indranil Das Gupta [mailto:indr...@gmail.com]
> Sent: Thursday, April 28, 2016 8:49 PM
> To: Hans Hvelplund Odborg 
> Cc: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Documentation for SIP2 support
>
> Hi,
>
> On Thu, Apr 28, 2016 at 10:56 PM, Hans Hvelplund Odborg
>  wrote:
>
>> Where can I find documentation for KOHA SIP2 support ?
>
> 1) https://wiki.koha-community.org/wiki/Koha_SIP2_Server_Capabilities
>
> 2) https://wiki.koha-community.org/wiki/Koha_SIP2_server_setup
>
> cheers
> -indranil
>
> --
> Indranil Das Gupta
>
> Phone : +91-98300-20971
> IRC  : indradg on irc://irc.freenode.net
> Twitter : indradg
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-
> Please exchange editable Office documents only in ODF Format. No other
> format is acceptable. Support Open Standards.
>
> For a free editor supporting ODF, please visit LibreOffice -
> http://www.documentfoundation.org
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Report of staff login reg.

[arun kishore]

Hi,
Could anyone help me out with an SQL query for getting staff record 
creation/modification statistics along with date of creation and barcode of 
items? With kind regards,

Arun Kishore, B.L.

 College Librarian (UGC)
Sanatana Dharma College
Sanathanapuram (PO)
Alappuzha
Keralam -  688003

Phone (O): 0477 - 2268450
Phone (R):  0476 - 2691951
Mobile:  +91 9496621951

Linkedin | Facebook
Web: www.sdcollege.in
.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Documentation for SIP2 support

[Hans Hvelplund Odborg]

Thanks.

There's not much information about what fields KOHA supports on those pages.

If anyone can point me to further documentation as to what is support I would 
be grateful.
E.g
Which of the optional fields are supported, in the different type of messages, 
Explanation of non-standard fields?


Hans Hvelplund Odborg
VP Software Development
e: h.h.odb...@bibliotheca.com
t: +45 30 23 59 40 | m: +45 30 23 59 40
linkedIn | facebook | youtube | website
Vallensbækvej 22A, 2. th. | DK – 2605 Brøndby | Danmark

bibliotheca
-Original Message-
From: Indranil Das Gupta [mailto:indr...@gmail.com] 
Sent: Thursday, April 28, 2016 8:49 PM
To: Hans Hvelplund Odborg 
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] Documentation for SIP2 support

Hi,

On Thu, Apr 28, 2016 at 10:56 PM, Hans Hvelplund Odborg
 wrote:

> Where can I find documentation for KOHA SIP2 support ?

1) https://wiki.koha-community.org/wiki/Koha_SIP2_Server_Capabilities

2) https://wiki.koha-community.org/wiki/Koha_SIP2_server_setup

cheers
-indranil

-- 
Indranil Das Gupta

Phone : +91-98300-20971
IRC  : indradg on irc://irc.freenode.net
Twitter : indradg

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-
Please exchange editable Office documents only in ODF Format. No other
format is acceptable. Support Open Standards.

For a free editor supporting ODF, please visit LibreOffice -
http://www.documentfoundation.org
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] translate site could not access

[BWS Johnson]

Salvete!



> For your information, I could not access
> http://translate.koha-community.org/ from Taiwan, at the time
> 2016.4.19 04:06 GMT
> 
> -- 
> Wishing you all the best. . . .

> 


 It's down for me too at 3.08EST, and I get a down from Down for Everyone 
or Just Me.

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

[Koha] rebuild index

[regina kivuyo]

when i tried  to run the  env KOHA_CONF=/etc/koha/koha-conf.xml
PERL5LIB=/usr/share/koha/lib /usr/share/koha/bin/migration_tools/
rebuild_zebra.pl -b -r -v

it give me error

Unable to load Koha::NorwegianPatronDB at /usr/share/koha/lib/C4/Members.pm
line 49.
Warning: You are running this script as the user 'root'.
If this is intentional you must explicitly specify this using the
-run-as-root switch
Please do '/usr/share/koha/bin/migration_tools/rebuild_zebra.pl --help' to
see usage.

im using ubuntu 12.04
koha 3.18

downloaded package
help please



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