| Time |
S |
Nick |
Message |
| 00:17 |
|
Penggu |
dcook__: Had to delete a couple of publishercode indexes on biblioitems and deletedbiblioitems because the upgrade script was trying to convert the column to text from varchar(255). Finally finished the upgrade! Thanks for your help! |
| 00:18 |
|
dcook__ |
Penggu: No worries! |
| 00:18 |
|
dcook__ |
With the conversion, was the problem that it was slow or was it creating an error? |
| 00:19 |
|
Penggu |
creating an error |
| 00:20 |
|
dcook__ |
Hmm could you raise a ticket with that information on Bugzilla? That would be good to share |
| 00:20 |
|
Penggu |
after the mysql client library downgrade, it progressed through some steps, but then hung on those index issues. |
| 00:20 |
|
Penggu |
i'll see if i still have some material to make the bug report useful |
| 00:20 |
|
dcook__ |
What version were you upgrading to? |
| 00:20 |
|
dcook__ |
Thanks :) |
| 00:21 |
|
Penggu |
we're now on 23.05.02.000, according to the UI. The offending upgrade script was 230501003.pl. |
| 00:22 |
|
Penggu |
there are no entries in db_revs that create the index. so it must've come from way back... |
| 00:24 |
|
dcook__ |
Yeah it would be an old old index |
| 00:42 |
|
|
dcook_ joined #koha |
| 00:58 |
|
Penggu |
https://bugs.koha-community.or[…]_bug.cgi?id=34548 |
| 00:58 |
|
huginn |
Bug 34548: major, P5 - low, ---, koha-bugs, NEW , Upgrade failed on conversion of publishercode from varchar to text on biblioitems and deletedbiblioitems due to existing indexes |
| 01:02 |
|
Penggu |
adios! |
| 01:39 |
|
edveal[m] |
So for those in Helsinki, I hope you are enjoying the conference. I think have the perl group and our Koha community together is a great thing. I am waiting for Montreal dates so I can book my travel. |
| 01:42 |
|
dcook_ |
<3 |
| 01:42 |
|
dcook_ |
edveal[m] Can't wait for Montreal! |
| 02:18 |
|
|
edveal joined #koha |
| 02:21 |
|
edveal |
Ok, I am leaning Element on my phone and at work but not liking it. Now that I am back on an IRC program proper, is there a way to link them so I don't have two nicks? |
| 02:30 |
|
edveal |
@later tell bag Any chance that BWS might be able to provide me any assistance to me for attending Kohacon24 in Montreal. As soon as the dates are set Janet and I are going to be making plans to attend. The problem is that the city of McKinney wont pay for anything out of the country so it will be completely out of pocket. I know this is a bit forward but you can't say yes if I don't ask. LOL I would be glad to work on a formal presentation if that helps. |
| 02:30 |
|
edveal |
Either way I hope to see you there! |
| 02:30 |
|
huginn |
edveal: The operation succeeded. |
| 03:02 |
|
|
edveal_ joined #koha |
| 04:39 |
|
|
dolf joined #koha |
| 05:07 |
|
|
fridolin joined #koha |
| 05:46 |
|
|
reiveune joined #koha |
| 05:49 |
|
reiveune |
hello |
| 06:33 |
|
|
oleonard_ joined #koha |
| 06:34 |
|
oleonard_ |
o/ |
| 06:41 |
|
dcook_ |
\o |
| 07:01 |
|
davidnind |
I'm assuming no live streams today and tomorrow for KohaCon 8-( |
| 07:01 |
|
ashimema |
I don't think so |
| 07:02 |
|
ashimema |
I'm doing mine over zoom right now |
| 07:02 |
|
ashimema |
but from what I'm told it doesn't look like any of the workshops are setup for streaming at the moment. |
| 07:03 |
|
davidnind |
Happy to do any sign offs, just going to have some tea first |
| 07:04 |
|
ashimema |
We're working through bugs attached to Bug 23003 - Accessibility improvements |
| 07:04 |
|
huginn |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=23003 enhancement, P5 - low, ---, oleonard, NEW , Accessibility improvements |
| 07:04 |
|
ashimema |
and I'm sure other workshops will be doing their own. |
| 07:04 |
|
dcook_ |
I don't have anything to add at the moment but *waves* and *runs away from his desk* |
| 07:04 |
|
davidnind |
great stuff there for accessibility, lots to do .... |
| 07:20 |
|
|
ebegin joined #koha |
| 07:28 |
|
|
ebegin joined #koha |
| 07:37 |
|
|
matts_ joined #koha |
| 07:39 |
|
|
NadeemSohail[m] joined #koha |
| 07:40 |
|
NadeemSohail[m] |
Hello... (full message at <https://matrix.org/_matrix/med[…]LGOzdLNbsoWCDszld>) |
| 07:42 |
|
paulderscheid[m] |
morning #koha |
| 07:42 |
|
ebegin |
Does sandboxes support ES ? |
| 07:46 |
|
oleonard_ |
WAVE accessibility extension: https://addons.mozilla.org/en-[…]cessibility-tool/ |
| 07:46 |
|
ashimema |
They should ebegin |
| 07:46 |
|
ashimema |
I believe we run the container for ES, so you should just need to change the system preference |
| 07:47 |
|
ashimema |
Another accessibility extension I've had recommended is https://chrome.google.com/webs[…]nindnejefpokejbdd |
| 07:48 |
|
|
aude_c[m] joined #koha |
| 07:48 |
|
aude_c[m] |
Matt mentioned siteimprove https://www.siteimprove.com/in[…]owser-extensions/ |
| 07:52 |
|
|
fridolin1 joined #koha |
| 07:55 |
|
oleonard_ |
We do have a QA test for this one but only in the OPAC I think: https://bugs.koha-community.or[…]_bug.cgi?id=25166 |
| 07:55 |
|
huginn |
Bug 25166: enhancement, P5 - low, ---, oleonard, CLOSED FIXED, Add aria-hidden = "true" to Font Awesome icons in the OPAC |
| 07:56 |
|
oleonard_ |
That is supposed to prevent screen readers from trying to speak the icon |
| 07:58 |
|
NadeemSohail[m] |
Hello !... (full message at <https://matrix.org/_matrix/med[…]DFcIfQvIbvkOzyWTg>) |
| 08:01 |
|
aude_c[m] |
Lund University Opac accessibility statement https://www.ub.lu.se/accessibility-lubcat (Opac at https://lubcat.lub.lu.se/?language=en) |
| 08:07 |
|
ashimema |
Nadeem Sohail: There are a few ways you can do this.. using a feed into Koha's CSV patron import tool, using the RESTful API's.. or perhaps even just using LDAP/SAML2 along with it's autocreation options. |
| 08:13 |
|
aude_c[m] |
Workshop on accessibility statement - see new wiki page https://wiki.koha-community.or[…]ibility_Statement |
| 08:13 |
|
dolf |
After upgrading my Koha from 21.05.00-1 to 23.05.02-1 yesterday, my search results don't look right: https://library.refstudycentre[…]sort_by=relevance The MARC data seems to be there, but the "normal view" is also empty https://library.refstudycentre[…]iblionumber=35948 . Yikes |
| 08:17 |
|
NadeemSohail[m] |
<ashimema> "Nadeem Sohail: There are a few..." <- Dear Ashimema, Thank you for your reply |
| 08:20 |
|
aude_c[m] |
davidnind Still around? We're looking for help with getting new Wiki logins for people at kohacon please :D |
| 08:20 |
|
oleonard_ |
dolf: Are you using a custom XSLT stylesheet? |
| 08:21 |
|
oleonard_ |
dolf: That problem is most often because of a broken XSLT stylesheet |
| 08:21 |
|
dolf |
oleonard_: Not that I know of, but it's not impossible. This Koha instance was first installed back in 2011. |
| 08:22 |
|
oleonard_ |
dolf: Check system preferences for xslt-related prefs |
| 08:23 |
|
davidnind |
aude_c: I am - there is a problem I think with email going out (I think tcohen was having a look at it) - I can see several waiting for approval. Do you know if they got a message to confirm their request? |
| 08:23 |
|
NadeemSohail[m] |
<NadeemSohail[m]> "Dear Ashimema, Thank you for..." <- ashimema: how we can you LDAP/SAML2 along with it's autocreation options |
| 08:24 |
|
ashimema |
Thanks for adding that new page aude_C |
| 08:24 |
|
ashimema |
s/aude_C/aude\_c/ |
| 08:24 |
|
dolf |
oleonard_: Most of the xlst settings are empty, but two of them are set to "default". Should they all be "default"? |
| 08:24 |
|
oleonard_ |
Yes |
| 08:24 |
|
dolf |
xlst should be xslt |
| 08:25 |
|
ashimema |
NadeemSohail[m]: https://koha-community.org/man[…]otocols.html#ldap |
| 08:26 |
|
ashimema |
ashimema: for Shibboleth/SAML2 there's examples in the koha-conf.xml too |
| 08:26 |
|
ashimema |
ashimema: https://wiki.koha-community.or[…]eth_Configuration |
| 08:27 |
|
ashimema |
ashimema: is some documentation around saml2 |
| 08:27 |
|
davidnind |
aude_c: I approved one for Andrew - it is supposed to send him an email with a temporary password - do you know if he has received it? |
| 08:28 |
|
aude_c[m] |
davidnind: Åsa and Andrew just got an email! Sophie is going to request a new one |
| 08:28 |
|
aude_c[m] |
davidnind++ |
| 08:28 |
|
ashimema |
nice one |
| 08:28 |
|
* ashimema |
just poked Tomas, but sounds like it got fixed before I did |
| 08:28 |
|
aude_c[m] |
Thank you for your help David :) |
| 08:29 |
|
davidnind |
aude_c: looks like tcohen fixed things! Sophie's is waiting for approval, so I'll just approve it and she should get a temporary password. |
| 08:30 |
|
aude_c[m] |
Brilliant! |
| 08:31 |
|
davidnind |
aude_c: Sophie's was waiting from the 20th July! I'll also approve the one waiting for Gladys as well. |
| 08:31 |
|
dolf |
oleonard_: Thanks for the help. Where it says Enter "default" for the default stylesheet I entered "default". Where it says Empty. No XSLT will be applied (default) I left it empty. I clicked all of the "save" buttons. AuthorityXSLTResultsDisplay I left empty because it does not say what the default should be. I also searched for "stylesheet", found opaclayoutstylesheet had a value, and cleared it. No difference. Is there a cache I should clear? |
| 08:32 |
|
davidnind |
tcohen++ for fixing the Wiki account request email sending |
| 08:32 |
|
oleonard_ |
dolf: I think you may need to restart some services but I'm not sure which |
| 08:33 |
|
oleonard_ |
dolf: I recall that testing XSLT customizations can be tedious because of that |
| 08:33 |
|
dolf |
OK, will do. I'll just reboot the VM, since it's a dedicated Koha VM. |
| 08:33 |
|
oleonard_ |
dolf: Are you using Koha Testing Docker? |
| 08:33 |
|
dolf |
No, I have a `apt install koha-common` on Debian 12 (updated from Debian 10 yesterday) |
| 08:34 |
|
|
Caroline joined #koha |
| 08:35 |
|
|
fridolin1 left #koha |
| 08:36 |
|
dolf |
No difference after the reboot :( |
| 08:36 |
|
|
ebegin joined #koha |
| 08:37 |
|
|
caroline joined #koha |
| 08:38 |
|
dolf |
I wonder whether this has anything to do with the "ALTER TABLE foo ROW_FORMAT=DYNAMIC;" queries I ran yesterday (mentioned above in IRC). |
| 08:40 |
|
|
dcook__ joined #koha |
| 08:43 |
|
|
caroline joined #koha |
| 08:53 |
|
aude_c[m] |
davidnind I'm sorry to bother you again. Sophie and Laurence say they didn't receive any emails... They tried both in July and today to set up a new account on the Wiki and reset password, and nothing. Any ideas, please? |
| 09:00 |
|
ashimema |
wiki email is 'fun' |
| 09:01 |
|
oleonard_ |
:D |
| 09:01 |
|
* ashimema |
is going through the coding guidelines and adding proper syntax highlighting to all the blocks missing it. |
| 09:01 |
|
oleonard_ |
Nice, I'm really glad we have that option now |
| 09:02 |
|
davidnind |
aude_c: I was just going to suggest they try a password reset, but since that didn't work it must be something with the email again! (Their accounts are created https://wiki.koha-community.or[…]er_talk:Smeynieux and https://wiki.koha-community.or[…]User_talk:Lrault) |
| 09:03 |
|
davidnind |
aude_c: if tcohen is around, could you ask him to have a look again? Unless ashimema has access... |
| 09:04 |
|
aude_c[m] |
Thanks! We'll ask. |
| 09:04 |
|
davidnind |
Thanks! |
| 09:04 |
|
ashimema |
I sort of have access.. but it's one of the places I don't have the knowledge.. I will get him to talk me through the fix some time so I can help when needed in the future. |
| 09:05 |
|
tcohen[m] |
we really need a reliable SMTP |
| 09:05 |
|
tcohen[m] |
Theke's work |
| 09:05 |
|
tcohen[m] |
s |
| 09:05 |
|
tcohen[m] |
but it gets banned from time to time by major providers (google, microsoft, etc) |
| 09:06 |
|
ashimema |
ptfs-e has their own email server too.. might be able to wangle using that if it helps? |
| 09:06 |
|
tcohen[m] |
sure |
| 09:06 |
|
tcohen[m] |
please do |
| 09:06 |
|
tcohen[m] |
there's a configuration file in /srv/wiki |
| 09:06 |
|
tcohen[m] |
with an SMTP config |
| 09:06 |
|
NadeemSohail[m] |
<ashimema> "is some documentation around..." <- Thank You very much sir, I am obliged you have share a wonderfull docomentations on my query. Stay blessed . |
| 09:06 |
|
tcohen[m] |
you can always back it up |
| 09:06 |
|
tcohen[m] |
and try |
| 09:08 |
|
|
oleonard_ joined #koha |
| 09:08 |
|
ashimema |
cool.. may need to wait for Jake to get home as he's the king of that particular castle here at the moment 😜 |
| 09:08 |
|
tcohen[m] |
so, SMTP configs, and then look for the sender email address in a bunch of places in that file, and replace it with something that works for your server |
| 09:09 |
|
oleonard_ |
Lunch time in Helsinki, devs please don't forget to eat :D |
| 09:57 |
|
|
oleonard_ joined #koha |
| 09:58 |
|
davidnind |
dolf: I added the record you linked to to my testing environment, and it displayed as expected (your page was missing the HTML markup for displaying the normal view details) |
| 09:59 |
|
davidnind |
If I add the record to the cart, the title etc displays OK |
| 09:59 |
|
davidnind |
do you have any custom JavaScript or CSS for the OPAC? |
| 09:59 |
|
dolf |
davidnind: Thanks, but I'm not sure I understand. Are you saying that you verified that the problem is not with my MARC data? |
| 10:00 |
|
dolf |
With the help of oleonard above, I removed all custom CSS, and saw no difference. I think there is a tiny bit of JS which just redirects the front page to the advanced search page, but I can remove that and see if it helps. |
| 10:02 |
|
davidnind |
dolf: that was what I was testing, so it doesn't seem to be a problem with the MARC record |
| 10:03 |
|
dolf |
Cool. That is expected, since no staff member has touched the site since I upgraded it yesterday, and everything was displaying nicely before the upgrade. |
| 10:03 |
|
dolf |
(I'm also getting 504 timeouts when doing Catalog searches, which did not happen before the upgrade. Probably unrelated, but I must look into that next) |
| 10:05 |
|
davidnind |
very frustrating! |
| 10:05 |
|
dolf |
This is the only custom JS in sight: https://pastebin.com/vACkhaFj |
| 10:08 |
|
dolf |
Oh, I had some OPACUserCss too, from long ago, for elements that don't exist. I removed both OPACUserCss and OPACUserJs. Saved. CTRL+F5 on OPAC. No difference yet. |
| 10:08 |
|
davidnind |
dolf: I just tried the mJS, and it works OK - so that isn't interferring |
| 10:09 |
|
davidnind |
mJS s/be JS |
| 10:09 |
|
dolf |
Here are the last few lines from my opac-error.log https://pastebin.com/RfgMgLkM I don't understand the messages, but I get them repeatedly. |
| 10:11 |
|
davidnind |
not something that makes sense to me either 8-( |
| 10:12 |
|
davidnind |
I'm not sure whether you would have to do a full reindex after an upgrade or not - hopefully someone on here can say whether this is what they would do or not |
| 10:14 |
|
davidnind |
sorry, I've got to the limit of my limited expertise... |
| 10:14 |
|
oleonard_ |
dolf: The ZOOM error is concerning, and presumably why you're having problem with searches |
| 10:15 |
|
oleonard_ |
dolf: But I don't know how to diagnose and fix. You need someone who knows about Zebra configuration. |
| 10:20 |
|
davidnind |
dolf: not sure whether an upgrade would replace the XSLT files or leave what was there - I think the XSLT files are in koha-tmpl/opac-tmpl/bootstrap/en/xslt - maybe comparing them to what is in master to identify any differences |
| 10:22 |
|
dolf |
Good idea! I'll ook into zebra reindexing and xslt file differences. I also noticed an e-mail saying "run-parts: /etc/cron.daily/koha-common exited with return code 1" so I have yet another thing to investigate. Hopefully all related. |
| 10:23 |
|
dolf |
Is the output of /etc/cron.daily/koha-common logged somewhere? |
| 10:31 |
|
dolf |
Nevermind, /etc/cron.daily/koha-common failing was an unrelated issue, which is sorted now. I appended a line to that script, and my line was failing. The rest of /etc/cron.daily/koha-common is running fine. |
| 10:44 |
|
|
khall joined #koha |
| 11:10 |
|
|
magnuse joined #koha |
| 11:19 |
|
|
cait1 joined #koha |
| 11:34 |
|
|
oleonard joined #koha |
| 11:55 |
|
dolf |
What is the character set supposed to be in the Koha database for most or all tables? latin1? utfmb4? |
| 11:55 |
|
dolf |
And the collation? |
| 12:04 |
|
dolf |
In my DB, the collation is utf8mb4_unicode_ci for all tables, except patron_consent which is latin1_swedish_ci for some reason. Would it be safe to convert patron_consent to utf8mb4_unicode_ci ? |
| 12:09 |
|
|
cait joined #koha |
| 12:12 |
|
|
magnuse joined #koha |
| 12:26 |
|
|
cait1 joined #koha |
| 12:30 |
|
|
cait2 joined #koha |
| 12:38 |
|
|
cait joined #koha |
| 12:41 |
|
|
cait left #koha |
| 12:46 |
|
|
Dyrcona joined #koha |
| 12:49 |
|
ashimema |
any chance of you casting your more artistic eye over Bug 34275 - Add a button to easily toggle between advanced/basic cataloging editors oleonard |
| 12:49 |
|
huginn |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=34275 enhancement, P5 - low, ---, lucas, Signed Off , Add a button to easily toggle between advanced/basic cataloging editors |
| 12:50 |
|
oleonard |
Sure ashimema |
| 12:50 |
|
ashimema |
cheers dude |
| 12:50 |
|
ashimema |
right.. I don't think I can put off bookings any longer.. I've got the QA queue moving again and thorough enjoyed the accessability workshop and future of koha talk this afternoon |
| 12:50 |
|
ashimema |
time to get on with the hard work again.. haha |
| 12:50 |
|
oleonard |
XD |
| 12:50 |
|
ashimema |
hope your all still enjoying KohaCon |
| 12:51 |
|
LibraryHU[m] |
can anyone help in getting accession register report from KOHA |
| 13:11 |
|
dolf |
oleonard: Do you mean here? https://github.com/Koha-Commun[…]pl/opac-tmpl/xslt There is only one file, and it looks the same as my folder at /usr/share/koha/opac/htdocs/opac-tmpl/xslt |
| 13:11 |
|
dolf |
davidind: previous msg is for you too :) |
| 13:12 |
|
dolf |
I also ran the commands from https://koha-community.org/man[…]t-the-zebra-index but I can't see a difference. Not sure if I'm supposed to run another command to re-index stuff after that? |
| 13:12 |
|
dolf |
The indexer daemon should do that eventually, I guess. |
| 13:13 |
|
* ashimema |
thinks he just scared oleonard away. |
| 13:16 |
|
dolf |
hahaha |
| 13:31 |
|
|
ebegin joined #koha |
| 13:31 |
|
|
caroline joined #koha |
| 13:31 |
|
aude_c[m] |
Emoji test for @ebg 😅 |
| 13:45 |
|
|
jalway joined #koha |
| 13:52 |
|
dolf |
What is plack? I can't find any docs on what it does or why I need it. I only see how to install it, here: https://wiki.koha-community.or[…]ebian#Setup_plack |
| 14:00 |
|
jalway |
https://en.wikipedia.org/wiki/Plack_(software) |
| 14:01 |
|
|
khall joined #koha |
| 14:01 |
|
jalway |
khall, Are you Kyle Hall? I found a minor error in the Patron Importer plugin. |
| 14:01 |
|
dolf |
jalway: Thanks, I read that, but it's a bit over my head. I was hoping for a simple explanation of what it does for Koha, and whether it's optional or not. |
| 14:02 |
|
jalway |
dolf, I would highly suspect that it's not. |
| 14:02 |
|
jalway |
dolf, Plack is likely baked into Koha. |
| 14:02 |
|
khall |
jalway can you file an issue on the github page for that and link it here? |
| 14:02 |
|
jalway |
I can do that from the web interface, yes? |
| 14:07 |
|
jalway |
https://github.com/bywatersolu[…]importer/issues/1 |
| 14:08 |
|
dolf |
Another question (please tell me if I'm being annoying): I'm trying to use koha-restore on a backup that was made with koha-run-backups (automatically). But I'm getting an erro "No database selected", as if the backup was made with "koha-dump --without-db-name". Is there a way to specify the name on the command line? Or is it a bug in koha-restore or in koha-run-backups? |
| 14:10 |
|
jalway |
dolf, Assuming that was directed at me, I have no idea. I hope you're testing your backup and not just hoping that your untested backup will save you. |
| 14:11 |
|
dolf |
Directed at anyone that would listen :) Yes, I'm testing a backup on a test VM at the moment. No success in restoring thus far. |
| 14:11 |
|
jalway |
dolf, That is definitely the best place to be at in that situation. xD |
| 14:13 |
|
jalway |
dolf, You're using the newest version of Koha? |
| 14:14 |
|
jalway |
dolf, Hmm..., maybe you're running into this: https://bugs.koha-community.or[…]_bug.cgi?id=15664 ? |
| 14:14 |
|
huginn |
Bug 15664: enhancement, P5 - low, ---, gmcharlt, NEW , koha-restore: Allow database dump to be restored to another Koha instance |
| 14:15 |
|
dolf |
Yes, I just installed Ubuntu 22 (I could test with Debian also, but it's very very similar) on a fresh test VM, then followed https://wiki.koha-community.or[…]ki/Koha_on_Debian exactly. I have Koha 23.05.02-1 with zero instances, and trying to restore one instance from a .sql.gz and a .tar.gz file. |
| 14:16 |
|
dolf |
wait... I commented on that issue in 2019 hahaha |
| 14:16 |
|
dolf |
I'm Rudolf Byker |
| 14:16 |
|
jalway |
Ah. XD |
| 14:20 |
|
dolf |
In that issue, the problem was that the database name was hardcoded into the sql dump. But it looks like my sql dumps (which come from koha-run-backups on version 21.something) already omit the "CREATE DATABASE" and "USE DATABASE" statements, so it should work? (My message above was confusing – I thought the database name should be in the sql dump, but I see that it's derived from the filename in the koha-restore script) |
| 14:20 |
|
jalway |
You're not trying to overwrite and instance, right? |
| 14:21 |
|
jalway |
*an |
| 14:21 |
|
dolf |
No. There are no instances on this machine. I just installed Ubuntu a few minutes ago. |
| 14:22 |
|
dolf |
Is restoring a backup from 21.* on 23.* unsupported, maybe? |
| 14:23 |
|
jalway |
That's entirely possible. |
| 14:24 |
|
jalway |
There's a bug for 17.x / 16.x, but that's when the biblio_metadata table was introduced. |
| 14:25 |
|
jalway |
Not sure, if there were changes to the database structure between 21.x and 22.x |
| 14:27 |
|
dolf |
There would be, but I was assuming that it's upgradable using the same script that runs after you do "apt upgrade". I'm installing 21.05 now, to try and restore to that. |
| 14:49 |
|
jalway |
khall, I forked the repository, edited the line in question, and pushed it. |
| 14:50 |
|
khall |
jalway did you push it to a github repo? |
| 14:59 |
|
|
lukeg joined #koha |
| 14:59 |
|
lukeg |
hi |
| 15:06 |
|
khall |
jalway fixed! |
| 15:09 |
|
jalway |
khall, Cool, thanks. :-) |
| 15:09 |
|
khall |
np! |
| 15:09 |
|
jalway |
khall, Do you have any documentation on how to use the Patron Importer? |
| 15:09 |
|
jalway |
khall, For whatever reason we're still unable to actually get it to work. :-( |
| 15:10 |
|
khall |
jalway do you have the nightly plugin cronjob enabled? You can run that manually for testing as well |
| 15:12 |
|
jalway |
khall, Pretty sure that's working. Was given a log showing that X num had been processed, but all entries were "invalid". |
| 15:12 |
|
khall |
jalway Also, a big question: Have you become the koha-user and manually connected to the SFTP server? That will accept the key and verify you can connect to it |
| 15:12 |
|
khall |
it has to be done from koha-shell |
| 15:12 |
|
jalway |
khall, I've run the test and it shows a successful test? |
| 15:12 |
|
jalway |
khall, I've definitely not done that. |
| 15:13 |
|
khall |
jalway give that a try |
| 15:13 |
|
khall |
it could be failing because the public key hasn' |
| 15:13 |
|
khall |
hasn't been accepted for that user |
| 15:14 |
|
reiveune |
bye |
| 15:14 |
|
|
reiveune left #koha |
| 15:52 |
|
|
Dyrcona joined #koha |
| 16:14 |
|
jalway |
khall, That wasn't the issue, but it did prompt a phone call. We're on the right track, I believe. |
| 16:14 |
|
jalway |
khall, Apparently the dateenrolled that we're supplying isn't in the expected format. xD |
| 16:28 |
|
|
khall joined #koha |
| 17:03 |
|
dolf |
I managed to restore from backup at last. I had to modify the .sql.gz file and add CREATE DATABASE ... and USE ... statements, OR modify koha-restore to create the database before importing the sql file and to set the database name on the command line when importing the sql file. |
| 17:04 |
|
dolf |
Now I just can't get the search results working. The OPAC search always gives me 0 results. I already did "koha-rebuils-zebra --full instance" (but this is done at the end of koha-restore anyway) and I did "koha-indexer --start rsc". Search results are still empty. I can access the individual books by biblio number in the URL without problems. |
| 18:09 |
|
|
Mimir9090 joined #koha |
| 18:09 |
|
Mimir9090 |
I think one thing I severely misunderstand is how networking for Koha works - I can't even log in on the local network from a different PC than the server is running on, let alone access the OPAC externally |
| 19:00 |
|
|
khall_ joined #koha |
| 19:03 |
|
dolf |
Mimir9000: Koha does not do anything special with regards to networking. It uses Apache2 as a web server. If you follow the guide at https://wiki.koha-community.or[…]ki/Koha_on_Debian you will see that it asks you to modify some variables in /etc/koha/koha-sites.conf . This is used to generate /etc/apache2/sites-enabled/foo.conf when you create a new Koha instance called 'foo'. Inside that are two VirtualHosts. A VirtualHost uses the domain |
| 19:03 |
|
dolf |
name from the URL in the browser to decide which website to serve, so that you can serve more than one website from the same machine through the same port (port 80 by default). Do some reading on how VirtualHost works in Apache2. Also make sure port 80 is open in the firewall, if there is a firewall. I hope this helps. |
| 19:05 |
|
dolf |
In principle: If you have a DNS setting or routing or any kind of network setup which causes a request for http://foo.example.com to end up at the IP on which your Apache2 is running, it will look for a VirtualHost with a ServerName of foo.example.com and try to serve that. |
| 19:18 |
|
Mimir9090 |
I do wonder if there's a firewall in the way |
| 19:18 |
|
Mimir9090 |
I asked a technician who said I may need to do port forwarding |
| 19:21 |
|
Mimir9090 |
Currently using MarcEdit to search my ISBNs - it's working, but most of them have a match on 1 out of 6 servers which makes me think I need to track down a couple more specialized servers to sure up my records |
| 19:21 |
|
Mimir9090 |
Presumably it's because this is mostly textbooks |
| 19:28 |
|
davidnind |
Mimir9090: Many organisations block non-standard ports/traffic from accessing the internet, such as those used by Z39.50 - for example, one of the Library of Congress servers is at lx2.loc.gov:210 |
| 19:39 |
|
|
khall joined #koha |
| 20:35 |
|
|
jalway joined #koha |
| 21:31 |
|
Mimir909 |
Holy cow it's working |
| 21:31 |
|
Mimir909 |
I did a batch ISBN lookup with Marc Edit, downloaded the results as a Marc, staged it for import and I now finally have a catalog |
| 21:37 |
|
Mimir909 |
It's a working marc file too, it's all there (as much as could be gotten) and the records will do me fine for now. How do I go about adding them into the catalog of my defined library? |
| 21:51 |
|
Mimir909 |
Ah, I see the problem - The job keeps failing |
| 21:52 |
|
jalway |
Mimir909, Are you using the compiled marc format or Marc Edit's broken apart, but human readable format? |
| 21:53 |
|
jalway |
Mimir909, Koha will only understand the standard marc format. |
| 21:53 |
|
Mimir909 |
It says it's a 'MARC binary' file |
| 21:53 |
|
jalway |
Mimir909, That should be correct, then. |
| 21:53 |
|
Mimir909 |
the staging seems successful because it has 5000 ish records, but it fails when importing them to catalog |
| 21:57 |
|
jalway |
Did you check for item record data? I'm assuming you've not setup items? |
| 21:58 |
|
Mimir909 |
When I installed Koha, it set a bunch of defaults for items, if that's what you mean |
| 21:58 |
|
Mimir909 |
Or shall I look at the file directly and check? |
| 21:58 |
|
jalway |
Unless you added items to your records, you won't have items. Just the records. |
| 21:59 |
|
Mimir909 |
Ooooooh, like one field that says "this many of this exist", or...? |
| 22:00 |
|
jalway |
Mimir909, You can export items with your marc record. In our old system it was a specific MARC field. In Koha, I think it's a bit more complicated, but you can get the items exported in a specific MARC field. Koha's MARC item field is 952, I believe. |
| 22:01 |
|
Mimir909 |
The MARC file was prepared with MarcEdit, if that helps |
| 22:01 |
|
jalway |
Mimir909, Yeah, so all you got were the bibliographic records. You have no item fields. |
| 22:01 |
|
Mimir909 |
I used its z39 client to make the records then just output them as a marc. So it can probably also set items |
| 22:02 |
|
jalway |
Mimir909, Just wondering, if that's causing your issue. Or perhaps you chose the incorrect encoding? |
| 22:02 |
|
jalway |
They staged properly, though? |
| 22:02 |
|
jalway |
You can click Manage Staged Records and there's a boat load of them? |
| 22:03 |
|
jalway |
Mimir909, How did you record multiple copies of an item in your spreadsheet? |
| 22:04 |
|
Mimir909 |
Well, what i've done here is take my spreadsheet of ISBNS and converted them to TXT for the z39 client, then looked them all up in a batch, then exported a marc file from that |
| 22:04 |
|
Mimir909 |
The staged record showed no errors and has records for all the items, but they are not showing in the actual catalog and importing them fails |
| 22:05 |
|
jalway |
Mimir909, Yeah, that is cool. Do the books that you have on the shelf have barcodes and/or call numbers associated with them? |
| 22:05 |
|
jalway |
As in phsyical labels on the books. |
| 22:05 |
|
jalway |
*physical |
| 22:05 |
|
Mimir909 |
Not yet - We were using a different software which had a bespoke nonsense number system |
| 22:05 |
|
jalway |
Mimir909, That's actually kind of good. |
| 22:05 |
|
Mimir909 |
They have unique identifiers but the catalog they existed in is totally wrecked and no barcodes either. Just labels. |
| 22:06 |
|
Mimir909 |
So this initial inventory was done by hand by me |
| 22:06 |
|
jalway |
Mimir909, How did you record how many of X book that you have? |
| 22:06 |
|
Mimir909 |
For each copy, the ISBN or entry is just duplicated |
| 22:06 |
|
Mimir909 |
(many do not have ISBNs, that's a whole other issue) |
| 22:07 |
|
jalway |
Mimir909, You could do a new search by title using MARCEdit, but that would be error prone. |
| 22:07 |
|
jalway |
I.E. The same way you did the ISBN data gathering. |
| 22:08 |
|
jalway |
Mimir909, Are you proficient in any computer languages or actually able to do things like create scripts to manipulate lines of data? |
| 22:08 |
|
Mimir909 |
I mean, the items without ISBNs are few enough to be manually corrected later |
| 22:09 |
|
Mimir909 |
I know enough to understand lines of data and a script if I'm reading it, but haven't coded much |
| 22:09 |
|
Mimir909 |
I can do formulas in Excel pretty okay. |
| 22:09 |
|
jalway |
Mimir909, I highly suggest that you come up with a barcode system that you would like to use. |
| 22:10 |
|
Mimir909 |
That's in the works - For now I guess I need to determine how to tell Koha '1 of this exists' so the import works |
| 22:10 |
|
jalway |
Mimir909, In our library, we typically use a 6 digit number padded with zeros, if necessary. |
| 22:10 |
|
jalway |
Mimir909, You just need to tell the import to not look for item records, I think. |
| 22:11 |
|
Mimir909 |
Just having the catalog in any form will save me a lot of immediate agony in what I'm doing, and polishing it to a proper library setup can wait a little while |
| 22:11 |
|
jalway |
Mimir909, If you just want to upload the records into the catalog. |
| 22:11 |
|
jalway |
When you're staging the records. |
| 22:13 |
|
Mimir909 |
Hmmmmmm. i don't fully understand this and will have to leave shortly if I'm going to make it to the gym on time to keep my date with my SO. Is it possible to message directly and arrange for later contact? |
| 22:13 |
|
Mimir909 |
These more in-depth guidances are really helping me get my mind around all this for work. |
| 22:14 |
|
Mimir909 |
I never got super into IRC to know if/how anything like that works |
| 22:18 |
|
jalway |
Uh, not really. Here's a video, though: https://youtu.be/0fJpIqYVMLs?t=568 |
| 22:19 |
|
jalway |
Found one that goes through the steps, but I'm not sure that you're having issues with using it or if something's wrong with some of your records or what. xD |
| 22:21 |
|
jalway |
I'm out for now as well, hope you get it figured out! |
