Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 12 Next »

For batch files containing 001 fields with a bare OCLC number or that has no useable 001, but does have 035 with OCLC numbers (OCoLC), and if we have access to OCLC Connexion, when working on batch files.

1-MarcEdit

Clean up:

  • Delete any incorrect 001 fields (or 001s without prefixes) using Add/Delete Field

Why we need special treatment:

OCLC 001 number prefixes vary according to length of numbers.

The OCLC control number in field 001 is prefixed by ocm, ocn, or on.

OCLC numbers 1 through 99999999:

  • Have an ocm prefix; need to be padded with zeros 0 to form 8 digits

  • Composed of 8 digits, right justified, with leading zeros as necessary to length

  • Followed by a blank

OCLC numbers 100000000 and higher:

  • Have an ocn prefix

  • Composed of 9 digits

OCLC numbers 1000000000 and higher:

  • Have an on prefix

  • Composed of 10 or more digits

ocm00012345

ocn123456789

on1345345345

2-Do a Find All on 035 fields

  • While the Find all: screen is open

  • image-20240419-185529.png

  • Find the copy icon in the lower left side and click on it

    image-20240419-185616.png

3-Excel

  • And paste the copied find all text

  • image-20240419-185853.png

  • Clean up the text to just the OCLC number with the search of an asterix in front of it.

image-20240419-185948.png

Copy the cleaned up column of OCLC nos.

image-20240419-190043.png

  • Open Notepad and paste the column in

image-20240419-190134.png

  • Save it with an easy to find name

4-CONNEXION

Batch; Enter bibliographic search keys

  • Import; then find the text file

image-20240419-190822.png

  • Save the Search keys: and Close

  • If you have an empty Local Save File, go on to next step, otherwise, stop and create one/or empty one in Local File Manager

  • Batch; Process Batch:

image-20240419-191253.png

  • Select your Save file

  • Select Online Searches

  • OK

  • image-20240419-191416.png

    This will take a few minutes (or longer)

  • When OCLC finishes, a summary screen will come up with the results:

image-20240419-191829.png

  • Do an F3; Return key search of the local save file; select the first bib; scroll to the end and Ctrl-Shift-Click to select entire file

  • …And, might as well go ahead & set our Holdings; Update Holdings

  • Export all those marked records and give it an easy to find name: OCLCforGPOpilot001s

  • File will have the suffix of .dat

MarcEdit

If you do MarcBreaker on it, you will see those lovely prefixed and zero padded as needed field 001s

image-20240419-192553.png

  • Close MarcEditor

5-In MarcEdit’s menu screen, do Tools; Merge Records

  • image-20240419-193023.png

    The record identifier must be 035$a

image-20240429-155243.png

  • Source file: the OCLC records with their proper 001 fields

  • Merge file: the GPO pilot project records (deleted 001s)

  • Save file: the new merged file name

  • Next=>

    • Select the 001 field only; click arrow to send to Merge Fields

    • Next=>

    • image-20240419-193543.png

image-20240419-213155.png

  • Click Edit records

image-20240419-193726.png

  • Would you look at that: It works!

  • No labels