1 / 12

Acquisitions Automation:

Acquisitions Automation:. Import without data going bump in the night. 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.

diata
Download Presentation

Acquisitions Automation:

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Acquisitions Automation: Import without data going bump in the night

  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

  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

  4. YBP terms • EOCRs are initial orders • OCLC Plus records are enhanced bibliographic records - optional service • EDI - invoices themselves

  5. Orders & Enhanced Bib Records • Aleph Database

  6. Invoices • Aleph Database

  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

  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

  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

  10. 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

  11. 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.

  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)

More Related