- Koha - lists.katipo.co.nz

bulkmarcimport problems
by Larry Stamm 16 Aug '03

16 Aug '03

Hi All, When trying to import MARC records into Koha using the bulkmarcimport script, about 6% of the records get added to the biblio and biblioitem tables with just the biblionumber and biblioitemnumber incremented, and the rest of the fields being "NULL" (except for the timestamp data). These items are also totally absent from the items table. Random checks indicate that they are not being added correctly to the marc_word table either, although they are entered there. Anybody else noticing this? Below is a listing of a typical MARC record that is missed. Is there something in this cataloguing that is screwing up Perl? I have noticed that a majority of the missing records have "cn" as the first values in the "001" field. ______________________________________________________________________ 001 $ $cn 88094114 008 $ $880426s1988 oncac b 00110 eng d 015 $ a $C88-94114-6 020 $ ac $0385251505 :$$29.95 035 $ a $(WaOLN)4955878 040 $ abcd $CaOTU$eng$CaOTU$CaOONL 043 $ a $n-cn--- 055 00 $ ab $FC176$C64 1988 055 01 $ a $FC176 082 0 $ a2 $001.9/0971$19 100 10 $ ad $Colombo, John Robert,$1936- 245 10 $ abc $Mysterious Canada :$strange sights, extraordinary events, and peculiar places /$John Robert Colombo. 260 0 $ abc $Toronto :$Doubleday Canada,$c1988. 263 $ a $8811 300 $ abc $xii, 436 p. :$ill., ports. ;$26 cm. 500 $ a $Includes index. 504 $ a $Bibliography: p. 420-424. 650 0 $ az $Curiosities and wonders$Canada. 651 0 $ ax $Canada$Miscellanea. 651 0 $ axx $Canada$History$Miscellanea. 650 6 $ az $Curiositâes et merveilles$Canada. 651 6 $ ax $Canada$Miscellanâees. 651 6 $ axx $Canada$Histoire$Miscellanâees. 852 $ phi98 $100022$001.930971$Col$29.95$19960712 ______________________________________________________________________ -- Larry Stamm, Chair McBride and District Public Library McBride, BC V0J 2E0 Canada http://www.mcbridebc.org/library

1 0

Re: [Koha] MARC importing tool? ... trepidatiously into the breach
by baljkas＠mb.sympatico.ca 16 Aug '03

16 Aug '03

Saturday, August 16, 2003 00:53 CDT Howdy, all, At some point in this conversation, Wolfgang (I think) was asking something about MARC and given the beginning part of the subject line, I am wondering if anybody checked out the various to/from MARC conversion tools available off the Library of Congress MARC Tools page at: URL <http://www.loc.gov/marc/marctools.html> Take a look at MARCMakr. You might need to do a two-step dump to regularise the data but it should be able to handle just about anything. I wasn't clear on what info was wanted on MARC. Normally, when dealing with a batch of records in one file (as often with collection exports in migration), the end-of-record delimiter appears in a text editor as two boxes, with the next record's leader and directory starting immediately afterward. Wolfgang, if I misunderstood and you were asking for what delimiters end any given MARC field, you have a huge problem in hand because the variability with even brief records is immense and the delimiting is regulated by position from the directory at the beginning of the MARC record (i.e. get out your calculator, it's gonna be a long night). ------------------------------------------------ On another tangent, if I understood Wolfgang, the bibliographic data from the different contributing libraries/library branches is of what one euphemistically hears called "varying quality." While in the perfect world -- and like the ad currently on in the North American market reminds us, 'Of course, we live nowhere near Perfect' -- everything would come with clear breaks and all the data would be sparkingly perfect, too, most retrospective conversions simply aim to get some version of the data to migrate across, at least in the first pass. I have friends whose whole contract positions were just cleaning up catalogues after system migrations. Wolfgang, you can use global editing tools, outside of Koha, like the MARCEdit one off that same LOC page, to make systematic corrections to your records before importing them into Koha. Or is that not working for some reason? Give it a try if you haven't. You may be able to correct and standardise enough of the records to make a smoother transition. Your library staff should realise, though, with any system migration, there *will* be "interactive" work to be done: i.e. touching up of the records in the new system. This is *normal*. From what I've been reading, people seem to be expecting Koha to eliminate this (even Koha people seem to be aiming pretty high in thinking this can be eliminated). Remember: your cataloguing staff are there for a reason ;-) I hope some of this helps. Just remember, guys: you are doing a great job and people out here DO appreciate it and the beautiful thing you have created in Koha. Pat yourselves on the back. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB CANADA

3 2

Here's my ISBN/MARC tools
by John Voth 16 Aug '03

16 Aug '03

Howdy, You will find a tar.gz file containing my EAN to ISBN converter and my MARC retrieving program here: http://www.voth.ca/bib.php I hope they are useful to others. John

1 0

Re: [Koha] MARC importing tool?
by Stephen Hedges 15 Aug '03

15 Aug '03

John, if your file is in the standard iso2709 MARC format, you can use bulkmarcimport.pl found in the intranet/scripts/misc directory of the MARC version (currently 1.9.x) of Koha. Stephen Hedges Nelsonville Public Library > Howdy! > > I've developed a couple of programs that I have > used to aid me in > populating the library database. > > The first program takes a raw scan of a book's > EAN (ie:9781575212784) > and converts it into the ISBN (ie:1575212781). > > The second program takes a list of ISBN's and > attempts to retrieve the > MARC record for each title from the LoC. > > I have successfully used these two programs to > obtain MARC records on > approximately 4000 titles so far. I think it took > about 40 minutes to > poll the LoC and save all the responses to a > file. > > The only program I need to > find/write/beg/borrow/steal is one that will > take all these MARC records and import them into > KOHA. Is there anything > out there that does this already? > > Regards, > John > > PS: I can make the above mentioned two programs > available if there's > enough interest. > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha >

5 12

LITA national forum
by paul POULAIN 15 Aug '03

15 Aug '03

Hi all, I think the LITA forum can be interesting for readers here playing with Koha. We are a part of "collaborative projects in the digital age" aren't we ? It seems that yes, as I read in the program : http://www.ala.org/Content/NavigationMenu/LITA/LITA_Events_and_Programs/LIT… : *Open Communication for Open Source Software Development: The Koha Experience* /Presenter: / Brenda Chawner, Senior Lecturer, School of Information Management, Victoria University of Wellington Does anyone from Koha project know who is Brenda ??? Does anyone from Koha mailing lists intend to go to forum ? PS : i'm on vacation... now, and be back in Sept, 2. ORIGINAL MAIL posted on PERL4LIB mailing list : ============= 2003 LITA National Forum "Putting Technology Into Practice" is the theme for the sixth annual Library and Information Technology Association (LITA) National Forum, to be held October 2 - 5, 2003 at the Sheraton Norfolk Waterside, Norfolk, VA. Three exciting general sessions anchor the event. R. David Lankes, Executive Director of the Information Institute of Syracuse and Assistant Professor at Syracuse University's School of Information Studies, will speak on the current state of digital reference services. Liz Bishoff, Executive Director of the Colorado Digitization Program, will discuss collaborative projects in the digital age. The closing session features David Seaman, Director of the Digital Library Federation, speaking on major trends in digital libraries. More than 25 concurrent sessions provide a wealth of practical information. Topics include virtual reference consortia, digital library collection management, database-driven websites, metadata standards (including OAI), XML databases, open source portal management, cross-database search projects, managing access to GIS repositories, usability studies, and much more. In addition, for the first time, the 2003 Forum includes poster sessions, presenting unique technology applications that solve specific problems, such as digital rights management in the academic environment, PDA use in health sciences libraries, and link maintenance and repair. Add to the Forum experience with a choice of preconference workshops, a full day on "The Library as a Place in the Digital Age," or a half day on either "Handheld Library Programs: New Levels of Service" or "Creating, Managing, and Using Open Source Software in Libraries." Corporate sponsors of the LITA Forum help to bring the programming and networking opportunities to attendees. We gratefully acknowledge the support of Endeavor Information Systems, Inc., Veicon Technology, Inc., and Swets Blackwell. An opening reception, generously sponsored by Endeavor Information Systems, Inc., will be held in the Grand Promenade of the Sheraton Norfolk Waterside, overlooking the picturesque Norfolk Harbor. Other networking opportunities include Saturday lunch, continental breakfasts and refreshment breaks, as well as Saturday evening dinner groups organized by LITA leaders. Registration is limited to 500. Advance registration closes Friday, September 19 at 2pm CST. Register by August 29, 2003 to save $40! For complete details, visit http://www.lita.org/forum03. LITA is a division of the American Library Association http://www.ala.org ------------------------------------------ Miriam Blake Library Without Walls Los Alamos National Laboratory Research Library Voice: 505-665-5724 Fax: 505-665-6452 http://lib-www.lanl.gov/lww/welcome.html -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

3 2

RE: [Koha] LITA national forum
by Brenda Chawner 15 Aug '03

15 Aug '03

Bonjour Paul, and hello everyone else I'll be going to this, and would be happy to report back on sessions that would be of interest to Koha participants. If anyone else on the list is going, perhaps we can arrange to meet at the conference and have a chat about Koha and open source software in general. Paul asked "who is Brenda?". I am a lecturer in library and information management here in New Zealand, and teach courses in information technology and business information sources. I have been following Koha developments for a while now, and hope to be more involved with the project in the future. Here is the abstract for my presentation at the LITA National Forum 2003: Abstract/Outline: What is involved in managing and participating in a distributed open source software development project? What options are available for organisations that choose to implement open source software? Koha, the world's first open source library management software package, was originally developed for the Horowhenua Library Trust, based in Levin, New Zealand, by Katipo Communications Limited, in Wellington, New Zealand. It was released as open source software under the GPL in 2000, and there are now 27 registered developers (and 84 subscribers to the development discussion list) working on new releases, in New Zealand, Canada, the United States and France, Poland, Germany, Spain, and New Caledonia. The Koha kaitiaki (project manager) is in the state of Washington, USA. Koha is currently being used by libraries in New Zealand, Australia, Canada, France, Italy, and the United States, and people from India, and South America have also expressed interest in it . This session will cover the various Koha participant roles (such as project manager, developer, documenter, user), as well as the range of tools and techniques used by Koha participants to communicate with each other, using a case study approach. These include email discussion lists, IRC, and a wikiwikiweb (or wiki for short), as well as a bug tracking utility. I wrote the abstract quite a while ago, and know that the number of developers and list of countries using Koha are out-of-date - I hope to have these updated for the presentation. I expect that the handouts from the talk will be available on the LITA website following the conference - I'll send the URL to the list when (and if) it's available. You might also be interested in the bibliography of articles and other material about open source software for libraries I have made available at http://www.vuw.ac.nz/staff/brenda_chawner/biblio.html I hope to have an updated version of the bibliography done by the end of September. -- Brenda Chawner School of Information Management Victoria University of Wellington P O Box 600 Wellington NEW ZEALAND (04) 463 5780 fax (04) 463 5446 brenda.chawner(a)vuw.ac.nz

1 0

see you in september
by paul POULAIN 14 Aug '03

14 Aug '03

Hi all, I'm off for 2 weeks. Will be back in september, 2 In a few days, mjr/slef should release a 2.0.0pre3. Take care of it, help fixing a lot of bugs, and see your in September for a 2.0.0rc1 hopefully :-) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

bug 512 in 2.0.0 branch
by paul POULAIN 13 Aug '03

13 Aug '03

Hi all, I've a problem with the bug 512 (http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=512) I don't understand what is the problem, & box4email(a)yahoo.com didn't answer a mail I sended a few days ago. does someone have encountered this bug ? Otherwise, i'll mark it as invalid. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

Re: [Koha] Koha installer defaults ***Partial Solution****
by Robert Maynord 13 Aug '03

13 Aug '03

Hello Koha Folks: I have made some progress. I now have the OPAC working! The solution was to add a second ScriptAlias line to the OPAC part of the httpd2.conf file. The first ScriptAlias points to -- /cgi-bin/opac/ /usr/local/koha/opac/cgi-bin/ The second points to -- /cgi-bin/koha/ /usr/local/koha/opac/cgi-bin/ Without both of these, it doesn't work. The Intranet part of Koha is not yet working for me, but I continue to pursue it... Robert

1 0

Koha installer defaults to different directory than perl scripts?
by Robert Maynord 13 Aug '03

13 Aug '03

Thanks to Paul for the help on httpd configuration. I am now able to load the first Koha page in a browser. However, I am not able to go further into "Log In" "Advanced Search" or "Search the Catalogue". I checked my opac error log, and it says -- "script not found or unable to stat: /var/www/cgi-bin/koha, referer: http://192.168.0.3/cgi-bin/opac/opac-main.pl" I used the Koha defaults during installation, which put everything into /usr/local/koha. There is nothing in var/www.cgi-bin. Should I try to install koha into var/www/koha rather than the default /usr/local/koha? Thanks... Robert

2 1