Scope: Analyzing Aleph data before creating batch-update jobs frequently requires analysis of a subset of MARC bib field data.  Gwynneth Duncan created this Aleph service in 2012.

Contact: Jacquie Samples

Unit: Metadata & Discovery Strategy

Date last reviewed: 30 Aug 2021 

Date of next review: 31 Aug 2022 

NOTE: If using a list of system numbers that are not from a CCL search, a text file with the system numbers in this format 000000000DUK01 is necessary.  See this page for info on converting Aleph system numbers.

Running MARC columnar reports in Aleph based on CCL searches

For list of CCL terms used in Aleph indexes, see: Searching OCLC and Aleph#AlephCCLcodesforDUK01

Search desired output using the CCL Query search box.

• Type this in box: "sgn=online databases"

Save results – do not use capital letters or punctuation in file name (NOTE: when typing, it appears as all caps) (this will be the INPUT File Name)

Run the service "Duke customizable MARC columnar report (Custom-25)." By default the Bib Sys No is included in the output.

• Select: *Services
• Select: Retrieve Catalog Records
• Select: Duke Customizable MARC Columnar Report (custom-25); (this screen should appear)

• • Input File Name is the name you used (above) to save on the server.
  • The Report File Name (output name) should be distinctive enough so that you can identify the report in: F:\Aleph\MARC_reports. It does not need to match the input file name (the search you saved earlier from the CCL search).
  • Include this type of data in the report:
    • STA##
    • 245##
    • 260##
    • 506##
    • 655##
    • 85640
    • 85641
    • 901##
    • 029##
  • Select preferred "Runtime"/"At".
  • Select "Submit". (If you want to run it immediately, select "Online")

Retrieve data from the report.

• Open Excel
• Open the file from F:\Aleph\MARC_reports that was created by the MARC columnar service.
• You have the data you need to proceed.