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. _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
