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

New Feature planned : Automatically adding/linking authorities when creating biblios
by Henri-Damien LAURENT 14 Aug '07

14 Aug '07

Hi there, We are planning to add a new feature with a new System preference (BiblioAddsAuthorities). When set to One, in addbiblio.pl when saving a new biblio, or modifying one, For each used field linked to an authority, unless there is already a $3 or a $9, we search authorities for a similar one (same subfields). If found, we add a $9 to the first authority number (supposed to be stored in 001 field) (or maybe we should display all results to select the authority to link to ?) Else, we create a new authority of the type linked to current biblio field, so that heading contains all subfields of the current biblio field We add a $9 to that biblio field which points to authid. End End Comments and remarks welcome. -- Henri-Damien LAURENT

1 0

Re: [Koha-devel] Database structure, some cleaning
by Waylon Robertson 10 Aug '07

10 Aug '07

http://katipo.co.nz/gallery/koha2-4/search_ideas_1, right hand search column shows how these tables were to be used... and i did implement usage of these tables, showed Rachel a working version of this idea. Thought i committed it all.... guess not. Found the work though. as i recall, categorytable was a table of 'adult, child' and mediatype like 'cd, dvd, book, pamplet, newspaper', and subcategory like 'fiction, nonfiction, so on. My code included the search within option. should i recheck my work and commit? (to 2.9)? Waylon categorytable : ========== this table is filled by admin/itemtypecategory.pl script, commited by genjimoto on 2005-05-02, but we do nothing with this table. So I propose we remove the table and the script. mediatype : ========== This table is filled by admin/mediatype.pl script, commited by genjimoto on 2005-05-02, but we do nothing with this table. So I propose we remove the table and the script. subcategorytable : =========== this table is filled by admin/itemtypesubcategory.pl script, commited by genjimoto on 2005-05-02, but we do nothing with this table. So I propose we remove the table and the script. Send instant messages to your online friends http://au.messenger.yahoo.com

1 0

A New Reserves System
by Kyle Hall 09 Aug '07

09 Aug '07

Hey all, I've been talking with Kados and Chris about revamping the current Reserves system, which will in the future be known as the Holds system to distinguish it from Academic Reserves. I've set up a page on the Koha Wiki with a list of requirements my librarians have given me, and I would like to get suggestions and input from the rest of the Koha community before I begin this undertaking. The wiki page can be found at http://wiki.koha.org/doku.php?id=en:development:ideas_for_a_new_reserves_sy… Thanks, Kyle -- IT Tech Crawford County Federated Library System

1 0

Database structure, some cleaning
by Paul POULAIN 08 Aug '07

08 Aug '07

Hello world, I have reviewed the DB schema : ***** QUESTIONS ****** accountoffsets : ========= The accountoffsets table seems to be filled sometimes (C4/Circ.pm, line 1399 for example), but I see only some INSERT. It is SELECTEd or UPDATEd nowhere in the code On all my user database, this table is empty. So : can we remove the accountoffsets table & the code refering to it ??? aqorderdelivery : ========== the table is never filled by anyone, but used in acquisition_stats.pl under certain circumstances. I think acquisition_stats is buggy here, and we can remove the table categorytable : ========== this table is filled by admin/itemtypecategory.pl script, commited by genjimoto on 2005-05-02, but we do nothing with this table. So I propose we remove the table and the script. mediatype : ========== This table is filled by admin/mediatype.pl script, commited by genjimoto on 2005-05-02, but we do nothing with this table. So I propose we remove the table and the script. subcategorytable : =========== this table is filled by admin/itemtypesubcategory.pl script, commited by genjimoto on 2005-05-02, but we do nothing with this table. So I propose we remove the table and the script. ******* ALREADY DONE *********** just to let you know, but i'm 99.99% sure of what has to be done, so I did it already. aqorderbreakdown : ============= the branchcode, linenumber and allocation rows are never used. I've removed them from default structure. auth_subfield_table, marc_biblio, marc_blob_subfield, marc_subfield_table, : ============= useless in koha 3.0, will be important for libraries migrating from 22 to 3.0, but not for a fresh install. table removed from default structure. biblioanalysis, uploadedmarc, charges, itemsprice, sessionqueries, users, borexp, borrowers_to_borrowers, catalogueentry, marcrecorddone, websites, z3950queue, z3950results : ========= Tables not used in 3.0, removed from default structure. It can either be a koha 1.0 table that is useless, sometimes since years, or a test table. -- 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

2 1

Fw: Community perl survey
by MJ Ray 06 Aug '07

06 Aug '07

-- forwarded text begins Take part in the 2007 Perl Survey! The Perl Survey is an attempt to capture a picture of the Perl community in all its diversity. No matter what sort of Perl programmer you are, we'd love to hear from you. The survey can be found at: http://perlsurvey.org It only takes about 5 minutes to complete. The survey will be open until September 30th, 2007. After that, we'll be reporting on the results and making the data freely available. Please feel free to forward this email to anyone other Perl programmers you know. Thanks for your help! Yours, Kirrily "Skud" Robert The Perl Survey info(a)perlsurvey.org

1 0

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