This is an old revision of the document!
Uploading MARC Records to OCLC
Prepare Records for upload
-
Keep all default filters as is, and change the following filters to:
Partner Share = “Any”
Availability/Status = “Produced”
Enter the appropriate dates in the "File uploaded between _ and __ fields." For example, if the last record set uploaded to OCLC included records present on Drupal up to January 26, 2019, for the new upload, locate the records uploaded between 2019-01-27 and 2020-01-22 (the date of the export)
Click
Apply
Select all records
You will see the option to select all the records, not just the ones visible on that page, click that button
Click
Generate MARC XML export file
-
Please read the following section to find out how to name the MRC file
Name the MARC File
The filename contains 3 parts, each separated by a period .
:
a 7-digit data sync Collection ID
the OCLC institution symbol CANEL
for NNELS, and
optional alphanumeric characters in upper or lower case to identify a particular upload
For regular upload to update NNELS holdings on OCLC, please use the Collection Records Added to WorldCat
, with the ID 1031295
Add NNELS' OCLC institution symbol CANEL
after the Collection ID
: e.g., 1031295.CANEL
.
And then add the optional third part to identify the records being uploaded, for example, the date of the last record or record set. In this case, the last record set was exported from Drupal on January 22, 2020. So the filename will be: 1031295.CANEL.20200122.mrc
Upload the MARC File
There are two ways to upload MARC files to OCLC, via WorldShare or via SFTP. WorldShare is more user-friendly. However, when problems occur or when the MARC file is larger than 1GB, please try SFTP.
I. Via WorldShare
-
Click Uploads
.
Click Choose File
to retrieve the MARC file from your computer.
Leave File Type
as Data sync bibliographic
.
Click
Upload
, and wait for the file to be uploaded, which may take a while.
Note that once the file is uploaded it can't be changed. The best way to contact OCLC staff about the upload is through the Collection's comment form. Comments can be added at any time:
Go to Collection Manager
.
Choose Data Sync Collection
under Scope
.
Enter the Collection ID under Search Term(s)
.
Click on the
Collection Name
.
Click
Comments
, and a pop-up window will appear.
II. Via SFTP
Download
FileZilla (or you can use other SFTP sites)
-
Information for NNELS: Content Coordinator can provide login
Additional Info
Local System Number (LSN)
Field 001 (which contains the Drupal NID) is used as LSN for OCLC. This field is used by OCLC as the Local System Number (LSN) to produce Unresolved Cross Reference and Bibliographic Cross Reference reports that list each OCLC control number across from the LSN. This information can be used to index the OCLC numbers in our local system. Indexing the OCLC control number links our library's records to other WorldCat services (e.g. WorldCat Discovery).
Check Reports
After the file upload, it will usually take OCLC 48 hours to process it. To check the reports:
-
Go to Metadata > My Files > Downloads > Records and Reports, and choose
Filter by
Reports
If the file has been processed, you will see the reports available for download
-
If there are errors listed in one of the reports, read the following section
Edit Uploaded Records in WorldShare
If there are only a few records with error, it is easy to edit them in WorldShare.
In the following example, there is an error in field 040$b
Note the OCLC call numbers in the report
-
Go to Metadata > Record Manager and enter the OCLC number in
Term(s)
to look for the record
Once the record is retrieved, click Actions
and choose View/Edit Metadata
Go to the corresponding field, in this case 040, and make the correction. In this example, we replace "jap" with "jpn" in subfield $b
When you are done, click Save
and choose Replace Bibliographic Records
Past Uploads
Please keep a record of each upload. Note the filename for preparing next upload. For example, to prepare for the next upload after September 11, 2020, you should follow the filename and export from Drupal the new records added on/after September 4, 2020.
Upload Date | No. of records | Filename | Note |
2019-01-27 | 37,926 | 1031295.CANEL.20190127.mrc | |
2020-01-24 | 1,776 | 1031295.CANEL.20200222.mrc | error in filename, next export starts from Jan. 22, 2020 |
2020-07-24 | 38 | 1031295.CANEL.20200724.mrc | exporter error |
2020-09-11 | 2,391 | 1031295.CANEL.20200904.mrc | |