Time Nick Message 07:17 koha-jenkins Project Koha_20.11_D10 build #22: SUCCESS in 57 min: https://jenkins.koha-community.org/job/Koha_20.11_D10/22/ 07:27 alex_a Bonjour 07:27 wahanui bidet, alex_a 07:28 reiveune hello 08:37 shaffendi hi everyone. just want to ask can koha force all the patron to receive check in/out receipt to their email? 08:38 shaffendi i know if overdue notices will be sent based on the library’s rules, not the patron’s choice 08:39 shaffendi is there anything i can do to make changes to this? 08:39 shaffendi including modifying the dbase 09:04 ashimema mornin' #koha 09:34 koha-jenkins Project Koha_20.11_U20 build #7: SUCCESS in 45 min: https://jenkins.koha-community.org/job/Koha_20.11_U20/7/ 09:37 koha-jenkins Project Koha_20.11_D10 build #23: SUCCESS in 49 min: https://jenkins.koha-community.org/job/Koha_20.11_D10/23/ 09:44 koha-jenkins Project Koha_20.11_U18 build #7: SUCCESS in 56 min: https://jenkins.koha-community.org/job/Koha_20.11_U18/7/ 09:49 magnuse shaffendi: enable EnhancedMessagingPreferences, set all patron categories to receive check in/out email, run the script misc/maintenance/borrowers-force-messaging-defaults.pl to update borrowers based on the category settings, disable EnhancedMessagingPreferencesOPAC (so patrons can't change the settings) 09:53 koha-jenkins Project Koha_20.11_U2010 build #9: SUCCESS in 58 min: https://jenkins.koha-community.org/job/Koha_20.11_U2010/9/ 10:04 koha-jenkins Project Koha_20.11_U16 build #7: SUCCESS in 1 hr 18 min: https://jenkins.koha-community.org/job/Koha_20.11_U16/7/ 10:21 koha-jenkins Project Koha_20.11_D9 build #13: UNSTABLE in 47 min: https://jenkins.koha-community.org/job/Koha_20.11_D9/13/ 10:27 koha-jenkins Project Koha_20.11_U16 build #8: SUCCESS in 50 min: https://jenkins.koha-community.org/job/Koha_20.11_U16/8/ 10:35 koha-jenkins Project Koha_20.11_D11 build #16: SUCCESS in 50 min: https://jenkins.koha-community.org/job/Koha_20.11_D11/16/ 10:35 koha-jenkins Project Koha_20.11_D11 build #17: FAILURE in 41 min: https://jenkins.koha-community.org/job/Koha_20.11_D11/17/ 11:59 oleonard HI #koha 12:49 shaffendi magnuse 12:50 shaffendi im using koha 20.05 12:50 shaffendi i cant find misc/maintenance/borrowers-force-messaging-defaults.pl 12:50 shaffendi where that file located? 12:52 shaffendi ok found it 12:52 shaffendi root@debian:/usr/share/koha/bin/maintenance# ./borrowers-force-messaging-defaults.pl Since: 0000-00-00 1: ADMIN 2: ADMIN 12:52 shaffendi thats it? 13:01 cait1 @seen ere 13:01 huginn cait1: ere was last seen in #koha 29 weeks, 3 days, 2 hours, 54 minutes, and 58 seconds ago: <ere> ashimema: Done! Good stuff, thanks, that's so much better :) 13:03 shaffendi why does that script only update only my 2 patron categories :( 13:07 magnuse shaffendi: https://perldoc.koha-community.org/20.05.x/misc/maintenance/borrowers-force-messaging-defaults.html you must use the --doit switch 13:08 shaffendi i got around 15 patron categories 13:08 shaffendi when i run 13:08 shaffendi borrowers-force-messaging-defaults.pl Since: 0000-00-00 1: ADMIN 2: ADMIN 13:08 shaffendi it only update 2 13:12 shaffendi and i did check other patron message preference. not updated 13:15 shaffendi ults.pl --doit Since: 0000-00-00 1: ADMIN 2: ADMIN Total borrowers updated: 2 13:21 magnuse shaffendi: that looks a bit strange... did you "enable EnhancedMessagingPreferences, set all patron categories to receive check in/out email"? 13:22 shaffendi yes i did 13:23 shaffendi "enable EnhancedMessagingPreferences <-- this means set the value to 'Allow" 13:23 shaffendi am i ight? 13:23 magnuse yes 13:23 shaffendi right 13:23 shaffendi ya i did 13:24 shaffendi the admin category did change to the value i wanted 13:24 shaffendi but other categories not follow 13:26 magnuse hm, i'm out of ideas, then 13:30 shaffendi :`( 13:35 shaffendi i tried using borrowers-force-messaging-defaults.pl --doit --category <-- also didnt update the category i entered 13:35 shaffendi what could be wrong :-| 13:58 tuxayo hi #koha :) 14:07 liliputech_asu hi tuxayo :) 14:07 tuxayo o/ 15:40 shaffendi anyone online? 15:41 caroline shaffendi: usually at this time there are a couple people online 15:42 shaffendi hi caroline 15:42 shaffendi i got question 15:42 caroline go ahead 15:42 shaffendi i used borrowers-force-messaging-defaults.pl 15:43 shaffendi it only update 1 of my patron categories 15:43 shaffendi im using koha 20.05.06 on debian 9 15:44 shaffendi i already set allow at EnhancedMessagingPreferences 15:44 caroline All your patron categories have message defaults? 15:44 shaffendi i got around 10 patron categories but it only modified 1 15:44 shaffendi All your patron categories have message defaults? <-- do u mean all must be same? 15:45 caroline no, but all of them have defaults? 15:45 caroline they can be different 15:45 shaffendi ya i already set all of them before i exucute that pearl file 15:46 caroline ok 15:46 shaffendi i tried using borrowers-force-messaging-defaults.pl --doit --category <-- also didnt update the category i entered 15:46 caroline I'm on 20.05.05 I will try it 15:46 shaffendi ok thanks 15:54 caroline hm... it seems to work for me 15:54 shaffendi huhu 15:54 shaffendi erm.. 15:54 caroline I only did ./borrowers-force-messaging-defaults.pl --doit 15:54 cait1 what exactly did you enter for category? 15:54 caroline I set defaults for 3 of my categories 15:54 cait1 the internal code? same spelling? 15:55 shaffendi Since: 0000-00-00 1: ADMIN 2: ADMIN Total borrowers updated: 2 15:55 shaffendi ./borrowers-force-messaging-defaults.pl --doit <-- when i did this 15:55 cait1 do you have more than 2 users in ADMIN? 15:55 shaffendi i have only 2 admins 15:55 cait1 ok, doy ou have other users? 15:56 shaffendi but i got 9 more patron categories 15:56 cait1 do you only have patron categories or users in them too? 15:56 shaffendi yes i have patron that have been assinged to that 9 categories 15:56 cait1 hm 15:56 cait1 did you check theem in case of the output of the script being wrong? 15:56 cait1 caroline: it showed a full report for you? 15:57 caroline For me, the output of the script was all the patrons 15:57 caroline but I didn't specify --category 15:58 cait1 hm sorry, running out of ideas then :( 15:58 cait1 brb 15:58 caroline shaffendi: can you show me the output for when you did it with --category? 15:58 shaffendi defauls that u mean is tick the email on item due, check in /out hold right? 15:58 shaffendi ok wait 15:59 shaffendi ults.pl --doit --category LIB Since: 0000-00-00 Total borrowers updated: 0 15:59 caroline shaffendi: yes that's it 15:59 caroline do you have access to the database? 15:59 shaffendi yes i have 15:59 caroline can you do select count(*) from borrowers where categorycode = "LIB" 16:00 shaffendi ok wait 16:00 shaffendi 72 16:00 caroline hm 16:04 shaffendi any other sugestion? 16:05 shaffendi maybe i can query direct from database? is it posible? 16:06 caroline shaffendi: we have a plugin to use this script from the interface, not sure if it will help, but maybe you can try? 16:06 shaffendi sure i will give a try 16:06 caroline https://inlibro.com/en/instructions-notifications-wizard/ 16:07 caroline haven't tried it on 20.05 yet, but it should still work 16:08 shaffendi how do i use it 16:09 caroline Do you know How to install a plugin? 16:09 shaffendi *while reading manuals lol 16:09 shaffendi koha> tool> plugin 16:09 shaffendi upload 16:09 caroline yup, after that you have to "Enable" and then Execute 16:10 shaffendi Records deleted between these dates: 16:10 shaffendi undeleterecord? 16:10 caroline hm... wrong download 16:11 shaffendi ehhh 16:11 shaffendi i click download undeleterecords.kpz 16:11 caroline god... I'll tell the guys to change it -_- 16:11 shaffendi lol 16:11 caroline https://inlibro.com/en/koha-plugins/ 16:11 caroline you can download it from there, it seems to be the right one 16:14 shaffendi ok done enable 16:14 shaffendi how do i use it 16:14 shaffendi can u guide me 16:14 caroline Actions > Execute 16:15 caroline I'm doing it at the same time, 1 sec 16:15 shaffendi Actions > Execute <-- u mean Run? 16:15 caroline yes sorry 16:15 shaffendi ok done 16:16 caroline Then you should only have to click launch 16:17 shaffendi ok 16:17 shaffendi done 16:17 shaffendi it got 2 option 16:17 caroline check your patrons 16:17 shaffendi by date and reset tick box 16:18 caroline Yeah, you don't have to use those, maybe reset if you want 16:19 caroline Mine worked 16:19 shaffendi so which 1 i should use? 16:19 shaffendi reset? 16:19 shaffendi i imported all my patron on certain date 16:20 caroline I didn't check anything and just clicked launch 16:20 shaffendi ok 16:20 shaffendi auwww 16:20 shaffendi Internal Server Error 16:20 wahanui i heard Internal Server Error was not good even if config is wrong 16:20 caroline ugh 16:20 caroline too bad 16:20 shaffendi :( 16:22 shaffendi what i did wrong? haha 16:23 caroline I'm wondering if it didnt work because of a problem eith the daa? 16:23 caroline data 16:24 caroline do all of your patrons have a patron category? 16:24 caroline select categorycode, count(*) from borrowers group by categorycode; 16:25 shaffendi ya it have 16:25 shaffendi select categorycode, count(*) from borrowers group by categorycode; <-- i execute this 16:25 shaffendi it display number of patron by each category 16:25 caroline no NULL? 16:26 shaffendi if got null it will apear on that list? 16:26 caroline it should yes 16:26 shaffendi no. no null here 16:26 caroline and all the categories in that list are real categories? 16:27 shaffendi i checked just not it is the same patron categories that i set 16:27 caroline they match your categories in Admin > Patron categories 16:27 shaffendi ya it match 16:27 caroline ok 16:27 shaffendi wait i check it again 16:28 shaffendi ya it is the same 16:28 shaffendi i did try like this just now 16:29 caroline it's good (but it's bad for my theory lol!) 16:29 shaffendi i manually click preference on patron 16:29 shaffendi tick the email check in out manually for 1 patron under other than ADMIN catagory 16:30 shaffendi i made a checkout and exucte the send out mail 16:30 shaffendi i received the eail 16:30 shaffendi email* 16:31 shaffendi so i think if the patron categories not right, the email wont sent out. am i right? 16:31 caroline My theory is that there is 1 patron in the batch that is causing a probblem 16:31 shaffendi hurm..maybe.. 16:31 shaffendi i got 20k patron lol 16:32 caroline and when the script arrives at that patron, it breaks 16:32 shaffendi ohh... 16:32 caroline I thought maybe one patron had a category that didn't exist 16:33 shaffendi when i run your query 16:33 shaffendi not all patron categories use 16:33 shaffendi i mean there are 2-3 patron categories that no patron under it 16:34 shaffendi could it be the prob? 16:34 caroline I don't think that's a problem 16:34 caroline If you can check the logs, you could have a clue as to what the problem is 16:35 shaffendi apache log or koha log? 16:36 caroline koha log 16:37 shaffendi got a few file name here 16:37 shaffendi plack error, sip2, oac 16:37 shaffendi opac 16:37 shaffendi zebra 16:37 shaffendi which 1 should i take a look 16:38 shaffendi plack intranet? 16:39 caroline yes probably plack intranet 16:39 caroline around the time you had the internal server serror 16:40 shaffendi caroline 16:40 wahanui well, caroline is there supposed to be a documentation meeting now? 16:41 shaffendi i just rerun the plugin u ask me to download 16:41 shaffendi it work but 16:41 shaffendi lol 16:41 shaffendi Number of borrowers to process: 2 This job was started in the background, your changes will be applied soon. 16:41 oleonard Anyone know if it's possible to get biblio information from the API using an item barcode? 16:41 shaffendi oh my.... 16:41 caroline there is still only 2 patrons 16:43 shaffendi ya... T_T 16:43 caroline nothing in the logs? 16:47 shaffendi nothing close to that time 16:47 caroline :/ 16:50 shaffendi is there any compulsory field that that script need in order to run? 16:50 shaffendi i mean 16:51 shaffendi the only field that the ADMIN have and the others dont have is firstname 16:51 shaffendi ADMIN have firstname but other patron dont have 16:51 shaffendi others just have surname 16:53 shaffendi this is from plack error 16:53 shaffendi Accept failed with 1 tries left: Invalid argument Accept failed with 1 tries left: Invalid argument Accept failed with 1 tries left: Invalid argument Accept failed with 1 tries left: Invalid argument Accept failed with 0 tries left: Invalid argument Accept failed with 0 tries left: Invalid argument Accept failed with 0 tries left: Invalid argument Accept failed with 0 tries left: Invalid argument Ran out of accept retries! Ran out of accept retries! Ran 17:14 reiveune bye 17:47 shaffendi thanks btw caroline for your help. i twill cont try to find solution tomorrow 18:32 tuxayo About creating an atomicupdate, what should one do with the last line? «NewVersion( $DBversion, XXXXX, "Description");» 18:32 tuxayo https://wiki.koha-community.org/wiki/Database_updates#How_to_write_an_atomicupdate_file 18:32 tuxayo Before running locally, should the version be filled or should I comment it? 18:48 kidclamp XXXXX is the bug number, and you should replace the description 20:16 tuxayo kidclamp++ Thanks :D the bugnumber is what I was missing, now it should run locally. 20:17 kidclamp excellent! 20:17 wahanui darn tootin' it is.