- Koha-devel - lists.koha-community.org

KHOA developer needed (work from home)
by Steven Saunders 07 Oct '10

07 Oct '10

Greetings, I am looking for a strong Perl developer to work on a KOHA based book/document imaging and library management system. The customer is headquartered near the East coast and this is a work from home remote development position. Both contract or employment arrangements are possible. TECHNICAL QUALIFICATIONS - Strong Perl Developer, mySQL, and Linux environments - 3 to 5 years experience preferably with larger applications - Experience in the library (electronic book management) industry a plus, but not a requirement - Experience with KOHA a plus, but not a requirement - Remote OK, employee or contractor OK PERSONAL QUALIFICATIONS These are at least as important as your technical qualifications (and the basis my business success) - Complete integrity, no exceptions - Strong problem solver who is highly productive and who always delivers - Customer focused, easy to work, no drama If this sounds like you please let me know, I would love to work with you Steve Saunders Steven Saunders Founder and Principal Sentosa Technology Consultants Cell 303.809.8043 Fax 303.834.8853 Email <mailto:steve@sentosatech.com> steve(a)sentosatech.com Web <http://www.sentosatech.com/> www.sentosatech.com AIM SteveAtSentosa cid:image001.jpg@01C9EFFC.ECB10130

1 0

[koha] mail configuraiton help
by Nitesh Rijal 05 Oct '10

05 Oct '10

Hello all. I have been running koha in my server for about 10 libraries. Each of them have a different public IP for accesssing. What are the things that I need inorder to use the mail functionality for sending overdue notices and other related functions? Is there some step by step guide for it? We already have a mail server at some other IP address, so is it possible to use that server as mail server for koha as well or is it necessary that the machine that has koha server, should also have mail server configured in it? Please reply. Regards. -- Nitesh Rijal BE IT rijal.it(a)gmail.com http://niteshrijal.com.np http://facebook.com/openrijal http://twitter.com/openrijal +9779841458173

4 8

Item barcode prefixes in 3.2
by Linda Culberson 04 Oct '10

04 Oct '10

I apologize for another newbie question, this time regarding item barcode prefixes in 3.2: We are a single-branch library that has B in front of our item barcodes which are then auto-incremental. However, unlike the documentation there is not a set itembarcodelength. So that an item barcode could be B1 or it could be B1245351. There is nothing in front of the patron barcodes which are also auto-incremental, and the B in front of the item barcode just lets us know that it applies to an item and not a person. Do I need to use javascript to handle this or is there a setting(s) that I can use for a single branch system? What I have been reading seems to apply only to consortia, and I was unclear as to whether this was still a RFC or something that was already handled in 3.2. 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 Facsimile: 601/576-6824

2 1

October Newsletter Call for Articles
by Nicole Engard 30 Sep '10

30 Sep '10

It's that time again, the next newsletter will be published in a couple of weeks. I need any and all announcements/tips/tricks/news/koha events sent to me by the 13th of October if I'm to get the newsletter out on time. Articles should be short and if you have a lot to say then send along a link to the full article. Remember you don't have to write a whole lot, just a short 2 liner is A-OK! Thanks in advance, Nicole C. Engard

1 0

mysqldump & restore issues
by Christopher Curry 29 Sep '10

29 Sep '10

Hello all, I'm trying to create a mirrored failover server with data from our live Koha. In order to do so, I'm using *mysqldump* and *mysql* for backup and restore. I've discovered a troubling problem and I can't determine the cause. I run this command to backup the live server: *mysqldump --single-transaction -ukoha -p koha > /home/koha/KohaServerBackups/koha.`/bin/date +\%Y\%m\%d\%H\%M\%S`.sql* This seems to work correctly (and very quickly! 1.7 GB database exports in 2 min) Then, I run this command: *mysql -v -ukoha -p koha < /home/koha/KohaServerBackups/backupFileName.sql* This also seems to work, as I receive no warnings or error messages. I'm exporting from a 3.00.05.001 system and importing to a 3.00.05.003 system, so I then run the *$KOHA_SOURCE/installer/data/mysql/updatedatabase.pl* script. Relevant specs: MySQL version: mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 OS: Debian Lenny Failover server is virtual, running on VirtualBox 3.2.8, on an Ubuntu 10.4 host. All GUI functions of the Koha failover server seem to operate correctly, but when I run *mysqlcheck -ukoha -p koha* the check fails on koha.biblioitems with the following error message: mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'CHECK TABLE ... ' If I try mysqldump, I get the same error, but it is more specific, reporting that it falls on row 41536. If I check /var/log/syslog, I see this http://pastebin.com/YuuFBHry "InnoDB: Database page corruption on disk or a failed file read of page 58164", etc. Both mysqlcheck & mysqldump work without error on the live server, so I'm thinking that something must be happening to the data during the export or import that corrupts the InnoDB data, but this is speculation, since I'm not a MySQL expert. Has anyone seen behavior like this? Any suggestions for further troubleshooting/resolution? -- Cheers, Christopher Curry Assistant Technical Librarian / Assistant IT Officer American Philosophical Society 105 South Fifth Street Philadelphia, PA 19106-3386 Tel. (215) 599-4299 ccurry(a)amphilsoc.org <mailto:ccurry@amphilsoc.org> Main Library number: (215)440-3400 APS website: http://www.amphilsoc.org

3 8

Proposal to change phone and email language on patron
by Nicole Engard 25 Sep '10

25 Sep '10

Hi all, I was talking with some librarians today and they were wondering if we could change the language on the patron record. Instead of saying Phone (home) could it read Phone (primary)? This suggestion came from the fact that many people now have only a cell phone and if you enter that number in the Phone (cell) box you don't see it on the transit slips or the patron record quick view on the left. This suggestion carries over to the email addresses as well. I recommend we use Primary, Secondary, and Tertiary instead of Home, Work, Cell so that the librarians and patrons can decide what's most important for the patron. What do you all think? Anyone have any strong feelings either way? I will gladly make the change if others think this makes sense, but I wanted to bring the question to you all first. Thanks Nicole C. Engard

7 15

The work on bibliografic relationships (RFC 3.4 Analytic Record support)
by Zeno Tajoli 24 Sep '10

24 Sep '10

Hi to all, as I say, I have a sponsor to develop this RFC. Savitra Sirohi wrote here that want to do the work in Oct 2010. I can also work on this RFC in Oct 2010, but also later. Probably aslo one person from ByWater has a task on this RFC (Ian Walls?) Are there others developers ? I think we need to start to coordinate ourselves. Do we need a bug on bugzilla ? A specific git server / branch ? How to develop in parallel ? I have add a chat log about this RFC in http://wiki.koha-community.org/wiki/Talk:Analytic_Record_support I also add same consideration about MARC21 and Unimarc here: http://wiki.koha-community.org/wiki/Analytic_Record_support#MARC21_and_Unim… My consideration: --I dont' want to use the embedded fields in Unimarc, too complex to use --In the near future I will add a optional plugin in z39.50 section to traslate Unimarc 4xx fields done with embedded fields to 4xx fields with standard fields. In Italy all Unimarc z39.50 server use embedded fields. -- I like the idea to have all relation in SQL tables but with the option to insert them into MARC data. For me the default is 'insert them into MARC, select to not insert' -- I suggest the idea to work manly with cataloguing plugins Bye Zeno -- Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci qaunto tra AT con @)

1 0

Should CSS file be outside the translated path?
by Owen Leonard 20 Sep '10

20 Sep '10

I've been working on Bug 4048, "js libs must be outside of translated paths." http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4048 Is there any reason why CSS files should not also be moved? -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

2 1

Invitation to join KUDOS
by Ian Walls 16 Sep '10

16 Sep '10

Everyone, The KUDOS board is inviting all North American institutions with an installation of Koha to become a member. If you join now as a charter member, there will be no registration fee through 2011 (since we don't yet have non-profit status, nor an agreed-upon due structure). If you wish to become a member of KUDOS, we ask that you fill out this simple online form<https://spreadsheets.google.com/viewform?hl=en&pli=1&formkey=dG84YjZKbHZPQV…> . Of course, we are looking for volunteers to do all kinds of things, so please check off the categories in which you are interested. Positions on the board are available! Once we have a good base of interest, we can all begin moving forward with determining how KUDOS can serve the greater Koha community. Thank you for your interest. Ian Walls (Acting) President, KUDOS

1 0

Error on Index 'Any' when searching authorities
by Tomas Cohen Arazi 16 Sep '10

16 Sep '10

When searching for authorities putting my search string on "Anywhere" y get no results, and the logs show: auth_finder.pl: oAuth error: Unsupported Use attribute (114) Any Bib-1 I was first recommended to review some threads about the topic (thanks jcamins) of the 'Heading-main' index, but I had no positive results. Reindexing yielded the same (null) results everytime. Then I remebered having switched recently to 'dom' model for authorities... because it was recommended during the install (at least in the 3.0.x branch, If I'm not wrong it was alleged more efficient). The thing is that when I switched back to grs1, I got my query results back! I think 'dom' usage should be discouraged until this is fixed. Thanks To+

4 7