[Koha] Koha Digest, Vol 94, Issue 50
Akin Adigun (Akinomatics)
akinomatics at yahoo.com
Tue Sep 3 21:42:15 NZST 2013
Hello all,
I think this might be a bug in the because I notice the date set for an item in acquisition is on the dateaccessioned in items table (items.dateaccessioned) and also if the cataloguer select the date while cataloguing the date is also on dateaccessioned (items.dateaccessioned), so using this field for the 2 reports i.e. items acquired per date and also items catalogue per date is making one of the report right while the other wrong.
Pls, where do i report this bug?
________________________________
From: "koha-request at lists.katipo.co.nz" <koha-request at lists.katipo.co.nz>
To: koha at lists.katipo.co.nz
Sent: Wednesday, August 28, 2013 1:00 AM
Subject: Koha Digest, Vol 94, Issue 50
Send Koha mailing list submissions to
koha at lists.katipo.co.nz
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.katipo.co.nz/mailman/listinfo/koha
or, via email, send a message with subject or body 'help' to
koha-request at lists.katipo.co.nz
You can reach the person managing the list at
koha-owner at 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. Re: Query for report on items catalogue in a date. (Paul)
2. Re: Query for report on items catalogue in a date. (Gay Richards)
3. Re: JQuery Help (Nicole Engard)
4. Re: JQuery Help (Nicole Engard)
----------------------------------------------------------------------
Message: 1
Date: Tue, 27 Aug 2013 16:37:19 -0400
From: Paul <paul.a at aandc.org>
To: Gay Richards <g.richards at auckland.ac.nz>,
<koha at lists.katipo.co.nz>
Subject: Re: [Koha] Query for report on items catalogue in a date.
Message-ID: <5.2.1.1.2.20130827163157.05b45e88 at localhost>
Content-Type: text/plain; charset="iso-8859-1"; format=flowed
At 08:17 PM 8/27/2013 +0000, Gay Richards wrote:
>Paul
>This is great. I was looking for this too. Unfortunately the html doesn't
>seem to work when downloaded to csv but I guess I could remove that.
Without the html, it is a little shorter:
SELECT biblio.title AS Title, biblio.author AS Author,
items.barcode AS Barcode
FROM items
LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
WHERE
DATE(items.dateaccessioned) BETWEEN <<Accessioned BETWEEN (yyyy-mm-dd)>>
AND <<and (yyyy-mm-dd)>>
Best - Paul
>Thanks, Gay
>
>Gay Richards
>Information Specialist
>New Zealand Family Violence Clearinghouse
>T?maki Innovation Campus
>The University of Auckland
>Ph: (09) 923 4640
>
>
> 09 923 4640 | www.nzfvc.org.nz | info at nzfvc.org.nz
>
>-----Original Message-----
>From: koha-bounces at lists.katipo.co.nz
>[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Paul
>Sent: Wednesday, 28 August 2013 2:26 a.m.
>To: koha at lists.katipo.co.nz
>Subject: Re: [Koha] Query for report on items catalogue in a date.
>
>At 04:41 AM 8/27/2013 -0700, Akin Adigun \(Akinomatics\) wrote:
> >I want the title, author, barcode for all items catalogue in a date or
> >range of date
>
>SELECT CONCAT('<a
>href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',items.biblionumber,'\">',biblio.title,'</a>')
>AS Title, biblio.author AS Author,
>items.barcode AS Barcode
>FROM items
>LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
>WHERE
>DATE(items.dateaccessioned) BETWEEN <<Accessioned BETWEEN (yyyy-mm-dd)>>
>AND <<and (yyyy-mm-dd)>>;
>
>Best - Paul
>
>---
>Maritime heritage and history, preservation and conservation, research and
>education through the written word and the arts.
><http://NavalMarineArchive.com> and <http://UltraMarine.ca>
>
>_______________________________________________
>Koha mailing list http://koha-community.org Koha at lists.katipo.co.nz
>http://lists.katipo.co.nz/mailman/listinfo/koha
---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>
------------------------------
Message: 2
Date: Tue, 27 Aug 2013 20:59:04 +0000
From: Gay Richards <g.richards at auckland.ac.nz>
To: 'Paul' <paul.a at aandc.org>, "koha at lists.katipo.co.nz"
<koha at lists.katipo.co.nz>
Subject: Re: [Koha] Query for report on items catalogue in a date.
Message-ID:
<AB44DEB8CF4F784F90EBCDBBD9B81737895D4978 at uxcn10-5.UoA.auckland.ac.nz>
Content-Type: text/plain; charset="utf-8"
Paul
Thank you. My novice SQL efforts hadn't quite figured that out.
Regards, Gay
Gay Richards
Information Specialist
New Zealand Family Violence Clearinghouse
T?maki Innovation Campus
The University of Auckland
Ph: (09) 923 4640
09 923 4640 | www.nzfvc.org.nz | info at nzfvc.org.nz
-----Original Message-----
From: Paul [mailto:paul.a at aandc.org]
Sent: Wednesday, 28 August 2013 8:37 a.m.
To: Gay Richards; koha at lists.katipo.co.nz
Subject: RE: [Koha] Query for report on items catalogue in a date.
At 08:17 PM 8/27/2013 +0000, Gay Richards wrote:
>Paul
>This is great. I was looking for this too. Unfortunately the html
>doesn't seem to work when downloaded to csv but I guess I could remove that.
Without the html, it is a little shorter:
SELECT biblio.title AS Title, biblio.author AS Author, items.barcode AS Barcode FROM items LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
WHERE
DATE(items.dateaccessioned) BETWEEN <<Accessioned BETWEEN (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>>
Best - Paul
>Thanks, Gay
>
>Gay Richards
>Information Specialist
>New Zealand Family Violence Clearinghouse T?maki Innovation Campus The
>University of Auckland
>Ph: (09) 923 4640
>
>
> 09 923 4640 | www.nzfvc.org.nz | info at nzfvc.org.nz
>
>-----Original Message-----
>From: koha-bounces at lists.katipo.co.nz
>[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Paul
>Sent: Wednesday, 28 August 2013 2:26 a.m.
>To: koha at lists.katipo.co.nz
>Subject: Re: [Koha] Query for report on items catalogue in a date.
>
>At 04:41 AM 8/27/2013 -0700, Akin Adigun \(Akinomatics\) wrote:
> >I want the title, author, barcode for all items catalogue in a date
> >or range of date
>
>SELECT CONCAT('<a
>href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',items.biblionum
>ber,'\">',biblio.title,'</a>')
>AS Title, biblio.author AS Author,
>items.barcode AS Barcode
>FROM items
>LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
>WHERE
>DATE(items.dateaccessioned) BETWEEN <<Accessioned BETWEEN
>(yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>>;
>
>Best - Paul
>
>---
>Maritime heritage and history, preservation and conservation, research
>and education through the written word and the arts.
><http://NavalMarineArchive.com> and <http://UltraMarine.ca>
>
>_______________________________________________
>Koha mailing list http://koha-community.org Koha at lists.katipo.co.nz
>http://lists.katipo.co.nz/mailman/listinfo/koha
---
Maritime heritage and history, preservation and conservation, research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>
------------------------------
Message: 3
Date: Tue, 27 Aug 2013 19:19:35 -0400
From: Nicole Engard <nengard at gmail.com>
To: Bernardo Gonzalez Kriegel <bgkriegel at gmail.com>
Cc: Koha <Koha at lists.katipo.co.nz>
Subject: Re: [Koha] JQuery Help
Message-ID:
<CAC0K6VG4+B_DWrmbD5jG8Yyx+=+A2vAgsuKd+EHf21oaSca28w at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Thank you!
On Tue, Aug 27, 2013 at 9:43 AM, Bernardo Gonzalez Kriegel
<bgkriegel at gmail.com> wrote:
> Nicole,
> one more line is needed to change sort1 on those two places,
> the last one
>
> $(document).ready(function(){
>
> $("#memberentry_library_management label[for='sort1']").html("Jurisdiction
> :");
> $("#patron-library-details .label:contains('Sort field
> 1:')").html('Jurisdiction:');
> $("fieldset.rows label[for='sort1']").html("Jurisdiction :");
>
> });
>
> Regards,
> Bernardo
>
>
> --
> Bernardo Gonzalez Kriegel
> bgkriegel at gmail.com
>
>
> On Mon, Aug 26, 2013 at 5:10 PM, Nicole Engard <nengard at gmail.com> wrote:
>>
>> I'd like to update this jquery
>>
>> http://wiki.koha-community.org/wiki/JQuery_Library#Relabel_Sort1_on_Patron_Record
>> to also change sort1 on these pages:
>>
>> /cgi-bin/koha/tools/modborrowers.pl
>> /cgi-bin/koha/tools/import_borrowers.pl
>>
>> Any help would be appreciated.
>> _______________________________________________
>> Koha mailing list http://koha-community.org
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
------------------------------
Message: 4
Date: Tue, 27 Aug 2013 19:21:58 -0400
From: Nicole Engard <nengard at gmail.com>
To: Bernardo Gonzalez Kriegel <bgkriegel at gmail.com>
Cc: Koha <Koha at lists.katipo.co.nz>
Subject: Re: [Koha] JQuery Help
Message-ID:
<CAC0K6VHOf4cHCvHw_GZ1QTsSfBzeP2yYPGqrgfAtDHOsN3G-Cw at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Bernardo,
Sorry ... it didn't work on /cgi-bin/koha/tools/modborrowers.pl , but
it did on the other.
Nicole
On Tue, Aug 27, 2013 at 7:19 PM, Nicole Engard <nengard at gmail.com> wrote:
> Thank you!
>
> On Tue, Aug 27, 2013 at 9:43 AM, Bernardo Gonzalez Kriegel
> <bgkriegel at gmail.com> wrote:
>> Nicole,
>> one more line is needed to change sort1 on those two places,
>> the last one
>>
>> $(document).ready(function(){
>>
>> $("#memberentry_library_management label[for='sort1']").html("Jurisdiction
>> :");
>> $("#patron-library-details .label:contains('Sort field
>> 1:')").html('Jurisdiction:');
>> $("fieldset.rows label[for='sort1']").html("Jurisdiction :");
>>
>> });
>>
>> Regards,
>> Bernardo
>>
>>
>> --
>> Bernardo Gonzalez Kriegel
>> bgkriegel at gmail.com
>>
>>
>> On Mon, Aug 26, 2013 at 5:10 PM, Nicole Engard <nengard at gmail.com> wrote:
>>>
>>> I'd like to update this jquery
>>>
>>> http://wiki.koha-community.org/wiki/JQuery_Library#Relabel_Sort1_on_Patron_Record
>>> to also change sort1 on these pages:
>>>
>>> /cgi-bin/koha/tools/modborrowers.pl
>>> /cgi-bin/koha/tools/import_borrowers.pl
>>>
>>> Any help would be appreciated.
>>> _______________________________________________
>>> Koha mailing list http://koha-community.org
>>> Koha at lists.katipo.co.nz
>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>>
------------------------------
_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
End of Koha Digest, Vol 94, Issue 50
************************************
More information about the Koha
mailing list