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

hypertext link
by C W Nel 01 Jul '09

01 Jul '09

Is there an easy way to link a record to a specific URL? With other words to have a hyperlink on a specific record to take you to e.g. an html or pdf file to supply more info on this record? Thanks for any help.

4 6

Reminder - general project IRC meeting 1 July 2009
by Galen Charlton 30 Jun '09

30 Jun '09

Hi, The next general meeting of the Koha project will be held on the #koha IRC channel at 19:00 UTC+0. The following standing agenda items will be discussed: 1. Koha 3.2 update 2. Koha 3.0.x update 3. Actions from the previous IRC meeting 4. Addition of “Skip to content” links in the staff client, as discussed on Koha-devel [1] To suggest additional agenda items, please go to the wiki page for this meeting located at <http://wiki.koha.org/doku.php?id=meetingnotes09jul01>. [1] http://lists.koha.org/pipermail/koha-devel/2009-June/009733.html Regards, Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton(a)liblime.com p: 1-888-564-2457 x709 skype: gmcharlt

3 2

Re: [Koha-devel] [Koha] Saving MARC records very slow
by Mason James 30 Jun '09

30 Jun '09

On 2009/06/30, at 11:52 AM, Rick Welykochy wrote: > Cab Vinton wrote: > >> This was covered on the list a while back -- in Firefox it was taking >> 40-50 s on our staff clients to save records. >> >> We've switched to Google Chrome & the time is now much more >> manageable. >> >> I don't believe a diagnosis or fix were ever found for the Firefox >> issue. > As pointed out, this is because of Javascript. > > Question: can Koha operate properly with JS disabled? If not, why not? > > Observation: JS is quite slow compared the server itself. Perhaps the > *HUGE* task of validating a MARC save could be (optionally) left to > the server to validate. this is a good suggestion, but might require a pretty big rewrite of the marc-editor code (not for the faint-hearted) another easier speed win could be to find the slow/often-executed JS code thru profiling, and rewrite it with some optimised jquery is jquery code faster? ermmm i'm not sure actually ;) just a thought...

1 0

updateitem.pl
by Roche III, Edward 29 Jun '09

29 Jun '09

Can someone tell me how to use this script. I know it cannot be used from the command line and I have tried to run it from with the browser. Any help help would be great. Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?"

6 8

koha 3.0 - inexistant table 'borrower_attributes' during update
by Frère Sébastien Marie 29 Jun '09

29 Jun '09

I have a problem when I update koha, during last stage (database update in webinstaller). KOHA Version: 3.0 (git track origin/3.0.x) update 0f6359539cd3a16d28537b18d3c23447b0cd17fb to b2a4853fc53c471664a54630b783c9cc7ac4f93f Database version: update 3.00.01.007 to 3.00.02.012 --- webinstaller log --- [Mon Jun 29 16:11:59 2009] updatedatabase.pl: inside 3.00 at koha/installer/data/mysql/updatedatabase.pl line 1963. [Mon Jun 29 16:11:59 2009] updatedatabase.pl: DBD::mysql::db do failed: Table 'koha.borrower_attributes' doesn't exist at koha/installer/data/mysql/updatedatabase30.pl line 248. [Mon Jun 29 16:11:59 2009] updatedatabase.pl: DBD::mysql::db do failed: Table 'koha.borrower_attributes' doesn't exist at koha/installer/data/mysql/updatedatabase30.pl line 249. --- end --- --- part of "koha/installer/data/mysql/updatedatabase30.pl" --- +$DBversion = "3.00.02.005"; +#$DBversion = '3.01.00.010'; +if ( C4::Context->preference('Version') < TransformToNum($DBversion) ) { + $dbh->do("ALTER TABLE `borrower_attributes` MODIFY COLUMN `attribute` VARCHAR(64) DEFAULT NULL"); + $dbh->do("ALTER TABLE `borrower_attributes` MODIFY COLUMN `password` VARCHAR(64) DEFAULT NULL"); + print "Upgrade to $DBversion done (bug 2687: increase length of borrower attribute fields)\n"; + SetVersion ($DBversion); +} --- end --- --- patch GIT --- commit c1901a84aeaee55a8590d64f8ee1fcac328cf264 Author: Henri-Damien LAURENT <henridamien.laurent(a)biblibre.com> Date: Wed May 6 15:42:19 2009 +0200 UpdateDatabases for 3.0.2 updating elements in order to make 3.0.2 work Signed-off-by: Henri-Damien LAURENT <henridamien.laurent(a)biblibre.com> --- end --- Shortly, updatedatabase30.pl tried to update 'borrower_attributes' table, but this table doesn't exist in my version... (koha 3.0) This modification (the part that failed) is for bug 2687 (increase the length of the password field to VARCHAR(64)). I think is a bug correction for koha 3.1, but not for 3.0 (I hope for my database... else where is my 'borrower_attributes' table ?) Should I ignore this error, with no problem for data integrity (in futures updates) ? Thank. -- Frère Sébastien Marie Abbaye Notre Dame de La Trappe 61380 Soligny-la-Trappe http://www.latrappe.fr/

1 0

Marc Extract and subject headings
by David Schuster 29 Jun '09

29 Jun '09

I am doing a full MARC extraction and with the subject headings am seeing: $9 with numbers. I don't see a way to strip that off unless I do it somehow after the extraction. This is messy for those of us sending to another utility like Biblios or OCLC. =650 \1$aAnimal sounds$vFiction.$9195874 =650 \1$aBedtime$vFiction.$9195875 =650 \1$aStories in rhyme$9195872 Any suggestions or is this a bug needing to be reported looking for an enhancement? David Schuster -- View this message in context: http://www.nabble.com/Marc-Extract-and-subject-headings-tp24202653p24202653… Sent from the Koha - Dev mailing list archive at Nabble.com.

3 4

Koha-3.0.3 Stable release
by LAURENT Henri-Damien 26 Jun '09

26 Jun '09

Hi, Some of you might have encountered some problems with 3.0.2 release opac-reserve and holds-transfer-slip was not in tarball. So we are very happy to announce Koha3.0.3 Stable, which fixes those bugs has been released on http://download.koha.org/ Its name is koha-3.00.03.tar.gz You can download file and signatures You can check the integrity of the package; either by verifying the provided GPG signature (.sig) or by comparing the MD5 checksum: 6c7761b26cbc3e515e225e862907944a koha-3.00.03.tar.gz I have also tagged this in Git as "version 3.00.03" v3.00.03 You can download. An extract of release notes is pasted below This release is bugfix only of 3.0.2 release, and doesnot include any new feature. It doesnot add any databases change from 3.0.2. The next release scheduled in July will include features which are now in master but not ported yet to stable because of database change required. That is to say mainly many content enhancement were not integrated Librarything, Syndetics, Baker&Taylor, Babeltheque, and BranchTransferLimits. But we are willing to make them into the next release which will come out as soon as possible in July. Cheers -- Henri-Damien LAURENT 3 major bug fixing: - opac-reserve broken - 3320 - hold-transfer-slip not included in tarball _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel

2 1

Re: [Koha-devel] [Koha] Label Creator Barcode Not Appearing
by Roche III, Edward 26 Jun '09

26 Jun '09

Ok I thought I checked all the Barcode Types but may have done it with Acrobat 9 and not the others. So it is now working. I have the text info centered but the barcode stays justified to the left, is there a way to center that as well? Thanks! Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" From: Kathy Rippel [mailto:kdr@ckls.org] Sent: Friday, June 26, 2009 12:59 PM To: Roche III, Edward; koha(a)lists.katipo.co.nz Cc: Oliver Bernuetz Subject: Re: [Koha] Label Creator Barcode Not Appearing This may be too simple, but have you experimented with the various "Choose Barcode Type (encoding)" in the layout? Kathy At 11:45 AM 6/26/2009, Roche III, Edward wrote: Content-class: urn:content-classes:message Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C9F67D.93262F0E" Still having this problem. I have now tried Acrobat 7, 8 and 9 with no luck. It almost like I am missing a font or something? Any other thoughts? Oliver, I doubled checked and the drop down had the correct version I was trying to use. Thanks! Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" From: Oliver Bernuetz [ mailto:Oliver.Bernuetz@canadabusiness.mb.ca <mailto:Oliver.Bernuetz@canadabusiness.mb.ca> ] Sent: Wednesday, June 24, 2009 4:01 PM To: Roche III, Edward Subject: RE: [Koha] Label Creator Barcode Not Appearing Hi Ed, When you're generating the PDF did you change the program Koha is supposed to use? It may still be trying to use the newer version of Acrobat. Oliver From: Roche III, Edward [ mailto:edward_roche@solanco.k12.pa.us <mailto:edward_roche@solanco.k12.pa.us> ] Sent: June 24, 2009 2:53 PM To: Oliver Bernuetz Cc: koha(a)lists.katipo.co.nz Subject: RE: [Koha] Label Creator Barcode Not Appearing That didn't do it. I installed version 7 and it still isn't working right. Thanks! Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" From: Oliver Bernuetz [ mailto:Oliver.Bernuetz@canadabusiness.mb.ca <mailto:Oliver.Bernuetz@canadabusiness.mb.ca> ] Sent: Wednesday, June 24, 2009 3:06 PM To: Roche III, Edward Subject: RE: [Koha] Label Creator Barcode Not Appearing You're welcome. Have a good one. Oliver From: Roche III, Edward [ mailto:edward_roche@solanco.k12.pa.us <mailto:edward_roche@solanco.k12.pa.us> ] Sent: June 24, 2009 2:09 PM To: Oliver Bernuetz Subject: RE: [Koha] Label Creator Barcode Not Appearing Version 9 Thanks! Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" From: Oliver Bernuetz [ mailto:Oliver.Bernuetz@canadabusiness.mb.ca <mailto:Oliver.Bernuetz@canadabusiness.mb.ca> ] Sent: Wednesday, June 24, 2009 3:02 PM To: Roche III, Edward Subject: RE: [Koha] Label Creator Barcode Not Appearing Hi Ed, What version of Acrobat are you using? We discovered that the barcodes wouldn't appear on the labels unless we used an earlier version of Acrobat. We're using 7.0 right now. No idea why that is but it works for us. Oliver D. Bernuetz, BA Adv, MLIS Information Specialist/Librarian | Specialiste de l'information/Bibliothècaire Canada/Manitoba Business Service Centre | Centre de services aux entreprises du Canada - Manitoba Western Economic Diversification | Diversification de l'économie de l'Ouest Canada P.O. Box 2609 | C.P. 2609 250-240 Graham Avenue | 240, avenue Graham, bureau 250 Winnipeg, MB R3C 4B3 Telephone | Téléphone 204-983-6182 Facsimile I Téléimprimeur 204-983-3852 Government of Canada | Gouvernement du Canada Government of Manitoba | Gouvernement du Manitoba From: koha-bounces(a)lists.katipo.co.nz [ mailto:koha-bounces@lists.katipo.co.nz <mailto:koha-bounces@lists.katipo.co.nz> ] On Behalf Of Roche III, Edward Sent: June 24, 2009 1:51 PM To: koha(a)lists.katipo.co.nz Subject: [Koha] Label Creator Barcode Not Appearing I did a test barcode label run and the barcode itself is not created. It gives the barcode number and the title but not the lines. Do I need to install a barcode font? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha Kathleen D. Rippel Dept. Head/Consultant--Resource Sharing and Access ; Pathfinder Central (Manager) Central Kansas Library System 1409 Williams Great Bend, KS 67530 (620-792-4865) phone (800-362-2642) toll-free, KS (620-792-5495) fax kdr(a)ckls.org ******************************************************************************************** I'm currently reading: A Breath of Snow and Ashes, by Diana Gabaldon. I'm currently listening to: Eclipse, by Stephenie Meyer.

1 0

Re: [Koha-devel] Barcode Not Found
by Roche III, Edward 26 Jun '09

26 Jun '09

How is run? Thanks Edward J. Roche III Network Administrator Solanco School District ---------------------------------------------------- Sent using Ed's Crackberry -----Original Message----- From: Joe Atzberger <ohiocore(a)gmail.com> To: Roche III, Edward <edward_roche(a)solanco.k12.pa.us> CC: koha-devel <koha-devel(a)lists.koha.org> Sent: Thu Jun 25 16:17:15 2009 Subject: Re: [Koha-devel] Barcode Not Found You can't run that kind of script from the command line. On Thu, Jun 25, 2009 at 3:43 PM, Roche III, Edward <edward_roche(a)solanco.k12.pa.us> wrote: Has anyone used updateitem.pl script before after importing data into the items table? Whenever I run it displays html instead of any type of progress. Thanks! Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" -----Original Message----- From: Roche III, Edward Sent: Wednesday, June 24, 2009 1:03 PM To: Roche III, Edward; koha-devel Subject: RE: [Koha-devel] Barcode Not Found I updated the fields to include the barcode field in updateitem.pl and saved it as a new file. Now do I run it like I would the other PERL scripts that are used to import a catalog or rebuild zebra because when I do that it shows me HTML code instead of executing the script. Thanks! Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" -----Original Message----- From: koha-devel-bounces(a)lists.koha.org [mailto:koha-devel-bounces@lists.koha.org] On Behalf Of Roche III, Edward Sent: Wednesday, June 24, 2009 11:50 AM To: koha-devel Subject: Re: [Koha-devel] Barcode Not Found Forgot to add the list back on to my response to Mason.... So if I change the lostitem fields to what I need to update and should do it? Thanks! Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" -----Original Message----- From: Mason James [mailto:mason.loves.sushi@gmail.com] Sent: Tuesday, June 23, 2009 5:45 PM To: Roche III, Edward Cc: koha-devel Subject: Re: [Koha-devel] Barcode Not Found On 2009/06/24, at 6:21 AM, Roche III, Edward wrote: > Is this a script that needs to be run? > no, its a subroutine in ./C4/Items.pm, see... http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob;f=C4/ Items.pm;h=6c58365ef0d192d4ee7126823397f3f7fc9c9780;hb=HEAD#l453 > How would you use the C4:Items:ModItems() API? > take a look here for an example of it being used in a script http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob;f=catalogue/ updateitem.pl;h=7b0b673727fe1e55299332a2ff13a1130ebe2f41;hb=HEAD _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel

1 1

How-to describing the installation of MarcEdit under Wine on Linux
by Chris Nighswonger 26 Jun '09

26 Jun '09

FWIW I've hacked up a how-to describing the installation of MarcEdit under Wine on Linux in the Koha wiki: http://wiki.koha.org/doku.php?id=en:record_manipulation:software:how_to:mar… Regards, Chris

2 1