Ben, CREATE TABLE public.single_lib_bibs AS (SELECT record FROM asset.call_number WHERE owning_lib=1234); SELECT id FROM biblio.record_entry WHERE record IN (SELECT record FROM public.single_lib_bibs); --dump this to a txt file
>From there, I think you can use that text file of bib id's as an input list. To export a set of USMARC records in a file named "output_file" based on the IDs contained in a file named "list_of_ids": cat list_of_ids | $0 > output_file Sincerely, Michael Peters Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana Helpdesk office - 317.234.2128 email - [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ben Shum Sent: Friday, June 15, 2012 12:29 AM To: Evergreen Development Discussion List Subject: [OPEN-ILS-DEV] Using marc_export to extract only a single library's holdings I'm not sure, but it seems like it may not be possible to use marc_export script to extract only a single library's holdings as associated to bib records. Using an option for --library SHORTNAME definitely gives me the bib records with that library attached, but using the option for --items seems to drag in all holdings associated to that bib record and not just the one for the library specified. Is it possible (or has anyone already modified marc_export) to include the capability of extracting only a single library's bibs and associated holdings if specified? -- Ben -- Benjamin Shum Open Source Software Coordinator Bibliomation, Inc. 32 Crest Road Middlebury, CT 06762 203-577-4070, ext. 113
