Dear Mei,
I did something similar for loading OCLC numbers to our old system. I
would get a tab delimited file from OCLC with 2 columns, but I think a
spreadsheet is very similar. The instructions (based on an earlier version
of MARCedit I am afraid) were:
Use MarcEdit to convert the tab delimited text file to a .mrc file.
Add-ins, Delimited text translator; input file is X.txt, output file
X.mrk. Choose delimiter (Tab, but check the file from OCLC first to be
sure); Select field 0 map to 001 (no indicators), click Apply; Select
field 1, map to 941$a (indicators \\), click Apply; click Finish; should
say Processing file. Check it when it is done, then make it into MARC
.mrc.
Field 0 and field 1 stand for the columns in the file. MARCedit will
create little stub MARC records and supply the LDR, etc.
************
Diana Brooking (206) 685-0389
Cataloging & Germanics Librarian
Suzzallo Library [log in to unmask]
University of Washington
Box 352900
Seattle WA 98195-2900
On Tue, 3 Dec 2013, Hu, Mei wrote:
>
> Knovel doesn?t provide MARC files for deleted titles, only Excel files. Instead of deleting titles one by one in our
> online catalog, I am trying to find out if there?s a way to convert a spreadsheet to MARC so I can use the OCLC numbers
> in the spreadsheet to batch delete records in our catalog once the MARC file is uploaded in Millennium. I saved the
> spreadsheet into a Notepad text file with 2 columns, one for OCLC numbers and one for the status of ?Removed.? Then I
> used the MarcEdit Delimited Text Translator for conversion. I was not sure what to put in the tool. And this is all
> I?ve got below:
>
>
>
> [IMAGE]
>
>
>
> If someone knows how to do the job, would you please share your knowledge with me?
>
>
>
> Thank you!
>
>
>
> Mei X. Hu
>
> Metadata/ILS Librarian, Associate Professor
>
> Volpe Library
>
> Tennessee Technological University
>
> Cookeville, TN 38505
>
> 931-372-3530
>
> [log in to unmask]
>
>
>
> ________________________________________________________________________
>
> This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you
> wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a
> message "SIGNOFF MARCEDIT-L" to [log in to unmask]
>
>
>
________________________________________________________________________
This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]
|