Re: [Koha] ISBN report

2014-02-26 Thread Nicolas Legrand
It prints a value only once, if you want all values from all rows, remove the 'DISTINCT' from the request. 2014-02-26 0:54 GMT+01:00 Manos PETRIDIS : > Could it be that the select against biblioitems miss multiple/alternative > ISBN entries for a single item? > > Sent from my iPhone > > On 25 Φε

[Koha] sql report for books of different languages

2014-02-26 Thread Saira Asghar
Dear All I need sql report for list of books of different languages. Do anyone have this type of report? -- *Regards* Saira Asghar Librarian Namal College, 30-Kilometer Talagang Road, Mianwali, Pakistan. ___ Koha mailing list http://koha-community.or

Re: [Koha] Cannot edit public list

2014-02-26 Thread Marcel de Rooy
Amy, You are not encouraged to create public lists with the special Koha admin user. Are you able to create a public list in staff, set the appropriate permissions on it, and add some items (logged in as a superlibrarian in staff) ? Marcel Van: koha-boun..

[Koha] Database in specific directory & backup

2014-02-26 Thread Andrea Furin
hi to all. two questions: 1. is it possible to save the koha database in a specific directory, like in home directory in a second hard drive? 2. for making regular backups is it better to have only one partition in an hard drive (system + data) and create an image file of the hard disk and save

[Koha] Koha 3.14.4 released

2014-02-26 Thread Fridolin SOMERS
Hie community. Koha 3.14.4 is released. See http://koha-community.org/koha-3-14-4-released/ Best regards, -- Fridolin SOMERS Biblibre - Pôles support et système fridolin.som...@biblibre.com ___ Koha mailing list http://koha-community.org Koha@lists.ka

Re: [Koha] Cannot edit public list

2014-02-26 Thread Elaine Bradtke
Have you checked your System preferences? Administration preferences > Interface options> virtual shelves. I just tested our one public list and it seems to accept new records. We're using 3.14.2 On Tue, Feb 25, 2014 at 9:02 PM, Amy Schuler wrote: > Hello All, > > In Koha admin interface, I a

Re: [Koha] z39.50 search not working

2014-02-26 Thread Elaine Bradtke
Have you tried a different z39.50 server to see if the problem lies with LC or with your system? We use several, because our collection is a bit unusual, but also they do sometimes shut them down for maintenance or change the parameters. That said, we've not had any trouble with our connection to L

Re: [Koha] Database in specific directory & backup

2014-02-26 Thread Robin Sheat
Andrea Furin schreef op wo 26-02-2014 om 14:16 [+0100]: > 1. is it possible to save the koha database in a specific directory, > like in home directory in a second hard drive? Yes, you can configure mysql however you like. > 2. for making regular backups is it better to have only one partition

[Koha] Sorting conundrum

2014-02-26 Thread Doug Dearden
Hello all, I have a database that has no item records, only biblios. We are using it to catalog some archival folders, and pointing to pdfs with scanned images using the 856u field. We are using the 099a field as the call number field. In Administration - System Preferences - Cataloging - Re