Hello
I am hoping someone can help me with a little bit of SQL.
I need to export my whole catalogue but I have now realised that the 'simple
framework' some staff have been using to create bib items did not include the
952 tag so this information is missing from those MARC records.
So I now ne
l
field:
select biblionumber from biblioitems where marcxml NOT LIKE '%tag="952"%';
Hope this helps!
Steve
-Original Message-
From: Peel Lisa [mailto:lisa.p...@ritz.edu]
Sent: Thursday, May 21, 2015 3:20 AM
To: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz&
st
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: Peel Lisa [mailto:lisa.p...@ritz.edu]
Sent: T
Hello
I need to create a list of all authorities which I can export to excel. There
do not seem to be any examples of these on the SQL Report Library, so if anyone
could help me I would really appreciate it - I am trying to clean up our
authorities and it is very time consuming doing this just
Hello
All of a sudden we are having a problem when checking in some items - we keep
getting the message 'this item needs to be transferred to IHCR. Transfer now?'
even when the item is being checked in at IHCR and the borrower also has the
location IHCR. It is doing this sparodically (different
Thanks for the response Henri-Damien - no, we have made no changes, it started
about a week ago.
Regards
Lisa
-Original Message-
From: LAURENT Henri-Damien [mailto:henridamien.laur...@biblibre.com]
Sent: 12 May 2011 19:05
To: Peel Lisa; Christophe Croullebois
Subject: Re: [Koha
Hello
I need to create a list which will give me details of all the items at one
library including the year of publication. Have tried adding publication year
to the guided search but no data appears in the column.
Apologies for making such a basic request but I have been asked for the report
2011 16:03
To: Peel Lisa
Cc: koha list
Subject: Re: [Koha] Help with report - again!
On Jun 2, 2011, at 8:45 AM, Peel Lisa wrote:
Hello
I need to create a list which will give me details of all the items at one
library including the year of publication. Have tried adding publication year
to the
...@ritz.edu<mailto:hortense.ho...@ritz.edu>
http://www.ritz.edu<http://www.ritz.edu/> -
http://www.culinaryarts.ch<http://www.culinaryarts.ch/>
From: Church, Beverly [mailto:bchu...@liblime.com]
Sent: 02 June 2011 16:24
To: Peel Lisa
Cc: Liz Rea; koha@lists.katipo.co.nz
Subjec
Hello
We upgraded to 3.4 at the end of June. Yesterday I was doing some staff
training and noticed that if I issue a book to a patron and on the same day
renew it, the date keeps rolling forward instead of renewing to the same date.
For example, I issued a 1 week loan to a patron yesterday, ori
.@ritz.edu
http://www.ritz.edu/ - http://www.culinaryarts.ch/
+++ 25 Years "César Ritz" Colleges Switzerland +++
From: Chris Cormack [ch...@bigballofwax.co.nz]
Sent: 19 July 2011 10:35
To: Peel Lisa
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha]
Hello
I have finally bought my first e-book ! The book supplier I used has sent me
the MARC record as a .usm file but I do not have any idea how to open it or how
to import the record into KOHA.
Do I need to download/buy some external Marc Editor and how can I then import
it into KOHA?
As usu
July 2011 17:17
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] marc editors and importing records
Peel Lisa
> I have finally bought my first e-book ! The book supplier I used has
> sent me the MARC record as a .usm file but I do not have any idea how
> to open it or how to import the re
Hello
I have had two patrons today checking in overdue items (they come up as overdue
on check in) but no fine has been created on their account.
We upgraded to 3.4 recently - I had a quick look in the system prefs, calendar
and fine rules and I think it all looks ok. Is there something I am mi
Hello
We are having instances where patrons are receiving overdue notices for items
they have already checked in - for example I received one today for an item
which was checked in on Friday and is not now on my patron account.
Any ideas?
Regards
Lisa
[Description: Description: Description:
Hello
I think I already know the answer to this but just wanted someone far more
intelligent and knowledgeable than me to confirm. . . !!
If I delete a patron, their usage stats are still kept in the tables aren't
they? I am not wiping this information out by deleting their account?
The only e
Hello
Report help again I am afraid!
Could anyone supply me with the SQL for a report which will show me the amount
of fines being written off at a specific library for a given period of time
(for example the last three months?)
Regards and thanks in advance
Lisa
[Description: Description:
Hi there
We are on version 3.07. Previously, if I set holidays in the calendar, the due
date would then skip to the next open day available (for example, I currently
have the 23rd of June to the 10th July as holiday days as our school is closed.
I would therefore expect that any 7 day items iss
18 matches
Mail list logo