Difference between revisions of "Koha-Library-Management-System/C3/Import-MARC-to-Koha/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
(Created page with " {|border=1 |Time |Narration |- | 00:01 | Welcome to the '''Spoken Tutorial '''on '''Import MARC file into Koha.''' |- | 00:06 | In this tutorial we will learn to- Import...")
 
m (Protected "Koha-Library-Management-System/C3/Import-MARC-to-Koha/English-timed" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)))
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
{|border=1
 +
|Time
 +
|Narration
  
−
{|border=1
+
|-
−
|Time
+
| 00:01
−
|Narration
+
| Welcome to the '''Spoken Tutorial '''on '''Import MARC file into Koha.'''
  
−
|-
+
|-  
−
| 00:01
+
| 00:07
−
|  Welcome to the '''Spoken Tutorial '''on '''Import MARC file into Koha.'''
+
|  In this tutorial, we will: learn to '''import''' a '''MARC file '''into''' KOHA '''and
  
−
|-
+
search imported data in''' OPAC.'''  
−
| 00:06
+
−
|  In this tutorial we will learn to-  Import a '''MARC file '''into''' KOHA '''and
+
  
−
Search imported data in''' OPAC'''
+
|-
 +
| 00:20
 +
|  To record this tutorial, I am using:  '''Ubuntu Linux OS 16.04 '''  
  
−
|-
+
|-  
−
| 00:15
+
| 00:28
−
| To record this tutorial, I am using  '''Ubuntu Linux OS 16.04 '''
+
| '''Koha version 16.05 '''and  '''Firefox Web browser.'''  
  
−
|-
+
|-  
−
| 00:22
+
| 00:36
−
|  '''Koha version 16.05 '''and  '''Firefox Web browser'''
+
|  You may use any other web browser of your choice.
  
−
|-
+
|-  
−
| 00:29
+
| 00:41
−
|   You may use any other web browser of your choice.
+
| To follow this tutorial, learners should be familiar with Library Science.  
  
−
|-
+
|-  
−
| 00:33
+
| 00:47
−
|  To follow this '''tutorial,''' learners should be familiar with '''Library Science.'''
+
|  To practice this tutorial, You should have '''Koha''' installed on your system.  
  
−
|-
+
And, You should also have '''Admin '''access in '''Koha.'''
−
| 00:39
+
−
|  To practice this tutorial, You should have '''Koha''' installed on your system.
+
  
−
And You should also have '''Admin '''access in '''Koha.'''
+
|-
 +
| 00:58
 +
|  If not, please refer to the '''Koha Spoken Tutorial''' series on this website.  
  
−
|-
+
|-  
−
| 00:48
+
| 01:05
−
| If not, please refer to the '''Koha Spoken Tutorial''' series on this website.
+
| Importing '''record'''s into '''Koha''' is done in two steps:
  
−
|-
+
'''Stage MARC records for import''' and  '''Manage staged records'''.
−
| 00:56
+
−
| Importing '''records''' into '''Koha''' is done in two steps:
+
  
−
'''Stage MARC records for import''' and  '''Manage staged records'''
+
|-
 +
| 01:18
 +
| To begin, let’s login to '''Koha '''with our '''Superlibrarian '''access.
  
−
|-
+
|-  
−
| 01:06
+
|01:24
−
| To begin, let’s login to '''Koha '''with our '''Superlibrarian '''access.
+
| On the''' Home page''', click on '''Tools'''.  
  
−
|-
+
|-  
−
|01:13
+
| 01:28
−
| On the''' Home page''', click on '''Tools'''.
+
| A new page opens. Under the section '''Catalog''', click on '''Stage MARC records for import.'''  
  
−
|-
+
|-  
−
| 01:17
+
| 01:40
−
| A new page opens. Under the '''section Catalog''', click on '''Stage MARC records for import.'''
+
| A new page opens with the title '''Stage MARC records for import. '''  
  
−
|-
+
|-  
−
| 01:27
+
−
| A new page opens with the title '''Stage MARC records for import. '''
+
−
 
+
−
|-
+
−
| 01:33
+
−
| Go to the section '''Stage records into the reservoir.'''
+
−
 
+
−
|-
+
−
| 01:38
+
−
| Here''' '''click on '''Browse... '''adjacent to '''Select the file to stage. '''
+
−
 
+
−
|-
+
 
| 01:46
 
| 01:46
−
| Then go to the '''Downloads '''folder. A window '''File Upload '''opens
+
| Go to the section '''Stage records into the reservoir.'''  
  
−
|-
+
|-  
−
| 01:52
+
| 01:51
−
| Here locate the file named '''TestData.mrc'''
+
| Here, click on '''Browse... '''adjacent to '''Select the file to stage. '''  
  
−
|-
+
|-  
 
| 01:58
 
| 01:58
−
| Recall, we had created '''TestData.mrc '''file in one of the earlier tutorial.  
+
| A window '''File Upload '''opens. Then go to the '''Downloads '''folder.
  
−
|-
+
|-  
−
| 02:05
+
| 02:06
−
| Select the '''TestData.mrc''' file, if not already selected.
+
| Here, locate the file named '''TestData.mrc'''.  
  
−
And click on the button '''Open '''at the bottom of the page.
+
|-
 +
| 02:12
 +
|  Recall, we had created '''TestData.mrc '''file in one of the earlier tutorial.  
  
−
|-
+
|-  
−
| 02:17
+
| 02:20
−
| On the same page, you will see '''TestData.mrc''' as name of the file, adjacent to the tab '''Browse.'''
+
| Select the '''TestData.mrc''' file, if not already selected.  
  
−
|-
+
And, click on the button '''Open '''at the bottom of the page.  
−
| 02:28
+
−
| Now, click on''' Upload file '''button at the bottom of the page.
+
  
−
|-
+
|-  
−
| 02:33
+
| 02:32
−
| You will see the '''Upload progress '''bar in brown color.
+
| On the same page, you will see '''TestData.mrc''' as name of the file, adjacent to the tab '''Browse.'''
  
−
|-
+
|-  
−
| 02:38
+
| 02:43
−
| After the '''Upload '''is complete upto '''100%, '''we are prompted to fill in the some details.
+
| Now, click on''' Upload file '''button at the bottom of the page.  
  
−
|-
+
|-  
−
| 02:45
+
| 02:49
−
| First, fill the '''field''' for '''Comments about this file.'''
+
| You will see the '''Upload progress bar''' in brown color.  
  
−
|-
+
|-  
−
| 02:50
+
| 02:55
−
|  This is useful for identifying the uploaded file in '''KOHA.'''
+
|  After the upload is complete up to '''100%, '''we are prompted to fill in some details.
 +
 +
|-
 +
|  03:03
 +
|  First, fill the '''field''' for '''Comments about this file.'''  
  
−
|-
+
|-  
−
| 02:55
+
| 03:09
−
|  I will enter '''Book Data.'''
+
|  This is useful for identifying the uploaded file in '''KOHA.'''  
  
−
|-
+
|-  
−
| 02:58
+
| 03:14
−
|  Next is '''Record type: ''' Here, '''Koha '''by default selects '''Bibliographic.'''
+
|  I will enter '''Book Data.'''  
  
−
|-
+
|-  
−
| 03:04
+
| 03:18
−
|  Similarly for '''Character encoding, Koha '''by default selects, '''UTF-8 (Default)'''.
+
|  Next is '''Record type. ''' Here, '''Koha '''by default, selects '''Bibliographic.'''  
  
−
|-
+
|-  
−
| 03:13
+
| 03:26
−
|  Next come to the '''section Look for existing records in catalog?'''
+
|  Similarly, for '''Character encoding, Koha '''by default selects '''UTF-8 (Default)'''.
  
−
|-
+
|-  
−
| 03:18
+
| 03:35
−
|  Under this '''section''', go to '''Record matching rule: '''
+
|  Next, come to the section '''Look for existing records in catalog?'''  
  
−
'''Koha '''by default, selects '''Do not look for matching records'''.
+
|-
 +
|  03:41
 +
|  Under this section, go to '''Record matching rule: '''  
  
−
|-
+
'''Koha '''by default, selects '''Do not look for matching records'''.  
−
| 03:27
+
−
|  If you want to match existing records, select another option from the drop down i.e.-  '''ISBN/ISSN number'''.
+
  
−
|-
+
|-  
−
| 03:40
+
| 03:51
−
| Now we come to '''Action if matching record found: '''
+
|   If you want to match existing records, select another option from the drop down i.e. '''ISBN/ISSN number'''.
  
−
|-
+
|-  
−
| 03:45
+
| 04:04
−
|  '''Koha '''by default, selects '''Replace existing record with incoming record.'''
+
|  Now we come to '''Action if matching record found. '''  
  
−
|-
+
|-  
−
|  03:51
+
−
|  Then comes '''Action if no match is found:''' '''Koha '''by default, selects '''Add incoming record'''.
+
−
 
+
−
|-
+
−
|  03:59
+
−
|  Next, we come to the section''' Check for embedded item record data?'''
+
−
 
+
−
There are two options here  '''Yes '''and  '''No'''
+
−
 
+
−
|-
+
 
| 04:09
 
| 04:09
−
| '''Koha '''by default, selects '''Yes.'''
+
| '''Koha '''by default, selects '''Replace existing record with incoming record.'''  
  
−
|-
+
|-  
−
|  04:13
+
|  04:16
−
|  For '''How to process items:, Koha '''by default selects, '''Always add items.'''
+
|  Then comes '''Action if no match is found.''' '''Koha '''by default, selects '''Add incoming record'''.
  
−
|-
+
|-  
−
|  04:21
+
|  04:25
−
|  There are other options, as well. You may choose any of these options as per your preference.
+
|  Next, we come to the section''' Check for embedded item record data?'''
  
−
|-
+
There are two options here, '''Yes '''and '''No'''.  
−
| 04:28
+
−
| Click on the '''Stage for import '''button at the bottom of the page.
+
  
−
You will see '''“Job progress” '''in a blue colored bar.
+
|-  
−
 
+
−
|-
+
 
| 04:37
 
| 04:37
−
|  When the progress is complete upto '''100%''', a new page opens with heading '''Stage MARC records for import.'''
+
| '''Koha '''by default, selects '''Yes.'''
 +
 
 +
|-
 +
|  04:41
 +
|  For '''How to process items,''' Koha by default, selects '''Always add items.'''  
  
−
|-
+
|-  
−
| 04:47
+
| 04:48
−
|  Note that now, we have successfully imported the data which we had in our '''Excel sheet'''.
+
|  There are other options, as well. You may choose any of these options as per your preference.  
  
−
|-
+
|-  
 
|  04:56
 
|  04:56
−
|  It has the following details.
+
|  Click on the '''Stage for import '''button at the bottom of the page.  
  
−
|-
+
You will see '''“Job progress” '''in a blue colored bar.  
−
|  04:59
+
−
|  Note that you will see a different value on your '''Koha interface''', as per your '''.mrc''' data.
+
  
−
|-
+
|-  
−
| 05:07
+
| 05:06
−
|  On this same page, above the title, you will see two options:
+
|  When the progress is complete up to '''100%''', a new page opens with the heading '''Stage MARC records for import.'''
  
−
'''Stage MARC records '''and '''Manage staged records'''
+
|-
 +
| 05:17
 +
|  Note that now we have successfully imported the data which we had in our '''Excel sheet'''.
  
−
|-
+
|-  
−
|  05:18
+
|  05:25
−
|  Note that- I will not click on '''Stage MARC records '''as I have already imported the '''Excel''' file i.e. '''TestData.'''
+
|  It has the following details.  
  
−
|-
+
|-  
 
|  05:28
 
|  05:28
−
|  If you need to import any other file then click on '''Stage MARC records.'''
+
|  Note that you will see a different value on your '''Koha interface''' as per your '''.mrc''' data.
  
−
And follow the steps as mentioned earlier.
+
|-
 +
|  05:36
 +
|  On this same page, above the title, you will see two options:
  
−
|-
+
'''Stage MARC records '''and '''Manage staged records.'''  
−
|  05:38
+
−
|  Next, we have to manage the imported '''records''' in '''KOHA Catalog.'''
+
  
−
So, click on '''Manage staged records.'''
+
|-
 +
|  05:48
 +
|  Note that I will not click on '''Stage MARC records '''as I have already imported the '''Excel''' file i.e. '''TestData.'''  
  
−
|-
+
|-  
−
| 05:49
+
| 06:00
−
|  A new window '''Manage staged MARC records › Batch 6, '''opens.
+
|  If you need to import any other file then click on '''Stage MARC records''' and follow the steps as mentioned earlier.
 +
 +
|-
 +
|  06:11
 +
|  Next, we have to manage the imported '''records''' in '''KOHA Catalog.'''
  
−
|-
+
So, click on '''Manage staged records.'''  
−
| 05:56
+
−
|  On this page, '''Koha''' fills the following '''fields '''with the values shown here.
+
  
−
|-
+
|-  
−
| 06:03
+
| 06:22
−
|  And for the following '''fields''', '''Koha''' by default, selects these entries from the drop down.  
+
|  A new window '''Manage staged MARC records › Batch 6 '''opens.  
  
−
|-
+
|-  
−
| 06:10
+
| 06:30
−
|  But, you can change these entries from their respective drop-downs, as per your requirement.
+
|  On this page, '''Koha''' fills the following '''fields '''with the values shown here.  
  
−
|-
+
|-  
−
| 06:17
+
| 06:37
−
|  Next is the button named '''Apply different matching rules.'''
+
|  And for the following '''fields''', '''Koha''' by default, selects these entries from the drop down.
  
−
|-
+
|-  
−
| 06:23
+
| 06:45
−
|  You may click on this button to avoid the duplication of the '''records''' in the '''database'''.
+
|  But, you can change these entries from their respective drop-downs as per your requirement.  
  
−
I will skip this button and move ahead.
+
|-
 +
| 06:52
 +
|  Next is the button named '''Apply different matching rules.'''
  
−
|-
+
|-  
−
| 06:32
+
| 06:57
−
|  Now locate''' Add new bibliographic records into this framework:'''
+
|  You may click on this button to avoid the duplication of the records in the database.
  
−
And from the drop down, I will select '''BOOKS'''.
+
I will skip this button and move ahead.  
  
−
|-
+
|-  
−
| 06:43
+
| 07:09
−
| Again, you may select as per your requirement.
+
| Now, locate''' Add new bibliographic records into this framework.'''
  
−
|-
+
And from the drop down, I will select '''BOOKS'''.
−
|  06:47
+
−
|  Now come to the '''section Manage staged MARC records  Batch 6'''
+
  
−
I will click on the tab '''Import this batch into the catalog '''at the bottom.
+
|-
 +
| 07:20
 +
| Again, you may select as per your requirement.  
  
−
|-
+
|-  
−
|  07:01
+
|  07:25
−
|  However, before clicking we will go through the '''section Citation.'''
+
|  Now, I will click on the tab '''Import this batch into the catalog '''.
  
−
|-
+
|-  
−
|  07:06
+
|  07:32
−
|  Please note the particular numbers
+
|  However, before clicking we will go through the section '''Citation.'''
  
−
Note that, you will see a different number with the details that we have imported from '''Excel.'''
+
|-
 +
|  07:37
 +
|  Please note the particular numbers.  
  
−
|-
+
Note that you will see a different number with the details that we have imported from '''Excel.'''  
−
|  07:17
+
−
|  Now, we will click on the button named '''Import this batch into the catalog '''at the bottom.
+
  
−
|-
+
|-  
−
|  07:25
+
|  07:48
−
|  When we do so, the '''Job progress bar '''appears.
+
|  Now, we will click on the button named '''Import this batch into the catalog. '''
  
−
|-
+
|-  
−
| 07:29
+
| 07:55
−
| When the progress is complete upto '''100%''', a new page opens.
+
| When we do so, the '''Job progress bar '''appears.  
  
−
|-
+
|-  
−
| 07:35
+
| 08:00
−
| With the heading '''Manage staged MARC records › Batch 6'''
+
| When the progress is complete up to '''100%''', a new page opens
  
−
And the following details which were entered earlier.
+
|-
 +
| 08:06
 +
|  with the heading '''Manage staged MARC records › Batch 6''' and the following details which were entered earlier.  
  
−
|-
+
|-  
−
|  07:46
+
|  08:16
−
|  It is possible to undo your import. In case, you found a mistake in the imported data, to correct it do the following.
+
|  It is possible to '''undo''' your '''import'''. In case, you found a mistake in the imported data, to correct it do the following.  
  
−
|-
+
|-  
−
| 07:56
+
| 08:27
−
|  Click on the tab '''Undo import into catalog''' at the bottom of the section.
+
|  Click on the tab '''Undo import into catalog''' at the bottom of the section.  
  
−
|-
+
|-  
−
|  08:02
+
|  08:34
−
|  I will not click here.
+
|  I will not click here.  
  
−
|-
+
|-  
−
| 08:05
+
| 08:37
−
|  Next is '''Completed import of records.'''
+
|  Next is '''Completed import of records.'''  
  
−
|-
+
|-  
−
|08:09
+
|08:42
−
|  Here you will see the details of the '''records added, updated '''and so on.  
+
|  Here, you will see the details of the '''records added, updated '''and so on.  
  
−
|-
+
|-  
−
| 08:15
+
| 08:49
−
|  Then you will see the '''section Citation, '''with the details that have been imported.
+
|  Then you will see the section '''Citation '''with the details that have been imported.  
  
−
|-
+
|-  
−
|  08:22
+
|  08:56
−
|  Once the import is complete, a link to the new '''Record '''will appear.
+
|  Once the import is complete, a link to the new '''Record '''will appear.  
  
−
|-
+
|-  
−
| 08:29
+
| 09:02
−
| This is visible to the right side of each '''Citation''' that was imported.
+
| This is visible to the right side of each '''Citation''' that was imported.  
  
−
|-
+
|-  
−
|  08:35
+
|  09:08
−
|  Now we will confirm whether the titles are added in the '''Catalog '''or not.
+
|  Now, we will confirm whether the titles are added in the '''Catalog '''or not.  
  
−
|-
+
|-  
−
| 08:40
+
| 09:15
−
|  To do so, at the top of the same page, locate the field for '''Search the catalog.'''
+
|  To do so, at the top of the same page, locate the field for '''Search the catalog.'''  
  
−
|-
+
|-  
−
| 08:48
+
| 09:22
−
|  I will now do a small test to confirm the imports of '''records''' into '''Koha'''.
+
|  I will now do a small test to confirm the imports of '''records''' into '''Koha'''.  
  
−
|-
+
|-  
−
| 08:55
+
| 09:29
−
|  So, I will type one of the titles from the imported '''record''' in the '''Citation section'''.
+
|  So, I will type one of the titles from the imported '''record''' in the '''Citation''' section.  
  
−
|-
+
|-  
−
| 09:02
+
| 09:37
−
|  Then, click on the '''Submit''' button at the right side of the '''field'''.
+
|  Then, click on the '''Submit''' button at the right side of the '''field'''.  
  
−
|-
+
|-  
−
|  09:07
+
|  09:43
−
|  A new page opens, '''Inorganic chemistry Housecroft, Catherine E.'''
+
|  A new page opens- '''Inorganic chemistry Housecroft, Catherine E.'''  
  
−
|-
+
|-  
−
|  09:15
+
|  09:50
−
|  '''Koha''' shows the searched '''Title''' result, which proves that '''records''' are imported properly.
+
|  '''Koha''' shows the searched '''Title''' result, which proves that '''records''' are imported properly.  
  
−
|-
+
|-  
−
|  09:22
+
|  09:58
−
|  With this we have completed importing '''MARC '''into''' Koha.'''
+
|  With this, we have completed importing '''MARC '''into''' Koha.'''  
  
−
|-
+
|-  
−
| 09:28
+
| 10:04
−
|  Let us Summarize
+
|  Let us Summarize.
  
−
In this tutorial we learnt to: Import a '''MARC file '''into''' KOHA''' and  Search imported data in''' OPAC'''
+
In this tutorial, we learnt to import a '''MARC file '''into''' KOHA''' and  search imported data in''' OPAC.'''  
  
−
|-
+
|-  
−
| 09:41
+
| 10:17
−
|  For '''Assignment-'''
+
|  For assignment-  
  
−
Use the 10 '''records''' of '''MARC''' that were converted in an earlier tutorial and import them into '''KOHA'''  
+
Use the 10 '''records''' of '''MARC''' that were converted in an earlier tutorial and import them into '''KOHA.'''  
  
−
|-
+
|-  
−
| 09:51
+
| 10:29
−
| '''Hint:''' Please refer to the tutorial, '''Conversion of Excel data to Marc 21 format.'''
+
| Hint: Please refer to the tutorial, '''Conversion of Excel data to Marc 21 format.'''
 +
 +
|-
 +
| 10:37
 +
| The video at the following link summarizes the '''Spoken Tutorial project.'''  
  
−
|-
+
Please download and watch it.  
−
| 09:59
+
−
| The video at the following link summarizes the '''Spoken Tutorial project.'''
+
  
−
Please download and watch it.
+
|-
 +
| 10:45
 +
| The''' Spoken Tutorial Project''' team conducts workshops and gives certificates.  
  
−
|-
+
For more details, please write to us.  
−
| 10:05
+
−
| The''' Spoken Tutorial Project''' Team conducts workshops and gives certificates.
+
  
−
For more details, please write to us.
+
|-
 +
| 10:56
 +
| Please post your timed queries in this forum.  
  
−
|-
+
|-  
−
| 10:13
+
| 10:59
−
| Please post your timed queries in this forum.
+
| '''Spoken Tutorial project''' is funded by '''NMEICT, MHRD''', Government of India.  
  
−
|-
+
More information on this mission is available at this link.  
−
| 10:18
+
−
| '''Spoken Tutorial project''' is funded by '''NMEICT, MHRD, Government of India.'''
+
  
−
More information on this mission is available at this link.
+
|-  
−
 
+
| 11:10
−
|-
+
| This is Bella Tony from '''IIT Bombay''', signing off.  
−
| 10:29
+
−
| This is Bella Tony from IIT Bombay signing off.
+
  
−
Thank you for joining.
+
Thank you for joining.  
  
 
|}
 
|}

Latest revision as of 16:47, 21 February 2019

Time Narration
00:01 Welcome to the Spoken Tutorial on Import MARC file into Koha.
00:07 In this tutorial, we will: learn to import a MARC file into KOHA and

search imported data in OPAC.

00:20 To record this tutorial, I am using: Ubuntu Linux OS 16.04
00:28 Koha version 16.05 and Firefox Web browser.
00:36 You may use any other web browser of your choice.
00:41 To follow this tutorial, learners should be familiar with Library Science.
00:47 To practice this tutorial, You should have Koha installed on your system.

And, You should also have Admin access in Koha.

00:58 If not, please refer to the Koha Spoken Tutorial series on this website.
01:05 Importing records into Koha is done in two steps:

Stage MARC records for import and Manage staged records.

01:18 To begin, let’s login to Koha with our Superlibrarian access.
01:24 On the Home page, click on Tools.
01:28 A new page opens. Under the section Catalog, click on Stage MARC records for import.
01:40 A new page opens with the title Stage MARC records for import.
01:46 Go to the section Stage records into the reservoir.
01:51 Here, click on Browse... adjacent to Select the file to stage.
01:58 A window File Upload opens. Then go to the Downloads folder.
02:06 Here, locate the file named TestData.mrc.
02:12 Recall, we had created TestData.mrc file in one of the earlier tutorial.
02:20 Select the TestData.mrc file, if not already selected.

And, click on the button Open at the bottom of the page.

02:32 On the same page, you will see TestData.mrc as name of the file, adjacent to the tab Browse.
02:43 Now, click on Upload file button at the bottom of the page.
02:49 You will see the Upload progress bar in brown color.
02:55 After the upload is complete up to 100%, we are prompted to fill in some details.
03:03 First, fill the field for Comments about this file.
03:09 This is useful for identifying the uploaded file in KOHA.
03:14 I will enter Book Data.
03:18 Next is Record type. Here, Koha by default, selects Bibliographic.
03:26 Similarly, for Character encoding, Koha by default selects UTF-8 (Default).
03:35 Next, come to the section Look for existing records in catalog?
03:41 Under this section, go to Record matching rule:

Koha by default, selects Do not look for matching records.

03:51 If you want to match existing records, select another option from the drop down i.e. ISBN/ISSN number.
04:04 Now we come to Action if matching record found.
04:09 Koha by default, selects Replace existing record with incoming record.
04:16 Then comes Action if no match is found. Koha by default, selects Add incoming record.
04:25 Next, we come to the section Check for embedded item record data?

There are two options here, Yes and No.

04:37 Koha by default, selects Yes.
04:41 For How to process items, Koha by default, selects Always add items.
04:48 There are other options, as well. You may choose any of these options as per your preference.
04:56 Click on the Stage for import button at the bottom of the page.

You will see “Job progress” in a blue colored bar.

05:06 When the progress is complete up to 100%, a new page opens with the heading Stage MARC records for import.
05:17 Note that now we have successfully imported the data which we had in our Excel sheet.
05:25 It has the following details.
05:28 Note that you will see a different value on your Koha interface as per your .mrc data.
05:36 On this same page, above the title, you will see two options:

Stage MARC records and Manage staged records.

05:48 Note that I will not click on Stage MARC records as I have already imported the Excel file i.e. TestData.
06:00 If you need to import any other file then click on Stage MARC records and follow the steps as mentioned earlier.
06:11 Next, we have to manage the imported records in KOHA Catalog.

So, click on Manage staged records.

06:22 A new window Manage staged MARC records › Batch 6 opens.
06:30 On this page, Koha fills the following fields with the values shown here.
06:37 And for the following fields, Koha by default, selects these entries from the drop down.
06:45 But, you can change these entries from their respective drop-downs as per your requirement.
06:52 Next is the button named Apply different matching rules.
06:57 You may click on this button to avoid the duplication of the records in the database.

I will skip this button and move ahead.

07:09 Now, locate Add new bibliographic records into this framework.

And from the drop down, I will select BOOKS.

07:20 Again, you may select as per your requirement.
07:25 Now, I will click on the tab Import this batch into the catalog .
07:32 However, before clicking we will go through the section Citation.
07:37 Please note the particular numbers.

Note that you will see a different number with the details that we have imported from Excel.

07:48 Now, we will click on the button named Import this batch into the catalog.
07:55 When we do so, the Job progress bar appears.
08:00 When the progress is complete up to 100%, a new page opens
08:06 with the heading Manage staged MARC records › Batch 6 and the following details which were entered earlier.
08:16 It is possible to undo your import. In case, you found a mistake in the imported data, to correct it do the following.
08:27 Click on the tab Undo import into catalog at the bottom of the section.
08:34 I will not click here.
08:37 Next is Completed import of records.
08:42 Here, you will see the details of the records added, updated and so on.
08:49 Then you will see the section Citation with the details that have been imported.
08:56 Once the import is complete, a link to the new Record will appear.
09:02 This is visible to the right side of each Citation that was imported.
09:08 Now, we will confirm whether the titles are added in the Catalog or not.
09:15 To do so, at the top of the same page, locate the field for Search the catalog.
09:22 I will now do a small test to confirm the imports of records into Koha.
09:29 So, I will type one of the titles from the imported record in the Citation section.
09:37 Then, click on the Submit button at the right side of the field.
09:43 A new page opens- Inorganic chemistry Housecroft, Catherine E.
09:50 Koha shows the searched Title result, which proves that records are imported properly.
09:58 With this, we have completed importing MARC into Koha.
10:04 Let us Summarize.

In this tutorial, we learnt to import a MARC file into KOHA and search imported data in OPAC.

10:17 For assignment-

Use the 10 records of MARC that were converted in an earlier tutorial and import them into KOHA.

10:29 Hint: Please refer to the tutorial, Conversion of Excel data to Marc 21 format.
10:37 The video at the following link summarizes the Spoken Tutorial project.

Please download and watch it.

10:45 The Spoken Tutorial Project team conducts workshops and gives certificates.

For more details, please write to us.

10:56 Please post your timed queries in this forum.
10:59 Spoken Tutorial project is funded by NMEICT, MHRD, Government of India.

More information on this mission is available at this link.

11:10 This is Bella Tony from IIT Bombay, signing off.

Thank you for joining.

Contributors and Content Editors

Nancyvarkey, PoojaMoolya, Pratik kamble, Sandhya.np14

Retrieved from "https://script.spoken-tutorial.org/index.php?title=Koha-Library-Management-System/C3/Import-MARC-to-Koha/English-timed&oldid=46065"