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

    Command to export particular fields from all records

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

    Description:
    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.)

    Resolution:
    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