[Koha] Testing Koha - How to migrate data from Voyager 9 to Koha for testing?

[Eliseo Gatchalian]

Hi All,

Greetings! ☺ I’ve successfully installed Koha in a test virtual box and hoping to explore more of what it can do and check/match/improve our current workflows.

I’d like to test Koha with our actual data we have from Voyager 9.0, and wondering if anyone can point me on a direction of how to migrate our data?

I’ve done a search and found, https://github.com/jcamins/koha-migration-toolbox but I am not sure if this would work on the latest Koha version as it seems that last commits was at least 4 years ago.

Also, if we are to use the koha-migration-toolbox, from its scripts, it will extract CSV’s of all data, but I can’t seem to find in Koha on how to import those CSV’s? Any step-by-step guide for migrating data would be very helpful?


Many thanks in advance guys… ☺


Best regards,
Ellis

________________________________


This electronic mail transmission is intended for the named recipients only. It may contain private and confidential information. If this has come to you in error you must take no action based upon it, nor must you copy it or show it to anyone; please telephone or email the sender at Wintec immediately and return the original email. We cannot accept any liability for any loss or damage sustained as a result of software viruses. It is your responsibility to carry out such virus checking as is necessary before opening any attachment which may be included with this message.
_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://lists.kat

[Ere Maijala]

Hi,

I'm not sure how well the migration toolbox works out of the box, but
there's one thing worth noting anyway: The vanilla Koha doesn't support
MFHD's, which have a pretty important role in Voyager. While in many
cases the relevant information can be stored in the bibliographic or
item records, we found it necessary to implement support for holdings
records in Koha. It, and the previous attempts, haven't really gained
traction, but I'm still trying. :) In any case we're currently in the
process of converting some Voyager databases to Koha with this custom
holdings support.

There's a Holdings RFC at
<https://wiki.koha-community.org/wiki/MARC_Holdings_Records_RFC> and
patches at
<http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20447>. I'll
try to see if there any chance at discussing this at the KohaCon 2018
hackfest, but I'd also appreciate any input you as another Voyager
library might have.

Regards,
Ere

Post by Eliseo Gatchalian
Hi All,
Greetings! ☺ I’ve successfully installed Koha in a test virtual box and hoping to explore more of what it can do and check/match/improve our current workflows.
I’d like to test Koha with our actual data we have from Voyager 9.0, and wondering if anyone can point me on a direction of how to migrate our data?
I’ve done a search and found, https://github.com/jcamins/koha-migration-toolbox but I am not sure if this would work on the latest Koha version as it seems that last commits was at least 4 years ago.
Also, if we are to use the koha-migration-toolbox, from its scripts, it will extract CSV’s of all data, but I can’t seem to find in Koha on how to import those CSV’s? Any step-by-step guide for migrating data would be very helpful?
Many thanks in advance guys… ☺
Best regards,
Ellis
________________________________
This electronic mail transmission is intended for the named recipients only. It may contain private and confidential information. If this has come to you in error you must take no action based upon it, nor must you copy it or show it to anyone; please telephone or email the sender at Wintec immediately and return the original email. We cannot accept any liability for any loss or damage sustained as a result of software viruses. It is your responsibility to carry out such virus checking as is necessary before opening any attachment which may be included with this message.
_______________________________________________
Koha mailing list http://koha-community.org
https://lists.katipo.co.nz/mailman/listinfo/koha

[Joy Nelson]

Ere is correct. In Voyager migrations you need to think about the holding
records and how to handle them. We typically convert the holdings into
item tags on the associated bib record or load the information into a
textual holding statement(s) if possible.

-Joy

Post by Ere Maijala
Hi,
I'm not sure how well the migration toolbox works out of the box, but
there's one thing worth noting anyway: The vanilla Koha doesn't support
MFHD's, which have a pretty important role in Voyager. While in many cases
the relevant information can be stored in the bibliographic or item
records, we found it necessary to implement support for holdings records in
Koha. It, and the previous attempts, haven't really gained traction, but
I'm still trying. :) In any case we're currently in the process of
converting some Voyager databases to Koha with this custom holdings support.
There's a Holdings RFC at <https://wiki.koha-community.o
rg/wiki/MARC_Holdings_Records_RFC> and patches at <
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20447>. I'll try
to see if there any chance at discussing this at the KohaCon 2018 hackfest,
but I'd also appreciate any input you as another Voyager library might have.
Regards,
Ere

Post by Eliseo Gatchalian
Hi All,
Greetings! ☺ I’ve successfully installed Koha in a test virtual box and
hoping to explore more of what it can do and check/match/improve our
current workflows.
I’d like to test Koha with our actual data we have from Voyager 9.0, and
wondering if anyone can point me on a direction of how to migrate our data?
I’ve done a search and found, https://github.com/jcamins/koh
a-migration-toolbox but I am not sure if this would work on the latest
Koha version as it seems that last commits was at least 4 years ago.
Also, if we are to use the koha-migration-toolbox, from its scripts, it
will extract CSV’s of all data, but I can’t seem to find in Koha on how to
import those CSV’s? Any step-by-step guide for migrating data would be very
helpful?
Many thanks in advance guys… ☺
Best regards,
Ellis
________________________________
This electronic mail transmission is intended for the named recipients
only. It may contain private and confidential information. If this has come
to you in error you must take no action based upon it, nor must you copy it
or show it to anyone; please telephone or email the sender at Wintec
immediately and return the original email. We cannot accept any liability
for any loss or damage sustained as a result of software viruses. It is
your responsibility to carry out such virus checking as is necessary before
opening any attachment which may be included with this message.
_______________________________________________
Koha mailing list http://koha-community.org
https://lists.katipo.co.nz/mailman/listinfo/koha

--
Ere Maijala
Kansalliskirjasto / The National Library of Finland
_______________________________________________
Koha mailing list http://koha-community.org
https://lists.katipo.co.nz/mailman/listinfo/koha

--
Joy Nelson
Vice President of Implementations

ByWater Solutions <http://bywatersolutions.com>
Support and Consulting for Open Source Software
Phone/Fax [phone]
What is Koha? <http://bywatersolutions.com/what-is-koha/>
_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://list

[Ere Maijala]

Hi Ellis,

If you mean exporting bibs and holdings from Voyager and importing them
to Koha, you can do that but the current Koha versions will treat all
the records as bibliographic, which isn't very useful, and it would also
lose all the links between bibs and holdings.

You could use Michael's utility to move the relevant holdings fields to
the bib records. This would work fine unless you have more verbose MFHDs
as there's no way to say in the bib record that fields coming from a
single MFHD belong together. E.g. if you have multiple holdings with 852
and 856 fields, there's no way to indicate which ones go together.
That's why I implemented the not-yet-accepted support for proper holding
records in Koha.

Regards,
Ere

Hi Ere,
Many thanks for the useful info. As an alternative, if I do a full Marc export using https://rocky.uta.edu/doran/voyager/export/ or using the Voyager's Pmarcexport utility, and import it to Koha to stage it for mapping, do you think that would work?
Best regards,
Ellis
-----Original Message-----
Sent: Monday, 27 August 2018 7:30 PM
Subject: Re: [Koha] Testing Koha - How to migrate data from Voyager 9 to Koha for testing?
Hi,
I'm not sure how well the migration toolbox works out of the box, but there's one thing worth noting anyway: The vanilla Koha doesn't support MFHD's, which have a pretty important role in Voyager. While in many cases the relevant information can be stored in the bibliographic or item records, we found it necessary to implement support for holdings records in Koha. It, and the previous attempts, haven't really gained traction, but I'm still trying. :) In any case we're currently in the process of converting some Voyager databases to Koha with this custom holdings support.
There's a Holdings RFC at
<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.koha-community.org%2Fwiki%2FMARC_Holdings_Records_RFC&amp;data=02%7C01%7Celiseo.gatchalian%40wintec.ac.nz%7C0659bf4972a64a9bce7908d60bef0f7f%7C4dfb6010c24b4460a31d9fab1f5b12c2%7C0%7C0%7C636709518756644591&amp;sdata=eYoP%2FaFSEF7JUG7CV5eZEe7e6X5Lq15CPYs4UZjZe5Y%3D&amp;reserved=0> and patches at <https://apac01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fbugs.koha-community.org%2Fbugzilla3%2Fshow_bug.cgi%3Fid%3D20447&amp;data=02%7C01%7Celiseo.gatchalian%40wintec.ac.nz%7C0659bf4972a64a9bce7908d60bef0f7f%7C4dfb6010c24b4460a31d9fab1f5b12c2%7C0%7C0%7C636709518756644591&amp;sdata=qt%2Fz8%2BIXt0AkWKmHjG5%2BByZg46bOVfHYnN5Fihc3Ft4%3D&amp;reserved=0>. I'll try to see if there any chance at discussing this at the KohaCon 2018 hackfest, but I'd also appreciate any input you as another Voyager library might have.
Regards,
Ere

Post by Eliseo Gatchalian
Hi All,
Greetings! ☺ I’ve successfully installed Koha in a test virtual box and hoping to explore more of what it can do and check/match/improve our current workflows.
I’d like to test Koha with our actual data we have from Voyager 9.0, and wondering if anyone can point me on a direction of how to migrate our data?
I’ve done a search and found, https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fjcamins%2Fkoha-migration-toolbox&amp;data=02%7C01%7Celiseo.gatchalian%40wintec.ac.nz%7C0659bf4972a64a9bce7908d60bef0f7f%7C4dfb6010c24b4460a31d9fab1f5b12c2%7C0%7C0%7C636709518756644591&amp;sdata=9g0s0GvSbIpfWvc61Lv%2BisF1ukCmBp7moTs4pJm9YSY%3D&amp;reserved=0 but I am not sure if this would work on the latest Koha version as it seems that last commits was at least 4 years ago.
Also, if we are to use the koha-migration-toolbox, from its scripts, it will extract CSV’s of all data, but I can’t seem to find in Koha on how to import those CSV’s? Any step-by-step guide for migrating data would be very helpful?
Many thanks in advance guys… ☺
Best regards,
Ellis
________________________________
This electronic mail transmission is intended for the named recipients only. It may contain private and confidential information. If this has come to you in error you must take no action based upon it, nor must you copy it or show it to anyone; please telephone or email the sender at Wintec immediately and return the original email. We cannot accept any liability for any loss or damage sustained as a result of software viruses. It is your responsibility to carry out such virus checking as is necessary before opening any attachment which may be included with this message.
_______________________________________________
Koha mailing list
https://apac01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha
-community.org&amp;data=02%7C01%7Celiseo.gatchalian%40wintec.ac.nz%7C0
659bf4972a64a9bce7908d60bef0f7f%7C4dfb6010c24b4460a31d9fab1f5b12c2%7C0
%7C0%7C636709518756644591&amp;sdata=YmZujrZ4QHvYlU1rnJfpyoyqob3qVCnexy
OFv4Doa6M%3D&amp;reserved=0
https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flis
ts.katipo.co.nz%2Fmailman%2Flistinfo%2Fkoha&amp;data=02%7C01%7Celiseo.
gatchalian%40wintec.ac.nz%7C0659bf4972a64a9bce7908d60bef0f7f%7C4dfb601
0c24b4460a31d9fab1f5b12c2%7C0%7C0%7C636709518756644591&amp;sdata=704um
7mtg7w7a3iX5fCmKcz1gdUzMRFLoo5OQFXyI1o%3D&amp;reserved=0

--
Ere Maijala
Kansalliskirjasto / The National Library of Finland _______________________________________________
Koha mailing list https://apac01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fkoha-community.org&amp;data=02%7C01%7Celiseo.gatchalian%40wintec.ac.nz%7C0659bf4972a64a9bce7908d60bef0f7f%7C4dfb6010c24b4460a31d9fab1f5b12c2%7C0%7C0%7C636709518756644591&amp;sdata=YmZujrZ4QHvYlU1rnJfpyoyqob3qVCnexyOFv4Doa6M%3D&amp;reserved=0
https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.katipo.co.nz%2Fmailman%2Flistinfo%2Fkoha&amp;data=02%7C01%7Celiseo.gatchalian%40wintec.ac.nz%7C0659bf4972a64a9bce7908d60bef0f7f%7C4dfb6010c24b4460a31d9fab1f5b12c2%7C0%7C0%7C636709518756644591&amp;sdata=704um7mtg7w7a3iX5fCmKcz1gdUzMRFLoo5OQFXyI1o%3D&amp;reserved=0