Versions Compared

Key

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

...

  1. Use the filter for the appropriate field, such as MMS ID or Item ID. If you are expecting an exact match, select "is equal to" and paste in your string of IDs
  2. If you are not expecting an exact match (e.g., if the identifier is an ISBN and the field probably contains multiple ISBNs) select "contains any"
  3. There is some limit to how many IDs you can paste into a filter. The limit is much higher if it is an exact match. I usually do four pages of ISBNs at a time and up to 26 pages of Item or MMS IDs. Analytics is sometimes inconsistent about how much it will accept, so if you get an error, trying using fewer IDs temporarily.
  4. When copying IDs from the Word document, make sure your string does not start or end with a semicolon!


Strategies for Identifying Malformed Barcodes

  1. Character length
    1. Duplicate the barcode column
    2. Edit the formula to
      CHAR_LENGTH("Physical Item Details"."Barcode") 
    3. In Filters, filter on
      CHAR_LENGTH(Barcode) is not equal to / is not in  14
  2. Contains non-numeric characters
    1. Duplicate the barcode column
    2. Edit the formula to
      evaluate('REGEXP_INSTR(%1, ''^[0-9]+$'')',"Physical Item Details"."Barcode") 
    3. In Filters, filter on
      EVALUATE('REGEXP_INSTR(%1, ''^[... is equal to / is in  0
  3. Barcodes that do not start with 39074 (this applies to Main campus; other campuses may have other expected barcode prefixes)
    1. Duplicate the barcode column
    2. Edit the formula to
      SUBSTRING("Physical Item Details"."Barcode" FROM 0 FOR 5)
    3. In Filters, filter on
      SUBSTRING(Barcode FROM 0 FOR 5) is not equal to / is not in  39074