- Koha - lists.katipo.co.nz

SQL help?
by Kerrie Stevens 28 May '20

28 May '20

Every year, we need to confirm graduating students have no outstanding loans so they can graduate. And every year I think I must ask for some help in doing it more efficiently than searching borrower numbers one by one... I'd like to be able to copy & paste a number of borrower numbers into search box and get back a table showing those with outstanding loans: (borrower number, name, and number of current loans) Can cutting & pasting or searching on multiple borrower numbers be done in SQL reports? This is way beyond my basic level of SQL understanding, so any advice/assistance would be greatly appreciated. Thank you and have a great day wherever you may be! Kerrie Stevens AALIA(CP), MAppSci(LibMgt), BBus(Info&LibMgt) Director of Library Services, Alphacrucis College Librarian - Melbourne Campus HDR Liaison Librarian

5 4

SQL Help
by Himanshu Aggarwal 27 May '20

27 May '20

Can someone suggest report for getting accession number with a range from and to -- Assistant Librarian,

1 0

Report help needed
by Elaine Bradtke 27 May '20

27 May '20

What I'd like it to do - give a list of biblio numbers for records with a particular itemtype, and the information found in the Leader *06 - Type of record *field. I found the following in the reports library as something that could be modified to fit my needs. But it doesn't work I get the following message: Unknown column 'marcxml' in 'field list' Please check the log for further details. Also, I don't understand how to indicate Leader position 06 SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber= ',biblionumber,'\">',biblionumber,'</a>') AS biblionumber FROM biblioitems, (SELECT biblioitemnumber, SUBSTR(marcxml,INSTR(marcxml, "<leader>")+8+6,1) AS leader6 FROM biblioitems) AS leaders WHERE biblioitems.biblioitemnumber=leaders.biblioitemnumber AND leaders.leader6 = 'a' AND itemtype = <<Item Type|itemtypes>> Any help would be appreciated stay safe, Elaine Bradtke 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

3 2

Re: [Koha] Call for news: May 2020 Koha Newsletter
by JESSE KAH 24 May '20

24 May '20

Dear Chad and all members of KOHA Community, New KOHA Library in Malaysia implemented by Lemonjar Software Media Sdn. Bhd - First City University College, Malaysia. System successfully went live on 10 March 2020, and the OPAC was only officially being informed to all patrons after the MCO movement in condition after 10 May. Due to the Covid-19 outbreak, Malaysia Movement Control Order (MCO) started 18 March until 10 May, and extended to 9 June with movement condition allowance. First City University Collge's OPAC is accessible via: https://libkoha.firstcity.edu.my/ Thanks! Stay Safe & Stay Positive during the outbreak of Covid-19 ~ Best Regards, Jesse Kah Ingland Lemonjar Software Media Sdn. Bhd. -- Business Owner -- Mobile: +6 (016) 8606 826 Tel: +6 (088) 713226 Fax: +6 (088) 719226 Website: https://www.edgetech.com.my https://www.lemonjar.com.my Email: jessekah(a)edgetech.com.my On 14/05/2020, 10:30 PM, "Koha on behalf of Koha Newsletter" <koha-bounces(a)lists.katipo.co.nz on behalf of kohanews(a)gmail.com> wrote: I'm collecting news for the April newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: - Please include dates for past events. If I can't find dates I may not add it. - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon - For past events , **** one month back is the cut-off ****. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. Thank you! -- Chad Roseburg Editor, Koha Community Newsletter _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Integration of "Dialogflow" with "Koha"
by Victor Barroso Oliveira 23 May '20

23 May '20

Good Morning, You already did some integration of "Dialogflow" with "Koha". If so, please share with me. Thank you, Victor

1 0

Koha 19.05.11 Release
by Lucas Gass 22 May '20

22 May '20

The Koha Community is happy to announce the release of Koha 19.05.11. This is a maintenance release. The full release notes can be found at: https://koha-community.org/koha-19-05-11-release/ Debian packages will be available shortly. Thanks to everyone involved, -- Lucas Gass Web Developer

1 0

20.05.00 Alpha release
by Renvoize, Martin 22 May '20

22 May '20

Hi all, As we've got a number of improvements in the translations and packaging processes in this release I have built an alpha to test prior to a full release in the coming days. If you have time to work through any test upgrades/installs using the nightly Debian repository it would be greatly appreciated to get your feedback. The repository is available at http://apt.kohaaloha.com/koha-nightly/. Things to look out for: * Debian 10 Support! * Installer process and translations of default data * Circulation rules being added correctly during onboarding * Logging and log file permissions Any feedback given over the next few days will be taken into consideration before I build the release notes and officially release to the wider world. Many thanks, *Martin Renvoize* <https://www.ptfs-europe.com> Development Team Manager Community Release Manager (19.11, 20.05) *Phone:* +44 (0) 1483 378728 *Mobile:* +44 (0) 7725 985 636 *Email:* martin.renvoize(a)ptfs-europe.com *Fax:* +44 (0) 800 756 6384 www.ptfs-europe.com Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30 The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info(a)ptfs-europe.com

2 2

Bulk import complains about invalid library location
by Peter Korsten 20 May '20

20 May '20

Hi, First message on this list. My company is installing a Koha installation for a customer, and I've been graced with the task. Everything is working, pretty well, but when I attempt to import MARC records, Koha won't add items, only bibliographic records. From the command line: # bin/migration_tools/bulkmarcimport.pl -b -file ~ILS-VM-User01/cbom.mrc -d deleting biblios .Item not added (bib 1, item tag #1, barcode 000020147167): invalid homebranch Library .Item not added (bib 2, item tag #1, barcode 000020229757): invalid homebranch Library .Item not added (bib 3, item tag #1, barcode 000020189594): invalid homebranch Library .Item not added (bib 4, item tag #1, barcode 000020190644): invalid homebranch Library .Item not added (bib 5, item tag #1, barcode 000020197209): invalid homebranch Library .Item not added (bib 6, item tag #1, barcode 000020179052): invalid homebranch Library Item not added (bib 6, item tag #2, barcode 000020189587): invalid homebranch Library .Item not added (bib 7, item tag #1, barcode 000020176716): invalid homebranch Library .Item not added (bib 8, item tag #1, barcode 000020180645): invalid homebranch Library .Item not added (bib 9, item tag #1, barcode 000010080085): invalid homebranch Library .Item not added (bib 10, item tag #1, barcode 000020064341): invalid homebranch Library Item not added (bib 10, item tag #2, barcode 000020100155): invalid homebranch Library .Item not added (bib 11, item tag #1, barcode 000010091302): invalid homebranch Library .Item not added (bib 12, item tag #1, barcode 12482): invalid homebranch System Location .Item not added (bib 13, item tag #1, barcode 000020140502): invalid homebranch Library .Item not added (bib 14, item tag #1, barcode 000020119546): invalid homebranch Library .Item not added (bib 15, item tag #1, barcode 000020004026): invalid homebranch Library .Item not added (bib 16, item tag #1, barcode 000010007266): invalid homebranch Library .Item not added (bib 17, item tag #1, barcode 000020203818): invalid homebranch Library .Item not added (bib 18, item tag #1, barcode 000020193751): invalid homebranch Library .Item not added (bib 19, item tag #1, barcode 000020193706): invalid homebranch Library .Item not added (bib 20, item tag #1, barcode 000020205164): invalid homebranch Library .Item not added (bib 21, item tag #1, barcode 000020232375): invalid homebranch Library .Item not added (bib 22, item tag #1, barcode 000020086909): invalid homebranch Library .Item not added (bib 23, item tag #1, barcode 000010013137): invalid homebranch Library .Item not added (bib 24, item tag #1, barcode 000020203825): invalid homebranch Library .Item not added (bib 25, item tag #1, barcode 000010010976): invalid homebranch Library .Item not added (bib 26, item tag #1, barcode 000010011928): invalid homebranch Library .Item not added (bib 27, item tag #1, barcode 000020077044): invalid homebranch Library .Item not added (bib 28, item tag #1, barcode 000010010730): invalid homebranch Library .Item not added (bib 29, item tag #1, barcode 000020187729): invalid homebranch Library .Item not added (bib 30, item tag #1, barcode 000020167141): invalid homebranch Library .Item not added (bib 31, item tag #1, barcode 000010011645): invalid homebranch Library .Item not added (bib 32, item tag #1, barcode 000020001339): invalid homebranch Library .Item not added (bib 33, item tag #1, barcode 000020010348): invalid homebranch Archives .Item not added (bib 34, item tag #1, barcode 000020010386): invalid homebranch Archives .Item not added (bib 35, item tag #1, barcode 000020017439): invalid homebranch Archives .Item not added (bib 36, item tag #1, barcode 000020010423): invalid homebranch Archives .Item not added (bib 37, item tag #1, barcode 000020010416): invalid homebranch Archives .Item not added (bib 38, item tag #1, barcode 000020010409): invalid homebranch Archives .Item not added (bib 39, item tag #1, barcode 000020010454): invalid homebranch Archives .Item not added (bib 40, item tag #1, barcode 000020010447): invalid homebranch Archives ... However, these branches exist. In MySQL: mysql> select branchcode, branchname, marcorgcode from branches; +------------+-----------------+-----------------+ | branchcode | branchname | marcorgcode | +------------+-----------------+-----------------+ | ARC | Archives | Archives | | LIB | Library | Library | | MAIN | System Location | System Location | +------------+-----------------+-----------------+ 3 rows in set (0.00 sec) mysql> So now I'm confused. Google is usually my friend, but not in this case. I haven't yet added part of the MARC/MARCXML file (there are over 1200 items in there), but I can if necessary. Thanks, - Peter

2 2

Domain for Koha Server (URL SET UP)
by Evil-A 19 May '20

19 May '20

Hello, I will probably ask something really easy to fix, but I am totally new to this, so... I installed and configure Koha Version 19.11, also I made a little customization on my OPAC. I am able to see my Koha through both Intranet and Internet (only with an IP) In the intranet I use 11.11.11.11:80 (OPAC) and 11.11.11.11:8080 (Admin) On internet I use 111.111.111.11:80 (OPAC) and 111.111.111.11:8080 (Admin) No issues until here. I also have a domain active... mydomain.abc.de But I've been trying different ways to set up the URL so everybody can see my sites but unsuccessful. My /etc/hosts looks like: 127.0.0.1 localhost 127.0.1.1 library 111.111.111.11 library.mydomain.abc.de 111.111.111.11 library-admin.mydomain.abc.de Then my /etc/koha/koha-sites/.conf is: DOMAIN=".mydomain.abc.de" ---- here I also tried with the real IP (111.111.111.11) INTRAPORT="8080" INTRAPREFIX="lybrary" INTRASUFFIX="-admin" OPACPORT="80" OPACPREFIX="library" INTRASUFFIX="" Not working at this point... So I was reading some posts here end they suggest to edit the /etc/koha/koha-sites.conf I added a ServerAlias like this: # OPAC <VirtualHost *:80> ServerName librarylocalhost ServerAlias library.mydomain.abc.de # Intranet <VirtualHost *:8080> ServerName library-adminlocalhost ServerAlias library-admin.mydomain.abc.de then I tried # OPAC <VirtualHost *:80> ServerName library # Intranet <VirtualHost *:8080> ServerName library-admin And # OPAC <VirtualHost *:80> ServerName library ServerAlias library.mydomain.abc.de # Intranet <VirtualHost *:8080> ServerName library-admin ServerAlias library-admin.mydomain.abc.de But still not working I read another post that suggest to make some modifications on koha-httpd.conf but couldn´t find that file, other post suggest to edit file /etc/apache2/sites-enabled/koha.conf but that file don't even exist on my server. I´ve been trying with all of these configurations but until now I am no able to reach my sites with an url. Does anybody have an idea on what I am doing wrong... Thanks -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

2 1

[koha] Barcode as a link report
by muirunyeri 18 May '20

18 May '20

Hello team I hope you all keeping safe I'm looking to create a report with barcode as a link that when will clicked will open the edit items page. Kindly assist. Warm Regards James Sent from my Samsung Galaxy smartphone.

2 1