| Time |
S |
Nick |
Message |
| 04:09 |
|
|
Oak joined #koha |
| 04:56 |
|
|
cait joined #koha |
| 06:09 |
|
|
magnuse joined #koha |
| 06:10 |
|
magnuse |
\o/ |
| 06:48 |
|
|
alex_ joined #koha |
| 07:04 |
|
|
thibaud_g joined #koha |
| 07:15 |
|
|
cait joined #koha |
| 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[…]import_patrons.pl |
| 08:03 |
|
|
dcook_ joined #koha |
| 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/man[…]ml#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 |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=33043 enhancement, P5 - low, ---, kyle, Signed Off , Use process_tt in SIP modules |
| 10:49 |
|
|
khall joined #koha |
| 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:00 |
|
|
alex_ joined #koha |
| 12:27 |
|
ashimema |
there's a bug on this line right: https://git.koha-community.org[…]e_notices.pl#L422 |
| 12:28 |
|
ashimema |
we should surely be sending $digests there and not $due_digest |
| 12:29 |
|
|
khall joined #koha |
| 12:31 |
|
cait |
hm there is more mentions of $due_digest |
| 12:33 |
|
cait |
but it looks like you are right |
| 12:35 |
|
|
nikkom joined #koha |
| 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? |
| 15:01 |
|
|
thibaud_g joined #koha |
| 16:29 |
|
cait |
bye #koha |
| 16:29 |
|
|
cait left #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 |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=21983 blocker, P5 - low, ---, tomascohen, Needs Signoff , Better handling of deleted biblios on ILL requests |
| 17:03 |
|
|
Dyrcona joined #koha |
| 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:29 |
|
|
dpk joined #koha |
| 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 |
| 17:59 |
|
|
dpk joined #koha |
| 18:01 |
|
|
cait joined #koha |
| 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 |
