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

    p_file_20: file naming convention for Z??? elements; sample XML input file

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

    Description:
    We are planning to switch to xml input files for the PLIF patron loader. The documentation is confusing regarding how to name the Znnn elements. Specifically, we need to know whether we can use the names (in tags) exactly as they are defined if we were to use the SQLPLUS 'DESC' command. There are several discrepancies: case, use of hyphen versus underscore, and in some cases, the field names themselves.

    Example 1 (case and punctuation)
    PLIF doc: <z303-Name>
    DESC: Z303_NAME
    Our guess for xml input: <Z303_NAME>

    Example 2 (element names)
    PLIF doc: <z303-id>
    DESC: no corresponding field except as part of key
    Our guess for xml input: <match-id-type> and <match-id>

    Example 3 (element names)
    PLIF doc: <z304-sequence> <z304-address-0> <z304-address-1> <z304-address-2> <z304-address-3> <z304-address-4>
    Sequential PLIF doc: ADDR-REC-SEQUENCE
    ADDR-REC-TYPE
    ADDR-REC-ADDR-1
    ADDR-REC-ADDR-2
    ADDR-REC-ADDR-3
    ADDR-REC-ADDR-4
    ADDR-REC-ADDR-5

    DESC: Z304_ADDRESS
    Our guess for xml input: ?

    We would appreciate getting some help on clarifying this.

    Resolution:
    The PLIF_sample_files_v18_xml directory on the ftp server contains a sample input file: plif.in_2.xml .

    I am also including below, for your convenience. Note that *any* z303, z304, z305, or z308 field can be included in the input file, even if not shown below.

    <p-file-20>
    <patron-record>
    <z303>
    <match-id-type>06</match-id-type>
    <match-id>E48045</match-id>
    <record-action>A</record-action>
    <z303-title>%</z303-title>
    <z303-name>Hotchkiss, Angela D</z303-name>
    <z303-field-2>20080572-042143 NSS PLIF; Staff</z303-field-2>
    <z303-send-all-letters>Y</z303-send-all-letters>
    <z303-con-lng>ENG</z303-con-lng>
    <z303-user-type>REG</z303-user-type>
    <z303-plain-html>P</z303-plain-html>
    <z303-want-sms>N</z303-want-sms>
    <z303-gender>F</z303-gender>
    </z303>
    <z304>
    <record-action>A</record-action>
    <z304-sequence>01</z304-sequence>
    <z304-address-type>01</z304-address-type>
    <z304-address-0>Angela D Hotchkiss</z304-address-0>
    <z304-address-1>4133 Clayton Road</z304-address-1>
    <z304-address-2>Wilmington DE</z304-address-2>
    <z304-address-3>%</z304-address-3>
    <z304-address-4>%</z304-address-4>
    <z304-zip>19805</z304-zip>
    <z304-telephone>3025591234</z304-telephone>
    <z304-telephone-2>%</z304-telephone-2>
    <z304-telephone-3>%</z304-telephone-3>
    <z304-telephone-4>%</z304-telephone-4>
    <z304-email-address>ahotch@uabc.edu</z304-email-address>
    <z304-date-from>%</z304-date-from>
    <z304-date-to>%</z304-date-to>
    </z304>
    <z304>
    <record-action>A</record-action>
    <z304-sequence>02</z304-sequence>
    <z304-address-type>02</z304-address-type>
    <z304-address-0>Angela D Hotchkiss</z304-address-0>
    <z304-address-1>Physical Therapy</z304-address-1>
    <z304-address-2>53 Mckelvy Lab</z304-address-2>
    <z304-address-3>%</z304-address-3>
    <z304-address-4>%</z304-address-4>
    <z304-zip>%</z304-zip>
    <z304-telephone>3028311234</z304-telephone>
    <z304-telephone-2>%</z304-telephone-2>
    <z304-telephone-3>%</z304-telephone-3>
    <z304-telephone-4>%</z304-telephone-4>
    <z304-email-address>ahotch@udel.edu</z304-email-address>
    <z304-date-from>%</z304-date-from>
    <z304-date-to>%</z304-date-to>
    </z304>
    <z305>
    <record-action>A</record-action>
    <z305-sub-library>DEL50</z305-sub-library>
    <z305-bor-status>51</z305-bor-status>
    <z305-expiry-date>20090115</z305-expiry-date>
    </z305>
    <z308>
    <record-action>A</record-action>
    <z308-key-type>01</z308-key-type>
    <z308-key-data>603052008064961234</z308-key-data>
    <z308-verification>EXL7BABC</z308-verification>
    <z308-verification-type>00</z308-verification-type>
    <z308-status>AC</z308-status>
    <z308-encryption>Y</z308-encryption>
    </z308>
    <z308>
    <record-action>A</record-action>
    <z308-key-type>05</z308-key-type>
    <z308-key-data>AHOTCH</z308-key-data>
    <z308-verification>EXL7BABC</z308-verification>
    <z308-verification-type>02</z308-verification-type>
    <z308-status>AC</z308-status>
    <z308-encryption>Y</z308-encryption>
    </z308>
    <z308>
    <record-action>A</record-action>
    <z308-key-type>06</z308-key-type>
    <z308-key-data>E48123</z308-key-data>
    <z308-verification>EXL7BABC</z308-verification>
    <z308-verification-type>00</z308-verification-type>
    <z308-status>AC</z308-status>
    <z308-encryption>Y</z308-encryption>
    </z308>
    </patron-record>
    <patron-record>
    <z303>
    <match-id-type>06</match-id-type>
    <match-id>E32533</match-id>
    <record-action>A</record-action>
    <z303-title>%</z303-title>
    <z303-name>Morrison, Virgil M</z303-name>
    <z303-field-2>20080526-042123 NSS PLIF; Staff; Retired</z303-field-2>
    <z303-send-all-letters>Y</z303-send-all-letters>
    <z303-con-lng>ENG</z303-con-lng>
    <z303-user-type>REG</z303-user-type>
    <z303-plain-html>P</z303-plain-html>
    <z303-want-sms>N</z303-want-sms>
    <z303-gender>M</z303-gender>
    </z303>
    <z304>
    <record-action>A</record-action>
    <z304-sequence>01</z304-sequence>
    <z304-address-type>01</z304-address-type>
    <z304-address-0>Virgil M Morrison</z304-address-0>
    <z304-address-1>112 Orchard Ave</z304-address-1>
    <z304-address-2>Newark DE</z304-address-2>
    <z304-address-3>%</z304-address-3>
    <z304-address-4>%</z304-address-4>
    <z304-zip>197110000</z304-zip>
    <z304-telephone>3027312123</z304-telephone>
    <z304-telephone-2>%</z304-telephone-2>
    <z304-telephone-3>%</z304-telephone-3>
    <z304-telephone-4>%</z304-telephone-4>
    <z304-email-address>%</z304-email-address>
    <z304-date-from>%</z304-date-from>
    <z304-date-to>%</z304-date-to>
    </z304>
    <z304>
    <record-action>A</record-action>
    <z304-sequence>02</z304-sequence>
    <z304-address-type>02</z304-address-type>
    <z304-address-0>Virgil M Morrison</z304-address-0>
    <z304-address-1>112 Orchard Ave</z304-address-1>
    <z304-address-2>Newark DE</z304-address-2>
    <z304-address-3>%</z304-address-3>
    <z304-address-4>%</z304-address-4>
    <z304-zip>197110000</z304-zip>
    <z304-telephone>3027312123</z304-telephone>
    <z304-telephone-2>%</z304-telephone-2>
    <z304-telephone-3>%</z304-telephone-3>
    <z304-telephone-4>%</z304-telephon


    • Article last edited: 10/8/2013