Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 Parse (crunch) data and save it in a MySQL db.