Primo VE Normalization Rule Examples

36 Replies to “Primo VE Normalization Rule Examples”

1. These are great examples! Are there any for dublin core?
   Thanks!

   Log in to Reply

2. Hi Lee,
   Please see examples for DC in https://knowledge.exlibrisgroup.com/Primo/Product_Documentation/020Primo_VE/045Loading_Records_from_External_Sources_into_Primo_VE/Configuring_Normalization_Rules_for_External_Resources_(Primo_VE)#DC_Examples

   Log in to Reply

3. Applying the — Remove ‘Online’ indication from the title — rule does not appear to remove “(Online)” from the title. Instead it replaces “(Online)” with “()”.

   Log in to Reply

4. You are correct, thank you for noticed. It seems that there was a problem to save the rule here with two backslash (\\). The line should be as follows:
   remove string (TEMP”1″,”\\(Online\\)”)

   I have updated the example

   Log in to Reply

5. Yep, \\(Online\\) seems to work. I appreciate the prompt action.

   Log in to Reply

6. Hello,

   I have created a local field using search and facet normalization rules to make this field searchable in Primo and filterable by facets.

   But I don’t know how to configure the NR to get the information facets of this local field to display in Primo with the punctuation marks that separate the different subfields. I mean commas or parentheses, like in this example: 996 _ _ $$a Castillo, Antonio del $$c (llibreter), $$d 1758?-1806

   Thanks!!

   Log in to Reply

7. Hello Diana,

   Can you please specify exactly what would you like to be displayed in the facet value for this specific example?
   Also if you want more assistance with the rules you can submit a case to Support

   Thank you,
   Moran

   Log in to Reply

8. Hello Moran,

   Sorry! I think it’s enough that the facet value shows the information of the subfield “a” including the comma between the last name and the first name of the authority, as in the author / creator facet. To make it looks like this: Castillo, Antonio del.
   In the tests I have done, I can’t get the comma to appear in the facet value. It shows like this: Castillo Antonio del.
   How can I do that?

   Thanks for help. I will also consult Support

   Log in to Reply

9. Hello Moran,
   I think that what I really would like to know is if we can configure the display of facet value that is shown in Primo. Especially for local fields.
   Thanks a lot!

   Log in to Reply

10. Hello Diana,

    I suggest you open a support case so they will look at your specific data and they will give you the needed information to set it up.

    Regards,
    Moran

    Log in to Reply

11. Thank you for the examples! This is very helpful. For the 1st rule(create a hyperlink), ‘\’ needs to be added right before the quotation mark(“) for the HTML code as below; otherwise it gives a syntax error.

    add prefix (TEMP”1″,”“)

    Log in to Reply

12. Thank youoran, really helpful.

    There’s a typo in “Check that both subfields ‘a’ and ‘b’ exist”
    when
    MARC.”245″ has any “a,b”
    then
    create pnx.”display”.”lds05″ with MARC.”200″ subfields “a,b”

    200 should be 245

    Log in to Reply

13. Thank you both for the comments. I have updated the examples

    Log in to Reply

14. Hi

    Just to add:

    rule “Primo VE Marc – Lsr01”
    when
    MARC.”300” has any “a,b”
    then
    create pnx.”search”.”lsr01″ with MARC “300” subfields “a,b”
    end

    This concatenates the subfields for search.
    I’m just adding this here because I was looking for an example (to eliminate false positives in local search fields) and didn’t realize this already covers it.

    Log in to Reply

15. Is there a way to concatenate values from separate MARC fields? For example, this display for format has values from several MARC fields:

    https://drive.google.com/file/d/1Q6N4899E9KKhLl7Y0Vl_zIkCurkyrmmo/view?usp=sharing

    This is our current norm rule for FORMAT:

    https://drive.google.com/file/d/1pmEjVWN9P6bkyNBsHE228UluSpVW3qMC/view?usp=sharing

    Is there a way to get all those values on the same line, separated by a semicolon?

    Log in to Reply

16. Hi Israel,

    You can use the following line in the format rule:

    append TEMP”1″ to pnx.”display”.”format” delimited by “-”

    This line is instead of the create action:

    rule “Primo VE – Format 347”
    when
    MARC is “347”
    then
    set TEMP”1″ to MARC.”347″ excluding num subfields without sort
    append TEMP”1″ to pnx.”display”.”format” delimited by “-”
    end

    If you would like to concatenate all the format fields (300, 346, 347 etc.) you should add the ‘ append’ action for all the format rules

    Thank you for raising this question.

    Regards,
    Moran

    Log in to Reply

17. Is there a way to access the values of the 007 control field?

    This rule:

    rule “Primo VE – Lds48”
    when
    MARC.control.”007″(0-1) equals “vd”
    then
    create pnx.”display”.”Lds48″ with “TEST”
    end

    results in this error:

    [3] Unable to expand: MARC.control.”007″(0-1) equals “vd” [3175,17]: [ERR 102] Line 3175:17 mismatched input ‘”007″‘ expecting ‘identifier’ in rule

    Log in to Reply

18. Hello,

    Thank you for raising this question.
    The example you used is working for 008 – we developed it specific for the 008 for customers needs.

    Since using it for 007 required a new development please raise it as enhancement request

    Thank you,
    Moran

    Log in to Reply

19. Has there been an enhancement request for 007? We really need this to replicate what we were doing in BO. We also use 006 in some situations. Thank you!

    Log in to Reply

20. I want to concatenate 5 different 5XX fields if they exist. So I think my When statement would be something like:

    MARC is “500”.”a” OR MARC.”518″ has any “a,d,p” OR MARC is “540”.”a” OR MARC.”546″ has any “a,b” OR MARC is “504”.”a”

    If this is correct, do I then just set each different 5XX field to a TEMP field and then concatenate them all together with a delimiter at the end. Does it handle everything ok if the 5XX field doesn’t exist?

    Log in to Reply

21. That first example to create a hypertext link out only seems to produce an error when attempting to adapt it for 555 subfield u,z (u is the URL, z is the text that should appear). Suggestions? Thanks!

    Log in to Reply

22. Hello,

    There was a typo in the first example and it has been fixed. Thanks for noticed.

    Log in to Reply

23. Iowa State University Library 01IASU_INST,

    Apologizes for the late response.
    When using OR in the condition section – you must mention only one field (and if needed subfields). The reason is that the system can only get one field to compare the fields in the action section.
    When using more than one field with OR in the condition – the code will not know for sure to which field it should refer – Thank you for raising this question since this is an important note that will be added to the documentation.

    In order to make a rule that will find the 5xx fields you want, you can use the following syntax:

    rule “Primo VE – Lds15”
    when
    MARC is “500”.”a”
    then
    create pnx.”display”.”lds15″ with MARC.”500″.”a”
    end

    rule “Primo VE – Lds151”
    when
    MARC is “504”.”a”
    then
    create pnx.”display”.”lds15″ with MARC.”504″.”a”
    end

    rule “Primo VE – Lds152″
    when
    MARC.”518” has any “a,d,p”
    then
    create pnx.”display”.”lds15″ with MARC.”518″ subfields “a,d,p”
    end

    rule “Primo VE – Lds153”
    when
    MARC is “540”.”a”
    then
    create pnx.”display”.”lds15″ with MARC.”540″.”a”
    end

    rule “Primo VE – Lds154″
    when
    MARC.”546” has any “a,b”
    then
    create pnx.”display”.”lds15″ with MARC.”546″ subfields “a,b”
    end

    With this syntax it will get the 5xx that exist in the source.

    Thanks,
    Moran

    Log in to Reply

24. Hi
    Part of our rule to display creation date in Primo VE is

    rule “Primo VE – Date Of Publication 008”
    priority 30
    when
    MARC.control is “008” AND NOT
    MARC.”264″ has any “c”
    then
    set TEMP”1″ to MARC.control.”008″.Date1
    set TEMP”2″ to MARC.control.”008″.Date2
    replace string by string (TEMP”1″,”[^0-9]”,”\\?”)
    replace string by string (TEMP”1″,”9{4}”,””)
    replace string by string (TEMP”2″,”[^0-9]”,”\\?”)
    replace string by string (TEMP”2″,”13{4}”,””)
    remove substring using regex (TEMP”1″,”^(0|\\?)+$”)
    remove substring using regex (TEMP”2″,”^(0|\\?)+$”)
    concatenate with delimiter (TEMP”1″,TEMP”2″,”-“)
    set pnx.”display”.”creationdate” to TEMP”1″
    end

    Result = display of year1-year2 from field 008.

    Example: the second title here
    https://basel.swisscovery.org/discovery/search?query=any,contains,%22geo%20magazin%22&tab=UBS&search_scope=UBS&sortby=date_d&vid=41SLSP_UBS:live&facet=frbrgroupid,include,9003648693927988965&lang=en&offset=0

    —-

    What I would like to achieve:

    – show year1-year2 when year2 is NOT 9999
    – show year1- when year2 = 9999

    So in the example we wouldn’t show
    1976-9999
    but
    1976-

    —-

    I see above the examples for “if … else”, but I don’t see how to combine that with our rule.

    Thank you!
    Manuela

    Log in to Reply

25. (hope my post won’t look as the previw awaiting moderation does, without any line breaks)

    Log in to Reply

26. There’s another typo in this statement:

    Check that both subfields ‘a’ and ‘b’ exist”
    when
    MARC.”245″ has any “a,b”…

    According to the CKC, “has any” checks if the field exists and has one or more of the listed subfields.

    So it’s not “both subfields”, but rather “either subfield”, yes?

    I’d like to see an example that DOES check for both, however!

    Log in to Reply

27. > Field 008, Year2 = 9999:

    Solution via Ex Libris; we asked them to change the default rule.

    […]
    replace string by string (TEMP”2″,”13{4}”,””)
    remove substring using regex (TEMP”1″,”^(0|\\?)+$”)
    remove substring using regex (TEMP”2″,”^(0|\\?)+$”)
    replace string by string (TEMP”2″,”[9999]”,” “)
    concatenate with delimiter (TEMP”1″,TEMP”2″,”-“)
    set pnx.”display”.”creationdate” to TEMP”1″
    end

    = change 09 to 13 in the first line shown, add the whole line containing 9999, change ” – ” to “-” for consistency.

    Log in to Reply

28. Hello,
    I am trying to create a normalization rule (search and facet) for a local field. However I get this error:

    The file cannot be saved due to a compilation error: Rule Compilation error : [Rule name=’Primo VE – Lds02′] defaultpkg/Rule_Primo_VE___Lds02_0.java (13:696) : create cannot be resolved to a type defau

    This is my rule:
    rule “Primo VE Marc – Lsr02”
    when
    MARC is “650”.”a” AND
    MARC.”650″.”2″ match “reo”
    then
    create pnx.”search”.”lsr02″ with MARC “650”.”a”
    end

    Any help would be appreciated.
    Thank you
    Kind regards
    Sandra

    Log in to Reply

29. Hi Sandra,
    Please try to remove from the rule title:
    “rule “Primo VE Marc – Lsr02”
    the word “Marc” and also change the “Lsr02” to “Lds02”.

    Best regards,
    Yael.

    Log in to Reply

30. Thank you Yael,

    I was trying to create a normalization rule for the search and facet local field (Lsr) not a rule for display local field (Lds) – I am not sure why the error message suggested changing to Lds?

    I have now resolved my rule now – after copying my rule into notepad I discovered that three of the quotation marks were displaying in notepad as question marks (see rule below). I have since amended my rule and it is working as expected. Thank you for your help.

    Best regards,
    Sandra

    This is my rule:
    rule “Primo VE Marc – Lsr02”
    when
    MARC is “650”.”a” AND
    MARC.”650?.”2? match “reo”
    then
    create pnx.”search”.”lsr02? with MARC “650”.”a”
    end

    Log in to Reply

31. Update to “suppress date2 if = 9999″:

    […]
    replace string by string (TEMP”2″,”13{4}”,””)
    remove substring using regex (TEMP”1″,”^(0|\\?)+$”)
    remove substring using regex (TEMP”2″,”^(0|\\?)+$”)
    replace string by string (TEMP”2″,”(9999|;)”,” “)
    concatenate with delimiter (TEMP”1″,TEMP”2″,”-“)
    set pnx.”display”.”creationdate” to TEMP”1″
    end

    line 4 is improved, with code found on this page 🙂
    before this change, all 9 in year2 got suppressed, not only when year2 = 9999

    Log in to Reply

32. I think the example for the LDR check should look in positions 6-8, not 6-7.

    Log in to Reply

33. > Has there been an enhancement request for 007?

    https://ideas.exlibrisgroup.com/forums/308176-primo/suggestions/45283696-add-007-to-marc-control-identifiers-for-display-an , 4 votes at the moment..

    Log in to Reply

34. Adding this here because I could not get any of the other rules I found to work.
    With the help of Laurence Richelle, Université de Liège:

    Suppress / hide a field if it has a certain term in a certain subfield.
    Combine more that one AND NOT condition.

    rule “Primo VE Display – contributor 700″
    when
    MARC.”700” has any “a,b,c,5” AND
    MARC.control is “001”
    AND NOT
    (MARC.”700″.ind”2″ equals “2” OR
    MARC.”700″.”5″ match “term_to_trigger_the_hiding” )
    then
    […]

    Log in to Reply

35. I am having some issues with the syntax for the 008– what we are trying to do is to have the creation date show date 2 first when the DtSt position matches p for distribution/production date.

    The alterations I made to the display rules are:

    rule “Primo VE – Date Of Publication 008 Film”
    priority 35
    when
    MARC.control.”008″(06) equals “p”
    then
    set TEMP”1″ to MARC.control.”008″.Date2
    set TEMP”2″ to MARC.control.”008″.Date1
    replace string by string (TEMP”1″,”[^0-9]”,”\\?”)
    replace string by string (TEMP”1″,”9{4}”,””)
    replace string by string (TEMP”2″,”[^0-9]”,”\\?”)
    replace string by string (TEMP”2″,”9{4}”,””)
    remove substring using regex (TEMP”1″,”^(0|\\?)+$”)
    remove substring using regex (TEMP”2″,”^(0|\\?)+$”)
    concatenate with delimiter (TEMP”1″,TEMP”2″,” – “)
    set pnx.”display”.”creationdate” to TEMP”2″
    end

    rule “Primo VE – Date Of Publication 008”
    priority 30
    when
    MARC.control is “008” AND NOT
    MARC.control.”008″(06) equals “p”
    then
    set TEMP”1″ to MARC.control.”008″.Date1
    set TEMP”2″ to MARC.control.”008″.Date2
    replace string by string (TEMP”1″,”[^0-9]”,”\\?”)
    replace string by string (TEMP”1″,”9{4}”,””)
    replace string by string (TEMP”2″,”[^0-9]”,”\\?”)
    replace string by string (TEMP”2″,”9{4}”,””)
    remove substring using regex (TEMP”1″,”^(0|\\?)+$”)
    remove substring using regex (TEMP”2″,”^(0|\\?)+$”)
    concatenate with delimiter (TEMP”1″,TEMP”2″,” – “)
    set pnx.”display”.”creationdate” to TEMP”1″
    end

    But I consistently get syntax errors for the when statements:

    “The file cannot be saved due to a compilation error: [5] Unable to expand: MARC.control.”008″(06) equals “p” [6] Unable to expand: MARC.control.”008″(06) equals “p” [2809,15]: [ERR 102] Line 2809:15 mism”

    Based on the examples here and elsewhere this seems to be correct, so why is it not working?

    Log in to Reply

36. When enabled is there a way to configure the “Hypertext Linking Definitions” using NR for display depending on the content of the related field?
    For instance, I’ve defined “Related Titles” to be hypertext linked for 775 tags.
    However I would like to disable the hypertext linking for 775 tags that do not have a subfield “w”

    775 0#$t20 Minuten $bBern $w(Sz)001267174
    775 0#$t20 Minuten $bBasel
    775 0#$t20 Minuten $bLuzern
    775 0#$t20 Minuten $bSt. Gallen
    775 0#$t20 minutes $bGenève $w(Sz)001452367
    775 0#$t20 minutes $bLausanne $w(Sz)001452369
    775 0#$t20 minutes $bRomandie $w(Sz)001483900
    775 0#$t20 minuti $bTicino $w(Sz)001643316

    By default Primo VE create hypertext linking using the displayed fields:

    https://nb-helveticat-psb.primo.exlibrisgroup.com/discovery/fulldisplay?vid=41SNL_51_INST:helveticall&search_scope=MyInstitution&tab=LibraryCatalog&docid=alma991017145879703976&lang=en&context=L&adaptor=Local%20Search%20Engine&query=any,contains,20%20Minuten&offset=0

    rule “Primo VE – Relation 775 with prefix no w”
    when
    MARC.”775″ has any “a,t” subfield not exist “775”.”w” AND NOT
    MARC.”775″.ind”2″ equals “8”
    then
    set TEMP”1″ to MARC.”775″ sub without sort “a,b,g,s,t,x,z” wrap subfields
    add prefix (TEMP”1″,”$$COthered$$V”)
    replace wrapping delimiters (TEMP”1″,”a”,””,””)
    replace wrapping delimiters (TEMP”1″,”b”,”. “,””)
    replace wrapping delimiters (TEMP”1″,”g”,”. “,””)
    replace wrapping delimiters (TEMP”1″,”s”,””,””)
    replace wrapping delimiters (TEMP”1″,”t”,””,””)
    replace wrapping delimiters (TEMP”1″,”x”,”, ISSN “,””)
    replace wrapping delimiters (TEMP”1″,”z”,”, ISBN “,””)
    replace string by string (TEMP”1″,”(\\s\\,)”,”,”)
    replace string by string (TEMP”1″,”(\\s\\.)”,”.”)
    remove string (TEMP”1″,”<>”)
    remove leading and trailing spaces (TEMP”1″)
    create pnx.”display”.”relation” with TEMP”1″
    end

    I don’t want to hide the 775 field without w, I just want to disable the hypertext link.
    I tried to insert HTML tags such as TEMP”1″ but the file cannot be saved due to a compilation error: Rule Compilation error : [Rule name=’Primo VE – Relation 775 with prefix no w’] defaultpkg/Rule_Primo_VE___Relation_775_with_prefix_no_w_0.java

    Does anyone know how to do this?

    Thanks 🙂

    Log in to Reply