Thank you Heather...yes, that looks like the same issue. I had actually search
Bugzilla first but didn't see that one. Thanks again!
Steve
-Original Message-
From: Hernandez, Heather [mailto:heather_hernan...@nps.gov]
Sent: Monday, June 22, 2015 12:18 PM
To: koha@lists.katipo.co.nz
I think this is a bug but I wanted to know if anyone could think of a way
around it. In a List, book titles starting with the articles A, An and
The appear to be sorted improperly and appear in order WITH the article
included instead of skipping the article and sorting by the second word in
the
Hi Lisa,
I hope this is what you were looking for.the SQL below will list
biblionumber and ISBN for all biblioitems without 'tag=952' in the marcxml
field:
select biblionumber from biblioitems where marcxml NOT LIKE '%tag=952%';
Hope this helps!
Steve
-Original Message-
From:
: Steven Nickerson snick...@maine.rr.com mailto:snick...@maine.rr.com
To: koha@lists.katipo.co.nz mailto:koha@lists.katipo.co.nz
Sent: Friday, April 3, 2015 2:53 PM
Subject: [Koha] 2 ways to mark an item withdrawn???
Hello everyone,
I'm running a variety of Koha package versions on Debian
Hello everyone,
I'm running a variety of Koha package versions on Debian, ranging from
3.16.2 to 3.18.5.1 and am hearing reports of issues with how items are
marked as withdrawn. If you search in the staff client for an item and
click on its title to go into the details you can mark an
Hello everyone,
I'm trying to clean up some data from the RDA-related changes when we
updated our framework a while back and have a few topics/questions regarding
the publication fields (particularly the dates):
- Can someone explain to me where the publisher, location, and date
come
Hi everyone,
I have a 3.16.02 package install of Koha running on Debian. When first
installed almost 2 years ago now, I did several iterations of importing
~40,000+ MARC records and then cleaning the resulting staged records. I
was noticing the other day that this MySQL DB's backups are
Hello all,
I've recently upgraded a package install environment on Debian to 3.18.04
and have the 'symptoms' of not being able to find anything in the OPAC
search and also seeing the couldn't open collection.abs error when trying
to rebuild the zebra indexes. I'm trying to follow the
Hi everyone,
I know the topic of Zebra index rebuilding comes up periodically and I've
tried to find an answer to this but can't seem to locate one. I have the
package version of 3.16.02 installed on Debian and have the following
default cron entry in /etc/cron.d/koha-common:
*/5 * * * *
Hello all,
I seem to recall a discussion on this in the past but I can't find the
answer/solution for some reason. I have a 3.16.03 package install version
on Debian. If we mark an item as withdrawn and then search for it, if we
get a list of multiple search results the withdrawn item shows
Hi Kerrie,
I think adding AND s.branch =Branch|branches will do what you're
looking for. So the whole SQL statement would be:
SELECT concat(b.surname,', ',b.firstname) AS name, count(s.borrowernumber)
AS checkouts FROM statistics s LEFT JOIN borrowers b USING (borrowernumber)
WHERE s.datetime
With the finding of the most recent Shellshock vulnerability with the BASH
shell, I'm wondering If Koha uses the BASH shell in any way? I'm pretty
sure it does not, but just wanted to make sure. I realize that the Linux
system Koha is running on likely has the BASH shell that probably has the
Hello folks,
After a recent upgrade to the package version of 3.16.03 it seems as
though Overdue Notices are behaving differently than they used to and I'm
wondering if we can make them work the way we're accustomed to, and if not
can someone please tell us how to print them? It used to be
Good morning,
After a recent upgrade from the tarball 3.9 version to the package
version 3.16.3 we are unable to view the Holds tab on any patron record.
It simply says Processing and never returns results. We can however see
all the holds via a report, so I started poking around and find
=
ba31e9ffc8a0a35586f02324649b14a7b8e9af7c;hb=9657a2c6dc92516963ffa960b7d561cd
cc2dc5e8;hpb=3bcb0f89093daddc9d30e0c393b4801d82bba23b
Hope this helps,
Katrin
Am 13.09.2014 um 16:27 schrieb Steven Nickerson:
Good morning,
After a recent upgrade from the tarball 3.9 version to the package
version 3.16.3 we are unable to view
Hello all,
I'm using the package version of 3.16.03 (but I've seen this same
behavior in several previous versions as well) and am wondering if there is
a way for me to make it so that the .gz files created under
/var/spool/koha/site are world-readable? Currently they are always owned
by
Hi all,
We are running the package version of 3.16.02 and I'm wondering if on a
small spine label I can limit the number of characters printed?
Currently we include the entire author field but we'd like to limit that
to only the first 8 characters of the author? When defining a Label
Layout
and go from there.
Hope this helps,
Katrin
Am 01.08.2014 um 18:02 schrieb Steven Nickerson:
Hello everyone,
We have implemented one of the overdue reports from the Report
Library and that gives us a snapshot of the overdue count at the point
in time when the report is run
I decided to go ahead and try to implement prompting for the year inside of
the Koha report and here's the SQL I came up with (enter the year twice when
prompted):
SELECT month(returndate) AS `MONTH`, COUNT(*) AS `OVERDUES`
FROM old_issues WHERE returndate date_due AND returndate concat(START
Hello everyone,
I'm looking for some thoughts/opinions. I have a working 3.14.04
package install environment running on a 4-core 3.6GHz system with 8GB
RAM. The OS is Debian 32-bit running as a VM on top of VMware ESXi. This
single VM is allocated pretty much all of the physical hardware
Hi Elaine,
I'm really not positive this is the issue, but I would double-check to make
sure that all of your single and double quotes are standard ASCII quote marks.
It looks like several of them are special characters, perhaps automatically
converted somewhere along the way in your
Is there someone who can provide the SQL for me for a report that simply
lists the itemnumber, barcode, and itemcallnumber for all items of a given
Item Type. I'd like the report to prompt (with a pull-down) the list of
all Item Types I have so that I can select it to report on. I think this
itemnumber, barcode, itemcallnumber FROM items WHERE itype=Item
type|itemtypes
You can find more info about the runtime paramters on the wiki too:
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Parameters
-Nick
On Thu, May 1, 2014 at 4:33 PM, Steven Nickerson snick
As Robin stated to me yesterday regarding my other query, checked out status
comes from two locations (issues table and items.onloan field). So if I
understand what you're asking, in order to remove all availability status I
think you'd need to run the following two statements in MySQL:
Hi Jerwyn.
Although the link I find in a Google search is now broken
(http://contribs.koha.org/extension_view.php?eid=15) there is/was a Perl
script already written that converts the MARC records exported from Athena
into ones that you can simply import into Koha, without having to manipulate
them
Hi everyone,
Can anyone tell me where the item availability status on the search
results page comes from, specifically if a search yields more than one match
and shows the results in the summary format? After a recent migration from
Athena to Koha 3.14.03, I'm seeing 1 item, 1 available for
Thanks for the suggestion.yes, I had also already done a full zebra rebuild
with 'sudo koha-rebuild-zebra -f LIBNAME' and that did not resolve it for
me.
From: Jerwyn Fernandez [mailto:jerwyn_fernan...@southville.edu.ph]
Sent: Wednesday, April 02, 2014 4:34 PM
To: Steven Nickerson
Cc: koha
, no?
-Original Message-
From: Robin Sheat [mailto:ro...@catalyst.net.nz]
Sent: Wednesday, April 02, 2014 6:07 PM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Item availability status
Steven Nickerson schreef op wo 02-04-2014 om 15:50 [-0400]:
After a recent migration from
Athena to Koha
@lists.katipo.co.nz
Subject: Re: [Koha] Item availability status
Steven Nickerson schreef op wo 02-04-2014 om 15:50 [-0400]:
After a recent migration from
Athena to Koha 3.14.03, I'm seeing 1 item, 1 available for ALL of my
search results, but some of the items are actually checked out and if
I click
Hello again everyone,
After a recent upgrade from 3.02.02 to 3.14.03 (package install on
Debian) I didn't realize it but the email functions (overdues, holds, etc).
were turned off. When I re-enabled email today with koha-enable-email
messages started flowing again, but the overdue notices
Hi everyone,
I've already solved this issue for myself and thought I'd post in case
anyone else sees a similar issue. I recently upgraded an environment from
3.02.02 to 3.14.03 and after the apparently successful upgrade we were
unable to check-in any overdue items. When we tried to
Hello everyone,
If I have a working 3.12.00.000 environment installed from the Debian
squeeze packages, what is the best way to make an exact, complete duplicate
onto a 2nd machine? Can anyone send me or point me to some step-by-step
instructions? Doesn't have to be complete details, just
-Original Message-
From: Chris Cormack [mailto:chr...@catalyst.net.nz]
Sent: Tuesday, August 20, 2013 3:17 PM
To: Steven Nickerson
Cc: 'Olugbenga Adara'; koha@lists.katipo.co.nz
Subject: Re: [Koha] How frequently to run zebra rebuild and what switches
* Steven Nickerson (snick...@maine.rr.com
Hello everyone,
Looking for some advice and recommendations. For a fairly small library
running Koha 3.12.00.000 from the Debian squeeze packages, how often should
the zebra_rebuild.pl script be executed and with exactly which switches?
Right now I run it at 7:30 AM each morning with
-Original Message-
From: Olugbenga Adara [mailto:gbengaad...@yahoo.com]
Sent: Tuesday, August 20, 2013 2:50 PM
To: Steven Nickerson; koha@lists.katipo.co.nz
Subject: Re: [Koha] How frequently to run zebra rebuild and what switches
Hello Steven,
Looking for some advice and recommendations
Hello folks,
We're migrating from a home-grown Library Management System (using MySQL
for the DB) to Koha. The current DB has the following fields in the
circulation table, and I'm wondering if anyone could provide me with the
SQL commands for me to be able to successfully get the existing
Hello everyone,
I'm building a new environment for a Library that currently has a
custom-built library system with a MySQL back-end DB. I've gone through
the process outlined at
http://www.botskool.com/geeks/how-import-excel-data-koha to export my
existing MySQL data to Excel, converting it
We are using Koha version 3.02.02.000
THANKS!
-Original Message-
From: Chris Cormack [mailto:ch...@bigballofwax.co.nz]
Sent: Thursday, July 05, 2012 5:40 PM
To: Steven Nickerson
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] Overdue notices only list the first book/item that's late
Hello everyone,
We've noticed that the email overdue notices that go out only seem to
list the 1st item that is overdue, and not all overdue items. For example,
if I checked out 2 books on the same date/time, I only get an overdue notice
for one of the two items.Anyone have any ideas? I
Hello everyone,
Thanks for the help with the HOLDS issue yesterday.thought I'd try a
different topic today. We have already enabled overdue email notices and
they seem to be working but I'm wondering if someone can explain exactly how
they work (who gets them, when) and answer a question
Hello everyone,
We're using Koha 3.2.2 and have the AllowOnShelfHolds setting set to
Allow, but we are unable to place a HOLD on anything that is currently on
the shelf. Every attempt yields Sorry, none of these items can be placed
on hold.. We can place a hold on any item currently checked
41 matches
Mail list logo