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

Bulk Marc Import via the Web
by Rick Welykochy 28 Apr '10

28 Apr '10

Hi all I am discussing the possibility of wrapping the bulkmarcimport.pl script in a web page with Bob Birchall. The page would offer a form that contains the command line options as checkboxes or textboxes as appopriate along with a file input control to upload a .MRC file. Upon completion of the form, the web page validates the .MRC as far as that is possible (hints anyone?) and then passes it on to bulkmarcimport.pl. The output from the script is captured and sent back to the the web user. Seems simple enough. The only problem I imagine encountering is the web browser timing out for an import that takes a long time. Any advice and observations from the developers is most welcome. cheers rickw -- _________________________________ Rick Welykochy || Praxis Services Politics is the business of getting power and privilege without possessing merit. -- PJ O'Rourke

8 13

Some CPAN modules Koha needs in Debian now
by Lars Wirzenius 27 Apr '10

27 Apr '10

This might be a nice small bit of good news to start the week. Debian squeeze has most of the CPAN modules Koha needs, but five were missing. I made packages for them and got them uploaded into Debian. They last of them has just this weekend gotten through the NEW queue, which is where new Debian packages wait for the Debian ftp-master to check them. Right now, all five packages are only in Debian unstable (a.k.a. sid), but if there are no bugs found, they should land in Debian squeeze in about ten days, I hope. If you wish, you can check their current status in Debian via the following page: http://qa.debian.org/developer.php?login=lars% 40catalyst.net.nz&comaint=yes When it lists a version for "Testing", then the package is in squeeze (squeeze being the current development/testing version of Debian). There is a reasonable chance that Koha will install and work on Debian squeeze out of the box, without any additional software to be installed. Note that I do not yet know if everything required to actually run all parts of Koha are there yet, but Koha does pass the automatic test suite with these packages installed.

3 3

Modifying biblio data with SQL
by Rick Welykochy 27 Apr '10

27 Apr '10

Hi all, We wish to make some minor tweaks to biblio data that was imported originally using bulkmarcimport.pl. I understand where the data resides in the biblio,biblioitems,items table trio and can do the fix with some SQL. My question regards the other place the data is stored, i.e. in the marcxml field in the bibioitems table. Should I make the same changes to the marcxml data that I make in the table trio? If so, why? tia rickw -- _________________________________ Rick Welykochy || Praxis Services Politics is the business of getting power and privilege without possessing merit. -- PJ O'Rourke

3 2

git.koha-community.org hosting
by Brendan Gallagher 24 Apr '10

24 Apr '10

Hello All - I've recently realized that there isn't a git.koha-community.org site for hosting code. I'm am proposing that ByWater Solutions provide server space for hosting a git repo with an address of git.koha-community.org The main control and configuration will be managed by the koha-community.org Release Managers, Release Maintainers, and Translation Managers and anybody else designated to push patches. We will gladly take all help and recommendations for configuration, appropriate security, and access rights for all involved. The manner in which we plan on hosting git - is access for all. All those interested in helping please contact myself or Ian Walls ( ian.walls(a)bywatersolutions.com ) and of course please make sure to post comments here in the mail-list so that we can all follow along. IRC is also great too. A preview of the webspace is here --> http://git.koha-community.org Thanks, Brendan As a side note, if and when this is fine with everyone, we will wait for the Release Managers to let us know when to start pulling and cloning. The site is still being tested by the Release Managers. --------------------------------------------------------------------------------------------------------------- Brendan A. Gallagher ByWater Solutions CEO, Director of Innovation Support and Consulting for Open Source Software Installation, Data Migration, Training, Customization, Hosting and Complete Support Packages Headquarters: Santa Barbara, CA - Office: West Haven, CT Phone # (888) 900-8944 http://bywatersolutions.com info(a)bywatersolutions.com ---------------------------------------------------------------------------------------------------------------

3 2

Re: [Koha-devel] [Koha] Installation of Koha on centOS
by Waylon Robertson 24 Apr '10

24 Apr '10

I myself failed to install koha on Centos 5. it came with a libxml library that was incompatible with the libXML perl module. And downgrading would of been a headache. So, i switched to debian, and to make up time, got someone else to install it. ----- Original Message ---- From: "bariki.kamara(a)out.ac.tz" <bariki.kamara(a)out.ac.tz> To: koha(a)lists.katipo.co.nz Sent: Fri, 23 April, 2010 9:59:45 PM Subject: [Koha] Installation of Koha on centOS Hi, Am trying to install perl modules, but i got the following error message; cpan> install Tk Running install for module Tk Running make for S/SR/SREZIC/Tk-804.028.tar.gz Is already unwrapped into directory /root/.cpan/build/Tk-804.028 Makefile.PL returned status 512 Running make test Make had some problems, maybe interrupted? Won't test Running make install Make had some problems, maybe interrupted? Won't install cpan> install Curses Running install for module Curses Running make for G/GI/GIRAFFED/Curses-1.28.tgz Is already unwrapped into directory /root/.cpan/build/Curses-1.28 Has already been processed within this session Running make test Can't test without successful make Running make install make had returned bad status, install seems impossible cpan> install PDF::API2 Running install for module PDF::API2 Running make for A/AR/AREIBENS/PDF-API2-0.73.tar.gz Checksum mismatch for distribution file. Please investigate. Distribution id = A/AR/AREIBENS/PDF-API2-0.73.tar.gz CPAN_USERID AREIBENS (Alfred Reibenschuh <alfredreibenschuh(a)gmx.net>) CALLED_FOR PDF::API2 CONTAINSMODS PDF::API2::Resource::Font::CoreFont::timesbolditalic PDF::API2::Basic::PDF::Utils PDF::API2::Resource::Font::neTrueType PDF::API2::Resource::Font::CoreFont::courier PDF::API2::NamedDestination PDF::API2::Resource::Font::CoreFont::trebuchetbolditalic PDF::API2::Basic::TTF::Kern::ClassArray PDF::API2::Basic::TTF::XMLparse PDF::API2::UniWrap PDF::API2::Resource::XObject::Form::BarCode PDF::API2::Resource::Font::CoreFont::webdings PDF::API2::Resource::Font::BdFont PDF::API2::Content PDF::API2::Resource::Font::CoreFont::helveticabold PDF::API2::Resource::ColorSpace::Indexed PDF::API2::Resource::Font::CoreFont::georgia PDF::API2::Basic::TTF::Glyf PDF::API2::Basic::TTF::Vhea PDF::API2::Version PDF::API2::Basic::TTF::Mort::Ligature PDF::API2::Resource::ColorSpace::Indexed::Hue PDF::API2::Matrix PDF::API2::Basic::TTF::PCLT PDF::API2::Resource::XObject::Image::PNG PDF::API2::Basic::TTF::Bsln PDF::API2::Resource::XObject::Form::BarCode::codabar PDF::API2::Resource::UniFont PDF::API2::Basic::TTF::AATutils PDF::API2::Basic::PDF::Page PDF::API2::Basic::TTF::Delta PDF::API2::Resource::Font::CoreFont::verdana PDF::API2::Resource::CIDFont::CJKFont PDF::API2::Basic::TTF::Mort::Chain PDF::API2::Resource::Font::CoreFont::helveticaoblique PDF::API2::Basic::TTF::Kern::Subtable PDF::API2::Resource::Shading PDF::API2::Basic::PDF::File PDF::API2::Annotation PDF::API2::Basic::TTF::Post PDF::API2::Resource::XObject::Form::BarCode::code128 PDF::API2::Basic::TTF::Hdmx PDF::API2::Resource::XObject::Image::PNM PDF::API2::Basic::TTF::Head PDF::API2::Basic::TTF::Fdsc PDF::API2::Basic::TTF::LTSH PDF::API2::Basic::TTF::OldMort PDF::API2::Basic::TTF::Glyph PDF::API2::Basic::TTF::Prop PDF::API2::Resource::XObject::Image PDF::API2::Basic::TTF::GDEF PDF::API2::Resource::Font::CoreFont::verdanabolditalic PDF::API2::Resource::Font PDF::API2::Basic::TTF::Kern PDF::API2::Resource::Font::Postscript PDF::API2::Basic::PDF::String PDF::API2::Resource::Font::CoreFont::timesitalic PDF::API2::Basic::TTF::Kern::CompactClassArray PDF::API2::Basic::PDF::Objind PDF::API2::Basic::TTF::Mort::Insertion PDF::API2::Resource::Font::CoreFont::helveticaboldoblique PDF::API2::Resource::CIDFont::TrueType::FontFile PDF::API2::Basic::TTF::Mort::Contextual PDF::API2::Resource::Font::CoreFont::courierbold PDF::API2::Resource::Font::CoreFont::trebuchetbold PDF::API2::Win32 PDF::API2::Resource::Font::SynFont PDF::API2::Resource::Font::CoreFont::zapfdingbats PDF::API2::Resource::ColorSpace::DeviceN PDF::API2::Resource::Font::CoreFont::trebuchetitalic PDF::API2::Resource PDF::API2::Resource::XObject::Form PDF::API2::Basic::TTF::Vmtx PDF::API2::Resource::Font::CoreFont::georgiabolditalic PDF::API2::Basic::TTF::Kern::OrderedList PDF::API2::Resource::Font::CoreFont::timesroman PDF::API2::Basic::TTF::Mort::Subtable PDF::API2::Basic::TTF::Cmap PDF::API2::Basic::TTF::Fmtx PDF::API2::Resource::Font::CoreFont PDF::API2::Basic::PDF::Bool PDF::API2 PDF::API2::Basic::PDF::Literal PDF::API2::Resource::CIDFont::TrueType PDF::API2::Resource::XObject::Form::BarCode::code3of9 PDF::API2::Basic::TTF::Kern::StateTable PDF::API2::Basic::TTF::Loca PDF::API2::Content::Text PDF::API2::Resource::XObject::Image::JPEG PDF::API2::Basic::TTF::Win32 PDF::API2::Outlines PDF::API2::Resource::ColorSpace PDF::API2::Basic::TTF::Mort PDF::API2::Basic::PDF::Filter PDF::API2::Resource::Font::CoreFont::symbol PDF::API2::Resource::ExtGState PDF::API2::Resource::Font::CoreFont::georgiaitalic PDF::API2::Basic::PDF::Array PDF::API2::Resource::Font::CoreFont::verdanaitalic PDF::API2::Basic::TTF::GPOS PDF::API2::Basic::TTF::Maxp PDF::API2::Basic::TTF::Anchor PDF::API2::Resource::BaseFont PDF::API2::Resource::XObject::Form::BarCode::int2of5 PDF::API2::Basic::TTF::Name PDF::API2::Resource::XObject::Image::GIF PDF::API2::Outline PDF::API2::Resource::Font::CoreFont::georgiabold PDF::API2::Resource::XObject PDF::API2::Util PDF::API2::Basic::TTF::Ttopen PDF::API2::Basic::TTF::Mort::Rearrangement PDF::API2::Resource::Font::CoreFont::timesbold PDF::API2::Basic::TTF::Mort::Noncontextual PDF::API2::Lite PDF::API2::Basic::TTF::Hhea PDF::API2::Resource::Font::CoreFont::verdanabold PDF::API2::Basic::PDF::Null PDF::API2::Basic::TTF::OS_2 PDF::API2::Basic::TTF::PSNames PDF::API2::Basic::TTF::GSUB PDF::API2::Basic::TTF::AATKern PDF::API2::Resource::Font::CoreFont::courieroblique PDF::API2::Resource::XObject::Image::GD PDF::API2::Basic::TTF::Hmtx PDF::API2::Basic::TTF::Utils PDF::API2::Resource::XObject::Form::Hybrid PDF::API2::Resource::ColorSpace::Indexed::ACTFile PDF::API2::Resource::XObject::Image::TIFF PDF::API2::Basic::PDF::Name PDF::API2::Basic::TTF::Prep PDF::API2::Resource::Font::CoreFont::helvetica PDF::API2::Basic::PDF::Pages PDF::API2::Resource::Font::CoreFont::trebuchet PDF::API2::Page PDF::API2::Basic::TTF::Table PDF::API2::Basic::TTF::Ttc PDF::API2::Basic::TTF::OldCmap PDF::API2::Resource::Font::CoreFont::courierboldoblique PDF::API2::Resource::XObject::Form::BarCode::ean13 PDF::API2::Basic::TTF::Cvt_ PDF::API2::Basic::PDF::Dict PDF::API2::Basic::TTF::Font PDF::API2::Basic::TTF::Feat PDF::API2::Basic::TTF::Coverage PDF::API2::Resource::Pattern PDF::API2::Resource::Font::CoreFont::wingdings PDF::API2::Resource::ColorSpace::Separation PDF::API2::Resource::Font::CoreFont::bankgothic PDF::API2::Resource::ColorSpace::Indexed::WebColor PDF::API2::Basic::PDF::Number PDF::API2::Basic::TTF::Fpgm PDF::API2::Basic::TTF::Segarr PDF::API2::Resource::CIDFont MD5_STATUS force_update 2 incommandcolor 1 localfile /root/.cpan/sources/authors/id/A/AR/AREIBENS/PDF-API2-0.73.tar.gz I'd recommend removing /root/.cpan/sources/authors/id/A/AR/AREIBENS/PDF-API2-0.73.tar.gz. Its MD5 checksum is incorrect. Maybe you have configured your 'urllist' with a bad URL. Please check this array with 'o conf urllist', and retry. cpan> install File::Basename Running install for module File::Basename Running make for J/JE/JESSE/perl-5.12.0.tar.bz2 Checksum for /root/.cpan/sources/authors/id/J/JE/JESSE/perl-5.12.0.tar.bz2 ok Use of uninitialized value in string eq at /usr/lib/perl5/5.8.8/CPAN.pm line 4469. Is neither a tar nor a zip archive. Running make test Make had some problems, maybe interrupted? Won't test Has no own directory Running make install Has no own directory Make had some problems, maybe interrupted? Won't install cpan> install install GD Running install for module install Running make for D/DA/DAGOLDEN/install-0.01.tar.gz Fetching with LWP: ftp://ftp.is.co.za/pub/cpan/authors/id/D/DA/DAGOLDEN/install-0.01.tar.gz Checksum for /root/.cpan/sources/authors/id/D/DA/DAGOLDEN/install-0.01.tar.gz ok install-0.01/ install-0.01/t/ install-0.01/t/install.t install-0.01/MANIFEST install-0.01/lib/ install-0.01/lib/install.pm install-0.01/Changes install-0.01/README install-0.01/Makefile.PL install-0.01/META.yml CPAN.pm: Going to build D/DA/DAGOLDEN/install-0.01.tar.gz Checking if your kit is complete... Looks good Writing Makefile for install cp lib/install.pm blib/lib/install.pm Manifying blib/man3/install.3pm /usr/bin/make -- OK Running make test PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/install.t .. ok All tests successful. Files=1, Tests=1, 0 wallclock secs ( 0.02 usr 0.00 sys + 0.01 cusr 0.02 csys = 0.05 CPU) Result: PASS /usr/bin/make test -- OK Running make install Manifying blib/man3/install.3pm Installing /usr/lib/perl5/site_perl/5.8.8/install.pm Installing /usr/share/man/man3/install.3pm Appending installation info to /usr/lib/perl5/5.8.8/i386-linux-thread-multi/perllocal.pod /usr/bin/make install -- OK Running install for module GD Running make for L/LD/LDS/GD-2.44.tar.gz Checksum for /root/.cpan/sources/authors/id/L/LD/LDS/GD-2.44.tar.gz ok GD-2.44/ GD-2.44/t/ GD-2.44/t/test.out.3.jpeg GD-2.44/t/GD.t GD-2.44/t/tile.jpeg GD-2.44/t/test.out.4.jpeg GD-2.44/t/test.out.5.jpeg GD-2.44/t/test.out.6.jpeg GD-2.44/t/test.out.7.jpeg GD-2.44/t/test.out.8.jpeg GD-2.44/t/test.out.9.jpeg GD-2.44/t/test.out.3.png-1 GD-2.44/t/Polyline.t GD-2.44/t/test.out.4.png-1 GD-2.44/t/test.out.4.png-2 GD-2.44/t/test.out.10.png-1 GD-2.44/t/test.out.10.png-2 GD-2.44/t/test.out.10.png-3 GD-2.44/t/test.out.1.png GD-2.44/t/test.out.2.gif GD-2.44/t/test.out.2.png GD-2.44/t/test.out.3.gif GD-2.44/t/test.out.3.png GD-2.44/t/test.out.4.gif GD-2.44/t/test.out.4.png GD-2.44/t/test.out.5.gif GD-2.44/t/test.out.5.png GD-2.44/t/test.out.6.gif GD-2.44/t/test.out.6.png GD-2.44/t/test.out.7.gif GD-2.44/t/test.out.7.png GD-2.44/t/test.out.8.gif GD-2.44/t/test.out.8.png GD-2.44/t/test.out.9.gif GD-2.44/t/test.out.9.png GD-2.44/t/test.out.5.png-1 GD-2.44/t/Generic.ttf GD-2.44/t/test.out.6.png-1 GD-2.44/t/test.out.7.png-1 GD-2.44/t/frog.jpg GD-2.44/t/frog.xpm GD-2.44/t/test.out.10.jpeg GD-2.44/t/test.out.8.png-1 GD-2.44/t/test.out.8.png-2 GD-2.44/t/test.out.8.png-3 GD-2.44/t/test.out.8.png-4 GD-2.44/t/test.out.8.png-5 GD-2.44/t/test.out.8.png-6 GD-2.44/t/tile.gif GD-2.44/t/tile.png GD-2.44/t/test.out.2.png-1 GD-2.44/t/test.out.9.png-1 GD-2.44/t/test.out.9.png-2 GD-2.44/t/palettemap.png GD-2.44/t/test.out.10.gif GD-2.44/t/test.out.10.png GD-2.44/t/test.out.2.jpeg GD-2.44/GD/ GD-2.44/GD/Group.pm GD-2.44/GD/Polygon.pm GD-2.44/GD/Simple.pm GD-2.44/GD/Image.pm.PLS GD-2.44/GD/Polyline.pm GD-2.44/GD.pm GD-2.44/GD.xs GD-2.44/demos/ GD-2.44/demos/brushes.pl GD-2.44/demos/font_list.png GD-2.44/demos/fonttest GD-2.44/demos/polys.pl GD-2.44/demos/fills.pl GD-2.44/demos/truetype_test GD-2.44/demos/shapes.pl GD-2.44/demos/copies.pl GD-2.44/demos/ttf.pl GD-2.44/demos/gd_example.cgi GD-2.44/demos/tile.png GD-2.44/demos/polyline.pl GD-2.44/demos/transform.pl GD-2.44/qd.pl GD-2.44/README GD-2.44/Makefile.PL GD-2.44/README.QUICKDRAW GD-2.44/META.yml GD-2.44/typemap GD-2.44/bdf_scripts/ GD-2.44/bdf_scripts/README GD-2.44/bdf_scripts/bdf2gdfont.PLS GD-2.44/bdf_scripts/bdftogd GD-2.44/bdf_scripts/bdf2gdfont.pl GD-2.44/README.unix GD-2.44/ChangeLog GD-2.44/MANIFEST Removing previously used /root/.cpan/build/GD-2.44 CPAN.pm: Going to build L/LD/LDS/GD-2.44.tar.gz Notice: Type perl Makefile.PL -h for command-line option summary. **UNRECOVERABLE ERROR** Could not find gdlib-config in the search path. Please install libgd 2.0.28 or higher. If you want to try to compile anyway, please rerun this script with the option --ignore_missing_gd. Running make test Make had some problems, maybe interrupted? Won't test Running make install Make had some problems, maybe interrupted? Won't install ---------------------- CONFIDENTIALITY NOTICE -------------------------------- PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL This email is intended only for the person to whom it is addressed and may contain confidential information and may be legally privileged. If you are not the intended recipient, you are notified that you may not use, distribute or copy this document in any manner whatsoever. Kindly also notify the sender by email and/or delete this e-mail. Any views or opinions expressed in this e-mail are those of the sender and do not necessarily coincide with those of the Open University of Tanzania. --------------------THE OPEN UNIVERSITY OF TANZANIA-------------------------- _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Catalog Items Don't Appear in OPAC Search
by Richard Forristall 23 Apr '10

23 Apr '10

Good day everyone, Our librarian is having trouble with the OPAC search. When a student searches for books that we know are in the database, some will not appear in the results list. Yet, if we go into the staff client and do a checkout, we can find the catalog item. At first thought, it would seem the catalog item is not getting into the zebra index so the search doesn't find it. Does Koha automatically do a zebra index when catalog items are added? Is there a setting in the Koha admin that has to be set? In OPAC, when we search for a book we don't see it in the results list. In staff client: When we want to check out the book (the library uses a barcode scanner to find the book): The book is then found and we can check it out. The impact is the student can't find some books for the work they need to complete. So only if a student happens to see the book on the shelf can he/she check it out. Thanks in advance for any/all assistance. Thanks, Rick ------------------------------------------- Rick Forristall Programmer Analyst Goodwill of Central AZ 602.535.4078 ------------------------------------------- Through your generous material and cash donations - we provide free human services programs that create hope, jobs and sustainability for central Arizonans. In 2009 your donations transformed 25,000 lives. Good Stuff. Good Work. Goodwill. We Put People to Work! A 2009 Best Places to Work Winner www.goodwillaz.org <file:///C:/Documents%20and%20Settings/cstewart/Application%20Data/Micro soft/Signatures/www.goodwillaz.org>

5 17

Re: [Koha-devel] new module to send mails
by Zeno Tajoli 22 Apr '10

22 Apr '10

Dear Miguel, At 17.15 08/03/2010, Miguel Angel Calvo Lázaro wrote: >We have commited a new module C4::Mail to send >emails with Mail::Sender. Those emails can be >sent in html format. We provide a new html >editor to edit the letters. In this new editor >now we use a new marks to delimit the fields >that will be included in the letter. Instead of ><<>> we now use [], because the first ones have conflicts with html editors. i think is a good develop. I underline the option of use external SMTP server. Now you need an SMTP on your localhost, as I know. I suggest: -- Translate all comments in english -- Send patch to install the new module with apt-get (I think that the package is libmail-sender-perl) -- See all the place where Mail::Sendmail is used and use instead Mail::Sender or C4::Mail. It is a problem to have 2 perl modules on the same topic. Bye Zeno Tajoli Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)

5 6

Test Email Page
by Rick Welykochy 21 Apr '10

21 Apr '10

Hi all, There is a thread on the Koha list, which repeatedly comes up, about email not working out of Koha. How about an Email Test page in the Admin area? I'm willing to write such a page. Before doing that, I'd like any ideas developers have about such a thing. And I'd like some details on how email works in Koha "from the horses' mouth". cheers rickw -- _________________________________ Rick Welykochy || Praxis Services Politics is the business of getting power and privilege without possessing merit. -- PJ O'Rourke

3 5

Import MARC data(chinese), I see messy code.
by messagesky 21 Apr '10

21 Apr '10

Hi! I import MARC data(Chiness) that was added in attachments(test.mar). Login in by Admin. Use "Tool"-->"MARC Import(staging) ". I check MARC data in "Tool"-->MARC Import(manageing batches). I see messy code. Just like attachments:(messy code.jpg ) Please give me a hand! Thanks. messagesky

3 2

Re-Call for Proposals for KohaCon10
by Nicole Engard 20 Apr '10

20 Apr '10

Hi all, Just a reminder that the official call for proposals (https://spreadsheets.google.com/viewform?formkey=dGJjUWtHMTE2X0J0Vm5ENXlaSn…) for KohaCon10 (http://kohacon.appspot.com/) has been made. If you’re joining us in NZ in October, please think about sharing your Koha knowledge, tips, and ideas with us! Submit as many proposals (https://spreadsheets.google.com/viewform?formkey=dGJjUWtHMTE2X0J0Vm5ENXlaSn…) as you want (I think I gave 5 talks at KohaCon09). Thanks a bunch, Nicole C. Engard KohaCon10 Program Coordinator

3 2