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

Cutting long cyrillic fields via import (record added)
by Serhij Dubyk Сергі й Дубик 30 Jul '07

30 Jul '07

Hi Problem with importing of some records with long subfield (not with all such records). In Koha (main DB or reserviour) result subfields cutted (sometime to few words). Similar results when use web GUI import and bulkmarcimport. When manually added data via Koha-Intranet - all subfiels present fully. Can it is will be connected with Koha DB's structure? (i.e. for marc_breeding table title limited to varchar(128 bytes?)) My systems: Koha 2.2.9 (and previous v.), MySQL 5, Debian 4, all utf-8 Here 1 record for test this (my initial after iso2xml.pl): http://www.nabble.com/file/p11861237/1record_to_test_bag.xml 1record_to_test_bag.xml (xml2marc.pl): http://www.nabble.com/file/p11861237/1record_to_test_bag.xml.mrc 1record_to_test_bag.xml.mrc (MarcEdit to text): http://www.nabble.com/file/p11861237/1record_to_test_bag.xml.mrk8 1record_to_test_bag.xml.mrk8 -- View this message in context: http://www.nabble.com/Cutting-long-cyrillic-fields-via-import-%28record-add… Sent from the Koha - Dev mailing list archive at Nabble.com.

1 0

New Koha 2.2 search....
by Ernesto Silva 27 Jul '07

27 Jul '07

Hi, I've said before we've developed a different search in Koha 2.2, as our Koha installation has many modifications I'm not able to send you a 2.2 working version with the new features. Anyway, I can send you our pages, templates and modules so "somebody" can make a integration-testing with actual Koha versions and evaluate. I'm attaching a ZIP file with all our new staff, please feel free to use it, test it, and finally comment on it. I don't have any other files, so if someone wants to give it a try and needs any assistance please contact me (silva(a)ort.edu.uy) or Jean Pierre Ducassou (ducassou(a)ort.edu.uy) so we can guide you. Other data: - all texts, help and comments are in Spanish, please contact us if you need any help or assistance. - we use MySQL 5.0.18, I think that any version with sub-queries support should work fine. - all templates belongs to the Intranet section, when the system is fully functional we'll make some for the OPAC. - There's a help file with an explanation of the grammar used by the librarians, the grammar which we convert to MySQL 5 queries/subqueries. - In the grammar the slowest operation is the negation of something, we have operators like "contains" and "nocontains" and that works fine, but if you use the "not" operator the queries gets slow. We are trying to find an elegant solution, but this will take some days - We used YAPP to parse the grammar and generate a perl module, the .yp file with the grammar source is also included. Finally, I know this lacks a lot of information, but please, first look at it and then contact us. Best regards, Ernesto Silva. ******************************************************************** Hi, here at Universidad ORT Uruguay we've been using koha since may'05. Andres Tarallo and I were the primary developers, Andres is still with us but working on another proyect and we've hired Jean Pierre Ducassou to continue our Koha developement. And... no Paul, Jean Pierre is not french, but his ancients were. Anyway, as our Koha 2.2 installation has it's own flavour and we were aiming to improve the search system we've made some work during 2006 but the developer we hired has gone away... pity. We've been reviewing 2006 search code (with Jean Pierre) wich was based on MySQL 5 using sub-queries and Full Text Indexing. We've got a 95% working search system, we're giving it the final tweaks. We were wondering if anyone is interested in it, we can contribute with the code, explanations and basic documentation. The basics of the systems are: - our own query language, simple but yet powerful. - a parser to convert the query language expressions to sql expressions. - a new table, similar to marc_subfield_table, but with a subfieldvalue field of blob type, and a nsubfieldvalue field of float type. - full text indexing. In our developement server (2 x PIII of 800 MHz) the new search system works very fast with 52000 bibles and 75000 items. When the system is fully functional (in 2 or 3 days I hope) we will begin the migration off the rest of our Koha installation to MySQL 5, and when this is ready we'll put into the production server, I hope we can achieve this in October. Sorry about my poor english and best regards, -- Ernesto Silva. Coordinador de Desarrollo Web y Sistemas Abiertos Centro de Procesamiento de Datos Universidad ORT Uruguay. E-mail: silva(a)ort.edu.uy Tel: (+598-2) 902-1505 ext. 206 Fax: (+598-2) 900-2952 _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel

1 0

New.koha.org progress and translations
by Russel Garlick 27 Jul '07

27 Jul '07

Hi everyone, A couple of us have been playing with plone for the new version of the Koha site. The goal is to have a new site up and going for the upcoming release of version 3. We have an install up and going at http://new.koha.org:8080/koha/. It is using a default plone look at the moment, but as I am interested mainly in the content, I have plugged in most of the content from the current site. We have a couple of things up and going: The Plone Help Centre http://new.koha.org:8080/koha/documentation Although it seems to have a few issues, by and large this seems to be pretty nice. It covers the full gambit of docs and has some nice features which allows you to tag docs against an audience (End User, Sys Admin, Developer) and version. Multilingual Content (using LinguaPlone) In a perfect world, we would have a completely multilingual site. This is something that was going to be very difficult to do on the old platform. At the moment, I have done one page (as a proof of concept) http://new.koha.org:8080/koha/documentation/manual/koha-2.2/ introduction/view?set_language=en http://new.koha.org:8080/koha/documentation/manual/koha-2.2/ introduction-1/view?set_language=fr Unfortunately my French extends about as far as ordering a coffee and my Russian as far as identifying a book and table. So the purpose of this email? I am asking for your help, particularly with translations. If you would like to lend a hand, then please email me off list or drop me a line on #koha and we can get you set up. Cheers, -- Russel Garlick russel.garlick(a)liblime.com General Manager - Australasia +64 21 542 188 LibLime Limited www.liblime.com

1 0

New Koha 2.2 search....
by Ernesto Silva 24 Jul '07

24 Jul '07

Hi, here at Universidad ORT Uruguay we've been using koha since may'05. Andres Tarallo and I were the primary developers, Andres is still with us but working on another proyect and we've hired Jean Pierre Ducassou to continue our Koha developement. And... no Paul, Jean Pierre is not french, but his ancients were. Anyway, as our Koha 2.2 installation has it's own flavour and we were aiming to improve the search system we've made some work during 2006 but the developer we hired has gone away... pity. We've been reviewing 2006 search code (with Jean Pierre) wich was based on MySQL 5 using sub-queries and Full Text Indexing. We've got a 95% working search system, we're giving it the final tweaks. We were wondering if anyone is interested in it, we can contribute with the code, explanations and basic documentation. The basics of the systems are: - our own query language, simple but yet powerful. - a parser to convert the query language expressions to sql expressions. - a new table, similar to marc_subfield_table, but with a subfieldvalue field of blob type, and a nsubfieldvalue field of float type. - full text indexing. In our developement server (2 x PIII of 800 MHz) the new search system works very fast with 52000 bibles and 75000 items. When the system is fully functional (in 2 or 3 days I hope) we will begin the migration off the rest of our Koha installation to MySQL 5, and when this is ready we'll put into the production server, I hope we can achieve this in October. Sorry about my poor english and best regards, -- Ernesto Silva. Coordinador de Desarrollo Web y Sistemas Abiertos Centro de Procesamiento de Datos Universidad ORT Uruguay. E-mail: silva(a)ort.edu.uy Tel: (+598-2) 902-1505 ext. 206 Fax: (+598-2) 900-2952

2 1

Koha Project Day Schedule Change
by Joshua M. Ferraro 20 Jul '07

20 Jul '07

Hi folks, The LibLime management team is happy to announce that we're switching Koha Project Day to Thursdays, starting next Thursday, July 26th (that's Friday in New Zealand). For those of you who are new to this list (welcome!), Koha Project Day is an initiative to foster community development and growth of the Koha project. It's an all day event that starts at 9am EST in our US office in Athens, Ohio and ends 15 hours later at 5pm NZ in our New Zealand Office in Wellington. Of course, throughout the week, we LibLimers spend the majority of our time working for our customers: writing specifications, doing development work, implementation, and support. Koha Project Day gives us a chance to give back to you -- the community that makes all of this possible! Of course, the invitation to join us is extended to you as well! Join us any time on any Thursday and pitch in, if you're able. Speaking of which, what is there to do? Glad you asked. Here's just a partial list: * organize and write documentation * write specifications for new proposed features * write technical documentation for existing Koha features * respond to questions/comments on the Koha lists * test features and report bugs * fix bugs :-) * read through the code and make comments * translate Koha into your native language * write that new feature you thought of * talk to the developers and tell them how to improve Koha Where is all of this happening? You can join us in real time on the #koha channel on irc.katipo.co.nz. If you've not used IRC before, and you're running Windows, give mIRC a shot: http://www.mirc.com/ See you Thursday! Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf(a)liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS

1 0

Re: [Koha] attempting to install Koha at Bluehost.com
by MJ Ray 19 Jul '07

19 Jul '07

Actually, this question should go to koha-devel and s/Do/Should/ MJ Ray <mjr(a)phonecoop.coop> wrote: > Do we still use Class::Accessor, Event and HTML::Template? I see from hdl's list that HTML::Template is used only in maclesold.pl,MACLES.pl,macles.v1.0.pl - will they be in 3.0? I can't see Class::Accessor or Event. I think Event was pulled in by Net::Z3950, which is going away. I await your replies with interest. Thanks, -- MJ Ray - see/vidu http://mjr.towers.org.uk/email.html Experienced webmaster-developers for hire http://www.ttllp.co.uk/ Also: statistician, sysadmin, online shop builder, workers co-op. Writing on koha, debian, sat TV, Kewstoke http://mjr.towers.org.uk/

2 2

Re: How to change HTML / TMPL path prefix?
by Jack Bates 18 Jul '07

18 Jul '07

Here is the second version of a patch to support configuring intranet / opac, cgi / html base URLs: http://cgi.sfu.ca/~jdbates/tmp/koha/200707170/koha.patch3 I changed the roughly 1135 instances of /cgi-bin/koha in the English templates to use either the new intracgi or opaccgi variables. It's almost working for us! http://sfpirg6.stdntsvcs.sfu.ca/koha/opac-cgi/opac-main.pl All that remains is to hunt-and-kill the remaining 124 instances in 78 Perl scripts. Hopefully I can get to this by the end of the week. Any feedback much appreciated! Thanks, Jack > Maybe we should move this discussion to koha-devel? > http://lists.nongnu.org/mailman/listinfo/koha-devel > > Jack Bates <ms419@...> wrote: > > [...] Also, before I go > > editing template files for various translations, I assume each > > translation is built from one source file? > > I think they're built from the English template and a po file with the > tools in misc/translator. > > > I browsed the developer wiki a bit, but haven't yet found instructions > > to build a Koha distribution archive from the source repository > > (presumably this involves compiling localized versions of templates). > > In 2.2, it's misc/buildrelease and I don't think it localises templates. > > In HEAD, that is in rather a state of flux just now. It may end up > as "perl Makefile.PL && make dist" but that's not brilliant yet. > > > Please find attached the small patch I created so far and my SSH key. > > Can I please have access to clone the 2.2 git repository? > > As I understand it, you don't need ssh access to clone it: see > http://lists.nongnu.org/archive/html/koha-devel/2007-06/msg00008.html > for instructions. 2.2 is the branch origin/rel_2_2 > > Hope that helps, > -- > MJ Ray - see/vidu http://mjr.towers.org.uk/email.html > Experienced webmaster-developers for hire http://www.ttllp.co.uk/ > Also: statistician, sysadmin, online shop builder, workers co-op. > Writing on koha, debian, sat TV, Kewstoke http://mjr.towers.org.uk/

1 0

Re: [Koha-devel] (koha 3.0) OPAC search results list
by eija＠inwave.com 11 Jul '07

11 Jul '07

This is a follow-up to my message from last night. I have now had a chance to look at the pages in Internet Explorer 6 and find them much more readable than in my older browser. I still believe the records may be a little close to each other, particularly on the IPT example. Additional questions on CCFLS: On the Normal View, it would be nice to be able to click on the added entries to conduct a search on that name like one can with the main entry. On the MARC view, it might be nice to be able to click on authorized headings to bring up either a search on that heading or the authority record for the heading. Non-Koha-related cataloging/record maintentance question: On record # mpl19202793 (ISBN 0671032550), Infection (Book 1: Star Trek - Next Generation, Double Helix.), the series is listed as Star Wars | X-Wing: Book 3. Several other Star trek books are also listed in the Star wars series. Thank you for your assistance, Bryan Baldus Cataloger Quality Books Inc. address@hidden address@hidden http://home.inwave.com/eija

1 0

FAO: Tumer Garip / Problem with javascript when using MARC editor
by Martin Morris 11 Jul '07

11 Jul '07

I mentioned this on the #koha chatroom earlier today; they replied that i should send this to you (and the koha-devel group). When editing a biblio in the MARC editor, and attempting to link 100 $a to a name authority, I see what I believe are javascript errors when clicking on the ... next to the 100$a textbox. The error box contains the following: Error: Invalid argument Code: 0 URL: http://<hostname>/cgi-bin/koha/acqui.simple/addbiblio.pl? oldbiblionumber=1110 If there's an answer to this would appreciate it. Thanks, Martin

2 1

(koha 3.0) OPAC search results list
by Paul POULAIN 11 Jul '07

11 Jul '07

Hello world (and mainly kados) yesterday, kados & me spoke of the look the result list could/should have for Koha 3.0 Here are 2 proposals : http://catalog.ccfls.org/search?idx=&q=chaos http://catalogue.iptheologie.fr/cgi-bin/koha/opac-search.pl?q=chaos I show ccfls look to ipt librarian, and she is happy with this. so I think we could move head to this look. The tabular view is interesting, but need more space on screen (the item location column is mostly empty) On ccfls templates, there are some tweakings to do anyway : - copies available at : BRANCHNAME (number) would be copies available at : BRANCHNAME LOCATION (number) - the 2nd line, with the itemcallnumber (658 Peters in the 3rd result) is fine, except when there is more than one item : go to page 2, the 5th result (If you give a moose a muffin) : the callnumbers are repeated with a |. worst, go http://catalog.ccfls.org/search?q=potter&offset=20 : the biblionumber 50994 entry (has 2 differents callnumbers [ FIC YA Rowling | JUV PB (SERIES) ], and the link reaches a zebra error) cheers -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org) Tel : 04 91 31 45 19

8 8