Skip to main content
ExLibris
Ex Libris Knowledge Center

How to Use a List of Values from a CSV File as a Filter in Alma Analytics

  • Product: Alma

Introduction:

Often the institution will have a list of values, such as MMS IDs or barcodes, in a column of a csv file. The csv file may originate from a variety of sources, for example:

  • Exporting a set in Alma
  • The “Duplicate title analysis” job
  • A local application

It is possible to use these values as a filter in Alma analytics.  In the case below we will use the MMS ID.  The same flow can be used for other values such as barcodes.

Note that the maximum number of values that can be included in a filter is 9,999.

Question:

What are the best steps to use a list of MMS IDs (or any other value) from a csv file as input in Alma Analytics?

Answer:
  1. Click filter for the MMS ID column.
  2. Click the magnifying glass (Search):
    clipboard_ea421827b6304cfcc7edf970fe1897799.png
  3. Click the pencil icon (Edit):
    clipboard_e8feea3eb095921a6fd42bcbb4619d2dc.png
  4. Paste the list of MMS IDs into the box. Click OK to the three windows to apply the filter:
    clipboard_e52c526e3064a952b16d0c4cee803e9af.png
  5. The report is now filtered by the MMS IDs:
    clipboard_e2231691b8747cbc02cd97039b2e90f01.png

 


  • Article last edited: 16-Nov-2022