[Koha] Fwd: Migrating data from 2.2.9 to 3.00.X: item problems solved!

Wed May 5 01:58:13 NZST 2010

Hi again, 
this is just to finally say a big thank you to Koustubha Kale and others for helping us solve our item problems - it worked excellently. We just had to wait a while for our IT-guy to come back and export the altered file! As the solution was sent to me off list I include it in this email for future reference. Thanks again, 

Sincerely, 
Magdalena Söderqvist 
SIPRI Library 

----- Forwarded Message ----- 
From: "Koustubha Kale" <kmkale at anantcorp.com> 
To: "Magdalena Söderqvist" <soderqvist at sipri.org> 
Sent: Tuesday, 20 April, 2010 13:36:09 GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna 
Subject: Re: [Koha] Migrating data from 2.2.9 to 3.00.X: item problems 

Hi, 
Why not keep it on the list? Some one else having same issues may learn.. 

If that's the case I suggest you break the marc file into .MRK using markbreaker in MarcEdit. Then save it as "marc utf-8 text file .mrk8" 

Then use your favorite text editor to correct the errors. ( HINT : You might see two lines for 952 tag in marcedit and your text editor. It needs to be one line with proper subfields) 

Reopen the corrected file with marcedit and compile it into .mrc. Import the new mrc into koha with Stage records.. and Manage staged records etc. Run rebuild db etc... 

Let me ( and koha list ;) ) know how it goes. 

Regards, 
Koustubha Kale 
Anant Corporation 

Contact Details : 
Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), 
Maharashtra, India, Pin : 400601. 
TeleFax : +91-22-21720108, +91-22-21720109 
Mobile : +919820715876 
Website : http://www.anantcorp.com 
Blog : http://www.anantcorp.com/blog/?author=2 

2010/4/20 Magdalena Söderqvist < soderqvist at sipri.org > 

Hi, 
many thanks for your reply. I hope you don't might my writing to you off the list. You were right: looking at the import file in a text program reveals end of line characters within the 952 field. My followup question is: do you have any suggestions as to how to get rid of it? We've been using MarcEdit for other things - could we use that somehow or is there another way/another program? 

Reg the barcodes: yes we can assign new codes, and we will. I was just trying to find a way around editing 2800 records by hand, but that was just pure laziness, nothing else... 

Thanks again, 
Magdalena 
SIPRI library 

----- Forwarded Message ----- 
From: "Koustubha Kale" < kmkale at anantcorp.com > 
To: "Magdalena Söderqvist" < soderqvist at sipri.org > 
Cc: koha at lists.katipo.co.nz 
Sent: Monday, 19 April, 2010 10:41:23 GMT +01:00 Amsterdam / Berlin / Bern / Rome / Stockholm / Vienna 
Subject: Re: [Koha] Migrating data from 2.2.9 to 3.00.X: item problems 

I have come across Problem (1); It happened due to the import file having end of line characters in the middle of records data. 
Please check it carefully, and while doing so, may I suggest you assign a new barcode to the chapters? 

Regards, 
Koustubha Kale 
Anant Corporation 

Contact Details : 
Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), 
Maharashtra, India, Pin : 400601. 
TeleFax : +91-22-21720108, +91-22-21720109 
Mobile : +919820715876 
Website : http://www.anantcorp.com 
Blog : http://www.anantcorp.com/blog/?author=2 

2010/4/19 Magdalena Söderqvist < soderqvist at sipri.org > 

Hi, 
SIPRI library is attempting to migrate catalogue records from 2.2.9 to 3.00.06.008. I know the latest stable release is 3.00.05, but our IT-guy got a little carried away (and then he went on vacation)! The upgrade however solved a major problem with blank record pages in the opac, but we still have some remaining problems we need help solving. Others have reported similar problems but I haven't been able to figure out how their problems were actually solved, hence this appeal. 

Problem 1: 
When importing a normal biblio with only one item to the new version, the one item is split up in two, with Shelf location on one row and Barcode on another. The rest of the item specific information is hidden. If I edit the record and delete one of the items and move the barcode to the remaining item, all the hidden information shows up. 

So the question is, what is wrong? We use 952c for Shelving location and 952p for Barcode. 
Also, we don't use actual barcodes, but instead use the barcode field for our accession numbers, for example G10/123 or 10/124. 

Problem 2: 
We occasionally catalogue chapters as separate biblios, and when doing so, we have used the same barcode/accession no. for each chapter belonging to the same book. It worked fine in 2.2.9, but since 3.0.x does not seem to accept duplicate barcodes this has now become a problem. Would it be possible/complicated/stupid? to alter the bulcmarcimport.pl to make it allow import of biblios with duplicate barcodes? Is there a better solution? 

Any help you can offer is much appreciated. Sincerely, 
Magdalena Söderqvist, Librarian 
SIPRI Library (Stockholm, Sweden) 

******************************************* 

System details: 

New Koha version: 3.00.06.008 

Apache Server version: Apache/2.2.3 Server built: Mar 27 2010 13:52:09 
MySQL mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline 5.1 
OS Linux db1.sipri.org 2.6.18-164.15.1.el5xen #1 SMP Wed Mar 17 12:04:23 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux 
Perl 5.008008 
************** 

Old Koha version: 2.2.9 

OS version ('uname -a') Linux koha.sipri.org 2.6.18-8.el5xen #1 SMP Fri Jan 26 14:29:35 EST 2007 x86_64 x86_64 x86_64 GNU/Linux 

Perl version 5.008008 

MySQL version mysql Ver 14.7 Distrib 4.1.22, for unknown-linux-gnu (x86_64) using readline 4.3 

Apache version Server version: Apache/2.2.3 Server built: Nov 29 2006 06:33:27 

_______________________________________________ 
Koha mailing list 
Koha at lists.katipo.co.nz 
http://lists.katipo.co.nz/mailman/listinfo/koha 

-- 
***************************** 
Magdalena Söderqvist 
Librarian 

SIPRI Library and Documentation 
Signalistgatan 9 
SE-169 70 SOLNA 

Telephone: +46 8 655 97 78 
Fax: +46 8 655 97 33 
E-mail: soderqvist at sipri.org 
***************************** 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100504/49e4d870/attachment-0001.htm 