Re: [Koha] Parsing public reports
Hi Alexander, That works !! Thanks 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 à 01:53, Alexander Borkowski < alexander.borkow...@kau.se> a écrit : > Hi Alvaro, > > The JSON data you are seeing in the browser is an array (of arrays) not a > JSON object. Accordingly, $json_obj is a reference to an Perl array not a > Perl hash. Hence the output > > JSON OBJ: ARRAY(0x564ec76dd7f8) > > and Perl's complaint about $json_obj being treated as hash reference: > > Not a HASH reference at reporte53-2.pl line 23. > > The same goes for $row, too. It is also an array reference. Try to change > the end of your script to this: > > print "JSON OBJ: " . $json_obj . "\n"; > print scalar(@{$json_obj}), " rows:\n"; > > foreach my $row (@{$json_obj}){ > print join(" ", @{$row}), "\n"; > } > > Hope this helps, > > Alexander > > ___ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Adding Patron Error
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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] delete content of a biblio instance
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 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 > a > > > > écrit : > > > Am Dienstag, 7. Juli 2020, 17:55:20 CEST schrieb rogan.ha...@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 < > > > > > > lmoisesro...@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.oer...@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@lists.katipo.co.nz > > > > > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > > > > ___ > > > > > > > > > > Koha mailing list http://koha-community.org > > > > > Koha@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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Error in Tools
Hi there. Have you tried with the untranslated interface? (i.e. english) El mié., 8 jul. 2020 a las 14:29, Victor Barroso Oliveira (< vbovic...@gmail.com>) escribió: > I noticed that when I change the language to Portuguese Brazil (pt-BR) the > tools module has an error. > > Em qua., 8 de jul. de 2020 às 13:57, Victor Barroso Oliveira < > vbovic...@gmail.com> escreveu: > > > 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 > > > ___ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Error in Tools
I noticed that when I change the language to Portuguese Brazil (pt-BR) the tools module has an error. Em qua., 8 de jul. de 2020 às 13:57, Victor Barroso Oliveira < vbovic...@gmail.com> escreveu: > 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 > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Error in Tools
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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Webinar on Digital Library Technology July 15-16, 2020
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=sharing 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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Wrong order wehen sorting public list by copyright year
Hi We are working with Koha 18.11.05 on Debian GNU/Linux 8. In our library we found in the OPAC it is not possible to sort public lists correctly by copyright date. As far as I know sorting by copyright date would follow the content of MARC 008 position 7-10. But looking at an actual sorting we see the sorting is as follows 2018 2017 2016 2015 2015 2014 2014 2013 2011 2017 <-- here it starts getting wrong 2019 2018 2016 2018 2016 ... Alle these records have correct content in MARC 008 and MARC 264$c. Strangely we found if a record has content in MARC 260$c and 264$c it changes the sort order - even if only MARC 008 should be relevant for the sort order. How can we achieve the correct sort order? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Unable to create patron
Hi We are working with Koha 18.11.05 on Debian GNU/Linux 8. In our library we try to add a new patron in Koha menu "Patrons" by clicking the button "+ New patron" - but absolutely nothing happens: No error message on the screen, no log entry anywhere in "/var/log/koha/INSTANCE" or "/var/log/mysql", nothing in the Mozilla Firefox Inspektor Console. According to the library this happens since some update in the past. What could be the reason for this behaviour? By the way, adding a new patron by clicking Koha menu "Patrons > Quick add new patron" works as expected. Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Parsing public reports
Hi Alvaro, The JSON data you are seeing in the browser is an array (of arrays) not a JSON object. Accordingly, $json_obj is a reference to an Perl array not a Perl hash. Hence the output JSON OBJ: ARRAY(0x564ec76dd7f8) and Perl's complaint about $json_obj being treated as hash reference: Not a HASH reference at reporte53-2.pl line 23. The same goes for $row, too. It is also an array reference. Try to change the end of your script to this: print "JSON OBJ: " . $json_obj . "\n"; print scalar(@{$json_obj}), " rows:\n"; foreach my $row (@{$json_obj}){ print join(" ", @{$row}), "\n"; } Hope this helps, Alexander ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Parsing public reports
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 =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 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha