- Koha - lists.katipo.co.nz

Report of staff login reg.
by arun kishore 29 Apr '16

29 Apr '16

Hi, Could anyone help me out with an SQL query for getting staff record creation/modification statistics along with date of creation and barcode of items? With kind regards, Arun Kishore, B.L. College Librarian (UGC) Sanatana Dharma College Sanathanapuram (PO) Alappuzha Keralam - 688003 ............................................ Phone (O): 0477 - 2268450 Phone (R): 0476 - 2691951 Mobile: +91 9496621951 ........................................ Linkedin | Facebook Web: www.sdcollege.in .........................................

1 0

translate site could not access
by Anthony Mao 29 Apr '16

29 Apr '16

For your information, I could not access http://translate.koha-community.org/ from Taiwan, at the time 2016.4.19 04:06 GMT -- Wishing you all the best. . . . Anthony Mao 毛慶禎＋886 2 29052334 (voice) + 886 2 29017405 (FAX)

2 1

rebuild index
by regina kivuyo 29 Apr '16

29 Apr '16

when i tried to run the env KOHA_CONF=/etc/koha/koha-conf.xml PERL5LIB=/usr/share/koha/lib /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl -b -r -v it give me error Unable to load Koha::NorwegianPatronDB at /usr/share/koha/lib/C4/Members.pm line 49. Warning: You are running this script as the user 'root'. If this is intentional you must explicitly specify this using the -run-as-root switch Please do '/usr/share/koha/bin/migration_tools/rebuild_zebra.pl --help' to see usage. im using ubuntu 12.04 koha 3.18 downloaded package help please -- regina

1 0

Re: [Koha] Best practices for koha - journal migration using marcedit
by Paul A 28 Apr '16

28 Apr '16

At 08:24 PM 4/28/2016 +0530, Indranil Das Gupta wrote: [snip > > I would like to know how to covert excel data of journals especially with > > large number of issues(having more than 600 issues) for each journal. Tried > > using marcedit and it is giving error - 501 when trying to covert mrk to > > mrc format. [snip] > > Is there any other way how I can covert this data to mrc format. > >Yes, if you do programming or have access to a programmer adept at >handling MARC21 data, you can. If you have details, please make them available. We looked into this (again after MarcEdit attempts), but ran into problems (from memory, more_subfields_xml) ... and we've got about .25 million items to add ;=} Thanks -- Paul

2 1

Package for 3.22.6 now available
by Galen Charlton 28 Apr '16

28 Apr '16

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Hi, The package for Koha 3.22.6 is now available from the Koha APT repository debian.koha-community.org. As always, instructions for installing from the packages can be found at https://wiki.koha-community.org/wiki/Debian Regards, Galen - -- Galen Charlton gmcharlt(a)gmail.com -----BEGIN PGP SIGNATURE----- Version: Mailvelope v1.3.6 Comment: https://www.mailvelope.com wsFcBAEBCAAQBQJXImhBCRATSna3Q9mGMAAAOUgQAIyRvpl6pAc7JwjdQrq6 O/CNU/6KVH6AEOEyDYvJCrab+aCs5xlnnC+m6SMZ16QT0Yyz3P5U0wTFxNp+ 8rs8aRgQHjRQQruu0G+JsQ48/+gLhvD8pGmvZZlgfabhWvFRMABeY5ZCj1Ja Y/qYd0x1qfYr1zfPosqIiXHdlQvkhFb8LAeiunmYiNarpe/0WNOVK1kUHt5H 53D92TUKNI5E6TUcBBUfm4AKiqBsEz01ggrk27I9ugiADtzAIljTScbQzkDK fXMaZCz/nY2qedUEJkYlgg2iJ2mWEjZXKag4P5mCevSAxh+78yMe7qSd86SJ En2lgegK+FT2FC98bM5IH/qxSOJ+cjEZpNaXHxpTB13AsjuSB9i4+ng0Xpj/ McKpq2BVILXap6aBAGL9vcRrqVaUlcPZyLVdQIp/LeZ8/Z8CagUgWYlyQZAn yt0itYyGLlGqmfKLMBzb6qtVHAaJHfXSLfP7WSCSkqsWZ3O0vgt0ZgzDcvkx eEbMcL5V1GVGl/JkfahonuFYV9Ex4EMyR2qaUmmprqI5gSIJhDeFi1H8AiIX U9KH3lyCEON60Ly0H+EXteDfU93ONerscBIlu4sXXL0PRBvXSs7atIJeVpUq 86mgvKe+tfjBiE/1sJS4cmpN7CsUh6AOqN8zRvjjzYWKFbX7xql2HjfVeHII ImwN =rTA1 -----END PGP SIGNATURE-----

1 0

Best practices for koha - journal migration using marcedit
by Suresh Kumar Tejomurtula 28 Apr '16

28 Apr '16

Dear team, I would like to know how to covert excel data of journals especially with large number of issues(having more than 600 issues) for each journal. Tried using marcedit and it is giving error - 501 when trying to covert mrk to mrc format. Is there any other way how I can covert this data to mrc format. -- Regards T. Suresh Kumar

2 1

Koha 3.20.11 released
by Frédéric Demians 27 Apr '16

27 Apr '16

It is with great pleasure that we announce the release of Koha 3.20.11, a maintenance release of the Koha open source integrated library system. See the full release notes here: https://koha-community.org/koha-3-20-11-released/ Download: http://koha-community.org/download-koha/ Stay tuned for Debian/Ubuntu package availability. -- Frédéric DEMIANS http://www.tamil.fr/fdemians

1 0

OAI-PMH in 3.22
by Pedro Amorim 27 Apr '16

27 Apr '16

Hello all, After the upgrade to 3.22, OAI-PMH response is now using oai_dc:collection instead of oai_dc:dc. NOTE: You might need to access the corresponding staff interface for the links below, because the database may have been reseted and OAI repository might be disabled. *This is an example from online demo version 3.16 (Haven't got any handy 3.20):* http://library.software.coop/cgi-bin/koha/oai.pl?verb=ListRecords&metadataP… *This is from online demo 3.22:* http://koha.adminkuhn.ch:8000/cgi-bin/koha/oai.pl?verb=ListRecords&metadata… Can someone else confirm this? Is this intentional? I have found nothing regarding this in the release notes. Thanks, Pedro Amorim

4 6

Migration koha 3.12 (debian 6) to a fresh koha 3.22 (debian 8)
by Administrateur 27 Apr '16

27 Apr '16

Hello, I am trying to do the migration from koha 3.12 (I'm not the one who installed it) to koha 3.20 or 3.22. The one on debian 3.22 is a freshly installed debian 8. I made my test using a cloned virtual machine so the new system only has mysql-server and apache2. Nothing else is installed or configured. I think I've encountered a problem with Zebra. Both of my installations uses the debian package koha-common. I transfered the database and the files from 3.12 to 3.22 with koha-dump and then koha-restore. (doc-ite is the name of my koha instance) Here is what happen after a restore : ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'koha_doc-ite'@'%' ERROR 1046 (3D000) at line 2: No database selected DBI connect('dbname=koha_doc-ite;host=localhost;port=3306','koha_doc-ite',...) failed: Access denied for user 'koha_doc-ite'@'%' to database 'koha_doc-ite' at /usr/share/perl5/DBIx/Connector.pm line 32. Can't call method "do" on unblessed reference at /usr/share/koha/lib/C4/Context.pm line 793. Something went wrong rebuilding biblio indexes for doc-ite DBI connect('dbname=koha_doc-ite;host=localhost;port=3306','koha_doc-ite',...) failed: Access denied for user 'koha_doc-ite'@'%' to database 'koha_doc-ite' at /usr/share/perl5/DBIx/Connector.pm line 32. Can't call method "do" on unblessed reference at /usr/share/koha/lib/C4/Context.pm line 793. Something went wrong rebuilding authority indexes for doc-ite Restarting apache2 (via systemctl): apache2.service. But even with thoses errors the DB was populated and I was able to do a koha-upgrade-schema without errors. The user koha_doc-ite can connect to the mysql database with the password in koha-conf.xml (I had to manually reset the password). I can connect to the front-end and the back-end and all the data seems to be there (If I look in overdue, I can see my books). But I can't search any books in the library. No hits. My zebrasrv is started (with koha-start-zebra) and running. The weird part is that if I don't do use 'koha-rebuild-zebra' after a fresh restore I have some results with zebra but not all of them. The number of hits is correct but there is like 3 results instead of ten in the result page. Then if I do a complete rebuild here is the message I get : # koha-rebuild-zebra -v -f doc-ite Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/doc-ite/biblios Zebra authorities directory = /var/lib/koha/doc-ite/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/koha/doc-ite/rebuild/rebuild..LCK BIBLIONUMBER in : 001$@ BIBLIOITEMNUMBER in : 090$a ================================ skipping authorities ==================== exporting biblio ==================== 78101.................................................................................................... Records exported: 78124 ==================== REINDEXING zebra ==================== 10:58:08-19/04 zebraidx(24995) [warn] Record didn't contain match fields in (bib1,Local-number) ==================== CLEANING ==================== Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/doc-ite/biblios Zebra authorities directory = /var/lib/koha/doc-ite/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/koha/doc-ite/rebuild/rebuild..LCK BIBLIONUMBER in : 001$@ BIBLIOITEMNUMBER in : 090$a ================================ ==================== exporting authority ==================== 1........ Records exported: 9 ==================== REINDEXING zebra ==================== skipping biblios ==================== CLEANING ==================== And then no more results. 0 hit. /var/log/koha/zebra.log /var/log/koha/zebra-error.log Are all empty and /var/log/koha/zebra-output.log simply contain "zebrasrv(1) [warn] ir_session (exception)" If I connect using yaz-client $ yaz-client -c /etc/koha/zebradb/ccl.properties unix:/var/run/koha/doc-ite/bibliosocket Connecting...OK. Sent initrequest. Connection accepted by v3 target. ID : 81 Name : Zebra Information Server/GFS/YAZ Version: 4.2.30 98864b44c654645bc16b2c54f822dc2e45a93031 Options: search present delSet triggerResourceCtrl scan sort extendedServices namedResultSets Elapsed: 0.001318 Z> base biblios Z> f Bible Sent searchRequest. Received SearchResponse. Search was a success. Number of hits: 0, setno 1 SearchResult-1: term=Bible cnt=0 records returned: 0 The result I'm getting on koha 3.12 is : Z> f Bible Sent searchRequest. Received SearchResponse. Search was a success. Number of hits: 5876, setno 1 SearchResult-1: term=Bible cnt=5876 records returned: 0 Elapsed: 0.002232 There is also difference in some files (But I think it's because Zebra can't generate an index) /var/lib/koha/doc-ite/biblios/register/ on debian 6 is ~550Mb whereas the one on debian 8 is 20Kb (basically empty) Because it didn't work, I tried to manually dump the SQL from 3.12 and load it on a freshly installed koha 3.22 after creating a dummy instance with koha-create, same problem. I did the same with koha oldstable (3.20), but no success. I even tried to install the 3.12 from the tarball on debian 8 but I've encountered many issues with perl and non-existing lib. I couldn't make it work. I looked for a 3.12 debian repository but it don't seem to exist. Usually I always find solutions but this time I really need help because I have no more idea on how to do it. I'm new to the koha world (started to look into it 2 weeks ago) and I feel like I'm missing something simple. Thanks. -- Regards. Joël M. Administrateur Réseaux/Système Institut Biblique de Nogent-sur-Marne.

3 2

Tag 952 field migrated records not shown
by Decka David 27 Apr '16

27 Apr '16

Dear Koha team, It's not happening right when I am migrating MARC records from the Athena library system to Koha. I have set my Koha MARC bibliographic framework correct and the results shown Ok from the MARC test. From the old Athena 852 tag there is little difference in MARC subfields. I have edited MARC fields especially the tag 852 to 952 and its subfields using the MARC editor tool. The only problem now is that tag 952 fields which when migration test records, it seems no records were shown in the 952 Holdings tag. Can someone advice me how to solve this problem or am I missing a step during this process for smooth flow of migration. Does it actually happened that the tag 952 marc field are easy to import from marc file after editing using the marc editor. Or will I be editing all 99 000+ records of the tag 952 fields manually? Regards Decka

2 1