- Koha - lists.katipo.co.nz

Data migration: importing of anonymous checkout history
by Сычев Игорь Алексеевич 11 Jul '23

11 Jul '23

Hello! I have a checkout history over the past years. But some of the patrons have already been deleted. What do I need to do to import anonymizing the checkout history? In other words, if there is a user, then the story is personalized, if there is no user, then the story is impersonal. Good Luck! Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru

2 3

[koha-US Circulation SIG] JUNE 10th Koha-US Circulation Special Interest Group ("CircSIG")
by Lauren Denny 10 Jul '23

10 Jul '23

Hi everyone, Join us for the next Koha-US Circulation meeting this Thursday, July 10th, at 8 PT / 9 MT / 10 CT / 11 ET / 15 UTC. Bring topics on anything to do with patrons, circulation, notices, OPAC, etcetera, and we can all share our thoughts and ideas. You don't have to be a member of Koha-US to join us, we're hoping you'll come! Here is the link to the Zoom meeting and https://us02web.zoom.us/j/962703559?pwd=SjJWcW9CRDJvMy8ycVIyTzIzOUdSUT09 Can't make it? No worries--it will be recorded and available on the Koha-US YouTube Channel: https://www.youtube.com/c/kohaUS/playlists (See the Circulation Special Interest Group's playlist for past circulation topics!) Feel free to send me any questions or topics for discussion ahead of time! Looking forward to seeing you! Lauren Denny

1 1

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