- Koha - lists.katipo.co.nz

cataloguing
by Margaret Matthews 01 Aug '11

01 Aug '11

Hi, I need some help on error msgs that I am getting while trying to catalog. using 3.2 on ubuntu. all cataloging was fine until I got these msgs. i have cataloged 2600 titles all downloaded from LOC and now these msgs. 1. All arguments must be MARC: field objects at /usr/share/koha/intranet/cgi-bin/cataloguing/addbiblio.pl line 149 and 2. Can't call method "subfield" on an undefined value at /usr/share/koha/intranet/cgi-bin/cataloguing/additon.pl line 79 what do these pl lines represent? what MARC field do they represent or do they?? help!! thanks in advance!! margaret at Valentine isd, Texas

1 0

IRC meeting reminder (August 2 02:00 UTC)
by Chris Cormack 31 Jul '11

31 Jul '11

Hi all It's nearly that time again, for our monthly IRC meeting. The agenda is here http://wiki.koha-community.org/wiki/General_IRC_Meeting,_2_August_2011 The meeting is open to all with an interest in Koha. http://koha-community.org/get-involved/irc/ Please come along, Koha is what we make it :) Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand

1 0

SQL start error
by Devendra Tapdia 30 Jul '11

30 Jul '11

Hi all, I am facing following error when trying to start mysql. $]/etc/init.d/mysql start Error 1142 *Select* command *denied* for user kohaadmin@koha for table user. Also I get same error when i login using following mysql -ukohaadmin -p >*Select* * from mysql.user; My System Configuration 1] Using Oracle Virtual Box 2] Debian 5.0 3] Koha 3.0 -Devendra

2 2

lists.koha-community.org down
by Paul Poulain 29 Jul '11

29 Jul '11

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 xxx(a)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

2 2

Acquisitions - Vendor Purchases History
by Joel Harbottle 29 Jul '11

29 Jul '11

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.Services(a)hotmail.com Web: http://libservices.wordpress.com/

2 1

Koha question for archives
by Linda Culberson 29 Jul '11

29 Jul '11

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 lculber(a)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

1 0

Report Help - Extracting XML
by Nicole Engard 29 Jul '11

29 Jul '11

Hello all, I need some report assistance. I want to add the summary (520a) to this report: 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://mycatalogv/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'\">http://catalog.losgatosca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'</a>') as URL, biblio.author, items.location from statistics join items on (items.itemnumber=statistics.itemnumber) left join biblio on (biblio.biblionumber=items.biblionumber) where DATE(statistics.datetime) Between <<Date between (yyyy-mm-dd)>> and <<and (yyyy-mm-dd)>> and statistics.itemnumber is not NULL and location = <<Shelving Location Code>> group by biblio.biblionumber order by circs DESC Limit 10 Can someone make some suggestions?

3 8

Seeking Koha Newsletter Editor
by Nicole Engard 29 Jul '11

29 Jul '11

Community members, In case you missed it in the most recent newsletter (July 2011) I am resigning my post as newsletter editor and am currently seeking someone to fill my position. I have held this post for 1.5 years and am unable to continue managing both the manual and the newsletter (and of course all the other stuff I do). The new editor will take over for the August issue and continue at least through December 2012. That will be a 1.5 year term (as mine has been). If you would like to volunteer please do so at the next Koha meeting or place your proposal on the agenda if you cannot attend the meeting. Thanks Nicole C. Engard

8 8

ILS open sources
by Jonson philip 29 Jul '11

29 Jul '11

hi i'm going to create a document about Integrated Library Systems in open sources , any one can helps me by official list of open sources ILS . thank's

3 3

Problems Column in Inventory
by Nicole Engard 29 Jul '11

29 Jul '11

Can anyone tell me what the last column that shows on the shelf listing for the inventory tool is for? It is labeled as 'Problems' but I have never seen anything but 'None' under that - and I've tested on a lot of systems. What would a problem be? What is being reported by this column? Nicole

2 2