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

Koha 3 Reset Database
by David Riggs 29 Jan '09

29 Jan '09

Hello, I'm a very-new Koha user, and have a fresh installation of Koha 3.00.00 on Ubuntu 8.04. I initially choose to have the sample data installed out of the box, but would now like to try the application out using semi-real data. A search turned up only info for older versions, so I'll pose this question: What is the best way to reset or "wipe" the database clean in Koha 3, while (optionally) retaining configuration settings? Thanks! - DR -- david a. riggs software engineer, createTank mailto:riggs@createtank.com voice: +1-304-685-7537 fax: +1-800-975-8379 http://createtank.com

4 11

Re: [Koha-devel] Koha-devel Digest, Vol 38, Issue 22
by Sayed Baser Ali 28 Jan '09

28 Jan '09

Dear All, We want to use koha catalogue for our library please help us where we can buy or get the web hosting , we are in Afghanistan, Best regards, Jan Agha -----Original Message----- From: koha-devel-bounces(a)lists.koha.org [mailto:koha-devel-bounces@lists.koha.org] On Behalf Of koha-devel-request(a)lists.koha.org Sent: Tuesday, January 27, 2009 4:07 AM To: koha-devel(a)lists.koha.org Subject: Koha-devel Digest, Vol 38, Issue 22 Send Koha-devel mailing list submissions to koha-devel(a)lists.koha.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.koha.org/mailman/listinfo/koha-devel or, via email, send a message with subject or body 'help' to koha-devel-request(a)lists.koha.org You can reach the person managing the list at koha-devel-owner(a)lists.koha.org When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha-devel digest..." Today's Topics: 1. Re: Koha 3 Reset Database (David Riggs) 2. Re: Koha 3 Reset Database (Mason James) 3. Re: Kudos.koha.org up and running! (Chris Cormack) 4. Re: Kudos.koha.org up and running! (MJ Ray) 5. Re: Kudos.koha.org up and running! (Owen Leonard) 6. Re: Kudos.koha.org up and running! (Galen Charlton) 7. RFC: Koha 3.2 : Split Issuing rules into Circ rules and Circ policies (Ryan Higgins) ---------------------------------------------------------------------- Message: 1 Date: Mon, 26 Jan 2009 16:51:21 -0500 From: David Riggs <riggs(a)createtank.com> Subject: Re: [Koha-devel] Koha 3 Reset Database To: koha-devel(a)lists.koha.org Message-ID: <e976163d0901261351o4d631131qaead4ec237b211a9(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 On Mon, Jan 26, 2009 at 4:16 PM, Mason James <mason.loves.sushi(a)gmail.com> wrote: > > try a 'zebraidx -c /yourpath/koha-conf.xml init' then > > FYI: have a peek at line 488-ish of the rebuild script > > system("zebraidx -c $zebra_config -g $record_format -d $zebra_db_name > init") if $reset_index; > No change. I continue to get results when searching, despite having truncated the listed tables, running various combinations of `rebuild_zebra.pl` and `zebraidx -c`. Clicking those items results in a 404. I have verified that browser caching is not at fault. I'm supposed to give an evaluation of Koha's suitability for use this week, and having the database(s) in an inconsistent state is making that extremely difficult. While it would be nice to persist my configuration changes, I'd be happy just blowing away and re-creating the database. Can someone please point me to docs or offer help as to how to re-initialize the DB without doing a complete re-installation? I'm overwhelmed by the number of scripts and data files provided, and unable to find documentation aside from reading hundreds of lines of Perl. Thanks for your help! - DR -- david a. riggs software engineer, createTank mailto:riggs@createtank.com voice: +1-304-685-7537 fax: +1-800-975-8379 http://createtank.com ------------------------------ Message: 2 Date: Tue, 27 Jan 2009 11:02:42 +1300 From: Mason James <mason.loves.sushi(a)gmail.com> Subject: Re: [Koha-devel] Koha 3 Reset Database To: David Riggs <riggs(a)createtank.com> Cc: koha-devel(a)lists.koha.org Message-ID: <748F707A-A27C-4E92-87D2-B14E59A0F9FD(a)gmail.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed On 2009/01/27, at 10:51 AM, David Riggs wrote: > On Mon, Jan 26, 2009 at 4:16 PM, Mason James > <mason.loves.sushi(a)gmail.com> wrote: >> >> try a 'zebraidx -c /yourpath/koha-conf.xml init' then >> >> FYI: have a peek at line 488-ish of the rebuild script >> >> system("zebraidx -c $zebra_config -g $record_format -d >> $zebra_db_name >> init") if $reset_index; >> > > No change. I continue to get results when searching, despite having > truncated the listed tables, running various combinations of > `rebuild_zebra.pl` and `zebraidx -c`. Clicking those items results in > a 404. I have verified that browser caching is not at fault. > > I'm supposed to give an evaluation of Koha's suitability for use this > week, and having the database(s) in an inconsistent state is making > that extremely difficult. While it would be nice to persist my > configuration changes, I'd be happy just blowing away and re-creating > the database. Can someone please point me to docs or offer help as to > how to re-initialize the DB without doing a complete re-installation? > I'm overwhelmed by the number of scripts and data files provided, and > unable to find documentation aside from reading hundreds of lines of > Perl. > > Thanks for your help! > - DR > > ok, to wipe your zebra auth and bib dbs - this works for me.. # zebraidx -c /home/mason/koha/ashs/etc/zebradb/zebra-authorities- dom.cfg -g iso2709 -d authorities init 11:01:02-27/01 zebraidx(17800) [log] zebra_start 2.0.34 /home/mason/ koha/ashs/etc/zebradb/zebra-authorities-dom.cfg 11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-text.so 11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-dom.so 11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-alvis.so 11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-grs-marc.so 11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-grs-xml.so 11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-grs-regx.so 11:01:02-27/01 zebraidx(17800) [log] enabling shadow spec=/home/mason/ koha/ashs/var/lib/zebradb/authorities/shadow:1G 11:01:02-27/01 zebraidx(17800) [log] cache_fname = /home/mason/koha/ ashs/var/lib/zebradb/authorities/shadow/cache 11:01:02-27/01 zebraidx(17800) [log] zebra_stop: 0.02 0.02 0.00 # zebraidx -c /home/mason/koha/ashs/etc/zebradb/zebra-biblios.cfg - g iso2709 -d biblios init 11:01:26-27/01 zebraidx(17801) [log] zebra_start 2.0.34 /home/mason/ koha/ashs/etc/zebradb/zebra-biblios.cfg 11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-text.so 11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-dom.so 11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-alvis.so 11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-grs-marc.so 11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-grs-xml.so 11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-grs-regx.so 11:01:26-27/01 zebraidx(17801) [log] enabling shadow spec=/home/mason/ koha/ashs/var/lib/zebradb/biblios/shadow:4G 11:01:26-27/01 zebraidx(17801) [log] cache_fname = /home/mason/koha/ ashs/var/lib/zebradb/biblios/shadow/cache 11:01:26-27/01 zebraidx(17801) [log] zebra_stop: 0.06 0.02 0.00 root@fugu:/etc/apache2/sites-enabled# ------------------------------ Message: 3 Date: Tue, 27 Jan 2009 09:00:43 +1300 From: Chris Cormack <chris(a)bigballofwax.co.nz> Subject: Re: [Koha-devel] Kudos.koha.org up and running! To: Kyle Hall <kyle.m.hall(a)gmail.com> Cc: koha-devel <Koha-devel(a)nongnu.org> Message-ID: <606aab810901261200i48c24861h556b45d6dfaa1e9a(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 On Tue, Jan 27, 2009 at 1:26 AM, Kyle Hall <kyle.m.hall(a)gmail.com> wrote: > Hello All, > The KUDOS Koha Users and Developers Group website is up and running > at http://kudos.koha.org/ . Thanks to Josh for the help setting it up. > Please let me know if you have any suggestions / criticisms / > complaints / what-have-you. There's not much content at the moment, so > suggestions are very welcome. Let me know if it seems slow or anything > like that, the servers is a virtual machine, so I can bump up the RAM > if it gets a bit sluggish. > > If everything seems kosher, I'll post something up on the Koha and > KUDOS mailing lists. > My only query is the byline " The Official Koha Users & Developers Group! " Kudos is a worldwide users group?? And is it the only users and developers group? What is kohala then? Chris _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel ------------------------------ Message: 4 Date: Mon, 26 Jan 2009 21:21:33 +0000 From: MJ Ray <mjr(a)phonecoop.coop> Subject: Re: [Koha-devel] Kudos.koha.org up and running! To: kyle.m.hall(a)gmail.com, Koha-devel(a)nongnu.org Message-ID: <497e295d.URdvAZJTgjpDE445%mjr(a)phonecoop.coop> Content-Type: text/plain; charset=us-ascii Kyle Hall <kyle.m.hall(a)gmail.com> wrote: > The KUDOS Koha Users and Developers Group website is up and running > at http://kudos.koha.org/ . Thanks to Josh for the help setting it up. It seems to be a redirect to http://liblime.com/news-items/blogs which is not at all appropriate, in my opinion. Is the intention to port the current KUDOS Wordpress across? (Please!) Thanks, -- MJ Ray (slef) Webmaster for hire, statistician and online shop builder for a small worker cooperative http://www.ttllp.co.uk/ http://mjr.towers.org.uk/ (Notice http://mjr.towers.org.uk/email.html) tel:+44-844-4437-237 _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel ------------------------------ Message: 5 Date: Mon, 26 Jan 2009 17:28:42 -0500 From: Owen Leonard <oleonard(a)myacpl.org> Subject: Re: [Koha-devel] Kudos.koha.org up and running! To: Chris Cormack <chris(a)bigballofwax.co.nz> Cc: koha-devel <Koha-devel(a)nongnu.org> Message-ID: <c0aa2140901261428t2ab091b6l3c38fc6e7659a69e(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 > My only query is the byline > > " The Official Koha Users & Developers Group! " Agreed. I think it's important not to claim anything official about it. That suggests that if someone started another group it wouldn't be "endorsed by the Koha Project." -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel ------------------------------ Message: 6 Date: Mon, 26 Jan 2009 15:34:09 -0700 From: Galen Charlton <galen.charlton(a)liblime.com> Subject: Re: [Koha-devel] Kudos.koha.org up and running! To: Chris Cormack <chris(a)bigballofwax.co.nz> Cc: koha-devel <Koha-devel(a)nongnu.org> Message-ID: <4659947d0901261434t31d5c7f9t79ba12986b5df21a(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi, On Mon, Jan 26, 2009 at 1:00 PM, Chris Cormack <chris(a)bigballofwax.co.nz> wrote: > My only query is the byline > > " The Official Koha Users & Developers Group! " > > Kudos is a worldwide users group?? And is it the only users and > developers group? What is kohala then? I also question the tagline. I hope that KUDOS will play an active and important role in the Koha project, but there is no need to imply exclusivity. Regards, Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton(a)liblime.com p: 1-888-564-2457 x709 skype: gmcharlt _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel ------------------------------ Message: 7 Date: Mon, 26 Jan 2009 18:36:36 -0500 From: Ryan Higgins <ryan.higgins(a)liblime.com> Subject: [Koha-devel] RFC: Koha 3.2 : Split Issuing rules into Circ rules and Circ policies To: "koha-devel(a)lists.koha.org" <koha-devel(a)lists.koha.org> Message-ID: <b223c4200901261536u44622eb5r413697e02cd37d01(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 RFC : Split issuingrules into Circ rules and Circ policies Full version : http://wiki.koha.org/doku.php?id=en:development:rfcs3.2:rfc32_circ_policies Synopsis: The issuingrules table and smart-rules.pl interface currently mix definition of circulation policy with definition of when those policies should be applied. This proposal suggests two distinct interfaces for these operations. Details The issuingrules table currently holds performs two discrete functions: 1. it holds data describing circulation & fines policy, i.e. loan length, maxissues, fine, etc. 2. it describes which transactions should cause those policies to be applied. This RFC proposes that these two data sets be represented in two new tables in the Koha database, circ_rules and circ_policies, which would supercede the issuingrules table (i.e. issuingrules will be dropped). Benefits: 1. Database normalization. as described above. 2. Simplifies interface for those libraries that have many itemtype & borrower categories. 3. Simplifies future enhancements, allowing us to attach other types of policies to a given transaction context, e.g. adding a holds_policies table. Drawbacks: 1. Having the Policies described on a separate page than where they are assigned adds a level of complexity to assignment. This drawback is addressed by including in smart_rules.pl a 'policy lookup' allowing the user to look up any available circ policies, as well as an on-hover display of a policy in the rules display. (see screenshot). Database changes: * circ_rules will include branchcode, itemtype, categorycode and circ_policies_id (and circ_termset_id, see rfc: term loans) * circ_policies will include remaining columns from issuingules, with some cleanup. The patch set will include an updatedatabase patch that will extract repeated policies from the issuingrules table, name them in English with an appropriate description, and assign those policies to the circ_rules table. Please see wiki page for screenshot of interface. http://wiki.koha.org/doku.php?id=en:development:rfcs3.2:rfc32_circ_policies Comments appreciated. -- Ryan Higgins LibLime * Open-Source Solutions for Libraries Featuring KohaZOOM ILS 888-564-2457 x704 ------------------------------ _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel End of Koha-devel Digest, Vol 38, Issue 22 ******************************************

3 2

Re: [Koha-devel] Koha-devel Digest, Vol 38, Issue 26
by Krishnan M 28 Jan '09

28 Jan '09

Sayed, There are some companies that host koha for you (including Liblime). The other alternative is to get your own hosting, setup Koha and do-it-yourself, as long as you (or someone you know) can do a (tiny) little bit of Linux system administration from time to time. I can volunteer to assist you with the latter route, since i suspect that it is, in general, more cost-effective and flexible. I did the same for a non-profit (GOB) in Spain. Their Koha is now up at https://biblioteca.gobmallorca.com/ We basically rented a "slice" (a server through virtualization) on the Internet, and then set it up with Koha. The approximate current cost is about 25USD a month. Best regards, krishnan mani, India --- On Wed, 28/1/09, koha-devel-request(a)lists.koha.org <koha-devel-request(a)lists.koha.org> wrote: From: koha-devel-request(a)lists.koha.org <koha-devel-request(a)lists.koha.org> Subject: Koha-devel Digest, Vol 38, Issue 26 To: koha-devel(a)lists.koha.org Date: Wednesday, 28 January, 2009, 11:00 AM Send Koha-devel mailing list submissions to koha-devel(a)lists.koha.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.koha.org/mailman/listinfo/koha-devel or, via email, send a message with subject or body 'help' to koha-devel-request(a)lists.koha.org You can reach the person managing the list at koha-devel-owner(a)lists.koha.org When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha-devel digest..." Today's Topics: 1. Re: Kudos.koha.org up and running! (Kyle Hall) 2. Re: Koha-devel Digest, Vol 38, Issue 22 (Sayed Baser Ali) ---------------------------------------------------------------------- Message: 1 Date: Tue, 27 Jan 2009 20:17:10 -0500 From: Kyle Hall <kyle.m.hall(a)gmail.com> Subject: Re: [Koha-devel] Kudos.koha.org up and running! To: Tina Burger <tina.burger(a)gmail.com> Cc: koha-devel <Koha-devel(a)nongnu.org> Message-ID: <aa4e12320901271717m74119f83u4340200e2964f502(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 > Indeed, KUDOS was always intended to be a US-specific group because (I feel > like a broken record here-- so sorry about that) that's what the Koha > developers and creators said they wanted at the KohaCon in France-- for each > region or continent to have their own user group and no 'worldwide' one. > > All my conversations with John Brice have always indicated to me that that > was his assumption as well (US -- or at least North American-- specific) So > I agree with the new tagline you suggest above. I have assumed from the beginning that KUDOS was to be US-centric. John has said so before. From the beginning I didn't really like the byline I had used, that's why I've been asking for input. Let me know if you have any other suggestions for changes or content. FYI, the server that is hosting the site seems to be down. I'll be fixing that in the morning. Thanks, Kyle _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel ------------------------------ Message: 2 Date: Wed, 28 Jan 2009 08:54:49 +0430 From: "Sayed Baser Ali" <sali(a)arolp.org> Subject: Re: [Koha-devel] Koha-devel Digest, Vol 38, Issue 22 To: <koha-devel(a)lists.koha.org> Message-ID: <20090128042516.97EF73296E(a)koha.paulpoulain.com> Content-Type: text/plain; charset="us-ascii" Dear All, We want to use koha catalogue for our library please help us where we can buy or get the web hosting , we are in Afghanistan, Best regards, Jan Agha -----Original Message----- From: koha-devel-bounces(a)lists.koha.org [mailto:koha-devel-bounces@lists.koha.org] On Behalf Of koha-devel-request(a)lists.koha.org Sent: Tuesday, January 27, 2009 4:07 AM To: koha-devel(a)lists.koha.org Subject: Koha-devel Digest, Vol 38, Issue 22 Send Koha-devel mailing list submissions to koha-devel(a)lists.koha.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.koha.org/mailman/listinfo/koha-devel or, via email, send a message with subject or body 'help' to koha-devel-request(a)lists.koha.org You can reach the person managing the list at koha-devel-owner(a)lists.koha.org When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha-devel digest..." Today's Topics: 1. Re: Koha 3 Reset Database (David Riggs) 2. Re: Koha 3 Reset Database (Mason James) 3. Re: Kudos.koha.org up and running! (Chris Cormack) 4. Re: Kudos.koha.org up and running! (MJ Ray) 5. Re: Kudos.koha.org up and running! (Owen Leonard) 6. Re: Kudos.koha.org up and running! (Galen Charlton) 7. RFC: Koha 3.2 : Split Issuing rules into Circ rules and Circ policies (Ryan Higgins) ---------------------------------------------------------------------- Message: 1 Date: Mon, 26 Jan 2009 16:51:21 -0500 From: David Riggs <riggs(a)createtank.com> Subject: Re: [Koha-devel] Koha 3 Reset Database To: koha-devel(a)lists.koha.org Message-ID: <e976163d0901261351o4d631131qaead4ec237b211a9(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 On Mon, Jan 26, 2009 at 4:16 PM, Mason James <mason.loves.sushi(a)gmail.com> wrote: > > try a 'zebraidx -c /yourpath/koha-conf.xml init' then > > FYI: have a peek at line 488-ish of the rebuild script > > system("zebraidx -c $zebra_config -g $record_format -d $zebra_db_name > init") if $reset_index; > No change. I continue to get results when searching, despite having truncated the listed tables, running various combinations of `rebuild_zebra.pl` and `zebraidx -c`. Clicking those items results in a 404. I have verified that browser caching is not at fault. I'm supposed to give an evaluation of Koha's suitability for use this week, and having the database(s) in an inconsistent state is making that extremely difficult. While it would be nice to persist my configuration changes, I'd be happy just blowing away and re-creating the database. Can someone please point me to docs or offer help as to how to re-initialize the DB without doing a complete re-installation? I'm overwhelmed by the number of scripts and data files provided, and unable to find documentation aside from reading hundreds of lines of Perl. Thanks for your help! - DR -- david a. riggs software engineer, createTank mailto:riggs@createtank.com voice: +1-304-685-7537 fax: +1-800-975-8379 http://createtank.com ------------------------------ Message: 2 Date: Tue, 27 Jan 2009 11:02:42 +1300 From: Mason James <mason.loves.sushi(a)gmail.com> Subject: Re: [Koha-devel] Koha 3 Reset Database To: David Riggs <riggs(a)createtank.com> Cc: koha-devel(a)lists.koha.org Message-ID: <748F707A-A27C-4E92-87D2-B14E59A0F9FD(a)gmail.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed On 2009/01/27, at 10:51 AM, David Riggs wrote: > On Mon, Jan 26, 2009 at 4:16 PM, Mason James > <mason.loves.sushi(a)gmail.com> wrote: >> >> try a 'zebraidx -c /yourpath/koha-conf.xml init' then >> >> FYI: have a peek at line 488-ish of the rebuild script >> >> system("zebraidx -c $zebra_config -g $record_format -d >> $zebra_db_name >> init") if $reset_index; >> > > No change. I continue to get results when searching, despite having > truncated the listed tables, running various combinations of > `rebuild_zebra.pl` and `zebraidx -c`. Clicking those items results in > a 404. I have verified that browser caching is not at fault. > > I'm supposed to give an evaluation of Koha's suitability for use this > week, and having the database(s) in an inconsistent state is making > that extremely difficult. While it would be nice to persist my > configuration changes, I'd be happy just blowing away and re-creating > the database. Can someone please point me to docs or offer help as to > how to re-initialize the DB without doing a complete re-installation? > I'm overwhelmed by the number of scripts and data files provided, and > unable to find documentation aside from reading hundreds of lines of > Perl. > > Thanks for your help! > - DR > > ok, to wipe your zebra auth and bib dbs - this works for me.. # zebraidx -c /home/mason/koha/ashs/etc/zebradb/zebra-authorities- dom.cfg -g iso2709 -d authorities init 11:01:02-27/01 zebraidx(17800) [log] zebra_start 2.0.34 /home/mason/ koha/ashs/etc/zebradb/zebra-authorities-dom.cfg 11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-text.so 11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-dom.so 11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-alvis.so 11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-grs-marc.so 11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-grs-xml.so 11:01:02-27/01 zebraidx(17800) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-grs-regx.so 11:01:02-27/01 zebraidx(17800) [log] enabling shadow spec=/home/mason/ koha/ashs/var/lib/zebradb/authorities/shadow:1G 11:01:02-27/01 zebraidx(17800) [log] cache_fname = /home/mason/koha/ ashs/var/lib/zebradb/authorities/shadow/cache 11:01:02-27/01 zebraidx(17800) [log] zebra_stop: 0.02 0.02 0.00 # zebraidx -c /home/mason/koha/ashs/etc/zebradb/zebra-biblios.cfg - g iso2709 -d biblios init 11:01:26-27/01 zebraidx(17801) [log] zebra_start 2.0.34 /home/mason/ koha/ashs/etc/zebradb/zebra-biblios.cfg 11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-text.so 11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-dom.so 11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-alvis.so 11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-grs-marc.so 11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-grs-xml.so 11:01:26-27/01 zebraidx(17801) [log] Loaded filter module /usr/lib/ idzebra-2.0/modules/mod-grs-regx.so 11:01:26-27/01 zebraidx(17801) [log] enabling shadow spec=/home/mason/ koha/ashs/var/lib/zebradb/biblios/shadow:4G 11:01:26-27/01 zebraidx(17801) [log] cache_fname = /home/mason/koha/ ashs/var/lib/zebradb/biblios/shadow/cache 11:01:26-27/01 zebraidx(17801) [log] zebra_stop: 0.06 0.02 0.00 root@fugu:/etc/apache2/sites-enabled# ------------------------------ Message: 3 Date: Tue, 27 Jan 2009 09:00:43 +1300 From: Chris Cormack <chris(a)bigballofwax.co.nz> Subject: Re: [Koha-devel] Kudos.koha.org up and running! To: Kyle Hall <kyle.m.hall(a)gmail.com> Cc: koha-devel <Koha-devel(a)nongnu.org> Message-ID: <606aab810901261200i48c24861h556b45d6dfaa1e9a(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 On Tue, Jan 27, 2009 at 1:26 AM, Kyle Hall <kyle.m.hall(a)gmail.com> wrote: > Hello All, > The KUDOS Koha Users and Developers Group website is up and running > at http://kudos.koha.org/ . Thanks to Josh for the help setting it up. > Please let me know if you have any suggestions / criticisms / > complaints / what-have-you. There's not much content at the moment, so > suggestions are very welcome. Let me know if it seems slow or anything > like that, the servers is a virtual machine, so I can bump up the RAM > if it gets a bit sluggish. > > If everything seems kosher, I'll post something up on the Koha and > KUDOS mailing lists. > My only query is the byline " The Official Koha Users & Developers Group! " Kudos is a worldwide users group?? And is it the only users and developers group? What is kohala then? Chris _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel ------------------------------ Message: 4 Date: Mon, 26 Jan 2009 21:21:33 +0000 From: MJ Ray <mjr(a)phonecoop.coop> Subject: Re: [Koha-devel] Kudos.koha.org up and running! To: kyle.m.hall(a)gmail.com, Koha-devel(a)nongnu.org Message-ID: <497e295d.URdvAZJTgjpDE445%mjr(a)phonecoop.coop> Content-Type: text/plain; charset=us-ascii Kyle Hall <kyle.m.hall(a)gmail.com> wrote: > The KUDOS Koha Users and Developers Group website is up and running > at http://kudos.koha.org/ . Thanks to Josh for the help setting it up. It seems to be a redirect to http://liblime.com/news-items/blogs which is not at all appropriate, in my opinion. Is the intention to port the current KUDOS Wordpress across? (Please!) Thanks, -- MJ Ray (slef) Webmaster for hire, statistician and online shop builder for a small worker cooperative http://www.ttllp.co.uk/ http://mjr.towers.org.uk/ (Notice http://mjr.towers.org.uk/email.html) tel:+44-844-4437-237 _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel ------------------------------ Message: 5 Date: Mon, 26 Jan 2009 17:28:42 -0500 From: Owen Leonard <oleonard(a)myacpl.org> Subject: Re: [Koha-devel] Kudos.koha.org up and running! To: Chris Cormack <chris(a)bigballofwax.co.nz> Cc: koha-devel <Koha-devel(a)nongnu.org> Message-ID: <c0aa2140901261428t2ab091b6l3c38fc6e7659a69e(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 > My only query is the byline > > " The Official Koha Users & Developers Group! " Agreed. I think it's important not to claim anything official about it. That suggests that if someone started another group it wouldn't be "endorsed by the Koha Project." -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel ------------------------------ Message: 6 Date: Mon, 26 Jan 2009 15:34:09 -0700 From: Galen Charlton <galen.charlton(a)liblime.com> Subject: Re: [Koha-devel] Kudos.koha.org up and running! To: Chris Cormack <chris(a)bigballofwax.co.nz> Cc: koha-devel <Koha-devel(a)nongnu.org> Message-ID: <4659947d0901261434t31d5c7f9t79ba12986b5df21a(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi, On Mon, Jan 26, 2009 at 1:00 PM, Chris Cormack <chris(a)bigballofwax.co.nz> wrote: > My only query is the byline > > " The Official Koha Users & Developers Group! " > > Kudos is a worldwide users group?? And is it the only users and > developers group? What is kohala then? I also question the tagline. I hope that KUDOS will play an active and important role in the Koha project, but there is no need to imply exclusivity. Regards, Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton(a)liblime.com p: 1-888-564-2457 x709 skype: gmcharlt _______________________________________________ Koha-devel mailing list Koha-devel(a)nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel ------------------------------ Message: 7 Date: Mon, 26 Jan 2009 18:36:36 -0500 From: Ryan Higgins <ryan.higgins(a)liblime.com> Subject: [Koha-devel] RFC: Koha 3.2 : Split Issuing rules into Circ rules and Circ policies To: "koha-devel(a)lists.koha.org" <koha-devel(a)lists.koha.org> Message-ID: <b223c4200901261536u44622eb5r413697e02cd37d01(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 RFC : Split issuingrules into Circ rules and Circ policies Full version : http://wiki.koha.org/doku.php?id=en:development:rfcs3.2:rfc32_circ_policies Synopsis: The issuingrules table and smart-rules.pl interface currently mix definition of circulation policy with definition of when those policies should be applied. This proposal suggests two distinct interfaces for these operations. Details The issuingrules table currently holds performs two discrete functions: 1. it holds data describing circulation & fines policy, i.e. loan length, maxissues, fine, etc. 2. it describes which transactions should cause those policies to be applied. This RFC proposes that these two data sets be represented in two new tables in the Koha database, circ_rules and circ_policies, which would supercede the issuingrules table (i.e. issuingrules will be dropped). Benefits: 1. Database normalization. as described above. 2. Simplifies interface for those libraries that have many itemtype & borrower categories. 3. Simplifies future enhancements, allowing us to attach other types of policies to a given transaction context, e.g. adding a holds_policies table. Drawbacks: 1. Having the Policies described on a separate page than where they are assigned adds a level of complexity to assignment. This drawback is addressed by including in smart_rules.pl a 'policy lookup' allowing the user to look up any available circ policies, as well as an on-hover display of a policy in the rules display. (see screenshot). Database changes: * circ_rules will include branchcode, itemtype, categorycode and circ_policies_id (and circ_termset_id, see rfc: term loans) * circ_policies will include remaining columns from issuingules, with some cleanup. The patch set will include an updatedatabase patch that will extract repeated policies from the issuingrules table, name them in English with an appropriate description, and assign those policies to the circ_rules table. Please see wiki page for screenshot of interface. http://wiki.koha.org/doku.php?id=en:development:rfcs3.2:rfc32_circ_policies Comments appreciated. -- Ryan Higgins LibLime * Open-Source Solutions for Libraries Featuring KohaZOOM ILS 888-564-2457 x704 ------------------------------ _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel End of Koha-devel Digest, Vol 38, Issue 22 ****************************************** ------------------------------ _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel End of Koha-devel Digest, Vol 38, Issue 26 ****************************************** Connect with friends all over the world. Get Yahoo! India Messenger at http://in.messenger.yahoo.com/?wm=n/

1 0

Holds Queue view_holdsqueue.pl 404 Error
by David Riggs 28 Jan '09

28 Jan '09

I've installed Koha 3.00.00 on Ubuntu 8.04, and when clicking the "Holds Queue" link in the Staff Client, I receive a 404 error trying to display view_holdsqueue.pl. Searching the mailing lists shows several people complaining about this, but no definitive answer as to the cause. Is this the result of some failed part of the installation? Missing cron job? Strangely, I've placed two holds via the OPAC successfully, but when I look in the database, 'select count(*) from tmp_holdsqueue' claims 1 row, and 'select * from tmp_holdsqueue' returns zero rows. Huh?! Can anyone explain what I've botched and how to get a working holds queue? Thanks, - DR -- david a. riggs software engineer, createTank mailto:riggs@createtank.com voice: +1-304-685-7537 fax: +1-800-975-8379 http://createtank.com

1 0

RFC: Koha 3.2 : Split Issuing rules into Circ rules and Circ policies
by Ryan Higgins 27 Jan '09

27 Jan '09

RFC : Split issuingrules into Circ rules and Circ policies Full version : http://wiki.koha.org/doku.php?id=en:development:rfcs3.2:rfc32_circ_policies Synopsis: The issuingrules table and smart-rules.pl interface currently mix definition of circulation policy with definition of when those policies should be applied. This proposal suggests two distinct interfaces for these operations. Details The issuingrules table currently holds performs two discrete functions: 1. it holds data describing circulation & fines policy, i.e. loan length, maxissues, fine, etc. 2. it describes which transactions should cause those policies to be applied. This RFC proposes that these two data sets be represented in two new tables in the Koha database, circ_rules and circ_policies, which would supercede the issuingrules table (i.e. issuingrules will be dropped). Benefits: 1. Database normalization. as described above. 2. Simplifies interface for those libraries that have many itemtype & borrower categories. 3. Simplifies future enhancements, allowing us to attach other types of policies to a given transaction context, e.g. adding a holds_policies table. Drawbacks: 1. Having the Policies described on a separate page than where they are assigned adds a level of complexity to assignment. This drawback is addressed by including in smart_rules.pl a 'policy lookup' allowing the user to look up any available circ policies, as well as an on-hover display of a policy in the rules display. (see screenshot). Database changes: * circ_rules will include branchcode, itemtype, categorycode and circ_policies_id (and circ_termset_id, see rfc: term loans) * circ_policies will include remaining columns from issuingules, with some cleanup. The patch set will include an updatedatabase patch that will extract repeated policies from the issuingrules table, name them in English with an appropriate description, and assign those policies to the circ_rules table. Please see wiki page for screenshot of interface. http://wiki.koha.org/doku.php?id=en:development:rfcs3.2:rfc32_circ_policies Comments appreciated. -- Ryan Higgins LibLime * Open-Source Solutions for Libraries Featuring KohaZOOM ILS 888-564-2457 x704

1 0

Bug in "Add to list" feature
by Jason Macki 26 Jan '09

26 Jan '09

Hello, I've recently imported data from our old library system to Koha version 3 on Linux. When someone opens a bibliographic record in the Koha management interface, and clicks "add to list", a popup window appears with the following error: Can't use string ("1") as an ARRAY ref while "strict refs" in use at /usr/share/koha/intranet/cgi-bin/virtualshelves/addbybiblionumber.pl line 101. Does anyone know how I can fix this problem? Thanks very much, Jason

1 0

KohaCon 2009 information about the conference and Registration
by David Schuster 26 Jan '09

26 Jan '09

Forgive the cross posting but trying to make sure I cover as much of the community as possible. KohaCon 2009 Registration KohaCon 2009 will be held in Plano, TX April 16 and 17. This is a FREE conference. There is no registration fee, but we are requesting that all attendees pre-register. Details (travel, hotels, agenda draft, etc) can be found at: Koha WIKI: http://wiki.koha.org/doku.php?id=kohacon2009 There is a "Tentative Schedule" - it will change as more people sign up probably for programs. Travel information along with Hotel accomodation information. Lunch and dinners will be on your own. Feel free to contact any of the three people listed on the Wiki at the top or email me directly. David Schuster -- View this message in context: http://www.nabble.com/KohaCon-2009-information-about-the-conference-and-Reg… Sent from the Koha - Dev mailing list archive at Nabble.com.

1 0

Re: [Koha-devel] adding a model abstraction ?
by Marc Chantreux 23 Jan '09

23 Jan '09

Hi Zeno, On Thu, Jan 22, 2009 at 06:27:21PM +0100, Zeno Tajoli wrote: >> - try to find a way to have an up-to-date diagram class > in fact I and Matteo Romanello we are working on this task. well ... i meant autogenerated diagrams using the introspection features provided by modern OO frameworks like Moose. regards -- Marc Chantreux BibLibre, expert en logiciels libres pour l'info-doc http://biblibre.com

1 0

adding a model abstraction ?
by Marc Chantreux 22 Jan '09

22 Jan '09

hello guys, I just rewritten the C4::Bookseller::AddBookseller and it now looks like: sub AddBookseller { _koha_insert_and_get_id( 'aqbooksellers', shift ); } _koha_insert_and_get_id is a function where i deal with DBI and all specific DBD tricks with reuse in mind. You can see the following code. do i try to push it in koha ? and where ? It sounds like Koha::SQL package. regards sub _koha_insert_and_get_id { # Todo: implement uses of config # like exclude, defaults, ... # $tablename is a string and contains the name of the table # $data is a reference to an hash that contains column names to set as keys # optionnal $config alter default behaviour my ( $tablename, $data, $config ) = @_; my $dbh = C4::Context->dbh; # @fields to insert are all %$data (unless overwritten by $$config{fields} ) my @fields = (defined $config and exists $config->{fields}) ? @{ $config->{fields} } : keys %$data ; # build the query my $query = 'INSERT INTO ' . $tablename .' (' . join(',',@fields) . ') VALUES (' . join(',', map {'?'} @fields) . ');' ; my $sth = $dbh->prepare($query); # deal with the server $sth->execute( @$data{@fields}); if ( $sth->err ) { warn $sth->errstr; return undef; } # return the last id C4::Context->config('db_scheme') eq 'mysql' and return $dbh->{mysql_insertid}; # todo use the last_insert_id dbh function # my $id = $dbh->last_insert_id( ? ); # before give up warn 'database unable to get last inserted id'; return undef; } -- Marc Chantreux http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc

12 32

unimarc mapping to biblioitems.volume inconsistant
by Michael Hafen 22 Jan '09

22 Jan '09

So I'm working on adding a remainderoftitle column to the biblio table. I've been told that in Unimarc 200$e would be a good place to map this column. I'm looking at the French unimarc default framework sql file in the installer, and it seems that biblioitems.volume is already there. Now I look at the english unimarc default framework file, and biblioitems.volume is mapped to 225$v and 200$e is unmapped. I would like it if those who develop on the unimarc framework could resolve this inconsistency. Thank you. -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA for Koha checkout http://koha-dev.washk12.org or git://koha-dev.washk12.org/koha

3 2