[Koha] Question about Migration of data to Koha

Wed Oct 28 08:04:51 NZDT 2009

Hello,

We just purchased Koha Express, and I am trying to discover the best way
of migrating our 6,000 records from a program called LiBRARYSOFT to
Koha.  I wanted to describe the steps I've been taking and ask if this
is the best possible way to go.  I'd also very much like to see examples
of a file that has been uploaded successful from another program to
Koha.  What did it look like?

LiBRARYSOFT's MARC-record report looks like this (except it is much
longer).  The fields are tab delimited.  There seems to be no way to
indicate an empty field, so the Excel columns do not line up
automatically: a lot of shifting is going on.

004590000000001690000000010001700000020001500017100002200032245005300054
260001500107300003300122520004500155590000900200650001100209852002400220
949002900244949001600273   a0307278069 :      a2007037139 aBoxer, Sarah,
ed.      aUltimate blogs : masterworks from the wild Web /      aNew
York : axxii, 343 p. : ill. ; 21 cm. a'A Vintage Books original.'--T.p.
verso.      aBOOK aBlogs.     81/20/2009_914.95_t1    aAC5 .U45
2008_i000051144     lVine Street__

004730000000001810000000010001700000020001500017100002000032245004900052
260001500101300002700116590000900143650003400152650002900186650001200215
852002000227949002800247949001600275      a0307263584 :     a2005044709
aRemnick, David.  aReporting :   writings from The New Yorker /    aNew
York : axii, 483 p. ;   25 cm. aBOOK aJournalism  -  United States.
aReporters and reporting.     aEssays.    86/13/2009_90_t1  aAC8  .R453
2006_i300000      lVine Street__

004190000000001450000000010001500000020001500015245004000030260001800070
300006500088520002700153650003000180852002000210949003200230949001100262
a085229929X a2004566204 aEncyclopedia Britannica 2003 CD ROM  aChicago,
IL :    a2 CD-ROMs : sd., col. ; 4 3/4 in. + 1 insert (8 p. ; 12 cm.)
aTitle from disc label. aElectronic encyclopedias.    87/16/2008_90_t1
aAE5 [2004 01264]_i000050454 lDayton__

004630000000001570000000010001700000100002700017245007000044250004500114
260001500159300003100174590000900205650002700214852002000241949003100261
949001300292   a0060924322 :     aFeldman, David, 1950 -     aWhen did
wild poodles roam the earth? : an ImponderablesTM book /      a1st
HaperPerennial ed.Questions and answ aNew York : axx, 297 p. : ill. ; 21
cm.      aBOOK aQuestions and answers. 88/13/2009_90_t1  aAG 195 .F4
1993_i030000583      lFranklin__

004530000000001570000000010001900000100002300019245008000042260001500122
300002400137590000900161650002900170650002800199852002400227949003300251
949001100284   a100760779538 :   aFloyd, E. Randall. aThe world's 100
greatest mysteries : strange secrets of the past revealed /      aNew
York : aix, 305 p. ; 21 cm.    aBOOK aCuriosities and wonders.
aHistory -- Miscellanea.      85/28/2008_916.95_t1    aAG 243 .F69
2000._i000028181 lDayton__

I've uploaded this into an Excel file, running the text-to-column
command.  Right now, I'm cleaning up the Excel file to make sure that
each field and subfield is in a separate column.  My expectation is that
at a certain point I'll be able upload my Excel file to MarcEdit and
translate that .xls file in to a .mrc file.

Does this seem like a reasonable course of action, or can you suggest
better (and especially faster ways).  I'd prefer to do the work myself
if at all possible.

I'm sorry if I'm asking a question that's been asked before-I browsed
the archives but perhaps not as thoroughly as I might have. 

Laurie

Laurie Henry, MFA, MSLS

Regional Librarian

Southwestern College Library

Florence - Cincinnati - Franklin - Dayton - Toledo 

________________________________

From: koha-bounces at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Walls, Ian
Sent: Tuesday, October 27, 2009 12:35 PM
To: 'bradtke.e at googlemail.com'; koha at lists.katipo.co.nz
Subject: Re: [Koha] 773 and 774 fields not displaying in ISBD

Elaine,

Have you looked at the ISBD system preference?  It contains the layout
of which MARC tags/subfields get displayed in which order/layout.

My library is also looking at using MARC 21 77X for analyzing entries
(we get a lot of serials issues that are also monographs).  We'll
probably be writing some code for it; that probably doesn't do you any
good right now, but know that you're not alone in wanting to do this
kind of thing.

Cheers,

Ian Walls

Systems Integration Librarian

NYU Health Sciences Libraries

550 First Ave., New York, NY 10016

(212) 263-8687

From: koha-bounces at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of
bradtke.e at googlemail.com
Sent: Tuesday, October 27, 2009 11:48 AM
To: koha at lists.katipo.co.nz
Subject: [Koha] 773 and 774 fields not displaying in ISBD

Hello
I'm in the process of testing Koha to see if it will work for our small
and very quirky library.
We have always catalogued things like individual papers in conference
proceedings and articles in serials so we have a non-MARC database chock
full of analytical entries that we don't want to loose in the
conversion.

I understand where they need to go in MARC 21 - fields 773 and 774 are
going to get a lot of use.
However, try as I might I can't get these fields to display in the ISBD
view (or the normal view for that matter).
I have gone into the MARC structure and edited the subfield constraints
(to 'hidden 0'), so they show up in cataloguing mode.
But I can't seem to get them to show outside of the MARC view. 

I was kind of hoping I wouldn't have to do a detailed 505 if I could
just list all the authors and paper titles in 774. But if it won't
display, it's not much use to the end user.
Thanks for any advice, I did trawl through the archives which is how I
got as far as I did!

Elaine

------------------------------------------------------------
This email message, including any attachments, is for the sole use of
the intended recipient(s) and may contain information that is
proprietary, confidential, and exempt from disclosure under applicable
law. Any unauthorized review, use, disclosure, or distribution is
prohibited. If you have received this email in error please notify the
sender by return email and delete the original message. Please note, the
recipient should check this email and any attachments for the presence
of viruses. The organization accepts no liability for any damage caused
by any virus transmitted by this email.
================================= 

This transmission may contain information that is privileged, confidential, and/or exempt from disclosure under applicable law.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED.  If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format.  Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20091027/0a6a2550/attachment-0001.htm 