- Koha - lists.katipo.co.nz

Report_Circulation
by Jameela P 14 Nov '14

14 Nov '14

I have doubts on following issue. 1.We have 03 VIP members who have the privilege to borrow n number of books. I want to generate report (in excel or CSV) for these members. The report may contain all the bibliographical data like ISBN, Class No. , title, author, publisher, eidtion, barcode, price, etc.....The report available in KOHA version 3.12.05.000 does not have the field Title, author etc.... Jameela, at Indian Naval Academy Library

1 0

Zebra rebuild frequency
by Steven Nickerson 14 Nov '14

14 Nov '14

Hi everyone, I know the topic of Zebra index rebuilding comes up periodically and I've tried to find an answer to this but can't seem to locate one. I have the package version of 3.16.02 installed on Debian and have the following "default" cron entry in /etc/cron.d/koha-common: */5 * * * * root test -x /usr/sbin/koha-rebuild-zebra && koha-rebuild-zebra -q $(koha-list --enabled) Aside from this rebuild, is there some other "complete" Zebra rebuild recommended, and if so on what frequency? Thanks! Steve

3 2

Location of koha-conf.xml
by Alyssa Enganio Gono 14 Nov '14

14 Nov '14

Where is usually the location koha-conf.xml . I tried this command: export PERL5LIB=/usr/share/koha/lib export KOHA_CONF=/usr/share/koha/koha-conf.xml /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -v -x but it only gets this error: unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/Context.pm line 373. Can't use an undefined value as a HASH reference at /usr/share/koha/bin/migration_tools How will I fix it? -- View this message in context: http://koha.1045719.n5.nabble.com/Location-of-koha-conf-xml-tp5818688.html Sent from the Koha-general mailing list archive at Nabble.com.

3 3

Report filtered by item type fails
by Elaine Bradtke 13 Nov '14

13 Nov '14

Koha 3.16 According to my statistical report, we have 848 biblios that are continuing resources (BIBITEMTYPE CR) But when I try to build a report that limits the output to these records I get only a handful of records (these uniquely have items attached, 99% of our CR records do not, so this information usually only appears in the 942c). If I run the following report it doesn't list any entries with CR. SELECT biblionumber, ExtractValue(marcxml, '//datafield[@tag="942"]/subfield[@code="c"]') AS comp FROM biblioitems But I can search and retrieve individual records, and they do indeed have CR in the 942c. When I run an advanced search and limit it to this item type, the search results are exactly what I expect to see. I can't figure out how it will count them in one instance, but not list them in another; find them in the advanced search, but not when I query the database with a report. . . We've just moved our server over to a new virtual machine and a different version of Linux. . . Is the above a symptom of indexing problems or some other technical glitch? -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

2 3

No Result Founds in Opac Search
by Alyssa Enganio Gono 13 Nov '14

13 Nov '14

I have a freshly installed Koha 3.16 in a Debian Server. I already imported the MARC records into the catalog, but when I search it on Opac , there is no results found. What shall I do now? I really have to fix it? -- View this message in context: http://koha.1045719.n5.nabble.com/No-Result-Founds-in-Opac-Search-tp5818575… Sent from the Koha-general mailing list archive at Nabble.com.

3 2

Re: [Koha] Bulk return
by Amit Gupta 13 Nov '14

13 Nov '14

Hello Jameela, If you know Koha database structure and know SQL then create SQL script and insert in database. On Thu, Nov 13, 2014 at 5:22 PM, Vinod Kumar Mishra < vinod_librarian(a)rediffmail.com> wrote: > Please refer format of Koha, if you have member code and accession number > than i think you can do it. > > > https://www.google.co.in/search?q=off+line+circulation&ie=utf-8&oe=utf-8&aq… > > On Thu, 13 Nov 2014 15:44:10 +0530 Jameela P wrote > >Please advice me on following... > > > > Recently we failed to use LMS KOHA due to some technical problem. At that > > time we have done bulk return of books of about 12, 000. We have maintained > > the bar code of these returned books in excel spreadsheet. Is there any > > provision to return this book in KOHA in one go, or need I return the book > > one by one. > > > > > > Jameela at Indian Naval Academy Library > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > With regards, > Vinod Kumar Mishra, > Assistant Librarian, > Biju Patnaik Central Library, > NIT Rourkela, > Mob:91+9439420860 > 91+6612462103 (O) > email: vinod_librarian(a)rediffmail.com > : mishravk79(a)gmail.com > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- Regards, Amit Gupta

1 0

Bulk return
by Jameela P 13 Nov '14

13 Nov '14

Please advice me on following... Recently we failed to use LMS KOHA due to some technical problem. At that time we have done bulk return of books of about 12, 000. We have maintained the bar code of these returned books in excel spreadsheet. Is there any provision to return this book in KOHA in one go, or need I return the book one by one. Jameela at Indian Naval Academy Library

3 2

How to migrate from Libsuite to Koha
by Chinmayee Bhange 13 Nov '14

13 Nov '14

Hi, Request help on migrating from Libsuite to Koha. Where is the tag for Shelf or location in Koha? -- *Thanks & Regards,Ms. Chinmayee BhangeLibrarianSt. Francis Institute of Technology (Engineering College)Mumbai - Maharashtra*

2 1

Report_Circulation
by Jameela P 13 Nov '14

13 Nov '14

I have doubts on following issue. 1.We have 03 VIP members who have the privilege to borrow n number of books. I want to generate report (in excel or CSV) for these members. The report may contain all the bibliographical data like ISBN, Class No. , title, author, publisher, eidtion, barcode, price, etc.....The report available in KOHA version 3.12.05.000 does not have the field Title, author etc.... Jameela, at Indian Naval Academy Library

1 0

Report_transfer
by Jameela P 13 Nov '14

13 Nov '14

Our main library consist of 3 Branches of library situated at different locations having 2500 books each. The databases of books of all these branches are maintained in KOHA database.The branch libraries now require the database of the books held at their library separately. They want almost all the field of bibliographical data like ISBN, Class No., title, author, edition, publication, physical description, bar code etc...So please advice me on the following 1) How to generate full report on transferred books in excel or CSV format 2) I have checked the same in SQL Report Library in Wiki.Koha community (Item 4.34), but failed to access the requirement as I am a first time user of SQL report generation methods. Request educate me on the above. Jameela, Information Assistant at Indian Naval Academy

1 0