You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

I had hoped to parse the MARC records into the JSON documents that are required by /instance-storage/instances, /holdings-storage/holdings, and /items-storage/items (including the UUIDs that connect items w/holdings and instances) and save them in a MySQL db but FOLIO seems to need to create those UUIDs itself. So all I'm doing here is putting the MARC records, and the item data that is not included in the 999, in these two MySQL db tables: 

mysql> describe marcRecords;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| marc | mediumtext | YES | | NULL | |
| instanceId | varchar(36) | YES | | NULL | |
| catalogKey | varchar(10) | NO | PRI | NULL | |
+------------+-------------+------+-----+---------+-------+



There will be some parsing involved in order to get the data for multiple items into a single row in which the catalogKey is the primary key

  • No labels