[Koha] Upgrading from Koha 2.2.x to Koha 3.0

[Vimal Kumar]

Dear Friends,

See the method I tried to upgrade Koha 2.2.x to Koha 3.x.

I extorted bibliographic details as CSV format from database using SQL
query trough PhpMyAdmin.
Then converted CSV file to MARC 21 using MarcEdit software.
I imported marc records in Koha 3.x version.

In the same way,  I exported patron details and imported in new koha
installation

But,  I missed old transaction details.

But I could retrieve most of the data using above mentioned way.

Here is the SQL script, after necessary changes you can make use this for
your purpose,

items.barcode,items.dateaccessioned,items.itemcallnumber,biblioitems.isbn,biblio.author,biblio.title,biblioitems.pages,biblioitems.publishercode,biblioitems.place,biblio.copyrightdate

FROM items
LEFT JOIN biblioitems ON
(items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
ORDER BY items.barcode ASC

Regards,

-- 
Vimal Kumar V.
Mahatma Gandhi University Library
Kottayam, Kerala- 686 560
Web: www.vimalkumar.org
Blog: http://vimalkumar.oksociety.in http://linuxhalwa.blogspot.com
---------------------------------------------------------------------------
"I forget what I was taught. I only remember what I have learnt"
-Patrick White
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20110810/87c0df83/attachment.html>