Journal of Information and Knowledge (Formerly SRELS Journal of Information Management)

Open Access Open Access  Restricted Access Subscription Access
Open Access Open Access Open Access  Restricted Access Restricted Access Subscription Access

Demystifying the Transformation of Bibliographic Data: Excel to MARC Decrypted


Affiliations
1 Presidency University, Yelahanka, Bengaluru – 560064, Karnataka, India
2 Department of Studies and Research in LISc., Tumkur University, Tumakuru – 572103, Karnataka, India
     

   Subscribe/Renew Journal


This article explores the process of conversion of Excel data to MARC format, a major step in data migration which enhances the accuracy and accessibility of management of library collections. The study explains the intricacies of data curation within Excel, emphasizing the optimal structuring of information for subsequent MARC conversion. It provides an accessible introduction to MARC tags and subfield codes, essential for accurate cataloguing. The article guides readers through the steps of curating the bibliographic data in Excel and converting the curated data, mapping it to MARC tags, etc. It also delves into the crucial process of uploading MARC records into Koha, an open-source Integrated Library Management System, Furthermore, the article discovers advanced features of the MARC editor, including finding and replacing functions and deduplication, enabling global adjustments and improved data management.

Keywords

Data Conversion, Data Migration, Marc Editor, Machine-Readable Cataloguing.
User
About The Authors

Duragappa
Presidency University, Yelahanka, Bengaluru – 560064, Karnataka
India

K. N. Sheshadri
Presidency University, Yelahanka, Bengaluru – 560064, Karnataka
India

Beeresh N. Gundur
Department of Studies and Research in LISc., Tumkur University, Tumakuru – 572103, Karnataka
India


Notifications

  • Goyal , K., and Engard, N. C. (2010). Importing excel data into Koha Appendix L. MarcEdit. Available at: https://kohacommunity. org/manual/16.11/html/apls02.html

  • Karak, S., and Dutta, K. (2017). Bibliographic data migration in KOHA 3.18 from existing data sheet: A practical experience. International Research: Journal of Library and Information Science. 7, 122-132.

  • Kumar, V. (2022). Bulk excel records convert into MARC. Vijender Kumar’s Blog. Available at: https://www.vijenderkumar. com/2022/05/bulk-excel-records-convert-into-marc.html Library of Congress. (n.d.). MARC 21 Format for Bibliographic Data: Update No. 1 (UM01 to UM06) [Machine-readable data file]. Available at: https://www.loc.gov/marc/umb/ um01to06.html

  • Mishra, V. K. (2015). Systematic approach of data migration, customization and implementation of Koha: A case study of Saharanpur Campus Library. KBD Publication.

  • Narad, A., Mishra, P., Chakravarty, A., and Chakravarty, R. (2023). Data migration and retrospective conversion using MarcEdit: A study of Koha. IP Indian Journal of Library Science and Information Technology, 8: 5-13. https://doi. org/10.18231/j.ijlsit.2023.002

  • ProQuest. (n.d.). How do I combine multiple MARC files into one file? ProQuest Support. Available at: https://support. proquest.com/s/article/How-do-I-combine-multiple- MARC-files-into-one-file?language=en_US

  • Reese, T., and Robertson, W. (2018). Beginners guide to MarcEdit and beyond the editor: Advanced tools and techniques for working with metadata. The Serials Librarian, 74: 3-8. https://doi.org/10.1080/0361526X.2018.1439247

  • Reese, T. (n.d.). Is MarcEdit open source? MarcEdit. Available at: http://marcedit.reeset.net/is-marcedit-open-source

  • Reese, T. (n.d.). Correct ISBNs Converted to Scientific Notation in Excel. MarcEdit. Available at: https://marcedit.reeset.net/ correct-isbns-converted-to-scientific-notation-in-excel

  • Singh, V. (2014). Expectations versus experiences: Librarians using open source integrated library systems. The Electronic Library, 32: 688-709. https://doi.org/10.1108/EL-10-2012-0129


Abstract Views: 40

PDF Views: 2




  • Demystifying the Transformation of Bibliographic Data: Excel to MARC Decrypted

Abstract Views: 40  |  PDF Views: 2

Authors

Duragappa
Presidency University, Yelahanka, Bengaluru – 560064, Karnataka, India
K. N. Sheshadri
Presidency University, Yelahanka, Bengaluru – 560064, Karnataka, India
Beeresh N. Gundur
Department of Studies and Research in LISc., Tumkur University, Tumakuru – 572103, Karnataka, India

Abstract


This article explores the process of conversion of Excel data to MARC format, a major step in data migration which enhances the accuracy and accessibility of management of library collections. The study explains the intricacies of data curation within Excel, emphasizing the optimal structuring of information for subsequent MARC conversion. It provides an accessible introduction to MARC tags and subfield codes, essential for accurate cataloguing. The article guides readers through the steps of curating the bibliographic data in Excel and converting the curated data, mapping it to MARC tags, etc. It also delves into the crucial process of uploading MARC records into Koha, an open-source Integrated Library Management System, Furthermore, the article discovers advanced features of the MARC editor, including finding and replacing functions and deduplication, enabling global adjustments and improved data management.

Keywords


Data Conversion, Data Migration, Marc Editor, Machine-Readable Cataloguing.

References





DOI: https://doi.org/10.17821/srels%2F2023%2Fv60i5%2F171168