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@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Walls, Ian Sent: Tuesday, October 27, 2009 12:35 PM To: 'bradtke.e@googlemail.com'; koha@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@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of bradtke.e@googlemail.com Sent: Tuesday, October 27, 2009 11:48 AM To: koha@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.