1-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:
OCLC numbers 100000000 and higher:
OCLC numbers 1000000000 and higher:
| ocm00012345 ocn123456789 on1345345345 |
2-Do a Find All on 035 fields
While the Find all: screen is open
Find the copy icon in the lower left side and click on it
3-Excel
And paste the copied find all text
Clean up the text to just the OCLC number with the search of an asterix in front of it.
Copy the cleaned up column of OCLC nos.
Open Notepad and paste the column in
Save it with an easy to find name
4-CONNEXION
Batch; Enter bibliographic search keys
Import; then find the text file
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:
Select your Save file
Select Online Searches
OK
This will take a few minutes
When OCLC finishes, a summary screen will come up with the results:
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
Might as well go ahead and set our Holdings; Update Holdings
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
Close MarcEditor
5-In MarcEdit’s menu screen, do Tools; Merge Records
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
Next
Click Edit records
Would you look at that: It works!
0 Comments