Query WorldCat to create a spreadsheet of your WorldCat holdings
Configure institution settings for query collections
If you haven't already, follow the instructions to Configure institution settings for query collections. Many of the settings are optional. At a minimum, configure the required settings below:
Verify your OCLC Symbol
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.
Enable MARC Records
Use the MARC Records setting to enable record delivery. Note that collection-level record delivery settings will remain disabled. You will need to enable record delivery within your collections before records will be delivered.
To enable record delivery in the institution settings:
Once you enable record delivery, tabs of settings to customize your records will appear. The settings in these tabs apply across all collections and records you output from Collection Manager. To customize your records, complete the settings in each tab relevant for your collection types: Customize Records, WorldCat Updates, Record Delivery, Cataloging Partner Options.
Create a query collection to retrieve records for your holdings
Create a query collection leaving One-time delivery selected:
- 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
- Navigate to Metadata > Collection Manager > Create a Collection > Query collection.
- Enter a Collection Name.
- The Collection ID is automatically supplied. Do not delete it.
- Enter your WorldCat Selection Criteria. Replace [OCLC symbol] with your library's symbol:
- Leave One-time delivery selected for the Collection Type.
- Records may be delivered in a New or Update file. See Criteria for new, update, delete and merged records.
- Click Create.
For complete instructions, see Create a query collection.
Enable MARC Records at the collection-level
Within the query collection you just created:
- Expand MARC Records.
- Select Use institution setting to enable record delivery at the collection level.
- Click Save.
Your profile is now set up. Records might be output as soon as the following day (records are output on weekdays, US EST). Large collections require an additional day to output records.
Download files using My Files
Use MarcEdit to pull specific fields from your file of records
MarcEdit is available for download at: http://marcedit.reeset.net.
OCLC cannot provide support for this third-party tool. Find tutorials about using MarcEdit: http://www.youtube.com/results?search_query=marcedit.
To use MarcEdit to pull specific fields from your file of records:
- Open your downloaded files of records in MarcEdit and convert them to a tab-delimited file.
- Navigate to Tools > Export > Export Tab Delimited Records.
- In Set File Paths, enter the path of the file you downloaded from Collection Manager.
- Enter the path where you would like to output files.
- Browse to your desired source file by clicking the folder next to the text box. Click Next.
- Define the fields and subfields that you want to export into the spreadsheet. Select a field and subfield and click Add Field until you have all of the desired fields represented. For example, you could choose:
- ISBN (020$a),
- OCLC number (035 $a),
- LC call number (050 $a and $b),
- Author (100 $a), and
- Title (245 $a, $b and $c)
- Once you have selected all of the desired fields/subfields, click Export.