Re: [Koha] On syspar.par in Koha

2014-04-13 Thread Adalid Ortiz
In Koha doesn't exists the "syspar.par" file because Koha is a web server system. The "Global system preferences" and other module tools help the admin user in the configuration and administration of Koha. Winisis manual http://www.unesco.org/isis/files/winisis/windows/doc/english/WINISIS15rev.p

Re: [Koha] Report Help

2014-04-13 Thread Chitralekha
Please try this SQL report. This is sorted by count. SELECT CONCAT('',biblio.biblionumber,'') AS biblionumbers, biblio.author, biblio.title, COUNT(items.itemnumber) AS ItemCount, ccode, itype FROM items LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) GROUP BY items.biblionumb

[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 '//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 r