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

From Script | Spoken-Tutorial
Jump to: navigation, search
(Created page with " {| border=1 |Time |Narration |- | 00:02 |Welcome to the '''Spoken Tutorial '''on conversion of''' Excel data '''to''' Marc 21 format.''' |- | 00:09 |In this tutorial, we wi...")
 
m (Protected "Koha-Library-Management-System/C3/Convert-Excel-to-MARC/English-timed" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite)))
 
(6 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 conversion of''' Excel data '''to''' Marc 21 format.'''
  
−
|-
+
|-  
−
| 00:02
+
| 00:09
−
|Welcome to the '''Spoken Tutorial '''on conversion of''' Excel data '''to''' Marc 21 format.'''
+
|In this tutorial, we will learn to convert '''Excel data '''to''' Marc 21 format '''on a '''64-bit Windows '''machine.
  
−
|-
+
|-  
−
| 00:09
+
| 00:19
−
|In this tutorial, we will learn to- Convert '''Excel data '''to''' Marc 21 format '''on a '''64-bit Windows '''machine.
+
|To record this tutorial, I am using: '''Windows 10 Pro''' and 
  
−
|-
+
'''Firefox web browser.'''  
−
| 00:19
+
−
|To record this tutorial, I am using  '''Windows 10 Pro'''
+
  
−
And  '''Firefox web browser'''
+
|-
 +
| 00:29
 +
|To follow this tutorial, learners should be familiar with Library Science.
  
−
|-
+
|-  
−
| 00:27
+
|00:35
−
|To follow this tutorial, learners should be familiar with '''Library Science.'''
+
|Before moving ahead, please ensure that you have the following on your machine-
  
−
|-
+
'''Windows 10, 8 '''or''' 7''',  
−
|00:34
+
−
|Before moving ahead, please ensure that you have the following on your machine-
+
  
−
'''Windows 10, 8 '''or''' 7'''
+
|-
 +
| 00:45
 +
| Any web browser. For eg: '''Internet Explorer, Firefox''' or '''Google Chrome.'''  
  
−
|-
+
|-  
−
| 00:45
+
| 00:53
−
| Any web browser. For eg: '''Internet Explorer, Firefox''' or '''Google Chrome'''
+
| Earlier in the same series, we had installed '''MarcEdit 7 '''on the '''Desktop.'''  
  
−
|-
+
|-  
−
| 00:54
+
| 01:00
−
| Earlier in the same series, we had installed '''MarcEdit 7 '''on the '''Desktop.'''
+
| Open the same '''MarcEdit 7 '''by double-clicking on the icon.  
  
−
|-
+
|-  
−
| 01:01
+
| 01:07
−
| Open the same '''MarcEdit 7 '''by double-clicking on the icon.
+
| A window named '''MarcEdit 7.0.250 By Terry Reese '''opens.  
  
−
|-
+
|-  
−
| 01:07
+
| 01:15
−
| A window named '''MarcEdit 7.0.250 By Terry Reese, '''opens.
+
| Locate and click on the tab '''Export Tab Delimited Text.'''  
  
−
|-
+
|-  
−
| 01:16
+
| 01:21
−
| Locate and click on the tab '''Export Tab Delimited Text.'''
+
| Under the '''Source File''' field, locate the icon for a '''folder.'''  
  
−
|-
+
|-  
−
| 01:21
+
| 01:27
−
| Under the '''Source File field''', locate the icon for a '''folder.'''
+
|The '''source file''' is an '''Excel file''' which we are converting into '''.mrk''' format.
  
−
|-
+
|-  
−
| 01:29
+
| 01:34
−
|The '''source file''' is an '''Excel file''' which we are converting into '''.mrk format.'''
+
| Click on this icon for the '''Folder''' and browse for the '''Excel''' file in the '''field''' for '''File name'''.
  
−
|-
+
|-  
−
| 01:36
+
| 01:42
−
| Click on this icon for the '''Folder''' and browse for the '''Excel file''' in the '''field''' for '''File name'''.
+
| Click on the drop-down adjacent to '''File name.'''  
  
−
|-
+
|-  
−
| 01:45
+
| 01:46
−
| Click on the drop down adjacent to '''File name.'''
+
| If you have''' Microsoft Excel 97/2000/XP/2003 (.xls) '''then choose the format '''Excel File(*.xls).'''  
  
−
|-
+
|-  
−
| 01:49
+
|02:03
−
| If you have''' Microsoft Excel 97/2000/XP/2003 (.xls) '''then choose the format '''Excel File(*.xls).'''
+
| And if you have, '''Microsoft Excel 2007/2010/2013 XML(.xlsx) '''then choose the format '''Excel File(*.xlsx).'''  
  
−
|-
+
|-  
−
|02:05
+
| 02:21
−
| And if you have, '''Microsoft Excel 2007/2010/2013 XML(.xlsx) '''then choose the format '''Excel File(*.xlsx).'''
+
| As I have the '''.(dot)xlsx ''' file, I will select '''Excel XML File(*.xlsx).'''  
  
−
|-
+
|-  
−
| 02:23
+
| 02:32
−
| As I have the '''.(dot)xlsx file, '''I will select '''Excel XML File(*.xlsx).'''
+
| Next, go to the left-side folders and select the folder where your '''Excel file '''is saved.  
  
−
|-
+
|-  
−
| 02:33
+
| 02:40
−
| Next, go to the left-side folders and select the folder where your '''Excel file '''is saved.
+
|I have selected '''Downloads '''because that’s where I saved my '''Excel file'''.  
  
−
|-
+
|-  
−
| 02:41
+
| 02:47
−
|I have selected '''Downloads '''because that’s where I saved my '''Excel file'''.
+
| So, from the '''Downloads''' folder, I have selected '''TestData.xlsx.'''  
  
−
|-
+
|-  
−
| 02:47
+
| 02:55
−
| So, from the '''Downloads''' Folder, I have selected '''TestData.xlsx.'''
+
| When the file '''TestData.xlsx '''is selected, it appears in the '''File name''' field.
  
−
|-
+
|-  
−
| 02:54
+
| 03:04
−
| When the file '''TestData.xlsx '''is selected, it appears in the '''File name field'''.
+
| Now, click on the '''Open '''button at the bottom of the window.  
  
−
|-
+
|-  
−
| 03:04
+
| 03:09
−
| Now, click on the '''Open '''button at the bottom of the window.
+
| The same window re-opens with the '''Source File '''as  '''C:\Users\spoken\Downloads\TestData.xlsx'''.  
  
−
|-
+
|-  
−
| 03:09
+
| 03:21
−
| The same window re-opens with the '''Source File '''as '''C:\Users\spoken\Downloads\TestData.xlsx'''
+
| Now, click on the folder icon adjacent to the '''Output File.'''  
  
−
|-
+
|-  
−
| 03:21
+
| 03:27
−
| Now click on the folder icon adjacent to the '''Output File:'''
+
| On doing so, '''Save File '''window opens prompting us to fill in the '''File name.'''  
  
−
|-
+
|-  
−
| 03:27
+
| 03:34
−
| On doing so, '''Save File '''window opens prompting us to fill in the '''File name:'''
+
| On the same window, I will click on the '''Downloads '''folder located at the left hand side.
  
−
|-
+
And, type the '''File name: '''as '''TestData'''.  
−
| 03:34
+
−
| On the same window, I will click on the '''Downloads '''folder located at the left hand side.
+
  
−
And type the '''File name: '''as '''TestData'''
+
|-
 +
| 03:46
 +
|Now click on '''Save '''button at the bottom of the page.
  
−
|-
+
|-  
−
| 03:45
+
| 03:51
−
|Now click on '''Save '''button at the bottom of the page.
+
| The same window appears again.  
  
−
|-
+
The '''Output file''' field shows: '''C:\Users\spoken\Downloads\TestData.mrk'''.  
−
| 03:50
+
−
| The same window appears again.
+
  
−
The '''Output file field''' shows '''C:\Users\spoken\Downloads\TestData.mrk'''
+
|-
 +
| 04:06
 +
| Note that '''Excel Sheet Name: Sheet1 '''gets selected automatically by '''MarcEdit 7.'''  
  
−
|-
+
However, this '''sheet''' name is editable.  
−
| 04:04
+
−
| Note that '''Excel Sheet Name: Sheet1 '''gets selected automatically by '''MarcEdit 7.'''
+
  
−
However, this sheet name is editable.
+
|-
 +
| 04:20
 +
| Under the Section '''Options,''' the check-box''' UTF-8 Encoded''' is selected by '''MarcEdit 7, '''by default.  
  
−
|-
+
|-  
−
| 04:17
+
| 04:32
−
| Under the Section '''Options'''
+
| Click on the '''Next '''button at the right side of the same window.
  
−
The check-box''' UTF-8 Encoded''' is selected by '''MarcEdit 7, '''by default.
+
|-  
 +
| 04:37
 +
| Again a new window, '''MarcEdit Delimited Text Translator '''opens.  
  
−
|-
+
The heading says '''Data Snapshot.'''  
−
| 04:31
+
−
| Click on the '''Next '''button at the right side of the same window.
+
  
−
|-
+
|-  
−
| 04:36
+
| 04:48
−
| Again a new window, '''MarcEdit Delimited Text Translator, '''opens.
+
| This window will have all the '''field''' details as per entries made in the '''Excel file.'''
  
−
The heading says '''Data Snapshot.'''
+
|-
 +
| 04:55
 +
| We will see the '''Fields''' ranging from '''0 '''to''' 8''' and above with their corresponding values.  
 +
 +
|-
 +
| 05:03
 +
| For example, '''Field 0 '''has a value of '''978-3-319-47238-6 (ISBN)''' on my machine.
  
−
|-
+
|-  
−
| 04:47
+
| 05:17
−
| This window will have all the '''field''' details as per entries made in the '''Excel file.'''
+
| You may see a different value as per your '''Excel sheet.'''  
  
−
|-
+
|-  
−
| 04:53
+
| 05:22
−
| We will see the '''Fields''' ranging from '''0 '''to''' 8''' and above with their corresponding values.
+
| Under the section''' DataSnapshot, '''locate the section '''Settings.'''  
  
−
|-
+
|-  
−
| 05:02
+
| 05:28
−
| For example, '''Field 0 '''has a value of '''978-3-319-47238-6 (ISBN)''' on my machine.
+
|Go to the tab '''Select '''and from the drop-down select '''Field 0.'''  
  
−
|-
+
|-  
−
| 05:15
+
| 05:35
−
| You may see a different value as per your '''Excel sheet.'''
+
|With this we will be doing the '''mapping''' of '''Excel data''' with '''Koha MARC Tags.'''  
  
−
|-
+
|-  
−
| 05:21
+
| 05:43
−
| Under the section''' DataSnapshot, '''locate the section '''Settings.'''
+
| Remember, you can customize '''Map To: '''and '''Indicators.'''  
  
−
|-
+
|-  
−
| 05:26
+
| 05:49
−
|Go to the tab '''Select '''and from the drop down select '''Field 0.'''
+
|However, it is important that the '''Fields '''and '''Subfield Codes '''are as per the '''Koha MARC Tag.'''  
  
−
|-
+
|-  
−
| 05:34
+
| 05:58
−
|With this we will be doing the mapping of '''Excel data''' with '''Koha MARC Tags.'''
+
|For more information on '''MARC Tags, '''visit the link of official '''Library of Congress''' site.
  
−
|-
+
|-  
−
| 05:41
+
| 06:07
−
| Remember: You can customize '''Map To: '''and '''Indicators.'''
+
|On the browser, type this URL and click on '''search'''.  
  
−
|-
+
|-  
−
| 05:46
+
| 06:15
−
|However, it is important that the '''Fields '''and '''Subfield Codes '''are as per the '''Koha MARC Tag.'''
+
| Recall that '''Map To: '''values entered in the field are referred from an earlier tutorial in this series.  
  
−
|-
+
|-  
−
| 05:55
+
| 06:24
−
|For more information on '''MARC Tags '''visit the link of official '''Library of Congress''' site.
+
| I will enter '''020$a '''in the '''Map To:''' field.  
  
−
|-
+
|-  
−
| 06:05
+
| 06:31
−
|On the browser type this URL and click on search
+
|This sequence will change as per your '''Excel data'''.
  
−
|-
+
|-  
−
| 06:12
+
|06:36
−
| Recall that- '''Map To: '''values entered in the '''field,''' are referred from an earlier tutorial in this series.
+
| I will leave '''Indicators: '''and '''Term. Punctuation: '''as they are.  
  
−
So, I will enter '''020$a '''in the '''Map To: field'''.
+
|-
 +
| 06:42
 +
| However, you may fill these fields as directed by the '''Koha MARC Tags.'''  
  
−
|-
+
|-  
−
| 06:26
+
| 06:49
−
|This sequence will change as per your '''Excel data'''.
+
| Next is the check-box for '''Constant Data.'''  
  
−
|-
+
|-  
−
|06:30
+
| 06:54
−
| I will leave '''Indicators: '''and '''Term. Punctuation: '''as they are.
+
|Click this if you wish to '''map''' the same information  into the data field for each entry, in the delimited text document.  
  
−
However, you may fill these''' fields''' as directed by the '''Koha MARC Tags.'''
+
|-
 +
| 07:04
 +
| Click '''Repeatable subfield '''if you want to repeat the same '''subfield'''.
  
−
|-
+
|-  
−
| 06:41
+
| 07:10
−
| Next is the check box for '''Constant Data.'''
+
| Next, click on the button '''Add Argument.'''  
  
−
|-
+
|-  
−
| 06:44
+
−
|Click this if you wish- to map the same information  into the datafield for each entry  in the delimited text document
+
−
 
+
−
|-
+
−
| 06:55
+
−
| Click '''Repeatable subfield '''if you want to repeat the same '''subfield'''.
+
−
 
+
−
|-
+
−
| 07:01
+
−
| Next click on the button '''Add Argument.'''
+
−
 
+
−
On doing so, the value '''0 020$a 0 '''appears in the field under the section '''Arguments.'''
+
−
 
+
−
|-
+
 
| 07:15
 
| 07:15
−
| Similarly let’s map all the other '''fields'''.  
+
|On doing so, the value '''0 020$a 0 '''appears in the field under the section '''Arguments.'''
  
−
|-
+
|-  
−
| 07:19
+
| 07:25
−
|Under the section '''Settings''', Go to '''Select, '''from the drop down select '''Field 1. '''
+
| Similarly, let’s map all the other '''fields'''.  
  
−
|-
+
|-  
−
| 07:27
+
| 07:30
−
| In the '''field''' for '''Map To: '''type '''080$a.'''
+
|Under the section '''Settings''', go to '''Select. '''From the drop- down, select '''Field 1. '''  
  
−
|-
+
|-  
−
| 07:32
+
| 07:39
−
| Now, click on the button''' Add Argument.'''
+
| In the '''field''' for '''Map To, '''type:  '''080$a.'''  
  
−
On doing so, the value '''1 080$a 0 '''appears in the field under the section '''Arguments.'''
+
|-
 +
| 07:46
 +
| Now, click on the button''' Add Argument.'''  
  
−
|-
+
|-  
−
| 07:47
+
| 07:50
−
| Under the tab '''Select, '''from the drop down select '''Field 2.'''
+
| On doing so, the value '''1 080$a 0 '''appears in the field under the section '''Arguments.'''  
  
−
|-
+
|-  
−
| 07:53
+
| 08:01
−
| In the '''field '''for '''Map To: '''type '''100$a '''
+
| Under the tab '''Select, '''from the drop-down, select '''Field 2.'''  
  
−
|-
+
|-  
−
| 07:59
+
| 08:07
−
|In the field for '''Indicators: '''type '''1.'''
+
| In the field for '''Map To, '''type: '''100$a. '''  
  
−
Note that: '''1 '''is the''' first indicator''' of tag '''100''' and it represents the '''Surname '''for the '''subfield ‘a’.'''
+
|-
 +
| 08:13
 +
|In the field for '''Indicators, '''type '''1.'''  
 +
 +
|-
 +
| 08:17
 +
| Note that '''1 '''is the first indicator of '''tag 100''' and it represents the '''Surname '''for the '''subfield ‘a’.'''  
  
−
|-
+
|-  
−
| 08:14
+
−
| Likewise, complete the mapping of all fields upto '''Field 13 '''as being shown in the drop down under '''Select'''.
+
−
 
+
−
|-
+
−
| 08:24
+
−
| Notice the up and down arrows adjacent to each field.
+
−
 
+
−
|-
+
 
| 08:28
 
| 08:28
−
|You may use these to change the sequence of the values that appear.
+
| Likewise, complete the mapping of all the fields up to '''Field 13 '''as being shown in the drop-down under '''Select'''.  
  
−
|-
+
|-  
−
| 08:34
+
| 08:39
−
| Under the section '''Arguments, '''the''' Tags''' that are common with different '''subfields''' need to be joined.
+
| Notice the up and down arrows adjacent to each field.  
  
−
|-
+
|-  
−
| 08:41
+
| 08:44
−
|For that do the following- Select '''Common Tags''' for example '''245$a''' and '''245$c'''.  
+
|You may use these to change the sequence of the values that appear.  
  
−
|-
+
|-  
−
| 08:52
+
| 08:50
−
| Then right-click on '''Common Tags''' and from drop down select '''Join Items'''  
+
| Under the section '''Arguments, '''the''' Tags''' that are common with different '''sub-fields''' need to be joined.
  
−
|-
+
|-  
−
| 09:00
+
| 08:58
−
| This will create a grouping of the '''fields''' that are with the same type.
+
|For that, do the following- Select common tags for example '''245$a''' and '''245$c'''.  
  
−
|-
+
|-  
−
| 09:05
+
| 09:09
−
| Note that the '''<nowiki>* </nowiki>'''(asterisk symbol) will appear before the selected '''Tags.'''
+
| Then right-click on common tags and from drop-down select '''Join Items.'''  
  
−
|-
+
|-  
−
| 09:10
+
| 09:17
−
|The '''<nowiki>* </nowiki>'''asterisk symbol indicates that the common '''tags''' are now joined.
+
| This will create a grouping of the fields that are with the same type.  
  
−
|-
+
|-  
−
| 09:16
+
| 09:23
−
| Alternately, you can do the mapping of '''fields''' by Clicking on the tab '''Auto Generate''' to import the values of respective '''fields''' from 0 to 13 in the '''field''' provided for '''Arguments'''
+
| Note that the '''<nowiki>* </nowiki>'''(asterisk symbol) will appear before the selected '''Tags.'''  
  
−
|-
+
|-  
−
| 09:34
+
| 09:29
−
|However I have done mapping manually, so I will not click '''Auto Generate''' option.
+
|The '''<nowiki>* </nowiki>'''asterisk symbol indicates that the common '''tags''' are now joined.  
  
−
|-
+
|-  
−
| 09:41
+
| 09:35
−
| Next we see four options.
+
| Alternately, you can do the mapping of '''fields''' by clicking on the tab '''Auto Generate''' to '''import''' the values of respective fields from 0 to 13, in the fields provided for '''Arguments.'''
  
−
|-
+
|-  
−
| 09:44
+
−
| First one is '''Save Template'''
+
−
 
+
−
|-
+
−
| 09:47
+
−
|  Use this if you want to save the same '''mapping''' for future use.
+
−
 
+
−
|-
+
 
| 09:52
 
| 09:52
−
| The '''saved template''' will be used if in case you face any problem with data conversion.
+
|However, I have done mapping manually. So, I will not click '''Auto Generate''' option.
 +
 +
|-
 +
| 09:59
 +
| Next we see four options.  
  
−
|-
+
|-  
−
|10:00
+
| 10:02
−
| If we choose the option '''Save Template,''' then, we will be prompted to give it a name and  specify the directory for saving it
+
| First one is '''Save Template.'''  
  
−
|-
+
|-  
−
| 10:10
+
| 10:06
−
|It will get saved as '''.mrd file'''
+
| Use this if you want to save the same '''mapping''' for future use.
  
−
|-
+
|-  
−
| 10:15
+
| 10:12
−
| Access this '''template '''in the future by clicking “'''Load Template” '''at the right side of the window.
+
| The '''saved template''' will be used if in case you face any problem with data conversion.  
  
−
|-
+
|-  
−
| 10:22
+
|10:20
−
| Second option is '''Sort Fields.'''
+
| If we choose the option '''Save Template,''' then we will be prompted to give it a name and  specify the directory for saving it.
  
−
|-
+
|-  
−
| 10:26
+
−
| Third option is''' Calculate common nonfiling data'''.
+
−
 
+
−
|-
+
 
| 10:31
 
| 10:31
−
| Fourth option is''' Ignore Header Row.'''
+
|It will get saved as '''.mrd file'''  
  
−
Click here, if you have a header in the '''Excel sheet '''and if you need to ignore the headings.
+
|-
 +
| 10:36
 +
| Access this '''template '''in the future by clicking “'''Load Template” '''at the right side of the window.  
  
−
|-
+
|-  
−
| 10:41
+
| 10:44
−
| Among these- '''Sort Fields''' and '''Calculate common nonfiling data''' are auto-selected by '''MarcEdit 7.'''
+
| Second option is '''Sort Fields.'''  
  
−
I will leave them as they are.
+
|-
 +
| 10:48
 +
| Third option is''' Calculate common nonfiling data'''.  
  
−
|-
+
|-  
−
| 10:53
+
| 10:54
−
| Now, I will check the check-box for '''Save Template '''and''' Ignore Header Row.'''
+
| Fourth option is''' Ignore Header Row.'''  
  
 
|-
 
|-
−
| 11:00
+
|10:58
−
| Next, locate and click on the tab '''Finish''' on the top right corner of the page.
+
|Click here, if you have a header in the '''Excel sheet '''and if you need to ignore the headings.  
  
−
|-
+
|-  
−
| 11:07
+
| 11:05
−
| On doing so, '''Save File '''window opens, prompting us to fill in the '''File name:'''
+
| Among these, '''Sort Fields''' and '''Calculate common nonfiling data''' are auto-selected by '''MarcEdit 7.'''  
  
 
|-
 
|-
−
| 11:14
+
|11:15
−
| On the same window, I will click on the '''Downloads '''folder located at the left hand side.
+
|I will leave them as they are.  
  
−
And in the '''field''' for '''File name: '''I will type '''TestData'''
+
|-
 +
| 11:18
 +
| Now, I will check the check-box for '''Save Template '''and''' Ignore Header Row.'''  
  
−
|-
+
|-  
−
| 11:27
+
| 11:26
−
| Now click on '''Save '''button at the bottom of the page.
+
| Next, locate and click on the tab '''Finish''' on the top right corner of the page.  
  
−
|-
+
|-  
−
|11:32
+
| 11:34
−
| A pop-up window with the message: '''Process has been finished. Records saved to:'''
+
| On doing so, '''Save File '''window opens, prompting us to fill in the '''File name.'''  
  
−
'''C:\Users\Spoken\Download\TestData.mrk '''opens
+
|-
 +
| 11:41
 +
| On the same window, I will click on the '''Downloads '''folder, located at the left hand side.
  
 
|-
 
|-
−
| 11:45
+
|11:48
−
| Click on the '''Ok '''button at bottom of this dialog box.
+
|And, in the '''field''' for '''File name, '''I will type '''TestData.'''
  
−
|-
+
|-  
−
| 11:50
+
| 11:54
−
| With this''' .mrk file '''has been successfully saved in the directed location which is the '''Downloads''' folder.
+
| Now, click on '''Save '''button at the bottom of the page.  
  
−
|-
+
|-  
−
| 11:59
+
|11:59
−
| A new page''' MarcEdit 7.0.250 By Terry Reese, '''opens.
+
| A pop-up window with the message: '''Process has been finished. Records saved to:'''  
  
−
Locate and click on the icon '''MarcEditor'''.
+
'''C:\Users\Spoken\Download\TestData.mrk '''opens.  
  
−
|-
+
|-  
−
| 12:11
+
| 12:14
−
| A new page '''MarcEditor''' opens.
+
| Click on the '''Ok '''button at the bottom of this dialog-box.  
  
−
On the main '''Menu''' click on '''File''' and from the drop down select '''Open'''.
+
|-
 +
| 12:19
 +
| With this,''' .mrk file '''has been successfully saved in the directed location which is the '''Downloads''' folder.  
  
−
|-
+
|-  
−
| 12:24
+
| 12:29
−
| A window, '''Open File''' opens showing''' TestData.mrk '''file.
+
| A new page''' MarcEdit 7.0.250 By Terry Reese, '''opens.  
  
−
|-
+
Locate and click on the icon '''MarcEditor'''.  
−
| 12:30
+
−
| Click and select the '''TestData.mrk '''file.
+
  
−
It will show in the field for''' File name.'''
+
|-
 +
| 12:42
 +
| A new page '''MarcEditor''' opens.
  
−
|-
+
On the main '''Menu,''' click on '''File''' and from the drop- down select '''Open'''.  
−
| 12:39
+
−
| Now click on '''Open''' at the bottom of the window.
+
  
−
|-
+
|-  
−
| 12:44
+
| 12:55
−
| Another window '''MarcEditor: TestData.mrk''' opens with all the details.
+
| A window '''Open File''' opens showing''' TestData.mrk '''file.
 +
 +
|-
 +
| 13:02
 +
| Click and select the '''TestData.mrk '''file.  
  
 
|-
 
|-
−
| 12:51
+
|13:07
−
| On the same window, from the main menu, click on the '''File'''.
+
|It will show in the field for''' File name.'''  
  
−
|-
+
|-  
−
| 12:56
+
| 13:11
−
|Now, from the drop down select '''Compile File into MARC.'''
+
| Now click on '''Open''' at the bottom of the window.
  
−
|-
+
|-  
−
| 13:02
+
| 13:16
−
| Another new window '''Save File''', opens.
+
| Another window '''MarcEditor: TestData.mrk''' opens with all the details.  
  
−
Here locate '''File Name: '''and type the appropriate name in the '''field'''.
+
|-
 +
| 13:24
 +
| On the same window, from the main menu, click on the '''File'''.  
  
−
|-
+
|-  
−
| 13:11
+
| 13:29
−
|I will type '''TestData.'''
+
|Now, from the drop-down select '''Compile File into MARC.'''  
  
−
|-
+
|-  
−
| 13:16
+
| 13:35
−
| '''Koha '''by default, selects '''MARC Files (*.mrc) '''in the '''field Save as type:'''
+
| Another new window '''Save File''' opens.  
  
−
|-
+
|-  
−
| 13:25
+
| 13:39
−
| Now click on the '''Save '''button located at the bottom of the window.  
+
|Here, locate '''File Name: '''and type the appropriate name in the '''field'''.  
  
−
|-
+
|-  
−
| 13:30
+
| 13:46
−
| Upon doing so, on the same window at the bottom, you will see '''5 records processed in 0.166228 seconds'''.
+
|I will type '''TestData.'''  
  
−
|-
+
|-  
−
| 13:42
+
| 13:50
−
|This is because I imported only '''5 records'''. You will see a different number of '''records''' and processed time as per your data.
+
| '''Koha, '''by default, selects '''MARC Files (*.mrc) '''in the field '''Save as type:'''.  
  
−
|-
+
|-  
−
| 13:52
+
−
| With this we have converted '''Excel data '''of our library into''' Marc 21 format '''successfully.
+
−
 
+
−
|-
+
 
| 14:00
 
| 14:00
−
|'''Marc 21 format '''is the standard '''format''' used in '''Koha''' for '''cataloging''' and importing '''data''' into '''Koha'''.
+
| Now, click on the '''Save '''button located at the bottom of the window.  
  
−
|-
+
|-  
−
| 14:09
+
| 14:06
−
| Now close this window. To do so, go to the top right corner and click on the '''Close''' button.
+
| Upon doing so, on the same window at the bottom, you will see '''5 records processed in 0.166228 seconds'''.  
  
−
|-
+
|-  
 
| 14:19
 
| 14:19
−
| Let us summarize. In this tutorial, we have learnt to- Convert '''Excel data '''to''' Marc 21 format '''on a '''64-bit Windows '''machine.
+
|This is because I imported only '''5 records'''. You will see a different number of '''records''' and processed time as per your data.  
  
−
|-
+
|-  
−
| 14:30
+
| 14:29
−
| '''Assignment'''
+
| With this, we have converted '''Excel data '''of our library into''' Marc 21 format '''successfully.
  
−
Prepare a list of 10 '''records''' in '''Excel''' and convert those records into '''MARC '''by using '''MarcEdit 7.'''
+
|-
 +
| 14:37
 +
|'''Marc 21 format '''is the standard format used in '''Koha''' for cataloging and importing data into '''Koha'''.  
  
−
|-
+
|-  
−
| 14:41
+
| 14:46
−
| The video at the following link summarizes the '''Spoken Tutorial project.'''
+
| Now, close this window. To do so, go to the top right corner and click on the '''Close''' button.
  
−
Please download and watch it.
+
|-
 +
| 14:55
 +
| Let us summarize. In this tutorial, we have learnt to- convert '''Excel data '''to''' Marc 21 format '''on a '''64-bit Windows '''machine.  
  
−
|-
+
|-  
−
| 14:47
+
| 15:08
−
| The''' Spoken Tutorial Project''' Team conducts workshops and gives certificates.
+
| Assignment:
  
−
For more details, please write to us.
+
Prepare a list of 10 '''records''' in '''Excel''' and convert those records into '''MARC '''by using '''MarcEdit 7.'''
  
−
|-
+
|-  
−
||14:55
+
| 15:20
−
|| Please post your timed queries in this forum.
+
| The video at the following link summarizes the '''Spoken Tutorial project.'''
  
−
|-
+
Please download and watch it.  
−
| 14:59
+
−
| '''Spoken Tutorial project''' is funded by '''NMEICT, MHRD, Government of India.'''
+
  
−
More information on this mission is available at this link.
+
|-
 +
|  15:27
 +
|  The''' Spoken Tutorial Project''' team conducts workshops and gives certificates.
 +
 
 +
For more details, please write to us.
 +
 
 +
|-
 +
||15:35
 +
|| Please post your timed queries in this forum.
 +
 
 +
|-
 +
| 15:39
 +
| '''Spoken Tutorial project''' is funded by '''NMEICT, MHRD''', Government of India.  
  
 
|-
 
|-
−
| 15:09
+
|15:45
−
| This is Bella Tony from '''IIT Bombay '''signing off.
+
|More information on this mission is available at this link.
 +
 
 +
|-
 +
| 15:50
 +
| 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 conversion of Excel data to Marc 21 format.
00:09 In this tutorial, we will learn to convert Excel data to Marc 21 format on a 64-bit Windows machine.
00:19 To record this tutorial, I am using: Windows 10 Pro and

Firefox web browser.

00:29 To follow this tutorial, learners should be familiar with Library Science.
00:35 Before moving ahead, please ensure that you have the following on your machine-

Windows 10, 8 or 7,

00:45 Any web browser. For eg: Internet Explorer, Firefox or Google Chrome.
00:53 Earlier in the same series, we had installed MarcEdit 7 on the Desktop.
01:00 Open the same MarcEdit 7 by double-clicking on the icon.
01:07 A window named MarcEdit 7.0.250 By Terry Reese opens.
01:15 Locate and click on the tab Export Tab Delimited Text.
01:21 Under the Source File field, locate the icon for a folder.
01:27 The source file is an Excel file which we are converting into .mrk format.
01:34 Click on this icon for the Folder and browse for the Excel file in the field for File name.
01:42 Click on the drop-down adjacent to File name.
01:46 If you have Microsoft Excel 97/2000/XP/2003 (.xls) then choose the format Excel File(*.xls).
02:03 And if you have, Microsoft Excel 2007/2010/2013 XML(.xlsx) then choose the format Excel File(*.xlsx).
02:21 As I have the .(dot)xlsx file, I will select Excel XML File(*.xlsx).
02:32 Next, go to the left-side folders and select the folder where your Excel file is saved.
02:40 I have selected Downloads because that’s where I saved my Excel file.
02:47 So, from the Downloads folder, I have selected TestData.xlsx.
02:55 When the file TestData.xlsx is selected, it appears in the File name field.
03:04 Now, click on the Open button at the bottom of the window.
03:09 The same window re-opens with the Source File as C:\Users\spoken\Downloads\TestData.xlsx.
03:21 Now, click on the folder icon adjacent to the Output File.
03:27 On doing so, Save File window opens prompting us to fill in the File name.
03:34 On the same window, I will click on the Downloads folder located at the left hand side.

And, type the File name: as TestData.

03:46 Now click on Save button at the bottom of the page.
03:51 The same window appears again.

The Output file field shows: C:\Users\spoken\Downloads\TestData.mrk.

04:06 Note that Excel Sheet Name: Sheet1 gets selected automatically by MarcEdit 7.

However, this sheet name is editable.

04:20 Under the Section Options, the check-box UTF-8 Encoded is selected by MarcEdit 7, by default.
04:32 Click on the Next button at the right side of the same window.
04:37 Again a new window, MarcEdit Delimited Text Translator opens.

The heading says Data Snapshot.

04:48 This window will have all the field details as per entries made in the Excel file.
04:55 We will see the Fields ranging from 0 to 8 and above with their corresponding values.
05:03 For example, Field 0 has a value of 978-3-319-47238-6 (ISBN) on my machine.
05:17 You may see a different value as per your Excel sheet.
05:22 Under the section DataSnapshot, locate the section Settings.
05:28 Go to the tab Select and from the drop-down select Field 0.
05:35 With this we will be doing the mapping of Excel data with Koha MARC Tags.
05:43 Remember, you can customize Map To: and Indicators.
05:49 However, it is important that the Fields and Subfield Codes are as per the Koha MARC Tag.
05:58 For more information on MARC Tags, visit the link of official Library of Congress site.
06:07 On the browser, type this URL and click on search.
06:15 Recall that Map To: values entered in the field are referred from an earlier tutorial in this series.
06:24 I will enter 020$a in the Map To: field.
06:31 This sequence will change as per your Excel data.
06:36 I will leave Indicators: and Term. Punctuation: as they are.
06:42 However, you may fill these fields as directed by the Koha MARC Tags.
06:49 Next is the check-box for Constant Data.
06:54 Click this if you wish to map the same information into the data field for each entry, in the delimited text document.
07:04 Click Repeatable subfield if you want to repeat the same subfield.
07:10 Next, click on the button Add Argument.
07:15 On doing so, the value 0 020$a 0 appears in the field under the section Arguments.
07:25 Similarly, let’s map all the other fields.
07:30 Under the section Settings, go to Select. From the drop- down, select Field 1.
07:39 In the field for Map To, type: 080$a.
07:46 Now, click on the button Add Argument.
07:50 On doing so, the value 1 080$a 0 appears in the field under the section Arguments.
08:01 Under the tab Select, from the drop-down, select Field 2.
08:07 In the field for Map To, type: 100$a.
08:13 In the field for Indicators, type 1.
08:17 Note that 1 is the first indicator of tag 100 and it represents the Surname for the subfield ‘a’.
08:28 Likewise, complete the mapping of all the fields up to Field 13 as being shown in the drop-down under Select.
08:39 Notice the up and down arrows adjacent to each field.
08:44 You may use these to change the sequence of the values that appear.
08:50 Under the section Arguments, the Tags that are common with different sub-fields need to be joined.
08:58 For that, do the following- Select common tags for example 245$a and 245$c.
09:09 Then right-click on common tags and from drop-down select Join Items.
09:17 This will create a grouping of the fields that are with the same type.
09:23 Note that the * (asterisk symbol) will appear before the selected Tags.
09:29 The * asterisk symbol indicates that the common tags are now joined.
09:35 Alternately, you can do the mapping of fields by clicking on the tab Auto Generate to import the values of respective fields from 0 to 13, in the fields provided for Arguments.
09:52 However, I have done mapping manually. So, I will not click Auto Generate option.
09:59 Next we see four options.
10:02 First one is Save Template.
10:06 Use this if you want to save the same mapping for future use.
10:12 The saved template will be used if in case you face any problem with data conversion.
10:20 If we choose the option Save Template, then we will be prompted to give it a name and specify the directory for saving it.
10:31 It will get saved as .mrd file
10:36 Access this template in the future by clicking “Load Template” at the right side of the window.
10:44 Second option is Sort Fields.
10:48 Third option is Calculate common nonfiling data.
10:54 Fourth option is Ignore Header Row.
10:58 Click here, if you have a header in the Excel sheet and if you need to ignore the headings.
11:05 Among these, Sort Fields and Calculate common nonfiling data are auto-selected by MarcEdit 7.
11:15 I will leave them as they are.
11:18 Now, I will check the check-box for Save Template and Ignore Header Row.
11:26 Next, locate and click on the tab Finish on the top right corner of the page.
11:34 On doing so, Save File window opens, prompting us to fill in the File name.
11:41 On the same window, I will click on the Downloads folder, located at the left hand side.
11:48 And, in the field for File name, I will type TestData.
11:54 Now, click on Save button at the bottom of the page.
11:59 A pop-up window with the message: Process has been finished. Records saved to:

C:\Users\Spoken\Download\TestData.mrk opens.

12:14 Click on the Ok button at the bottom of this dialog-box.
12:19 With this, .mrk file has been successfully saved in the directed location which is the Downloads folder.
12:29 A new page MarcEdit 7.0.250 By Terry Reese, opens.

Locate and click on the icon MarcEditor.

12:42 A new page MarcEditor opens.

On the main Menu, click on File and from the drop- down select Open.

12:55 A window Open File opens showing TestData.mrk file.
13:02 Click and select the TestData.mrk file.
13:07 It will show in the field for File name.
13:11 Now click on Open at the bottom of the window.
13:16 Another window MarcEditor: TestData.mrk opens with all the details.
13:24 On the same window, from the main menu, click on the File.
13:29 Now, from the drop-down select Compile File into MARC.
13:35 Another new window Save File opens.
13:39 Here, locate File Name: and type the appropriate name in the field.
13:46 I will type TestData.
13:50 Koha, by default, selects MARC Files (*.mrc) in the field Save as type:.
14:00 Now, click on the Save button located at the bottom of the window.
14:06 Upon doing so, on the same window at the bottom, you will see 5 records processed in 0.166228 seconds.
14:19 This is because I imported only 5 records. You will see a different number of records and processed time as per your data.
14:29 With this, we have converted Excel data of our library into Marc 21 format successfully.
14:37 Marc 21 format is the standard format used in Koha for cataloging and importing data into Koha.
14:46 Now, close this window. To do so, go to the top right corner and click on the Close button.
14:55 Let us summarize. In this tutorial, we have learnt to- convert Excel data to Marc 21 format on a 64-bit Windows machine.
15:08 Assignment:

Prepare a list of 10 records in Excel and convert those records into MARC by using MarcEdit 7.

15:20 The video at the following link summarizes the Spoken Tutorial project.

Please download and watch it.

15:27 The Spoken Tutorial Project team conducts workshops and gives certificates.

For more details, please write to us.

15:35 Please post your timed queries in this forum.
15:39 Spoken Tutorial project is funded by NMEICT, MHRD, Government of India.
15:45 More information on this mission is available at this link.
15:50 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/Convert-Excel-to-MARC/English-timed&oldid=46063"