[Koha] Importing Patron Loan History (old_issues)

jbarker jbarker022 at gmail.com
Sat Apr 12 01:26:57 NZST 2014


I tried to export our loans history data from our old ILS to koha 3.14,
using:
load data local infile '/<PATHTO>/importloanstest.csv' into table
koha.old_issues fields terminated by ',' enclosed by '"' lines terminated
by'\n';

and got the following error:
ERROR 1452 (23000): Cannot add or update a child row: a foreign key
constraint fails (`koha`.`old_issues`, CONSTRAINT `old_issues_ibfk_1`
FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON
DELETE SET NULL ON UPDATE SET NULL)


So i'm just wondering how other people got their loans history into koha
from their old ILS?

Thanks



--
View this message in context: http://koha.1045719.n5.nabble.com/Importing-Patron-Loan-History-old-issues-tp5793794.html
Sent from the Koha-general mailing list archive at Nabble.com.


More information about the Koha mailing list