...
+------------+--------------+------+-----+---------+----------------+
| 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 it would probably be easier to use the MARC with 999s that can be found in the marcs db table (where the ckey will be the 001) - question: do I need any of the information that is in Louisa:items?
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.