- Koha - lists.katipo.co.nz

INVENTORY SQL
by muiru james 10 Jul '23

10 Jul '23

Hello team, Im trying to create a sql query that will return a count of books that will have a datelastseen from a date picker and combine/add all books on loan for the particular itemtype. I have 2 different itemtypes and would like a count for each itemtype to include those with a datelastseen and all those onloan for the itemtype. Any ideas/help will really be appreciated. Warm regards James

3 3

patron update
by Сычев Игорь Алексеевич 09 Jul '23

09 Jul '23

Hello! I have a csv file with "patron_attributes". Example: cardnumber,patron_attributes 23821012345678,"TPUID:12345,""PDivision:Academic Library, Dep IT""" Imported without problems. If the string uses "Double quotes" (")? then there is a problem with the import. Example, need : Other "ABC" SPb cardnumber,patron_attributes 23821012345678,"PDivision:Other ""ABC"" SPb" root@koha:/usr/share/koha/bin# perl import_patrons.pl -f /home/ias/patron.csv --matchpoint cardnumber --confirm -v Use of uninitialized value $borrower{"cardnumber"} in string eq at /usr/share/koha/lib/Koha/Patrons/Import.pm line 146, <$handle> line 2. Use of uninitialized value $borrower{"auth_method"} in string eq at /usr/share/koha/lib/Koha/Patrons/Import.pm line 147, <$handle> line 2. Import complete: Imported: 0 Overwritten: 0 Skipped: 0 Invalid: 1 Total: 1 How do I escape to csv so that the import takes place? Good Luck! Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru/

1 0

Koha Upgrade to 23.05.00.002 Error
by Sami M. Rasheed 09 Jul '23

09 Jul '23

Dear All, Hi, While I am upgrading Koha to 23.05.00.002, I have an error: ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate key name 'illrequests_bibfk' at /usr/share/koha/lib/C4/Installer.pm line 741 I use Ubuntu 20.04koha 23.05 Thanks.

1 0

import patrons
by Сычев Игорь Алексеевич 08 Jul '23

08 Jul '23

Hello! Koha 23.05 Importing patrons on the command line. What does the following warning mean? root@koha:/usr/share/koha/bin# perl import_patrons.pl -f /home/ias/patron.csv --matchpoint cardnumber -c -v Use of uninitialized value $borrower{"cardnumber"} in string eq at /usr/share/koha/lib/Koha/Patrons/Import.pm line 146, <$handle> line 500. Use of uninitialized value $borrower{"auth_method"} in string eq at /usr/share/koha/lib/Koha/Patrons/Import.pm line 147, <$handle> line 500. Option "-c" --confirm or --matchpoint? root@koha:/usr/share/koha/bin# perl import_patrons.pl --help Usage: import_patrons.pl --file /path/to/patrons.csv --matchpoint cardnumber --confirm [--default branchcode=MPL] [--overwrite] [--preserve-field <column>] [--preserve-extended-attributes] [--update-expiration] [--expiration-from-today] [--verbose] Options: -h|--help Prints a brief help message and exits -c|--confirm Confirms you really want to import these patrons, otherwise prints this help -f|--file Path to the CSV file of patrons to import -c|--matchpoint Field on which to match incoming patrons to existing patrons -d|--default Set defaults to patron fields, repeatable e.g. --default branchcode=MPL --default categorycode=PT -k|--preserve-field Prevent specified patron fields for existing patrons from being overwritten -o|--overwrite Overwrite existing patrons with new data if a match is found -p|--preserve-extended-attributes Retain extended patron attributes for existing patrons being overwritten -en|--email-new Send the WELCOME notice email to new users -ue|--update-expiration If a matching patron is found, extend the expiration date of their account using the patron's enrollment date as the base -et|--expiration-from-today If a matching patron is found, extend the expiration date of their account using the patron's enrollment date as the base -v|--verbose Be verbose Multiple -v options increase the verbosity 2 repetitions or above will report lines in error 3 repetitions or above will report feedback Good Luck! Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru

3 2

record won't delete
by Lauren Denny 08 Jul '23

08 Jul '23

Hi everyone, I have a record that will not delete. When I try to delete the record or merge it with another record I get this message: An error has occurred!*Error 500*This message may have been caused by any of the following reasons: - You made use of an external link to an item that is no longer available - You followed an outdated link e.g. from a search engine or a bookmark - You tried to access a page that needs authentication - An internal link in the client is broken and the page does not exist What's next? - Use top menu bar to navigate to another part of Koha. - To report a broken link or any other issue, please contact the Koha administrator. Send email <library%40teamwork-global.net> Does anyone have an idea of what is happening? Lauren

4 9

zebraidx warn
by Сычев Игорь Алексеевич 08 Jul '23

08 Jul '23

Hello! Please tell me how to solve the problem? koha-rebuild-zebra -f -v library 12:45:28-05/07 zebraidx(243390) [warn] duplicate entry for charmap from 'ź' 12:45:28-05/07 zebraidx(243390) [warn] duplicate entry for charmap from 'Ź' 12:45:28-05/07 zebraidx(243390) [warn] duplicate entry for charmap from 'ż' 12:45:28-05/07 zebraidx(243390) [warn] duplicate entry for charmap from 'Ż' 12:45:28-05/07 zebraidx(243390) [warn] duplicate entry for charmap from 'ć' 12:45:28-05/07 zebraidx(243390) [warn] duplicate entry for charmap from 'Ć' 12:45:28-05/07 zebraidx(243390) [warn] Map: 'α' has no mapping 12:45:28-05/07 zebraidx(243390) [warn] Map: 'α' has no mapping 12:45:28-05/07 zebraidx(243390) [warn] Map: 'ε' has no mapping 12:45:28-05/07 zebraidx(243390) [warn] Map: 'ε' has no mapping Koha 23.05 Good Luck! Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru

2 1

Next Koha Documentation meeting 12 July
by Charillon, Aude 07 Jul '23

07 Jul '23

Hello, The next Documentation team meeting will take place on Wednesday 12 July at 14:00 UTC (check the date and time in your time zone <https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Documentatio…> ). All details on how to join and what we're planning to discuss are on the meeting agenda https://wiki.koha-community.org/wiki/Documentation_meeting_12_July_2023 If you are curious about how the Koha manual gets made (and what we're doing to improve it), please join us! Cheers, Aude Aude Charillon Customer Services Consultant PTFS Europe Revalidated May 2022 [image: Phone icon] M: +44 7557 526188 | T: +44 1483 378728 ext. 1013 [image: Email icon] aude.charillon(a)ptfs-europe.com [image: Link icon] www.ptfs-europe.com [image: Click to open Twitter] <https://twitter.com/PTFSEurope> [image: Click to open YouTube] <https://www.youtube.com/@PTFSEurope> [image: Click to open PTFS Europe webpage] <https://www.ptfs-europe.com>

1 0

delete logs
by Сычев Игорь Алексеевич 07 Jul '23

07 Jul '23

Hello! How do I delete the "modification log" of all borrowers? Good Luck! Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru

1 1

The Terrific Every-Other-Thursday Training Video | S3E22 | Current Session Checkout Slips
by BRANNON, CHRISTOPHER 06 Jul '23

06 Jul '23

Quick! Check this out! Don't let this episode slip by! Print the most recent checkouts on your quick slips with these handy slip tips. Christopher and George show a couple ways to tackle this challenge using Template Toolkit. https://youtu.be/GbSb4sze2DU Christopher Brannon 2023 koha-US President

1 0

Koha-US System Administration Special Interest Group, 7/11/23
by Andrew Fuerste-Henry 06 Jul '23

06 Jul '23

Good morning! The Koha-US System Administraiton Special Interest Group will meet Tuesday, July 11, 8 PT / 9 MT / 10 CT / 11 ET. We discuss system preferences and all the other fun nonsense that lives in the Administration module, along with SQL questions, bugs of note, and whatever other mad schemes folks want to talk up. Come join us! The meeting will be held on Zoom at https://us02web.zoom.us/j/955473977?pwd=S3RGaW90SmxVVkRSaHk3ZERMOExBZz09. For full details, visit https://koha-us.org/event/system-administration-special-interest-group/?ins… Andrew Fuerste-Henry Assistant Library Director Dubuque County Library District www.dubcolib.org | 563-582-0008 he|they<https://www.mypronouns.org/>

1 0