- Koha - lists.katipo.co.nz

how can i view all the contents of the libary
by tanzeem 13 Dec '11

13 Dec '11

hi I want to view all the records in the library in ISBD format Is this possible. Please help... with thanks in advance regards -- View this message in context: http://koha.1045719.n5.nabble.com/how-can-i-view-all-the-contents-of-the-li… Sent from the Koha-general mailing list archive at Nabble.com.

3 3

Well, this is disappointing ...
by Cab Vinton 13 Dec '11

13 Dec '11

http://www.librarytechnology.org/ltg-displaytext.pl?RC=16375 "LibLime Academic Koha to be used by University Students in Spring Semester 2012 [Dec. 8, 2011] Spring semester 2012, three schools are joining LibLime in the Koha with Class program. The three schools working with LibLime on this project include: The School of Library and Information Science at Indiana University; The Information School at the University of Washington Gallagher; and the Graduate School of Library and Information Science at Simmons College. Library school students at these three Universities – taking classes in library automation and technology systems -- will be studying the principles for design, selection, implementation and management of automated systems of all types in libraries. Each course will cover the use of ILSs for technical service processing, reference and user services, and management. Both courses will include presentations and demos from vendors and systems librarians and possible site visits to libraries using ILS systems in their day-to-day operations." Free hosting is a nice bonus, but still ... Cab Vinton, Director Sanbornton Public Library Sanbornton, NH "Politeness and consideration for others is like investing pennies and getting dollars back." Thomas Sowell

6 8

3.4.4 -> 3.6.1 upgrade
by Alen Vodopijevec 12 Dec '11

12 Dec '11

Dear all, during test upgrade of our Koha instance installer drops following errors: [Mon Dec 12 15:53:15 2011] 404.pl: Database update needed, redirecting to Installer. Database is 3.0404001 and Koha is 3.0601000 at /usr/share/koha/lib/C4/Auth.pm line 616. [Mon Dec 12 15:53:30 2011] install.pl: The following errors were returned while attempting to run the updatedatabase.pl script: [Mon Dec 12 15:53:30 2011] install.pl: [Mon Dec 12 15:53:25 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'BasketConfirmations' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4374. [Mon Dec 12 15:53:30 2011] install.pl: [Mon Dec 12 15:53:30 2011] install.pl: [Mon Dec 12 15:53:27 2011] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'issuesitemidx'; check that column/key exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4425. [Mon Dec 12 15:53:30 2011] install.pl: [Mon Dec 12 15:53:30 2011] install.pl: [Mon Dec 12 15:53:27 2011] updatedatabase.pl: DBD::mysql::db do failed: Multiple primary key defined at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4426. [Mon Dec 12 15:53:30 2011] install.pl: [Mon Dec 12 15:53:30 2011] install.pl: [Mon Dec 12 15:53:29 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate key name 'priorityfoundidx' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4436. Is it safe to ignore them or do I have to change something in my setup/database? Regards, alen -- Alen Vodopijevec (alen(a)irb.hr) Library, Rudjer Boskovic Institute tel.: +385 1 456 0954 (x1293) gsm: +385 98 584 045 http://lib.irb.hr http://katalog.irb.hr

2 1

Please shutdown the site of Koha Windows version
by Vimal Kumar 12 Dec '11

12 Dec '11

Dear Friends, Many people are downloading Koha Windows version from www.koha.rwjr.comsite and installed in their library and send many query regarding about it. They are newbies to Koha and don't know windows version is obsoleted one. My humble request to Koha Windows version developer is that either shut down the site or give proper message to visitors that development of Windows version is stopped. Installation of Koha in Windows is troublesome and can break anytime. Many librarians entered their whole data in Koha Windows version and after that they know that the version is not updated. They feel difficult to convert their data to latest version of Koha. Windows is not a good platform for Koha production system. Regards, -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: www.vimalkumar.org Blog: http://linuxhalwa.blogspot.com --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

3 2

Cannot Place Hold
by Vimal Kumar 12 Dec '11

12 Dec '11

Dear Friends, I got following message when I try to pace a hold, Cannot Place Hold Too Many Holds: Thomas has too many holds No copies are available to be placed on hold. My Koha version is 3.4.6. Please suggest a solution? -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: www.vimalkumar.org Blog: http://linuxhalwa.blogspot.com --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

3 2

Database update errors
by Perch 12 Dec '11

12 Dec '11

Upon updating koha to the latest version I got these error when running database update: [Mon Dec 12 13:04:03 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'hold_fill_targets' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 1983. [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AllowRenewalLimitOverride' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2049. [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'reserves-HOLD' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2063. [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '4' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2067. [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '4-sms-0' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2068. [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '4-email-0' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2069. [Mon Dec 12 13:04:05 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate key name 'issn' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2076. [Mon Dec 12 13:04:06 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'branch_transfer_limits' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2112. [Mon Dec 12 13:04:07 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '1-override_renewals' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2132. [Mon Dec 12 13:04:08 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'branch_item_rules' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2166. [Mon Dec 12 13:04:08 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'default_branch_item_rules' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2177. [Mon Dec 12 13:04:10 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'item_circulation_alert_preferences' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2199. [Mon Dec 12 13:04:11 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'ccode' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2238. [Mon Dec 12 13:04:12 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'OPACAmazonCoverImages' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2274. [Mon Dec 12 13:04:12 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AmazonCoverImages' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2276. [Mon Dec 12 13:04:12 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'smsalertnumber' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2312. [Mon Dec 12 13:04:13 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AmazonReviews' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2391. [Mon Dec 12 13:04:13 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'AllowNotForLoanOverride' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2409. [Mon Dec 12 13:04:14 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'RenewalPeriodBase' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2426. [Mon Dec 12 13:04:20 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'export_format' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2695. [Mon Dec 12 13:04:20 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'fieldmapping' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2709. [Mon Dec 12 13:04:20 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'finedays' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2766. [Mon Dec 12 13:04:24 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'aqbudgets' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2951. [Mon Dec 12 13:04:24 2011] updatedatabase.pl: DBD::mysql::db do failed: Unknown column 'aqbudgetid' in 'aqbudgets' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2955. [Mon Dec 12 13:04:24 2011] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'startdate'; check that column/key exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3003. [Mon Dec 12 13:04:25 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'aqorders_items' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3123. [Mon Dec 12 13:04:26 2011] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'budget_amount_sublevel'; check that column/key exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3177. [Mon Dec 12 13:04:27 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'deliveryplace' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3239. [Mon Dec 12 13:04:28 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'billingplace' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3288. [Mon Dec 12 13:04:31 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'collections' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3377. [Mon Dec 12 13:04:31 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'collections_tracking' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3387. [Mon Dec 12 13:04:35 2011] patroncards_upgrade.pl: DBD::mysql::db do failed: Table 'creator_batches' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/patroncards_upgrade.pl line 149. [Mon Dec 12 13:04:35 2011] patroncards_upgrade.pl: DB ERROR: Table 'creator_batches' already exists [Mon Dec 12 13:04:35 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'csv_separator' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3418. [Mon Dec 12 13:04:35 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'encoding' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3429. [Mon Dec 12 13:04:48 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'privacy' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3997. [Mon Dec 12 13:04:48 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'privacy' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3998. [Mon Dec 12 13:04:51 2011] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'freedeliveryplace' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4251. [Mon Dec 12 13:04:58 2011] updatedatabase.pl: DBD::mysql::db do failed: Table 'need_merge_authorities' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4535. Will these be a problem or is it safe to just ignore them? Most of them seem to be related to data already existing in the database with this exception: [Mon Dec 12 13:04:24 2011] updatedatabase.pl: DBD::mysql::db do failed: Unknown column 'aqbudgetid' in 'aqbudgets' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2955. -- View this message in context: http://koha.1045719.n5.nabble.com/Database-update-errors-tp5068234p5068234.… Sent from the Koha-general mailing list archive at Nabble.com.

1 0

Regarding the book entry
by dawit.ayalew＠tabyengineering.com 09 Dec '11

09 Dec '11

Dear sure, I can't manage to insert book to the koha library and also connect the z3950 it would be great if you guys give me small examples and steps to be done. Thanks!!! I also tried zotero to perform this task but I can't manage to get it work with koha ILS. Best Regards, -- *Dawit Ayalew Software Development TABY Engineering P.L.C. at GIZ IS Bole Road, TK International Building No. 2 5th Floor Room No. 502 Addis Ababa, Ethiopia T: +251 11 662 22 60 Ext. 5024 +251 11 618 38 50 M: +251 91 180 07 08 E: dawit.ayalew(a)tabyengineering.com I: www.tabyengineering.com *

2 1

Is it possible to take an XML feed of individual records and bring it into Koha or MARC format?
by Hartman, David W. - GBTS Library 09 Dec '11

09 Dec '11

Is it possible to take an XML feed of individual records and bring it into Koha or MARC format? Gartner can only send their article records to me as XML ... I don't know how to get it from XML to MARC.. David W. Hartman Global Business Technology Strategy Library Team Disney 336N 407 828 4250 (8-222) FAX 407 828 4868 FOLLOW MY RESEARCH on Backlot<http://backlot.disney.com/> & Yammer<http://www.yammer.com/>! Learn about our research partners in the 2011 IT Research Competency Center <http://tink.corp.disney.com/?i=n7a> GBTS CAST can click to request AV Equipment<http://tink.corp.disney.com/?i=jbo>, Books<http://tink.corp.disney.com/?i=jbp>, & Research<http://tink.corp.disney.com/?i=jbn> WATCH the GBTS Library (Video) Update<http://tink.corp.disney.com/?i=2f0> ! CLICK for the GBTS VIRTUAL LIBRARY<http://tink.corp.disney.com/?i=1wn>portal site!! "This communication is confidential, intended only for the named recipients above and may contain trade secrets or other information that is exempt from disclosure under applicable law. Any use, dissemination, distribution or copying of this communication by anyone other than the named recipients is strictly prohibited. If you have received this communication in error, please immediately notify us by calling (407) 828-4250. Thank you." [cid:image001.gif@01CCB65C.1A36D7B0]Please consider your environmental responsibility before printing this e-mail [cid:image001.gif@01CCB65C.1A36D7B0] Think Environmentality! Reduce! Reuse! Recycle!

2 3

How can i get serial number in the generated reports
by tanzeem 09 Dec '11

09 Dec '11

Hi I have generated a report using the guided report option. Since i have deleted some records while entering records i dont have some of the biblionumbers as valid.So i dont get a report arranged in an increasing order of serial number from 1 to the total number of rows in the generated reports . How can I get this. Please help... with thanks in advance -- View this message in context: http://koha.1045719.n5.nabble.com/How-can-i-get-serial-number-in-the-genera… Sent from the Koha-general mailing list archive at Nabble.com.

1 0

Re: [Koha] Improving permissions on lists (virtual shelves)
by Adalid Ortiz 08 Dec '11

08 Dec '11

Oh sorry, is not my Koha Opac is an Argentina Koha fork based on version 2.x my opac is 3.4 and is located at http://clavius.tij.uia.mx the funcionality i want is: LISTS Architecture *** History of art I [list of related bibliography] *** Computer Aided Design II [list of related bibliography] * Computer Science *** Calculus I [list of related bibliography] *** Algebra I [list of related bibliography] etc. Administred by one person but all can see it. Saludos, Felipe Adalid Ortiz Anzaldo Bibliotecario de sistemas Universidad Iberoamericana Tijuana Biblioteca Loyola http://clavius.tij.uia.mx Ave. Centro Universitario 2501 Playas de Tijuana 22200, Tijuana, B.C. 0 664 630-1577 Ext. 623 adalid(a)tij.uia.mx

1 0