- Koha - lists.katipo.co.nz

MARC Record
by ahtshun83 22 Jul '09

22 Jul '09

Hi all, i would like to know where doo all the information store when u add a new MARC record for book as item. I would like to import a bulk of records(books) from Ms Access. i can save the info into CSV and import using SQLyog..but i need to know which database that holds all these info. anyone can assist me? -- View this message in context: http://www.nabble.com/MARC-Record-tp24564566p24564566.html Sent from the Koha - Discuss mailing list archive at Nabble.com.

3 5

Question about the staffClientBaseURL and OPACBaseURL system preferences
by Sébastien Hinderer 22 Jul '09

22 Jul '09

Dear all, I'm wondering whehther these two system preferences are supposed to work onr not. I'm trying to install Koha on a system where I don't have root permission. The only thing I have is a personal web directory where I am allowed to put an .htaccess file. It is worth mentionning that these files can't contain Alias directives and the like. So, I set e.g. staffClientBaseURL to somehost.somedomain.net/koha/intranet/ And then I thought that the URLs generated by Koha would all start with this prefix, but this did not happen. Do I misunderstand something ? Thanks in advance for any help, Sébastien.

1 0

Re: [Koha] problem with koha Mysql connect.
by rekhasaraswat 22 Jul '09

22 Jul '09

Hurrahhhhhhhhhh! I have got my problem solved. I wish to say thanx to every one who spent their valuable time for me. I did the following. 1.sudo cp -a /usr/share/koha/lib/* /etc/perl 2. sudo /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -w and now my catalog search feature is working. ----- Original Message ----- From: Joe Atzberger To: rekhasaraswat Cc: Koha(a)lists.katipo.co.nz Sent: Monday, July 20, 2009 8:35 PM Subject: Re: [Koha] problem with koha Mysql connect. Now the error is that can't connect to local mysql server through the socket var/run/mysqld/mysqld.sock. There can be several causes: 1.. mysqld isn't running, so /var/run/mysqld/mysqld.sock doesn't exist 2.. The socket is leftover from a previously running instance. Shutdown all mysqld processes and remove the sock file. Then restart mysqld. 3.. the location of the sock file is different. read your config and search your machine to see if other mysqld.sock exist. at the same time when i m trying to rebuild zebra it is showing can't find EXPLAIN schema. Sorry, I don't recognize this problem. -- Joe Atzberger LibLime - Open Source Library Solutions

3 4

Re: [Koha] Linking an item to multiple bibliographic records
by Veronica Lencinas 21 Jul '09

21 Jul '09

Hi, shouldn't this be done with the "w" Subfield of the 773 field (Host Item Entry) of Marc21? I have right now this problem in a Library with a lot of analytical records. Regards Verónica Lencinas Córdoba, Argentina --- El vie 19-jun-09, Nicole Engard <nicole.engard(a)liblime.com> escribió: De: Nicole Engard <nicole.engard(a)liblime.com> Asunto: Re: [Koha] Linking an item to multiple bibliographic records Para: "Walls, Ian" <Ian.Walls(a)med.nyu.edu> Cc: koha(a)lists.katipo.co.nz Fecha: viernes, 19 de junio de 2009, 8:09 am Ian, I too used to do something similar when cataloging for an academic library. Once in a while we would catalog the articles in a journal (professors often requested it) and we would then attach the item for the full journal to the article record. I'd add one more suggestion. Add another table to the database that takes care of linking the items to the bibs - this table can just have the ID of the item and ID of the bib - that way you can link the same item to multiple bibs without duplicating all of the information about the item and worrying about syncing. --- Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce(a)liblime.com AIM/Y!/Skype: nengard http://liblime.com http://blogs.liblime.com/open-sesame/ 2009/6/18 Walls, Ian <Ian.Walls(a)med.nyu.edu>: > Koha folks, > > > > > > In the migration process for my library, I’ve come across an odd subset of > records in our existing ILS. This system allows you to link an item record > to multiple bib records. We use this for providing additional access to > certain issues of certain medical journals; these issues are at once a > volume/issue of a series AND a monographic publication with ISBN. Patrons > may look for the resource under either paradigm, either trying to find an > article within (using a journal citation), or obtain a book on a specific > topic (these certain issues are grouped by subject). > > > > Example: > > > > Seminars in Neurology, volume 12 (1992) has the monographic title > “Neurodermatology”. The series record just has the subject heading > “Neurology-Periodicals”, while monographic record has subject heading > “Neurodermatitis” and an authority link to the editor. > > > > Koha’s data structure doesn’t allow a record in the Items table to point to > multiple records in the Biblio and Biblioitems table. Let’s ignore that > Biblio and Biblioitems are split, since there has been discussion of merger > in the future, and best not to hack a solution on something that’ll > disappear. What other ways could we come up with share the item information > between two different bibs? Here are a few of my ideas; I’d love to hear > more! > > > > · Attach the item to the monographic record, and fill in the series > information to match the series record. Add some kind of code to the series > record’s display to show items attached to other bibs with the same ISSN > and/or series title. > > · Attach the item to either record, and then do some kind of field > repurposing in the Item record to include the biblio/biblioitem number of > the other, and have the OPAC display this somehow. > > · Just include a link the monographic record to the series, and tell > people to look there for the item’s location/availability > > · Duplicate the item record, and come up with some kind of way to > sync it… must show both items checked out if one is. > > · Keep the item data in both MARCXML records, but only import the > info into MySQL for one > > · Use the Summary level in Koha 3.2… somehow…. > > > > Have any of you encountered this kind of problem before? What were your > solutions? Does the above make sense? Could something else be done? > > > > Thanks so much, > > > > > > Ian Walls > > Systems Integration Librarian > > NYU Health Sciences Libraries > > (212) 263-8687 > > > > > > ------------------------------------------------------------ > This email message, including any attachments, is for the sole use of the > intended recipient(s) and may contain information that is proprietary, > confidential, and exempt from disclosure under applicable law. Any > unauthorized review, use, disclosure, or distribution is prohibited. If you > have received this email in error please notify the sender by return email > and delete the original message. Please note, the recipient should check > this email and any attachments for the presence of viruses. The organization > accepts no liability for any damage caused by any virus transmitted by this > email. > ================================= > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ____________________________________________________________________________________ ¡Viví la mejor experiencia en la web! Descargá gratis el nuevo Internet Explorer 8 http://downloads.yahoo.com/ieak8/?l=ar

2 1

Re: [Koha] Holds
by Kathy Rippel 21 Jul '09

21 Jul '09

Nicole- We have the OPACDisplayRequestPriority preference turned OFF, and yet it still shows the patron their priority when they place the hold. This can cause problems with alert patrons who later ask why their position dropped (possibly because staff re-ordered for some reason). Is this a bug that needs fixing, or is there something else going on? See example below from our OPAC: ----------------------------------------------------------------------------- Confirm holds for: Dumi Forcara (27434000010890) Hold Title Priority Place On: Pickup Location <http://ckls.kohalibrary.com/cgi-bin/koha/opac-detail.pl?biblionumber=18704>Twilight / , by Meyer, Stephenie, 13 out of 12 Next available copy A specific copy Central Kansas Library System ------------------------------------------------------------------------ Kathy At 09:26 AM 7/10/2009, Nicole Engard wrote: ><snip> >Patrons can see where they are in the queue if you turn on the >OPACDisplayRequestPriority system preference - if you don't turn this >on - you as staff can still see where people are in the queue by >clicking the holds tab on the record itself in the staff client. ><snip> >Nicole C. Engard >Open Source Evangelist, LibLime >(888) Koha ILS (564-2457) ext. 714 >nce(a)liblime.com >AIM/Y!/Skype: nengard > >http://liblime.com >http://blogs.liblime.com/open-sesame/ Kathleen D. Rippel Dept. Head/Consultant--Resource Sharing and Access ; Pathfinder Central (Manager) Central Kansas Library System 1409 Williams Great Bend, KS 67530 (620-792-4865) phone (800-362-2642) toll-free, KS (620-792-5495) fax kdr(a)ckls.org ******************************************************************************************** I'm currently reading: The Myriad: Tour of the Merrimack #1, by R. M. Meluch. I'm currently listening to: Eclipse, by Stephenie Meyer.

2 1

Advanced search - "Audience" limiter
by Justin Davis 20 Jul '09

20 Jul '09

Hello All, I'm running Koha 3.0.3 & am trying to figure out how to make use of the "Audience" limiter within the advanced search. From looking at the documentation (http://koha.org/documentation/manual/3.0/searching/guide-to-searching/commo…) it looks like the "aud" notation relies on a specific index, I just can't figure out what that index is. There is no mention of it (that I can find) in the z39.50 Bib-1 attribute documentation. Can anyone point me in the right direction? The only relevant MARC21 field definition that I can find is the "521 - Target Audience Note". Am I missing something in the Koha<->MARC mapping definition? Thank you kindly, Justin Davis -- Sr. Systems Analyst Liberal Arts ITS University of Texas at Austin

2 2

zebra indexes are not working
by Z. Iqbal 20 Jul '09

20 Jul '09

hi i am working on koha3 with debian 5. i have imported about 68000 marc records through koha3 interface(staged,then import) with small files about 100 marc record in each file and zebra services have been working properly. the problem arises when i imported 69000 marc record the zebra service get stop and after 68000 record, no records have been search by zebra. can any one have the same problem. i donot know what to do? regards, z.iqbal -- View this message in context: http://www.nabble.com/zebra-indexes-are-not-working-tp24566711p24566711.html Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

problem with koha Mysql connect.
by rekhasaraswat 20 Jul '09

20 Jul '09

Dear Vimal, Myself Rekha saraswat from CDAC, Noida. I m using BOSS Linux(Debian). i have installed idzebra2.0 ,Net-Zoom package, YAZ3.0.38 Now the error is that can't connect to local mysql server through the socket var/run/mysqld/mysqld.sock. at the same time when i m trying to rebuild zebra it is showing can't find EXPLAIN schema. this problem is only with catalog search. rest of the things are working fine. kindly help me, if you can understand my problem. Regards Rekha

3 2

acquisitions and end of budget year
by Lexa Long 20 Jul '09

20 Jul '09

To All: I am using Koha 3.00107. I am only using Acquisitions. I did not step up this system and have no technical support and I am not a techie. I am trying to enter my budget information for the current fiscal year. I need an explanation and a solution to a current problem. I have entered the new year's budget dates and amounts. These appear to have taken. On the main acquisitions screen the expenditures from last year's budget are also appearing. See below Funds and Budgets [ Manage ] <http://koha.shepherd.edu:8080/cgi-bin/koha/admin/aqbookfund.pl> Budgets Total Spent Comtd Avail Arts & Humanities Books 10508.33 <http://koha.shepherd.edu:8080/cgi-bin/koha/admin/aqbudget.pl?op=add_for m&aqbudgetid=80> 12325.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/spent.pl?bookfund=AHBK S&start=2009-07-01&end=2010-07-20> 0.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/bookfund.pl?bookfund=A HBKS&start=2009-07-01&end=2010-07-20> -1816.67 Arts & Humanities Media 750.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/admin/aqbudget.pl?op=add_for m&aqbudgetid=81> 1110.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/spent.pl?bookfund=AHME &start=2009-07-01&end=2010-07-20> 0.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/bookfund.pl?bookfund=A HME&start=2009-07-01&end=2010-07-20> -360.00 Arts & Humanities Periodicals 14000.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/admin/aqbudget.pl?op=add_for m&aqbudgetid=82> 13479.96 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/spent.pl?bookfund=AHPE R&start=2009-07-01&end=2010-07-20> 0.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/bookfund.pl?bookfund=A HPER&start=2009-07-01&end=2010-07-20> 520.04 Arts & Humanities Standing Orders 2700.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/admin/aqbudget.pl?op=add_for m&aqbudgetid=83> 2783.44 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/spent.pl?bookfund=AHSO &start=2009-07-01&end=2010-07-20> 0.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/bookfund.pl?bookfund=A HSO&start=2009-07-01&end=2010-07-20> -83.44 Business & Social Sciences Books 9958.33 <http://koha.shepherd.edu:8080/cgi-bin/koha/admin/aqbudget.pl?op=add_for m&aqbudgetid=84> 956.13 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/spent.pl?bookfund=BSBK S&start=2009-07-01&end=2010-07-20> 0.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/bookfund.pl?bookfund=B SBKS&start=2009-07-01&end=2010-07-20> 9002.20 Business & Social Sciences Media 1500.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/admin/aqbudget.pl?op=add_for m&aqbudgetid=85> 1063.70 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/spent.pl?bookfund=BSME &start=2009-07-01&end=2010-07-20> 0.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/bookfund.pl?bookfund=B SME&start=2009-07-01&end=2010-07-20> 436.30 Business & Social Sciences Periodicals 13500.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/admin/aqbudget.pl?op=add_for m&aqbudgetid=86> 11555.17 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/spent.pl?bookfund=BSPE R&start=2009-07-01&end=2010-07-20> 0.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/bookfund.pl?bookfund=B SPER&start=2009-07-01&end=2010-07-20> 1944.83 Business & Social Sciences Standing Orders 3000.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/admin/aqbudget.pl?op=add_for m&aqbudgetid=87> 5915.71 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/spent.pl?bookfund=BSSO &start=2009-07-01&end=2010-07-20> 0.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/bookfund.pl?bookfund=B SSO&start=2009-07-01&end=2010-07-20> -2915.71 Electronic Resources 109460.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/admin/aqbudget.pl?op=add_for m&aqbudgetid=88> 114652.44 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/spent.pl?bookfund=ELEC &start=2009-07-01&end=2010-07-20> 0.00 <http://koha.shepherd.edu:8080/cgi-bin/koha/acqui/bookfund.pl?bookfund=E LEC&start=2009-07-01&end=2010-07-20> -5192.44 Total 165376.66 163841.55 0.00 1535.11 Can any one explain why this is happening? What do I need to do to get rid of these numbers and have them appear as 0.00 amounts? The manual does not give any procedures for changing fiscal years so I do not know if I missed a step and things are not a simple as they seem. Thank you for all of your help in advance. Lexa V. Long Acquisions Associate Scarborough Library Shepherds University P. O. Box 5001 Shepherdstown, WV 25443 (304) 876-5417 OFFICE (304) 876-0731 Fax llong(a)shepherd.edu

1 0

Koha benchmarks
by Marcel de Rooy 20 Jul '09

20 Jul '09

Hi all, Does anyone of you have some Apache benchmarks for me, just to give me an idea of the performance of other Koha servers? Run e.g. something like: ab -kc 8 -t 10 http://yourkohaserver:port/ **REPLACE with your own server** My performance currently is quite poor: Document Path: / [OPAC] Document Length: 8159 bytes Concurrency Level: 8 Time taken for tests: 10.382 seconds Complete requests: 9 Failed requests: 0 Write errors: 0 Keep-Alive requests: 0 Total transferred: 109460 bytes HTML transferred: 106067 bytes Requests per second: 0.87 [#/sec] (mean) Time per request: 9228.848 [ms] (mean) Time per request: 1153.606 [ms] (mean, across all concurrent requests) Transfer rate: 10.30 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 0 43 52.6 39 133 Processing: 4841 5444 250.4 5491 5702 Waiting: 4337 4946 309.4 5068 5242 Total: 4841 5487 280.5 5517 5779 Percentage of the requests served within a certain time (ms) 50% 5493 66% 5541 75% 5702 80% 5746 90% 5779 95% 5779 98% 5779 99% 5779 100% 5779 (longest request) Thanks! Regards, M. de Rooy

1 0