This shows you the differences between two versions of the page.
public:nnels:cataloguing:oclc:upload-marc-to-oclc [2020/09/11 17:51] lilith [Past Uploads] |
public:nnels:cataloguing:oclc:upload-marc-to-oclc [2024/05/09 05:04] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Uploading MARC Records to OCLC ====== | ||
- | =====Prepare Records for upload===== | ||
- | |||
- | - Go to this MARC record set checkout view [[https:// | ||
- | - Keep all default filters as is, and change the following filters to: | ||
- | - Partner Share = “Any” | ||
- | - Availability/ | ||
- | - Enter the appropriate dates in the "File uploaded between ___ and ____ fields." | ||
- | - Click '' | ||
- | - 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 '' | ||
- | - Follow [[public: | ||
- | - 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 '' | ||
- | - the OCLC institution symbol '' | ||
- | - 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 '' | ||
- | - Add NNELS' OCLC institution symbol '' | ||
- | - 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: '' | ||
- | |||
- | =====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==== | ||
- | - On [[https:// | ||
- | - Click '' | ||
- | - Click '' | ||
- | - Leave '' | ||
- | - Click '' | ||
- | |||
- | ---- | ||
- | 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' | ||
- | - Go to '' | ||
- | - Choose '' | ||
- | - Enter the Collection ID under '' | ||
- | - Click on the '' | ||
- | - Click '' | ||
- | |||
- | ====II. Via SFTP==== | ||
- | - Download [[https:// | ||
- | - Follow [[https:// | ||
- | - 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' | ||
- | |||
- | ---- | ||
- | ======Check Reports====== | ||
- | After the file upload, it will usually take OCLC 48 hours to process it. To check the reports: | ||
- | - Log into [[https:// | ||
- | - Go to Metadata > My Files > Downloads > Records and Reports, and choose '' | ||
- | - If the file has been processed, you will see the reports available for download | ||
- | - Download the text files and open them in Excel, consult [[https:// | ||
- | - 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 | ||
- | - Log into [[https:// | ||
- | - Go to Metadata > Record Manager and enter the OCLC number in '' | ||
- | - Once the record is retrieved, click '' | ||
- | - Go to the corresponding field, in this case 040, and make the correction. In this example, we replace " | ||
- | - When you are done, click '' | ||
- | |||
- | |||
- | ---- | ||
- | |||
- | ======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 | ||
- | |2019-01-27 | 37, | ||
- | |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, | ||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||