Difference between revisions of "Koha-Library-Software/C4/Extract-Excel-to-Marc-Codefile/English"
(Created page with "'''Title of the Script: Extract Excel to Marc Codefile''' '''Author: '''Maya Hans and Vaibhavi Satardekar '''Keywords:''' Koha, Koha 24.05, Koha library system, Excel to MAR...") |
|||
| Line 31: | Line 31: | ||
|| To record this tutorial, I am using | || To record this tutorial, I am using | ||
| − | * '''Windows 11 Pro Operating System '''and | + | * '''Windows 11 Pro Operating System ''' and |
* I also have a working internet connection. | * I also have a working internet connection. | ||
| Line 41: | Line 41: | ||
|| To practice this tutorial, you should have knowledge of Library Science. | || To practice this tutorial, you should have knowledge of Library Science. | ||
| + | |||
| + | Recall that in an earlier tutorial we have already installed '''MarcEdit 7.7'''. | ||
|- | |- | ||
| − | || | + | |
| − | + | '''Slide Number 5''' | |
| + | |||
| + | '''Code Files''' | ||
| + | |||
| + | ||To practice this tutorial the following '''Excel''' file is required. | ||
| + | |||
| + | This file is provided in the '''Code Files''' link of this tutorial page. | ||
| + | |||
| + | Please download the '''Excel''' file from the Code files link. | ||
|- | |- | ||
| − | |||
| − | |||
| − | |||
| − | Now let’s learn to extract the code file. | + | || Narration only |
| + | || Now let’s learn to extract the code file. | ||
|- | |- | ||
|| Point to '''This PC '''icon | || Point to '''This PC '''icon | ||
| Line 71: | Line 79: | ||
Double click on the '''Code-file''' folder | Double click on the '''Code-file''' folder | ||
| − | || On the '''Desktop''' click on '''This PC'''. | + | || On the '''Desktop''' click on '''This PC''' shortcut. |
From the navigation pane on the left, click on '''Downloads'''. | From the navigation pane on the left, click on '''Downloads'''. | ||
| Line 77: | Line 85: | ||
Right-click on the '''Convert-Excel-to-MARC-Codefiles''' folder and select '''Extract All'''. | Right-click on the '''Convert-Excel-to-MARC-Codefiles''' folder and select '''Extract All'''. | ||
| − | A pop up '''Select a Destination and Extract Files '''opens. | + | A pop up '''Select a Destination and Extract Files ''' opens. |
| − | Click on '''Browse''', a pop up '''Select a destination '''window''' '''opens. | + | Click on '''Browse''' button, a pop up '''Select a destination '''window''' '''opens. |
From the navigation pane on the left, click on '''Desktop'''. | From the navigation pane on the left, click on '''Desktop'''. | ||
Latest revision as of 21:41, 18 January 2026
Title of the Script: Extract Excel to Marc Codefile
Author: Maya Hans and Vaibhavi Satardekar
Keywords: Koha, Koha 24.05, Koha library system, Excel to MARC, Excel to MARC conversion, Video tutorial.
Prerequisite: Install MarcEditor on Windows
| Slide Number 1
Title Slide |
Welcome to this Spoken Tutorial on Extract Excel to Marc Codefile. |
| Slide Number 2
Learning Objectives
|
In this tutorial, we will learn how to:
|
| Slide Number 3
System Requirement
|
To record this tutorial, I am using
|
| Slide Number 4
Prerequisites
|
To practice this tutorial, you should have knowledge of Library Science.
Recall that in an earlier tutorial we have already installed MarcEdit 7.7. |
| To practice this tutorial the following Excel file is required.
This file is provided in the Code Files link of this tutorial page. Please download the Excel file from the Code files link. | |
| Narration only | Now let’s learn to extract the code file. |
| Point to This PC icon
Point to navigation pane on the left click on Downloads Right-click on Convert-Excel-to-MARC-Code Files folder select Extract All Cursor on Select a Destination and Extract Files Click on Browse Cursor on Select a destination window From navigation pane on the left, click on Desktop Click on Select Folder Click on Extract
|
On the Desktop click on This PC shortcut.
From the navigation pane on the left, click on Downloads. Right-click on the Convert-Excel-to-MARC-Codefiles folder and select Extract All. A pop up Select a Destination and Extract Files opens. Click on Browse button, a pop up Select a destination window opens. From the navigation pane on the left, click on Desktop. At the bottom of the window, click on Select Folder then click on Extract button. Now close this window. On the Desktop double click on the Code-file folder. We can see the codefile is extracted successfully. Now copy the TestData file and paste it on the Desktop for easy access. |
| Narration only | With this we come to the end of this tutorial. |
| Slide Number 4
Summary We learned to:
|
Let’s quickly recap. |
| Slide Number 5
Assignment
|
As an assignment,
Extract the assignment codefile provided in the codefiles link. |
| Slide Number 6
Thank you |
Thank you for joining. |
