Thanks Michael,
It was a simple problem with a comma on line 5:
ExtractValue(bi.marcxml, '//datafield[@tag="210"]/subfield[@code="d"]') as
Date*,*
After correcting the problem, it worked just fine :)
All the best,
Vanda
2018-02-28 10:23 GMT+00:00 Michael K
orised_value)
LEFT JOIN biblioitems bi ON (i.biblioitemnumber=bi.biblioitemnumber)
WHERE i.itemlost != 0 AND v.category='LOST'
Thanks a lot for your help and your explanation. Without it I wouldn't be
able to find the answer.
All the best,
Vanda
2018-02-28 9:47 GMT+00:00 vanda koha
510.594.3660 <(510)%20594-3660>
>
> 5212 Broadway, Oakland, CA 94618
> <https://maps.google.com/?q=5212+Broadway,+Oakland,+CA+94618&entry=gmail&source=g>
>
> 8th St., San Francisco, CA
> <https://maps.google.com/?q=+8th+St.,+San+Francisco,+CA%C2%A0+94107&
nimarc and the fields I also
need to show up in the results are:
205 a (Edition Statement)
210 c (Publisher Name)
210 d (Date of Publication).
Can anyone help me with this SQL query?
Many thanks in advance
Vanda
___
Koha mailing list http://koha-com
re. And we haven't done
anything diferent to cause this problem.
Do you have any idea what might be wrong? Has it ever happened to anyone of
you?
Any help would be very appreciated.
Thanks
Vanda
___
Koha mailing list http://koha-community.org
Koha@lis
i.koha-community.
> org/wiki/DBMS_auto_increment_fix,implement the fix and upgrade to a more
> recent version.
>
> Regards,
> Jonathan
>
> On Tue, 2 Jan 2018 at 08:56 vanda koha wrote:
>
>> Hi everybody!
>>
>> We are using koha version 16.11.04.
>>
help would be very welcomed.
Thanks
Vanda
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
for a specific library but you may be examining the 'all libraries'
> rules.
>
> I hope this helps,
> Bob Birchall
> Calyx
>
>
> On 24/11/17 01:24, vanda koha wrote:
>
>> Hi everybody,
>>
>> I'm having some problems with the renewals. When
sumes the date of
the day the renweal is made and not the new date due (that is 30 more days)
We are using 16.11.04 Koha version.
What did I do wrong?
Many thanks in advance
Vanda
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Hi Satish,
I have worked in a College library and we have never erased the patrons
from our databese: we just blocked the students access when they finished
their course. As simple as that. I think that's the best policy. Imagnie
that later on they decide to attend another course: you'll just have
7;) AS Uniform_Title
> FROM auth_header
> WHERE date(datecreated) BETWEEN <> AND < (-mm-dd)>> ORDER by authid
>
> On Wed, Mar 8, 2017 at 6:17 AM, vanda koha wrote:
>
>> Hi everybody,
>>
>> Does anyone know how to do a SQL Report in order to ge
Hi everybody,
Does anyone know how to do a SQL Report in order to get a list of all the
authority records we have already created in a period of time? And can we sort
it by alphabetical order?
Many thanks.
Vanda
___
Koha mailing list http://koha
ancois.charbonn...@inlibro.com>
>
> inLibro | Spécialistes en technologies documentaires | www.inLibro.com <
> http://www.inLibro.com>
>
> Le 2017-03-03 à 07:24, vanda koha a écrit :
>
>> Hi everybody,
>>
>> I have properly set the circulation rules, the item cir
Hello Rebecca,
I work in a small library in a govermental institution, and we have adopted
just now Koha. I must say that once it is implemented it is very easy to
work with.
The most difficult part is that you really need to have someone with very
good knowledge of Linux language, otherwise you
up, etc) that
are ready to be sent to our users? I know some users have overdues, but I
don't know where to look for the notices. Can anyone help me, please?
Many thanks,
Vanda
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
> Jessica L. Tobin
> Technical Services & Systems Librarian
> Arnold Library
> Office 206.667.6846
> Library Main 206.667.4314
> jto...@fredhutch.org
>
> Fred Hutchinson Cancer Research Center
> 1100 Fairview Ave. N., Mail Stop B1-010
> Seattle, WA 98109
>
>
would be great if
the report showed the number of days or the hold expiration date.
Many thanks,
Vanda
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
ot work, when
> the records itself look correct.
>
> Then, when running the web installer, you also need to make sure UNIMARC
> is selected there. This will affect which cataloguing frameworks (MARC
> field and subfield definitions) are installed.
>
> Hope this helps,
>
> Ka
Hello Ian,
We are still unable to solve our problem. We have done everything we were
told to do, including what you mention in your message. Unfortunately
nothing worked.
And yes, we chose UNIMARC when the package installation was performed. My
computer collegues say that we also have some refere
a.pl -f -a -b
> -v`
>
> Regards,
> Jonathan
>
> On Thu, 9 Feb 2017 at 13:16 vanda koha wrote:
>
> > -- Forwarded message --
> > From: vanda koha
> > Date: 2017-02-09 10:58 GMT+00:00
> > Subject: Re: [Koha] No results with the advanced se
-- Forwarded message --
From: vanda koha
Date: 2017-02-09 10:58 GMT+00:00
Subject: Re: [Koha] No results with the advanced search
To: Chris Cormack
Hi Chris,
I was informed by my computer colleagues that the installation was done via
packages. And Zebra seems to be running
title, author, subject, keyword, etc).
The message we get is this: No results found
No results match your search for 'ti,wrdl: manual' in Biblioteca catalog.
What are we doing wrong? Can anyone please help us?
Many thanks in advance,
Vanda
___
Ko
22 matches
Mail list logo
