...
+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+----------------+
| cnA | varchar(100) | YES | | NULL | |
| cnD | varchar(50) | YES | | NULL | |
| cnType | varchar(10) | YES | | NULL | |
| collection | varchar(15) | YES | | NULL | |
| barcode | varchar(15) | YES | | NULL | |
| hLocation | varchar(20) | YES | | NULL | |
| cLocation | varchar(10) | YES | | NULL | |
| itemType | varchar(10) | YES | | NULL | |
| titleID | int(11) | YES | | NULL | |
| ckey | int(11) | YES | | NULL | |
| createDate | date | YES | | NULL | |
| itemID | int(11) | NO | PRI | NULL | auto_increment |
+------------+--------------+------+-----+---------+----------------+
12 rows in set (0.01 sec)
After these titles and items are in FOLIO their MARCs will need to be re-written with FOLIO 999s and added to the records db table so before loading them into FOLIO they These titles should be added to the folio:marcRecords MySQL table (see Parse) from whence a revised version of bibLoad.pl should be able to do what needs to be done. So, the trick is going to be to write an /opt/folio/parse/Louisa2folio.pl script to get that job done. Note that Louisa's MARCs do not have 999s - since that is the case, rather than copying data from Louisa:items to folio:itemData it would probably be better to have bibLoad.pl look at Louisa:items where it would other wise parse the 999.
So, all that Louisa2folio needs to do is map three fields from Louisa:titles to folio:marcRecords:
...
Only 193,522 of Louisa's 240,175 titles had catalogKeys which suggests that the other 46,653 are eBooks and/or GovDocs. It wouldn't hurt to investigate that further, later.
Next up: make a copy of bibLoad.pl and tweak it to look to Louisa's items table for all of that 999 info.....
- update the Louisa MARCs with the relevant MARCs from Walter's marc:marcs MySQL table since those MARC records have Sirsi-based 999s : /opt/folio/create/updateMarcRecordsPerLouisa.pl
- cp bibLoad.pl bibLoad4Louisa.pl and have it look in Louisa:items if there is anything there, perhaps cnA, that it needs.
When that's all done the next step will be adding MARCs to FOLIO.