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

    Command to export particular fields from all records

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

    I need a command to export the 022, 050, 082, and 086 fields from all the records in our QRS01 bib library. (I don't have access to the GUI.)

    These are the commands in version 20....

    First, you need to run p_ret_01 to retrieve the keys of all the records:

    csh -f $aleph_proc/p_ret_01 QRS01,,allkeys.js,000000000,999999999,,00,00000000,99999999,00000000,99999999,,AND,NOT,,,,,,,,,,,,,,,,,,,,,,00000000,99999999,MASTER, > & qrs01_p_ret_01.mmdd.log &

    (You need to change "allkeys.js" to the name you want the output file with all the keys to have.)

    Then, you need to do this:

    csh -f $aleph_proc/p_print_03 QRS01,allkeys.js,022##,050##,082##,086##,,,,,print03.outfile,A,,,,N, > & qrs01.p_print_03.mmdd.log &

    (You need to change:

    allkeys.js to the name of the file produced in the first step and
    print03.outfile to the name you want for the output file . )

    The "A" will give you Aleph Sequential output. If you want MARC format, it would be "M1"; or, for MARC XML, "X".

    • Article last edited: 10/8/2013