Dear All, I am able to upload the data on the koha in all respective correct location like barcode, branch library, main library, item type, etc. During the search in OPAC/ Staff Client interface I am able to see all the bibliographic details and item details (local MARC21 952 detail) in the correct location, but i am not able to see the holding details or issue/return the books. Please guide. Thanks and Regards R Sunil Kumar Library Technologist Ecole Solutions Pvt Ltd Level 15 Concorde Towers UB City 1 Vittal Mallya Road Bangalore 560001 India Ph: +91 9686 576 695 Fax: +91 80 40300400 Mail:sunil.kumar@ecoleglobal.com Web: www.ecoleglobal.com On Sat 02/07/11 12:00 AM , koha-request@lists.katipo.co.nz sent:

Send Koha mailing list submissions to koha@ lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/kohaor, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz You can reach the person managing the list at koha-owner@lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..."

Today's Topics:

1. Re: Report Help (Nicole Engard) 2. Re: Report Help (Fr?d?ric Demians) 3. Re: Report Help (Chris Nighswonger) 4. Edting label-create-pdf.pl does not make effect (tanzeem) 5. A couple of questions about Koha (Christine Othitis) 6. Re: Koha - insecure = off (Fred Pierre) 7. Re: A couple of questions about Koha (Nicole Engard) 8. Adding child to staff patron record (Holly Hancock)

----------------------------------------------------------------------

Message: 1 Date: Fri, 1 Jul 2011 10:19:13 -0400 From: Nicole Engard il.com>Subject: Re: [Koha] Report Help To: Chris Nighswonger < cnighswonger@foundations.edu>Cc: Koha lists.katipo.co.nz>Message-ID: w@mail.gmail.com>Content-Type: text/plain; charset=UTF-8

On Fri, Jul 1, 2011 at 10:09 AM, Chris Nighswonger < cnighswonger@foundations.edu> wrote:> The sad thing is if it was comma or otherwise delimited we could do some> splitting foo. But spaces will inevitably appear in the date in the> specified fields.

Chris, in this library's case (cause they do have professional catalogers) the subject headings all end in periods ... could we use that instead of the comma/space?

Nicole

------------------------------

Message: 2 Date: Fri, 01 Jul 2011 18:23:48 +0200 From: Fr?d?ric Demians mil.fr>Subject: Re: [Koha] Report Help To: Nicole Engard il.com>Cc: Koha lists.katipo.co.nz>Message-ID: DF494.1020406@tamil.fr>Content-Type: text/plain; charset=ISO-8859-1; format=flowed

...

I wrote this report to get all subject headings in a Koha system that> start with key phrases:

You can get your headings with a Perl script.

You can also export all your biblio records in ISO2709 and then combine various standard Linux commands to extract and select your headings.

For example, on Linux Shell:

mysql my_koha_db_name -e 'SELECT marc FROM biblioitems' | \ yaz-marcdump | grep ^610 | sort | uniq

After grep ^610, you can add a text filter to extract just $a without field name and other subfields.

-- Fr?d?ric DEMIANS http://www.tamil.fr/u/fdemians.html

------------------------------

Message: 3 Date: Fri, 1 Jul 2011 12:33:34 -0400 From: Chris Nighswonger < cnighswonger@foundations.edu>Subject: Re: [Koha] Report Help To: Nicole Engard il.com>Cc: Koha lists.katipo.co.nz>Message-ID: Content-Type: text/plain; charset="utf-8"

...

On Fri, Jul 1, 2011 at 10:09 AM, Chris Nighswonger> < cnighswonger@foundations.edu> wrote:> > The sad thing is if it was comma or otherwise delimited we could do some> > splitting foo. But spaces will inevitably appear in the date in the> > specified fields.

Chris, in this library's case (cause they do have professional> catalogers) the subject headings all end in

On Fri, Jul 1, 2011 at 10:19 AM, Nicole Engard il.com> wrote: periods ... could we use> that instead of the comma/space?

...

Assuming there were no periods embedded anywhere else in the data its possible. The 'foo' I mentioned amounts to writing a stored procedure inyour db do handle the splitting since MySQL does not have a splitting function. So it would require some coding apart from the reports tool inKoha.

Kind Regards, Chris