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 to be done urgently! Any help appreciated Regards Lisa [Description: Description: Description: CR_logo_POS_COULEUR b] LISA PEEL, PGDip, MA. Librarian César Ritz Colleges Switzerland 1897 Le Bouveret - Switzerland Tel: +41 24 482 82 82 Fax: +41 24 482 82 80 E-mail: lisa.peel@ritz.edu<mailto:hortense.hofer@ritz.edu> http://www.ritz.edu<http://www.ritz.edu/> - http://www.culinaryarts.ch<http://www.culinaryarts.ch/>
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 guided search but no data appears in the column.
Apologies for making such a basic request but I have been asked for the report to be done urgently!
Any help appreciated
Regards
Lisa
<image001.jpg>
LISA PEEL, PGDip, MA. Librarian César Ritz Colleges Switzerland 1897 Le Bouveret - Switzerland Tel: +41 24 482 82 82 Fax: +41 24 482 82 80 E-mail: lisa.peel@ritz.edu http://www.ritz.edu - http://www.culinaryarts.ch
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
SELECT items.itemcallnumber, items.barcode, biblio.author, biblio.title, biblioitems.publicationyear FROM items JOIN biblio USING (biblionumber) join biblioitems USING (biblionumber) WHERE items.homebranch='yourbranch' limit 150000 ORDER BY items.itemcallnumber asc notes: Paste this into the reports "Create from SQL" section, and run from there. you'll want to put in your branch code for 'yourbranch' Set the limit to something above the maximum number of records you expect. Hope this helps! Liz Rea lrea@nekls.org
Hi Liz Thanks for the quick reply but there is still no data in the publication year column - is this something we have done wrong when cataloguing? There is definitely data in the 260c field in the majority of our records. Regards Lisa From: Liz Rea [mailto:lrea@nekls.org] Sent: 02 June 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 guided search but no data appears in the column. Apologies for making such a basic request but I have been asked for the report to be done urgently! Any help appreciated Regards Lisa <image001.jpg> LISA PEEL, PGDip, MA. Librarian César Ritz Colleges Switzerland 1897 Le Bouveret - Switzerland Tel: +41 24 482 82 82 Fax: +41 24 482 82 80 E-mail: lisa.peel@ritz.edu<mailto:hortense.hofer@ritz.edu> http://www.ritz.edu<http://www.ritz.edu/> - http://www.culinaryarts.ch<http://www.culinaryarts.ch/> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha SELECT items.itemcallnumber, items.barcode, biblio.author, biblio.title, biblioitems.publicationyear FROM items JOIN biblio USING (biblionumber) join biblioitems USING (biblionumber) WHERE items.homebranch='yourbranch' limit 150000 ORDER BY items.itemcallnumber asc notes: Paste this into the reports "Create from SQL" section, and run from there. you'll want to put in your branch code for 'yourbranch' Set the limit to something above the maximum number of records you expect. Hope this helps! Liz Rea lrea@nekls.org<mailto:lrea@nekls.org> [cid:image001.jpg@01CC213F.7E193820]
Hi Lisa, I think you should replace biblioitems.publicationyear with biblio.copyrightdate to get the date of publication. Nora ________________________ Nora Blake MassCat Manager Massachusetts Library System P.O. Box 609 South Deerfield, MA 01373-0241 413-665-9898 x123 800-282-7755 Email: nblake@masslibsystem.org AIM: noraatmls From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Peel Lisa Sent: Thursday, June 02, 2011 10:10 AM To: 'Liz Rea' Cc: 'koha@lists.katipo.co.nz' Subject: Re: [Koha] Help with report - again! Hi Liz Thanks for the quick reply but there is still no data in the publication year column is this something we have done wrong when cataloguing? There is definitely data in the 260c field in the majority of our records. Regards Lisa From: Liz Rea [mailto:lrea@nekls.org] Sent: 02 June 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 guided search but no data appears in the column. Apologies for making such a basic request but I have been asked for the report to be done urgently! Any help appreciated Regards Lisa <image001.jpg> LISA PEEL, PGDip, MA. Librarian César Ritz Colleges Switzerland 1897 Le Bouveret - Switzerland Tel: +41 24 482 82 82 Fax: +41 24 482 82 80 E-mail: lisa.peel@ritz.edu <mailto:hortense.hofer@ritz.edu> http://www.ritz.edu <http://www.ritz.edu/> - http://www.culinaryarts.ch <http://www.culinaryarts.ch/> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha SELECT items.itemcallnumber, items.barcode, biblio.author, biblio.title, biblioitems.publicationyear FROM items JOIN biblio USING (biblionumber) join biblioitems USING (biblionumber) WHERE items.homebranch='yourbranch' limit 150000 ORDER BY items.itemcallnumber asc notes: Paste this into the reports "Create from SQL" section, and run from there. you'll want to put in your branch code for 'yourbranch' Set the limit to something above the maximum number of records you expect. Hope this helps! Liz Rea lrea@nekls.org
Hi Lisa, Try the "copyrightdate" column in the "biblio" table. Bev * * * * Beverly Church LibLime Project Manager phone: 1-301-654-8088 ext. 292 email: bchurch@liblime.com skype: beverlychurch 2011/6/2 Peel Lisa <lisa.peel@ritz.edu>
Hi Liz
Thanks for the quick reply but there is still no data in the publication year column – is this something we have done wrong when cataloguing? There is definitely data in the 260c field in the majority of our records.
Regards
Lisa
*From:* Liz Rea [mailto:lrea@nekls.org] *Sent:* 02 June 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 guided search but no data appears in the column.
Apologies for making such a basic request but I have been asked for the report to be done urgently!
Any help appreciated
Regards
Lisa
<image001.jpg>
* *
* *
*LISA PEEL, PGDip, MA.*
Librarian
César Ritz Colleges Switzerland
1897 Le Bouveret - Switzerland
Tel: +41 24 482 82 82 Fax: +41 24 482 82 80
E-mail: *lisa.peel@ritz.edu <hortense.hofer@ritz.edu>*
http://www.ritz.edu - http://www.culinaryarts.ch
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
SELECT items.itemcallnumber, items.barcode, biblio.author, biblio.title, biblioitems.publicationyear FROM items JOIN biblio USING (biblionumber) join biblioitems USING (biblionumber) WHERE items.homebranch='yourbranch' limit 150000 ORDER BY items.itemcallnumber asc
notes:
Paste this into the reports "Create from SQL" section, and run from there.
you'll want to put in your branch code for 'yourbranch'
Set the limit to something above the maximum number of records you expect.
Hope this helps!
Liz Rea lrea@nekls.org
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi Beverley and Nora Thank you, now have the list I need. Thanks again Lisa [Description: Description: Description: CR_logo_POS_COULEUR b] LISA PEEL, PGDip, MA. Librarian César Ritz Colleges Switzerland 1897 Le Bouveret - Switzerland Tel: +41 24 482 82 82 Fax: +41 24 482 82 80 E-mail: lisa.peel@ritz.edu<mailto:hortense.hofer@ritz.edu> http://www.ritz.edu<http://www.ritz.edu/> - http://www.culinaryarts.ch<http://www.culinaryarts.ch/> From: Church, Beverly [mailto:bchurch@liblime.com] Sent: 02 June 2011 16:24 To: Peel Lisa Cc: Liz Rea; koha@lists.katipo.co.nz Subject: Re: [Koha] Help with report - again! Hi Lisa, Try the "copyrightdate" column in the "biblio" table. Bev * * * * Beverly Church LibLime Project Manager phone: 1-301-654-8088 ext. 292 email: bchurch@liblime.com<mailto:bchurch@liblime.com> skype: beverlychurch 2011/6/2 Peel Lisa <lisa.peel@ritz.edu<mailto:lisa.peel@ritz.edu>> Hi Liz Thanks for the quick reply but there is still no data in the publication year column - is this something we have done wrong when cataloguing? There is definitely data in the 260c field in the majority of our records. Regards Lisa From: Liz Rea [mailto:lrea@nekls.org<mailto:lrea@nekls.org>] Sent: 02 June 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 guided search but no data appears in the column. Apologies for making such a basic request but I have been asked for the report to be done urgently! Any help appreciated Regards Lisa <image001.jpg> LISA PEEL, PGDip, MA. Librarian César Ritz Colleges Switzerland 1897 Le Bouveret - Switzerland Tel: +41 24 482 82 82 Fax: +41 24 482 82 80 E-mail: lisa.peel@ritz.edu<mailto:hortense.hofer@ritz.edu> http://www.ritz.edu<http://www.ritz.edu/> - http://www.culinaryarts.ch<http://www.culinaryarts.ch/> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha SELECT items.itemcallnumber, items.barcode, biblio.author, biblio.title, biblioitems.publicationyear FROM items JOIN biblio USING (biblionumber) join biblioitems USING (biblionumber) WHERE items.homebranch='yourbranch' limit 150000 ORDER BY items.itemcallnumber asc notes: Paste this into the reports "Create from SQL" section, and run from there. you'll want to put in your branch code for 'yourbranch' Set the limit to something above the maximum number of records you expect. Hope this helps! Liz Rea lrea@nekls.org<mailto:lrea@nekls.org> [cid:image003.jpg@01CC2144.B13E61D0] _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha
I use biblio.copyrightdate in SQL This is a modifed Super Weeder from the blog. It's great in a downloadable Excel report! SELECT CONCAT( '<a href=\"/cgi-bin/koha/cataloguing/additem.pl?biblionumber=',biblio.biblionumber, '\">',items.barcode,'</a>' ) AS 'Barcode',items.barcode,items.itemcallnumber,biblio.title,biblio.author,biblio.copyrightdate AS 'Copyright',items.dateaccessioned AS 'Accessioned',items.itype,items.issues,items.itemnumber,items.renewals,(IFNULL(items.issues,0)+IFNULL(items.renewals,0)) AS Total_Circ,items.datelastborrowed,items.itemlost,items.onloan,items.damaged,items.itemnotes,items.holdingbranch FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.holdingbranch='FARMINGTON' ORDER BY items.itemcallnumber Use these parameters in the WHERE (in red) conneced with AND items.holdingbranch='FARMINGTON' items.itemcallnumber LIKE 'FAST %' items.itype='BOOK' items.ccode='ADULT' Hal Bright Farmington Libraies ________________________________ From: koha-bounces@lists.katipo.co.nz [koha-bounces@lists.katipo.co.nz] on behalf of Peel Lisa [lisa.peel@ritz.edu] Sent: Thursday, June 02, 2011 9:45 AM To: 'koha@lists.katipo.co.nz' Subject: [Koha] Help with report - again! 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 to be done urgently! Any help appreciated Regards Lisa [Description: Description: Description: CR_logo_POS_COULEUR b] LISA PEEL, PGDip, MA. Librarian César Ritz Colleges Switzerland 1897 Le Bouveret - Switzerland Tel: +41 24 482 82 82 Fax: +41 24 482 82 80 E-mail: lisa.peel@ritz.edu<mailto:hortense.hofer@ritz.edu> http://www.ritz.edu<http://www.ritz.edu/> - http://www.culinaryarts.ch<http://www.culinaryarts.ch/>
participants (5)
-
Church, Beverly -
Hal Bright -
Liz Rea -
Nora Blake -
Peel Lisa