[Wactclc-alma] Using indicator values in normalization rules

[Whittaker, Shellie]

While working with Shoreline to figure out why an import job set to strip non-LC subject headings from records being imported in batch from OCLC wasn't doing what was expected, we discovered an error in the normalization rule we were using.  It got by us at first because the syntax looks good. We found the problem by reviewing the documentation<https://knowledge.exlibrisgroup.com/Alma/Product_Documentation/Alma_Online_Help_(English)/Resource_Management/040Metadata_Management/070Working_with_Normalization_Rules>.

We had received the following normalization rule, named Non LC Subject Headings, from one of the other institutions, with the understanding that it was working to strip out the unwanted subject headings.

rule "Delete 938, 980, 981, 993, 650 2, 650 3, 650 4, 650 5, 650 6, 650 7, 650 8"
when
  (TRUE)
then
  removefield "938"
  removeField "980"
  removeField "981"
  removeField "993"
  removeField "650" if (exists "650.{2,*}")
  removeField "650" if (exists "650.{3,*}")
  removeField "650" if (exists "650.{4,*}")
  removeField "650" if (exists "650.{5,*}")
  removeField "650" if (exists "650.{6,*}")
  removeField "650" if (exists "650.{7,*}")
  removeField "650" if (exists "650.{8,*}")
end


When we ran an import job using a normalization process that contained this normalization rule, the non-LC subject headings were still there.

Review the following email exchange to see the solution. :)

Shellie

From: Doepping, Debbie [mailto:ddoeppin at shoreline.edu]
Sent: Monday, September 11, 2017 11:41 AM
To: Whittaker, Shellie <ShellieW at bigbend.edu>
Subject: RE: I think I figured out the problem with the import

YES, YES, YES, it worked!!!!!!

Thank-you, when you think about it the solution was so simple.

Debbie

From: Whittaker, Shellie [mailto:ShellieW at bigbend.edu]
Sent: Monday, September 11, 2017 11:25 AM
To: Doepping, Debbie <ddoeppin at shoreline.edu<mailto:ddoeppin at shoreline.edu>>
Subject: I think I figured out the problem with the import

We want to normalize using the SECOND indicator.  So we need to edit the rule to be like the second one shown below.
Here's a snip from the documentation:

[cid:image001.jpg at 01D32AF2.DC4359D0]

Our rule as it is now:

rule "Delete 938, 980, 981, 993, 650 2, 650 3, 650 4, 650 5, 650 6, 650 7, 650 8"
when
  (TRUE)
then
  removefield "938"
  removeField "980"
  removeField "981"
  removeField "993"
  removeField "650" if (exists "650.{2,*}")
  removeField "650" if (exists "650.{3,*}")
  removeField "650" if (exists "650.{4,*}")
  removeField "650" if (exists "650.{5,*}")
  removeField "650" if (exists "650.{6,*}")
  removeField "650" if (exists "650.{7,*}")
  removeField "650" if (exists "650.{8,*}")
end

The rule we need:

rule "Delete 938, 980, 981, 993, 650 2, 650 3, 650 4, 650 5, 650 6, 650 7, 650 8"
when
  (TRUE)
then
  removefield "938"
  removeField "980"
  removeField "981"
  removeField "993"
  removeField "650" if (exists "650.{*,2}")
  removeField "650" if (exists "650.{*,3}")
  removeField "650" if (exists "650.{*,4}")
  removeField "650" if (exists "650.{*,5}")
  removeField "650" if (exists "650.{*,6}")
  removeField "650" if (exists "650.{*,7}")
  removeField "650" if (exists "650.{*,8}")
end



[Title: Big Bend Community College Logo]

Shellie Whittaker
WACTC Library Consortium Services Coordinator
Big Bend Community College
shelliew at bigbend.edu<mailto:shelliew at bigbend.edu>

360.452.5264

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

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



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20170912/8f96adb9/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 16662 bytes
Desc: image001.jpg
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20170912/8f96adb9/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 12936 bytes
Desc: image002.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20170912/8f96adb9/attachment.png>