[Wactclc-alma] Norm rule

Wed Apr 27 12:42:13 PDT 2022

I'm importing from OCLC and 95% of the time those three fields are there, but once in a while (especially if it is a self-published book) they aren't there. There have been more requests that the librarians have put in for books that were published by lesser known publishers or self-published books. Those MARC records (if any) tend to be very sparse on details. 

Victoria Solheim 
Library Technician | She/Her
Pierce College
253-840-8310
1601 39th AVE SE, Puyallup, WA 98374
www.pierce.ctc.edu | vsolheim at pierce.ctc.edu 

Borrow Library Items Guide

-----Original Message-----
From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> On Behalf Of wactclc-alma-request at lists.ctc.edu
Sent: Wednesday, April 27, 2022 12:00 PM
To: wactclc-alma at lists.ctc.edu
Subject: Wactclc-alma Digest, Vol 68, Issue 11

CAUTION: This email originated from outside Pierce College. Do not click links or open attachments unless you have confirmed this is an authentic message from sender and know the content is safe. If you are unsure, contact the Help Desk at 253-964-6373 or email Helpdesk at pierce.ctc.edu

Send Wactclc-alma mailing list submissions to
        wactclc-alma at lists.ctc.edu

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.ctc.edu/mailman/listinfo/wactclc-alma_lists.ctc.edu
or, via email, send a message with subject or body 'help' to
        wactclc-alma-request at lists.ctc.edu

You can reach the person managing the list at
        wactclc-alma-owner at lists.ctc.edu

When replying, please edit your Subject line so it is more specific than "Re: Contents of Wactclc-alma digest..."

Today's Topics:

   1. Process type date filtering (Guidry, Wade)
   2. Re: Process type date filtering (Thomas, Kirsti)
   3. Fun with Analytics! (Elena Bianco)
   4. Re: Process type date filtering (Guidry, Wade)
   5. Norm rule (Victoria Solheim)
   6. Re: Norm rule (Thomas, Kirsti)

----------------------------------------------------------------------

Message: 1
Date: Tue, 26 Apr 2022 20:36:19 +0000
From: "Guidry, Wade" <WadeG at bigbend.edu>
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Subject: [Wactclc-alma] Process type date filtering
Message-ID: <76a8f2b31d204141ac0cd2d60a905d32 at Exch2013-01.bigbend.edu>
Content-Type: text/plain; charset="us-ascii"

I'll put in this in the meeting notes as well, but for those of you who were on the call today, here is the correct syntax for filtering on process type date in the Physical Items subject area, when you want to filter relative to current date:

      "Physical Item Details"."Process Type Date" > (TIMESTAMPADD(SQL_TSI_DAY, -3, CURRENT_DATE))

In this example, the formula will select all process type dates greater than 3 days in the past (current date minus 3 days)

Kudos to Dan, as he was the one who mentioned misplaced or missing parentheses, and that's exactly what I was missing this morning, those outer parens that are underlined above.

Wade Guidry
Library Consortium Services Manager, WACTCLC wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
(509) 760-4474
https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.wactclc.org&c=E,1,7Ci3mOZ2EncT_NDl0I90NVeHm5FF7-784_jeO6ytdgCWqU3o9LPLBgG3q-O2Vcye37bmB03kxhcpy7AbVkX_XrWsjPKF72EEMGHMu8GtOyzgBiLiHXx5IZS_osHm&typo=1<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.wactclc.org%2f&c=E,1,VuewmPpTdv0Eg4DtFfmqhZgyzBQyjpqoIwaBb0hsVaroH0qZPKugLL0lArnNCuS-uxTZPR4n3UVv528q0aqsoaD1cOWl_-tHikkBOJCPo_srs94-ke1CItbmW4AO&typo=1>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20220426/53d27d71/attachment-0001.html>

------------------------------

Message: 2
Date: Tue, 26 Apr 2022 22:04:03 +0000
From: "Thomas, Kirsti" <Kirsti.Thomas at seattlecolleges.edu>
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Subject: Re: [Wactclc-alma] Process type date filtering
Message-ID:
        <BL3PR07MB8986FC977C30BC04211F59BEFAFB9 at BL3PR07MB8986.namprd07.prod.outlook.com>

Content-Type: text/plain; charset="us-ascii"

Following up on that, there's a really helpful Powerpoint presentation by Yoel on the Ex Libris support site that has examples and step by step instructions:

Alma Training > Extended Training > Presentations and Documents - Analytics
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fknowledge.exlibrisgroup.com%2fAlma%2fTraining%2fExtended_Training%2fPresentations_and_Documents_-_Analytics&c=E,1,uHwo0I5zZQEBu0EIUb4xgpZzz1Rd9iVKoWzZNmfTZyWM50Epvj0HHzfPJXpd1KMeNklMaEr6cFCou-7oWE7JT1RqmNAN4EKfWn1I404mL5o,&typo=1

Presentation is called:
How to use the TIMESTAMPADD parameter to retrieve by today - X time in an Alma Analytics report

It will be ok!

Kirsti S. Thomas
Library Technical Services Manager
Seattle Colleges
kirsti.thomas at seattlecolleges.edu<mailto:kirsti.thomas at seattlecolleges.edu>

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> On Behalf Of Guidry, Wade
Sent: Tuesday, April 26, 2022 13:36
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Subject: [Wactclc-alma] Process type date filtering

I'll put in this in the meeting notes as well, but for those of you who were on the call today, here is the correct syntax for filtering on process type date in the Physical Items subject area, when you want to filter relative to current date:

"Physical Item Details"."Process Type Date" > (TIMESTAMPADD(SQL_TSI_DAY, -3, CURRENT_DATE))

In this example, the formula will select all process type dates greater than 3 days in the past (current date minus 3 days)

Kudos to Dan, as he was the one who mentioned misplaced or missing parentheses, and that's exactly what I was missing this morning, those outer parens that are underlined above.

Wade Guidry
Library Consortium Services Manager, WACTCLC wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
(509) 760-4474
https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.wactclc.org&c=E,1,4SllLvbsJkOGIke21Q_fePbXkJZCbI0PZ3X6R_IBLugFnokwrnml54mx9O42NbqH6Z15g4M79Q-3Lhv6Sjpg_HiztMPYly59PMwb3Y4m3CjvnOw,&typo=1<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.wactclc.org%2F&data=05%7C01%7C%7C6228ef974a194d4e5cbd08da27c4b6c1%7C02d8ff38d7114e31a9156cb5cff788df%7C0%7C0%7C637866023834344917%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=GyiRTs9VvnbE1G1zV2hUdMJKDrsSKwtyq9cBSqmki6o%3D&reserved=0>

CAUTION: This email originated outside of the Seattle Colleges' email system. Do not click links or open attachments unless you recognize the sender and know the content is safe. Questions? Contact IT Services at x6333 (Central), x3630 (North), x5844 (South) or email ITHelp at seattlecolleges.edu<mailto:ITHelp at seattlecolleges.edu>.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20220426/10a546c9/attachment-0001.html>

------------------------------

Message: 3
Date: Tue, 26 Apr 2022 23:16:39 +0000
From: Elena Bianco <Elena.Bianco at skagit.edu>
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Subject: [Wactclc-alma] Fun with Analytics!
Message-ID:
        <MWHPR0101MB31817C6DD76B20EACA3A912AE6FB9 at MWHPR0101MB3181.prod.exchangelabs.com>

Content-Type: text/plain; charset="us-ascii"

Hi everyone:

For those of you who are interested in the discussion we had this morning about Skagit's very weird Analytics problem, here it is:

I have created an Analytics report that shows the number of laptops and hotspots that are available in each of our campus libraries. However, when I created the report, I created it as a Physical Item Inventory report, NOT a Fulfillment report, which would have allowed me to show the library desk it was loaned from.

So, we sent some equipment from one campus to another, but this report doesn't show that - it shows the availability in the location where the item came from. I *think* that this is because the items' temporary location didn't get set and the location didn't get changed.

The question is do we need to change future practice so that we make sure the location is changed once the items go over to the other campus, OR should I have created this report as a Fulfillment report - would that still have allowed me to sort and show items by their current process status(how many on loan, available, etc.).

Hopefully we can figure this out on Thursday...

(Feel like these are word problems that should be included in Gary Larson's"Hell's Library" - or maybe it's El's Library ):

[47 Far side ideas | far side cartoons, far side comics, the far side]

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/20220426/4b9be0c4/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 24309 bytes
Desc: image003.jpg
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20220426/4b9be0c4/attachment-0001.jpg>

------------------------------

Message: 4
Date: Wed, 27 Apr 2022 00:08:16 +0000
From: "Guidry, Wade" <WadeG at bigbend.edu>
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Subject: Re: [Wactclc-alma] Process type date filtering
Message-ID: <b69f22e0ddf641fb95e30cb9d8c53d65 at Exch2013-01.bigbend.edu>
Content-Type: text/plain; charset="us-ascii"

And for more analytics resources, see the Analytics Training page on the consortium site:

Analytics Training - Training - LibGuides at Big Bend Community College<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2flibguides.bigbend.edu%2fc.php%3fg%3d1142425%26p%3d8334852&c=E,1,SbUlqxG6LRX2NlybHQ4tsq05orFERQPXXs09AV3DA5QqLc4xUSRZIzd3hGS5gOifLv8QXjYtb56jMXK-MMwlghTNA9lUVbswm7bFHpj1b4oSIH71k3qeyj26QA,,&typo=1>

Wade Guidry
Library Consortium Services Manager, WACTCLC wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
(509) 760-4474
https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.wactclc.org&c=E,1,rz6uaCEH1iZOWqkZhbUPHtIlZBDVTpxJsMmgBPyNkPm3iHfkr2imzoz-znvRgWhPGkaFGHxWkLxk8aywASUSDMRlUxo7J-nmDuymf30P47rmEVRGOlAhXbM,&typo=1<https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.wactclc.org%2f&c=E,1,XoXdQLfRq__CXa48PiUYJUPUCLy9cD9IWFUT0S_wFHDQ7PBLFp6RGXjRzJ17Xkyi-7omvLWnY35K5kRsY8jRs25IY28fsNnMTVjLyZ7JZ96XErktuw,,&typo=1>

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> On Behalf Of Thomas, Kirsti
Sent: Tuesday, April 26, 2022 3:04 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Subject: Re: [Wactclc-alma] Process type date filtering

CAUTION: Originated outside our network. Do not click links or open attachments unless you validate the sender.

Following up on that, there's a really helpful Powerpoint presentation by Yoel on the Ex Libris support site that has examples and step by step instructions:

Alma Training > Extended Training > Presentations and Documents - Analytics
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fknowledge.exlibrisgroup.com%2fAlma%2fTraining%2fExtended_Training%2fPresentations_and_Documents_-_Analytics&c=E,1,kbDqGMygm7Vzp0aMaTChTYQ1dWj7aw5JWX5t-s3zVzJiTJMQ8B_rChrtJmH2CZgFmuGBNi_BvwTTTMT5m8ToIEq3E28egZhvT8B2KllkdRKSIKIZZbE,&typo=1

Presentation is called:
How to use the TIMESTAMPADD parameter to retrieve by today - X time in an Alma Analytics report

It will be ok!

Kirsti S. Thomas
Library Technical Services Manager
Seattle Colleges
kirsti.thomas at seattlecolleges.edu<mailto:kirsti.thomas at seattlecolleges.edu>

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Guidry, Wade
Sent: Tuesday, April 26, 2022 13:36
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: [Wactclc-alma] Process type date filtering

I'll put in this in the meeting notes as well, but for those of you who were on the call today, here is the correct syntax for filtering on process type date in the Physical Items subject area, when you want to filter relative to current date:

"Physical Item Details"."Process Type Date" > (TIMESTAMPADD(SQL_TSI_DAY, -3, CURRENT_DATE))

In this example, the formula will select all process type dates greater than 3 days in the past (current date minus 3 days)

Kudos to Dan, as he was the one who mentioned misplaced or missing parentheses, and that's exactly what I was missing this morning, those outer parens that are underlined above.

Wade Guidry
Library Consortium Services Manager, WACTCLC wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
(509) 760-4474
https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.wactclc.org&c=E,1,_OsORN6zl2g32b7_ZUB1lkaclmU6u0LMuFQSzbcUk0zj5kb0bRsbHXKzzPRl9H1NiwrlgG-w1ofmqUZeA9drzDe6hilx3yw2CuUZSNYQknVxDyKTLRZqkq_sNKg,&typo=1<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.wactclc.org%2F&data=05%7C01%7C%7C6228ef974a194d4e5cbd08da27c4b6c1%7C02d8ff38d7114e31a9156cb5cff788df%7C0%7C0%7C637866023834344917%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=GyiRTs9VvnbE1G1zV2hUdMJKDrsSKwtyq9cBSqmki6o%3D&reserved=0>

CAUTION: This email originated outside of the Seattle Colleges' email system. Do not click links or open attachments unless you recognize the sender and know the content is safe. Questions? Contact IT Services at x6333 (Central), x3630 (North), x5844 (South) or email ITHelp at seattlecolleges.edu<mailto:ITHelp at seattlecolleges.edu>.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20220427/1aea7202/attachment-0001.html>

------------------------------

Message: 5
Date: Wed, 27 Apr 2022 16:57:11 +0000
From: Victoria Solheim <VSolheim at pierce.ctc.edu>
To: "wactclc-alma at lists.ctc.edu" <wactclc-alma at lists.ctc.edu>
Subject: [Wactclc-alma] Norm rule
Message-ID: <0aea92612bb948e0939c53bd73a74ee5 at pierce.ctc.edu>
Content-Type: text/plain; charset="us-ascii"

Hello all,

I've come across enough records while importing (or having to do original cataloging) that I decided to make a norm rule to add the 336, 337, and 338 fields to the MARC record. I've successfully done the norm rule and it works... It just adds them to the end of the record. Does anyone know if there is a way to edit the norm rule so it adds them in numeric order?

Victoria Solheim
Library Technician | She/Her
Pierce College
253-840-8310
1601 39th AVE SE, Puyallup, WA 98374
www.pierce.ctc.edu<http://www.pierce.ctc.edu/> | vsolheim at pierce.ctc.edu<mailto:vsolheim at pierce.ctc.edu>

Borrow Library Items Guide<https://linkprotect.cudasvc.com/url?a=https%3a%2f%2flibguides.pierce.ctc.edu%2fc.php%3fg%3d1129394%26p%3d8242586&c=E,1,snnUOMcPacccmPXlrAUyZPGviqYjZHzV3lAkf-twtOYVrvJFnS78YRl7fUi27GwUrB-adT9oVvoYob7w-k0GlpGuWBFyAVyAn-FeOKnqWLA-3JoDEbH7hQM,&typo=1>

[pierce college logo]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20220427/37b462db/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3749 bytes
Desc: image001.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20220427/37b462db/attachment-0001.png>

------------------------------

Message: 6
Date: Wed, 27 Apr 2022 17:08:11 +0000
From: "Thomas, Kirsti" <Kirsti.Thomas at seattlecolleges.edu>
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Subject: Re: [Wactclc-alma] Norm rule
Message-ID:
        <BL3PR07MB8986185294BED0F7A2B22965FAFA9 at BL3PR07MB8986.namprd07.prod.outlook.com>

Content-Type: text/plain; charset="us-ascii"

Victoria,

Are you importing records from OCLC?  If so, those should already have the 33X fields and you shouldn't need a Norm Rule to add the fields.  Where are you getting the records from?

It will be ok!

Kirsti S. Thomas
Library Technical Services Manager
Seattle Colleges
kirsti.thomas at seattlecolleges.edu<mailto:kirsti.thomas at seattlecolleges.edu>

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> On Behalf Of Victoria Solheim
Sent: Wednesday, April 27, 2022 09:57
To: wactclc-alma at lists.ctc.edu
Subject: [Wactclc-alma] Norm rule

Hello all,

I've come across enough records while importing (or having to do original cataloging) that I decided to make a norm rule to add the 336, 337, and 338 fields to the MARC record. I've successfully done the norm rule and it works... It just adds them to the end of the record. Does anyone know if there is a way to edit the norm rule so it adds them in numeric order?

Victoria Solheim
Library Technician | She/Her
Pierce College
253-840-8310
1601 39th AVE SE, Puyallup, WA 98374
www.pierce.ctc.edu<https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.pierce.ctc.edu%2F&data=05%7C01%7C%7C32dd50ab2f604f50f97708da286f09c5%7C02d8ff38d7114e31a9156cb5cff788df%7C0%7C0%7C637866754737993551%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=WA1IsLXFlBdyitKWPyh3s7oYLqiWYQ6FZLHKaXARZbw%3D&reserved=0> | vsolheim at pierce.ctc.edu<mailto:vsolheim at pierce.ctc.edu>

Borrow Library Items Guide<https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flibguides.pierce.ctc.edu%2Fc.php%3Fg%3D1129394%26p%3D8242586&data=05%7C01%7C%7C32dd50ab2f604f50f97708da286f09c5%7C02d8ff38d7114e31a9156cb5cff788df%7C0%7C0%7C637866754737993551%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=b9SjBZ%2BSwpTJ3pVeeiCIBHwKQ87uGVMNAsVQo%2BsCG64%3D&reserved=0>

[pierce college logo]

CAUTION: This email originated outside of the Seattle Colleges' email system. Do not click links or open attachments unless you recognize the sender and know the content is safe. Questions? Contact IT Services at x6333 (Central), x3630 (North), x5844 (South) or email ITHelp at seattlecolleges.edu<mailto:ITHelp at seattlecolleges.edu>.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20220427/70f4a3a5/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3749 bytes
Desc: image001.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20220427/70f4a3a5/attachment-0001.png>

End of Wactclc-alma Digest, Vol 68, Issue 11
********************************************