Overview

Discover an overview of the ongoing delete local holdings records collection in WorldShare Collection Manager.

Expand section

Overview

Data synchronization is an automated process that compares records from your local catalog against records in WorldCat and manages holdings on those matching records. These holdings may be at the institution-level, such as your OCLC symbol, or at the local-level, such as local holdings records (LHRs). This process also facilitates adding new records to WorldCat.

Create a delete local holdings records collection to dlete loca holdings records (LHRs) by providing MFHD data.

Image of the data sync workflow

How to use this guide

This interactive learning path allows you to:

  • Navigate linearly: Work through each section in order using the sidebar navigation
  • Jump to specific topics: Click any section in the sidebar to go directly to that content
  • Expand/collapse sections: Use the buttons at the top to expand or collapse all sections at once
  • Search within the page: Use Ctrl+F (or Cmd+F on Mac) to find specific information
  • Track your progress: The progress indicator shows how many sections you've viewed

Navigate to Settings

Institution settings apply across all your collections. Use caution when changing existing settings as the changes might impact other collections. Please remember to click Save after you select settings. If your session times out, you could lose your work.

Navigate to the institution settings:

  1. Sign in to the WorldShare interface at your library's WorldShare URL. Replace yourlibrary with your library's identifier: https://yourlibrary.share.worldcat.org/wms
  2. Navigate to Metadata > Collection Manager > Institution Settings.

Configure the following settings

  1. OCLC Symbol
Verify that your OCLC Symbol is selected

Use the OCLC Symbol setting to verify that your institution's OCLC symbol is selected. Collection Manager uses the symbol displayed here to maintain WorldCat holdings and to output records.

  1. Reports
Enable emailed reports

If you enable reports in Institution Settings > Reports,  reports will be available via email around the time when files of records have been output and/or after there are changes to your holdings in WorldCat. When your first report is available, you will get an email from Usage_Statistics@oclc.org with the subject field: "The report [name of report] you requested for [YYYYMMDD]."

You will not receive an email on days when there is no activity. Reports are also available in the OCLC Usage Statistics Portal and they are identical to the reports that come by email. See how to access reports in the OCLC Usage Statistics Portal.

To receive emailed reports:

  1. Navigate to Institution Settings > Reports.
  2. Select Yes to Receive Email Reports.
  3. Enter your cataloging authorization or an admin code. This is a 9-digit number starting with 100. Only one authorization code is needed per institution.
  4. Expand and select the Report Types you want to receive.
  5. Enter the Email Address(es) the reports will be sent to. If you are adding more than one email address, separate each email address with a semi-colon (;). Do not put a space before or after the semi-colon (;) separating the email addresses.
  6. Modify the Report Format if needed. Options include:
    • HTML
    • Excel
  7. Modify the Receive as settings if needed. Options include:
    • Email Attachment
      • Users will receive the report as an attachment in the format specified above.
    • Hyperlink
      • Users will receive a hyperlink to the OCLC Usage Statistics page. 
  8. Click Save.

  There is not a way to select only certain reports per email. The email address(es) entered will receive all selected reports.

  Many libraries that have collections that output records on an ongoing basis select the Updated Records report. The report will notify you of critical changes like OCLC number merges and the reason you received an updated record even if you have not enabled WorldCat updates.

For a complete list and details about institution settings, see Collection Manager Institution settings. 

Create a delete local holdings records collection to delete local holdings records (LHRs) by providing the following MFHD data.

 Caution: When entering text into text fields (e.g., Comment, Description, etc.):

  • Do not add new lines. All text needs to be in one paragraph.
  • Do not copy and paste text from Microsoft Word, email, a web browser, or other sources. Pasted text can contain hidden formatting codes.

 Note:

  • You cannot delete a collection once it has been saved and/or submitted.
  • If you have questions while creating your collection, you can:

Create the collection

  1. Navigate to the WorldShare interface > Metadata tab > Collection Manager.
  2. Click Create a Collection.
  3. Select Data Sync Collection from the Collection Type drop-down list.
  4. Select Delete Local Holdings Records from the Data Sync Type drop-down list.
     Note: If you have already created this type of WorldCat data sync collection, the following warning will appear:
    An existing WorldCat Data Synchronization collection of this same type already exists. We recommend editing this existing collection; however, you can create a secondary collection type of the same type.
    Generally, you will configure one collection for each type of data to be sent, making it easier to manage the process and maintain up-to-date holdings in WorldCat.
  5. Click Create. The accordions for this collection appear.

Complete the Properties accordion

The Properties accordion must be completed before you can save your progress when creating a collection.

  1. Enter a Collection Name for your collection.
  2. Select whether you are part of a Group. Only select Yes if you will be sending data for multiple institutions to be processed under this collection. If you select Yes, be sure to use the OCLC symbol/WorldShare instance for your group when creating a collection. If you do not have an OCLC group symbol, contact OCLC Customer Support for assistance.
     Note: WMS libraries can create bibliographic, bibliographic and local holdings records, and delete WorldCat holdings collections for a group. All other institutions can create bibliographic and delete WorldCat holdings collections for a group.
  3. Enter the Third Party/Consortia Name if a vendor is sending data for your library or your library is part of a consortia.
  4. Select the Original Data Format of your files.
    1. MARC
    2. Non-MARC
       Note: If Non-MARC is selected, you must send a .CSV or .TXT file with additional data to create MARC records for processing.
  5. Select whether you would like to Remove WorldCat Holding When Final LHR Deleted.
  6. (Optional). Enter a Description for the collection. The description field should be used anytime there is an exception or special consideration with your collection (e.g., setting up a collection to use OCLC number matching only). The exception or special condition should also be added as a comment in the Comments accordion.
  7. Click Save.
     Note: The first time you click Save, a Collection ID is generated. The Collection ID is a unique 7-digit number assigned to your data sync collection that is used

Complete the Local Holdings Records Information accordion

  1. Click Local Holdings Records Information to open the accordion.

 Note: When selecting multiple locations, use the Add button (Add button) to create additional rows.

Complete the MFHD tab

  1. For Initial Estimate for Record Count, enter the number of records that will be sent in the first file in the Initial Estimate of Record field.
  2. For System Information:
    • Enter the Provider.
    • Enter the System Name.
    • Enter the Version.
  3. For OCLC Number Location, select the location in your records from the drop-down list.
  4. For Local System Holdings Record Number Location(s), select the location(s) in your records from the drop-down list.
  5. For Local System Bibliographic Record Number Location(s), select the location(s) in your records from the drop-down list. List locations in order of priority.
  6. Click Save.

Complete the Processing tab

  1. If applicable, enter the location (Tag, Subfield, or Indicator) and the value that appears in that location to identify records or fields to exclude from processing in the Excluded Information field.
     Note: 
    • When excluded information is encountered in the Fixed Field, the entire record will be excluded from setting/cancelling holdings.
    • When excluded information is encountered in the Leader or Fixed Field (tag 008), the entire record will be excluded from setting/cancelling holdings. Other control tags have the additional option to just exclude the field that is identified.
  2. Click Save.

Complete the Comments accordion

The Comments accordion appears after you save your collection for the first time. It allows you to communicate with the database specialist assigned to your collection.

  • A database specialist is assigned to your project after you submit a file for review.
  • Database specialists can also communicate with you about your collection using the Comments accordion.

 Note: You would only complete the Comments accordion while creating a collection if you have a question or need to convey information not addressed in the collection.

Click Comments to open the accordion.

Add a comment to the list

  1. Click Add Comment. The Add Comment window opens.
  2. Enter a Topic for your comment.
  3. Enter a Comment about your collection.
  4. Click Add Comment to save your comment to the list. An OCLC staff member will respond to your comment in the Comments accordion, using the same Topic. Check the Comments accordion after 24-48 hours, as you will not receive an email when a staff member responds.
     Note: Once you have added your comment to the list, it cannot be edited or deleted.

View a comment in the list

  1. Click the Topic of the comment you wish to view.
  2. Click Cancel to return to the comment list.

Complete the Contact Information accordion

The information entered in the Contact Information accordion is required so that OCLC staff can contact you with questions about your collection. You must add a contact before your collection can be submitted.

  1. Click Contact Information to open the accordion.
  2. Enter the contact's Last Name.
  3. Enter the contact's First Name.
  4. Enter the contact's Title.
  5. Enter the contact's Telephone number and Email Address.
  6. Click Save.
     Note: When adding multiple contacts, use the Add button (Add button) to create additional rows. List contacts in order of priority.

Submit your collection

  1. Select Submit Collection to OCLC from the Collection Actions drop-down menu.
     Note: You cannot delete a collection once it has been saved and/or submitted.

LHR data sync will process MFHD records that contain, at a minimum, a valid OCLC control number and enough information to successfully translate local location codes into valid OCLC institution symbol and holding library code combinations in 852 ‡a and ‡b, respectively, of the WorldCat LHRs.

While LHRs are based on MFHD, there are a few key aspects of OCLC's implementation of the standard that should be noted:

  • WorldCat LHRs are copy-specific, separate holdings records.
  • OCLC does not process holdings for multiple locations in one holdings record.

 Note: It is imperative that all holdings records associated with a specific bibliographic record are always included in the same file. If only one holdings record in a set attached to a single bibliographic record has changed, you must send the whole set of holdings records (not just the changed record). OCLC requires all holdings records for a bibliographic record because data sync processing does not match individual holdings records.

OCLC Control Number

Every record submitted for your LHR data sync collection must contain a single valid OCLC control number (OCN) for the corresponding WorldCat bibliographic record. This can be the 004, 014, and 035 field but it must consistently be in the same location in all records. OCLC knows where to find the OCN based on your selection in the collection.

004 - Control Number for Related Bibliographic Record (NR)

When field 004 is selected, a number will be recognized as the OCLC control number if it has no prefix or an accepted prefix. Accepted 004 prefixes are:

  • (OCoLC)
  • (OCoLC)ocl7
  • (OCoLC)ocm
  • (OCoLC)ocn
  • (OCoLC)on
  • ocl7
  • ocm
  • ocn
  • on

Field 004 is not repeatable in MFHD; no more than one 004 field should be present in a record.

014 - Linkage Number (R)

When field 014 is selected, a number in subfield ‡a will be recognized as the OCLC control number only when subfield ‡b contains 'OCoLC'.

Field 014 is repeatable in MFHD; no more than one 014 field containing an OCN should be present in a record; 014 fields containing other numbers are allowed.

035 - System Control Number (R)

When field 035 is selected, a number in subfield ‡a will be recognized as the OCLC control number only when the number follows an accepted prefix. Accepted 035 ‡a prefixes are:

  • (OCoLC)
  • (OCoLC)ocl7
  • (OCoLC)ocm
  • (OCoLC)ocn
  • (OCoLC)on
  • ocl7
  • ocm
  • ocn
  • on

Field 035 is repeatable in MFHD; no more than one 035 field containing an OCN should be present in a record; 035 fields containing other numbers are allowed.

Location codes for 852 ‡a and ‡b

All OCLC LHRs must contain an 852 field with a valid OCLC institution symbol and holding library code combination in 852 ‡a and ‡b, respectively. Once your initial data is received, an OCLC Database Specialist will be assigned to your collection. They will review the source data and work with you to create a Holdings Translation Table. This table is used during processing to map your local location codes to an OCLC institution symbol in 852 subfield ‡a; a 4-character OCLC-profiled holding library code in 852 ‡b; and, in some cases, a shelving location in 852 ‡c of the WorldCat LHRs. It can also be used to set the lending and reproduction policy bytes of the 008 field (008/20 and 008/21, respectively).

Please see Holdings translation tables for more information.

 Caution: Field 852 is NOT repeatable in the OCLC LHR format.

The presence of other MFHD fields will vary depending on content. OCLC will supply default values for certain elements if they are lacking or invalid.

LHRs may be loaded to WorldCat with validation errors that will be subsequently reported for correction.

Before sending your files for data sync processing there are steps you can take to evaluate and prepare your data, giving you the opportunity to solve potential errors in advance. Note that not all pages listed below are relevant to all types of data sync collections. If you are unsure which data preparation steps to take, please consult with your Database Specialist.

 Caution: Currently when the system identifies duplicate records or multiple matches in your submitted data sync file, the file will be rerun in an attempt to resolve the issue. Multiple reports and files may be generated for each retry.

Title Description
OCLC control numbers and data sync records

Find out how OCLC control numbers are used for matching in data sync processing.

 Note: Information on this page applies to the following data sync collection types:

  • Bibliographic
  • Local holdings records
  • Delete local holdings records
Local system number Find out how your local system number is used for data sync processing in WorldShare Collection Manager.
035 field and OCLC control numbers Find out how data sync processing uses preprocessing routines to map existing OCLC control numbers to field 035 $a, prefixed with (OCoLC).
Record status Find out how the record status value in a record impacts data sync processing in WorldShare Collection Manager.
Prepare your BIBFRAME data

Discover the specifications and guidelines for BIBFRAME data.

 Note: Information on this page applies to the following data sync collection types:

  • Bibliographic
  • Delete WorldCat holdings
Other common errors Find common errors in data sync processing, how they can be prevented, and whether they can be addressed by preprocessing routines in bibliographic data sync collections.

Upload a file    

You can upload your files using My Files, which is located under the Metadata module in the WorldShare interface. You also have SFTP options.

 Note: 

  • For bibliographic and delete WorldCat holdings collections, you can submit MARC, MARCXML, BIBFRAME 2.2.0 and ONIX 3.0 or above files for data sync processing.
  • When uploading using My Files, please note that there is a one (1) gigabyte file size limit. If you have files to upload that exceed the 1 GB size limit, please upload using SFTP.
  • Uploaded files are retained in the WorldShare interface for one year. To verify that your files have been processed, click Uploads and search for the collection ID and date the file was uploaded in the File Name column.

My Files Uploads

  1. Navigate to Metadata > My Files.
  2. Click Uploads.
  3. Click Upload your file to locate the file you wish to upload. Refer to File naming conventions below for more information.
  4. Select your file and click Open. The file name appears under Selected file. 
  5. Select the File Type.
    • Data sync bibliographic
    • Data sync LHR
  6. Click Upload file. A confirmation message appears when the file has successfully uploaded. If a file was unable to upload, an error message will appear.

File naming conventions

Each file name must be unique and must include:

  • 7-digit data sync collection ID - Include as the first element of the file name, immediately followed by a period. This ensures that the file will be processed under the correct data sync collection.
  • OCLC institution symbol - Include as the second element of the file name, separated from the collection ID by a period.

General rules

Include

  • A period should be used to separate distinct elements within a file name.
  • A valid 7-digit data sync collection ID must be included at the beginning of the file name and must be immediately followed by a period.
  • The OCLC institution symbol for which the file should be processed must be included as the second element of the file name and must be preceded and followed by a period.
  • Alphanumeric characters are allowed. Letters can be both upper and lower case.
    • MARC data files (Bib or LHR) should have the filename extension that corresponds with the datatype, for example .mrc or .xml
    • Non-MARC data files should have the filename extension .csv.
  • Control characters @, $, and # will be converted as follows:
    • @ will be replaced with _64
    • $ will be replaced with _36
    • # will be replaced with _35

Do not include

  • Periods, dashes, and/or underscores at the beginning of the file name
  • Spaces and other non-alphanumeric characters

Watch video

WorldCat data sync collections: Name files to upload

Run time: 2:41

This video reviews how to name files to upload for data sync processing.

 

Find information about record processing

See Data sync processing for information about data sync collection record processing.

If you have questions about data processing, please contact your Database Specialist.  

Thema Details
Data sync processing Find information about data sync processing, including holdings translation tables, record validation, sparse records, and unresolved records.
WorldCat data sync collections: Process records in WorldCat staging

Find an overview of WorldCat Staging and learn how to fix unresolved records in Connexion client and WorldShare Record Manager.

 Note: Information on this page applies to the following data sync collection types:

  • Bibliographic
  • Bibliographic and local holdings records
WorldCat data sync collections: Post-processing

Run time: 11:30

This video describes bibliographic reports generated after files are processed through WorldCat data sync collections. You will also learn about unresolved records and how to process them. Timestamps allow you to jump to a specific section of the video.

 Note: All Own Record Return files are output in UTF-8.

Download a file

 Note: Files are made available via SFTP at least once every three hours (approximately), while files are made available via My Files three or four times a day. Thus, it is possible to see a file via SFTP before it is available via My Files. OCLC is working on tighter synchronization between SFTP and My Files so that files will appear in both places almost simultaneously.

Download your files and records using My Files, located under the Metadata tab in the WorldShare interface. You do not need additional credentials to download records from the WorldShare interface. You also have SFTP options.

See Record output and timing for an output schedule for files of records and timing by collection type.

To download a file using My Files:

  1. In the WorldShare interface, navigate to Metadata > My Files.
  2. Click Downloads.
  3. Locate the file you want to download:
    • In the File Name column, find the file you want to download, or
    • Use the Show filters button Show filters button in WorldShare Collection Managerto limit the results by file type. Options include:
      • Records - New
      • Records - Deleted
      • Reports
      • Records - Updated
      • Records - Contract Services
      • Records - Cataloging Partner
    • Select Hide downloaded files to hide files that have been previously downloaded, or select Show all files to show the files regardless of if they have been previously downloaded.
  4. Select Download in the row for the desired file. The file will automatically download to your workstation.

Metadata interface highlighting Collection Manager, Downloads under My Files, and the table filter button.

Watch a video

Download your records in My Files

Run time: 8:26

This video demonstrates where and how to download your files of MARC records, as well as discusses file naming conventions and retentions in My Files.

 

About columns in My Files

See Files of records and file names for details about file names.

Column name Description Notes
File Name Each file name will be unique. See Files of records and file names for details. This column can be sorted (A to Z; Z to A).
File Type    
Size The size listed reflects the size of the file (e.g., 10KB). File size does not reflect the number of records, only the size of the file.  
Post Date* This is the date the file became available for your institution to download. The most recent post date will be listed first. This column can be sorted (ascending / descending).
Download Date* After you download a file from the WorldShare interface, the date of the download will appear in this column. If the file is downloaded multiple times, the date will reflect the most recent date of download. United States Data Center
The date value in the interface will not reflect downloads performed by FTP, SFTP, or SCP.

Australian, Canadian, and European Data Centers
The date value in the interface will reflect all file downloads (My Files, SFTP, or SCP).
Download Click the Download button to download the file. You may download a file multiple times.  
*Depending on your geographic location, the date format will vary. For example, DD/MM/YYYY is used for the United States, DD.MM.YY is used for Germany, and so forth.

File size

Files include no more than 100,000 records each. Batches of records that include more than 100,000 records will be split into multiple files with successive files extensions.

File retention

Files are retained for 90 days.

  • Files are available for download in the WorldShare interface and on the server for 60 days. Files can be downloaded multiple times.  
  • Files older than 60 days can be requested via OCLC Support and are not available for download in the WorldShare interface or on the server. The filename for files older than 60 days will still be listed under their original filename with -stub.txt appended to the end.
    • To request the file, contact OCLC Support and include the original file name in your request, and use Collection Manager File Request as the subject line. 
      • The file will be available for download within 2-4 business days. It will be available to download for 30 days and then deleted.

 Note: Collection Manager output files older than 7 days will be compressed (i.e., zipped) in order to improve performance. Compressed files are given the .zip extension but retain their original file name (e.g., metacoll.OCWMS.new.D20170612.T141740.1.mrc becomes metacoll.OCWMS.new.D20170612.T141740.1.mrc.zip). 

It is recommended that you process record files in date order.  When processing records for a specific date, it is recommended that they are processed in the following order: Deletes, New, Merges, and Updates. See Criteria for new, update, delete, and merged records for more information.

Watch a video

Download your records in My Files

Run time: 8:26

This video demonstrates where and how to download your files of MARC records, as well as discusses file naming conventions and retentions in My Files.

 

Watch a video

Download your records in My Files

Run time: 8:26

This video demonstrates where and how to download your files of MARC records, as well as discusses file naming conventions and retentions in My Files.

 

About columns in My Files

See Files of records and file names for details about file names.

Column name Description Notes
File Name Each file name will be unique. See Files of records and file names for details. This column can be sorted (A to Z; Z to A).
File Type    
Size The size listed reflects the size of the file (e.g., 10KB). File size does not reflect the number of records, only the size of the file.  
Post Date* This is the date the file became available for your institution to download. The most recent post date will be listed first. This column can be sorted (ascending / descending).
Download Date* After you download a file from the WorldShare interface, the date of the download will appear in this column. If the file is downloaded multiple times, the date will reflect the most recent date of download. United States Data Center
The date value in the interface will not reflect downloads performed by FTP, SFTP, or SCP.

Australian, Canadian, and European Data Centers
The date value in the interface will reflect all file downloads (My Files, SFTP, or SCP).
Download Click the Download button to download the file. You may download a file multiple times.  
*Depending on your geographic location, the date format will vary. For example, DD/MM/YYYY is used for the United States, DD.MM.YY is used for Germany, and so forth.

File size

Files include no more than 100,000 records each. Batches of records that include more than 100,000 records will be split into multiple files with successive files extensions.

File retention

Files are retained for 90 days.

  • Files are available for download in the WorldShare interface and on the server for 60 days. Files can be downloaded multiple times.  
  • Files older than 60 days can be requested via OCLC Support and are not available for download in the WorldShare interface or on the server. The filename for files older than 60 days will still be listed under their original filename with -stub.txt appended to the end.
    • To request the file, contact OCLC Support and include the original file name in your request, and use Collection Manager File Request as the subject line. 
      • The file will be available for download within 2-4 business days. It will be available to download for 30 days and then deleted.

 Note: Collection Manager output files older than 7 days will be compressed (i.e., zipped) in order to improve performance. Compressed files are given the .zip extension but retain their original file name (e.g., metacoll.OCWMS.new.D20170612.T141740.1.mrc becomes metacoll.OCWMS.new.D20170612.T141740.1.mrc.zip). 

It is recommended that you process record files in date order.  When processing records for a specific date, it is recommended that they are processed in the following order: Deletes, New, Merges, and Updates. See Criteria for new, update, delete, and merged records for more information.

Understand reports

Reports 

Additional resources