TAMULib / fw-registry

MIT License
0 stars 2 forks source link

ILS Workflow: Export to Rapid ILS for print journals monthly #105

Closed ghost closed 3 years ago

ghost commented 3 years ago

Perl scripts that run on ringle.tamu.edu to extract print journal and print monograph data for submission to Rapid ILS website. Journals run monthly, monographs quarterly.

Candidate for cron task.

Look into Rapid ILS website for possible input.

Look into LDP data types.

May require MARC bibliographic and MARC holdings record.

hismith commented 3 years ago

rapid_print_serials_sql.txt rapid_print_monos_sql.txt

This task has 3 pieces: rapid_print_monos, rapid_print_serials, rapid_electronic_serials. In general, all 3 tasks create output files that should be added to the MIS dashboard for ILS staff to download so that they can be uploaded to the Rapid website.

Rapid Print Monos sql for the ldp is attached output file should have the name rapid_print_monos.txt. output file format should be tab-delimited and gzipped cron job should be run quarterly in months 1,4,7,10

Rapid Print Serials sql for the ldp is attached output file should have the name rapid_print_serials.txt. output file format should be tab-delimited and gzipped cron job should be run monthly on the 10 of the month

Rapid Electronic Serials There is a job on killick.library.tamu.edu, /exlibris/sfx_ver/sfx4_1/tamu/home/scripts/rapid_sfx.pl. It takes an existing file that is created by an SFX utility and copies it to a folder on killick from which it can be downloaded. The replacement job needs to follow the same procedure to copy the output file to the MIS dashboard with the filename rapid_electronic_serials.gz The file should also be gzipped, which the current script doesn't do. Cron job should be run monthly on the 10th of the month.