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 | |
| shadowFlag | varchar(1) | YES | | NULL | |
| catalogedDate | varchar(8) | YES | | NULL | |
| catalogKey | int(11) | NO | PRI | NULL | |
+---------------+-------------+------+-----+---------+-------+
mysql> describe itemData;
+-------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+-------------+------+-----+---------+-------+
| analyticPosition | int(11) | YES | | NULL | |
| callNumShadowFlag | varchar(1) | YES | | NULL | |
| circNote | mediumtext | YES | | NULL | |
| publicNote | mediumtext | YES | | NULL | |
| staffNote | mediumtext | YES | | NULL | |
| itemCat1 | varchar(10) | YES | | NULL | |
| itemCat2 | varchar(10) | YES | | NULL | |
| itemShadowFlag | varchar(1) | YES | | NULL | |
| barcode | varchar(16) | NO | PRI | NULL | |
+-------------------+-------------+------+-----+---------+-------+
The next step will be to write loadMARCrecords.pl and loadItemData.pl...