search

sul-dlss / libsys-airflow

Airflow DAGS for migrating and managing ILS data into FOLIO along with other LibSys workflows
Apache License 2.0
5 stars 0 forks source link

[SPIKE] Lehigh App for Orders Requirements Analysis #271

Closed jermnelson closed 1 year ago

jermnelson commented 1 year ago

Currently FOLIO's mod-data-import does not support creating and loading Order records from BIB 9xx fields. One option is the Lehigh's FOLIO Order import tool. This tool is a Java standalone web application that may be difficult to integrate with Airflow as there doesn't appear to be an API that we can use. Also, the app creates Instances, Holdings, and Items records and we want to leverage mod-data-import to this FOLIO record creation.

The scope of this Spike is to determine if Lehigh tool can be used in the context of Airflow and our planned use of the mod-data-import. If that doesn't look viable, create one or more tickets outlining what information needs to be extracted from the MARC Bib record 9xx fields to create Order records. Documentation in the FOLIO Wiki, Import Orders in MARC format, can be of use as it outlines future workflow for Orders importing using the mod-data-import.

Another source for requirements is FOLIO-FSE's Order transformer that creates Order records from TSV files and the example composite order mapping.

Finally, the Okapi mod-orders and mod-orders-storage provide the JSON schema for composite orders records.

jmartin-sul commented 1 year ago

this ticket is for analysis, and we'll spin off implementation tickets as needed.

seems likely that jeremy or shelley will pick up this ticket, since they have most relevant expertise.

jermnelson commented 1 year ago

Closing this ticket as our current thinking is that we may use the Lehigh tool as an interim solutions for Orders until we migrate to Orchid.