►
From YouTube: System Administration Special Interest Group - 5/10/2022
Description
00:09:54 Lisette: https://docs.google.com/document/d/18_-ptFDr8TO_GcR8iMWNjEkERWO-3CTxeX04tu2loNE/edit
00:12:46 George - laptop: If you run this what's the result look like?
00:13:13 George - laptop: Sorry I'm late to the party
00:22:32 Jason (SEKLS): https://www.seknfind.org/cgi-bin/koha/opac-course-details.pl?course_id=1
00:24:01 Jason (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12141
00:35:35 Lisette: LEFT JOIN action_logs a ON a.object = b.borrowernumber AND a.module='MEMBERS' AND ((a.info LIKE CONCAT('%', '"before" : "SELFREG"', '%')) OR ((a.info NOT LIKE CONCAT('%', '"before" : "SELFREG"', '%')) AND (a.action LIKE "creat%") AND (b.categorycode!="SELFREG") AND (a.interface="intranet")))
00:41:50 Jason (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26440
00:43:10 bjohnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30647
00:48:18 Jason (SEKLS): https://koha-us.org/events/conferences/kohacon22/
00:48:33 Kristen Martinez: Will Koha con be a hybrid event?
00:49:00 Kristen Martinez: Thank you! :)
A
A
I
have
a
thing
which
is
that
I
started
I
built
a
little
dashboard
for
our
monthly
statistics
so
that,
instead
of
running,
like
12
monthly
statistics
reports,
we
can
run
one
well.
It
only
does
part
of
it
right
now,
because
I'm
still
working
on
it,
but
and
it's
kind
of
a
big
report
because
of
the
way
that
we
set
it
up.
A
A
A
It's
it's
running
right
now,
it's
it
takes
a
couple
minutes
to
run.
It
looks
so
small.
This
is
what
it
looks
like.
Oh
in
the
chat
george
asked.
What's,
if
I
run
it,
what
does
the
result?
Look
like,
and
some
of
the
sections
are
a
lot
smaller.
You
know
like
this
is
each
branch
just
how
many
checkouts
total
or
no?
This
is
the
stuff
that
we
get
from
the
rest
of
the
consortium.
A
A
A
If
we
had
it
in
like
a
excel
sheet,
we
could
just
copy
these
three
rows
and
then
paste
them
into
these
three
rows
without
formatting,
and
that
would
work
really
nicely
so
like
it's
a
pretty
simple
little
report,
but
it's
better
than
running
one.
Two,
three
four
five
six
reports
and
the
ones
that
we
get
automatically
emailed
right
now
have
like
a
day
by
day.
A
A
Space,
so
we
are
doing
it
like
a
little
bit
at
a
time,
so
we
can't
just
like
get
everything
in
transit
and
have
it
fix
itself
right
away.
So
we
have
a
report.
That'll
pull
all
the
things
that
should
be
on
that
report,
but
then
it's
also
picking
up
things
like
that
are
waiting
on
hold
for
patrons
and
stuff,
like
that.
So
I've
been
working
with
my
water
to
get
some
of
that
stuff,
fixed.
C
I
was
just
looking
through
my
most
recent
reports-
one
that's
not
exciting,
but
sort
of
exciting
that
I've
been
working
on
and
I
nick
basically
sent
it
to
me
and
I
tweaked
it.
So
we
use
novelist,
select
and
library,
aware
and
I've
been
sending
isbn
updates
every
month
forever,
because
that's
how
we
update-
and
so
I
started
poking
at
ebsco
out
there
on
the
on
the
shelf
service,
which
can
like
link
up
using
apis,
and
I
asked
nick
about
it.
C
The
api
can't
show
availability
yet,
but
we
can
show
that
all
with
reports.
So
I
sent
the
public
report
to
the
obstacle
people
and
they
seemed
pretty
excited
that
what
they
could
pull
with
it.
So
their
work
they've
added
that
to
their
development
queue,
and
hopefully
we
can
get
that
working
so
that
we
don't
have
to.
B
C
C
If
you're
interested
like
I
said
this
is
the
the
feed
testing,
so
it
sends
them
the
isbn,
the
the
link
in
the
opac
item
type
how
many
are
owned
and
how
they
are
available.
So
it's
fairly
simple,
but
it
gets
the
information
that
they
need
for
that
and
then
the
on
displays
report
is
this
one,
and
what
we're
our
primary
use
case
at
the
moment
is
new
shelves,
so
we're
using
the
the
course
resource
module
to
track
what's
new
within
a
display.
C
So
like
I've
got
it
everything
relabeled
here
and
then
we've
got
different
displays
and
there's
probably
nothing.
There's
some
test
items
in
here,
but
one
of
the
things
we
wanted
I
wanted
to
do
is
have
a
report
that
you
could
keep
track
of
how
long
things
have
been
on
the
new
shelf
so
that
we
can
run
it
to
figure
out
when
he's
pulled
off.
So
I've
linked
up
that
report
here
and
then
it's
just
a
simple
like
things
that
have
been
on
display
more
than
how
many
days.
C
D
A
C
We're
in
the
testing
phase,
so
I've
got
two
libraries
playing
with
it
right
now
and
then
we're
gonna
test
it
here
on
site
starting
next
week,
and
then
we've
got
a
big
use
case
here.
So
I
I
think
I've
got
it
all
fleshed
out,
there's
still
a
few
places
where
it
says
course
reserves.
Instead
of
displays
that
I
I
can't
really
fix.
C
I
did
find
a
way
to
change
the
url
slugs,
but
I
didn't
think
it
was
worth
it
so
because
I
thought
I
was
breaking
other
things,
but
it
would
be
nice
if
that
could
be
its
own
thing
in
co-op,
so
we
don't
have
to
adapt
the
course
resource
module
and
I
know
there's
a
ticket
out
on
that,
I'm
hoping
to
once
we
get
it
like
fleshed
out.
I
can
share
what
I've
done
on
the
ticket
as
an
example
of
how
it
could
work
if
it
could
be
added
to
the
code.
C
C
B
C
E
D
So
that
would
be
a
good
one.
I'm
I'm
at
home
today.
So
I
don't
have.
This
is
my
vacation.
This
is
how
I
spend
my
vacations
hanging
out
with
you
guys.
So
I
don't
have
a
lot
of
my
notes.
So
I
don't
know
what
the
bug
number
is,
but
there
is
a
bug
that
says:
could
there
be
could
course
reserves
be
duplicated
to
create
a
display,
a
real
displays
module
instead
of
just
messing
with
this
and
jason
put
the
bug
in
the
chat
there.
A
A
D
A
D
D
What
is
it
the
transfers
to
receive
on
circulation
only
shows
the
transfers
that
are
coming
to
your
library,
and
I
have
a
report
that
will
show
not
only
the
things
that
have
been
in
transit
to
your
library
for
a
long
time,
but
the
things
that
you've
shipped
to
other
libraries
have
been
in
transit
for
a
long
time
and
the
things
that
are
owned
by
your
library
that
have
been
in
transit
for
a
long
time.
So
let
me
I've
dug
that
up
and
then
I
opened
bugzilla
and
I
think
I
lost
it.
B
D
Doing
a
report
for
things
in
transit
to
you
and
then
unioning
that
with
the
report
for
what
you
own
and
then
you
needing
it
with
another
one.
So
when
you
run
it
and
I've
got
it
set
up.
So
when
you
run
it,
you
only
have
to
enter
the
library
that
you're
at
so
if
we
go
to
leavenworth
we'll
most
likely
have
some,
and
I
also
have
some.
D
D
The
first
part
of
the
sort
will
be
carbondale
horton,
so
it
that
doesn't
make
for
a
good
shelf
list,
because
if
you're
going
around
the
library,
you're
you're
you're
not
getting
things
in
call
number
order,
you're
getting
them
in
library
order
first,
and
so
there
are
12.
I
they're
only
12
items
that
are
missing
in
transit
between
well.
I
thought
I
picked
leavenworth,
but.
D
Doing
things
currently
at
knuckles
or
in
transit,
to
send
from
knuckles
to
someplace
else,
so
I
must
have
grabbed
the
wrong
the
wrong
branch,
but
this
is
showing
the
things
you
know.
This
was
sent
from
paola
two
knuckles
and
the
rest
of
these
were
sent
from
knuckles
and
there's
a
transfer
reason
over
here
return
to
home
and
some
of
them
are
old
enough.
D
D
D
D
So
this
way
when,
if
I
were,
if
I
wanted
to
contact
carbondale,
I
would
I
could
click
on
mail
to,
and
I
could
send
this
to
carbondale
and
say
this
item
was
shipped.
An
item
owned
by
carbondale
was
shipped
from
knuckles
to
carbondale
on
this
date
and
has
not
yet
arrived,
and
then
it
plugs
in
all
the
information
about
that
item.
So.
A
D
F
I
actually
had
a
question
about
not
necessarily
a
report,
but
the
reserves
database
schema
and
specifically
the
found
codes.
I
know
that
there's
like
f
for
found
and
w
for
waiting,
but
I
was
wondering
about
the
f.
Is
that
for
the
item
is
waiting
on
the
hold
shelf,
or
is
it
just
that
the
item
has
been
trapped
and
can
be
transferred
or
still
making
its
way
to
the
hotel?
Does
anybody
know.
A
A
A
A
F
B
F
D
A
A
A
A
To
grab
the
patrons
that
aren't
create
that
were
like
changed
from
self-registered
patrons,
and
we
use
this
to
like
check
for
duplicates
and
make
sure
all
the
information
we
need
is
filled
out
and
that
kind
of
stuff,
because
we
don't
have
paper
applications
anymore.
So
cert
goes
through
and
does
that
like
once
a
week
so.
A
C
D
You're
taking
care
of
that
here's,
the
question
I
have
that
that
was
that
just
triggered
in
me
is
how
many
consortiums
or
how
many
of
you
have
like
a
group
wide
application
process.
The
process
is
same
the
same
across
more
than
one
library.
I
guess
that'd
be
more
of
a
question
for
the
consortium
group,
but.
A
D
Yeah,
that's
that's
what
ours
is
when
christopher
brand-
and
I
were
talking
and
one
of
the
videos
we
did
recently.
They
actually
spent
a
long
time
moving
away
from
paper
registration
forms,
and
now
the
city
there
in
coeur
d'alene
wants
them
to
move
back
to
a
paper
registration
form
because,
with
all
of
these
issues
about
people
challenging
books
and
saying
my
kids
shouldn't
be
allowed
to
read
those
books,
they
want.
The
city
wants
documentation
to
cover
themselves,
so
they're
having
people
sign
a
form
that
says
you
know.
I
understand
that
my
child.
D
You
know,
I
understand
that
you
know
the
what
what
I
check
out
is
my
responsibility
and
then
signing
the
form
and
then
they're
filing
that,
so
that
when
somebody
tries
to
say
you
know
how
how
come
my
child
checked
out
this
book
or
how
come
you're,
allowing
people
to
check
this
out
they've
got
a
document
that
people
would
sign
that
says
you
know.
I
understand
that
what
I
check
out
is
my
own
damn
business.
D
C
We
do
have
a
fairly
standardized
card
format
and,
on
the
back
of
the
card,
there's
like
a
little
basically
a
little
contract
that
they
sign
so
that
that
is
a
consistent
thing
for
most
of
my
libraries
there's
a
few
libraries
that
have
gone
out
and
gotten
their
own
cards,
but
we
do
have
that.
I
guess
that
might
be
a
way
to
cover
it
but
yeah
as
far
as
how
they
do
it.
They
all
do
it
their
own
way.
C
D
Okay,
I
was
just
curious
and
lizet's.
We
don't
do
paper.
Forms
thing
is
what
triggered
me
and
because
I
know
they
don't
do
paper
forms,
but
I
know
every
other
library
out.
There
has
a
different
process
and
every
other
library
here
has
a
different
process
and
a
different
form,
and
some
of
them
do
paper
forms
some
of
them.
Have
the
library
that
I
have
that
fought
the
hardest
against
the
built-in
cohort
self-registration
now
has
their
own
self-registration
sheet
in
a
google
form,
because
that's
better
than
what
we
were
doing
before.
C
C
Find
it
because
I
had
somebody
complain
about
it
yesterday
and
we've
talked
about
this
in
the
past.
So,
okay,
one
of
the
issues
that
we're
running
into
is
when
you
go
to
renew
an
item.
That's
on
hold
it'll
flash
up
really
quickly
that
it's
on
hold
and
the
renewal
has
failed,
but
then
it
reverts
back
to
it
like
it's
really
hard
to
see
that
messaging
and
somewhere
along
the
way
it
changed
so
like
before
it
would
show
on
hold
in
that
column
and
prevent
the
renault
renewal
entirely.
C
C
B
But
I
can
never
remember
what
that
string
is
that
I'm
supposed
to
put
in
there,
so
this
was
just
a
thought
of
in
the
preferences
to
make
a
note
on
the
preference
that
this
is
what
you
use.
If
you
wanted
to
do
that,
so
that
you
didn't
have
to
sit
there
and
think
well,
I
would
do
that,
but
I'd
have
to
spend
10
minutes
trying
to
figure
out
what
that
string
is
I'm
supposed
to
put
on
there.
So
it's
just
like
an
informational
thing
to
indicate
you.
C
C
C
C
I
know
that
there
was
a
pretty
hefty
development
on
the
bywater
dev
site
that
has
largely
been
put
to
the
side,
mostly
because
aspen
has
been
filling
that
need
for
fertilization,
but
the
we're
not
an
aspen
location.
So
that's
something
that
we'd
love
to
see
added
to
koha.
So
if
that's
something
that
interests
you
I'm
sure
he
would
take
more
eyes
on
that.
So
I
told
him
I
would
throw
that
out
here
and
everywhere
that
I
I
go
because
I'm
really
excited
about
the
idea
for
us.
C
C
So
we
we
don't
have
to
worry
about
having
the
different
formats
on
separate
records,
because
the
holds
could
conglomerate
back
together
and
the
patron
could
have
a
choice
on
what
format
they
get
or
just
say.
I
want
any
kind
and
get
whatever
they
can
get
fastest,
so
I'm
excited
that
that
might
be
in
the
pipeline
again
and
if
it's
something
that
you're
interested
in,
like
I
said,
I'm
sure
sam
would
love
your
support
as
well.
C
C
B
B
E
E
C
C
Sorry
rob
jason
go
for
it.
Oh,
I
was
just
gonna
answer,
kristen's
question
that
the
call
cons
are
always
hybrid,
so
we
will
have
a
an
online
component.
We'll
probably
do
it
like
we
have
in
the
past
with
the
us
conferences
where
we're
live
streaming,
the
event
to
youtube.
So
you
can
participate
and
watch
the
presentations
and
such
okay
daniel
go
ahead.
F
Sorry
about
that
last
to
search
is,
are
people
using
that
now?
Last
time
I
was
looking
into
it,
they
were
bywater
was
saying
that
it's
not
quite
there,
and
I
think
it
was
like
last
year
and
I'm
wondering
if
it
has
improved
at
all
in
the
last,
like
six
to
nine
months
since
I
started
I
looked
at
this.
C
So
we
do
we
switched
late
last
year.
I
think,
and
it's
definitely
we're
consortium
star
catalogs
big
zebra
was
getting
really
slow,
so
it's
definitely
sped
up
our
searches.
I
think
the
only
the
only
issue
we've
really
run
into
is
the
fact
that
fuzzy
isn't
built
in
anymore,
so
you
do
have
to
like
append
a
little
tilde
at
the
end
of
terms.
If
you
want
to
do
a
little
sort
of
spell
checking,
so
sometimes
our
results
are
less.
C
B
We've
been
on
it
for
several
years.
I
think
we
were
an
early
adopter
and
it
has
improved.
It's
not
perfect.
So,
even
when
I
search
for
a
title-
and
I
think
it
ought
to
be-
you
know
the
top
hit
based
on
what's
in
the
title.
Maybe
it
doesn't
always
work
that
way,
but
it
will
be
further
up
in
the
list
of
results
than
it
was
with
zebra,
and
it
also
seems
like
the
the
different
formats
of
a
title
you
might
have
seem
to
be.
B
C
Yeah,
I
remember
one
of
our
several
searches
was
always
harry
potter
and
the
sorcerer's
stone
and
before
we
would
without
fail,
get
like
the
vhs
in
the
top
three
results
so
and
now
we're
getting
books
and
the
top
results,
which
is
what
we
wanted
to
see.
So
I
think
that
some
things
are
most
things
are
better.
Some
things
are
worse,
but
I
think
overall,
it
was
an
improvement
for
us.
F
Yeah
actually
might
start
looking
into
that
again,
but
our
trouble
with
zebra
came
down
to
when
you
were
searching
for
the
book
it
and
that
just
came
gave
us
all
kinds
of
weird
results.
But
if
it
can
do
that
better,
then
it
might
actually
be
worth
worth
looking
into.
Although
the
spelling
thing
is
kind
of.
C
Yeah,
the
the
lack
of
fuzzy
was
something
that
we
had
to
get
used
to.
We
trained
on
the
different
keywords
and
things
that
you
can
use
and
encourage.
We
put
that
in
our
patreon
brochure.
We
put
it
in
our
staff
training,
so
I
haven't
had
any
angry
people.
I
guess
the
the
the
worst
part
is
like
every
once
in
a
while,
we'll
get
maybe
a
request
in
to
go
to
our
statewide
system,
because
they
can't
find
it
in
the
current
catalog.
C
C
B
One
other
thing
we
have
noticed
too,
is,
like
I
say:
we've
been
having
we've
had
it
running
for
a
couple
years.
I
think,
and
then
staff
will
start
complaining
about.
You
know
searching
not
being
you
know
what
they,
how
they
think
it
should
be,
and
then
I'll
go
in
and
check
our
settings
and
we've
lost
our
rankings,
and
I
don't
know
why
I
don't
know
if
it
happened
during
an
upgrade,
I'm
not
sure,
but
I've
had
that
happen.
B
C
C
C
C
I'll
give
I'll
put
that
on
for
with
that
to
look
into
all
right,
I'm
not
seeing
any
other
discussion.
So
let
me
just
double
check
the
next.
This
admin
meeting
is
going
to
be
happening
on
tuesday
june
14th.
At
the
same
time,
like
I
said,
maybe
we'll
dig
into
the
upgrade
a
little
bit
and,
of
course,
we'll
probably
have
the
usual
slate
of
topics
or
reports
bugs
anything
else.
Cool
you're
doing
so
feel
free
to
bring
that
next
month.
So
thanks
everybody
for
coming.