- Koha - lists.katipo.co.nz

SQL report for list of authorities with occurrences
by Caterina Sansone 31 May '18

31 May '18

Dear all, I have been wandering the web in the last days but couldn't find a solution to my problem : I have a SQL report to obtain a list of authorities (subject : 250a and subfields), but in order to clean the indexes I would like to create a SQL report to obtain a list of authorities with their occurences (how many times each authority has been used). Also, sorting it by alphabetical order would be great. Of course I can see them on Koha but surfing 140 pages is not ideal! We are on Koha 3.22. Does anyone have any idea how to do that? Thanks to all, Caterina

2 4

Re: [Koha] Koha 18.05.00.000: Search in Group of Libraries not working after upgrade
by Ata ur Rehman 30 May '18

30 May '18

Dear Druart / All Thank you very much for response. There was no error during upgrade process. My groups of libraries look as given in screenshots at the following links: /cgi-bin/koha/admin/library_groups.pl: https://ibb.co/gJbndJ Search results when I search in All Libraries: https://ibb.co/h68psd Zero records found when I search in group: https://ibb.co/e42tJJ Regards, Ata On 30 May 2018 at 18:55, Jonathan Druart < jonathan.druart(a)bugs.koha-community.org> wrote: > Hello Ata, > > Did you get an error during the upgrade process? > How does look like the Library groups view, can you share a screenshot? > /cgi-bin/koha/admin/library_groups.pl > > Regards, > Jonathan > > On Wed, 30 May 2018 at 01:54 Ata ur Rehman <ata.rehman(a)gmail.com> wrote: > >> Dear All >> >> After upgrading to 18.05.00 from 17.11, searching catalog by limiting to a >> group of libraries (OPAC and Staff Client) is not working. I have come to >> know that Library Groups have been re-designed as hierarchy of libraries ( >> *Bug 15707* >> <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15707> ) and I >> tried to redefine all my groups/sub-groups but still no luck. >> >> Note: Searching in any single library or All Libraries is working fine >> both in OPAC and Staff Client >> >> Thanks in anticipation for any suggestion/advice, please >> >> Regards, >> >> Ata >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> >

2 1

Self-Registering Patrons allowed to choose -any- patron category?
by Alvin W. 30 May '18

30 May '18

I've activated Patron Self-Registration in the Koha library I support and that seems to be working okay; Except that on the self-registration screen, the new patron is allowed to choose whatever patron category he wishes, including those that should be staff or admin only. I would prefer self-registered patrons be limited to the default patron category and only be moved to an more appropriate category after staff review. Is there a setting that allows this? thanks!

3 3

help me auto increment issue to be fixed
by takan bhatt 30 May '18

30 May '18

Data problems Some of your tables have problems with their auto_increment values which may lead to data loss. *You should not ignore this warning.* The problem is that InnoDB does not keep auto_increment across SQL server restarts (it is only set in memory). So on server startup the auto_increment values are set to max(table.id)+1. To know how to avoid this problem see the related wiki page: DBMS auto increment fix <https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix> Problems found Patrons The following ids exist in both tables *borrowers* and *deletedborrowers*: 28 I am geting this warning.I have full koha backup. kindly help me. to resolve this problem. I already fixed auto-incrementation bug. Sincerely yours rajesh I am using maria db

2 1

Koha 18.05.00.000: Search in Group of Libraries not working after upgrade
by Ata ur Rehman 30 May '18

30 May '18

Dear All After upgrading to 18.05.00 from 17.11, searching catalog by limiting to a group of libraries (OPAC and Staff Client) is not working. I have come to know that Library Groups have been re-designed as hierarchy of libraries ( *Bug 15707* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15707> ) and I tried to redefine all my groups/sub-groups but still no luck. Note: Searching in any single library or All Libraries is working fine both in OPAC and Staff Client Thanks in anticipation for any suggestion/advice, please Regards, Ata

2 1

Re: [Koha] Listing all biblio records
by Indranil Das Gupta 29 May '18

29 May '18

Hi Ah Win, On Tue 29 May, 2018, 9:47 PM Ah Win, <ahwin2006(a)gmail.com> wrote: We are using one very simple software using MS Access for our school > libraries in Myanmar and now we would like to use Koha integrated system. > We would like to import our bibliographic data into Koha and now we are > testing. > Being an MS Access based system it will be easy to export it out as a spreadsheet. However that's where usually the fun begins :-) the first thing to identify is whether all your data is in Latin script (i.e. english) OR if your data also includes data in Burmese script. And if any data in Burmese script - is it Unicode (UTF-8) or does it involve any ASCII font replacement hacks for rendering it. Next is to clean up the data, perform de-duplication of the items (holdings data) and link them to unique bibliographic records. Now if your old aoftware had uawd any internal unique key for linking the tables, you can use this key as your de-duplication key OR if all your records have ISBN that is also a good dedup key to use. And while you do all that, you will be required to map your data into proper marc21 fields as most legacy software are unlikely to be marc compliant. This is a *crucial* step, where your librarian skills along with IT skills will get tested the maximum. Once you have de-duplicated the data, you have to add to the holdings information like item-level-type, branch codes and also biblio level itemtype to the biblio records. Your next stop will be the MarcEdit software where you will need to generate the unique biblio records marc file as well as the holdings marc file. And finally if everything goes ok you will have to merge them to get a new marc file. This is the file that you will import into Koha. Word of advice if your final marc file is over 1000 Bibliographic records, it will be helpful if you use MarcEdit to split it up into multiple files of 1000 records each. Koha will have an easy time ingesting a 1000 records file at a time, rather than one with say 25,000 records. That's basically the story of any legacy migration from a non-MARC21 dataset. Cheers Indranil. > Thank you again for your suggestion. > > Best regards, > Ah Win > > > > > > > > > > > > > > Ah Win > > Vice-President (1) > Myanmar Library Association > > > > On 29 May 2018 at 11:07, Father Vlasie <fv(a)spots.school> wrote: > >> Dear Ah Win, >> >> The SQL examples from this page: >> https://wiki.koha-community.org/wiki/SQL_Reports_Library >> >> Can be copied and pasted into the custom SQL reports in Home › Reports >> (your-koha-install/cgi-bin/koha/reports/reports-home.pl) >> >> 1) Copy the SQL from the sample >> >> 2) On the Reports page choose + Create from SQL >> >> 3) Enter a name for the report >> >> 4) Paste in the sample in the SQL box and click Save. >> >> 5) Click Saved Reports in the left hand column >> >> 6) Click Run on the report you would like. >> >> Let us know if it works. >> >> Father Vlasie >> >> St. Photios Orthodox Theological Seminary >> 510 Collier Way, Etna, CA 96027, U.S.A. >> <https://maps.google.com/?q=510+Collier+Way,+Etna,+CA+96027,+U.S.A.&entry=gm…> >> >> Website: www.spots.school >> >> >> On 28 May 2018, at 20:29, Ah Win <ahwin2006(a)gmail.com> wrote: >> >> Dear Indranil, >> >> I am new to the list and librarian from Myanmar. >> >> Please help me the way if we are not handy with SQL. >> For both import and export, please. >> >> Many thanks. >> Ah Win >> >> >> >> >> >> >> On 27 May 2018 at 03:37, Indranil Das Gupta <indradg(a)gmail.com> wrote: >> >>> On Sun 27 May, 2018, 2:33 AM Father Vlasie, <fv(a)spots.school> wrote: >>> >>> > Hello everyone, >>> > >>> > Is there an easy way to export a list of all items in a Koha database? >>> > >>> >>> If you are handy with SQL, take a look at >>> https://wiki.koha-community.org/wiki/SQL_Reports_Library >>> >>> Particularly at the section Bibliographic / Catalogue reports. >>> >>> >>> >>> > TIA >>> > FV >>> > _______________________________________________ >>> > Koha mailing list http://koha-community.org >>> > Koha(a)lists.katipo.co.nz >>> > https://lists.katipo.co.nz/mailman/listinfo/koha >>> > >>> _______________________________________________ >>> Koha mailing list http://koha-community.org >>> Koha(a)lists.katipo.co.nz >>> https://lists.katipo.co.nz/mailman/listinfo/koha >>> >> >> >> >

1 0

Fwd: OPAC Page not available and login credentials don't work
by Bedanta Borah 29 May '18

29 May '18

From: Bedanta Borah <bedanta.mail.01(a)gmail.com> Date: Mon, May 28, 2018 at 10:42 AM Subject: OPAC Page not available and login credentials don't work To: koha-request(a)lists.katipo.co.nz Hello there. My name is Bedanta. I am currently using Virtualbox to install Koha on Ubuntu 18.04 and Koha liveDVD. I have faced problems in both installations. 1) In case of Ubuntu, I have installed Koha using instructions given in this page ( https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages ). The Staff Login page works fine and I can use all the library functions. But the OPAC Page doesn't appear. All that appears is the Apache home page. # Staff Client : 127.0.1.1:8080 or 127.0.0.1:8080 # Instead of OPAC Page, the apache home page appears in the these addresses : 127.0.1.1 or 127.0.0.1 Q) How can I manage to appear the OPAC Page? 2) In case of koha livedvd, all features were doing fine untill I updated the system and the koha-common packages. After the update, my root user and password (koha_library & koha123) stopped working. But I can login with another patron which I had created before the update was done. Why I loose database user access after updating the software? Q) How can I regain the database user access? Please help me with the above two queries. Thank you. Yours faithfully Bedanta Nagaon, Assam, India

4 3

Staff Login Statistics
by Mr Mutsikiwa Admire 29 May '18

29 May '18

We are interested in establishing login statistics by our library staff. If possible even listing the actions that were done by a given staff as that which appears in the patron modification log -- Kind Regards, Admire Mutsikiwa (Mr) ICT Manager Libraries University of Zimbabwe Tel:+263-4-303276 Mob:+263782476883 “It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities.” Josiah Charles Stamp

1 0

percent of reindexing
by Arayik Manukyan 29 May '18

29 May '18

Hi List, We have 2000000 records in Koha 17.11.04. When we reindexing zebra we only can see the number of exported records, but we want to see the percent of reindexing too. How can we do it ? Thanks,

1 0

Listing all biblio records
by Father Vlasie 29 May '18

29 May '18

Hello everyone, Is there an easy way to export a list of all items in a Koha database? TIA FV

3 3