How to extract OCLC numbers from a file of MMS IDs and batch delete holdings in OCLC
Part 1. Gather the MMS IDs
Starting with a set of Titles in Alma, either view results or members of the set:
![Display members or results of a set](/sites/default/files/2022-08/Display%20members%20of%20a%20set.png)
Then click on the export list icon:
![Export list icon](/sites/default/files/2022-08/Export%20list%20icon.png)
Select “Current View.” This will export the list as an Excel spreadsheet. The spreadsheet will download onto your computer.
Part 2. Use Analytics to collect the OCLC numbers
In Analytics, click Create, Analysis. Select the “Titles” subject area.
In the Bibliographic Details folder double click MMS ID to add it to the criteria for the report.
![Bibliographic Details folder in analytics](/sites/default/files/2022-08/Bibliographic%20Details%20folder.png)
![MMS ID](/sites/default/files/2022-08/MMS%20ID.png)
From the Bibliographic ID’s folder double-click OCLC Control Number single (035a) to add it to the report criteria.
![OCLC number](/sites/default/files/2022-08/OCLC%20number.png)
Add a filter to the MMS ID column by clicking on the cog icon and selecting Filter:
![select filter](/sites/default/files/2022-08/select%20filter.png)
Click the Value drop-down arrow:
![Drop down arrow](/sites/default/files/2022-08/Dropdown%20arrow.png)
Click on More/Search:
![More Search](/sites/default/files/2022-08/More%20Search.png)
Click on the Edit icon:
![Edit Icon](/sites/default/files/2022-08/Edit%20Icon.png)
Open the spreadsheet that you downloaded in Part 1 and scroll to the right until you see the MMS ID column. Highlight and copy all the MMS IDs in the column. Paste the MMS IDs into the Edit box and click OK.
![Paste MMS IDs](/sites/default/files/2022-08/Paste%20MMS%20IDs.png)
Click OK until all the boxes close.
Save the report by clicking on the save icon and give the report a name.
Click on the results tab, and the report appears.
![MMS IDs to OCLC report](/sites/default/files/2022-08/MMS%20to%20OCLC%20report.png)
To export the report to an Excel spreadsheet, click on the icon to export the report to your computer.
![Export icon](/sites/default/files/2022-08/Export.png)
Part 3. In Connexion use the OCLC numbers to delete holdings
In Connexion, you can use this file of OCLC numbers to delete holdings in batch.
Click the Batch menu and select Holdings by OCLC number:
![holdings by OCLC number](/sites/default/files/2022-08/holdings%20by%20OCLC%20number.png)
Copy the column of OCLC numbers from the excel report and paste them into Connexion.
![Delete holdings in OCLC](/sites/default/files/2022-08/Delete%20holdings%20in%20OCLC.png)
Select Delete Holdings and click OK.