Importing Marc records from Koha 2.2.9 into 3.14.05
Hello! I have been unsuccessfully trying to export records from Koha 2.2.9 by going to Marc Biblio Export; selecting a call number range, clicking export and saving the file in notepad (not sure what program to use). The resulting file has a .mrc extension so I am presuming it is a Marc file, there is also data there. However, when I try to import it into version 3.14.05 it isn't being recognised. The steps I am following in version 3.14.05 are as follows: * Stage MARC records for Import * Select the file (koha.mrc) * Upload file The screen then briefly flashes 0% loading and then disappears. In Staged MARC management there is then no data. Any thoughts?? Thanks Liz
It might prove useful to look at the records in MarcEdit first - http://marcedit.reeset.net/ to look at your download to check that it is what you expect. It will also validate the MARC which could help you spot a problem. I export and import files all the time into 3.14 and as long as the MARC is valid it works. I don't know if saving it in notepad is causing a problem, but MARC is not plain text. To use your .mrc file in MarcEdit, you have to 'break' it into human readable text. The tutorials are helpful - http://marcedit.reeset.net/tutorials On Tue, May 13, 2014 at 2:00 AM, Elizabeth Wilcox <ewilcox@metier3.com.au>wrote:
Hello!
I have been unsuccessfully trying to export records from Koha 2.2.9 by going to Marc Biblio Export; selecting a call number range, clicking export and saving the file in notepad (not sure what program to use). The resulting file has a .mrc extension so I am presuming it is a Marc file, there is also data there. However, when I try to import it into version 3.14.05 it isn't being recognised.
The steps I am following in version 3.14.05 are as follows:
* Stage MARC records for Import
* Select the file (koha.mrc)
* Upload file The screen then briefly flashes 0% loading and then disappears. In Staged MARC management there is then no data.
Any thoughts?? Thanks Liz _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
There is documentation on how to export and import records from versions prior to 3.2. Usually the data is dumped via mysqldump to a file, then a 3.2 conversion is run on it, and then it is imported into 3.14. I am running Koha 3.0 and I have tried unsucessfully to export data from 3.0, convert it to 3.2 and then import it into Koha 3.14 but it might be because of some issue only with my database. I'm seeking a 12 step program to help with this issue (smile). I will search for the documentation and forward it to you (the whole process). Phillip
From: ewilcox@metier3.com.au To: koha@lists.katipo.co.nz Date: Tue, 13 May 2014 01:00:31 +0000 Subject: [Koha] Importing Marc records from Koha 2.2.9 into 3.14.05
Hello!
I have been unsuccessfully trying to export records from Koha 2.2.9 by going to Marc Biblio Export; selecting a call number range, clicking export and saving the file in notepad (not sure what program to use). The resulting file has a .mrc extension so I am presuming it is a Marc file, there is also data there. However, when I try to import it into version 3.14.05 it isn't being recognised.
The steps I am following in version 3.14.05 are as follows:
* Stage MARC records for Import
* Select the file (koha.mrc)
* Upload file The screen then briefly flashes 0% loading and then disappears. In Staged MARC management there is then no data.
Any thoughts?? Thanks Liz _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Thanks so much for the responses. I'm now working through converting the information using Marceditor (proving to be a long, slow process as there are many discrepancies). Looks like there have been huge changes in the fields so, as half the data had been reentered manually before I commenced in the role, looks like I may need to go back to that. From: Phillip Ponchot [mailto:pponchot@live.com] Sent: Wednesday, 21 May 2014 4:55 AM To: Elizabeth Wilcox; koha@lists.katipo.co.nz Subject: RE: [Koha] Importing Marc records from Koha 2.2.9 into 3.14.05 There is documentation on how to export and import records from versions prior to 3.2. Usually the data is dumped via mysqldump to a file, then a 3.2 conversion is run on it, and then it is imported into 3.14. I am running Koha 3.0 and I have tried unsucessfully to export data from 3.0, convert it to 3.2 and then import it into Koha 3.14 but it might be because of some issue only with my database. I'm seeking a 12 step program to help with this issue (smile). I will search for the documentation and forward it to you (the whole process). Phillip
From: ewilcox@metier3.com.au To: koha@lists.katipo.co.nz Date: Tue, 13 May 2014 01:00:31 +0000 Subject: [Koha] Importing Marc records from Koha 2.2.9 into 3.14.05
Hello!
I have been unsuccessfully trying to export records from Koha 2.2.9 by going to Marc Biblio Export; selecting a call number range, clicking export and saving the file in notepad (not sure what program to use). The resulting file has a .mrc extension so I am presuming it is a Marc file, there is also data there. However, when I try to import it into version 3.14.05 it isn't being recognised.
The steps I am following in version 3.14.05 are as follows:
* Stage MARC records for Import
* Select the file (koha.mrc)
* Upload file The screen then briefly flashes 0% loading and then disappears. In Staged MARC management there is then no data.
Any thoughts?? Thanks Liz _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Elaine Bradtke -
Elizabeth Wilcox -
Phillip Ponchot