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: Aug 30, 2021 

Date of next review: Aug 31, 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.

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)

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.