►
From YouTube: System Administration Special Interest Group - 7/12/2022
Description
00:09:18 Jason (SEKLS): https://docs.google.com/document/d/1YqmOVW3BVZJKwECPPQY-l_DOh043Z9k7Q-VHh8YrWMU/edit?usp=sharing
00:11:21 Jason (SEKLS): https://wiki.koha-community.org/wiki/SQL_Reports_Circulation#Circulation_and_fine_rules_by_branch
00:28:28 Juliet Heltibridle: Whenever we get error 500, it is because there was no item type in the 942 field.
00:30:55 NEKLS Zoom 3 / George Williams: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30952
00:40:44 NEKLS Zoom 3 / George Williams: //Embiggen item search fields $('#catalog_itemsearch #itemsearchform select[multiple="multiple"]').attr('size', '50%');
00:42:05 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12733
00:46:28 Daniel: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18217
01:02:41 Jason (SEKLS): https://koha-us.org/events/conferences/kohacon22/
01:02:45 NEKLS Zoom 3 / George Williams: https://koha-us.org/events/conferences/kohacon22/
A
A
B
Yeah,
so
I've
been
auditing
our
circle,
fine
rules
and
found
that
there
weren't
any
good
reports
for
that
in
the
wiki.
They
were
all
referencing.
The
issuing
rules
table,
which
is
from
an
older
version.
It's
under
circulation
rules
now
and
I,
the
structure
of
the
table,
may
be
changed.
Anyways
I
put
together
a
report
which
I'm
using
to
sort
of
go
through
and
dedupe
my
rules
with,
so
I
thought
I
could
share
that.
B
I
will
put
the
link-
I
put
it
in
the
wiki,
so
I'll
put
the
link
in
the
agenda
moments
ago,
put
it
in
the
wiki
and
I
can
share
my
screen
and
show
what
it
looks
like,
and
I
would
love
to
know
if
other
people
have
better
ways
of
doing
this.
For
sure.
Where
did
you
put
it
in
the
wiki,
because
I'm
I'll
put
the
link
in
the
chat
too?
It's
all
confusing.
Now
yeah,
there
were
some
other
circle
reports
in
the
circulation
portion
of
the
reports.
B
This
one,
so
when
you
do
a
just
a
dump
of
the
strict
fine
rules,
this
is
what
it
looks
like,
which
is
super
helpful,
because
it
lists
out
every
rule
in
an
individual
row
and
my
goal
was
to
kind
of
go
through
and
figure
out
what
rules
are
duplicate.
So
this
doesn't
help
me
all
that
much
so
what
I
did
was
I
broke
down
each
of
those
categories
into
its
own
section.
B
So
basically,
what
this
rule
does
is
it
takes
the
circles
table
and
puts
it
in
a
report
as
is,
and
then
you
can
export
that
to
excel.
Do
some
concatenation
do
some
conditional,
formatting
and
then
and
see
what
the
duplicates
are.
So
if
I
run
this
report-
and
it
is
branch
limited,
but
I
can
run
it
for
all
branches
as
well,
then
you
can
see
it's.
B
B
Oh,
I
should
mention
I
excluded
in
that
report.
You
can
see
I
excluded
some
stuff
in
the
where
statement,
so
that
table
also
gives
you
the
information
on
holds
policies.
It
gives
like
there's
a
cirque
final
table
at
the
top
and
there's
stuff
below
it
on
the
page
and
all
of
that
stuff's
in
the
table.
So
I
excluded
that
so
I
could
just
get
the
table
at
the
top,
but
you
can
pull
additional
information
from
that
page
too.
C
C
Rules
are
separate
free,
you
know
every
library
has
their
own
rules
and
they
vary
wildly,
but
I
don't
give
anybody
the
ability
to
edit
or
modify
circulation
rules
because
not
because
I
don't
trust
them
well,
some
of
them.
I
don't
trust,
but
not
because
I
don't
trust
them
so
much
as
I
know
it
would
be
really
easy
for
somebody
to
go
in
there
and
accidentally
make
a
mistake,
and
I
know
that
that
will
happen
because
it's
happened
in
the
past.
C
A
A
B
B
Is
this
the
one
two?
Four
five?
Five?
Oh
book
renewals
trigger
item.
One
policies
revert
to
pr.
Oh
no!
I
this
was
a
recent
complaint
that
I
received.
So
in
the
past.
We
we
think
at
least
the
the
sorry.
This
is
sort
of
consortially
stuff.
I
guess
I
didn't
realize,
but
so
in
the
past
we
thought
that
if
a
patron
went
to
checked
out
at
one
library
and
renewed
another
library,
it
was
still
going
to
follow
the
rules
of
the
library
where
they
checked
out.
B
C
I
know
there's
system
preferences
involved
and
I
know
the
library
where
lizette
is
commenting
about
the
in
this
bug
about
how
it's
working
at
their
library
and
their
library
does
it
differently
than
the
way
we
do
so.
I'm
wondering
I
have
nobody
has
complained
to
me
about
this
problem
and
I'm
set
up.
I
think
the
same
way
you
are
jason,
where
the
cert,
where
the
rules
follow
the
library
where
the
item
was
initially
checked
out,
no
matter
where
it's
renewed.
B
Well
and
I
tested
it
and
it
does
seem
to
be
following
the
logged
in
staff
members
rules.
So
currently
we're
set
up
with
cert
control
is
at
the
library
you're
logged
in
at
but
homer
holding
branch
is
the
items
holding
library.
So
it
could
be
that
my
settings
aren't
correct,
but
those
are
big
sightings
to
change.
So
I
guess
I
can
do
some
testing
in
my
desk
server
and
figure
it
out.
B
C
B
I
think
I
flip-flopped
these.
I
think
that
was
the
renewal
behavior
one
that
I
was
talking
about
and
then
the
other
bug
that
I
put
down
is
one
that
we
have
talked
about
in
the
past,
but
it
doesn't
have
much
movement,
which
is
when
you're
renewing
from
the
patrons
account
and
there's
a
hold
on
the
item.
It
flashes
up
a
message
really
fast.
It
says
item
on
hold
and
there
are
new
fails,
but
then
the
message
goes
away.
So
if
staff
members
aren't
paying
attention,
then
they
don't
realize
that
the
renewal
fails.
B
B
D
D
D
F
F
C
C
That
was,
it
was
like
not
a
valid
mark
record
and
it
couldn't
be
deleted
because
of
some
field
in
the
mark-
and
I
don't
remember,
it's
happened,
it's
been
such
a
long
time
since
I
had
it
happen.
I
don't
remember
exactly
what
the
problem
was,
but
that
was
the
issue.
Is
there
was
something
in
the
mark
record.
F
I'm
at
marywood
university
in
pennsylvania,
I'm
still
kind
of
new
and
getting
my
feet
wet
and
trying
to
build
up
some
confidence
here
to
talk
when
you
everyone
here.
Most
people
who
are
speaking
seem
to
have
a
lot
more
experience
with
coho,
it's
only
my
third
month,
but
slowly
getting
more
confidence.
And
but
this
terror
has
been
a
problem.
So
I've
been
finally
got
me
to
say
something.
D
F
D
C
I
was
going
to
mention
I
a
couple
of
days
ago.
I
guess
it
was
on
the
8th
cab
vinton
mentioned
that
there
was
the
the
redesign
of
the
staff
interface
was
available
in
the
sandbox
on
one
of
the
bill,
libras
sandboxes
and
within
four
hours.
It
had
stopped
working
correctly,
but
I
was
wondering
if
anybody
else
had
a
chance
to
look
at
it
before
it
stopped
working.
A
A
C
A
A
Yeah
I'd
I'd
really
like
to
be
able
to
poke
around
and
you
know,
compare
it
to
current
functionality
and
and
all
that,
so
I'm
I'll
be
really
interested
when
they
get
something.
That's
you
know
stable
that
we
can
play
around
with
some
of
the
last
one
to
four
hours
yeah
like
maybe
I
was
in
there
and
you
were
in
there
and
we
broke
it.
D
D
B
C
My
experience
with
staff
is,
if
you
change
anything,
if
you
move
something
that
used
to
be
here
over
here,
they
will
scream
and
yell
and
and
rip
their
garments,
and
shout
at
god.
Why?
Why
why
and
then
you
go
back
like
a
week
later
and
say
and
ask
them
a
question
like
they
don't
even
remember
what
it
was
like
before.
So,
oh,
I
think
a
lot
of
cosmetic
changes
are
that
way.
They
they
don't
like
the
change
and
then
after
they
use
it
for
a
week
or
two.
C
C
B
I'll
say
that
I
both
love
and
hate
the
item
search,
it's
got
its
uses,
but
it's
the
usability,
isn't
the
most
fun
because
it's
got
little
boxes
and
then
you
have
to
scroll
down
in
the
little
box
to
find
your
categories,
but
it
does.
It
is
helpful
for
people
that
aren't
as
comfortable
with
reports
and
stuff
because
they
can
basically
pull
a
report
with
it
and
look.
George
fix
the
issue.
I
was
just
talking
about
yeah.
C
Here's
what
I
did
to
the
little
boxes-
they're
huge
boxes,
so
that
one
of
the
issues
I
was
having
was
that
it
seems
like
some
of
these
they
weren't
alphabetized
properly
at
some
point,
and
so
I
had
to
use
some
code
too
to
alphabetize
them,
but
but
yeah
I
wrote
something.
I
don't
remember.
I
think
I'm
sure
it's
I
don't
know
if
it's
css
or
jquery
that
I
wrote
to
change
the
boxes,
but
I
hated
that
too,
where
you
can
only
see
three
lines
in
the
box
at
once.
That's.
B
B
Oh,
the
other
thing
about
the
item.
Search
is
sometimes
it
just
like
hangs
up
and
I'm
always
afraid
that
I
am
on
the
path
to
crashing
my
server
because
it
will
just
get
stuck
processing
a
request.
So,
yes,
daniel,
I
am
a
little
worried
about
it
being
more
exposed,
but
I
guess
we'll
deal
with
that
when
we,
when
something
bad
happens,
we'll
react
and
not
proact.
C
It
used
to
be
like
that
with
the
logs,
but
now
they
time
out
after
a
while,
it
used
to
be
like
that
with
reports
too,
I
remember
somebody.
That's
why
I
took
away
people's
ability
to
write
their
own
reports
is
because
somebody
would
invariably
do
a
report.
That
said,
give
me
all
the
bibliographic
records
in
one
column,
all
the
all,
the
bib
ids
and
all
the
item
ids
in
this
column,
and
then
you
end
up
with
like
a
bazillion
in,
and
they
would
always
do
it
like
at
3
55
on
a
friday
afternoon.
E
C
E
G
B
So
I
have
used
it
on
occasion
like
I
have
an
issue
where
and
it
may
be
due
to
our
size,
because
I
think
it's
trying
to
compare
the
files,
I'm
uploading
to
the
catalog
at
large,
but
like
I
can't
upload
more
than
maybe
a
thousand
barcodes
at
a
time.
Otherwise
it
times
out
and
hits
a
proxy
error
which
is
really
frustrating
because
then
it
kind
of
invalidates
the
the
whole
like.
D
When
we
did
our
inventory,
like
a
couple
of
years
ago,
we
tried
using
that
tool
and
it
just
it
would
it
would
do
exactly
what
you
said.
I
could
only
run
like
a
thousand,
so
I
didn't
do
that
so
much.
I
used
like
the
batch
item,
modify
and
put
a
note,
non-public
node
in
there
inventory
and
then
read
a
report
where
it
would
grab
items
that
didn't
have
that
and
that's
what
I'd
set
to
missing
and
that's
how
we
kind
of
did
it.
D
B
Yeah,
I'm
it's
still.
I
I
still
am
a
proponent
for
the
inventory
module
because
it
does
do
things
well
when
it
can,
when
it
can
work
right.
So
it
does
like
basically
check
everything,
and
it
does
give
me
a
list
of
things
that
were
on
the
shelf
that
we
scanned
that
aren't
in
the
catalog,
and
I
can't
run
a
report
later
on,
since
it
checks
everything
in
based
on
the
date.
E
A
I
don't
remember
if
it
was
this
meeting
or
what
meaning
it
was,
but
at
one
point
we
were
discussing
it
was
when
lizette
was
still
here.
We
were
discussing
an
interactive
inventory
tool
and
there
is
a
bug
for
that
and
I
I
don't
remember
much
about
the
discussion,
but
as
I
look
through
it
now,
I
see
somebody's
talking
about
a
scan
as
you
go
shelf.
Reading
an
inventory
plug-in
might
be
something
interesting
to
see
what
that
is.
C
B
Yeah
it
does
sound
like
it
would
be
value-added,
because
another
thing
that
we
have,
we
can't
really
do
it
with
the
call
inventory
tool
is
out
of
order
and
there's
like
a
check
box
for
out
of
order
reporting.
But
again,
if
I
can't
upload
more
than
a
thousand
there's
no
way,
I
can
give
me
accurate
results.
C
I'm
thinking
I
can't
find
anything
about
alphabetizing
them,
so
I
think
that
might
have
been
something
that
got
fixed,
because
I
think
there
was
some
point
where
the
the
collection
codes
and
the
item
types
weren't
necessarily
alphabetized
properly.
They
were.
I
think
they
were
alphabetical
by
the
code,
not
the
description,
something
like
that
for
some
reason:
another
they
weren't
alphabetical.
C
A
C
D
D
So
yeah
I
just
plugged
that
bug
that
was
18
21
7
and
it's
gonna.
It's
asking
to
combine
that
information
with
the
rest
of
the
contact
information
and
I
think
it's
going
to
be
really
useful
or
the
the
getting
this
bug
fixed
is
going
to
be
really
useful
in
the
future
because
of
this
new
feature.
So
please
comment
on
it,
so
we
can
get
some
work
done
on
it.
Thanks.
A
C
For
us,
it
just
means
I
need
to
get
rid
of
that.
We
have
we've
been
using
for
years,
we've
had
an
all
patron,
extended
attribute
that
says,
hold
contact
method
and
so
and
it's
and
it's
based
on
an
authorized
value,
so
you
can
put
whatever
you
want
in
there,
but
this
new
drop
down
is
just
gonna
have
to
be
removed
because
it
serves
no
purpose
without
having
the
sms
stuff
in
there.
So.
D
A
B
Oh,
I
guess
I
can
follow
up
last
week.
I
think
at
circ
I
was
talking
about
my
google
analytics
breaking.
I
did
figure
out
how
to
use
the
the
new
ga4
property.
It
was
really
simple
there.
I
think
I
found
a
a
tutorial
online,
but
basically
they
give
you
a
little
snippet
of
code
and
you
just
put
that
in
a
footer
element
in
in
your
opac
and
that
enables
google
analytics
before
it
was
a
little
snippet
of
code
that
you
put
in
your
jquery.
B
B
B
The
code
is
just
a
script,
that's
down
there
so,
and
this
is
pulled
out
of
the
setup
information
here
somewhere,
it's
been
less
than
a
week,
and
I
still
I
don't
remember
how
to
manage
this.
It's
here
so
like
your
old
one,
has
a
little
ga4
setup
assistant
and
when
you
transition
it
over
through
that,
then
it
gives
you
that
snippet
of
code
and
sticking
that,
just
at
the
bottom
of
every
page
on
your
opacl,
generate
your
your
tags,
which
feed
the
data.
A
B
Yeah,
I
I
do
find
it
useful
and
I
I
was
never
sure
if
mine
was
set
up
right
either,
but
it
does
like
feed
information.
I
can
see
the
real
time
stats
and
I
can
see
like
it's
especially
useful,
to
see
how
people
are
interacting
with
your
opac
so
like
it
tells
you
what
they're
using
it
most
for
so
like
you
can
see
that
they're
placing
holds
or-
and
you
can
also
see
their
devices.
So
you
can
see,
I
think,
for
us.
B
And
it's
I
had
to
sort
of
sell
it
in
the
beginning,
because
people
were
scared
that
it
was
kind
of
like
it
was
big
brothery
and
we
were
collecting
private
information.
But
it's
really
it's
all
non-identifiable.
As
far
as
I
can
tell,
I
mean
we're,
not
storing
anything
that
would
get
us
in
trouble.
As
far
as
I
know,
I
see
sally
has
their
hand
raised.
H
I
just
wanted
to
say
hello
and
introduce
myself
I'm
with
the
knox
county,
public
library,
and
we
are
just
starting
our
migration
after
30
years
on
symphony
we're
working
with
bywater,
so
I've
been
kind
of
lurking
around
and
watching
videos
all
you
folks
have
done,
and
I
really
appreciate
all
the
work
you
folks
put
into
this
to
make
it
easier
and
a
mature
product
that
we
can
all
try
to
use
so
hello,
hello
and
welcome.
Thank
you.
H
H
H
But
the
last
cersei
dynasty
conferences,
I
was
able
to
go
to
the
ones
in
nashville
and
then
they
moved
them
out
of
state,
and
that
was
it
for
me,
but
anyway
we're
leaving
cersei
dynax
we've
been
on
symphony,
be
long
before
it
was
symphony.
It's
been
30
years,
so
this
is
a
pretty
pretty
substantial
move
for
us
we're
already
using
aspen.
We
migrated
to
aspen
march,
so
we're
kind
of
doing
it
backwards.
H
Aspen
first,
but
it's
working
and
it's
great
people
are
really
happy
with
it.
So
I
think,
having
successfully
moved
to
aspen
has
put
people
to
working
with
bioware
just
kind
of
put
people
at
ease
a
little
more
because
they
know
things
went
fine
there
and
people
like
the
new
product.
So
this
move
to
coha,
which
is
gonna,
be
a
shock
to
some
folks
in
systems,
but
we're
right
right.
It's
time
for
something
new.
E
C
H
Cersei
and
we
had
unicorn,
and
I
think
my
predecessor,
it
was
1991
and
my
predecessor
launched
it
on.
I
think
unicorn
five
and
I'm
told
that
we
were
the
first
multi-library
system
to
use
uniform.
We
have
19
buildings
so
anyway,
that's
us
hello,
nice
to
meet.
You
all
welcome
great
you're
here.
Well,.
B
D
H
H
Yeah,
we're
there's
only
one
thing
right
now
where
and
it
has
to
do
with
lita
and
how
that
honors,
some
of
the
choices
we're
making
we've
made
but
other
than
that,
we're
because
we're
we're
not
doing
the
account
linking
and
lita
does
whether
we
want
to
do
it
or
not.
So
it's
a
little
problem,
but
that's
okay.
We.
H
Right
we're
just
I
mean
we,
we
have
it,
I
mean
it's
available,
but
we
are
not
advertising
it
to
the
customers
yet.
So
we're
we're
waiting
a
little
bit
on
that,
not
that
some
of
them
haven't
found
it
already.
We
know
some
folks
are
already
using
it.
The
more
curious
ones
who
know
how
to
look
around
for
these
things.
H
C
When
I
started
doing
this,
which
has
been
about
well,
it's
been
10
years
now
with
koha
wow.
That's
that's
a
long
time
people,
oh
people,
would
say
to
me.
Oh
you're,
so
good
at
this
you're.
So
smart
you.
So
you
know
what
you're
doing
and
I
just
kept
saying
it's
like.
I
don't
know
what
I'm
doing
I
just
whenever
I
come
to
a
brick
wall.
Whenever
I
don't
know
what
I'm
doing
and
I
come
to
that
brick
wall,
I
just
bang
my
head
on
it
until
I
knock
it
over.
E
D
H
B
D
H
C
H
C
H
C
H
We're
trying
to
work
out
a
contract
with
patronpoint
and
use
their
services,
including
for
the
sms
messaging.
We
couldn't
afford
the
address
validation
add-on.
That
would
have
been
great,
but
we're
doing
we're
gonna
use
them
for
our
messaging
and
we
have
a
whole
communications
department.
Who's
excited
about
setting
up
a
whole
messaging
marketing
campaign
using
those
tools.
C
A
A
You
can
go
to
the
koa
us
website
and
find
the
conference
and
the
registration
form
and
the
schedule
and
all
of
that
register
if
you're,
whether
you're
coming
in
person
or
not
be
sure
to
register
and
also
you
can
join
quahog
us
and
be
a
member
for
only.
I
think,
we're
we're
at
the
half
year
mark
now.
So
you
get
half
price
membership.
It's
only
12.50
for
now
through
the
end
of
the
year.
So
that's
another
thing
you
can
do
to
support
kohai
us.