Time Nick Message
06:10 magnuse \o/
07:37 aw-bib[m] hello! I am pretty new to koha, so I am still trying it find my way around. as my current job is to migrate an existing, running ILS to koha, I wonder where I can find some pointers for this migration steps. AFAIS the bibliographics seems pretty straight forward (I'll have to juggle some ouf our marc, but that's fine) but I did not yet find hints on how to migrate the patrons, their loans, ideally historic loan data (so we don't loose all
07:37 aw-bib[m] usage stats). Could someone in the know probably give me some pointers here? (I don't mind to write a few lines of code for this endeavour, in fact I am pretty sure I have to as we use a not so common ILS right now.)
07:59 cait hi #koha
08:00 cait For patrons you can use the patron import tool
08:00 cait it requires a csv file, but the instructions are all listed on the tool page
08:00 cait if you have a lot of patorns, there is a command line script that can do it (avoids running into timeouts with big files)
08:00 cait it works the same as the tool
08:00 cait aw-bib[m]: ^
08:00 aw-bib[m] ah, a cli would indeed come in handy!
08:01 cait easiest for items is to include them as 952 in your MARC records
08:01 cait Koha will create items from 952 fields on import
08:02 cait for any other data you'd want to write scripts to add to the database tables directly
08:02 cait checkouts go into issues (as an example)
08:02 cait This is the patron import script: https://git.koha-community.org/Koha-community/Koha/src/branch/master/misc/import_patrons.pl
08:04 aw-bib[m] I noticed 952 and am about to rewrite our holdings to this tag. but how about historic loans or who has the item right now? IOW how do I feed the patron accounts?
08:06 aw-bib[m] Maybe this is what you refer to by writing to the db directly.
08:07 aw-bib[m] There isn't by any chance some write up which data how to what table?
08:08 aw-bib[m] (Btw: I could even imagine to call up some koha api to feed it in.)
08:13 cait I think the API mihgt not work for that (yet)
08:13 cait you can ask here, for checkouts it's 2 things you'll need:
08:13 cait table issues
08:13 cait and then when you have that, update items.onloan for your checked out items with the due date
08:14 cait you could in theory use the offline circulation file format, but it's limited in what it lets you do, like you can't migrate the due dates that way
08:14 aw-bib[m] cait: ok, good to know then I'll not search for it ;)
08:16 aw-bib[m] btw: for the last migration I missused the sip-back end for some sort of replay. but on that system I wrote said back end. (funnily enough we used koha code in front of these functions.)
08:19 cait You could try SIP, but it might be more painful that way than just using SQL
08:19 cait and with SQL you'll get the best results usually, like you can also migrate the number of renewals, last renewal date, etc. if your current system has those
08:21 aw-bib[m] ah, cool. ok, then I'll dive into the sql. indeed, on the current system I do have quite some data and if it's possible to keep those I'd go for it.
08:23 aw-bib[m] btw: am I correct, that koha stores almost all config in sql and only a basic outset in conf-files? (I am wondering as I'd like to set up at least two identical boxes one for me to play and screw up and one where we can dive into the actual usage of koha.)
08:25 cait yes, I think you could say that most ist in the db
08:25 cait for migration testing if you have a clone with the same db that shoud work very well
08:25 cait someone from Biblibre around maybe?
08:26 cait jajm: alex_ matts?
08:26 aw-bib[m] ok. then I'll need to dive into this for the setup as well. afais the installer and onboarding tools both "just" upload a st of sqls, so maybe I can prepare something similar here as well.
08:28 cait yes, they mostly select some SQL files and add some basic configurationt o db
08:29 aw-bib[m] ok, then I got this right. thank you already for all this info. :) beware I may come back with a lot more... ;)
08:31 cait it's ok, the IRC chat is a good place to ask for those things
08:31 cait may I ask what system you currently use and where your library is?
08:35 aw-bib[m] sure. currently we run invenio 1 "with a few modifications" that reached the end of life time. as we use the current setup for more than just the ils the search for a successor wasn't that easy and right now we are in the uncomfortable situation to split what we had in one system again into two, and I won the ILS migration while another group is migrating the repository (that also holds quite a lot of CRISish functions.)
08:43 cait ah makes sense
08:44 cait I have heard about invenio, but never migrated it or seen it in action
08:45 aw-bib[m] if you're interested we can schedule some hands on. it's actually a nice system, the main issue is that upstream (3.x) they switched the focus quite a bit.
08:45 cait thx for the kind offer, but have my hands pretty full at the moment
08:46 cait just wonderng, since I think invenio is swiss, are you german speaking? :)
08:46 aw-bib[m] well swiss, I'd call it CERN. but indeed I am from germany and also german speaking, yes.
09:00 magnuse cait++
09:01 magnuse we could write those tips up as a wiki page
09:02 magnuse there is https://koha-community.org/manual/22.11/en/html/implementation_checklist.html#data-migration but that lacks some of the technical details
09:06 cait aw-bib[m]: just a guess, I am in Konstanz :)
09:06 aw-bib[m] magnuse: just to note: as I have to write this up anyway I could well imagine to contribute there. One issue we have is that I'd like to avoid _clicking it all together_. for some practical reasons and lessons learned from our project I tend to favour git controlled parameters added automatically. (not because we are _that large_.)
09:06 aw-bib[m] cait: Moin from Hamburg. ;)
09:10 cait heh :) probably too far to see me waving then
09:12 aw-bib[m] oh well. I'll wave back, you know it's quite flat here ;)
10:26 paxed oh, nice, i was just looking at the SIP TT processing, nice to see bug 33043 fixes it
10:26 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33043 enhancement, P5 - low, ---, kyle, Signed Off , Use process_tt in SIP modules
10:51 ashimema morning
11:02 cait morning and welcome back:)
11:03 ashimema lots of things to catch up on
11:03 ashimema seems like it was a rather busy week last week
11:11 oleonard Still waiting for KohaCon registration to open eh?
11:14 magnuse aw-bib[m]: if you can write up your findings on the wiki that would be awesome
11:14 aw-bib[m] I'll do my very best.
11:16 cait if you need a proof reader let me know
11:18 cait oh and let me know when you register, I can moderate the wiki account request :)
11:18 aw-bib[m] ack. I'll first write it up as I go here on my box but once I got something working that is actually migrating some of our data to the proper fields...
11:31 tcohen names
11:31 cait hello to you too, tcohen ;)
11:31 tcohen hola #koha o/
11:32 tcohen hola cait
11:35 tcohen did I miss too much on friday?
11:35 cait I was not around much either
11:36 tcohen we had a really positive KOha presentation in Buenos Aires
11:36 tcohen (and ASpen)
11:36 cait awesome :)
11:36 oleonard ooh, nice tcohen !
11:49 magnuse yay, getting close to 500 contributors!
11:55 cait hea numbers have also grown quite a bit again
12:27 ashimema there's a bug on this line right: https://git.koha-community.org/Koha-community/Koha/blame/branch/22.11.x/misc/cronjobs/advance_notices.pl#L422
12:28 ashimema we should surely be sending $digests there and not $due_digest
12:31 cait hm there is more mentions of $due_digest
12:33 cait but it looks like you are right
12:45 nikkom Hi koha. "I want to change logo in intranet (8080). I add these lines into IntranetUserCSS. It doesnt work" (9 lines) at https://paste.koha-community.org/15534
12:45 nikkom How can I change the logo?
13:16 magnuse huh? getting this in the plack error log: Invalid version format (non-numeric data) at /usr/share/koha/lib/C4/Installer/PerlModules.pm line 83, <DATA> line 755.
13:16 magnuse that line looks like: my $pkg_version = $module->can("VERSION") ? $module->VERSION : 0;
13:17 magnuse makes the "about" page throw a 500 error
13:21 PedroAmorim[m] magnuse: is this master?
13:22 magnuse no, 22.05.06
13:22 magnuse with some patches
13:22 PedroAmorim[m] at a glance it seems like some module is returning a version with some stuff in it other than numbers!
13:23 magnuse yup
13:23 PedroAmorim[m] can you dump $module->VERSION somewhere in the code?
13:24 magnuse i did a "warn $pkg_version;" after the line above, but all i got was "0.19" as the last one before the error
13:28 PedroAmorim[m] try it before the line
13:28 PedroAmorim[m] and if that fails, try dumping the whole $module see what last module name shows up before the 500
13:36 magnuse thanks, i'll have to leave that for tomorrow. gotta run off and make dinner!
13:45 PedroAmorim[m] nikkom: staff UI was redesigned in 22.11, that selector in your pastebin does not work anymore because .gradient no longer exists
14:28 tcohen mtj: around?
16:29 cait bye #koha
16:33 ashimema anyone know who Sam Lau is?
16:33 ashimema they're marching up the dashboard with signoffs
16:33 oleonard ashimema: An intern at ByWater
16:34 ashimema ah,, cool
16:34 ashimema I thought the name rang a bell
16:34 ashimema nice work
17:02 tcohen bug 21983
17:02 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 blocker, P5 - low, ---, tomascohen, Needs Signoff , Better handling of deleted biblios on ILL requests
17:04 tcohen ^^ ashimema
17:04 tcohen need your eye
17:05 ashimema Will take a look in 5
17:08 tcohen I'll prepare a 22.11 patch
17:08 tcohen if we agree
17:08 tcohen well, it is basically just skipping the 23.05 db_rev fix
17:24 ashimema Looks solid to me tcohen
17:34 tcohen ashimema: good
17:34 ashimema just booting the laptop to actually test it.
17:38 ashimema stupid question
17:38 ashimema should deleted_biblio_id be a foreign key on the deleted_biblio table?
17:40 tcohen I thought the same...
17:40 tcohen and saw aqorders didn't have the fk
17:40 ashimema it's not for the aqorders case
17:40 ashimema haha
17:40 tcohen right
17:40 ashimema I imagine it might make things in DelBiblio more complex?
17:40 * ashimema hasn't fully read that code recenly
17:41 tcohen this deals with DelBiblio in an elegant way
17:41 tcohen cait insisted statistics would benefit from keeping it, so...
17:41 tcohen I left it
17:42 tcohen read the codce
17:42 ashimema fair enough
17:44 ashimema leave it as is.. if cait wants it for stats
17:45 ashimema adding a key would need a modification to DelBiblio.. you'd need to copy the biblio to deletedbiblio before setting the deleted_biblio_id in illrequests
17:45 ashimema anywho.. time for me to clock out for a second time 😜
17:45 ashimema see ya tomorrow
17:45 * ashimema SO'd
17:51 tcohen thank you
18:34 tcohen cait: please review the ill fk bug
18:34 tcohen whenever you can
19:06 cait on my todo list already, thx!
23:25 mtj hi tcohen, about now