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

Textbook management system
by David Schuster 18 Sep '09

18 Sep '09

Is there interest in Koha to have a Textbook management type module? Does anyone know of a good OpenSource one? This Development might be coming soon... David Schuster -- View this message in context: http://www.nabble.com/Textbook-management-system-tp25508498p25508498.html Sent from the Koha - Dev mailing list archive at Nabble.com.

1 0

RFC: Koha Book Cover System
by Kyle Hall 18 Sep '09

18 Sep '09

Hey All, Writing the LibraryThing book cover module has really got my brain in full gear. I've been thinking about how nice it would be to add an internal cover system to Koha. That way, a library could specify the exact cover they want if they so wish. Here's what I'm imagining. A new ItemImages.pm ( BookCovers.pm, BookJackets.pm, what have you... ) This new Covers module would be the sole interface for Koha for all cover systems ( Amazon, LibraryThing, Syndetics, etc. ) and would act as an interface between Koha and the book cover modules. Another module ( say LocalCovers ) would act as a caching system. Librarians would then at the time of cataloging, but able to search various sources for book jackets, and choose one to download and save for that bib record. A set of preferences would allow for a cascading selection of sources from which to display book covers. For example, a library could have the system set up to look for a locally stored book cover first. If one is not found, it checks LibraryThing for one, if one is not found there, it then uses an Amazon book cover. Possible Issues: Do any of the cover API's have Terms of Service that could pose a problem to such an system? ( For example, can we cache amazon.com images, or must they always be links? ) The existing C4::External modules would need to be modified. Where should local/cached covers be stored? Filesystem and/or MySQL blob? Any and all opinions welcome, Kyle http://www.kylehall.info Information Technology Crawford County Federated Library System ( http://www.ccfls.org )

8 10

Farewell
by chirag purohit 17 Sep '09

17 Sep '09

Hello All, >From today I am no longer attached with KOHA.Thanks for your all's constant support,especially Joe Atzberger and Vimal Laxman. Regards, -- Purohit Chirag

1 0

mod_perl
by Miguel Angel Calvo Lázaro 17 Sep '09

17 Sep '09

Hello. I'm experimenting with mod_perl, accurately, with perl:: run and searches, to recharge I get this error: Attempt to reload C4/Auth.pm aborted.\nCompilation failed in require at /var/www/kohaorg/errors/500.pl line 21.\nBEGIN failed--compilation aborted at /var/www/kohaorg/errors/500.pl line 21.\n Do not know if someone is working under mod_perl. If not possible, I think it should be one of the main issues to be resolved. Miguel Angel Calvo

3 2

Offline circ tool [BibLibre coderun]
by paul POULAIN 17 Sep '09

17 Sep '09

Hi koha-dev, As you know, BibLibre is working (hard) on a coderun for 3.2 Jean-André (our last hired developer) has almost finished to work on a firefox extension for offline circ. It works pretty well, uses the .koc files structure defined by Kyle. As FF extension, it will be very easy to deploy and update. It should be improved in the next months, Jean-André is working on a wiki.koha.org page about improvements. Stay tuned. It will be contributed on git, of course, BUT for deployements the version will be downloaded from addons.mozilla.org (ie: the source code is useless for the Apache part of Koha) Cheers, -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

4 5

kohastructure.sql
by Simon Mitchell 16 Sep '09

16 Sep '09

Hi guy, am having a play with a script to convert the current mysql kohastructure.sql to postgresql etc. My thinking is that any updates to the mysql kohastructure.sql could be handled by automatically by a script. Firstly I have noticed that some table name and columns names are not quoted. Could some one fix that the next time an edit is done. Example DROP TABLE IF EXISTS `branch_transfer_limits`; CREATE TABLE branch_transfer_limits ( limitId int(8) NOT NULL auto_increment, toBranch varchar(10) NOT NULL, fromBranch varchar(10) NOT NULL, itemtype varchar(10) NULL, ccode varchar(10) NULL, PRIMARY KEY (limitId) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; And My postgresql database complains that there is no unique key on aqbookfund bookfundid My thinking is this is cause by *REFERENCES `aqbookfund` (`bookfundid`)*which should be *REFERENCES `aqbookfund` (`bookfundid`,`branchcode`)* in table aqorderbreakdown. Does this need to be fixed or is bookfundid unique and justs needs a unique key? DROP TABLE IF EXISTS `aqbookfund`; CREATE TABLE `aqbookfund` ( `bookfundid` varchar(10) NOT NULL default '', `bookfundname` mediumtext, `bookfundgroup` varchar(5) default NULL, `branchcode` varchar(10) NOT NULL default '', PRIMARY KEY (`bookfundid`,`branchcode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `aqorderbreakdown`; CREATE TABLE `aqorderbreakdown` ( `ordernumber` int(11) default NULL, `linenumber` int(11) default NULL, `branchcode` varchar(10) default NULL, `bookfundid` varchar(10) NOT NULL default '', `allocation` smallint(6) default NULL, KEY `ordernumber` (`ordernumber`), KEY `bookfundid` (`bookfundid`), CONSTRAINT `aqorderbreakdown_ibfk_1` FOREIGN KEY (`ordernumber`) REFERENCES `aqorders` (`ordernumber`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `aqorderbreakdown_ibfk_2` FOREIGN KEY (`bookfundid`) REFERENCES `aqbookfund` (`bookfundid`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ++++++++++++++++++++++++++++++++++++++++ some more ramblings follows I have been look at http://en.wikibooks.org/w/index.php?title=Programming:Converting_MySQL_to_P… and like the idea of using *SET sql_mode='ANSI_QUOTES' * at the top of the mysql sql files to get rid of the ` qoute and use ".* * The later versions of Postgresql has introduce new features that may make it possible koha to run on postgresql. Enum example - Mysql - CREATE TABLE `import_items` ( `import_items_id` int(11) NOT NULL auto_increment, `import_record_id` int(11) NOT NULL, `itemnumber` int(11) default NULL, `branchcode` varchar(10) default NULL, `status` enum('error', 'staged', 'imported', 'reverted', 'ignored') NOT NULL default 'staged', `marcxml` longtext NOT NULL, `import_error` mediumtext, PRIMARY KEY (`import_items_id`), CONSTRAINT `import_items_ibfk_1` FOREIGN KEY (`import_record_id`) REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE, KEY `itemnumber` (`itemnumber`), KEY `branchcode` (`branchcode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; Postgresql CREATE TYPE *enum_import_items_status* AS ENUM ('error', 'staged', 'imported', 'reverted', 'ignored'); DROP TABLE IF EXISTS "import_items"; CREATE TABLE "import_items" ( "import_items_id" serial, "import_record_id" integer NOT NULL, "itemnumber" integer default NULL, "branchcode" varchar(10) default NULL, "status" *enum_import_items_status* NOT NULL default 'staged', "marcxml" text NOT NULL, "import_error" text , PRIMARY KEY ("import_items_id") ); ALTER TABLE import_items ADD CONSTRAINT "import_items_ibfk_1" FOREIGN KEY ("import_record_id") REFERENCES "import_records" ("import_record_id") ON DELETE CASCADE ON UPDATE CASCADE; CREATE INDEX import_items_itemnumber_idx ON import_items ("itemnumber"); CREATE INDEX import_items_branchcode_idx ON import_items ("branchcode"); ++++++++++++++++++++++++++++ Regards Simon Sydney, Australia

2 1

Re: [Koha-devel] kohastructure.sql
by Zeno Tajoli 16 Sep '09

16 Sep '09

Dear Simon, At 08.26 16/09/2009, Simon Mitchell wrote: >Hi guy, am having a play with a script to convert the current mysql >kohastructure.sql to postgresql etc. >My thinking is that any updates to the mysql kohastructure.sql could >be handled by automatically by a script. i'm not sure this is the best path to have Koha on MySQL and on Postgresl. Chris Cormack is working on this topic (support Ps in Koha). I think he prefer to use a perl module as abstract layer (DBIx::Class). >Firstly I have noticed that some table name and columns names are not quoted. >Could some one fix that the next time an edit is done. > >And > >My postgresql database complains that there is no unique key on >aqbookfund bookfundid >My thinking is this is cause by REFERENCES `aqbookfund` >(`bookfundid`) which should be REFERENCES `aqbookfund` >(`bookfundid`,`branchcode`) >in table aqorderbreakdown. > >Does this need to be fixed or is bookfundid unique and justs needs a >unique key? In fact not all relations are present into .sql code. In fact to check to situation you need to see the code in the API (../C4 dirs). Documentation on DB level of Koha here: http://wiki.koha.org/doku.php?id=en:development:dbschema Attention on documentation about ver 3.0.3: Comments are correct, images not always. Bye Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)

1 0

Hiding search from users who haven't logged in
by Michael 16 Sep '09

16 Sep '09

Hi, I'm trying to make an adjustment on an OPAC. Is there a way to hide the 'search' form/buttons from users who have not logged in yet? Also, can it be done without editing the templates? Using jscript is fine or via any other method that can be done through System Preferences. Thanks!

2 1

Help for Koha and Fingerprint Reader
by Roxana Luz Fleipaz 16 Sep '09

16 Sep '09

Hello Friends. I'm sure there's someone here who has experience of working KOHA with Fingerprint Reader. My case is the following code readers have fingerprints SFR300 NEXT-S ver2 model, and I need to integrate with KOHA. Can anyone help me and tell me where to start? Thank you very much, Be aware of any please reply. Tanks. Roxana Luz

2 1

Koha error diagnosed, new question
by Chadwick, John, DCA 15 Sep '09

15 Sep '09

Okay, I diagnosed the cause of the error, but now I have a new question. In the koha-conf.xml file I commented out the last two lines concerning the memory caching, memcached_servers and memcached_namespace. That took care of the issue concerning being able to go to the web installer via the full url and getting the fatal error message when I use the just localhost:8080. Now, the question is, how important, or unimportant, is the memcached commands? Thanks, John +----------------------------------------------------------------------- -----+ John Chadwick, Ed.D. Information Technology Manager New Mexico State Library 1209 Camino Carlos Rey Santa Fe, NM 87507 Phone: 505-476-9740 Cell: 505-629-8116 Fax: 505-476-9761 john.chadwick(a)state.nm.us http://www.nmstatelibrary.org Confidentiality Notice: This e-mail, including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the Sybari - Antigen Email System. Confidentiality Notice: This e-mail,including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review,use,disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the MessageLabs Email Security System.

2 2