[Koha] Where can I find documentation on the Koha tables

2014-06-25 Thread Phillip Ponchot
Where can I find where information is stored in the Koha tables? For instance, I know that books are entered via the records-import table and entries end up in the items and biblioitems table. When a book is checked out what tables are changed to show that the book is checked out. If the

Re: [Koha] Where can I find documentation on the Koha tables

2014-06-25 Thread Indranil Das Gupta
Hi, On Wed, Jun 25, 2014 at 11:59 AM, Phillip Ponchot pponc...@live.com wrote: Where can I find where information is stored in the Koha tables? http://schema.koha-community.org/ cheers -idg -- Indranil Das Gupta Phone : +91-98300-20971 Blog: http://indradg.randomink.org/blog IRC :

Re: [Koha] Where can I find documentation on the Koha tables

2014-06-25 Thread Zeno Tajoli
Hi Phillip, When a book is checked out what tables are changed to show that the book is checked out. If the book is deleted from koha, does that release the book from the table which shows that the book is checked out? Any infomation is welcome and thanks to everyone whose helped me with this

Re: [Koha] Where can I find documentation on the Koha tables

2014-06-25 Thread Phillip Ponchot
Thanks for the reply, I'll do some reading on this from the site. Thanks again! Date: Wed, 25 Jun 2014 09:19:16 +0200 From: z.taj...@cineca.it To: pponc...@live.com CC: koha@lists.katipo.co.nz Subject: Re: [Koha] Where can I find documentation on the Koha tables Hi Phillip, When a

Re: [Koha] Http Bad request error messages

2014-06-25 Thread Heather Braum (NEKLS)
Joel, We had this crop up repeatedly on our consortia system after we moved to 3.14.3 in back in February. This bug was filed and the patch written/applied, and fixed our issue: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11369. That patch looks like it was added to the 3.16 release

Re: [Koha] Athena to Koha

2014-06-25 Thread Owen Leonard
Also, is there a PDF or webpage I can view to help me in doing cosmetic changes to the Koha site and the OPAC??? There are some articles here: http://www.myacpl.org/koha In addition, is there a list of all the features of Koha??? Have you read the Koha manual?

Re: [Koha] Koha Digest, Vol 104, Issue 54

2014-06-25 Thread Ilesanmi S. Olawale
Hi , We would like to upgrade the version of our Koha 3.12 to 3.16 Will this affect any configurations we have on the 3.12 ??. I mean will it affect the patrons data ??. Thanks Olawale                                   Ilesanmi S. Olawale Web Systems Admin.     ZACCHEUS

Re: [Koha] customizing framework

2014-06-25 Thread Elaine Bradtke
We need more information to help. Do the subfields appear in the editor? You should have a box Are they locked? (they are there but you can't type into them). Could you post a screen shot (you'll have to put it somewhere on the web so that we can see it, because I don't think it will work as an

Re: [Koha] customizing framework

2014-06-25 Thread Liz Rea
Hi, Make sure you have set the max length under advanced constraints to something greater than 0 or empty in the framework editor. Something amount that the data you want to keep in it will fit in. Many people use (even though the db will probably cut it off before it gets to that amount).

Re: [Koha] Where can I find documentation on the Koha tables

2014-06-25 Thread Phillip Ponchot
Thanks so much, this info has been very helpful. Date: Wed, 25 Jun 2014 09:19:16 +0200 From: z.taj...@cineca.it To: pponc...@live.com CC: koha@lists.katipo.co.nz Subject: Re: [Koha] Where can I find documentation on the Koha tables Hi Phillip, When a book is checked out what tables

Re: [Koha] Where can I find documentation on the Koha tables

2014-06-25 Thread Phillip Ponchot
This information has been very helpful and will help me on our migration to a new server and koha version. Date: Wed, 25 Jun 2014 12:05:01 +0530 Subject: Re: [Koha] Where can I find documentation on the Koha tables From: indr...@gmail.com To: pponc...@live.com CC: koha@lists.katipo.co.nz

[Koha] Results of SQL reports in xlsx format

2014-06-25 Thread Mayank Srivastava
Hi everyone, The results of SQL reports from Koha are available in 2 formats csv and tab delimited file. Will it be helpful to users if the results of reports could be downloaded in xlsx format as well? Please pour in your suggestions. Thanks in advance! Regards *Mayank Srivastava* Mob: +91 971

Re: [Koha] Results of SQL reports in xlsx format

2014-06-25 Thread Robin Sheat
Mayank Srivastava schreef op do 26-06-2014 om 10:58 [+0530]: Will it be helpful to users if the results of reports could be downloaded in xlsx format as well? Keep in mind that XLSX is an undocumented, proprietary, non-standard format. All products that can read XLSX should be able to read

Re: [Koha] Results of SQL reports in xlsx format

2014-06-25 Thread Fischer, Katrin
Hi, there is a new feature in 3.16 that adds an ODS export option: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11679 Katrin -Ursprüngliche Nachricht- Von: Koha im Auftrag von Robin Sheat Gesendet: Do 26.06.2014 07:48 An: koha@lists.katipo.co.nz Betreff: Re: [Koha] Results