Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Anchor
topofpage
topofpage
Table of Contents

Table of Contents

...

Get the file from Sierra

Create the file of records you want to replace.  They should all have OCoLC in the 003.

...

Export your 001 fields into a text file.

...

Clean up the file

Delete the header row.

...

Check the file for problem numbers.   These have issues that should be dealt with individuallySearch these in Sierra and fix them individually. Then remove them from the list.

...

Once you have a clean file, go to OCLC and make some changes to Options.

Settings in Connexion

Under the Export tab, you have to choose File or Gateway.  

...

In Options, under the Batch tab, check the box “Bibliographic Record Export.”

...

Apply and Close

...

Clear local save file 

(This is optional, but it will make the process easier)

...

Click Yes.  Now your local save file will be empty.

...

Load OCLC Numbers to Search

Next choose Batch > Enter Bibliographic Search Keys… 

...

Find your text file on your computer.  Click open.

...

Click Save.

...

Click Close.

...

Run Search in Connexion

Select Batch > Process Batch… 

...

You will get a report of the results.

...

Export from Connexion

These titles will now appear in the local save file.  They should be the only thing in the local save file if you cleared the file before this process.

...

then you have to download a file of records to load with Data Exchange.

...

...

Reload in Sierra with Data Exchange

...

Load profile (R) will match on OCLC number, and check for a match in the first five characters of the TITLE field. 

...