- Koha - lists.katipo.co.nz

Labels only showing all 0's
by Ari 13 Jun '18

13 Jun '18

Hi guys, I am trying to print off some labels for some books. I have set the correct label template. However, I am having trouble with the layout. No matter what I choose, the barcode is always "0000000" and none of the biblio information is visible. I have tried entering the MARC fields rather than the fields provided but they only churn corrupted pdf files. Has anyone had this issue before? Cheers -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

2 2

Linker bib-to-authority records looks to the first word only
by Ev Praksi 13 Jun '18

13 Jun '18

Hello Koha community! I am a new user of Koha and I would like to ask you for help in that issue: Why the Linker, which links authority to bib-records considers only the first word in the name fields, when it check for match? Which settings I have selected wrongly? DETAILS: In my Koha 17.11 installation I have following settings in Home › Administration › Global System preferences: Genral: AutoCreateAuthorities = do not generate BiblioAddsAuthorities = allow Linker: CatalogModuleRelink = Do not LinkerKeepStale = Do not LinkerModule = Default LinkerOptions = LinkerRelink = Do The selected Search Engine is ZEBRA. EXAMPLE: For the experiment I have created 2 dummy bib-records: “My title 1” by Hoare, Charles Antony Richard and “My title 2” by Brown, Michael. Both authors names came from the Authority file. There are 4 authors in total in the Authority file: Petson, Uwe Hoare, Charles Antony Richard Brown, Sandra Brown, Michael Note, the family names of two authors match – these are Sandra Brown and Michael Brown. After running link_bibs_to_authorities.pl and rebuilding zebra indexes the authority-linker finds correctly the author of the first book “My title 1” – Charles Antony Hoare, but the authority-linker gets confused who of the Browns to link to the second book “My title 2” – Sandra or Michael! The reason is that the authority-linker looks only to the first word in the name-field, which in this case is "Brown", and therefore it “finds” 2 matching to the bib-record names! Thus, it does not link “My title 2” to any of them! How can I set the authority-linker to look to all words in name-field (100$a)? As well, of course: How can I set the authority-linker to look to all other fields related to the author (100$c, 100$d, etc.) when it tries to find a match? I could find similar question from Erlanda Simonyan (Thu Jun 29 20:24:35 NZST 2017), but I couldn't find it's answer... Thank you very much for your help! Ev

1 0

EDS Plugin not loading
by Mohamed Negm 13 Jun '18

13 Jun '18

Hi I’m trying to configure EBSCO EDS plugin into Koha 17.11, I filled out all require information in the plugin but when press loading data from EBSCO admin, nothing change, any suggestions Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

3 4

Plugin Error
by SATISH 13 Jun '18

13 Jun '18

Hi, With Koha 17.11.06.000 On L-Ubuntu 16,04 Desktop from package installation method, I am getting follwoing error while uploading .kpz file at Home › Tools › Plugins. *Cannot unpack file to the plugins directory.Please verify that the Apache user can write to the plugins directory.* What is the right permission ?? . As a root user, I have created plugins directory drwxr-xr-x 6 gechlibrary-koha gechlibrary-koha 4096 Jun 8 22:48 gechlibrary drwxr-xr-x 2 root root 4096 Jun 12 17:28 plugins I tried to change, chown -R gechlibrary-koha:gechlibrary-koha /var/lib/koha/plugins/ drwxr-xr-x 6 gechlibrary-koha gechlibrary-koha 4096 Jun 8 22:48 gechlibrary drwxr-xr-x 2 gechlibrary-koha gechlibrary-koha 4096 Jun 12 17:28 plugins Alias /plugin/ "/var/lib/koha/plugins/" is updated in /etc/apache2/sites-available/gechlibrary.conf In both cases, I am not able to to perform upload plugin. Please help. Satish MV Librarian Govt. Engineering College, Hassan

4 3

bugs.koha-community.org outage warning
by Chris Cormack 12 Jun '18

12 Jun '18

Hi All The linode bugzilla (and a few outher services like the dashboard) is on is going down for a bit now to be upgraded to the next size up. This will cause a brief outage It should be back shortly Chris

1 0

Koha used for asset inventory
by Tim Atwood 12 Jun '18

12 Jun '18

Has anyone used Koha for asset inventory purposes? -- Tim Atwood Computer Systems Technician/ Grant Public Schools tatwood(a)grantps.net 231.834.5910 x5398

1 0

SQL report with Comma Delimited Paramater
by ksorbo 12 Jun '18

12 Jun '18

Is it possible to create a SQL report using a parameter with comma delimited ids? Specifically I would like to be able to select random, non-contiguous items. The following sql statement works when called directly from mysql: *select * from items where barcode in (3456,2346);* However, when I create a sql report with the following code: *select * from items where barcode in (<<Enter Barcodes>>)* it works if I enter 1 barcode, but fails if I enter 2 barcodes separated by a comma. Is there any workaround for this? -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

3 3

Zebra - less logging
by Tom Hanstra 12 Jun '18

12 Jun '18

Does anyone with Zebra knowledge know how to scale back the amount of logging which takes place. I'm still running Zebra for indexing with V17.11 and finding the logs are very large each day. I'd like to scale back logging so I only get errors logged. How might that be done? Thanks, Tom -- *Tom Hanstra* *Sr. Systems Administrator* hanstra(a)nd.edu <http://library.nd.edu/>

2 1

Migration problem
by Przemek Kosiński 12 Jun '18

12 Jun '18

Hi everyone, I tried to do a base migration from 3.20 to 17.11.06. The conversion of the database to the new schema and indexation has gone ok - everything works except the possibility of a full preview of the patron - after choosing one they receive such an error: Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_biblio-main.club_enrollments' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 269 I did two attempts and this problem appeared every time. System: Ubuntu 16.04LTS DataBase: MariaDB 10.0.34 Plack not enabled - when enable plack I get an error: Internal Server Error In the version of koha 17.11.05 there was no such error - the earlier attempt to migrate to this version was successful. I have a question about what I can do about it. Alternatively, how to withdrawal to an earlier version 17.11.05 to check whether this error can be invoked. Best regards Przemek Kosiński -- ************************************************* Powiatowa i Miejska Biblioteka Publiczna w Skarżysku-Kamiennej www: www.biblioteka24.eu mail: p.kosinski(a)biblioteka24.eu *************************************************

2 2

SQL help please
by Kerrie Stevens 12 Jun '18

12 Jun '18

I have the following report which almost does what I need but I can't quite get it there. I want to be able get a list of titles and the Dewey from 082$a but I also want to be able to select for which collection I want the results - that is where I'm getting stuck. I can select the collection when I run the report, but I get the following error so there is something else missing... Error: The following error was encountered: The database returned the following error: Unknown column 'items.ccode' in 'where clause' Here is my report so far: SELECT biblio.biblionumber, biblio.title, biblio.author, concat (ExtractValue( metadata, '//datafield[@tag="082"]/subfield[@code="a"]' ), " ", ExtractValue( metadata, '//datafield[@tag="082"]/subfield[@code="b"]' )) as Dewey FROM biblio_metadata JOIN biblio ON ( biblio_metadata.biblionumber = biblio.biblionumber ) WHERE items.ccode=<<Collection|CCODE>> ORDER BY biblio.title ASC It works if I remove the WHERE line, but then I can't select which collection. Thanks for any help you may provide! Kerrie Stevens AALIA(CP), MAppSci(LibMgt), BBus(Info&LibMgt) Melbourne Campus - Librarian kerrie.stevens(a)ac.edu.au | ac.edu.au<http://ac.edu.au/> P +61 3 8799 1155 | F +61 3 8799 1199 1 Keith Campbell Court, Scoresby VIC 3179 Australia This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this email in error, please notify the sender and delete this email immediately. Any confidentiality, privilege or copyright is not waived or lost because this email has been sent to you in error. It is your responsibility to check this email and any attachments for viruses. <p> Scanned by the Alphacrucis Netbox from <a href="http://cyberhound.com/">CyberHound</a>

2 1