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 9 Next »

In MarcEdit

Clean up:

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

OCLC 001 number prefixes vary according to length:

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

OCLC numbers 1 through 99999999:

  • Have an ocm prefix

  • Composed of 8 digits, right justified, with leading zeros

  • 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

4-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

5-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

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 on 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

  • 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

  • Export and give it an easy to find name: OCLCforGPOpilot001s or similar

  • It will have the suffix of .dat

MarcEdit

If you do MarcBreaker on it, you will see the lovely prefixed 001s

image-20240419-192553.png

  • Close MarcEditor

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

  • image-20240419-193023.png

image-20240419-193356.png

  • Source file: the oclc records

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

  • Save file: the new merged file

  • Next

    • Select the 001 field only

    • Next

    • image-20240419-193543.png

image-20240419-193606.png

Click Edit records

image-20240419-193726.png

  • Would you look at that! It works

  • No labels