Data Cleansing, Standardization and Data Migration Framework for Proprietary to Open-Source ILMS in India

Vinod Kumar Mishra; Durga Sankar Rath

doi:10.17821/srels/2023/v60i4/170811

Authors

Vinod Kumar Mishra
Research Scholar, Department of Library and Information Science, Vidyasagar University, Midnapore – 721101, West Bengal
Durga Sankar Rath
Professor and Head, Department of Library and Information Science, Vidyasagar University, Midnapore – 721101, West Bengal

DOI:

https://doi.org/10.17821/srels/2023/v60i4/170811

Keywords:

Data Migration, Koha, Libsys, Library Automation, MarcEdit, Open-Source Software, SOUL

Abstract

The present study discusses data migration and various issues involved in data cleansing and standardization. Libraries are moving to the popular open-source ILMS Koha. The paper describes the design of a data migration framework from proprietary Integrated Library Management Software (ILMS) to Koha. The issues related to data quality in source ILMS and processes involve understanding and correcting raw data. The paper highlights the methods, tips and tricks, configurations, and data migration in open ILMS Koha. Studies proved Open Source Solutions (OSS) such as Koha for library automation is the better choice as it supports customization at a minimal cost. The paper examines the errors, mistakes and lack of uniformity of data in source databases and methods for quality enhancement of raw data. The current article is of practical significance for those who wish to migrate from existing ILMS to open-source solutions like Koha. The paper covers the migration of bibliographic data, member data and transaction data.

Downloads

Download data is not yet available.

Metrics

Metrics Loading ...

References

Adeyoyin, S. O., and Akinyosoye, H. I. T. (2004). Retrospective conversion in a Nigerian research library: Migrating from TINMAN/TINLIB to CDS/ISIS. The Electronic Library, 22(4), 331–334. https://doi. org/10.1108/02640470410552965

Anyaogu, U. (2019). Retrospective conversion of bibliographic records: Koha experience of NIALS library. Library Philosophy and Practice, 2019.

Badovinac, B. (2021). Defining data quality in bibliographic and authority records: A case study of the COBISS.SI system. Cataloging and Classification Quarterly, 59(4), 355–377. https://doi.org/10.1080/01639374.2021.1910603

Data Migration Frequently Asked Questions FAQs. (n.d.). Soutron Global. Available at: https://www.soutron.com/ data-migration-faqs-usa/

Data Quality, Cleansing, Integration and Migration. (n.d.). Kualitatem. Available at: https://www.kualitatem.com/ data-quality-cleansing-integration-migration/

Don, K. (2011). A survey of Koha in Australian special libraries: Open source brings new opportunities to the outback. OCLC Systems & Services: International Digital Library Perspectives, 27(1), 23–39. https://doi. org/10.1108/10650751111106537

Hanumappa, A., Dora, M., and Navik, V. (2014). Open Source Software solutions in Indian libraries. Library Hi Tech, 32(3), 409–422. Scopus. https://doi.org/10.1108/LHT-12- 2013-0157

Ian, W. (2011). Migrating from Innovative Interfaces’ Millennium to Koha: The NYU Health Sciences Libraries’ experiences. OCLC Systems & Services: International Digital Library Perspectives, 27(1), 51–56. https://doi. org/10.1108/10650751111106564

Koha Data Migration. How to Import MARC file into Koha using Terminal @ Technical Digit. (n.d.). Available at: https://technicaldigit.com/koha-data-migration-usingterminal/

MarcEdit Development. (2013). MarcEdit Development. https://marcedit.reeset.net/downloads

Mishra, V. K., and Rath, D. S. (2021). Data migration, RFID integration and implementation of koha: A case study of nit rourkela. Annals of Library and Information Studies, 68(1), 47–55. https://doi.org/10.56042/alis.v68i1.37510

Mitchell, H. (2017). The Times, they are changing. Technical Services Quarterly, 34(2), 129–145. https://doi.org/10.1080 /07317131.2017.1286838

Rudić, G., and Surla, D. (2009). Conversion of bibliographic records to MARC 21 format. The Electronic Library, 27(6), 950–967. https://doi.org/10.1108/02640470911004057

Scopus—Document search. (n.d.). Available at: https://www. scopus.com/search/form.uri?display=basic#basic

Todd, C. R. (2017). Librarian as data migrator: A functional pathway from Millennium to Koha. Digital Library Perspectives, 34(1), 60–69. https://doi.org/10.1108/DLP- 09-2017-0035

What Is Data Migration? – How to Plan a Data Migration. NetApp. (2021). Available at: https://www.netapp.com/ data-management/what-is-data-migration/

WMS data migration checklist. (2020). OCLC Support. Available at: https://help.oclc.org/Librarian_Toolbox/ WMS_data_checklists/WMS__data__migration__checklist