04/22/23 1

Acquisitions Automation:

Import without data going bump in the night

04/22/23 2

• Purpose of this session: automate acquisitions data import to free staff for higher value work

• Use automation to make certain that appropriate flow of data is ongoing, and keep staff informed

04/22/23 3

What in specific are we importing?

• Orders include bibliographic, order and encumbrance records

• Enhanced Bibliographic records; more up to date and robust bib records

• Invoices for orders being readied for shipment

04/22/23 4

YBP terms

• EOCRs are initial orders

• OCLC Plus records are enhanced bibliographic records - optional service

• EDI - invoices themselves

Orders & Enhanced Bib Records

•Aleph Database

•Aleph Database

Invoices•Aleph

Database•Aleph

Database

04/22/23 7

### If eocr exist then process

if (-e $eocr_data) then

csh -f $aleph_proc/p_file_96 <parameters>

./sth01/tab/import/ tab_ybp_def

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!-!!!!!!!!!!-!!!!!!!!!>

ORDER-SEQ ########## DocNo or mono

Z30-MATERIAL ########## BOOK

Z68-VENDOR-CODE ########## YBP

Z601-VENDOR-CODE ########## YBP

04/22/23 8

• On GUI PC, in \AL500\Acq\tab\ACQ.INI

[OrderNumber]

EnablePrefix=N

PrefixString=DocNo

OR

Admin library (xxx50) -> UTIL/G/2

12. last-doc-number 105212 y S

22. last-order-no-mono 3012 y S M

04/22/23 9

• ./xxx01/tab/ tab_fix

! File 96 fixes

YANK fix_doc_do_file_08 del_fields.fix

YANK fix_doc_do_file_08 yankee_fix

• ./sth01/tab/import/ yankee_fix

1 049## REPLACE-STRING $aVBZM,$aVZBM

2 016## DELETE-FIELD

2 019## DELETE-FIELD

YBP file retrieval program started: 14:58:34 9/2/2010

85530902.ord 17729 bytes 85530902.cnt 1 bytes Warn: 85530901.mrc not available.

Warn: 8553090110.edi not available.

YBP files retrieved as of: 14:58:34 9/2/2010OCLC Plus file is not available for batch queue. EDI file is not available for batch queue. 17729 KB /home/hscapp/perl_jobs/inbound/8553_0902.ord Prepare to modify EOCR prices.... 9 records manipulated for loading.9 records checked before loading.1 EOCR records to be loaded are not MESH. EOCR Count: 9

Wed Oct 13 07:45:00 EDT 2010Starting daily process checking.... Daily import file found for OCLC PLus Bib records.

Found OCLC Plus records.Records were Matched by manage_36.No records were UNmatched by manage_36.No records had Multiple matches in manage_36.No records rejected by manage_18. Daily import file found for EOCR records.Found EOCR records. Daily processes found Invoice records.

Please see Acq GUI screens: Acq -> Admin tab -> EDI Load Log. Daily processes did NOT reject invoice records.Aleph loaded invoices.

04/22/23 12

For More Information

• Perl modules: MARC.pm, MARC::Record, libnet-1.22 -> Net::FTP (marc-perl.pdf)

• “Load Records using Generic Vendor Records Loader” ( file-96 Exlibris Doc)

• ./xxx01/tab/ tab_fix related docs

(Configuration Guide)

• "How to Set Up a Script for the Correction of Records“ ( System Librarian Guide )

• Staff User’s Guide (edi-09 & edi-10)

• MarcEdit (only one tool - optional)