[Koha] SQL report - Date issues

[Kerrie Stevens]

I have a report that picks out items that have no contents (505) added and also 
have no date entered. The problem is that the report is picking up materials 
that do have dates entered in both the 260 or 264 fields, so it is not working 
100% correctly.

Can anyone give me some pointers to get it working properly?

SELECT biblioitems.biblionumber, biblio.copyrightdate, biblioitems.marcxml
FROM biblioitems
JOIN biblio
ON biblioitems.biblionumber=biblio.biblionumber
WHERE biblioitems.marcxml not like "%505%" and biblio.copyrightdate is null
ORDER BY biblio.copyrightdate desc

Results that come back includes bibs with date entries in the 260 and 264 
fields - why would they be selected as having nothing in the date field, when 
they clearly do? Eg: both formats: '1958' or '[19--]' might appear in the fields

Thanks for any help you may provide...


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

[Koha] Koha Development IRC Meeting reminder - March 8, 19 UTC

[Nick Clemens]

HI All!

Just a reminder that tomorrow at 19 UTC is the next Koha Developers IRC
meeting.

Conversion to local time here:
https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Developers+IRC+Meeting=20170308T19

The agenda is here:
https://wiki.koha-community.org/wiki/Development_IRC_meeting_8_March_2017

Please add any items you wish to talk about to the wiki.

I am at code4lib this week so will miss the meeting - I hope someone will
volunteer to chair :-)

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

[Koha] Courtesey reminder: tomorrow is Koha-US March meeting

[Christopher Davis]

Hello Colleagues,

I would like to invite you to the March 2017 meeting of Koha-US held
at 10:30 am Central Time at https://kslib.zoom.us/j/450230564. The
agenda for this meeting is found at
http://koha-us.net/index.php/Minutes2017-03-08; if you would like to
add an item to this agenda, then please email your idea to me at the
email address provided below. Since this is a web meeting, it is
suggested that you use a microphone and webcam. I hope to see you at
this meeting.

Cordially,

Christopher Davis
Secretary, Koha-US
cgda...@uintah.utah.gov
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Can't access my newly installed koha

[King, Fred]

Sounds like you need to go to the staff page and do the final setup. I think 
you're at this point in the setup:
   
https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Web_Installation

Get the password (the line beginning with sudo xmlstarlet), go to the staff 
page (depends on how you set it up, mine's set up on Port 8080), log in as 
koha_(instancename), and take it from there.

Fred King
Medical Librarian, MedStar Washington Hospital Center
fred.k...@medstar.net
202-877-6670
ORCID -0001-5266-0279

If Teresa May put out a cigarette on her tongue it would make me feel a a lot 
better about her being Prime Minister.
--Susan Calman (News Quiz, BBC Radio 4)


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Javed Sahil
Sent: Thursday, March 02, 2017 4:58 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] Can't access my newly installed koha

-- Forwarded message --
From: "Javed Sahil" 

Date: Mar 2, 2017 2:55 PM
Subject: Can't access my newly installed koha
To: 
Cc:

Hello Seniors,
> I am new to koha, I installed Unbuntu Server 16.04 LTS and then Koha, 
> as instructed on koha website. But when i try to access my koha on 
> another machine, it says: (Screenshot Attached).
> System Maintenance
>
> The Koha online catalog is offline for system maintenance. We'll be 
> back soon! If you have any questions, please contact the site 
> administrator
>
> I need your help plz.
>
___
Koha mailing list  
https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.org=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=veui-bX2aGAirjHC8EU7xVk9a_nb0kPPqPfHxtdL4KU=0iywYImho0fewjSMdH__UL2LDrFfAxBacdo4um3jbOk=
Koha@lists.katipo.co.nz
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.nz_mailman_listinfo_koha=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=veui-bX2aGAirjHC8EU7xVk9a_nb0kPPqPfHxtdL4KU=uhVezT0UJ4V06WoRl_-2o-Lnk_jwF4BZgmXZVHySIfc=
 

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

Re: [Koha] How to print custom slips from Koha

[Nat is]

No idea if this list is still active, but I am having the same problem as
OP. I have created custom slips but they are not appearing in the Print
drop down menu. Is there some special mojo magic I missed?

Running Koha 3.18. Yes, really...

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

[Koha] Fields B_address and B_address2 of Patrons' File Does Not Display Content when I Create Patron Card

[OLUFUNMILAYO FATI]

Hello All,

I have put   in the text box of one of the fields
in "Edit Layout" Window. When I opened the resulting PDF file generated
from managing batches, exact texts in the field's text box were returned
just as they were input instead of displaying the values in the fields.
However, when I input  in the textbox of the same field, and I ran
the Batch export, it display the correct values.

What could be wrong with the fields  and . Any help
about this please?

Your advice will be appreciated.

Thank you.

Olufunmilayo FATI
University of Jos Library
Nigeria
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Can't access my newly installed koha

[Javed Sahil]

-- Forwarded message --
From: "Javed Sahil" 
Date: Mar 2, 2017 2:55 PM
Subject: Can't access my newly installed koha
To: 
Cc:

Hello Seniors,
> I am new to koha, I installed Unbuntu Server 16.04 LTS and then Koha, as
> instructed on koha website. But when i try to access my koha on another
> machine, it says: (Screenshot Attached).
> System Maintenance
>
> The Koha online catalog is offline for system maintenance. We'll be back
> soon! If you have any questions, please contact the site administrator
>
> I need your help plz.
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Search by Title 245 subfields $a $b only

[Layale Bassil]

Hello,

I know it is an old question but I am facing a similar issue. I need to exclude 
only the 780$t and 785$t. which means when I specify title in the drop down 
search by, I don’t want the search to look into 780$t and 785$t however I want 
the search to search by 780$t and 785$t when I select search by keywords.

How should I edit biblio-koha-indexdefs.xml file to apply this condition?

Thank you in advance,
Reagrds.

-Original Message-
From: janus...@gmail.com [mailto:janus...@gmail.com] 
Sent: Saturday, December 3, 2016 10:20 PM
To: Layale Bassil ; koha@lists.katipo.co.nz
Subject: RE: [Koha] Search by Title 245 subfields $a $b only

Hi Layale,

Depending on what type of installation you have, you would probably have to 
edit /etc/koha/zebradb/marc_defs/marc21/biblios/biblio-koha-indexdefs.xml and 
then transform it into biblio-zebra-indexdefs.xsl (or directly edit 
biblio-zebra-indexdefs.xsl).  But -- again, depending on the type of your 
installation -- be aware of possible problems with upcoming updates. 

Good luck!

Janusz


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Layale Bassil
Sent: Friday, December 2, 2016 5:23 PM
To: 'koha@lists.katipo.co.nz'
Subject: [Koha] Search by Title 245 subfields $a $b only
Importance: High

Hello,

I need to know how can I edit the Zebra search in order to only search by 
subfields a and b when searching by title 245?

The search is currently searching other subfields like c and returning 
non-relevant results.

What files should I edit in this case?

Thank you in advance,
Regards.
___
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] is koha right for our project run by volunteers?

[King, Fred]

Hello Rebecca!

First of all, I should say that like everybody else on this list I'm biased--I 
think Koha is wonderful, user-friendly, and a great product. That it's free and 
open-source is icing on the cake. It's also supported by a great bunch of 
people.

Still, as much as I love it, I wouldn't recommend Koha unreservedly for 
everyone for all purposes. It's a fully-functional ILS, and it does take a 
little time and effort to learn. A few considerations:

What do you want to use it for? Do you want an online catalog for in-house use, 
or will it be available to the public? If the latter, you'll need a server 
connected to the outside Internet. I don't know what services are available in 
the UK; for some of my Koha projects I use Digital Ocean (U.S. based but with 
servers in Europe as well)--they charge as little as USD$5 per month for their 
most basic service. For that you get a server and operating system (Linux), you 
install and set up Koha yourself. If you want to run it on your synagogue's 
Intranet, it's a bit easier.

What kind of computer experience do the people in your group have? Once Koha is 
set up, it pretty much runs itself, but it does need some occasional tending. 
You need to do upgrades every now and then, log files fill up--things like 
that. Nothing horribly complicated, but it helps to know very basic Linux 
commands. There's probably someone in your synagogue who could help you.

Cataloging the books: as a couple of people have said, you can use Z39.50 to 
get a lot of catalog records so you don't have to do original cataloging on 
each one of your 4000 books. But the more obscure* your books are, the less 
likely it is that you'll be able to find records--you'll probably have to do 
some cataloging as well as edit the records you download. But then, you'd have 
to do something similar with any system you choose.

Back in 2013 I was able to set up Koha and migrate our data from our old system 
by myself. (We have approximately the same ILS budget that you do.) I had 
minimal experience with Linux (we're using Ubuntu) and it was the first time I 
had set up an ILS. But then, I'm a geek.** I've been using computers since the 
late 1970s and I seem to have a knack for it. I also think this kind of thing 
is fun.

As I said, once you have Koha up and running, it doesn't require a lot of 
tending and it's easy to use. You don't have to learn everything at once, or at 
all--if you need to refresh your mind as to how something works, the 
information is usually available.

But let me go back to my second paragraph--Koha isn't for everyone and it may 
be more than you need. I'm on another listserv where people occasionally ask 
about affordable software for a small library. Though I always recommend Koha, 
a lot of people there decide to go with LibraryThing, mainly because they find 
it easier to use and they don't need all the (wonderful!) features that Koha 
provides.

Rebecca, feel free to contact me off-list if you'd like more information. 
Everyone else, comments welcome, on- or off-list.

Fred King
Medical Librarian, MedStar Washington Hospital Center
fred.k...@medstar.net
202-877-6670
ORCID -0001-5266-0279

If Teresa May put out a cigarette on her tongue it would make me feel a a lot 
better about her being Prime Minister.
--Susan Calman (News Quiz, BBC Radio 4)

*For example, I have a collection of 1000+ cartoon books--New Yorker, Lawrence 
Lariar's yearly collections, etc. If I ever get around to putting them in Koha, 
I don't think I'll find a whole lot of them via Z39.50. I could be wrong. Right 
now they're in storage, so it's going to be a while before I find out.
**My front teeth are chipped from biting the read-write heads off hard 
drives.***
***That joke might not travel well. See https://en.wikipedia.org/wiki/Geek_show
***Told you I was a geek. :-)


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Rebecca Shtasel
Sent: Tuesday, March 07, 2017 9:30 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] is koha right for our project run by volunteers?

Hello

We are a small group of volunteers (one of whom is a retired school
librarian) who run our synagogue's library in the UK.  We would like to produce 
an online catalogue and are interesting in using Koha for this purpose as we 
haven't much money.  The library has about 4000 books covering a variety of 
classifications (fiction, history etc) all related to Judaism.  The original 
accessions book was lost when the library had to be moved a year ago and we 
have a notebook with handwritten entries for the accessions we have received 
since the library moved to its new home.
Looking at the information to do with koha it appears very technical and we are 
wondering if we will be able to use it for our catalogue.  We would literally 
be taking books off the shelves to input their information, not importing the 
data from elsewhere and  none of us has anything more than 

Re: [Koha] is koha right for our project run by volunteers?

[Mark Tompsett]

Greetings,

I would say yes!


My 7 year old son was able to understand how to catalog some of his books 
using Z39.50 (https://tml.tulongaklatan.ph/). Though, he has some books 
through Scholastic which issue their own ISBN numbers for existing books, so 
you have to get a little creative in finding it by the Title, and then 
adding the extra ISBN number, but that really is about the most complex 
we've had to do. Generally, the ISBN search has worked well, though 
sometimes we had to search both the ISBN-13 and ISBN-10 numbers before 
finding something.

The Z39.50 functionality of Koha makes entry easy, by importing the entries 
from an external source which already has the entered data. I would 
recommend trying that. You will need to go item by item, but given that you 
have to manually catalog the whole library, I don't think that is going to 
be a big problem.

GPML,
Mark Tompsett

-Original Message- 
From: Rebecca Shtasel
Sent: Tuesday, March 07, 2017 9:29 AM
To: koha@lists.katipo.co.nz
Subject: [Koha] is koha right for our project run by volunteers?

Hello

We are a small group of volunteers (one of whom is a retired school
librarian) who run our synagogue's library in the UK.  We would like to
produce an online catalogue and are interesting in using Koha for this
purpose as we haven't much money.  The library has about 4000 books
covering a variety of classifications (fiction, history etc) all related to
Judaism.  The original accessions book was lost when the library had to be
moved a year ago and we have a notebook with handwritten entries for the
accessions we have received since the library moved to its new home.
Looking at the information to do with koha it appears very technical and we
are wondering if we will be able to use it for our catalogue.  We would
literally be taking books off the shelves to input their information, not
importing the data from elsewhere and  none of us has anything more than
basic computing knowledge.

Given this, do you think koha is too complicated for us to use or amongst
all the information related to using koha is there a very basic guide that
would suit beginners like us?
If you think we would struggle using koha, could you advise us on software
that you think would be more user-friendly and is not too expensive?

Thanking you all very much in advance for any advice you can give.

Rebecca (on behalf of the group)
___
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] is koha right for our project run by volunteers?

[vikram zadgaonkar]

Hello Rebecca,
koha is very simple to use and maintain. Being a community software you get
support from all community members.

I strongly suggest koha.

On 7 Mar 2017 8:00 p.m., "Rebecca Shtasel"  wrote:

> Hello
>
> We are a small group of volunteers (one of whom is a retired school
> librarian) who run our synagogue's library in the UK.  We would like to
> produce an online catalogue and are interesting in using Koha for this
> purpose as we haven't much money.  The library has about 4000 books
> covering a variety of classifications (fiction, history etc) all related to
> Judaism.  The original accessions book was lost when the library had to be
> moved a year ago and we have a notebook with handwritten entries for the
> accessions we have received since the library moved to its new home.
> Looking at the information to do with koha it appears very technical and we
> are wondering if we will be able to use it for our catalogue.  We would
> literally be taking books off the shelves to input their information, not
> importing the data from elsewhere and  none of us has anything more than
> basic computing knowledge.
>
> Given this, do you think koha is too complicated for us to use or amongst
> all the information related to using koha is there a very basic guide that
> would suit beginners like us?
> If you think we would struggle using koha, could you advise us on software
> that you think would be more user-friendly and is not too expensive?
>
> Thanking you all very much in advance for any advice you can give.
>
> Rebecca (on behalf of the group)
> ___
> 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] Zebra server is not running

[Luis Moises Rojas]

Take a look at this.

We still have problem with the z39 protocol.
What we did was this:
We installed a server (ubuntu)
We installed koha from zero
Then we made a test: Everything FINE!!

But, listen this

As soon as we make a these procedure to restore the DB from production to
the new server (remember it was working OK)
everything stopped.

mysql -u root -p koha_library < koha_library.sql
sudo su
koha-upgrade-schema library
sudo koha-rebuild-zebra -b -a -v -f library

On Mon, Feb 13, 2017 at 3:52 PM, Mark Alexander  wrote:

> Excerpts from Luis Moises Rojas's message of 2017-02-13 10:15:24 -0400:
> > When i see KOHA ABOUT its says:Zebra service is not running
> >
> > But when we try to restart o star using koha-zebra-restart or start: say
> >
> > Zebra is already running?
> >
> > Where is the problem?
> >
> > Is this the cause (maybe) why we have to run the koha-rebuild every
> morning?
>
> This may be the problem:
>
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16885
>
> See this for a possible fix:
>
> https://lists.katipo.co.nz/pipermail/koha/2016-September/046167.html
>
>


-- 
*Luis Moisés Rojas P.*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] is koha right for our project run by volunteers?

[Rebecca Shtasel]

Hello

We are a small group of volunteers (one of whom is a retired school
librarian) who run our synagogue's library in the UK.  We would like to
produce an online catalogue and are interesting in using Koha for this
purpose as we haven't much money.  The library has about 4000 books
covering a variety of classifications (fiction, history etc) all related to
Judaism.  The original accessions book was lost when the library had to be
moved a year ago and we have a notebook with handwritten entries for the
accessions we have received since the library moved to its new home.
Looking at the information to do with koha it appears very technical and we
are wondering if we will be able to use it for our catalogue.  We would
literally be taking books off the shelves to input their information, not
importing the data from elsewhere and  none of us has anything more than
basic computing knowledge.

Given this, do you think koha is too complicated for us to use or amongst
all the information related to using koha is there a very basic guide that
would suit beginners like us?
If you think we would struggle using koha, could you advise us on software
that you think would be more user-friendly and is not too expensive?

Thanking you all very much in advance for any advice you can give.

Rebecca (on behalf of the group)
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Commit-file

[Hugo Agud]

Dear all

I am working with Koha 16.11.04 (demo server) and I have seen that I am
able to upload a file into stage right, but when I commit the file, the
bibliofiles multiplies...by x number of times (aprox) I have tried to upload

It fails with webadmin, with stage_file.pl but it works fine with
bulkmarc.pl

anybody else has seen this behaviour?


Debian jessie 8 on multiinstance installation

Kindest Regards

-- 

*Hugo Agud - Orex Digital *

*www.orex.es *


[image: www.orex.es/koha] 
   [image: www.orex.es/vufind] 



Director

Calle Sant Joaquin,117, 2º-3ª · 08922 Santa Coloma de Gramanet - Tel: 933
856 138   ha...@orex.es · http://www.orex.es/



No imprima este mensaje a no ser que sea necesario. Una tonelada de papel
implica la tala de 15 árboles y el consumo de 250.000 litros de agua.



Aviso de confidencialidad
Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO
RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
está autorizado a recibirlo por el remitente), no está autorizado a copiar,
reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje
por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha