![Page 1: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/1.jpg)
MarcEdit Basics and Beyond
By Mary AycockHead, Catalog Department
Missouri University of Science and Technology
MOBIUS 2012 Conference
![Page 2: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/2.jpg)
MarcEdit's Many Powers
MarcEdit is a FREE program that allows you to:
Preview and edit MARC records outside ILS
Create spreadsheets of fields from MARC records
Crosswalk records (from MARCXML to MARC or other metadata schemes)
Create MARC records from spreadsheet data
Jumping place to learn about regular expressions, etc. and much more!
Desire to experiment and puzzle it out
![Page 3: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/3.jpg)
Why MarcEdit?
Empowering in current climate (record loads, different metadata schemes) to know possible options
MOBIUS staff very helpful, but have limited time and resources also
Origin: Program conceived in 2000 by Terry Reese, Oregon State University
Updates pushed out regularly to enhance and for bug fixes
![Page 4: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/4.jpg)
Presentation objectives
Overview of MarcEdit's functionality
Demonstration of selected features
Based on a real record set (with some modifications)
Using MARC
Encourage learning/use of program
Pre-conference training at Missouri Library Association Conference
![Page 5: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/5.jpg)
MARC in raw form
![Page 6: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/6.jpg)
MarcBreaker
Converts MARC file into text-based file (.mrk)
Process not intuitive at first glance
Advantage: No need to alter original file
Disadvantage: Have to convert file back into MARC
![Page 7: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/7.jpg)
MarcBreaker Demo1.Select MARC Tools
2. Browse & find MARC file (may not have suffix “.mrc”)
3.Output file name (usually same name with “.mrk” suffix)
4.Execute
5.Will display # of records
6.Select Edit Records to Open in MarcEditor
![Page 8: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/8.jpg)
MarcBreaker
![Page 9: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/9.jpg)
Edit Features, Basic
Find (Ctrl-F)
Simple find (in page)
Find All
Replace (Ctrl-R)
One at a time or replace all (if you're feeling lucky!)
Remember: Special Undo is your friend
Can use regular expressions (advanced)
![Page 10: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/10.jpg)
Find All Demo: Viewing 856
![Page 11: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/11.jpg)
Replace All Demo: Editing 856
![Page 12: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/12.jpg)
Edit Features (Under Tools -->)
Add/Delete field
Copy Field Data
Edit Indicators
Edit Subfield Data
Swap Fields
![Page 13: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/13.jpg)
Add/Delete field: Removing 538
Many paths up the Mountain: Could have also used Replace.
![Page 14: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/14.jpg)
Swap Fields: Moving 505 to 856
![Page 15: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/15.jpg)
Edit Subfield: Deleting invalid oneComputer network resources not used
correctly: “Use as a topical subdivision under subjects for works on computer network resources available for research on those subjects.”
![Page 16: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/16.jpg)
Correcting punctuation using Regular Expression (RegEx)
Regular Expressions can target specific patterns and replace/add strings (punctuation in this case):
![Page 17: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/17.jpg)
Edit Subfield: Adding GMD to 245 (featuring special syntax)
Using [a,p,^c] for subfield:
![Page 18: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/18.jpg)
Other featuresChange Case (HELPFUL FOR UPPERCASE):
Edit → Edit Shortcuts → Change Case
Find Missing Field
Edit → Edit Shortcuts → Field Edits → Find Records Missing Field (Example: 655)
Record Deduplication
Tools → Record Deduplication
Manage Tasks
Tools → Manage Tasks
Handy if you have repeated loads with consistent changes
![Page 19: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/19.jpg)
Generating Record IdentifiersGenerate Control Numbers (such as 001)
Tools → Generate Control Numbers
![Page 20: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/20.jpg)
Generating Call Numbers
Tools →
Generate
Call Numbers
![Page 21: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/21.jpg)
When you're done with the File
Compile back into MARC
File → Compile File into MARC
Better to keep track of all the steps you have done, especially if this will be a periodic load
Recommend not to save under original filename, but create an edited one
![Page 22: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/22.jpg)
Reports in MarcEditor
Field Count Report
Reports-->Field Count
Shows # of records
Can export data
![Page 23: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/23.jpg)
Reports in MarcEditor
Material Type Report
From the 008
![Page 24: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/24.jpg)
Reports in MarcEditorMARCValidator Report (For advanced
users: can edit the validation file in marcrules.txt)
![Page 25: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/25.jpg)
Creating a tab delimited fileOften there are reasons NOT to look at
entire record, such as:
You just want to check a few fields
Ability to use the sorting capability of spreadsheets
You are sending record data to other departments
You need to batchload records in OCLC
![Page 26: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/26.jpg)
Tab delimited file exampleTools → Export Tab Delimited Records
Select File Paths
Select MARC or MARK file in first box
Name your text file in next box
Select field delimiter (this is what will separate each field: will usually select comma)
Select in field delimiter: Defaults to semicolon
![Page 27: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/27.jpg)
Tab delimited file, cont.Select field and click add
Preferable to select subfield
Can delete field from list
Click “Export” when finished
![Page 28: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/28.jpg)
![Page 29: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/29.jpg)
Viewing in a Spreadsheet1 245$a 050$a 856$u
ebook00001 Antennas for base stations in wireless communications /TK7871.6ebook00002 Existing sewer evaluation and rehabilitation / TD719ebook00003 TD770ebook00004 TD442.5ebook00005 TD746ebook00006 Green roof construction and maintenance / SB419.5ebook00007 Manure pathogens TD930.2ebook00008 Organic electronics in sensors and biotechnology /TK7872.D48ebook00009 TJ853.4.O68ebook00010 Alternative energy systems in building design /TK1005ebook00011 TH24.A6ebook00012 Petroleum fuels manufacturing handbook TP355ebook00013 T174.7ebook00014 Handbook of structural steel connection design and details /TA472ebook00015 Harris' shock and vibration handbook TA355ebook00016 TA418.9.N35ebook00017 Advanced MEMS packaging / TK7875ebook00018 Biomedical applications of light scattering / QP82.2.L5ebook00019 Design for six sigma TS156
http://www.loc.gov/catdir/toc/fy1002/2009019119.html;http://ebookprovider.com/browse/antennas-for-base-stations-in-wireless-communicationshttp://ebookprovider.com/browse/existing-sewer-evaluation-and-rehabilitation-wef-manual-of-practice-no-fd-6-asce-ewri-manuals-and-reports-on-engineering-practice-no-62-third-edition
Wastewater solids incineration systems /;Duplicate title testhttp://ebookprovider.com/browse/wastewater-solids-incineration-systems-mop-30Membrane systems for wastewater treatment / http://www.loc.gov/catdir/enhancements/fy0665/2006274699-t.html;http://ebookprovider.com/browse/membrane-systems-for-wastewater-treatmentOperation of municipal wastewater treatment plants http://www.loc.gov/catdir/enhancements/fy0814/2008270152-t.html;http://ebookprovider.com/browse/operation-of-municipal-wastewater-treatment-plants-mop-no-11-sixth-edition
http://ebookprovider.com/browse/green-roof-construction-and-maintenancehttp://ebookprovider.com/browse/manure-pathogens-manure-management-regulations-and-water-quality-protectionhttp://ebookprovider.com/browse/organic-electronics-in-sensors-and-biotechnology
Optofluidics http://ebookprovider.com/browse/optofluidics-fundamentals-devices-and-applicationshttp://ebookprovider.com/browse/alternative-energy-systems-in-building-design
Inside the Civano Project http://ebookprovider.com/browse/inside-the-civano-project-a-case-study-of-large-scale-sustainable-neighborhood-developmenthttp://ebookprovider.com/browse/petroleum-fuels-manufacturing-handbook-including-specialty-products-and-sustainable-manufacturing-techniques
Nanostructuring operations in nanoscale science and engineering /http://ebookprovider.com/browse/nanostructuring-operations-in-nanoscale-science-and-engineeringhttp://ebookprovider.com/browse/handbook-of-structural-steel-connection-design-and-details-second-editionhttp://ebookprovider.com/browse/harris-shock-and-vibration-handbook-sixth-edition
Carbon nanoforms and applications http://ebookprovider.com/browse/carbon-nano-forms-and-applicationshttp://ebookprovider.com/browse/advanced-mems-packaginghttp://ebookprovider.com/browse/biomedical-applications-of-light-scatteringhttp://ebookprovider.com/browse/design-for-six-sigma-a-roadmap-for-product-development-second-edition
![Page 30: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/30.jpg)
Creating MARC file from non-MARC file
Example: OCLC sent a spreadsheet of 12,000+ records in which the holdings would be deleted in a bib reclamation project.
We wanted to double-check that we indeed didn't have these.
Solution: Create MARC file and ask MOBIUS to “load” them into a list, where we can use Millennium to sort, run secondary lists, etc.
![Page 31: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/31.jpg)
Creating MARC file from non-MARC file: Process
Save spreadsheet as tab-delimited text file
Select MARC tools
Input file: Text
Output file: .mrc
Select Function: MarcMaker; Then Execute
Can then Break file to see MARC record
![Page 32: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/32.jpg)
Functions/CrosswalkingVendor provided MARCXML file: Would
like to convert to MARC
Use same interface when “breaking” a file
Select Input file
Select output file
Select Function (MARC21XML to MARC)
![Page 33: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/33.jpg)
Crosswalking: The Result
![Page 34: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/34.jpg)
Batch Process records
If you have a lot of files to process, can do them all at once.
![Page 35: MarcEdit Basics and Beyond By Mary Aycock Head, Catalog Department Missouri University of Science and Technology MOBIUS 2012 Conference](https://reader035.vdocuments.us/reader035/viewer/2022062409/56649e0f5503460f94afa938/html5/thumbnails/35.jpg)
References/Resources
MarcEdit homepage (to download): http://people.oregonstate.edu/~reeset/marcedit/html/index.php
MarcEdit Listserv: http://metis3.gmu.edu/cgi-bin/wa?A0=MARCEDIT-L
Terry Reese's YouTube channel (video demos): http://www.youtube.com/user/tpreese?ob=0