[Koha] lists.koha-community.org down
Hello all, The server managing mailing lists (and our internal mails) has been shutdown by our provider, who think he has detected a hacking on it. So all mailing lists x...@lists.koha-community.org are OFF for instance. We're working to make the server live again ASAP. ( If you need to reach me use paul.poulain _ free.fr, or IRC please ) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] lists.koha-community.org down
Salvete! The server managing mailing lists (and our internal mails) has been shutdown by our provider, who think he has detected a hacking on it. So all mailing lists x...@lists.koha-community.org are OFF for instance. We're working to make the server live again ASAP. ( If you need to reach me use paul.poulain _ free.fr, or IRC please ) Yeah, some toad changed the wiki, too. Jerks. Someone cool please IP ban Pepe11. Cheers, Brooke ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Acquisitions - Vendor Purchases History
Hi All, Just dropping a quick question for everyone. Does anyone know, if there is a to either view, directly in the Acquisitions, or via a generated Report, to get a list of all items purchased from each Vendor in the Acquisitions module? I¹m just going through a few invoices but can¹t find a way of searching them in Acquisitions... Is there a way... I would really love to have this functionality. Thanking you in advance :) Kindest Regards, Joel Joel Harbottle Library Technician Library Processing Services (Queensland) Email: library.servi...@hotmail.com Web: http://libservices.wordpress.com/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report Help - Extracting XML
:) No problem! I actually had to remove them to test on the command line anyway.
You are right! It does work :) thanks - will share on the wiki with a
dual credit :)
Nicole
On Thu, Jul 28, 2011 at 8:21 PM, Grobani, Daniel
dgrob...@samuelmerritt.edu wrote:
Hmm, it works fine for me. It looks like it might have choked on the first
tab--try replacing all the tabs I introduced to spaces.
Thanks for your reminder about the and sorry I removed them. I remember
reading about that now, but because that works differently in our, um,
flavor, it didn't stick.
Daniel
-Original Message-
From: Nicole Engard [mailto:neng...@gmail.com]
Sent: Thursday, July 28, 2011 5:02 PM
To: Grobani, Daniel
Cc: koha@lists.katipo.co.nz
Subject: Re: [Koha] Report Help - Extracting XML
Okay - this:
select count(statistics.datetime) as circs, CONCAT('a
href=\/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\',biblio.title,'/a')
AS Title, CONCAT('a
href=\http://catalog.mysiteca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'\http://catalog.mysiteca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'/a')
as URL, biblio.author, items.location,
extractValue(biblioitems.marcxml,collection/record/datafield[@tag='520'][1]/subfield[@code='a'])
FROM statistics
JOIN items ON (items.itemnumber=statistics.itemnumber)
LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber)
LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber =
items.biblioitemnumber)
WHERE DATE(statistics.datetime) BETWEEN '2011-01-01' AND
'2011-07-01'
AND statistics.itemnumber IS NOT NULL
AND location = 'Shelving Location Code'
GROUP BY biblio.biblionumber
ORDER BY circs DESC
LIMIT 10
Gets this:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near ' statistics JOIN items ON (items.itemnumber=statistic'
at line 4
Also, a tip - those sections I had in there are runtime parameters for
Koha (a neat trick that is documented on the wiki and in the manual - in case
you removed them cause you didn't know what they were).
On Thu, Jul 28, 2011 at 7:41 PM, Daniel Grobani dgrob...@samuelmerritt.edu
wrote:
Try this (I also did some light cleanup):
SELECT COUNT(statistics.datetime) AS circs,
CONCAT(' \/cgi- ',biblio.title,' ') AS Title,
CONCAT(' \http://mycatalogv/cgi-
http://catalog.losgatosca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'
') AS URL,
biblio.author,
items.location,
extractValue(biblioitems.marcxml,collection/record/datafield[@tag='52
0'][1]/subfield[@code='a'])
FROM statistics
JOIN items ON (items.itemnumber=statistics.itemnumber)
LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber)
LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber =
items.biblioitemnumber)
WHERE DATE(statistics.datetime) BETWEEN '-mm-dd' AND
'-mm-dd'
AND statistics.itemnumber IS NOT NULL
AND location = 'Shelving Location Code'
GROUP BY biblio.biblionumber
ORDER BY circs DESC
LIMIT 10
-
Cheers,
Daniel Grobani
Library Technology Specialist
John A. Graziano Memorial Library
Samuel Merritt University
--
View this message in context:
http://koha.1045719.n5.nabble.com/Report-Help-Extracting-XML-tp4640604
p4644634.html Sent from the Koha - Discuss mailing list archive at
Nabble.com.
___
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha question for archives
This is a question for the government archives out there using Koha but also for anyone else who might have some ideas. We have thousands of state Supreme Court Case records that are called for by case number. They were not in our old catalog and therefore aren't in Koha simply because of the sheer volume of them. They are heavily used, as you can imagine, and so need to be in the catalog so we can track their use along with our our other holdings. Patrons can only have one box at a time, which is the rule for all of our archival materials. I'm thinking of creating fast add records using the case name as the title and the case number as the call number. There is of course, a box and/or folder number depending on the complexity of the case, and we have all that information in a database that I can pull from to create the biblios and items. I know that other archives use Koha, but I'm unclear as to whether other archives are using circulation (which is why we use an ILS) and how they handle really huge collections such as our state supreme court. Please feel free to contact me off list, as this may not be of interest to many. Thanks in advance. -- Linda Culberson lcul...@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Fax: 601/576-6824 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Acquisitions - Vendor Purchases History
Hi Joel, Took these right off the Wiki (http://wiki.koha-community.org/wiki/SQL_Reports_Library), hope they help: Orders in Date Range * Developer: Nicole C. Engard, ByWater Solutions * Module: Acquisitions * Purpose: Show order information for a specific date period. * Status: Complete SELECT v.name AS vendor, b.title AS 'book title', format(o.listprice,2) AS 'list price', format(o.unitprice,2) AS 'actual price', ba.basketname, o.notes FROM aqorders o LEFT JOIN aqbasket ba USING (basketno) LEFT JOIN aqbooksellers v ON (v.id = ba.booksellerid) LEFT JOIN biblio b USING (biblionumber) WHERE o.entrydate BETWEEN Ordered BETWEEN (-mm-dd) AND and (-mm-dd) Ledger * Developer: Nicole C. Engard, ByWater Solutions * Module: Acquisitions * Purpose: Show's a ledger of all items ordered * Status: Complete SELECT b.name AS vendor, i.itype, p.budget_branchcode AS branch, k.basketno, o.entrydate AS 'order date', format(o.listprice,2) AS 'list price', format(o.unitprice,2) AS 'unit price', o.quantity, format(o.totalamount,2) AS 'total amount', o.datereceived AS 'date received' FROM aqbasket k LEFT JOIN aqbooksellers b ON (k.booksellerid=b.id) LEFT JOIN aqorders o USING (basketno) LEFT JOIN items i USING (biblioitemnumber) LEFT JOIN aqbudgets p USING (budget_id) Respectfully, James Ghiorzi Library Assistant II San Benito County Free Library 470 Fifth St. Hollister, CA 95023 (831) 636-4107 From: koha-boun...@lists.katipo.co.nz [koha-boun...@lists.katipo.co.nz] On Behalf Of Joel Harbottle [joel.harbot...@hotmail.com.au] Sent: Friday, July 29, 2011 3:39 AM To: Koha List Subject: [Koha] Acquisitions - Vendor Purchases History Hi All, Just dropping a quick question for everyone. Does anyone know, if there is a to either view, directly in the Acquisitions, or via a generated Report, to get a list of all items purchased from each Vendor in the Acquisitions module? I’m just going through a few invoices but can’t find a way of searching them in Acquisitions... Is there a way... I would really love to have this functionality. Thanking you in advance :) Kindest Regards, Joel Joel Harbottle Library Technician Library Processing Services (Queensland) Email: library.servi...@hotmail.comUrlBlockedError.aspx Web: http://libservices.wordpress.com/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] lists.koha-community.org down
Le 29/07/2011 10:24, Paul Poulain a écrit : Hello all, The server managing mailing lists (and our internal mails) has been shutdown by our provider, who think he has detected a hacking on it. So all mailing lists x...@lists.koha-community.org are OFF for instance. We're working to make the server live again ASAP. ( If you need to reach me use paul.poulain _ free.fr, or IRC please ) I forgot to write it's back, you may have seen already. -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
