Re: [Koha] Report Help

2014-04-13 Thread Chitralekha
Please try this SQL report. This is sorted by count. SELECT CONCAT('a href=\/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\',biblio.biblionumber,'/a') AS biblionumbers, biblio.author, biblio.title, COUNT(items.itemnumber) AS ItemCount, ccode, itype FROM items LEFT

[Koha] Importing Patron Loan History (old_issues)

2014-04-13 Thread jbarker
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