University of Haifa – The Library

1. University of Haifa – The Library Webingest 2 Marc 85640 Boaz Dotan Developer meets Developer ExLibris Jerusalem 3-4 November 2010

2. The Request • Our media librarians want to create links to Digitool objects automatically(!) • The solution should give different descriptions of different files (e.g. jpeg, tiff, pdf) • The solution should cover old ingests

3. The Problem • Need to find a way to link between Digitool objects and Aleph records without buying the Digitool to Aleph synchronisation kit developed by ExLibris.

4. The way to the solution • Some facts: • Major objects in Digitool have Aleph records. • Almost all ingests use MARC XML file exported from Aleph created using print-03 service with Digitool fix program (fix_doc_do_file_08 with a file as program argument file)

5. The way to the solution – cont. • In Aleph every record that has a digital object includes the following line in the catalog record: 85646 <filename = aleph system number>.<file extension e.g. jpeg, pdf, etc.> • All Aleph records have 001 control field with the system number – needed to synchronisation between Aleph and Digitool via OAI.

6. The way to the solution – cont. • 2 ideas for the solution: • Writing PHP script using SQL – need to work with CLOB fields causing very complicated queries and dealing with huge data – not applicable. • Writing PHP script using the file jobs.log. There is a lot of information in it I can use – this is the way!

7. The solution • Running cshell script that creates 3 input files from the jobs.log file: 1. aleph001.txt 2. xml_list.txt 3. pid_xml.txt Then run PHP script which takes those 3 files and process them.

8. The solution – cont. Create 3 arrays which contain: - Aleph record system numbers - XML file name via VIEW or VIEW_MAIN usage type - XML file name via Digitool PID number. Then from all those 3 arrays create output file that contain the following:

9. The solution – cont. Aleph System number 85640 $$u link to Digitool object $$z Description e.g. jpeg, tif, pdf 001234567 85646 L $$uhttp://digitool.haifa.ac.il:80/webclient/DeliveryManager?pid=648589&custom_att_2=si mple_viewer$$zImage

10. The solution – cont. • Transfer the file using scp to the Aleph server and then upload into Aleph via p-manage-18.

11. Future Development • Run this script from the Meditor (Digitool GUI) via custom service (today the script runs only from command line). • Run this script from the web – maybe via the management module.

12. Questions ?

13. Thank you for listening, Boaz bdotan@univ.haifa.ac.il