User Tools

Site Tools


PINES Cataloging Manual

PINES Policies & Procedures

Copy Cataloging Guidelines

Original Cataloging Guidelines

Outsourcing Policies

PINES Evergreen Manual

Item Statuses and Circulation Rules

Spine Label Printing



Deleting holdings In OCLC

While PINES staff will routinely batch updating (also known as setting or adding) holdings in OCLC’s WorldCat, deleting holdings remains the responsibility of individual library systems. Deleting holdings assists interlibrary loan staff so that they do not get ILL requests for titles no longer held by a system. It is also part of GOLD compliance. It can, unfortunately, be a time consuming process.

With the exception of the Middle Georgia Regional Library System (which has one for the system and one for the Genealogy department), all PINES libraries have one OCLC symbol. This means all holdings, regardless of the number of branches in a system, are held under that one symbol on a bibliographic record in OCLC’s WorldCat. Individual copies are also not indicated in WorldCat – it doesn’t matter if a library has one or 100 copies of a title. You only need to delete holdings on the corresponding record in OCLC if you have deleted your system’s last copy attached to a bibliographic/title record in the PINES database. If just one copy is retained by your system, take no action in OCLC.

Determining last copy

You may already have a procedure in place identifying last copies that works perfectly fine with your workflow. The ideas here are not prescriptive and are intended to be just suggestions. They may not work for you or they may be a better option than what you are doing now.

If you are deleting a few items, determining last copy is simple – you can delete from holdings maintenance and tell from there if any other copies are attached to your library system. If deleting older titles and your library is one of those with multiple records from prePINES databases, you may need to do a quick title search in PINES to be certain.

Once you have established a list of title records with your library’s holdings no longer attached, you can then move to OCLC’s Connexion Client to delete holdings in OCLC. See section: Deleting holdings in Connexion Client for further information.

Using Item Status (F5)

You can delete barcodes in Item Status and determine after deletion if the item was the last copy.

1. Set your default view to Holdings View.

2. Load barcodes into Item Status (F5). There are three ways to load items into Item Status:

  • Directly entering barcodes
  • Uploading a txt file of barcodes
  • Transferring items from a copy bucket to Item Status

3. Once your items are in Item Status, working in batches of 20 or less, delete the items and then pick Show in Catalog from the Actions menu.

4. Go to each tab and check in Holdings View for your library’s holdings. If there are additional copies in your system, no further action is needed. If there are no additional items attached to your system, you will need to build a file or list to assist in OCLC deletions. Again, you have several options:

  • You can add all records with no library holdings to a record bucket. This includes records automatically deleted if you deleted the last copy attached to the bibliographic record. See instructions in the section Creating files for Connexion Client Batch Processing to proceed from the buckets.
  • You can copy the TCNs (Title Control Numbers) for OCLC records (those with the TCN prefix ocm or ocn) to a txt or NotePad file. See section for batchprocessing files in the section Deleting Holdings in Connnexion.

5. Then add records that are not OCLC records to a record bucket. See instructions for deleting holdings from records with no OCLC based TCN.

Using MSExcel spreadsheets with Pivot Tables

1. Assign all items to be deleted the status Discard/Weed.

  • Using copy buckets, put all items to be deleted in a Copy Bucket or buckets, depending on numbers (you can transfer the barcodes from Item Status (F5) into a copy bucket). Use Batch: Edit Item attributes to change status to Discard/Weed. If branch staff add items to be deleted to a Copy Bucket, they can share the bucket with you by giving you the bucket ID number.

2. Run report using the template Last copies, with count ID (clone) found in shared folder: elainehardy → OCLC holdings maintenance reports as well as in the PINES Quick Reports interface → Items → OCLC Holdings Maintenance: Last Copies.

3. Open the report in MSExcel.

Inserting a PivotTable in MSExcel

1. Delete any row that has a blank barcode, library, or status. (If you sort by barcode, library, then status, it will clump all the blanks together. Then sort by column A [Title Proper or Title] when done.)

2. Highlight the data table (Ctrl + A). Then Insert → PivotTable.

  • When Create PivotTable pops up, click OK.

3. From the PivotTable Field List, click and drag:

  • TCN value → Row Labels
  • Name or Copy Status → Column Labels
  • Copy ID or Count → Values

Field list labels will depend on whether you ran the report in the traditional reports interface or in Quick Reports.

4. Put your cursor anywhere in the data table, then use Ctrl + A to highlight all and Copy.

  • Open a new sheet tab and Paste Values.

5. Delete any empty initial rows and the row Sum of Copy ID or Count, then Sort → Discard/Weed: Smallest → Largest → Add level → Grand Total → Smallest to Largest.

6. Delete any rows that contain other statuses besides Discard/Weed (Unless you want to also use this report to investigate other statuses such as lost or missing).

  • The remaining rows should have Discard/weed = 1, Grand Total = 1. These are the records with the last copy for your system.

7. For OCLC based title control numbers, follow directions for creating a file to batch delete holdings in the Connexion Client.

8. For non-OCLC based title control numbers, before you delete the items you will need to look at the records to get sufficient information to locate a possible record in OCLC.

Delete discard/weed items in PINES.

After you have collected the information you need to delete holdings in OCLC, you can return to your Discard/weed copy buckets and delete the items there or transfer them to Item Status to delete.

Creating files for Connexion Client Batch Processing

You can create text files of OCLC title control numbers or ISBNs to import into the Connexion Client for batch processing. Files of OCLC title control numbers can be easily processed for holdings deletion. Processing a file of ISBNs (for those records without OCLC based TCNs) requires more steps.

OCLC based title control numbers: ocm/ocn/on title control numbers

Connexion Client allows you to import a file of OCLC title control numbers and process delete holdings in a batch. You first need to create a text file of the TCNs without the ocm, ocn, or on prefixes.

Creating a text file from a PINES/Evergreen report

1. Open in MSExcel the Last Copy report or other report that includes title control numbers for OCLC deletes.

2. Delete unnecessary columns and headers leaving just the title control numbers.

3. Sort so that non OCLC TCNs can be deleted. (You can create a separate file of these TCNs if you need to investigate them further).

You can remove duplicated TCNs at this point.

4. If there are more than 2500 rows, you should break apart the file into smaller numbers. You can do this by either cutting or pasting into a word doc or into different sheets in the spreadsheet. You will need to save each sheet as a .txt file.

5. Remove all ocm, ocn, and on prefixes.

6. MSExcel may delete all initial zeros. If your column is not formatted for numbers you may see barcodes in this format: 1.22E+08. Highlight the column and format the cell to read as numbers by right clicking, choosing Format Cells, Numbers:

7. Then save as a .txt file: Text (Tab delimited):

8. You are now ready to batch process the file(s) in the Connexion Client.

Creating a text file from a list

1. If you have created a list of OCLC TCNs in Notepad or MSWord, delete all ocm and ocn prefixes. It isn’t necessary to delete the initial zeros. If it is A MSWord document, save as a Plain Text file.

Notepad files are text files.

2. You are now ready to batch process the file in the Connexion Client.

Creating a text file from a from a record bucket

1. In your bucket loaded with records for OCLC holdings deletion (either copy or record), use the column picker to display only the TCN.

2. Download the full csv (Save file as Plain Text):

3. Open the file you just saved in MSWord. Then remove “TCN”, all quotes and the ocm, ocn, and on prefixes. Resave the file as a Plain Text File.

4. You are now ready to batch process file in the Connexion Client.

Non OCLC based title control numbers: PIN, etc.

If you have ISBNs for some of your nonOCLC records, you can do limited batch processing of them. Keep in mind that you may retrieve more than one record from WorldCat when you process the file. Also keep in mind that you may have multiple records in PINES with the same ISBN and that some of those records may still have holdings attached and should not be deleted from OCLC. It may be better to search for these records individually in OCLC from a list with more information so that you can be assured of deleting holdings from the correct record. If the records do not have ISBNs, it is not practical to create a file to batch search OCLC. You will need to do those one at a time in the Connexion Client.

Creating a text file from a PINES/Evergreen report

If you have a report that includes the ISBNs, create a text file as above of just the ISBNs. Once it is created, you are ready to batch process in the Connexion Client.

Creating a text file from a list

If you have a Notepad or MSWord file of a list of ISBNs, create a text file of the ISBNs as above. Once it is created, you are ready to batch process in the Connexion Client.

Creating a text file from a record bucket

In your record or copy bucket, use the column picker to display ISBN only. Follow the directions above to create a text file. Once it is created, you are ready to batch process in the Connexion Client.

Deleting holdings in Connexion Client

You can delete holdings in OCLC’s Connexion Client either singly or in a batch. Batch searching and deleting is best used when you have the OCLC based title control numbers for the records. If you have ISBNs, you can also batch search; but it is best to delete from the local save file so that you can be sure you are deleting holdings from the correct record since you may have another version of the title still in holdings. These instructions assume familiarity with OCLC’s Connexion Client. For more detailed instructions for the client see Connexion client documentation.

Before you begin, make sure your settings in the Connexion Client are set to retrieve more than one record, retain any search keys you want to retain, and have record actions set to delete attached LHRs. You may also want to display the batch reports automatically.

Settings are found under Tools → Options.

cat/deleting_holdings_in_oclc.txt · Last modified: 2019/09/30 10:09 by ehardy