- Koha - lists.katipo.co.nz

Re: [Koha] Subject: Contributing- computer reservation?
by jminges 02 Feb '09

02 Feb '09

Brook Westheimer wrote: RE: Subject: [Koha] Contributing- computer reservation? Message: 5 Date: Fri, 30 Jan 2009 16:09:38 -0500 From: "Westheimer, Brook" <Brook.Westheimer(a)cincinnatilibrary.org> Subject: [Koha] Contributing- computer reservation? To: <koha(a)lists.katipo.co.nz> Message-ID: <6C507EF21BE92D40A93EF2E3452C256AC33B4E(a)EXVSCL1.PLCH.NET> Content-Type: text/plain; charset="us-ascii" Hi- I wanted to introduce myself and put something out there. I've been lurking for a minute and learning more about Koha. I found Koha when researching open source options for computer reservation and printing systems since I work with this type of software the most. Has anyone ever proposed building reservation software? I would love to contribute this element... It's such a simple piece of software and there's so much that can be improved on. I work more on the user end of technology, but I also know HTML/CSS/PHP and am learning Perl and mySQL. Best- Brook Westheimer LSA TechCenter Public Library of Cincinnati and Hamilton County 513-369-6918 brook.westheimer(a)cincinnatilibrary.org Brook, Public computer reservation and print control software is a huge need for our group of libraries. If that were developed for the Koha environment that would be an important contribution. I believe there's some reservation code written by someone for v. 2.2 but not 3.0. Jim ----------------------------------------------------------- Jim Minges email: jminges(a)nekls.org Director Northeast Kansas Library System 4317 WEst 6th Street Lawrence, KS 66049 Phone: 785.838.4090 FAX: 785.838.3989 http://www.nekls.org/ On Jan 30, 2009, at 3:24 PM, koha-request(a)lists.katipo.co.nz wrote: > Subject: [Koha] Contributing- computer reservation?

5 6

re set database to allow web installer to be rerun
by Green Possum 02 Feb '09

02 Feb '09

I have just finished installing 3.0.0 on Ubuntu 8.04.2, thanks to the tute at www.blazingmoon.org. At one screen in the web installer I was offered the chance to install some sample data. I didn't take it up. Now I would like to run the web installer again. Is it sufficient to drop the database so that it will start from the beginning? Thanks, Ken -- View this message in context: http://www.nabble.com/reset-database-to-allow-web-installer-to-be-rerun-tp2… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

Postgres 8.2 Support for koha.
by Dinesh 02 Feb '09

02 Feb '09

Hai All, I am trying koha 3.0 on ubuntu 8.04 with postgres 8.2. For installation, i refered http://wiki.koha.org/doku.php?id=koha_3_install_guide_ubuntu_hardy which is very useful. During Installation, database didn't create by the installation script. So i created it manually. And find some tables are missing in the postgres database script. i refered the table structure for mysql and created. Installation moved smoothly. and i logged into the koha library. I tried to create a patron and catalogue, set a library. These modules give me error production mode - trapped fatal error. Anyone please tell me whether postgres support is there for koha? With Kind Regards, K.Dinesh

2 1

koha 2.2.9/zebra install
by Didac Grau 02 Feb '09

02 Feb '09

Someone knows any manual installation of the zebra for Koha window? Koha version 2.2.9 mysql 4.1.22 thank you Didac Grau Sanvisen Dpt. Desenvolupament dgrau(a)ilertec.com Ilertec Consultoria Tecnològica, sll Pl. Sant Joan 23, 4-A 25007 Lleida Tel: 973 232 051 Fax: 973 225 630 http://www.ilertec.com <http://www.ilertec.com> AVÍS LEGAL: La informació adjunta és CONFIDENCIAL, sent per a l'ús exclusiu del destinatari del missatge. Si llegiu aquest missatge i no sou el destinatari assenyalat, l'empleat o l'agent responsable d'entregar el missatge al destinatari, l'informem que és totalment prohibit qualsevol divulgació, distribució o reproducció d'aquesta comunicació. Si heu rebut aquesta comunicació per error, si us plau notifiqueu-ho de forma immediata al remitent i esborreu el missatge junt amb les seus fitxers annexos. El correu electrònic via Internet no permet assegurar la confidencialitat o correcta recepció dels missatges, i és per això que ILERTEC CONSULTORIA TECNOLÒGICA, SLL no assumeix cap tipus de responsabilitat pels danys ocasionats. Si en qualsevol moment voleu modificar la seva decisió de no rebre informació comercial d'ILERTEC CONSULTORIA TECNOLÒGICA, SLL a través del correu electrònic comuniqueu-ho a ILERTEC CONSULTORIA TECNOLÒGICA, SLL a la següent adreça: Pl. Sant Joan 23, 4-A 25007-Lleida. Si voleu expressar-nos algun dubte o pregunta sobre aquest assumpte, us demanem que us poseu en contacte amb nosaltres al telèfon 973 232 051, donant referència al assumpte "Protecció de Dades". Si voleu fer ús dels drets d'accés, rectificació o cancel·lació que us concedeix la Llei Orgànica 15/1999, comuniqueu-ho a ILERTEC CONSULTORIA TECNOLÒGICA, SLL a la següent adreça: Pl. Sant Joan 23, 4-A 25007-Lleida. AVISO LEGAL: La información adjunta es CONFIDENCIAL , siendo para el uso exclusivo del destinatario arriba mencionado. Si Ud. lee este mensaje y no es el destinatario señalado, el empleado o el agente responsable de entregar el mensaje al destinatario, le informamos que está totalmente prohibida cualquier divulgación, distribución o reproducción de esta comunicación. Si Ud. ha recibido esta comunicación por error, por favor, notifíquelo inmediatamente al remitente y borre el mensaje junto con sus ficheros anexos. El correo electrónico vía Internet no permite asegurar la confidencialidad o correcta recepción de los mensajes, por lo que ILERTEC CONSULTORIA TECNOLÒGICA, SLL. no asume responsabilidad alguna por los daños causados. Si en cualquier momento Ud. desea modificar su decisión de no recibir información comercial de ILERTEC CONSULTORIA TECNOLÒGICA, SLL. a través de correo electrónico. comuníquelo a ILERTEC CONSULTORIA TECNOLÒGICA, SLL. en la siguiente dirección: Pl. Sant Joan 23, 4-A 25007-Lleida. Si nos quiere expresar alguna duda o pregunta sobre este asunto, rogamos contacte con nosotros en el teléfono 973 232 051, refiriéndose al asunto "Protección de Datos". Si desea ejercitar los derechos de acceso, rectificación o cancelación que le concede la Ley Orgánica 15/1999, comuníquelo a ILERTEC CONSULTORIA TECNOLÒGICA, SLL. en la siguiente dirección: Pl. Sant Joan 23, 4-A 25007-Lleida. P Abans d'imprimir aquest e-mail penseu bé si és necessari fer-ho: El medi ambient es cosa de tots.

1 0

modify a budget
by Kohn, Karen 31 Jan '09

31 Jan '09

Hello, So far the answers to all my questions have been "no," but I'll keep trying! Thanks for the responses. Here's my latest question: Is there any way to modify a budget? I can get to the fund and add a budget, but I can't see a way to edit the current budget (i.e., put more money in or decrease it). Thanks! Karen Kohn Collection Development Manager Landman Library Arcadia University 450 S. Easton Road Glenside, PA 19038 ph: 215-572-8528 fax: 215-572-0240

2 1

importing issues table
by Marty 31 Jan '09

31 Jan '09

Thanks all, slowly I am getting Koha 3 to work. I have the patrons loaded and the biblios in. Of course I got stuck somewhere else, nothing is ever easy around here... So how do I get the issues loaded? At the moment nobody has anything out, which is not actually the case. I tried this: debian:~# mysqldump Koha.issues > Koha_issues09.sql mysqldump: Got error: 1102: Incorrect database name 'Koha.issues' when selecting the database Then I tried this: mysql> SELECT borrowernumber,itemnumber,date_due,branchcode,issuingbranch,returndate,lastreneweddate,return,renewals,timestamp INTO OUTFILE 'issues.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' FROM issues; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'return,renewals,timestamp INTO OUTFILE 'issues.csv' FIELDS TERMINATED BY ',' EN' at line 1 However, it works when I remove the return table; mysql> SELECT borrowernumber,itemnumber,date_due,branchcode,issuingbranch,returndate,lastreneweddate,renewals,timestamp INTO OUTFILE 'issues.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' FROM issues; Query OK, 6163 rows affected (0.16 sec) Importing this does NOT work; mysql> use koha; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> LOAD DATA INFILE "/home/marty/issues.csv" INTO TABLE issues FIELDS TERMINATED BY ',' ENCLOSED BY ""; ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`koha/issues`, CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL) I also modified the table to match the issues table in Koha 3 by adding the issuedate but that doesn't seem to help either. So I am stuck again... Any help is appreciated, as I am more a librarian than a database expert... Thanks again, Marty

2 1

Contributing- computer reservation?
by Westheimer, Brook 30 Jan '09

30 Jan '09

Hi- I wanted to introduce myself and put something out there. I've been lurking for a minute and learning more about Koha. I found Koha when researching open source options for computer reservation and printing systems since I work with this type of software the most. Has anyone ever proposed building reservation software? I would love to contribute this element... It's such a simple piece of software and there's so much that can be improved on. I work more on the user end of technology, but I also know HTML/CSS/PHP and am learning Perl and mySQL. Best- Brook Westheimer LSA TechCenter Public Library of Cincinnati and Hamilton County 513-369-6918 brook.westheimer(a)cincinnatilibrary.org

4 3

foreign key constraint fails when importing csv
by Marty 30 Jan '09

30 Jan '09

Me again. Trying to get borrowers from old koha to koah 3 I get this error message; mysql> LOAD DATA INFILE "/home/marty/patronz.csv" INTO TABLE borrowers FIELDS TERMINATED BY ',' ENCLOSED BY ""; ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`koha/borrowers`, CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)) Not sure about this foreign key constraint, did I fail to set some value in Koha?

2 2

Re: [Koha] For immediate release: Koha Open Source Community Regrets Failure of
by BWS Johnson 30 Jan '09

30 Jan '09

Salvete! I want to be very clear in stating that I mean no offence to any party by this posting, but I wanted to chime in on this very important discussion. I found there to be nothing inappropriate or deceptive in the release. A search of the archives of both the Developer list and this list shows slim pickings from PTFS, all of the postings very recent indeed. With no commits, and no documentation written to my knowledge, and no postings on the listserv, I feel that it's accurate to say that your company hasn't been involved with the project. The worry, as I see it, would be that the support you might provide might not be as high quality as it would if you were involved, and that any enhancements might not be contributed back. I'm glad that you say that they will be. I am also glad that you have Librarians on board to help you. Rachel is the Kaitiaki. We, as a community, voted for her to represent our values, and oversee the health of the project. I am glad that she is looking out for the project's best interests, as she always has. In the years that I've known her through this list, she's never been deceptive or inappropriate. Nor has Paul, who sent the letter from his account. Neither has Chris, who programmed the code. I find it hard to believe that any of them would change the rules, but if anything needs clarification, Rachel is the final authority for the project short of a formal vote of the membership. While I regret that your first exposure to the listserv was what it was, I like that the release very clearly outlines what PTFS ought do if it wishes to be included on the koha.org site. We aren't seeking to become an exclusive club. Everyone is just looking out for each other in the spirit of fair play. Cheers, Brooke

1 0

Hello world :-)
by Wagner, Jane 30 Jan '09

30 Jan '09

As I just posted to the developer list, I have been subscribed to the various Koha lists for some time, since I joined PTFS. I haven't posted anything yet because I am still learning the system. I thought it would be a courtesy to do my homework before posting newbie questions (but I will send some of those soon). However, I certainly plan to actively participate in the community, as do our developers. I have 20 years' experience in the ILS world, 13 of them as a Sirsi system administrator and programmer at the U.S. Courts, NASA, and University of Virginia Health Sciences Library. Several of you already know me from that environment. From my years in the Sirsi world, I know how valuable a resource a good user/developer community can be, and I look forward to building some good friendships with you. When I was a brand-new Sirsi admin, I got a lot of help from the older sites, and I have always tried to pay that debt forward by helping other sites in turn. I think personal relationships will be even more valuable in the open source world than in the vendor world. I look forward to a lot of good conversations with all of you. Jane Wagner Library Systems Analyst PTFS Inc. Content Management and Library Solutions 6400 Goldsboro Road, Suite 200 Bethesda, MD 20817 (301) 654-8088 x 151 jwagner(a)ptfs.com

1 0