MARCEdit

Many libraries like to use MarcEdit for modifications or data clean up. If you’d like to do this, download MarcEdit from http://marcedit.reeset.net/
Important: Many of the actions described on this page can be done in Koha using MARC modification templates, but this section is here for those who are used to MarcEdit.
__TOC__
==Adding a prefix to call numbers==
To add or replace text at the start of a call number, before importing you data into Koha:
Step	Action 	Screenshot
1. 	Open MarcEdit. 	
2. 	Select MarcEditor. 	
3. 	Select Tools > Edit Subfield Data.	
4. 	To add data to the start of the call number (prepend):  
* select 952 from the Field dropdown list
* enter o in the Subfield text box
* add the special character ^b to the Field Data text box
* enter the data to add to the start of the call number in the Replace with text box, for example, FIC
* click Replace Text
Note: Koha uses 952 to record item data.	
5. 	To replace existing data at the start of the call number:
* add ^b[string to replace] to the Field Data text box, for example, ^b[FIC]
* enter the replacement text in the Replace with text box, for example, NFIC
* click Replace Text	[Screenshot required]
== Change title (245) indicators in MarcEdit ==
To reflect author (1xx) fields and articles (A, An, The) at the beginning of the title
Note: If you don't change the second indicator for the articles then you will need to repeat ** for each set of 245 indicators. 
Step	Action 	Screenshot
1. 	Change all 245 field indicators to 00
Note: All the indicators need to be uniform so that when you start changing them to the when you select the records with authors the ones remaining are already correct with the first indicator 0.	
2. 	Select records for edit 	
3. 	Search 100, Import File 	
4. 	Selecting records to edit: 
A ) Select “Does not match”, 
B ) Select "Invert Selections'"
Note: This allows you to select records with authors.
If you made all the first indicators 1 at the beginning, you would only need to click on 'does not match'
C) Export Selected	
5. 	You will be taken to a new screen that only contains records you selected, you are now ready to 'Change 245 field indicators from 00 to 10.	
This is not finished yet.
== Importing spreadsheet data into Koha==
Suppose you have records of your library in a spreadsheet data format (e.g., comma-delimited) and want to import them into Koha. But how will you do this? Koha will not let you import spreadsheet data format records directly. There is a very simple solution for you which will let you import your spreasheet data records in Koha easily. First, we will convert the spreadsheet file into a MARC file and then will import it into Koha, by following these steps. (For more information on the MARC bibliographic record format, see the Library of Congress' MARC21 Bibliographic website.)
*Converting from Excel format into .mrk format using MARCEdit by opening it and selecting Add-ins >Delimited Text Translator:
*The following window will appear; select Next:
*Browse for your spreadsheet file:
*Locate your spreadsheet file; e.g., for an Excel file, choose the format Excel File(*.xls):
*Similarly, fill all the other entries such as Output File, Excel Sheet Name and check UTF-8 Encoded (if required) and select Next:
*Now you will be prompted for mapping the spreadsheet fields to MARC fields, e.g., suppose for Field 0 (first column in our example) we map to: 022$a (Valid ISSN for the continuing resource), then we select Apply. You can customize indicators, etc.:
*Similarly map all other fields and then Click on Finish:
*A window will appear indicating that your Marc Text File(*.mrk) has been created:
*Select Close, and you will have created your MARC file, and can browse to view it. The next step is to convert the .mrk file that we have created in the above step into raw MARC format that can be directly imported into Koha. For this step, open MarcEdit and Select MARC Tools:
*Next Select MarcMaker to convert .mrk file into .mrc format:
*Locate the .mrk file that we created in the above steps, and name your output file. Then select Execute:
*When finished, it will show you the result:
*Select Close, and now we have raw MARC bibliographic records as an .mrc file. The next step is to Stage MARC Records for Import, using your created .mrc file.
Category:Documentation