Versions Compared

Old Version 125

changes.mady.by.user Pedro Arroyo

Saved on

compared with

New Version 126

changes.mady.by.user Pedro Arroyo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

      3. Batch Withdrawals: Single Monographic Volume or Complete Serial collections - Batch withdrawals are performed by LTS's Automation Team.  The request may come from selectors looking to deselect material, or if a large number of missing/lost items need to be                                            withdrawn withdrawn, etc.  

    1. For batch withdrawals of single volume monographs, a .csv spreadsheet of barcodes of records to be withdrawn should be sent to the Automation team. 
      • The list should have more than 25 entries. Lists of fewer than 25 entries will be processed manually by DBQ staff.

    2. Automation Team staff will perform the following steps:

      • Import the .csv spreadsheet to DBeaver and create a separate table of the barcodes.
      • Perform a query (or queries) on the newly-created table of barcodes. This is to acquire specific data needed to perform the batch withdrawal process. The primary data necessary to complete a batch withdrawal are the instance UUIDs, holdings UUIDs and the item UUIDs.
      • Once item UUIDs are acquired, item records are deleted by means of a Python script.
      • Utilizing the holdings UUIDs and a Python script involving the the Folio API, all holding work will be completed. This would include adding the withdrawal note in the holdings note, the transaction data note and the suppression of the holdings. Examples of withdrawal notes: Withdrawn (lost/missing) 3/12/20, netid or Withdrawn (dupe-deselected) 3/12/20, netid.
      • If the holdings being withdrawn is the last CUL copy, the FOLIO Instance record will need to be suppressed.
      • The corresponding instance UUIDs for the bibliographic MARC bibs will be used when implementing or Python script utilizing the Folio API to suppress the instance and add the administrative notes, if there are no other holdings attached with circulating material. The instance will not be suppressed if there is a valid holdings attached with circulating material.
      • Develop and run query in Dbeaver to verify bibliographic records of last CUL copy are suppressed and that all withdrawn holdings are suppressed and the items deleted.

...