Time |
S |
Nick |
Message |
00:44 |
|
|
inlibro joined #koha |
01:44 |
|
|
inlibro joined #koha |
02:44 |
|
|
inlibro joined #koha |
03:44 |
|
|
inlibro joined #koha |
04:44 |
|
|
inlibro joined #koha |
05:05 |
|
|
chris joined #koha |
05:44 |
|
|
inlibro joined #koha |
05:54 |
|
|
calire joined #koha |
06:04 |
|
|
fridolin joined #koha |
06:05 |
|
fridolin |
hi |
06:20 |
|
|
cait joined #koha |
06:30 |
|
cait |
hi #kolha |
06:30 |
|
cait |
hi #koha |
06:31 |
|
|
laurence joined #koha |
06:37 |
|
|
reiveune joined #koha |
06:37 |
|
reiveune |
hello |
06:45 |
|
|
inlibro joined #koha |
06:49 |
|
|
alexbuckley joined #koha |
06:56 |
|
|
alex_a joined #koha |
06:56 |
|
alex_a |
bonjour |
07:10 |
|
|
marcelr joined #koha |
07:11 |
|
marcelr |
hi #koha |
07:14 |
|
cait |
hi marcelr |
07:16 |
|
marcelr |
o/ |
07:45 |
|
|
inlibro joined #koha |
08:23 |
|
|
AnkeB joined #koha |
08:34 |
|
|
greenjimll joined #koha |
08:45 |
|
|
vfernandes joined #koha |
08:45 |
|
vfernandes |
hi #koha |
08:45 |
|
|
inlibro joined #koha |
09:43 |
|
magnuse |
hiya #koha! |
09:43 |
|
* magnuse |
tries to get back in the groove after 5 weeks off |
09:45 |
|
|
inlibro joined #koha |
09:50 |
|
|
khall joined #koha |
09:59 |
|
magnuse |
huh, isn't there a bug about hiding "finished" ill requests? |
10:11 |
|
marcelr |
hi magnuse |
10:45 |
|
|
inlibro joined #koha |
10:53 |
|
magnuse |
hiya marcelr |
10:54 |
|
magnuse |
@wunder bodø, norway |
10:54 |
|
huginn` |
magnuse: Error: I could not find a valid location for: bodø, norway |
10:54 |
|
magnuse |
@wunder bodo, norway |
10:54 |
|
huginn` |
magnuse: Error: Failed to load Wunderground API. Check the logs for more information. |
11:15 |
|
|
khall joined #koha |
11:20 |
|
|
oleonard joined #koha |
11:21 |
|
oleonard |
Hi all |
11:28 |
|
kidclamp |
welcome back oleonard |
11:28 |
|
|
jzairo joined #koha |
11:28 |
|
oleonard |
Thanks, it's been a nice month-long vacation |
11:32 |
|
* magnuse |
waves to oleonard and kidclamp |
11:43 |
|
calire |
hi oleonard |
11:43 |
|
wahanui |
hi oleopard |
11:45 |
|
|
inlibro joined #koha |
11:52 |
|
|
khall joined #koha |
12:17 |
|
oleonard |
Sorry I missed Community Day. Any thoughts on whether it was "successful?" |
12:18 |
|
cait |
i missed it too |
12:18 |
|
cait |
I wante dto ask people to update the wiki maybe with their projects? |
12:18 |
|
cait |
I saw that Holly submitted some manual updates and I know catalyst ran projects the whole day |
12:19 |
|
cait |
oleonard: coudl you help fix bug 23143 maybe? |
12:19 |
|
huginn` |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=23143 major, P5 - low, ---, koha-bugs, NEW , [18.11] Filter paid transactions not working |
12:20 |
|
magnuse |
yeah, i was sorry to miss community day too. maybe we could have another one? |
12:20 |
|
cait |
I'd love that |
12:20 |
|
oleonard |
cait: I'll have to dig out of this week-high pile of emails, but I'll give it a go |
12:22 |
|
cait |
i think it's somethign to do with a backport maybe |
12:22 |
|
cait |
we had an issue in master too, but not sure how to resolve |
12:31 |
|
|
khall joined #koha |
12:33 |
|
|
khall joined #koha |
12:46 |
|
|
inlibro joined #koha |
13:03 |
|
oleonard |
kidclamp: I added a very small follow-up to Bug 23385 |
13:03 |
|
huginn` |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=23385 enhancement, P5 - low, ---, nick, Needs Signoff , Hide default value fields by default on patron import |
13:08 |
|
tcohen |
morning #koha |
13:08 |
|
cait |
mornign tcohen |
13:08 |
|
tcohen |
ashimema: did we agree to make 18.05.x require Stretch as well? |
13:08 |
|
tcohen |
hi cait! |
13:18 |
|
kidclamp |
oleonard++ |
13:30 |
|
|
wizzyrea joined #koha |
13:31 |
|
oleonard |
Hi wizzyrea |
13:31 |
|
|
caroline_catlady joined #koha |
13:34 |
|
caroline_catlady |
Good morning everyone! |
13:34 |
|
caroline_catlady |
It's a bright and sunny morning here in Montreal, a bit hot, but so far tolerable |
13:35 |
|
caroline_catlady |
How's everyone? |
13:38 |
|
wizzyrea |
good morning |
13:38 |
|
wizzyrea |
how is everyone |
13:39 |
|
|
khall joined #koha |
13:39 |
|
oleonard |
I arrived at work before it got hot and I don't want to know if that has changed. |
13:39 |
|
caroline_catlady |
Hi wizzyrea! |
13:40 |
|
* cait |
waves |
13:44 |
|
wizzyrea |
it was not hot when i started but that could quicklly change |
13:46 |
|
|
inlibro joined #koha |
13:50 |
|
oleonard |
cait: Bug 23143 patch sent |
13:50 |
|
huginn` |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=23143 major, P5 - low, ---, koha-bugs, Needs Signoff , [18.11] Filter paid transactions not working |
14:04 |
|
cait |
thx a lot |
14:14 |
|
|
calire left #koha |
14:19 |
|
|
corilynn joined #koha |
14:22 |
|
|
caroline_catlady joined #koha |
14:42 |
|
oleonard |
Oh hey Bug 23013 still applies... Good to know... |
14:42 |
|
huginn` |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=23013 enhancement, P5 - low, ---, oleonard, Needs Signoff , Upgrade DataTables in the staff client |
14:46 |
|
|
inlibro joined #koha |
14:53 |
|
corilynn |
isn't there a way to see what bugs have been applied to a koha instance? |
14:53 |
|
cait |
one of the sandboxes or your own? |
14:54 |
|
corilynn |
sandbox |
14:54 |
|
cait |
one of the new ones? |
14:54 |
|
cait |
look for the git log |
14:55 |
|
cait |
Logs > koha git log |
14:55 |
|
cait |
the last one |
14:55 |
|
wahanui |
the last one is pretty new |
14:55 |
|
cait |
when martin pushes, he adds a sign-off line... so all the patches that don't have that shoudl be the ones appleid by you |
14:55 |
|
cait |
on the one you got currently it looks like plain master |
14:56 |
|
cait |
http://sb1.sandboxes.bywaterso[…].com/git_log/cori |
14:56 |
|
corilynn |
yeah, it's not even letting me login |
14:56 |
|
cait |
ah interesting |
14:56 |
|
cait |
may i try? |
14:56 |
|
corilynn |
please |
14:56 |
|
cait |
ah right |
14:56 |
|
cait |
you need a different logi/pass to run the web installer |
14:56 |
|
cait |
i think you seleted without sample data or something |
14:57 |
|
cait |
try koha_<nameofinstance> /password |
14:57 |
|
cait |
that's the 'db user' |
14:57 |
|
corilynn |
weird |
14:57 |
|
corilynn |
i've never had that happen before |
14:58 |
|
corilynn |
error: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/share/perl5/DBIx/RunSQL.pm line 273. |
14:58 |
|
cait |
oh |
14:58 |
|
cait |
which step? |
14:58 |
|
cait |
khall: around? |
14:59 |
|
corilynn |
"Web installer › Set up database" |
14:59 |
|
corilynn |
what I'd like is a post- 18.05.xx installation |
15:00 |
|
cait |
what did you enter on setting it up? a branch? |
15:00 |
|
corilynn |
i entered nothing |
15:01 |
|
reiveune |
bye |
15:01 |
|
|
reiveune left #koha |
15:01 |
|
corilynn |
there's some thought that after 16232 that advanced cataloging doesn't load |
15:02 |
|
cait |
I am not sure why it didn#t create the sample data as it usually does |
15:02 |
|
corilynn |
when I put 16232 in the bug #, then the sandbox doesn't work, and if I leave it blank (current master) it has the db installation issue as above |
15:03 |
|
cait |
maybe did you do a 'clear database' action? |
15:03 |
|
corilynn |
i did not |
15:03 |
|
cait |
hm |
15:03 |
|
cait |
it might be a sandbox issue, not sure |
15:04 |
|
corilynn |
probably |
15:04 |
|
wahanui |
i heard probably was too hard. |
15:05 |
|
alex_a |
corilynn, the editor loads after 16232. But it adds a undefined save backend that conflict with 18823 |
15:05 |
|
corilynn |
yes, that's what I've been saying, so you have to adjust 18823 to account for this |
15:06 |
|
alex_a |
corilynn, you don't need to add 16232, it is already in master |
15:06 |
|
corilynn |
ok |
15:06 |
|
alex_a |
You are trying on a sandbox ? |
15:06 |
|
corilynn |
i was, yes |
15:06 |
|
corilynn |
i was trying to get "master" working on a sandbox, that had 16232 installed |
15:09 |
|
|
kellym joined #koha |
15:10 |
|
|
fridolin left #koha |
15:11 |
|
cait |
bye all |
15:11 |
|
|
cait left #koha |
15:19 |
|
corilynn |
ugh, |
15:20 |
|
corilynn |
i have a 19.05 version that won't load the advanced cataloging editor at all |
15:20 |
|
corilynn |
Uncaught ReferenceError: insert_copyright is not defined |
15:20 |
|
corilynn |
at marc-editor.js:140 |
15:20 |
|
corilynn |
at Object.execCb (require_19.0502000.js:29) |
15:20 |
|
corilynn |
at X.check (require_19.0502000.js:18) |
15:20 |
|
corilynn |
at X.<anonymous> (require_19.0502000.js:23) |
15:20 |
|
corilynn |
at require_19.0502000.js:8 |
15:20 |
|
corilynn |
at require_19.0502000.js:23 |
15:20 |
|
corilynn |
at y (require_19.0502000.js:7) |
15:20 |
|
corilynn |
at X.emit (require_19.0502000.js:23) |
15:20 |
|
corilynn |
at X.check (require_19.0502000.js:19) |
15:20 |
|
corilynn |
at X.<anonymous> (require_19.0502000.js:23) |
15:26 |
|
kidclamp |
check the keyboard shortcuts table, is it there? |
15:26 |
|
kidclamp |
did the database get updated? |
15:27 |
|
corilynn |
did the database get updated when? |
15:27 |
|
kidclamp |
when upgraed to 19.05? |
15:27 |
|
corilynn |
i created a new 19.05 |
15:27 |
|
corilynn |
i didn't upgrade |
15:28 |
|
kidclamp |
it should be intserted with manadatory data in 19.05 |
15:28 |
|
corilynn |
ok, i didn't uncheck anything |
15:28 |
|
kidclamp |
SELECT * FROM keyboard_shortcuts |
15:30 |
|
|
caroline_catlady joined #koha |
15:30 |
|
corilynn |
empty set |
15:30 |
|
corilynn |
(kidclamp) |
15:33 |
|
|
kellym joined #koha |
15:34 |
|
kidclamp |
yeah, that's bad |
15:34 |
|
corilynn |
i created a bug |
15:35 |
|
corilynn |
bug 23396 |
15:35 |
|
huginn` |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=23396 major, P5 - low, ---, koha-bugs, NEW , Rancor fails to load: insert_copyright is not defined |
15:43 |
|
|
laurence left #koha |
15:44 |
|
corilynn |
also, kidclamp, I don't know if you saw this, but the Sandboxes appear to be broken as well :( |
15:44 |
|
corilynn |
http://sb1.sandboxes.bywatersolutions.com/ |
15:46 |
|
|
inlibro joined #koha |
15:50 |
|
|
kellym_ joined #koha |
15:53 |
|
|
kellym_ left #koha |
16:13 |
|
tcohen |
has anyone used Test::NoWarnings |
16:16 |
|
|
cait joined #koha |
16:46 |
|
|
inlibro joined #koha |
17:37 |
|
corilynn |
oleonard, can you point me to a script to populate the missing data for 19.05? |
17:40 |
|
oleonard |
http://git.koha-community.org/[…]1faca3fa7;hb=HEAD |
17:41 |
|
corilynn |
thanks, man |
17:41 |
|
oleonard |
...I assume, based on your conversation with kidclamp |
17:41 |
|
corilynn |
you also updated the bug |
17:41 |
|
kidclamp |
yeah, we are just missing that script listed in C4/Installer |
17:41 |
|
kidclamp |
I had, incorrectly, assumed we just grabbed anything in that dir |
17:41 |
|
|
kellym joined #koha |
17:46 |
|
|
inlibro joined #koha |
18:02 |
|
|
cait joined #koha |
18:47 |
|
|
inlibro joined #koha |
18:59 |
|
oleonard |
See y'all later |
19:09 |
|
|
lukeG joined #koha |
19:11 |
|
caroline_catlady |
corilynn: are you a cataloguing expert? |
19:11 |
|
corilynn |
ummm "expert" is a interesting word |
19:11 |
|
corilynn |
I know a lot of cataloging stuff |
19:12 |
|
caroline_catlady |
hehe! I was just wondering if you knew if there was a marc field to indicate that a serial is not published anymore |
19:12 |
|
caroline_catlady |
I've been looking in 3XX and 5XX and not finding anything |
19:12 |
|
corilynn |
i thought it was in the leader |
19:13 |
|
caroline_catlady |
so there is not free text field? |
19:13 |
|
corilynn |
there should be... but I haven't done serials since my internship |
19:14 |
|
caroline_catlady |
ok thanks, I'll keep looking |
19:17 |
|
corilynn |
weird, the documentation for 260 has stuff about the end date, but not 264 |
19:17 |
|
corilynn |
https://www.loc.gov/marc/bibliographic/bd260.html (search "For serials" under the $c subfield) |
19:19 |
|
caroline_catlady |
I think it's 362 from the examples I see in my RDA book |
19:19 |
|
corilynn |
yup, that looks right! |
19:20 |
|
corilynn |
"If the serial is complete, use subfield Ç‚a for the designation of the first issue followed by the designation of the last issue." |
19:20 |
|
corilynn |
so glad I don't do serials :) |
19:21 |
|
caroline_catlady |
The info I have to work with is only like "closed" or "some issues available on the Internet" |
19:21 |
|
caroline_catlady |
I guess I'll put them in 362$a and hope it's ok |
19:25 |
|
caroline_catlady |
thanks for your help! |
19:32 |
|
corilynn |
np |
19:33 |
|
corilynn |
I'm getting errors for "Stage MARC for import" can anyone point me to the directions for using the non-gui tool? |
19:34 |
|
caroline_catlady |
its misc/migration_tools/bulk_marc_import |
19:34 |
|
corilynn |
right, but are there, like, instructions? |
19:35 |
|
caroline_catlady |
oh, can you open the script? The parameters are kind of explained |
19:35 |
|
corilynn |
i'm looking for it |
19:36 |
|
|
lukeG1 joined #koha |
19:37 |
|
caroline_catlady |
do you want me to copy it for you? |
19:37 |
|
corilynn |
where should i look for misc? |
19:38 |
|
corilynn |
i can't find it in /etc/koha |
19:38 |
|
caroline_catlady |
uh, I don't think my structure is the same, but it's right at the root (where there's C4 and koha-tmpl, etc) |
19:40 |
|
caroline_catlady |
and the name is bulkmarcimport.pl (no underscore) |
19:41 |
|
corilynn |
AH! that made the find find it ;) |
19:41 |
|
corilynn |
thx |
19:42 |
|
caroline_catlady |
yeah, sorry! I always write bulk and then hit tab, so I didn't know the rest ;/ |
19:45 |
|
corilynn |
well, that seems to be working ;) |
19:45 |
|
corilynn |
thanks, caroline_catlady! |
19:47 |
|
|
inlibro joined #koha |
20:01 |
|
|
Templeton joined #koha |
20:04 |
|
Templeton |
Hello, I have recently started tracking Local Use in my library. I would like to pull a report from KOHA circulation about which books have been logged as "Local Use". I have already set the Global Preferences in the Administration to "Record" Local Use, but the reports I have tried to create via the "Guided Report" option have not resulted with the data I want, or the book that I just checked in via Local Use is not appearing. Could you please help me? |
20:05 |
|
caroline_catlady |
Hi Templeton! Could you copy the SQL query that the guided report gave you here http://paste.koha-community.org/ |
20:05 |
|
caroline_catlady |
I'll take a look |
20:06 |
|
Templeton |
Thank you! |
20:06 |
|
Templeton |
SELECT items.barcode,items.datelastseen,items.location FROM borrowers LEFT JOIN statistics on (statistics.borrowernumber=borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = statistics.itemnumber) LEFT JOIN biblioitems on (biblioitems.biblioitemnumber = items.biblioitemnumber) WHERE items.itype=<<itype|itemtypes>> AND statistics.type='localuse' |
20:07 |
|
Templeton |
I would like it to produce a spreadsheet of barcodes and call numbers that have been logged in Local Use. I'm not familiar enough with this system to do this. I appreciate your help! |
20:07 |
|
cait |
i think local use is recorded in statitics or action logs |
20:08 |
|
caroline_catlady |
yeah it's in statistics |
20:08 |
|
cait |
caroline_catlady++ |
20:08 |
|
caroline_catlady |
The guided reports make such messy queries... |
20:08 |
|
cait |
yeah i usually tend to start over |
20:09 |
|
rangi |
i would like to remove the guided reports bit entirely |
20:10 |
|
rangi |
and I wrote the horrible mess that it is |
20:10 |
|
rangi |
(under protest I might add) |
20:10 |
|
cait |
heh |
20:10 |
|
cait |
one issue is it adds more tables than you need, so usually a cleaned up one is faster on big db |
20:10 |
|
Templeton |
That's good to know. So, if I were to re-create this, which statistics column should I select? Would it fall under "Type of Procedure" or something else? |
20:12 |
|
pastebot |
"caroline_catlady" at 127.0.0.1 pasted "Templeton, can you try this?" (1 line) at http://paste.koha-community.org/3438 |
20:12 |
|
cait |
this one from the wiki looks interesting too https://wiki.koha-community.or[…]L_Reports_Library |
20:12 |
|
cait |
hm seearch for local use |
20:13 |
|
cait |
hm and some more here: https://wiki.koha-community.or[…]ulation#Local_Use |
20:13 |
|
Templeton |
Caroline_catlady - That worked! Thank you so much! What did you do? |
20:13 |
|
caroline_catlady |
I just cleaned it up a bit. It was using the borrowers table for an obscure reason |
20:14 |
|
caroline_catlady |
you only needed the statistics table and the items table for the barcode and callnumber info |
20:14 |
|
Templeton |
Oh, I see. That makes more sense. |
20:14 |
|
Templeton |
Thank you for all your help! Have a good day everyone! |
20:14 |
|
cait |
caroline_catlady++ again |
20:14 |
|
caroline_catlady |
glad it worked :) |
20:38 |
|
|
lukeG joined #koha |
20:43 |
|
|
khall joined #koha |
20:47 |
|
|
inlibro joined #koha |
21:03 |
|
|
alexbuckley joined #koha |
21:47 |
|
|
inlibro joined #koha |
21:59 |
|
|
lukeG1 joined #koha |
22:47 |
|
|
inlibro joined #koha |
22:53 |
|
caroline_catlady |
good night! |
23:02 |
|
|
papa joined #koha |
23:16 |
|
|
lukeG joined #koha |
23:48 |
|
|
inlibro joined #koha |
23:52 |
|
|
jzairo joined #koha |