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

ER Diagrammer for the Koha Database
by Rick Welykochy 02 Mar '07

02 Mar '07

Hi all, I am doing a bit of development work on a local install of Koha and am constantly using MySQL to refer to the schema for the database. Enquiries with Katipo and elsewhere show that there is no overall ER diagram for the database. I am prepared to construct one from what I find, but wonder this: Are there any tools the list might know of that can connect to MySQL and produce an ER diagram of the schema? cheers rickw -- _________________________________ Rick Welykochy || Praxis Services Blessed are the cracked for they let in the light. -- Spike Milligan

4 4

private new
by Paul POULAIN 28 Feb '07

28 Feb '07

Hello, as most of you already know, Matthieu Poulain is born on sunday, feb 25, at 11:26AM. He was 3.530kg, 52cm. The mother and the baby are fine. The father is tired :-D They were back home today. You can see some picture if you're interested at http://www.paulpoulain.com/matthieu/ i'll mostly be away in march... -- 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

1 0

Reverting to previous versions in CVS
by Joshua M. Ferraro 28 Feb '07

28 Feb '07

Hey gang, I recently had a heck of a time working with Savannah's CVS to get it to allow me to revert a version of a file to a previous one. Here's how I eventually got it to work: $ cvs update -j 1.3.2.14 -j 1.3.2.15 search.pl $ mv search.pl search.pl.new $ cvs update -A search.pl $ mv search.pl.new search.pl $ cvs commit -m "reverting to previous version" search.pl Ahem ... we need a new revisioning system :-) 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

6 5

koha rss
by long_sam.tw 27 Feb '07

27 Feb '07

koha rss summary: how to configure rss on koha. Credit: Originally written by Pat Eyler (pate(a)eylerfamily.org) suggestions, advice, and help came from 'Content Syndication with RSS', Chris Cormack, Mike Hansen, Steve Tonnesen and a variety of folks on #koha at irc.katipo.co.nz. 1. environment koha 2.2.5 & koha 2.2.7 (templete for npl) 2. cvs mkdir cvs cd cvs cvs -z3 -d:pserver:anonymous@cvs.savannah.nongnu.org:/sources/koha co koha cd koha and copy -R rss/ /your-koha/intranet/modules/C4/ 3. lastAcquired-2.0.conf lastAcquire.conf books ------------------------------- channel title=Recent Koha Acquisitions link=http://www.koha.org desc=The 15 most recent acquisitions lang=en image title=Koha, the worlds best Open Source Library System url=http://www.koha.org/images/foo.jpg link=http://www.koha.org width=88 height=31 config tmpl=/opt/koha/intranet/modules/C4/rss/lastAcquired-2.0.tmpl output=/opt/koha/intranet/modules/C4/rss/lastAcquired-2.0.xml query=select biblio.title as title, biblio.author as author, biblio.biblionumber as bibid, biblio.notes as notes, biblioitems.place as place, biblioitems.publishercode as publishercode, biblioitems.publicationyear as publicationyear, biblioitems.pages as pages, biblioitems.illus as illus, biblioitems.size as size from biblio, biblioitems, items where biblioitems.biblionumber = items.biblionumber and biblio.biblionumber = items.biblionumber and items.dateaccessioned is not NULL order by items.issues desc 4. lastAcquired.tmpl <?xml version="1.0" encoding="utf8"?> <rss version="2.0"> <channel> <title></title> <link></link> <description></description> <language></language> <lastBuildDate></lastBuildDate> http://blogs.law.harvard.edu/tech/rss <generator>Koha</generator> <image> <title></title> <url></url> <link></link> <width></width> <height></height> <description></description> </image>  <item> <title>Title：  Author：  </title> http://www.koha.org/cgi-bin/koha/opac-detail.pl?bib= <description><![CDATA[Title：  Author：          ">Details | ">Reserve | &resultsperpage=20&orderby=biblio.title&op=do_search">other works ]]></description> </item>  </channel> </rss> 5. navigation.inc # add http://www.w3.org/People/Ishida/images/rdf_flyer-small.gif> http://lit145.lacc.fju.edu.tw/koha/rss/lastAcquired-2.0.xml>The 15 most recent acquisitions 6. crontab crontab -e 0 8,17 * * * /opt/koha/intranet/modules/C4/rss/rss.pl /opt/koha/intranet/modules/C4/rss/lastAcquired-2.0.conf 7. koha-httpd.conf www.koha.org:80> ServerAdmin long_sam.tw(a)yahoo.com.tw DocumentRoot /opt/koha/opac/htdocs ServerName www.koha.org ScriptAlias /cgi-bin/koha/ /opt/koha/opac/cgi-bin/ Redirect permanent index.html http://www.koha.org:80/cgi-bin/koha/opac-main.pl ----------------------------------------------------------------------------------- # add Alias Alias /koha/rss/lastAcquired-2.0.xml "/opt/koha/intranet/modules/C4/rss/lastAcquired-2.0.xml" </VirtualHost> restart apache 8. use google reader http://farm1.static.flickr.com/186/404542415_d0b27b3e67_o.png you can use firefox 2.0 9. demo site http://lit145.lacc.fju.edu.tw http://koha.nkes.ntct.edu.tw http://koha.jente.edu.tw 10. chinese information http://koha.wikispaces.com/rss laxendion ___________________________________________________ 您的生活即時通－溝通、娛樂、生活、工作一次搞定！ http://messenger.yahoo.com.tw/

1 0

Re: [Koha-devel] koha 3.0 & zebra
by Henri-Damien LAURENT 27 Feb '07

27 Feb '07

long_sam.tw a écrit : > hi,henri-damien lautent > > thanks. > > i change KOHA_CONF to koha.xml. > > opac-main.pl for prog > > http://farm1.static.flickr.com/165/404367800_68bb7694af_o.png > > but can't search > > http://farm1.static.flickr.com/137/404367801_e55ac3f46b_o.png > > error log > > > Error : > > Can't call method "size" on an undefined value at /usr/local/koha/intranet/modules/C4/Search.pm line 327. > > Would you mind sending a bigger part of logs ? rel_3_0 is still unstable. Maybe, You must try and create some zebra configuration files. If you did, maybe you could send some records in an iso2709 file + your zebra configuration files. To answer an other question : Zebra CAN Actually manage multiple formats in one base. But Koha is not using those features at the moment. > serach result is null. i run yaz-client @:2100/biblios, > i can find records. > > Z> find @attr 1=1016 perl > Sent searchRequest. > Received SearchResponse. > Search was a success. > Number of hits: 1, setno 1 > SearchResult-1: term=perl cnt=1 > records returned: 0 > Elapsed: 0.130322 > ----------------------------------------------- > zebraserv log > 15:01:11-27/02 zebrasrv(1) [request] Search biblios OK 1 1 1+0 RPN @attrset Bib-1 @attr 1=1016 perl > ------------------------------------------------ > i use koha search. > zebraserv log > 15:19:32-27/02 zebrasrv(4) [session] Session - OK 4 tcp:::1 5978 > 15:19:32-27/02 zebrasrv(4) [request] Auth none > 15:19:32-27/02 zebrasrv(4) [request] Init OK - ID:81/81 Name:ZOOM-C/YAZ Version:1.108/2.1.46 > 15:19:33-27/02 zebrasrv(4) [session] Connection closed by client > -------------------------------------------------------------- > Regards. -- Henri-Damien LAURENT

1 0

New Koha Languages Module
by Joshua M. Ferraro 21 Feb '07

21 Feb '07

Hi gang, On IRC today, hdl, paul and I discussed how we represent lists of languages in Koha. At the moment we have three places where lists are represented, and all three use a different method of obtaining the list: 1. language switcher for OPAC and Intranet, and directory names for the language options (use two letter codes based on the ISO 639-1 standard ). 2. search interface (limiting by langauge like on: http://search.athenscounty.lib.oh.us/search?expanded_options=1 ( use three letter codes based on ISO 639-2, language names in the language's script, and English langauge names all hardcoded in Koha.pm). 3. hdl's new web installer, where the librarian picks her language as a step in the install process (uses two letter codes based on ISO 639-1, hardcoded). There are other places where lists of langauges will need to be represented shortly (on that I can think of off the top of my head is the new translation site that is currently in beta). I'd like to propose that we create a new Language.pm module for managing the list of languages with the aim to provide the following elements for every list of langauges: 1. two or three letter codes for the language based on ISO 639-2, which is maintained by the LOC and is inclusive of ISO 639-1: http://www.loc.gov/standards/iso639-2/ http://www.loc.gov/marc/languages/ 2. the language name in the script of the language. So for instance, 中文 for Chinese, Français for French, etc. 3. the langauge name in the language of the user, based on the template language choice ( so that if you are logged in as a French speaker, you'd see Perse (French spelling), not Persian (English spelling). To acomplish this, I propose we create a Language.pm module in Koha that provides a set of functions for finding lists in various contexts. We could utilize the existing lists around ISO-630-2 to create the initial list, perhaps stored as a flat file, or in SQL ... and we will need to create a new language_list.tmpl file to store language name translations (at least some of which can probably be automated using available translations). So, ideas, questions? 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 1

Namespace Change: C4 -> Koha
by Joshua M. Ferraro 20 Feb '07

20 Feb '07

Hi all, Just a crazy thought I had: $ cd cvsrepos/rel_3_0/koha $ perl -p -i -e 's/C4/Koha/g' `grep -ril C4 *.pm` $ perl -p -i -e 's/C4/Koha/g' `grep -ril C4 *.pl` $ perl -p -i -e 's/C4/Koha/g' `grep -ril C4 *.tmpl` $ cvs commit -m "renaming namespace from C4 to Koha" The above commands should replace our entire module namespace from C4 to Koha, which is arguably more intuitive. Thoughts? 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

4 3

Languages.pm module in rel_3_0
by Joshua M. Ferraro 20 Feb '07

20 Feb '07

Hi all, I just had a crack at a first draft of the new Languages.pm module, which provides functions for getting lists of languages. It's well documented, so perldoc is your friend. Please try it out and if you find it useful, incorporate it whenever you need to get a list of languages. 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

2 3

Koha Documentation
by Joshua M. Ferraro 19 Feb '07

19 Feb '07

Hi all, I've given some thought to the current state of Koha documentation. We currently have the following documentation: 1. Koha Intranet help (built in [?] at top right of interface), not complete, not well maintained. At dev week, we discussed using the wiki as a means of updating the onlinehelp for the Intranet (point #3 above), any progress on that front? Do we have a script to convert wiki -> templates ? Do we all still feel that's the best way to improve the online help? 2. wiki.koha.org, easy to edit (when working), not very authoritative, not well organized. I think the wiki is always going to be a great resource for developers, but probably not the best for users. 3. kohadocs.org, somewhat authoritative, but slow to update, and only a few people with the know-how to use Freemind to generate the XML, etc. In looking around at other projects' User's Guides, one that stands out in my mind as having the ideal features is MySQL: http://dev.mysql.com/doc/ I'll try to summarize what I like about their Manual help: 1. each page has a version attached to it, so you can be looking at docs for Disaster Recovery for version 5.0: http://dev.mysql.com/doc/refman/5.0/en/disaster-prevention.html And you can click on '4.1' to see that page as it applies for version 4.1. 2. Users can add comments to ask questions or add additional info to the bottom of each page: http://dev.mysql.com/doc/refman/4.1/en/backup-recovery.html 3. There is a MySQL print manual, which I assume is generated from their online documentation (I could be wrong though). Having a print version of the manual is a huge advantage. The one thing missing from the MySQL manual is a way to translate pages. At LibLime, we run our website off of Plone (http://plone.org) which I think would allow us to do at least some of the nice things that MySQL can do, along with allowing for translation of each page. Before I invest too much time investigating what would be involved in customizing Plone for Koha's documentation, does anyone have any other ideas for how a new User's Guide should be structured, or what software would be good to try? 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

koha 2.2.8 (previously 2.2.7-1) release plan
by Paul POULAIN 19 Feb '07

19 Feb '07

Hello all, toins has created a R_2-2-7-1 branch from 2.2.7, and ported all BUGFIXES since 2.2.7 release. That will do the 2.2.8 (we talked of 2.2.7.1 during our last chat, but thinking of this, I think it's unclear for users : the next version should be called 2.2.8 and the next one 2.2.9. joshua agreed with this idea) I gave it some tests, and it seems to work fine. I install it atm for a new french koha user that i'll teach koha later this week. If everything is as smooth as expected, i'll release 2.2.8 on monday/tuesday next week (it may be delayed as baby birth is expected for wednesday, so if you don't hear from me on time, you'll know why ;-) ) NOTE FOR TRANSLATORS : there are only 1 new string and 2 updated strings between 2.2.7 and 2.2.8, so 2.2.7 translations should work for 2.2.8 as well. Here are planned release notes : -- 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