[Wactclc-alma] analytics question STRIP OUT OCLC NUMBER

Wed Oct 24 12:56:23 PDT 2018

And guys, don't forget that Google is your friend when searching for information.

I know that librarians sometimes have a mental block when it comes to Google, owing to the competition librarians feel towards Google :)

But if you google pretty much any Alma / Primo question you have, in a form similar to:

Exlibris alma analytics oclc number

You will find all kinds of useful info that can lead you in the right direction.

And assume most people know the "site:" keyword in Google.

So that if you want to search the exlibris site specifically, you can do:

                Exlibris alma analytics oclc number site:exlibrisgroup.com

If I want to search the Ex Libris knowledge center, that's typically what I do, instead of using the in-site search tool. Pretty much any in-site search tool is inferior to simply using Google.

[Title: Big Bend Community College Logo]

Wade Guidry
Library Consortium Services Manager
Big Bend Community College
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>

509.760.4474
www.bigbend.edu<http://www.bigbend.edu/>

Big Bend Community College * 7662 Chanute Street NE * Moses Lake, WA 98837-3299

WACTCLC Alma Instance: Alma NA02<http://status.exlibrisgroup.com/>
WACTCLC Primo Instance: Primo NA08<http://status.exlibrisgroup.com/>

From: Wactclc-alma [mailto:wactclc-alma-bounces at lists.ctc.edu] On Behalf Of Elena Bianco
Sent: Wednesday, October 24, 2018 12:44 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Subject: Re: [Wactclc-alma] analytics question STRIP OUT OCLC NUMBER

I'm impressed that you remembered that it was in the online meeting notes somewhere. That totally escaped me. Thanks again - so glad I have this group to help me figure stuff out...

Elena Bianco, Systems & Technical Services Librarian
Skagit Valley College
2405 E. College Way
Mount Vernon, WA 98273
(360)416-7624

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Paula Laine
Sent: Wednesday, October 24, 2018 12:41 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] analytics question STRIP OUT OCLC NUMBER

I will say that it took me a long time to find that snippet, buried in our online meeting notes.
That'll teach me not to wait next time I need something we have discussed!

                Paula

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Ventura, Gerie
Sent: Wednesday, October 24, 2018 12:36 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] analytics question STRIP OUT OCLC NUMBER

Have we started a central place where we can share procedures?  Gerie

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Elena Bianco
Sent: October 24, 2018 12:34 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] analytics question STRIP OUT OCLC NUMBER

Holy cow, Paula! That string is unbelievable and I never would have figured it out in a million years. Thanks very much! Question: Where did you put that in the query?

Elena Bianco, Systems & Technical Services Librarian
Skagit Valley College
2405 E. College Way
Mount Vernon, WA 98273
(360)416-7624

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Paula Laine
Sent: Wednesday, October 24, 2018 12:16 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] analytics question STRIP OUT OCLC NUMBER

Elena,

Here is a snippet of code that was posted to the list that strips out the OCLC number from the "network number" field.
It looks awful but it works.

CASE WHEN UPPER("Bibliographic Details"."Network Number") LIKE '%OCOLC%' THEN REPLACE(LEFT(SUBSTRING("Bibliographic Details"."Network Number" FROM LOCATE('(OCOLC',UPPER("Bibliographic Details"."Network Number"))), LOCATE(' ', SUBSTRING(CONCAT("Bibliographic Details"."Network Number",'; ') FROM LOCATE('(OCOLC',UPPER("Bibliographic Details"."Network Number"))))),';','') WHEN UPPER("Bibliographic Details"."Network Number") LIKE '%OCM%' THEN REPLACE(LEFT(SUBSTRING("Bibliographic Details"."Network Number" FROM LOCATE('OCM',UPPER("Bibliographic Details"."Network Number"))), LOCATE(' ', SUBSTRING(CONCAT("Bibliographic Details"."Network Number",'; ') FROM LOCATE('OCM',UPPER("Bibliographic Details"."Network Number"))))),';','') WHEN UPPER("Bibliographic Details"."Network Number") LIKE '%OCN%' THEN REPLACE(LEFT(SUBSTRING("Bibliographic Details"."Network Number" FROM LOCATE('OCN',UPPER("Bibliographic Details"."Network Number"))), LOCATE(' ', SUBSTRING(CONCAT("Bibliographic Details"."Network Number",'; ') FROM LOCATE('OCN',UPPER("Bibliographic Details"."Network Number"))))),';','') WHEN UPPER("Bibliographic Details"."Network Number") LIKE '%ON%' THEN REPLACE(LEFT(SUBSTRING("Bibliographic Details"."Network Number" FROM LOCATE('ON',UPPER("Bibliographic Details"."Network Number"))), LOCATE(' ', SUBSTRING(CONCAT("Bibliographic Details"."Network Number",'; ') FROM LOCATE('ON',UPPER("Bibliographic Details"."Network Number"))))),';','') ELSE 'No OCLC Number Available' END

The rest of it looks like this: [super wide cut&paste]
[cid:image003.png at 01D46B98.F8895DA0]
Feel free to call me if you'd like.

Paula Laine
425-564-2259

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Elena Bianco
Sent: Wednesday, October 24, 2018 11:56 AM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: [Wactclc-alma] analytics question

I am trying to run a list of all of the things that we have deleted from Alma in the past year, and I'm realizing that the OCLC numbers are not showing up. We need that so we can do a batch delete in OCLC. I thought that the field Bibliographic ID field would be the one to choose, but this field is blank for a lot of them.

How does one do a search in Analytics and specify that the 035 field be one of the fields that displays - or can you not do that in Analytics? In Millennium, we used to be able to specify which MARC fields to display in any lists that we ran...

Thanks,

Elena

Elena Bianco, Systems & Technical Services Librarian
Skagit Valley College
2405 E. College Way
Mount Vernon, WA 98273
(360)416-7624

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20181024/167c7070/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 12948 bytes
Desc: image002.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20181024/167c7070/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 23832 bytes
Desc: image003.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20181024/167c7070/attachment-0005.png>