- Koha - lists.katipo.co.nz

report behaves differently if run from intranet or the outside
by Alvaro Cornejo 12 Jul '20

12 Jul '20

Hi I´ve been working with a report to get records stats and found a strange behaviour. The exactly same report provides different data if run it from the report interface in koha than calling it from the outside (public link) either from a perl script or from a browser (tested on ie / chrome) The query is quite simple: ------------------ SELECT ExtractValue(metadata,'//datafield[@tag="942"]/subfield[@code="c"]') AS Tipo, FORMAT((COUNT(DISTINCT biblionumber)),0) AS Registros, FORMAT((COUNT(itemnumber)),0) AS Volúmenes FROM biblio_metadata LEFT JOIN items USING (biblionumber) GROUP BY Tipo WITH ROLLUP ------------------------- if I run it from intranet I get (being set public): Tipo Registros Volúmenes Analitico de Revista 7 7 ANLIB 6,939 10 ANREV 8,351 671 ART 96,109 95,054 ART-E 50 1 LIB 30,433 30,783 LIB-A 4,919 91 LIB-E 27 27 SEP 1,304 1,300 SER 165 485 SER-E 1 2 TESIS 9 9 VID 4 4 148,318 128,444 (this is from ROLLUP If run it from the outside I get only the first 10 lines: (tested with script and manually parse the JSON and calling the public link with chrome and ie) Tipo Registros Volúmenes Analitico de Revista 7 7 ANLIB 6,939 10 ANREV 8,351 671 ART 96,109 95,054 ART-E 50 1 LIB 30,433 30,783 LIB-A 4,919 91 LIB-E 27 27 SEP 1,304 1,300 SER 165 485 I initially thought there were some bad records and fixed some that do not have a 942c field defined. I tested it with a condition to get only new records in the last 30 days and this behavior does not happen. Although the report have only 8 rows including the rollup Updated query ------------------ SELECT ExtractValue(metadata,'//datafield[@tag="942"]/subfield[@code="c"]') AS Tipo, FORMAT((COUNT(DISTINCT biblionumber)),0) AS Registros, FORMAT((COUNT(itemnumber)),0) AS Volúmenes FROM biblio_metadata LEFT JOIN items USING (biblionumber) WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= items.dateaccessioned GROUP BY Tipo WITH ROLLUP ------------------------- Same result through intranet and public links with a script / browser Tipo Registros Volúmenes ANLIB 1 1 ART 895 895 LIB 60 62 LIB-E 22 22 SEP 21 21 SER 1 1 VID 4 4 1,004 1,006 I´ve increased the interval of days to this second report until I got more than 10 lines and the behaviour repeats. From the public link I can get no more than 10 lines but from within koha I get all the lines. I´m running koha 19.11.07.000 with perl 5.026001 in ubuntu 18.04 Any ideas? I guess there is no record limit since I´ve coverflow running and I get more than 10 records. Might be a timeout? It's a heavy query but runs for about 30 seconds on intranet and from a browser. Regards Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire

2 3

Release of LiveDVD 3.0
by mohan pradhan 10 Jul '20

10 Jul '20

HealthNet Nepal in collaboration with the following persons have released v3.0 of LiveDVD: Prof. Mohan Raj Pradhan, Ph. D. Mr. Demian Katz Former Prof. ARD Prasad, Ph. D. Mr. Sakib Ahmed Mr. Omar Khan Ms. Goma Banjade This LiveDVD consists of the following software : Koha ILS 19.11.05, DSpace 6.3, WordPress 5.4.2, VuFind 6.1.1, SubjectsPlus 4.5 and Exim mail server. In VuFind, a feature of union catalogue is incorporated and this version has also incorporated SDI service. In WordPress, a plugin has been developed which can retrieve data from SubjectsPlus through API. In DSpace, Mirage2 is incorporated which helps to access data from Mobile and Tablet. The live demo of LiveDVD is going to held in webinar in July 15, 2020. You can participate in this webinar by registering through the link: https://forms.gle/ecunNrR1mmtqxn8q8 The LiveDVD can be downloaded free of cost from the link: https://sourceforge.net/projects/livedvdvufindkohadspace/files/livedvd64bit… With regards Sincerely Yours, Prof. Mohan Raj Pradhan, Ph. D. Chairman HealthNet Nepal Web: mpradhan.com.np

1 0

Home Location and Its Purpose
by Charles Kelley 10 Jul '20

10 Jul '20

Hello, all! Here's another question for which I have been looking for an answer in vain: What are the purpose and use of the home location? I understand the purpose and use of the permanent location, but not those of the home location. If it's something like a temporary location, say, when a book is transferred from REFERENCE to TESTER, with the ultimate goal of returning it to REFERENCE, I can understand that. But I amn't sure of my presumption. So would someone be willing to help me out with this, please? (Disabusals are welcome.) Many thanks. -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

2 2

coverflow 2.4.35 error
by Pavlo Bobesiuk 10 Jul '20

10 Jul '20

Hi! Today I tried reinstalling coverflow plugin (v. 2.4.35) and restart koha-plack but without result. In plug-in configuration I received the following message when I tried to write mapping: Error: YAML Error: Inconsistent indentation level Code: YAML_PARSE_ERR_INCONSISTENT_INDENTATION Line: 2 Document: 1 at /usr/share/perl5/YAML/Loader.pm line 804. and this of the end: Status: 302 Found Location: /cgi-bin/koha/plugins/plugins-home.pl -- З повагою Павло Бобесюк=))

2 1

Re: [Koha] Frameworks and Their Purpose
by Charles Kelley 10 Jul '20

10 Jul '20

Hello again, all! In an earlier exchange, on 7 July 2020 at 09:51, I wrote: I do have a follow-up question: Is it possible in Koha to change a framework > of a group records en masse? For example, if I have a group of 747 maps > (949 $c = "MAP") but their framework is BKS, can I change the framework > to MAP through Koha in one fell swoop (and if so, how so); or must I > painstakingly change them one at a time? > > I have tried exporting them into MarcEdit and importing them anew into > Koha while selecting "Import this batch into the catalog" with "Add new bibliographic > records into this framework:" (select from the dropdown menu), but the > framework for each record remains as it was before the exporting and > importing. > On 6 July 2020, at 21:14, Eric Bégin <eric.begin(a)inLibro.com> replied: > As far as I know, there is no way to change the records framework in batch > editing. > > If I had to do it, I would update the data directly in the database. > > The framework is defined as the 'frameworkcode' column of the 'biblio' > table. > I was afraid of that. Thanks for the reply. -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

2 2

Re: [Koha] delete content of a biblio instance
by Alvaro Cornejo 09 Jul '20

09 Jul '20

Hi, Sorry, yes, that was it. It has been a long time since I did that import. I think it was a two step process... Regards Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le mer. 8 juil. 2020 à 16:40, Heinz-Jürgen Oertel <hj.oertel(a)t-online.de> a écrit : > Am Dienstag, 7. Juli 2020, 20:22:07 CEST schrieb Alvaro Cornejo: > > Hi, > > > > If you have imported the records through the upload tool of koha, you can > > remove those same records through the same tool. > > > > Regards, > > > > Alvaro > > Hi Alvaro, > > do you mean via > Tools-> Staged MARC record management > > ==> Managed staged MARC records, including completing and reversing imports > > to reverse the import? > > for some unknown reasons, this did not work > > Heinz > > > Le mar. 7 juil. 2020 à 12:32, Heinz-Jürgen Oertel <hj.oertel(a)t-online.de> > a > > > > écrit : > > > Am Dienstag, 7. Juli 2020, 17:55:20 CEST schrieb rogan.hamby(a)gmail.com > : > > > > Well, it depends. > > > > > > to your first question. It is not a used running system yet. I just > used > > > it to > > > get familiar with it. The first import in a new biblio was not > successful, > > > not > > > the correct import data used. Now I like to empty it and import a new > > > export > > > from another system. > > > > > > > If you only have bibs and items loaded this should work: > > > > > > > > SET FOREIGN_KEY_CHECKS = 0; > > > > truncate biblio; > > > > truncate biblioitems; > > > > > > > > truncate items; > > > > truncate auth_header; > > > > truncate sessions; > > > > truncate zebraqueue; > > > > truncate biblio_metadata; > > > > SET FOREIGN_KEY_CHECKS = 1; > > > > > > I assume that are all data base commands to the biblio data base? > > > > > > > However, if you've had this as a living system with transactions you > > > > will > > > > also need to look at cleaning out a lot of other tables such as > > > > > > statistics, > > > > > > > issues, etc.... > > > > > > see above. > > > > > > Thanks and Greetings > > > > > > Heinz > > > > > > > > On Tue, Jul 7, 2020 at 11:17 AM Luis Moises Rojas < > > > > > > lmoisesrojas(a)gmail.com> > > > > > > > wrote: > > > > > Hi, > > > > > That was my question a few days ago, and there is no way. > > > > > > > > > > I don't know if there is any answer now > > > > > > > > > > El mar., 7 de jul. de 2020 9:40 AM, Heinz-Jürgen Oertel < > > > > > > > > > > hj.oertel(a)t-online.de> escribió: > > > > > > Hello > > > > > > > > > > > > I'm looking for a way to delete the complete content of a biblio > > > > > > > > > > instance, > > > > > > > > > > > not > > > > > > the instance itself in order to keep "Item types", "Patron > > > > > > categories" > > > > > > > > etc. > > > > > > > > > > > Any hint is very welcome. After deleting the content,, I want to > > > > > > import > > > > > > > > > new > > > > > > data via marcxml import. > > > > > > > > > > > > Greetings > > > > > > > > > > > > Heinz > > > > > > > > > > > > _______________________________________________ > > > > > > > > > > > > Koha mailing list http://koha-community.org > > > > > > Koha(a)lists.katipo.co.nz > > > > > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > > > > _______________________________________________ > > > > > > > > > > Koha mailing list http://koha-community.org > > > > > Koha(a)lists.katipo.co.nz > > > > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > -- > > > mit freundlichen Grüßen aus Halle (Saale) > > > > > > Heinz-Jürgen Oertel > > > > > > _______________________________________________ > > > > > > Koha mailing list http://koha-community.org > > > Koha(a)lists.katipo.co.nz > > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > > -- > mit freundlichen Grüßen aus Halle (Saale) > Heinz-Jürgen Oertel > > >

2 2

Adding Patron Error
by Lamb Joseph 09 Jul '20

09 Jul '20

Hello, When adding a patron I get the following error: Something went wrong when creating the patron. Check the logs What logs should I check? Thank you Joseph Lamb Joseph Lamb

2 1

Parsing public reports
by Alvaro Cornejo 09 Jul '20

09 Jul '20

Hi I´m trying to parse the results of a report setup as public but are unable to get the data. This is the script I'm working on #!/usr/bin/perl use strict; use warnings; use LWP::UserAgent; use HTTP::Request; my $ua = new LWP::UserAgent; $ua->agent("Perl API Client/1.0"); my $url = "https://myurl/report?id=53"; my $request = HTTP::Request->new("GET" => $url); my $response = $ua->request($request); print "Response::: " . $response . "\n"; use JSON; my $json_obj = JSON->new->utf8->decode($response->content); print "JSON OBJ: " . $json_obj . "\n"; print $json_obj->{rowCount} . " rows:n"; foreach my $row(@{$json_obj->{rows}}){ print $row->{Key} . ":" . $row->{Value} . "n"; } My debug print gives me: Response::: HTTP::Response=HASH(0x564ec7e6cfa8) JSON OBJ: ARRAY(0x564ec76dd7f8) Not a HASH reference at reporte53-2.pl line 23. Each time I run the script I get different 0X values. If I call the report through a web browser I get [["aa",339],["ab",99094],["am",47957],["as",1641],["gm",1],["jm",1]] And if I add &annotated=1 to my report link I get: [{"Registros":339,"Type":"aa"},{"Type":"ab","Registros":99094},{"Registros":47957,"Type":"am"},{"Type":"as","Registros":1641},{"Registros":1,"Type":"gm"},{"Registros":1,"Type":"jm"}] What am I missing for parsing the report? Regards, Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire

2 2

Error in Tools
by Victor Barroso Oliveira 08 Jul '20

08 Jul '20

Good afternoon, When I try to access the "Tools" module, the error is "Internal Server Error" This is only happening with the "Tools" module. How can I solve this? Thank you, Victor

2 2

Webinar on Digital Library Technology July 15-16, 2020
by mohan pradhan 08 Jul '20

08 Jul '20

VuFind software is going to conduct a two-day webinar on Digital Library Technology. This webinar aims to share the recent trends of worldwide used technologies regarding digital library. The presentation will focus on the software: Koha, DSpace, VuFind, WordPress and SubjectsPlus. The seats are limited and its registration will be first come first basis. For details see the link below: https://drive.google.com/file/d/12LnmShZMW0iSJ7ekEr24xxdbHysLSd7E/view?usp=… For registration, go through the link: https://docs.google.com/forms/d/e/1FAIpQLSehZ_rP V4dUu8Xu9YCt2lRug_BY66FSuCsmwujAnpwNlIXsIg/vi ewform?usp=sf_link Mohan Raj Pradhaninar on Coordinator Webinar on Digital Library Technology

1 0