Time Nick Message 22:57 cait good night! 22:57 JasonGreene[m] good night 22:57 JasonGreene[m] yes, I'll pause for tonight, Tomorrow, I'll rebuild the server, do the import and restart Koha-common and see if it takes the import again 22:54 JasonGreene[m] now let me search to see what is in the DB 22:54 cait at least maybe something to go continue working on - time to box up cookies and go to sleep here 22:54 JasonGreene[m] yes, my data... not the MARCXML download 22:53 cait which one finished? the earlier one? 22:52 JasonGreene[m] one finished and one failed 22:52 cait we do have some remaining issues with rabbitmq 22:52 JasonGreene[m] that is odd from my view 22:52 JasonGreene[m] \ouch 22:52 cait hah :) 22:52 JasonGreene[m] that made the imports work 22:52 cait is that a good oh? 22:52 JasonGreene[m] Oh!!!! 22:50 cait hm? 22:50 JasonGreene[m] it too that command 22:50 JasonGreene[m] I'll try sudo service koha-common restart 22:50 cait the background jobs like importing 22:50 cait zebra is the search engine, we are trying to get rabbitmq going - that handles the jobs 22:49 cait i know there is different ways to do this, but this might work: sudo service koha-common restart 22:49 cait it should bring up the rabbitmq things that might be missing 22:49 JasonGreene[m] oh. I didn't see a "restart" command 22:49 cait koha-common is a system service (I think that's the right term) 22:49 cait no not koha zebra :) 22:48 JasonGreene[m] maintenance@Koha-library:~$ sudo koha-restart-zebra... (full message at <https://matrix.org/_matrix/media/v3/download/matrix.org/nxzjYtsHxKCnOkXwJzINIhUy>) 22:47 JasonGreene[m] ok 22:47 cait try to restart koha-common 22:47 JasonGreene[m] i downloaded the file from the link you sent and get a yellow 0% Not started and null/0 22:44 JasonGreene[m] I'll try thanks and see you tomorrow 22:28 caroline leaving for the night, see y'all tomorrow 22:25 caroline That way, we'll know it's not the records the problem 22:25 caroline or like, find another Koha library and download one of their records in MARC format 22:23 caroline can you try to import something that you know for sure is OK? Like https://lccn.loc.gov/2004670356/marcxml (this is MARCXML not MARC) 22:22 caroline pretty sure it's the workers 22:20 JasonGreene[m] hmmm.. laughing... now what? 22:20 caroline :((( 22:20 JasonGreene[m] jobs shows null/0 22:19 caroline :( 22:19 JasonGreene[m] got yellow bar "0% Not started" 22:18 * cait is waiting for cookies to finish baking 22:18 ashimema Mine was about encoding errors 22:18 JasonGreene[m] Clicked "Stage for import" 22:17 cait caroline++ 22:17 JasonGreene[m] selected "add incoming record" 22:17 caroline yeah us too, we have one where it warns if the branchcode is incorrect, but I think it was stuck too 22:16 * ashimema goes back to bed 22:16 ashimema We definitely need better errors handling for imports.. I even wrote bugs for it but they're stuck in discussion I think 22:16 JasonGreene[m] clicked "Upload file" 22:16 JasonGreene[m] selected "Flora-2-26-24-1-online-help-edit-mrc" 22:15 caroline lol the play by play 22:15 JasonGreene[m] Browse 22:14 JasonGreene[m] Clicked "Stage MARC records for import" 22:14 JasonGreene[m] Agree 22:13 caroline if it works we should write a bug report saying the import process needs to have error messages when records are not ok. seriously 22:12 JasonGreene[m] ... now ... ask Koha to import the .mrc ;-) 22:11 cait :) 22:11 JasonGreene[m] ok, that is complete 22:11 caroline " 22:11 caroline the video says "Compile and upload your records into Koha) 22:11 JasonGreene[m] ok, I'll do that 22:10 caroline yeah I think that's it 22:10 JasonGreene[m] when I double click the .mrk it opens it in MarcEdit and there is an option in "File" to "Compile file to Mark that has .mrc option 22:09 caroline Here it seems to say "save as" https://youtu.be/lVeIFVkgP6o?si=3c0SLFvr8uILNXm_&t=1470 22:08 cait on linux now so can't check 22:07 cait not a save as 22:07 cait I think it's a "convert to" entry in the first menu if using mrac edit 22:07 JasonGreene[m] no, only mrk or mrk8 on this part 22:06 caroline can you save as .mrc? 22:06 JasonGreene[m] so now import the new .mrk into koha ? 22:05 JasonGreene[m] All the 952$ were "join items" and it made a .mrk 22:02 caroline I guess you can "save as" .mrc after? 22:00 JasonGreene[m] that option makes an .mrk 21:59 JasonGreene[m] ok,,, next step... MarcEdit creating the mrc using the "Export Tab Delimited Text" option 21:57 caroline yep looks good to me 21:56 * JasonGreene[m] posted a file: (357KiB) < https://matrix.org/_matrix/media/v3/download/matrix.org/ZRyJzbkWSzEpAcCekLfHyNmN/Flora-2-26-24-1-online-help-edit.csv > 21:55 caroline lol! 21:54 JasonGreene[m] ok, I'll put it back 21:54 JasonGreene[m] Thinking... 21:54 caroline :) 21:54 caroline barcode? 952$p 21:53 JasonGreene[m] great. take one more look 21:53 * JasonGreene[m] posted a file: (328KiB) < https://matrix.org/_matrix/media/v3/download/matrix.org/CZNPkAgIkbepMXJYWylhVIfJ/Flora-2-26-24-1-online-help-edit.csv > 21:52 caroline save as .mrc and import .mrc into Koha 21:52 caroline skip the .mrk 21:52 JasonGreene[m] so, now save the csv and run it through MarcEdit and make a .mrc and then make the .mrc into a .mrk and then import the .mrk into Koha ??? 21:47 JasonGreene[m] ok, I'll change it to 952$b and remove 952$ 21:47 caroline 952$ should be 952$b I think 21:43 JasonGreene[m] ok, I've made the changes and this is that the csv has... (full message at <https://matrix.org/_matrix/media/v3/download/matrix.org/EjTWLaggkNEAYQzwlKFmyAQw>) 21:37 caroline That's what I use for migrations. Then, I don't know if it's necessary, but I reindex bc I'm not sure it does it automatically misc/search_tools/rebuild_elasticsearch.pl (for elasticsearch) or ./misc/migration_tools/rebuild_zebra.pl (for zebra) 21:36 caroline check misc/migration_tools/bulkmarcimport.pl 21:35 caroline you might want to try the command-line import, it might help to import, but will not fix the rabbit problem 21:34 caroline cait hinted that the import problem might be a rabbitmq problem 21:30 caroline Booklist_v2_final_FINAL ;) 21:29 caroline I think you should now have 952$a, 952$b, 942$c, 952$y, 650$a, 245$a, 100$a (or 700$a), 082$a, 952$o, and 952$p 21:28 JasonGreene[m] that's right.. now I remember 21:27 caroline yeah, probably because it was in 952$9, which is the koha itemnumber. That might indeed cause problems 21:27 JasonGreene[m] I have so many changed copies .... :-) 21:27 * JasonGreene[m] posted a file: (294KiB) < https://matrix.org/_matrix/media/v3/download/matrix.org/aMWTatmHSholiOoncbpkmrXc/Flora-2-21-24-1.csv > 21:27 caroline I don't think it will on a fresh system... If you want to keep it, put it in 952$p 21:25 JasonGreene[m] I'd like to keep the old data, but the idea was that it could cause import issue 21:23 caroline ok, you didn't want them anymore? I don't remember 21:22 JasonGreene[m] I took them out 21:22 JasonGreene[m] barcodes from the old system? 21:21 caroline Do you have the item barcodes somewhere? 21:20 caroline I think that should address all of cait comment from earlier 21:20 caroline also add a column 952$2 and put ddc in all the entries 21:20 JasonGreene[m] ok 21:19 caroline 700$a is secondary author, 100$ is primary author 21:19 caroline Maybe also change 700$a to 100$, but that is absolutely not necessary 21:19 JasonGreene[m] ok, I added 9525$b column and copied a into b 21:19 caroline In that case, I would copy 952$a and make 952$, copy 942$c to make 952$y, and copy 082$a to make 952$o 21:17 JasonGreene[m] SURE 21:06 caroline JasonGreene[m], Can you duplicate columns? i.e. add a "952$b" column that is the same content as 952$a? 20:56 * JasonGreene[m] posted a file: (257KiB) < https://matrix.org/_matrix/media/v3/download/matrix.org/SIJQGShMEGoBsFfPfuZGCbMU/Flora-2-23-24-1.csv > 20:52 JasonGreene[m] I re-built the server. Can someone look at our book spreadsheets before we try to import them to insure it is usable ? 20:32 jalway Guess that was it. Setting the acquisitions marc framework setting to mandatory for the field fixes my problem. 20:24 jalway Hmm..., or I just need to set it to mandatory? XD y Koha item type Tab:10, | Koha field: items.itype, Not repeatable, Not mandatory, Not important, | Auth value:itemtypes 20:23 jalway Is there a setting I'm missing? Or is that "normal"? Or something I screwed up along the way? 20:23 jalway Before I file a bug: I'm finding that Koha is letting me save an item without an itemtype when creating an order. 19:23 JasonGreene[m] ok, strange thing.. I just tried to import into the library system and Koha disconnected me. I couldn't log in with any account... I rebooted the server and still can't log in as a user or admin. 18:32 JasonGreene[m] thanks 18:31 cait I have to go - hope it helped a little 18:31 cait so the inventory tool and other features work 18:31 cait but if it matches the stickers on your books (where to find them) I'd also add it to the items 18:31 cait yes, it's ok, you can keep them 18:28 JasonGreene[m] 082$a are the Dewey numbers 18:28 JasonGreene[m] We took $9 out of the spreadsheet and it still failed 18:22 cait And I am not sure what this is, but it doesn't look quite right: $9L000792 (from your example) 18:22 cait and I would add a callnumber on item level - 082 is displayed, but the use is limited. if you want to do inventory, or search for callnumber in item search, you need it in 952$o 18:21 cait you need $2 with the code for your classification scheme - ddc if you are using DDC 18:21 cait you need $y with the itemtype - the code you configured in administration > itemtypes 18:21 cait $a is your homebranch, you need to add $b witht he same code for the holdingbranch - these are mandatory 18:21 cait hm ok, I am not making sense :) 18:20 cait d 18:20 cait so it's not read as a subfiel 18:20 cait $aFRL$9L000792 < here I saw the $9 - yo umight need to escape that 18:20 JasonGreene[m] We are trying to move from an old Handy Library Manager system to Koha 17:56 JasonGreene[m] 082 is Dewey 17:53 JasonGreene[m] $9 ? 17:52 JasonGreene[m] 952$a 942$c 650$a 245$a 700$a 082$a 17:51 JasonGreene[m] 952$a 942$c 650$a 245$a 700$a 082$a 17:51 JasonGreene[m] sort of...my excel has these 17:50 cait hope any of that made sense :) bbl 17:50 cait and your 337 might be the item type for 952$y? 17:49 cait and I'd put the itemcallnumber in 952$o that you seem to have in 082 - it will make things easier and set $2ddc - it will make Koha create a sorting form of yoru item callnumber, if $2 is missing, that won't happen 17:48 cait a = b if the item is at it's homebranch, but you need to set both 17:48 cait missing b (not y) and y and 2 (typoed the first subfield in my list) 17:47 cait what is $9 in your example? 17:47 cait also $2ddc if you are using ddc, or the sorting form of the callnumber won't be generated (later if you don't have one now) 17:47 cait you really need to add these 17:47 cait and 952$y 17:47 cait although your are missing 952$y 17:47 cait I think it's not your record 17:43 JasonGreene[m] Thoughts?? 17:35 JasonGreene[m] =952 \$aFRL$9L000792 17:35 JasonGreene[m] =700 \$aSharkley Don 17:35 JasonGreene[m] =650 \$aBlessed Virgin Mary 17:35 JasonGreene[m] =337 \$aBK 17:35 JasonGreene[m] =245 \4$aThe Woman Shall Conquer 17:35 JasonGreene[m] =082 \$a232.91 Sha 17:35 JasonGreene[m] =008 240222s9999||||xx||||||||||||||||und|| 17:35 JasonGreene[m] =LDR 00000nam a2200000Ia 4500 17:35 JasonGreene[m] this is the same book that we were trying to import and Marc converted an excel and would not import so I had to manually add the book to see the differences 17:35 cait mrc is every record on one line among some other differences 17:32 caroline learning something everyday :) 17:32 caroline i didn't know that was the difference between mrk and mrc 17:31 cait ok 17:31 JasonGreene[m] yes 17:31 cait this is what you see in marcedit, right? not another editor? 17:30 JasonGreene[m] =999 \$c1$d1 17:30 JasonGreene[m] =952 \$00$10$2ddc$40$70$92$aFRL$bFRL$cGEN$d2024-02-24$l0$r2024-02-24 16:35:24$w2024-02-24$yBK 17:30 JasonGreene[m] =942 \$2ddc$cBK$n0 17:30 JasonGreene[m] =700 \$aSharkley Don 17:30 JasonGreene[m] =650 \$aBlessed Virgin Mary 17:30 JasonGreene[m] =245 \$aThe Woman Shall Conquer 17:30 JasonGreene[m] =082 \$a232.91 Sha 17:30 JasonGreene[m] =040 \$aDLC$beng$cDLC $dOCLCO$erda 17:30 JasonGreene[m] =008 240224b\\\\||||||||||||\00|\0\eng\d 17:30 JasonGreene[m] =005 20240224161410.0 17:30 JasonGreene[m] =003 OSt 17:30 JasonGreene[m] =LDR 00451nam a22001577a 4500 17:30 JasonGreene[m] I open the file with MARC and see this 17:29 cait so maybe not a format thing, but the rabbit 17:29 cait hm 17:29 JasonGreene[m] no it goes to null/0 17:28 cait like... every field on one line? then you have .mrk 17:28 cait if you open it with an editor, is it readable? :) 17:28 JasonGreene[m] I opened it with MarcEdit and made some changes... then tried to import it... no luck 17:28 caroline are you able to reimport it without any changes? 17:27 JasonGreene[m] yes, when it exported... it was mrc 17:26 JasonGreene[m] ok.. I'll try that 17:26 cait you need the not readable format 17:25 cait did you convert it back to .mrc before importing? 17:25 cait hm you can't export .mrk, only .mrc 17:25 JasonGreene[m] s/adds/added/ 17:25 JasonGreene[m] Ok, I manually adds a book, then I exported that .mrk and looked at it, I edited it to make a new book and tried to import it... it failed. 17:08 * cait waves 16:53 cait hm, thinkign about it, some are very similar, like the one in Montreal to the others, they mostly share the same OpacUser* 16:51 caroline oof, that's a lot! 16:51 cait mostly yes, we don't have the experience of a lot of breakage, it mostly happened when the theme was changed (prog > bootstrap), staff redesign didn't cause much trouble so far 16:50 caroline each with individual opacs? 16:50 cait caroline: we have 130 :) 16:34 caroline if you only have one library to worry about, it's fine to customize with CSS and JS, but when you have 60+ it becomes very heavy in upgrade season 16:32 caroline ok, I was wondering if there was a more permanent way of doing it. In my experience, CSS and JS tend to break on updates, so I avoid them as much as possible 16:32 dolf_ cait: No, I did not set any XSLT preferences. What do you mean by a "better error"? 16:31 cait caroline: we woudl do it with CSS i think 16:10 caroline (I have a client who only has online publications, no items, so nothing is "available" according to Koha, but everything is bc it's online) 16:10 caroline Is there a way to remove the "Limit to available items" facet? I don't see it in the facet options in Administration > Search engine configuration 16:08 cait krimsonkharne[m]++ 16:08 cait caroline++ :) 16:07 krimsonkharne[m] u2 16:07 krimsonkharne[m] thx for the tip! 16:07 krimsonkharne[m] caroline: caroline++ 16:07 caroline have a good evening! 16:07 krimsonkharne[m] well, tomorrow.. I'm off for today :) 16:07 cait mtj: around? 16:07 krimsonkharne[m] might as well test the bug as long as I'm at it 15:56 krimsonkharne[m] I'll have to look at that again 15:54 krimsonkharne[m] ah cheers 15:53 huginn` 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32142 enhancement, P5 - low, ---, aleisha, Needs Signoff , Add HoldFeeMode option "if all items are checked out OR the record has at least one hold already" 15:53 caroline also bug 32142 15:50 caroline krimsonkharne[m], I'm not sure but did you check HoldFeeMode? 15:49 cait did you change the XSLT files? Did you set any paths in the XSLT system preferences? 15:48 cait dolf: I think there is a better error hiding in your logs 15:47 krimsonkharne[m] yeah exactly caroline ! 15:47 caroline i.e. if the item is available, then no fee, but if the item is loaned out, then fee? 15:46 krimsonkharne[m] AFAIK hold fees are currently only configurable by patron category so I would be interested to know if somebody has both options 15:46 krimsonkharne[m] hey all, slightly offtopic question: anybody have a client that allows both free (as in: no fee) requests on media that are in the shelves - that is, just request to take them off the shelf and set them aside at the front desk - and also has normal holds with a fee on media that is currently loaned out? 15:43 reiveune bye 15:18 dolf logs in the same way on version 21.11. I did so now, and whenever I refresh the `opac-search.pl` page, I get the following error: https://pastebin.com/dk3wQtKy . When refreshing the opac-detail.pl page, I get the following error: https://pastebin.com/GQKEnN0d . Any ideas? 15:18 dolf working fine, but I restored a backup of it onto a temporary VM. The VM is currently at 21.11 where it's broken, but I also have a snapshot of 21.05 where it was working just fine, to which we can roll back if needed. Last time, we tested with `tail -f /var/log/koha/rsc/*.log` (`rsc` being the instance name), and nothing showed up when refreshing the problematic page. When I revisited the IRC log, I realized that we never checked the 15:18 dolf Hi there. A while ago some of you kind people helped me to debug a problem with upgrading from 21.05 to 21.11. Full discussion is from https://irc.koha-community.org/koha/2024-01-04#i_2529627 to https://irc.koha-community.org/koha/2024-01-04#i_2529740 . In short: After upgrading from 21.05 to 21.11, the part of the page where the output of the XSLT display should be, is completely missing. I left our production site on 21.05 where it is 15:01 huginn` Joubu: The operation succeeded. 15:01 Joubu @later tell dcook 36094#c17 - Can you deal with that as soon as you can please? 15:00 aude_c[m] Probably. We're telling them more about the new features next week, we'll let you know if there's interest 14:59 caroline that's why I think a presentation could be interesting 14:59 caroline yeah but maybe they just don't know how it could help 14:59 aude_c[m] Haven't really heard anyone say they're looking to use it (yet) 14:59 aude_c[m] most of our libraries are still on 22.11; just starting to upgrade to 23.11 in March-April 14:58 aude_c[m] no... 14:57 caroline aude_c do any of your clients use it? 14:57 caroline good idea, I'll email them 14:57 cait maybe ask bywaters educators? 14:56 cait yeah that would be great 14:56 caroline like an IRL use of it 14:56 caroline I'd really like to have someone present the module at Kohacon, so that people get to know it, but Amaury said he couldn't nor anyone at BULAC :( 14:56 cait not us yet, wrong version 14:55 caroline do we know of anyone who uses the preservation module other than BULAC? 14:53 cait give or take one hour 14:53 cait not bad 14:53 cait 3pm 14:53 cait for europe it's ok 14:52 caroline yeah I think Europe and NZ are not compatible whatever you do 14:51 cait well 14 is not much better, neither is 13 14:51 caroline according to timeanddate.com, 12UTC is 1am in Wellington, so pretty bad for them too I think 14:50 cait so 14 UTC ok? 14:49 caroline 12 UTC is 7am in eastern north america. So you'll have only the hardcores 14:48 cait I think 12 UTC is probably better for NZ, but not sure about canada, possibly bad for Argentina? 14:47 cait 12 UTC or 14 UTC? 14:47 cait I need to push the just rescheduled meeting by one hour - forward or back - what is better? 14:41 paulderscheid[m] https://manpages.debian.org/unstable/libswagger2-perl/Swagger2.3pm.en.html 14:41 paulderscheid[m] I just read the deprecation warning on debian's manpages. Seems that it was a precursor to JSON::Validator (or at least its role). 14:39 ashimema confused 14:39 ashimema I think 14:39 ashimema the api 14:39 paulderscheid[m] Quick question, what did we use libswagger2-perl for? 13:23 cait hola tcohen 13:22 tcohen hola cait 13:22 tcohen oh 13:19 cait Joubu++ # running meeting script, but got to start somewhere 13:14 cait kidclamp: stop ignorning me pls :) 13:14 huginn` Log: https://meetings.koha-community.org/2024/development_irc_meeting_7_february_2024.2024-02-26-13.13.log.html 13:14 huginn` Minutes (text): https://meetings.koha-community.org/2024/development_irc_meeting_7_february_2024.2024-02-26-13.13.txt 13:14 huginn` Minutes: https://meetings.koha-community.org/2024/development_irc_meeting_7_february_2024.2024-02-26-13.13.html 13:14 huginn` Meeting ended Mon Feb 26 13:14:23 2024 UTC. Information about MeetBot at http://wiki.debian.org/MeetBot . (v 0.1.4) 13:14 cait #endmeeting 13:14 cait #info Rescheduling the missed meeting from 7 February 13:14 cait #info Next meeting: 28 February 2024, 13 UTC 13:13 huginn` The meeting name has been set to 'development_irc_meeting_7_february_2024' 13:13 huginn` Useful Commands: #action #agreed #help #info #idea #link #topic #startvote. 13:13 huginn` Meeting started Mon Feb 26 13:13:25 2024 UTC. The chair is cait. Information about MeetBot at http://wiki.debian.org/MeetBot. 13:13 cait #startmeeting Development IRC meeting 7 February 2024 13:13 cait so don't be surprised :) 13:13 cait Hi all, I'll do a fake meeting for rerunning the meeting script 13:11 * cait waves 13:11 ashimema but rarely actually active on it 13:11 ashimema I'm there 13:04 aude_c[m] I think I'm on that Koha-US Slack workspace 13:04 aude_c[m] Definitely lunchtime over here :D 12:54 tcohen :-D 12:53 paulderscheid[m] but maybe on lunch in europe :D 12:53 paulderscheid[m] yes 12:52 tcohen is anyone here? 12:50 tcohen is anyone on the slack channel koha-us set up? 12:47 tcohen hola #koha o/ 12:33 cait hi kidclamp 11:55 oleonard :D 11:47 paulderscheid[m] Monday Minutes w/ Paul 11:47 paulderscheid[m] Don't chain ->to 11:46 paulderscheid[m] The subsequent call just overrides the previous state of the route object if anyones interested. 11:40 paulderscheid[m] I'm always amazed how the mojolicious team built this whole thing w/o types. 11:38 paulderscheid[m] It seems that Additional#check completely circumvents the authentication. 11:37 paulderscheid[m] Well yeah it is, the question is why? 11:37 paulderscheid[m] Is this bad ->under('/...')->to('Auth#under')->to('Additional#check')? 11:14 cait oh now I missed fridolin 11:06 cait but keeps you away from the computer rather effectively :) 11:04 ashimema 😂 11:03 cait yes, was good. Did a lot of tidy up and sorting - incredible how many things fit in my small apartment 11:02 ashimema hope you had a good break cait 11:02 cait bit overwhelmed, but feels good too 11:02 cait thanks :) 10:59 paulderscheid[m] Good that you're back btw 10:59 paulderscheid[m] Just wanted to look up when it was scheduled and found nothing. 10:59 paulderscheid[m] Cool thanks 10:49 cait I will try to get to it today and send an email reminder 10:49 cait yes, it was not re-scheduled yet 10:42 paulderscheid[m] Shouldn't there be a dev meeting in the calendar this week? 10:42 cait hi paulderscheid[m] 10:42 paulderscheid[m] Hi cait1 10:34 cait1 hope to reach the top soon :) 10:34 cait1 hi #koha - I am back, but a bit stuck in a mountain of emails still 09:04 PedroAmorim[m] \o 08:15 paulderscheid[m] morning #koha 08:08 krimsonkharne[m] morning #koha 08:07 ashimema Morning 08:05 fridolin le bonjour 07:06 reiveune hello