stow data re ILS charges in a MySQL db so that Walter can then create loans in FOLIO...

  • via /circulation/check-out-by-barcode for loans w/fixed due dates
  • I thought that I could use /circulation/override-check-out-by-barcode for loans w/rolling due dates but the error message that I got back said: Override is not allowed when item is loanable
    • so, I'll have to use circulation/check-out-by-barcode and then /circulation/loans/$loanId/change-due-date to modify the due date
  • update the db row with the relevant loanId (UUID) once the item has been checked out in FOLIO
mysql> describe chargeData;
+-------------+-------------+------+-----+---------+----------------+
| Field       | Type        | Null | Key | Default | Extra          |
+-------------+-------------+------+-----+---------+----------------+
| circRule    | varchar(10) | YES  |     | NULL    |                |
| dateCharged | varchar(12) | YES  |     | NULL    |                |
| dateDue     | varchar(12) | YES  |     | NULL    |                |
| itemBarcode | varchar(14) | YES  |     | NULL    |                |
| itemType    | varchar(10) | YES  |     | NULL    |                |
| userBarcode | varchar(14) | YES  |     | NULL    |                |
| userProfile | varchar(10) | YES  |     | NULL    |                |
| loanId      | varchar(36) | YES  |     | NULL    |                |
| id          | int(11)     | NO   | PRI | NULL    | auto_increment |
+-------------+-------------+------+-----+---------+----------------+
  • No labels