Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    xxx30 Connection record published with different data than doc record

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    Brief workflow:

    (1)

    - Gui Circ => Course Doc List => “Catalog New”
    - New record is created in USM30 + attached to CR
    - In addition to a new record: “connector” record is also created in USM30
    Reminder: “connector” record contains SID (link) to a “physical” record
    - Both –physical and connector records – are processed by ue_01 and ue_21
    - The z00p records with the STATUS = NEW are created for “physical” and “connector”

    (2)
    - “Physical” record is *updated* via the gui catalog
    - It’s processed by ue_01 and ue_21
    - The z00p STATUS changed to UPDATED

    - publish-06 retrieves both records – “physical” and “connector”

    - The problem is that “connector” does not contain updated fields from a “physical” record


    (3)
    - Only if a “connector” re-saved to the server and the z00p STATUS changed to UPDATED, publish-06 outputs “connector” with updated fields.

    Do you think that extra step – re-saving “connector” in order to update the z00p record – is an enhancement request or bug?

    On the other hand, the z00p records are updated for BIBs if changes are done to items and holdings. We don’t have to re-send BIBs to the server every time items are updated, right?

    Complete Scenario attached.

    Resolution:
    You do *not need* a z00p for the connection record. Rather than trying to keep it updated, you should be *excluding* it.
    I will show you how this has been done at ABC University.

    Here's an ABC30 doc record 000062606, with an "SID L $$aABC30-000000009 ..." connection record:

    Reading doc : 000062606
    CNO L $$aS99.2059^BOBST^^^^^^0001
    SID L $$aABC30-000000009-S99.2059 BOBST
    CNO-0 L $$81$$aS99.2059 BOBST $$bPractice with Adult Survivors of Childhood Sexual Abuse $$cINSTRUCTOR $$1Yearly $$eSocial Work
    CNO-1 L $$81$$aPractice with Adult Survivors of Childhood Sexual Abuse
    CNO-2 L $$81$$aPractice with Adult Survivors of Childhood Sexual Abuse - INSTRUCTOR
    CNO-3 L $$81$$aINSTRUCTOR
    CNO-4 L $$81$$aINSTRUCTOR - Practice with Adult Survivors of Childhood Sexual Abuse
    CNO-5 L $$81$$aSocial Work
    CNO-6 L $$81$$1Yearly
    CNO-8 L $$81$$aS99.2059 BOBST - INSTRUCTOR
    CNO-9 L $$81$$aINSTRUCTOR - S99.2059 BOBST
    CNO10 L $$81$$aS99.2059 BOBST - Practice with Adult Survivors of Childhood Sexual Abuse - INSTRUCTOR
    FMT L BK
    LDR L ^^^^^nam^a2200133ra^4500
    001 L 000000009
    003 L NNUrbr
    008 L 080613nuuuuuuuuua^^^^^^^^^^^^000^0^eng^d
    0359 L $$aR100788
    040 L $$aNNU$$cNNU
    1001 L $$aWebb, L.P & Leehan, J.
    24510 L $$aEffects of child abuse for adult survivors
    973 L $$aMISCrbr RECORD$$bBobst

    And here is the ABC30 000000009 connection record:

    ENTER DOC NUMBER : 000000009
    Reading doc : 000000009
    FMT L BK
    LDR L ^^^^^nam^a2200133ra^4500
    001 L 000000009
    003 L NNUrbr
    008 L 080613nuuuuuuuuua^^^^^^^^^^^^000^0^eng^d
    0359 L $$aR100788
    040 L $$aNNU$$cNNU
    1001 L $$aWebb, L.P & Leehan, J.
    24510 L $$aEffects of child abuse for adult survivors
    CAT L $$aCONV$$b20$$c20080708$$lABC30$$h1616
    CAT L $$aNYEIM$$b20$$c20080820$$lABC30$$h1238
    CAT L $$aNYEIM$$b20$$c20080820$$lABC30$$h1239
    CAT L $$aNYEIM$$b20$$c20080820$$lABC30$$h1240
    973 L $$aMISCrbr RECORD$$bBobst
    PST8 L $$0Z30$$1003054333000010$$bBRES$$cBRES$$oBOOK$$d20$$fN$$rABC60-000000000$$n8$$jYSW2059.S34$$3Books$$4ABC Bobst Reserve Collection$$5Reserve Collection$$6Reserve 2 hour loan
    SBL L $$aBRES
    LOC8 L $$bBRES$$cBRES$$jYSW2059.S34$$oBOOK
    STS L $$a20

    Since the z00p for 000062606 has all of the necessary fields (see further below), ABC prevents the 000000009 connection record from being published by this entry in the abc30 tab_publish:

    ! 1 2 3 4 5
    !!!!!!!!!!!!!!!!!!!!-!!!!!!!!!!!!!!!!!!!!-!-!!!!!-!!!!!!!!!!!!!!!
    PRIMO-COURSE ABC30PRIMOBIG N PR30 MARC_XML

    This entry is saying that the nuy30 records must be part of the ABC30PRIMOBIG base in order to be included in the PRIMO-COURSE publishing set.

    And this is the tab_base.eng entry:

    ABC30PRIMOBIG ABC CR Primo Test ABC30 N wcn=(BOBST
    * or TNS* or CU or NYSID)

    And this is the tab11_word line:
    CNO 01 WCN

    Thus, only the xxx30 doc records which have CNO fields are included and connection records are excluded from the z00p:

    abc50@ALEPH20> select Z00P_PTR from z00p where Z00P_LIBRARY = 'ABC30' and Z00P_DOC_NUMBER = '000000009';
    no rows selected

    abc50@ALEPH20> select Z00P_PTR from z00p where Z00P_LIBRARY = 'ABC30' and Z00P_DOC_NUMBER = '000062606';
    **** Hit return to continue ****
    Z00P_PTR <etc.>

    Note: Your course numbers are no doubt different than ABC University's and will require a different base. See KB 16384-29714 in regard to this issue.

    After running p_manage_01, as a test to make sure that the base you are creating for the CNO field is working, you should do util h/1/10. If it shows "NEGATIVE BASE" for your new base, it is not working.

    When it *is* working, you should run p_publish_05, p_publish_04, and p_publish_06 to re-publish the records for this library.


    • Article last edited: 10/8/2013