From jesse.weaver@liblime.com Wed Oct 1 18:32:19 2008 From: Jesse Weaver To: koha-devel@lists.koha-community.org Subject: Re: [Koha-devel] [Koha] Creating reports in Koha 3.0 Date: Wed, 01 Oct 2008 10:18:15 -0600 Message-ID: <6bd6de210810010918r4f517aa1lfc31bae4035d4ed9@mail.gmail.com> In-Reply-To: <7.0.1.0.2.20081001110454.05d187b8@ckls.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1256005694422152050==" --===============1256005694422152050== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit On Wed, Oct 1, 2008 at 10:06 AM, Kathy Rippel wrote: > I agree, Marie. The list should have terms that librarians will recognize, > not programmers. The underlying structure can still use the programming > terms. > > Kathy > > > At 03:41 PM 9/30/2008, Nicole Engard wrote: > > As far as I know there isn't a list. It's sort of hit or miss. I usually > find out just testing different fields. I'm CCing the Koha List in case > they have any ideas. > > > --- > > Nicole C. Engard > Open Source Evangelist, LibLime > (888) Koha ILS (564-2457) ext. 714 > nce@liblime.com > AIM/Y!/Skype: nengard > > http://liblime.com > http://blogs.liblime.com/open-sesame/ > > > On Tue, Sep 30, 2008 at 4:20 PM, Marie Wardall > wrote: > Hi Nicole- > I'm looking at our test data for our school district and am trying to get a > handle on creating some custom reports because some of the reports in the > Wizard just don't pull enough or the right data. > > When I go into the custom report area I'm getting confused as to what a;; > of the things mean in Step 3 where you select columns for display. Is there > someplace that describes each of these so that I can make a good choice? > > Any help you could give me would be appreciated. > > Thanks, > > > Marie J. Wardall > Library Media Specialist > Mountain Bay Elementary School > 8602 Schofield Ave. > Weston, WI 54476 > mwardall@dce.k12.wi.us > Phone: 715-355-0302 ext. 5824 > > Change Today, Change Tomorrow, Keep Changing > > > _______________________________________________ > Koha mailing list > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > Kathy Rippel > > _______________________________________________ > Koha mailing list > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > As far as I know, this is due to the columns.def file not being up to date with the Koha database. A while back, we discussed using MySQL's COMMENT option to put descriptive information in the table schema. We have a couple of options: * Update columns.def so that it has all of the columns referenced by the guided reports tool. * Using a db update, add comments to all of those columns. These can be gotten by SHOW FULL COLUMNS FROM . This has the advantage of being more "proper", but is yet another displayed string in the database that would have to be translated... somehow. My vote is for columns.def, since it's under the template tree and therefore easily internationalized. Thoughts? -- Jesse Weaver Software Developer, LibLime --===============1256005694422152050== Content-Type: text/html Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.html" MIME-Version: 1.0 PGRpdiBkaXI9Imx0ciI+PGJyPjxicj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+T24gV2VkLCBP Y3QgMSwgMjAwOCBhdCAxMDowNiBBTSwgS2F0aHkgUmlwcGVsIDxzcGFuIGRpcj0ibHRyIj4mbHQ7 PGEgaHJlZj0ibWFpbHRvOmtkckBja2xzLm9yZyI+a2RyQGNrbHMub3JnPC9hPiZndDs8L3NwYW4+ IHdyb3RlOjxicj48YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJib3JkZXIt bGVmdDogMXB4IHNvbGlkIHJnYigyMDQsIDIwNCwgMjA0KTsgbWFyZ2luOiAwcHQgMHB0IDBwdCAw LjhleDsgcGFkZGluZy1sZWZ0OiAxZXg7Ij4KCjxkaXY+CkkgYWdyZWUsIE1hcmllLiBUaGUgbGlz dCBzaG91bGQgaGF2ZSB0ZXJtcyB0aGF0IGxpYnJhcmlhbnMgd2lsbApyZWNvZ25pemUsIG5vdCBw cm9ncmFtbWVycy4gVGhlIHVuZGVybHlpbmcgc3RydWN0dXJlIGNhbiBzdGlsbCB1c2UgdGhlCnBy b2dyYW1taW5nIHRlcm1zLjxicj48YnI+CkthdGh5PGRpdj48ZGl2PjwvZGl2PjxkaXYgY2xhc3M9 IldqM0M3YyI+PGJyPjxicj4KQXQgMDM6NDEgUE0gOS8zMC8yMDA4LCBOaWNvbGUgRW5nYXJkIHdy b3RlOjxicj4KPC9kaXY+PC9kaXY+PGJsb2NrcXVvdGUgdHlwZT0iY2l0ZSI+PGRpdj48ZGl2Pjwv ZGl2PjxkaXYgY2xhc3M9IldqM0M3YyI+QXMgZmFyIGFzIEkga25vdyB0aGVyZSBpc24mIzM5O3Qg YQpsaXN0LiZuYnNwOyBJdCYjMzk7cyBzb3J0IG9mIGhpdCBvciBtaXNzLiZuYnNwOyBJIHVzdWFs bHkgZmluZCBvdXQganVzdAp0ZXN0aW5nIGRpZmZlcmVudCBmaWVsZHMuJm5ic3A7IEkmIzM5O20g Q0NpbmcgdGhlIEtvaGEgTGlzdCBpbiBjYXNlIHRoZXkgaGF2ZQphbnkgaWRlYXMuPGJyPjxicj4K PGJyPgotLS08YnI+PGJyPgpOaWNvbGUgQy4gRW5nYXJkPGJyPgpPcGVuIFNvdXJjZSBFdmFuZ2Vs aXN0LCBMaWJMaW1lPGJyPgooODg4KSBLb2hhIElMUyAoNTY0LTI0NTcpIGV4dC4gNzE0PGJyPgo8 YSBocmVmPSJtYWlsdG86bmNlQGxpYmxpbWUuY29tIiB0YXJnZXQ9Il9ibGFuayI+bmNlQGxpYmxp bWUuY29tPC9hPjxicj4KQUlNL1khL1NreXBlOiBuZW5nYXJkPGJyPjxicj4KPGEgaHJlZj0iaHR0 cDovL2xpYmxpbWUuY29tIiB0YXJnZXQ9Il9ibGFuayI+aHR0cDovL2xpYmxpbWUuY29tPC9hPjxi cj4KPGEgaHJlZj0iaHR0cDovL2Jsb2dzLmxpYmxpbWUuY29tL29wZW4tc2VzYW1lLyIgdGFyZ2V0 PSJfYmxhbmsiPgpodHRwOi8vYmxvZ3MubGlibGltZS5jb20vb3Blbi1zZXNhbWUvPC9hPjxicj48 YnI+Cjxicj4KT24gVHVlLCBTZXAgMzAsIDIwMDggYXQgNDoyMCBQTSwgTWFyaWUgV2FyZGFsbAom bHQ7PGEgaHJlZj0ibWFpbHRvOk1XYXJkYWxsQGRjZS5rMTIud2kudXMiIHRhcmdldD0iX2JsYW5r Ij5NV2FyZGFsbEBkY2UuazEyLndpLnVzPC9hPgomZ3Q7IHdyb3RlOjxicj4KCjxkbD4KPGRkPkhp IE5pY29sZS08YnI+Cgo8L2RkPjxkZD5JJiMzOTttIGxvb2tpbmcgYXQgb3VyIHRlc3QgZGF0YSBm b3Igb3VyIHNjaG9vbCBkaXN0cmljdCBhbmQgYW0gdHJ5aW5nIHRvCmdldCBhIGhhbmRsZSBvbiBj cmVhdGluZyBzb21lIGN1c3RvbSByZXBvcnRzIGJlY2F1c2Ugc29tZSBvZiB0aGUgcmVwb3J0cwpp biB0aGUgV2l6YXJkIGp1c3QgZG9uJiMzOTt0IHB1bGwgZW5vdWdoIG9yIHRoZSByaWdodCBkYXRh Ljxicj48YnI+Cgo8L2RkPjxkZD5XaGVuIEkgZ28gaW50byB0aGUgY3VzdG9tIHJlcG9ydCBhcmVh IEkmIzM5O20gZ2V0dGluZyBjb25mdXNlZCBhcyB0byB3aGF0CmE7OyBvZiB0aGUgdGhpbmdzIG1l YW4gaW4gU3RlcCAzIHdoZXJlIHlvdSBzZWxlY3QgY29sdW1ucyBmb3IKZGlzcGxheS4mbmJzcDsg SXMgdGhlcmUgc29tZXBsYWNlIHRoYXQgZGVzY3JpYmVzIGVhY2ggb2YgdGhlc2Ugc28gdGhhdCBJ CmNhbiBtYWtlIGEgZ29vZCBjaG9pY2U/PGJyPjxicj4KCjwvZGQ+PGRkPkFueSBoZWxwIHlvdSBj b3VsZCBnaXZlIG1lIHdvdWxkIGJlIGFwcHJlY2lhdGVkLjxicj48YnI+Cgo8L2RkPjxkZD5UaGFu a3MsPGJyPjxicj4KPGJyPgoKPC9kZD48ZGQ+TWFyaWUgSi4gV2FyZGFsbDxicj4KCjwvZGQ+PGRk PkxpYnJhcnkgTWVkaWEgU3BlY2lhbGlzdDxicj4KCjwvZGQ+PGRkPk1vdW50YWluIEJheSBFbGVt ZW50YXJ5IFNjaG9vbDxicj4KCjwvZGQ+PGRkPjg2MDIgU2Nob2ZpZWxkIEF2ZS48YnI+Cgo8L2Rk PjxkZD5XZXN0b24sIFdJIDU0NDc2PGJyPgoKPC9kZD48ZGQ+PGEgaHJlZj0ibWFpbHRvOm13YXJk YWxsQGRjZS5rMTIud2kudXMiIHRhcmdldD0iX2JsYW5rIj5td2FyZGFsbEBkY2UuazEyLndpLnVz PC9hPjxicj4KCjwvZGQ+PGRkPlBob25lOiA3MTUtMzU1LTAzMDIgZXh0LiA1ODI0PGJyPjxicj4K CjwvZGQ+PGRkPkNoYW5nZSBUb2RheSwgQ2hhbmdlIFRvbW9ycm93LCBLZWVwIENoYW5naW5nPGJy Pjxicj4KCjwvZGQ+PC9kbD48YnI+PC9kaXY+PC9kaXY+Cl9fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fPGJyPgpLb2hhIG1haWxpbmcgbGlzdDxicj4KPGEgaHJl Zj0ibWFpbHRvOktvaGFAbGlzdHMua2F0aXBvLmNvLm56IiB0YXJnZXQ9Il9ibGFuayI+S29oYUBs aXN0cy5rYXRpcG8uY28ubno8L2E+PGJyPgo8YSBocmVmPSJodHRwOi8vbGlzdHMua2F0aXBvLmNv Lm56L21haWxtYW4vbGlzdGluZm8va29oYSIgdGFyZ2V0PSJfYmxhbmsiPgpodHRwOi8vbGlzdHMu a2F0aXBvLmNvLm56L21haWxtYW4vbGlzdGluZm8va29oYTwvYT48L2Jsb2NrcXVvdGU+PC9kaXY+ Cjxicj4KCjxkaXY+Cjxmb250IHNpemU9IjQiIGZhY2U9IkdhcmFtb25kIj5LYXRoeSBSaXBwZWw8 L2ZvbnQ+PGZvbnQgc2l6ZT0iNCIgZmFjZT0iR2FyYW1vbmQiPjxicj4KPC9mb250PjwvZGl2PgoK PGJyPl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fPGJyPgpL b2hhIG1haWxpbmcgbGlzdDxicj4KPGEgaHJlZj0ibWFpbHRvOktvaGFAbGlzdHMua2F0aXBvLmNv Lm56Ij5Lb2hhQGxpc3RzLmthdGlwby5jby5uejwvYT48YnI+CjxhIGhyZWY9Imh0dHA6Ly9saXN0 cy5rYXRpcG8uY28ubnovbWFpbG1hbi9saXN0aW5mby9rb2hhIiB0YXJnZXQ9Il9ibGFuayI+aHR0 cDovL2xpc3RzLmthdGlwby5jby5uei9tYWlsbWFuL2xpc3RpbmZvL2tvaGE8L2E+PGJyPgo8YnI+ PC9ibG9ja3F1b3RlPjwvZGl2Pjxicj5BcyBmYXIgYXMgSSBrbm93LCB0aGlzIGlzIGR1ZSB0byB0 aGUgY29sdW1ucy5kZWYgZmlsZSBub3QgYmVpbmcgdXAgdG8gZGF0ZSB3aXRoIHRoZSBLb2hhIGRh dGFiYXNlLjxicj48YnI+QSB3aGlsZSBiYWNrLCB3ZSBkaXNjdXNzZWQgdXNpbmcgTXlTUUwmIzM5 O3MgQ09NTUVOVCBvcHRpb24gdG8gcHV0IGRlc2NyaXB0aXZlIGluZm9ybWF0aW9uIGluIHRoZSB0 YWJsZSBzY2hlbWEuIFdlIGhhdmUgYSBjb3VwbGUgb2Ygb3B0aW9uczo8YnI+Cjxicj4qIFVwZGF0 ZSBjb2x1bW5zLmRlZiBzbyB0aGF0IGl0IGhhcyBhbGwgb2YgdGhlIGNvbHVtbnMgcmVmZXJlbmNl ZCBieSB0aGUgZ3VpZGVkIHJlcG9ydHMgdG9vbC48YnI+KiBVc2luZyBhIGRiIHVwZGF0ZSwgYWRk IGNvbW1lbnRzIHRvIGFsbCBvZiB0aG9zZSBjb2x1bW5zLiBUaGVzZSBjYW4gYmUgZ290dGVuIGJ5 IFNIT1cgRlVMTCBDT0xVTU5TIEZST00gJmx0O3RhYmxlJmd0Oy4gVGhpcyBoYXMgdGhlIGFkdmFu dGFnZSBvZiBiZWluZyBtb3JlICZxdW90O3Byb3BlciZxdW90OywgYnV0IGlzIHlldCBhbm90aGVy IGRpc3BsYXllZCBzdHJpbmcgaW4gdGhlIGRhdGFiYXNlIHRoYXQgd291bGQgaGF2ZSB0byBiZSB0 cmFuc2xhdGVkLi4uIHNvbWVob3cuPGJyPgo8YnI+TXkgdm90ZSBpcyBmb3IgY29sdW1ucy5kZWYs IHNpbmNlIGl0JiMzOTtzIHVuZGVyIHRoZSB0ZW1wbGF0ZSB0cmVlIGFuZCB0aGVyZWZvcmUgZWFz aWx5IGludGVybmF0aW9uYWxpemVkLjxiciBjbGVhcj0iYWxsIj48YnI+VGhvdWdodHM/PGJyPjxi cj4tLSA8YnI+SmVzc2UgV2VhdmVyPGJyPlNvZnR3YXJlIERldmVsb3BlciwgTGliTGltZTxicj4K PC9kaXY+Cg== --===============1256005694422152050==-- From chris@bigballofwax.co.nz Wed Oct 1 22:03:21 2008 From: Chris Cormack To: koha-devel@lists.koha-community.org Subject: Re: [Koha-devel] [Koha] Creating reports in Koha 3.0 Date: Thu, 02 Oct 2008 07:49:15 +1200 Message-ID: <606aab810810011249r42beb679p705130a42f404bc1@mail.gmail.com> In-Reply-To: <6bd6de210810010918r4f517aa1lfc31bae4035d4ed9@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============3376941869960321840==" --===============3376941869960321840== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit On Thu, Oct 2, 2008 at 4:18 AM, Jesse Weaver wrote: > >> > > As far as I know, this is due to the columns.def file not being up to date > with the Koha database. > > A while back, we discussed using MySQL's COMMENT option to put descriptive > information in the table schema. We have a couple of options: > > * Update columns.def so that it has all of the columns referenced by the > guided reports tool. > * Using a db update, add comments to all of those columns. These can be > gotten by SHOW FULL COLUMNS FROM
. This has the advantage of being > more "proper", but is yet another displayed string in the database that > would have to be translated... somehow. > > My vote is for columns.def, since it's under the template tree and therefore > easily internationalized. That was the plan I had when I put it there, so I vote for this too :) Chris --===============3376941869960321840==--