Introduction

Library Automation according to the adoption of emerging and new technologies, libraries and other information institutions are undergoing inevitable and significant shifts that extend beyond their traditional function as keepers of recorded knowledge. These technologies include, but are not limited to, incorporating fresh methods of information transmission, storage, and retrieval. Organizational structures, procedures, and tasks are all impacted simultaneously by these modifications, that are primarily made without ever using technology. To match the information-seeking behaviour and increasing user expectations, service delivery mechanisms are also shifting in line with these trends. One area in which these technology-driven changes and impacts are being seen in libraries is automation. It entails using technology to perform tasks more rapidly and efficiently while saving time and energy of personnel.^[1], ^[2], ^[3], ^[4], ^[5]

The word automation has been derived from the Greek word “Automose” which means something which has the power of spontaneous motion or self-movement. The main objective of library automation is to liberate librarians and other library staff members so they can contribute more significantly to the dissemination of knowledge and information. (Library Automation DLIS007, n.d.)

As per the Encyclopaedia of Library and Information Science, "automation is the technology concerned with the design and development of process and system that minimize the necessity of human intervention in operation". (Kent, 1977) Automation, when used in a library context, refers to the computerization or mechanization of all library activities.

Koha

Koha is the first free and open-source integrated library system (ILS). Development is sponsored by libraries of varying types and sizes, volunteers, and support companies from around the world. (Koha 21.11 Manual (En) — Koha Manual 21.11 Documentation, 2021)

MarcEdit

In 1999, MarcEdit started out as a simple MARC=>plain text translation utility. Today, MarcEdit has become one of the more complete metadata edit suites available to librarians. While the name MarcEdit has become a bit of a misnomer over the years (as MarcEdit now edits so much more data than simply MARC records), the program has and will continue to evolve to meet the past, present, and future metadata needs of the library community.

MarcEdit presently includes a very rich feature set targeted at making metadata translation and editing easier for both the beginner and advanced users. These features include:

Marc Editing, Automatic Normalization support, Metadata Translation, MarcEditor, Link data Framework, Bibframework Workflows, Clustering, RDA Helper, Delimited Text, Translator, Export as Tab Delimited, Harvest OAI Data, XML Translations, XML Profiler

Characterset conversion, Z39.50/SRU Client, ILS and OCLC Integrations, MARC SQL Explorer, MARCValidator, XML Editor, Hex Editor, Native software for MacOS and Windows. ^[6], ^[7], ^[8], ^[9]

Retrospective Conversion (ReCON)

The ability to migrate data is a key aspect of any change from one library management system to another the existing library data is an important asset and cannot be generated again and again as it is costly in terms of resources such as money, manpower, and time. (Data migration from one library management system to another: A case study in India, 2005).

In that case, retrospective conversion helps in data migration. Retrospective conversion or ReCON in library and information centre means "changing already existing catalogue from existing traditional form to a machine-readable form. (Dabas, 2004)

According to the ALA Glossary of Library & Information Science, ReCON has been defined as the process of converting the database of library holdings from non-machine-readable form to machine-readable form that is not converted during the day-to-day process. (ALA Glossary of Library and Information Science, Fourth Edition | ALA Store, 2013)

Retrospective Conversion (ReCON) is the conversion of a library's existing bibliographic records from manual to machine-readable format according to specified policies and standards" B. Jane, C. Joseph.

ReCON is the process of conversion of a printed catalogue of library holdings into machine-readable form, as quickly and as inexpensively as possible, in a pre-defined format using accepted standards for making it searchable through a machine. (Understanding MARC Bibliographic: Parts 1 to 6, 2022)

Harrod's Librarian's Glossary defines retrospective conversion (information retrieval) as a partial or complete conversion of an existing catalogue into machine-readable form as opposed to converting records created currently (Raymond John Prytherch, 2016).

Booth, R. (2018) has given the following Database Readiness Factors:

Catalogue records must be carefully converted from manual to machine-readable formats;

Collections must be prepared for conversion through effective and ongoing weeding and inventory programs;

Once converted, collections must be properly maintained as titles are added, withdrawn, transferred, and re-catalogued; and,

Standards -- for bibliographic, item, and patron records as well -- must be adhered to.

This process is a prerequisite for library computerization. Libraries cannot begin online transactions of other functions such as acquisition, cataloguing, circulation, OPAC and serial control, etc. unless and until the retrospective conversion is not fully done.

Need and Benefits of Retrospective Conversion

Exponential rise in published information and the limited library funds has increased the dependency on resource sharing for which MARC (Machine-Readable Cataloguing) provides a standard format. Machine-readable bibliographic data is exchanged across different library systems using MARC. The records produced during the retrospective conversion must adhere to the MARC standards in order for the records to comply with the international standards, simplifying the transfer of data between systems.

The foundation for all library automation software current and future automation efforts is the development of a top-notch MARC compliant library database. Vendors for the library may change over time, hardware may become outdated as new software replaces the old, but a well-built, well-maintained database will always be a valuable asset for the library. The quality of the corresponding databases and collection usage is improved via MARC-based ReCON.^[15]

The conversion of the database of library holdings from non-machine-readable form to machine-readable form is a prerequisite to implementing an automated system. These records provide the means of generating statistics and other information that is needed to improve the existing services and introduction of new ones (Dabas, 2004). ReCON enables libraries to switch over to a new MARC based ILMS to create a local database, improve and expedite the user services, improve internal library procedures, create an integrated file, eliminate the cost of maintaining parallel systems, provide flexibility in system changes, maximize return on investment involved in library automation, data protection, create union catalogue, exchange and share bibliographic data & resources, facilitate collection rationalization and contribute in national databases and strengthen Universal Bibliographic Control (UBC). Adherence to well-established and accepted standards of description for bibliographic information in a machine-readable database is critical because:

Without standards, files cannot easily be transferred from one automated system to another, and,

It is essential for libraries wishing to participate in resource-sharing arrangements with other libraries, that will require such adherence as a condition of participation. (Cohn, et. Al.,1997)

Approaches of Retrospective Conversion (ReCON) Process

There are several ways for recon to convert the catalogue into machine-readable form (MARC). The best method for a library or information centre depends upon the available resources at hand. The library may decide on - partial or full conversion, Capturing data by machine - optical character recognition (OCR), voice data input; By an outside recon vendor/commercial vendor or a combination of in-house and vendor recon. There would be a need to find the option, which offers the lowest cost, the highest quality, and the one with the least negative impact on the library.

Review of Related Literature

Purpose this case study aims to demonstrate that in-house integrated library systems migration can be accomplished by a dedicated team of librarians without advanced tools or prior experience with data migration or systems integration. Design/methodology/approach this migration was accomplished by academic librarians using freely available tools: Open Office Calc, MarcEdit, and the Koha Integrated Library System. Findings the data migration pathway presented here was developed and successfully used to transfer over 48,000 records in less than two months. Practical implications this case study presents an original process that is particularly effective for smaller libraries. Originality/value while similar case studies exist, most employ expensive third-party contractors for data migration or rely heavily on institutional IT departments (Todd, 2018).

In 2015, Rutgers became only the second accredited law school in the United States to select the open-source integrated library system, Koha. The merger of two unique catalogues at Rutgers Law School has presented unique challenges concerning migration mapping, data recall for large records, and relevancy ranking, all of which affect search results and usability of the Online Public Access Catalogue. System migrations always result in some data being lost or incorrectly transferred. The hope is to minimize just how much data is compromised while fixing errors that might not have come to light but for the migration. (Mitchell, 2017)

Objectives (Ob) of the Study

Every research has its aims and objectives to achieve. In every research, there must be some specific aims and objectives for which the study is to be conducted. Without definite aims and objectives, research has no value and may be considered meaningless. Hence, the study focused on the following basic objectives-

To examines the effects of batch import during data migration in the MARCedit software

To facilitate the functionalities and features of MarcEdit tools

To examine issues while doing Data migration (DM and ReCon with a smooth transition

To complete the process of importing bibliographic data into Koha

To covert the spreadsheet file into marc format

Results and Discussion

Library automation is a process that needs proper planning, timely implementation, and periodical evaluation. An automated library can provide better library services to its users and can maintain the library more properly which a manual library can't do. The record-keeping activities and various report generation become very easy in an automated library system. But the success of any library automation program depends upon its proper planning and execution. Hence library professionals need to take the right initiatives in the right direction. For the successful implementation of an integrated library system, all the key factors must be in place, support from administration, staff competence, consideration of user requirements, availability of the infrastructure, and excellent managerial skill of the co-coordinator of the project. With the emergence of Cloud-based ILMS accessible over web browsers, libraries have also started considering shifting from On-Premise (On-Prem) solutions to cloud ILMS as they require their infrastructure and involve up-front cost and recurring maintenance. Retrospective conversion of bibliographic records in libraries plays a crucial role in enhancing the migration of library resources to an online environment and improving the visibility of the library.

First step of data migration

First, prepare an excel sheet that is shorted on the bases of title to accumulate all unique titles in the same place.

The above screenshot defines different fields as like

Column A: ISBN

Column B: Language

Column C: Class no

Column D: Author Mark

Column E: Personal Name

Column F: Title

Column G Substitute

Column H: Statement of Responsibility

Column I: Edition

Column J: Place

Column K: Publisher

Column L: Year

Column M: Physical Description

Column N: Series

Column O: Volume

Column P: General note

Column Q: Bibliography

Column R: Summary

Column S: Sub Author

Column T: Location

Column U: Type

Column V: Price

Column W: Accession No

Convert your excel data into MARC format. The process is given below. See that the sheet given in the excel sheet contains all the bibliographical details about the document.

Now, open MarcEdit 7.5 and follow the procedure

Choose Delimited Text Translator and Select the Excel File. On the next page, choose excel or a text file that contains your original data. Then Select the delimiter, generally, it is 'comma'.

Step: - Click on the yellow symbol folder to select the input file (spreadsheet) from PC.

Step: - Click on the yellow folder with the green arrow to select the location where want to save the MRK file.

Step: - Click to select sheet number from the spreadsheet.

Step: - Click on EditLDR/008 and select book.

Step: - Click on import file button.

Now it is the most important part is mapping the field manually as per the MARC tag.

Otherwise, by clicking the Auto generates button it will automatically record data.

The arrow shows joint fields, forward of joints fields have * star symbols. (For e.g.: - 260a, 260b, 260c) these are joint fields.

After auto-generates, all data click on the Finish button then one dialogue box will appear to click OK.

Done, now MRK file looks like this.

After opening of MRK file delete the first entries

After completion, this is the final MRK file.

To convert. MRK file to. MRC click on Compile File into Marc.

Second step: Data migration in koha

Stage MARC records for import

Get there: More > Tools > Catalog > Stage MARC records for import.

This tool can be used to import both bibliographic and authority records that are saved in MARC format. Importing records into Koha includes two steps. The first is to stagerecords for import.

First, find the MARC file on the desktop then click > choose > upload file.

Comments about this file’: enter comments to identify your upload when going to the ‘Manage staged MARC records’ tool.

Record type’: tell Koha which type of file this is, bibliographic or authority,

Click ‘Stage for import’

This will be presented with a confirmation of your MARC import

To complete the process, continue to the Manage staged MARC records tool by clicking on the ‘Manage staged records’ button.

Staged MARC record management

Get there: More > Tools > Catalog > Staged MARC record management

Once you have staged your records for import you can complete the import using this tool.

In this figure, all information is given (see underlined part) like batch number, file name, and a comment which was added in figure 13. Click on import batch into the catalogue.

Once your import is complete a link to the new records will appear to the right of each title that was imported.

You can also undo your import by clicking the ‘Undo import into catalog’ button

For checking the successful task Click on search the catalogue and search any book from the imported entries, if it shows that same book it means the task is hundred percent done.

Findings and Suggestions

There are certain findings and suggestions based on those, future work can be carried out. These are: -

For successful doing data migration and retrospective conversion projects, there is a need for a detailed plan tempered with realistic expectations. The plan should Identify the objectives, carefully import data procedures and Specify standards to be used.

It is possible to examine import data migration to Koha with the help of MarcEdit software and open-source software which helps to access collections of documents very easily

At present, the efforts for importing data by clicking the Auto-generate button will automatically record data

There are no fixed policies prepared in respect of Retrospective Conversion using MarcEdit

The study findings reveal that MarcEdit software fully supports conversion of non-marc data in marc format for effective and accurate import to open source ILMS Koha making libraries independent and empowered.

Organize training program to develop an awareness of data migration in Koha and handling technical problems.

UGC or the Central government is encouraging the project of data migration and retro convention and providing training to college libraries to migrate library’s bibliographic data into Koha OSS to bring grey resources in limelight.

Conclusion

Data Migration is a process of moving bibliographic data into a system that usually performed through programs. Technology has been perhaps continued to have a dramatic impact on library operations and services. It is the main force for changing the core work culture of library situation to maintain their record on the accession register into excel sheet of a computer. So, if a library wants automation, then needs to migrate the huge amounts of data into the database of a system. For reducing manpower, time, and money to apply the method of data migration. So, an automation system is very crucial in the library. The trends in technology will certainly find their way into a large library setup. Because, the library must satisfy the expectations of its end users to sustain their goals, objectives, and existence in the present techno-oriented world. In the past, they were compiled manually, a tedious job. Nowadays library systems come with a graphical report interface that enables point and clicks selection of appropriate data elements, periods, frequencies, output devices, etc.

ReCON involves a considerable amount of work, essentially acquiring existing databases and keyboarding all the existing entries of records error-checking, etc., or getting the job done from commercial vendors and creating a bibliographic database and transferring the records to machine-readable form. RECON is a costly and time-consuming task for most libraries. Therefore, it is to be planned properly for completing the task with the day-to-day activities of the library. Hence Cost-effective and efficient forethought and planning are essential.

Source of Funding

None.

Conflict of Interest

None.