- Koha - lists.katipo.co.nz

Re: [Koha] Recent Comments page
by Randall Rowe 17 May '12

17 May '12

My personal choice for a database such as this would be MySQL since it's already installed for Koha :-) Randy Rowe Lincoln City Libraries I.T. -----Original Message----- From: "glaws" <glawson(a)rhcl.org> Sent 5/16/2012 3:40:33 PM To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Recent Comments page Sue: I found the cemetary link on your Koha OPAC site interesting. Here's a sample pull I was looking at: http://public.stdc.govt.nz/cemeteries/ Record Number : 4425 Name : Estate of Charlotte Ann Smith Section : Eltham General Anglican New Plot ID : 105 Block : 10 Row : Old Plot No : 16 Interment Status : Occupied Plot Notes : X Coord : Y Coord: Funeral Co-ordinator : Date Of Death : 12/12/1964 Date Of Interment : 14/12/1964 Date Of Birth : Type Of Interment : Burial Depth Of Plot : Double Deceased Age - Years : 0 - Months : 0 - Weeks : - Days : - Hours : Occupation : Place Of Death : Marital Status : Gender : Denomination : Anglican Nationality : Birth Place : Headstone Photo : Officiating : Obviously this isn't databased in Koha, so apparently you have this in a custom (Microsoft?) database? Anyone: I rather wonder if DSpace would be a good DB for this type of info? ----------------------------- Greg Lawson Network Administrator Rolling Hills Consolidated Library 1912 N. Belt Highway St. Joseph, MO 64506 ------------------------------ On 05/16/2012 03:15 PM, Sue McMillan wrote: > Hi Hal, > > South Taranaki District Libraries have comments available. http://ils.stdc.govt.nz > > > Susan McMillan > Cataloguing and Systems Librarian| South Taranaki District Council > 105-111 Albion St, Private Bag 902, Hawera 4610, NZ > Phone: +64 6 278 0555 | www.southtaranaki.com > > > > > -----Original Message----- > From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Hal Bright > > Does anyone have the recent comments page options activated on their public catalog? I would like to take a look at it. > > > This e-mail and any attachments may contain confidential and > privileged > information. If you are not the intended recipient, please notify the > sender immediately by return e-mail, delete this e-mail and destroy > any > copies. Any dissemination or use of this information by a person other > than the intended recipient is unauthorised and may be illegal. Please > note that this communication does not designate an information system > for the purposes of the Electronic Transactions Act 2002. > > <p><b>CAN'T OPEN ATTACHMENTS?</b></p> > The Council has upgraded to Microsoft office 2007 suite. This may mean you cannot open attachments if you have older versions of office. <a href="http://www.microsoft.com/downloads/details.aspx?familyid=941B3470-3AE9-4AEE…"> Click here to access Microsoft Office 2007's compatibility website.<a/> > _______________________________________________ > 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 ��

2 1

Re: [Koha] Printing Dewey spine labels in Koha 4.06
by Randall Rowe 17 May '12

17 May '12

Morning. To print our labels, we use Bartender labeling software. We design the labels in Bartender and use the MySQL ODBC connector to get the label data. Works sooooo much better than the Koha export to PDF functionality. Feel free to use whichever labeling software you chose as a substitute for Bartender. Randy Rowe Lincoln City Libraries I.T. -----Original Message----- From: "jpisunyer" <jpisunyer(a)gmail.com> Sent 5/14/2012 9:24:36 PM To: koha(a)lists.katipo.co.nz Subject: [Koha] Printing Dewey spine labels in Koha 4.06 Could anyone help me print a Dewey spine label in Koha 4.06? I have an error message and also am not sure of the logistics - do I get a single-label printer and do one at a time? I am setting up a new library in Baltimore, MD, USA and have about 4,000 books to label. Here is the error message: Koha error The following fatal error has occurred: DBD::mysql::st execute failed: Table 'koha_bcpss.printers_profile' doesn't exist at /home/ptfs/kohaclone/C4/Labels/Lib.pm line 215. ApacheServer version: Apache/2.2.9 (Debian) Server built: Apr 20 2010 15:42:00 Koha4.06.00.000 Koha DB4.0600000 MySQLmysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (x86_64) using readline 5.2 OSLinux KOHAPROD 2.6.26-2-amd64 #1 SMP Sun Jun 20 20:16:30 UTC 2010 x86_64 Perl5.010000 Thank you. jpisunyer -- View this message in context: http://koha.1045719.n5.nabble.com/Printing-Dewey-spine-labels-in-Koha-4-06-… Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ��

1 0

Show us your OPACs
by Peter Aronson 17 May '12

17 May '12

I'm working on our OPAC right now and I'd like to see what other people have done with their OPACs… How have you customized the OPAC? How are you using the HTML areas? Please describe and/or include a link to your OPAC or to a screenshot if your OPAC is not publicly accessible. Best regards, Peter

6 5

Search results not correct
by anjoze 17 May '12

17 May '12

Hi, I'm trying to improve search results using zebra. I'm using UNIMARC. I've tested it with version 3.2 and 3.8 My search is working but not 100%, the results are not displayed in the correct order. I've changed "Relevance" to other options but the problem still. For example, when I search for "História de Portugal" I get: 907 result(s) found for 'wrdl: "história de portugal"'. The problem is that the book with the name "história de portugal" should come in first place but is on page 10, it's on 186º position. I think that my zebra is searching for the "de" word! O maybe even Koha doesn’t like the Portuguese History :) I've tried to set the "marc_defs/unimarc/biblios/record.abs" the best I can but without success. Is the any example of configuration files record.abs, ccl.properties and bib1.att for UNIMARC? Thanks for any help, JA -- View this message in context: http://koha.1045719.n5.nabble.com/Search-results-not-correct-tp5709185.html Sent from the Koha-general mailing list archive at Nabble.com.

1 1

Listing update-or-removal requests
by MJ Ray 16 May '12

16 May '12

The following entries on http://koha-community.org/support/paid-support/ have email addresses that bounce, discovered during kohacon-related tasks. Busara Core Solutions Email: bmugambi(a)gmail.com, mugambi(a)busara.co.ke Categories: Africa, Uncategorized host ASPMX.L.GOOGLE.COM [173.194.78.27]: 550-5.1.1 The email account that you tried to reach does not exist. Only the address @busara seems to fail, so I guess it could be fixed just by removing that address from the listing. Is that OK? The following have only bouncing email addresses. So I guess from http://koha-community.org/support/paid-support/how-to-get-listed/ that I should ask the Koha webmasters to consider removing them if updates aren't supplied. Is that OK? Pakistan Library Automation Group (PakLAG) Email: paklagkoha(a)paklag.org Categories: Asia, Pakistan host paklag.org [184.107.71.193]: 550 Mailbox quota exceeded OSLO Ltd OSLO Ltd Email: peter(a)oslo.ie Categories: Europe, Ireland, Uncategorized host aspmx.l.google.com [173.194.78.27]: 550-5.1.1 The email account that you tried to reach does not exist. Sorry to suggest that, but I feel it gives potential users a bad impression if unreachable support companies are listed on the official website. Hope that helps, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/

2 1

Inactive borrowers report
by Cab Vinton 16 May '12

16 May '12

The SQL Reports Library contains a couple of reports for inactive borrowers: http://wiki.koha-community.org/wiki/SQL_Reports_Library#Inactive_Borrowers SELECT DISTINCT borrowers.surname, borrowers.firstname, borrowers.cardnumber, borrowers.email FROM borrowers WHERE NOT EXISTS (SELECT borrowernumber FROM statistics WHERE borrowers.borrowernumber = borrowernumber AND statistics.datetime >= 'YYYY-MM-DD') http://wiki.koha-community.org/wiki/SQL_Reports_Library#Patrons_with_No_Che… SELECT surname, firstname, cardnumber FROM borrowers WHERE borrowernumber NOT IN (SELECT DISTINCT borrowernumber FROM statistics WHERE type = 'issue' AND datetime BETWEEN <<Between (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>>) I'd like to modify either of these to create a report that includes the last date of activity for each patron inactive since a given date (last activity is an item either being checked in or returned). Anyone have pointers on how to achieve this? It's beyond my current minimal level of SQL-fu. Many thanks, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH Life is short. Read fast!

1 0

MySQL Database Restoring Problem from 3.4.x to 3.8.0
by Andi Sugandi 16 May '12

16 May '12

Hi all, The Koha 3.8.0 installation has no problem: http://goo.gl/WPBSC , but when restoring MySQL database from Koha 3.4.x to 3.8.0 I have an error message: ERROR 1005 (HY000) at line 2273: Can't create table 'kohadb.letter' (errno: 150) Any clue? Thanks in advance. Best regards, -- Andi Sugandi.

1 0

Re: [Koha] Multi-Lingual SQL & User Defined Parameters
by Karam Qubsi 16 May '12

16 May '12

Hi Dear Mr Massoud , Dear all, I think this will be very helpful for the people who don't want to use the English interface in Koha , and as you say when we finish translating koha 3.8 to Arabic ( very soon inshaallah) , we will have problems with the people who want to use koha in Arabic and english in the same time e.g: May be some Arab librarian prefer to use koha English interface for the staff client , and in the case that we've used the translated sql files (that your company provided it to us) for the marc21 the Arab librarian who want to use the English interface will have a problem because all the staff client will be in english except for the marc records and if we use the English version of the marc21 sql files the problem will be that the Arab librarian who will use the Arabic interface will see the marc fields in english so if we want to use arabic interface we have to use arabic sql files for marc is it possible to make something like armarc as we have normarc in the SQL structure ?! it's not a standard we don't really have 'armarc' and it is not a solution so the library chose its Marc flavor and all the librarian in that library will be forced to use this armarc , but will help to make the installation of the translated Arabic marc more easier and for the preferences description is included in the po files but the preferences still in English (the main term ) maybe the best solution is to make all the strings in koha included in the po files I don't have deep technical background but this will be more flexible for koha users all over the world for other languages not only for the Arabic language wish you will be able to do that for all the koha community :) thanks a lot for you Mr Massoud and thanks you all in Koha community for helping us :D Karam Qubsi Koha Arab Translating Team http://koha.wikibrary.org/ Wikibrary for Arab Librarians http://wikibrary.org > Date: Wed, 16 May 2012 09:00:57 +0300 > From: Massoud Alshareef <massoud(a)kwareict.com> > Subject: [Koha-translate] Multi-Lingual SQL & User Defined Parameters > To: koha-devel(a)lists.katipo.co.nz, koha(a)lists.katipo.co.nz, > koha-translate(a)lists.koha-community.org > Message-ID: > <CAMp2hxbU3fzajsQjgd-hou-RiPLmJ7y8Wf3XU=k2=5W15pPzmQ(a)mail.gmail.com> > Content-Type: text/plain; charset="iso-8859-1" > > Hello, > > I have asked a question about two years ago about when we can have Koha > support of Multi-Lingual SQL files (used for marc21/Auth fields description > in the Staff client) and Multi-Lingual users defined parameters (used for > describing items/ libraries & groups/ locations/ patrons categories/ etc), > and the answer from Koha development then was that it is > under consideration but not in the development pipelines yet, as it will > require some re-structuring in Koha system databases and controls. That > means, Koha will remain a single language in these areas. > > With Koha 3.6 release, I noticed the inclusion of "Spanish translation for > SQL files" in the INTERNATIONALIZATION enhancement section. Does this mean > that Spanish Koha, or any non-English Koha, now has both Spanish and > English SQL files, where Koha users can switch between more than one > language when, for instance, editing marc records in the staff client ? > > Koha Preferences description used to be in SQL files, which means a single > language prefers, and then moved into PO files format with 3.2 release (I > think) and thus Preferences became multi-lingual since then. > > Thank you Koha development for elaborating on the issue of having a fully > bilingual Koha. > > BTW, Arabic Koha 3.8 is now on the fast-lanes translation speed to be > completed within 3-4 weeks. > See Arabic Koha 3.8 OPAC demo site on > http://176.34.184.60/cgi-bin/koha/opac-search.pl?q=%D8%B9%D9%84%D9%85 > > Thanks > Massoud M. AlShareef, > > The world of achievement has always belonged to the optimist! > > KnowledgeWare Technologies > (P.O. Box 230-312) > Riyadh 11321, Saudi Arabia > Cel: +966 505 307 267 > massoud(a)kwareict.com >

2 1

Re: [Koha] http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6435
by Doug Kingston 16 May '12

16 May '12

We start the zebraqueue daemon from the /etc/init.d/koha-zebraqueue-daemon script at startup. This is a link to /usr/share/koha/bin/koha-zebraqueue-ctl.sh. My hack to keep things up to date is to run '/usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b' every 2 minutes from cron. /etc/cron.d/koha-hack: */30 * * * * koha KOHA_CONF=/etc/koha/koha-conf.xml PERL5LIB=/usr/share/koha/lib /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl -b -Doug- On 14 May 2012 10:43, Elaine Bradtke <eb(a)efdss.org> wrote: > I can't answer that question, can you? (down at the bottom). > EB > > ---------- Forwarded message ---------- > From: Mason James <mtj(a)kohaaloha.com> > Date: Tue, May 8, 2012 at 9:38 PM > Subject: Re: [Koha] > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6435 > To: Elaine Bradtke <eb(a)efdss.org> > Cc: Hugo Agud <hagud(a)orex.es>, Koha list <koha(a)lists.katipo.co.nz> > > > > > On 2012-05-9, at 5:05 AM, Elaine Bradtke wrote: > > > On Tue, May 8, 2012 at 11:34 AM, Hugo Agud <hagud(a)orex.es> wrote: > > > >> Dear all > >> > >> We are facing this bug again but this time with Koha 3.6.4, in our > case.. > >> > >> We have [intranet] false "no items" using zebra and nozebra, but when > you > >> click on title of the record.. the item appears without problem.... > >> > >> the main problem is that those items with false no items are not indexed > >> (the items) and you can't find them on advance search > >> > >> We have clean zebra index and reindex again and now appears all right... > >> but I think I will export the records and import another koha and check > >> what it happens and also upgrade to Koha 3.8 and check also what it > >> happens. > >> > > > > I've just tested this in our installation of 3.08 and the problem > persists. > > It happens with new records and recently edited records. Our workaround > > is to schedule the system to re-index periodically, but even with that, > > there is a delay between editing something and getting the barcode / item > > to show up again. Whereas any other changes I make (subject headings for > > instance) appear instantly. > > > > We're running > > mysql Ver 14.14 Distrib 5.1.61, for debian-linux-gnu (i486) using > readline > > 6.1 > > Apache version: Server version: Apache/2.2.16 (Debian) > > Zebra version: Zebra 2.0.50 (C) > > > > how are you starting your zebraqueue daemon, please? > > > > > > > >

1 0

Multi-Lingual SQL & User Defined Parameters
by Massoud Alshareef 16 May '12

16 May '12

Hello, I have asked a question about two years ago about when we can have Koha support of Multi-Lingual SQL files (used for marc21/Auth fields description in the Staff client) and Multi-Lingual users defined parameters (used for describing items/ libraries & groups/ locations/ patrons categories/ etc), and the answer from Koha development then was that it is under consideration but not in the development pipelines yet, as it will require some re-structuring in Koha system databases and controls. That means, Koha will remain a single language in these areas. With Koha 3.6 release, I noticed the inclusion of "Spanish translation for SQL files" in the INTERNATIONALIZATION enhancement section. Does this mean that Spanish Koha, or any non-English Koha, now has both Spanish and English SQL files, where Koha users can switch between more than one language when, for instance, editing marc records in the staff client ? Koha Preferences description used to be in SQL files, which means a single language prefers, and then moved into PO files format with 3.2 release (I think) and thus Preferences became multi-lingual since then. Thank you Koha development for elaborating on the issue of having a fully bilingual Koha. BTW, Arabic Koha 3.8 is now on the fast-lanes translation speed to be completed within 3-4 weeks. See Arabic Koha 3.8 OPAC demo site on http://176.34.184.60/cgi-bin/koha/opac-search.pl?q=%D8%B9%D9%84%D9%85 Thanks Massoud M. AlShareef, The world of achievement has always belonged to the optimist! KnowledgeWare Technologies (P.O. Box 230-312) Riyadh 11321, Saudi Arabia Cel: +966 505 307 267 massoud(a)kwareict.com

1 0