Re: [Koha] Importing WINISIS data into Koha

[Stowasser Rainer]

Hy Alex

I had the same "problem"

What I did was to generate the MARC records outside of Koha 
using Catmandu, MarcEdit
and then import them into Koha

As I understand there is not much in Koha for conversion from other systems
but if you have it up
it works perfect ;-)

Best regards
Hofrat Mag. Rainer Stowasser
Head of Library ZAMG


Von: Koha [koha-boun...@lists.katipo.co.nz] im Auftrag von Alex 
Shepherd [kiwi64...@gmail.com]
Gesendet: Dienstag, 05. Dezember 2017 05:42
An: koha@lists.katipo.co.nz
Betreff: [Koha] Importing WINISIS data into Koha

Hi Team,

I’ve been asked to migrate some library data currently in WINISIS into Koha and 
just wondered if anyone has been down this path recently and can share any 
advice or tools or recipe etc they used?

I’ve previously done one conversion from the XML file that WINISIS can export 
to, into MARC records via perl + MARC library, for a non-Koha system a number 
of years ago, but am hoping there might be some better alternatives now… ;)

Any help or advice would be much appreciated.

Regards

Alex Shepherd

p: +64-7-829 4441
m: +64-21-64
e: kiwi64...@gmail.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] koha tag 082, itemcallnumber

[Zeno Tajoli]

Hi all,

>Only you have diagnosed my problem,
>
>Can you help and guide me how it can be
>fixed/changed in the code??
>
>Javed

if you go here:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9156#c4
you find the starting info to write a patch.

Cheers
Zeno Tajoli


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

Re: [Koha] koha tag 082, itemcallnumber

[Javed Sahil]

Hi Katrin,

Only you have diagnosed my problem,

*Bug 9156*
 -
itemcallnumber not pulling more than 2 subfields

Can you help and guide me how it can be
fixed/changed in the code??

Javed

On Dec 5, 2017 1:26 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. email status changes to "failed". (Javed Sahil)
>2. Re: Does Koha has a web service API or search API for
>   searching books on different input parameters (Eric Phetteplace)
>3. MARC field and heading validation with Koha (Reichert, Kumiko)
>4. Look for records with specific info in a mark field
>   (Alvaro Cornejo)
>5. Re: Look for records with specific info in a mark field
>   (Katrin Fischer)
>6. Re: Please help this newbie :) (Katrin Fischer)
>7. Re: Tag 082, itemcallnumber (Katrin Fischer)
>
>
> --
>
> Message: 1
> Date: Mon, 4 Dec 2017 19:56:37 +0500
> From: Javed Sahil 
> To: koha@lists.katipo.co.nz
> Subject: [Koha] email status changes to "failed".
> Message-ID:
>  ail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> Hello everyone!
> I want koha to send emails to patrons for circulation transactions
> like check out, check in, overdue etc. I have installed postfix.
> Everything is set I can send emails from commands line.
>
> but in patron accounts email status is "pending".
>
> When I use following commands.
>
> 1.koha-shell library
> 2.export PERL5LIB="/usr/share/koha/lib"
> 3.export KOHA_CONF="/etc/koha/sites/library/koha-conf.xml"
> 4.cd /usr/share/koha/bin/cronjobs
>
> above all go fine, but when i use following command:
>
> 5../process_message_queue.pl
>
> this error message appears:
>
> connect to localhost failed (Connection refused)
> connect to localhost failed
> connect to localhost failed (Connection refused) no (more) retries!
>  at ./process_message_queue.pl line 66.
>
>
> Then in patron accounts, email status changes to "failed".
>
> Help Plz.
>
>
> --
>
> Message: 2
> Date: Mon, 4 Dec 2017 09:45:19 -0800
> From: Eric Phetteplace 
> To: prachim 
> Cc: Koha 
> Subject: Re: [Koha] Does Koha has a web service API or search API for
> searching books on different input parameters
> Message-ID:
> 

[Koha] Importing WINISIS data into Koha

[Alex Shepherd]

Hi Team,

I’ve been asked to migrate some library data currently in WINISIS into Koha and 
just wondered if anyone has been down this path recently and can share any 
advice or tools or recipe etc they used?

I’ve previously done one conversion from the XML file that WINISIS can export 
to, into MARC records via perl + MARC library, for a non-Koha system a number 
of years ago, but am hoping there might be some better alternatives now… ;)

Any help or advice would be much appreciated.

Regards

Alex Shepherd

p: +64-7-829 4441
m: +64-21-64
e: kiwi64...@gmail.com

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

Re: [Koha] Tag 082, itemcallnumber

[Katrin Fischer]

Hi Javed,

I think you have run into an old bug:

*Bug 9156* 
 - 
itemcallnumber not pulling more than 2 subfields


There is nothing you can do with configuration, this has to be 
fixed/changed in the code.


Katrin


On 04.12.2017 13:26, Javed Sahil wrote:

Hi all,

In koha preferences,

 itemcallnumber:   082ab  works fine.

  itemcallnumber:   082cd also works fine.


 itemcallnumber:   082abcd  does not work.

Only first two subfields work with 082 tag.

I wan to use four subfields  abcd,
How it will be possible?
___
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] Please help this newbie :)

[Katrin Fischer]

Hi Johan,

with the default configuration Koha won't search for records with 
non-latin characters correctly, but this can be fixed - you will have to 
switch to ICU for indexing. Instructions can be found on the wiki:


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

If it doesn't work at all, even for your German and English records, 
there might be another problem. Did you specify UNIMARC when creating 
the instance (defaults to MARC21)? Or only in the web installer? If the 
first was missed, your indexing configuration won't match your data 
which could also explain problems.


Hope this helps,

Katrin


On 04.12.2017 09:35, Johan Seyfferdt wrote:

Hello.

Thank you for adding me to this mailing list.

I have a question.

I am a sysadmin in St Petersburg, Russia and we are in the process of
moving to Koha.  So I am a newbie :)

I chosed the unimarc option as our database is in rusmarc.  We have our
database in .mrc format,  it is about 27 000 books in cyrilic, english and
german.

I was able to setup koha import that database but the search function does
not work.

I did a lot of googling, i tried kooha 16.05, 16.11, 17.05 on Debain 8 and
9 but without avail...

Any help will be truly appreciated! as i am truly stuck.
___
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] Look for records with specific info in a mark field

[Katrin Fischer]

Hi Alvaro,

yes, Koha stores the complete record as MARCXML and only some fields are 
mapped to database columns. You can see the mappings in Administration > 
Koha to MARC mappings. Be careful, after changing it you need to run a 
script to populate database fields correctly. The MARC record is stored 
in either biblioitems.marcxml (older versions) or 
biblio_metadata.metadata (current versions) and can be queried using the 
ExtractValue function. You can find examples in the reports library on 
the wiki:


https://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC

Hope this helps,

Katrin


On 04.12.2017 21:03, Alvaro Cornejo wrote:

Hi

How can I do a MySQL search for all the records/items with an specific
value in an specific marc field Xx?

I've looked at the bilblio and related tables but I'm unable to find a
table with marcs fields info. I saw some marcxml fields however; are marc
values stored there and I need to xlmparse that info to get an specific
value?

Regards

Alvaro
___
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] Look for records with specific info in a mark field

[Alvaro Cornejo]

Hi

How can I do a MySQL search for all the records/items with an specific
value in an specific marc field Xx?

I've looked at the bilblio and related tables but I'm unable to find a
table with marcs fields info. I saw some marcxml fields however; are marc
values stored there and I need to xlmparse that info to get an specific
value?

Regards

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

[Koha] MARC field and heading validation with Koha

[Reichert, Kumiko]

Hello all,


I apologize for cross-posting.  My library's Koha will go live next month, and 
I am now in training.  I hope you don't mind questions from a newbie.


How do you validate MARC fields and headings/access points based on the local 
authority database (1XX, 6XX, 7XX and 8XX) with Koha?  If Koha does not have 
the functionality, how do you manage validation?


Sincerely yours,

Kumiko


Kumiko Reichert

Metadata and Cataloging Librarian

Maxwell Library

Bridgewater State University

10 Shaw Road

Bridgewater, MA 02325

kumiko.reich...@bridgew.edu

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

Re: [Koha] Does Koha has a web service API or search API for searching books on different input parameters

[Eric Phetteplace]

Hi Prachi,

Koha's SRU protocol implementation is probably the closest thing to a
search API:
https://koha-community.org/manual/17.05/html/18_miscellaneous.html#using-the-sru-server

That manual page also describes other web services that Koha provides but
none are specifically search. Is there a reason why searching on the Koha
website couldn't fulfill your client's needs? I must admit I don't really
see the value in designing an app to accomplish something that the website
already does.

Best,

ERIC PHETTEPLACE

Systems Librarian


libraries.cca.edu | vault.cca.edu | 510.594.3660

5212 Broadway, Oakland, CA 94618

 8th St., San Francisco, CA 94107

Preferred Pronoun(s): he/him

:(){ :|: & };:

On Sun, Dec 3, 2017 at 5:38 AM, prachim  wrote:

> Hi,
>
> One of our client is a college. They are already using Koha for their
> library management.
> We are developing an android application for their students using which
> they
> can search for a book in first phase. This android app will send user
> queries to our back-end server, the back-end is developed in Java.
> We are expected to take input criteria specified by student (e.g.title,
> author, publisher etc.) and search for the book and its availability.
> So is there any web service API or search API by Koha for searching books
> on
> different input parameters?
> What kind of authentication need to be provided to access data specific to
> this college?
>
>
>
> --
> 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] email status changes to "failed".

[Javed Sahil]

Hello everyone!
I want koha to send emails to patrons for circulation transactions
like check out, check in, overdue etc. I have installed postfix.
Everything is set I can send emails from commands line.

but in patron accounts email status is "pending".

When I use following commands.

1.koha-shell library
2.export PERL5LIB="/usr/share/koha/lib"
3.export KOHA_CONF="/etc/koha/sites/library/koha-conf.xml"
4.cd /usr/share/koha/bin/cronjobs

above all go fine, but when i use following command:

5../process_message_queue.pl

this error message appears:

connect to localhost failed (Connection refused)
connect to localhost failed
connect to localhost failed (Connection refused) no (more) retries!
 at ./process_message_queue.pl line 66.


Then in patron accounts, email status changes to "failed".

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

Re: [Koha] Email status changes failed from pending

[Paul Hoffman]

On Sun, Dec 03, 2017 at 04:05:23PM +0500, Javed Sahil wrote:
> Hello everyone!
> I want koha to send emails to patrons for circulation transactions
> like check out, check in, overdue etc. I have installed postfix.
> Everything is set I can send emails from commands line.
> 
> but in patron accounts email status is "pending".
> 
> When I use following commands.
> 
> 1.koha-shell library
> 2.export PERL5LIB="/usr/share/koha/lib"
> 3.export KOHA_CONF="/etc/koha/sites/library/koha-conf.xml"
> 4.cd /usr/share/koha/bin/cronjobs
> 
> above all go fine, but when i use following command:
> 
> 5../process_message_queue.pl
> 
> this error message appears:
> 
> connect to localhost failed (Connection refused)
> connect to localhost failed
> connect to localhost failed (Connection refused) no (more) retries!
>  at ./process_message_queue.pl line 66.

It sounds as though Postfix is not listening on port 25.  Please run the 
following command (as root) and send us the output: 

netstat -tnlp | fgrep master

And please send us the output of this command, too:

uname -a

Paul.

-- 
Paul Hoffman 
Software Manager
Fenway Library Organization
550 Huntington Ave.
Boston, MA 02115
(617) 442-2384 (FLO main number)
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Email status changes failed from pending

[Mark Alexander]

Excerpts from Javed Sahil's message of 2017-12-03 16:05:23 +0500:
> 5../process_message_queue.pl
> 
> this error message appears:
> 
> connect to localhost failed (Connection refused)

This sounds to me like a postfix configuration problem.

What happens when you try this?

  telnet localhost 25

This should connect to the postfix SMTP server.

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

Re: [Koha] Disabling "Display News From" Option

[Owen Leonard]

> I have a Koha site with a single branch. I would like to disable the
> "Display News From" option on the OPAC Home Page.

There is a system preference which should turn that off:  OpacNewsLibrarySelect

-- Owen


-- 
Web Developer
Athens County Public Libraries
http://www.myacpl.org
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Tag 082, itemcallnumber

[Javed Sahil]

Hi all,

   In koha preferences,

itemcallnumber:   082ab  works fine.

 itemcallnumber:   082cd also works fine.


itemcallnumber:   082abcd  does not work.

Only first two subfields work with 082 tag.

I wan to use four subfields  abcd,
How it will be possible?
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Please help this newbie :)

[Pedro Amorim]

Hello Johan,

I'd suggest following the instructions as per in the documentation:
https://wiki.koha-community.org/wiki/Troubleshooting_Zebra#Searching_and_Searching_Issues

Namely, does connecting with yaz work?
yaz-client -c /etc/koha/zebradb/ccl.properties unix:/var/run/koha/
**/bibliosocket

Or have you tried searching after a zebra rebuild?
koha-rebuld-zebra -f -v **

GL,

Pedro Amorim

On 4 December 2017 at 07:35, Johan Seyfferdt  wrote:

> Hello.
>
> Thank you for adding me to this mailing list.
>
> I have a question.
>
> I am a sysadmin in St Petersburg, Russia and we are in the process of
> moving to Koha.  So I am a newbie :)
>
> I chosed the unimarc option as our database is in rusmarc.  We have our
> database in .mrc format,  it is about 27 000 books in cyrilic, english and
> german.
>
> I was able to setup koha import that database but the search function does
> not work.
>
> I did a lot of googling, i tried kooha 16.05, 16.11, 17.05 on Debain 8 and
> 9 but without avail...
>
> Any help will be truly appreciated! as i am truly stuck.
> ___
> 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] Please help this newbie :)

[Johan Seyfferdt]

Hello.

Thank you for adding me to this mailing list.

I have a question.

I am a sysadmin in St Petersburg, Russia and we are in the process of
moving to Koha.  So I am a newbie :)

I chosed the unimarc option as our database is in rusmarc.  We have our
database in .mrc format,  it is about 27 000 books in cyrilic, english and
german.

I was able to setup koha import that database but the search function does
not work.

I did a lot of googling, i tried kooha 16.05, 16.11, 17.05 on Debain 8 and
9 but without avail...

Any help will be truly appreciated! as i am truly stuck.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha