- Koha - lists.katipo.co.nz

guide query
by Roshan Bantawa 28 Apr '11

28 Apr '11

Hey, I was going through KOHA system and came across an interesting feature. I tried to use it but couldn't understand the process. If you could help me find a Guide for the operation of REPORTS of KOHA if possible it would be very helpful Thanks -- -ROSHAN BANTAWA

1 0

Re: [Koha] Ghost records
by Jared Camins-Esakov 28 Apr '11

28 Apr '11

Tomas, > Our problem was : > > melm 001 local-number,local-number:n > > ...... > > melm 035$a local-number,local-number:n > > We had two fields indexed in "local-number" and we had "ghost entries". > > We have corrected in : > > melm 001 local-number,local-number:n > > ...... > > melm 035$a identifier-other,identifier-other:n > > Reindex and it was the end of the fabulous story of ghost entries. > > Perhaps its just out of my knowledge's scope, by I don't see the > problem of having two different fields indexed under the same name, I > mean, I'd think both would match the same record and thus not be shown > twice. I'd rather think of a weird coincidence. I'm sorry if my > confusion just makes the situation more obscure. > The issue here is that the local-number index has "magic" properties. I don't really understand how Zebra works, but I do know that every entry in the local-number index is considered a "separate" record. So if record has two fields that appear in the local-number index, the Zebra index will store two copies of the record (this is where the search results in Koha come from, not from the database). At some point I will submit a patch changing the suggestion for the 035 index, since uncommenting the "melm 035" line as it stands now in the MARC21 record.abs is pretty much guaranteed to corrupt your Zebra indexes. Regards, Jared -- Jared Camins-Esakov Freelance bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins(a)cpbibliography.com (web) http://www.cpbibliography.com/

2 1

Ghost records
by Lenora Oftedahl 28 Apr '11

28 Apr '11

Hello all. Koha v. 3.00.00.107 Zebra 2.0.34 We're having a problem with ghost records in the index. The Zebra index is rebuilt every night, but still when searching, I'll pull up two records: one that has been deleted and one that is real. The public receives a 404 error. I receive Can't call method "fields" on an undefined value at /usr/share/koha/intranet/cgi-bin/catalogue/MARCdetail.pl line 123. Has anyone solved this problem? Will upgrading solve the problem or just compound? Thanx. Lenora StreamNet Regional Librarian Columbia River Inter-Tribal Fish Commission

4 4

Zebra errors
by Tom Hanstra 27 Apr '11

27 Apr '11

I've successfully got indexing working without Zebra so now I'm trying to configure with Zebra. I think I have Zebra installed (placed in my own /shared/zebra directory) and I ran the rebuild_zebra.pl and got resulting files: ./var/lib/zebradb/biblios/register ./var/lib/zebradb/biblios/register/isambA-0.mf ./var/lib/zebradb/biblios/register/isambC-0.mf ./var/lib/zebradb/biblios/register/isambD-0.mf ./var/lib/zebradb/biblios/register/recdA-0.mf ./var/lib/zebradb/biblios/register/gmatch-0.mf ./var/lib/zebradb/biblios/register/isambB-0.mf ./var/lib/zebradb/biblios/register/dict-0.mf ./var/lib/zebradb/biblios/register/reci-0.mf And the zebrasrv starts and looks like it is running. But, with searches now using the Zebra indexes, I get an ERROR 109 from zebrasrv: 11:30:34-27/04 zebrasrv(4) [request] Search biblios ERROR 109 1 1+0 RPN @attrset Bib-1 @not @or @or @attr 1=1003 @attr 4=1 @attr 6=3 @attr 9=32 @attr 2=102 "twain, mark" @attr 1=1003 @attr 4=1 @attr 9=26 @attr 2=102 "twain, mark" @attr 1=1003 @attr 5=1 @attr 4=6 @attr 9=26 @attr 2=102 "twain, mark" @attr 1=9011 1 What is ERROR 109? How can I track down what might be still missing? Thanks, Tom -- ----------------------------------------------------------------------------- Tom Hanstra Systems Administrator Hesburgh Libraries of Notre Dame Phone: (574)631-4686 213 Hesburgh Library Email: tom(a)nd.edu Notre Dame, IN 46556 Any idiot can face a crisis, it is this day-to-day living that wears you out. Anton Chekhov -----------------------------------------------------------------------------

6 8

Problem with Label Batch Create
by Empedocles 27 Apr '11

27 Apr '11

Hi, I have recently upgraded to 3.4. The layout, profile, and template sections of the labels tool are all working as they should, however I am having the following problem with the batch manager: -Trying to add new items/batches returns the error that the branch is not set. Although I had set the branch, at the top of the batch manager page there is simply a blank beside the set branch link- neither the branch name nor NO_BRANCH_SET. This does not seem to be happening anywhere else on the staff client. -The error log readout is as follows: [error] use of uninitialized value $branch_code in concatenation (.) or string at /usr/share/koha/intranet/cgi-bin/labels/label-manage.pl line 89., referer: http://.....:8080/cgi-bin/koha/labels/label-home.pl I was able to use the batch creator without problems under 3.2 (although I can't remember the last release I used it under). Any ideas on what might be causing this? Thanks in advance. Regards, Isaac -- View this message in context: http://koha.1045719.n5.nabble.com/Problem-with-Label-Batch-Create-tp4344579… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

Font changes on receipts
by Lesley Kimball 27 Apr '11

27 Apr '11

We are brand-new to Koha (went live on Monday 4/25). I would like to change the appearance (esp. font) of our receipts. I have found some information online (& archives) - all about editing the intranetuserjs area - but I am not proficient with javascript or css and I am not sure what I would put in that field. Most of the references I have found suggest something like - "put your own css/js info here, then the font info" - but since we aren't currently using any js or css in that area, I'm not sure how to go about that. Does anyone have a very simplified piece of code that you would share that might work for us? If I'm way off base, just let me know!! Thanks, Lesley Kimball ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ You see, I don't believe that libraries should be drab places where people sit in silence, and that's been the main reason for our policy of employing wild animals as librarians. -- Monty Python, "Gorilla Librarian" sketch ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Lesley Kimball Director Wiggin Memorial Library Stratham, NH <mailto:Director@WigginML.org> Director(a)WigginML.org

2 1

Database update error on upgrade from 3.2.6 to 3.2.7 using debian package
by Jorge de Cardenas 27 Apr '11

27 Apr '11

Looks like a miss-spelling; one is 'itemsstocknumberidx' <-- 2 S's the other is 'itemstocknumberidx' <-- 1 S -- ____________________________________ | Jorge de Cardenas | jdeca(a)smfpl.org | Stow-Munroe Falls Public Library _____________________________________ If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the institution.

1 0

Re: [Koha] SQL statement for generating current checkouts
by Randall Rowe 27 Apr '11

27 Apr '11

Nabonita, Simply change the WHERE issues.issuedate = 'yyyy-mm-dd' part to read WHERE issues.issuedate <= 'yyyy-mm-dd' in each query. Randy Rowe Lincoln City Libraries I.T. -----Original Message----- From: "nabonita(a)jncasr.ac.in" <nabonita(a)jncasr.ac.in> Sent 4/20/2011 11:35:49 PM To: "Church, Beverly" <bchurch(a)liblime.com> Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] SQL statement for generating current checkouts Thanks Beverly for send me the SQL query. But this is retrieving only those titles which are issued on the given date. Where as I need to know that the titles which were on loan AS OF 2011-03-29. This may contain overdue books, and books which were issued/renewed on or before the given date. I'm not sure if this sort of result can be generated in Koha. Regards Nabonita -- Nabonita Guha Library-cum-Information Officer Library, Jawaharlal Nehru Centre for Advanced Scientific Research, Jakkur Post, Bangalore 560064 Karnataka, India Phone: +91-80-22082930 Email: nabonita(a)jncasr.ac.in Web: http://lib.jncasr.ac.in At Wednesday, 20-04-2011 on 5:46 pm Church, Beverly wrote: Nabonita, You can use this query if you want to see the title: SELECT issues.issuedate, items.barcode, biblio.title, borrowers.firstname,borrowers.surname, borrowers.cardnumber, borrowers.categorycode FROM issues LEFT JOIN borrowers ON borrowers.borrowernumber = issues.borrowernumber LEFT JOIN items ON issues.itemnumber = items.itemnumber LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber WHERE issues.issuedate = 'yyyy-mm-dd' If you don't need the title, use this query: SELECT issues.issuedate, items.barcode, borrowers.firstname, borrowers.surname, borrowers.cardnumber, borrowers.categorycode FROM issues LEFT JOIN borrowers ON borrowers.borrowernumber = issues.borrowernumber LEFT JOIN items ON issues.itemnumber = items.itemnumber WHERE issues.issuedate = 'yyyy-mm-dd' * * * * Beverly Church LibLime Project Manager phone: 1-888-564-2457 ext. 717 1-301-654-8088 ext. 292 email: bchurch(a)liblime.com skype: beverlychurch 2011/4/20 nabonita Guha <nabonita(a)jncasr.ac.in> Dear Koha users/Developers, Can you please help me in building SQL statement to generate current checkouts on a given date (not for a date range). For example, I need to generate a report to get list of (barcodes with borrowers card number, surname and firstname and borrower's category with date of issue) were on Loan as on 2011-03-29. Looking forward to hearing from you. With best regards Nabonita -- Nabonita Guha Library-cum-Information Officer Library, Jawaharlal Nehru Centre for Advanced Scientific Research, Jakkur Post, Bangalore 560064 Karnataka, India Phone: +91-80-22082930 Email: nabonita(a)jncasr.ac.in Web: http://lib.jncasr.ac.in _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Need Help
by John Smith 27 Apr '11

27 Apr '11

Hi all Koha Members I had upload my all records after processing with marc edit but I need help to how create authorities and link it with record bibliographic thnks to all John Smith

1 0

Sending Alerts fro transaction
by Basavaraj Kumbar 27 Apr '11

27 Apr '11

Hi, I would like to know how to send alert for transactions? -- *Feel Free To Contact Library For Help* *Warm Regards,* Basavaraj S. Kumbar Librarian, AIMSR (Adept Institute of Management Studies & Research), DHARWAD - 580 011

1 0