►
From YouTube: System Administration Special Interest Group - 7/11/2023
Description
00:28:04 Christopher Brannon: There's a lot to choo choo on
00:28:09 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30708
00:29:36 Jason - SEKLS: https://wiki.koha-community.org/wiki/SQL_Reports_Patrons#Patron_branchcode_change_counts_in_a_date_range
00:30:42 Andrew Fuerste-Henry: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25159
00:33:01 Christopher Brannon: no
00:33:16 Christopher Brannon: okay, yes
00:39:40 Andrew Fuerste-Henry: SELECT title, subtitle,itemnumber, itemtype, sum(if(type='issue',1,0)), sum(if(type='localuse',1,0))FROM statistics left join items using (itemnumber) left join biblio using (biblionumber)GROUP BY itemnumber
00:43:20 Andrew Fuerste-Henry: https://www.w3schools.com/sql/func_mysql_round.asp
00:44:54 Christopher Brannon: CONCAT("$",FORMAT(a.amountoutstanding,2)) AS owes
00:47:19 Juliet Heltibridle: FORMAT(ABS(o.amount), 2) as "Amount Collected",
00:47:54 Fred King: Does your library have a photo of what's available?
01:00:47 Juliet Heltibridle: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34149
01:02:50 Juliet Heltibridle: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28307
A
Okay,
now
having
caught
up
good
morning,
everybody
Welcome
to
the
koha
US
assistance,
Administration
special
interest
group,
where
we
talk
about
systems
Administration
in
koha
and
stuff.
We,
complain
about
system
preferences
and
change
them
and
see
what
happens,
break
people's
systems
and
then
write
reports
to
find
out
how
to
fix
what
we've
done.
B
C
I
tried
to
do
elasticsearch
7
because,
supposedly
and
install
it
I
I
probably
need
to
go
back
and
try
it
again,
because
clearly,
I
did
something
horribly
wrong
and
I
fell
back
to
six,
but
but
I
am
stuck
on
is
when
I
try
to
rebuild
the
catalog.
It
says:
use
of
an
initialized
value
and
string
EQ
at
slash
user,
slash,
there's,
COA,
slash,
bins,
search,
underscore
tools,
rebuild
underscore
elasticsearch
PL
in
line
349.
B
C
B
C
C
Yeah,
my
other
one
is
an
update
of
when
I
did
it
in
2016
about
the
MedStar
authors.
Catalog
right
took
all
sorts
of
catalogs
or
actually
Medline
citations
and
turned
them
into
Mark
records
and
elasticsearch
is
making
it
a
lot
easier
and
I
can
present
a
lot
more
information.
Oh
yeah
I
have
to
do
an
elasticsearch
for
that
too.
A
A
C
It
says
working
working
on
the
batch
job.
Eventually,
it
will
give
me
a
screen
thing:
yeah.
It
worked,
I'd
really
like
it
to
go
back
to
manage
staged
records,
so
I
could
start
adding
items,
but
it
goes
to.
The
only
option
is
to
go
to
look
at
batch
jobs
get
administration,
so
I
have
to
go
back
to
the
main
screen
and
to
cataloging
it's
not
a
major
annoyance,
but
it's
something
it's
a
minor
one.
I
feel
like
that
got
a
little
better,
though,
because.
A
I
absolutely
ran
into
that
same
thing,
got
all
snitty
about
the
added
screens
and
like
filed
a
bug,
and
then
it
and
I
don't
remember
if
it
changed
shortly
thereafter
or
if
someone
like
pointed
out
that
I
was
being
over
listening,
I
think
I
might
have
gotten
a
nice
message
from
Katrin
telling
me
to
calm
down.
Let
me
see.
A
A
A
C
B
C
C
B
B
B
D
B
D
D
A
Here's
a
bug,
31891
show
Mark
staging
result.
Okay,
that's
that's
for
the
that's!
The
bug
I
filed
to
show
that,
like
summary,
of
how
many
records
we're
in
and
how
they
all
started
out,
that
got
back
ported
return
to
manage
Mark
import
after
importing
batch
31892
was
resolved
as
a
duplicate.
I
followed
this
goofy
chain.
Okay,
let
me
give
you
a
visual
aid
as
I
click
through
bugzilla.
If
I
could
figure
out
how
to
let
Zoom
make
me
do
that.
Okay,.
A
C
C
E
E
So
I
just
sent
something
to
Nick
yesterday
with
a
detailed
screenshots
I'm
having
issues
with
the
same
thing.
It's
like.
Where
do
I
go
it's
counterintuitive,
so
I
don't
know.
If
he's
responded
to
me
yet
and
I'm
happy
to
say
I
guess
you
know
all
the
clicks,
because
it's
leading
me
like
down
rabbit
hole.
It's
like
I,
don't
want
to
be
on
this
screen
and
then
I
can't
get
back
to
where
I
need
to
be
so.
It's
frustrating.
A
Well
and
Christy
I,
don't
know
if
you
saw
Fred
walked
us
through
what
that
process
looks
like
on
his
screen.
Well,
Jason
was
doing
it
on
his
system,
and
Jason
has
a
helpful
link
that
Fred
doesn't
have
to
get
sort
of
back
on
the
path
that
one
desires.
So
we've
got
some
code
inconsistency
with
an
unknown
source.
Oh.
E
E
D
B
E
E
A
C
A
E
A
My
informal
sense
is
that
that's
getting
less
true,
as
there
are
more
larger
libraries
using
cohabit,
don't
have
the
option
to
just
not
use
Acquisitions
for
so
long.
The
sort
of
like
meat
and
potatoes
koha
library
was
a
like
small
Public
Library
that
could
totally
do
Acquisitions
in
Excel
if
they
felt
like
it
and
I,
think
that's
less
and
less
the
case
anymore.
There
are
more
people
who,
like
really
beat
that
acquisition
module
to
work.
A
A
A
As
a
weird
tangent
off
of
that
last
week,
I
was
reading,
bug
and
bugzilla
that
is
currently
underway
to
add
a
preservation
module
to
koha.
This
is
being
coded
by
I
think
it
was
biblib
over
in
France.
It's
basically
seems
sort
of
parallel
to
Acquisitions,
but
it's
to
track
when
items
like
go
out
for
a
repair
or
a
rebinding
or
something
sort
of
more
of
a
process.
For
that
take
a
group
of
items
and
group
them
together
into
a
something
like
a
basket.
So
you
can
say
this.
A
A
If
any
of
you
all
think
that
might
be
a
module
you'd
be
interested
to
use,
I
would
encourage
you
to
find
this
bug
and
give
it
a
read
and
talk
to
them
about
the
terminology.
They've
translated
from
the
French,
currently
that
group
of
items
that
goes
off
somewhere
in
comes
back
is
called
a
train
like
which
is
cute.
A
A
I
spend
a
lot
of
time
coming
in
here
and
checking
on
bugs
reported
or
changed
in
the
last
24
hours.
It's
a
fun
way
to
start
your
morning,
see
what's
going
on
in
bugzilla.
What
crazy
things
are?
People
getting
up
to
and
I
don't
read
all
of
these
by
any
stretch,
but
it
can
be
fun
to
scroll
through
it
see,
what's
moving
and
find
the
interesting
preservation
module
that
people
in
France
are
writing
that
you
never
would
have
known
about
otherwise.
D
We
had
one
of
my
libraries
recently
started
up
with
Libby
and
they
wanted
to
see
how
many,
like
patrons
from
other
libraries,
we're
switching
home
Branch
so
that
they
could
use
Libby,
because
only
this
branch
has
it
so
I
use
the
action
logs
to
do
that
and
I
found
this
Nifty
Json
value
command.
That
I
didn't
see
in
the
reports.
B
D
D
A
A
So
I,
don't
if
you
all,
have
spent
much
time
looking
at
action
logs
output,
you
know
they
all
kind
of
have
their
own
different
thing
that
they'll
dump
into
that
info
box.
That
is
always
some
reflection
of
what
has
changed,
but
it's
really
inconsistent.
I.
Think
when
you
save
a
bib
record,
the
info
box
saves
what
the
bib
was
before
you
saved
it
and
when
you
save
an
item
it
saves
the
new
values
like
that
level
of
maddening
inconsistency.
A
But
the
patron
modification
log
is
this
golden
standard
of
a
beautifully
formatted
Json
set
of
this
field.
Was
this
and
now
it's
this,
and
it
is
the
easiest
thing
in
the
world
to
write
a
report
on
so
yeah
Jason
put
a
link
in
the
chat
there.
That
will
give
a
nice
example.
I
know
I've
used
the
same
thing
to
write
a
report.
A
C
A
A
A
A
A
If
it's
a
line
where
the
action,
the
thing
that
happened
was
an
issue
instead
of
just
just
give
me
a
one
and
if
it
wasn't
an
issue,
give
me
a
zero
and
that's
going
to
give
me
a
count
of
per
item.
How
many
checkouts
there
are
in
that
issues
table
and
then
I
can
take
exactly
the
same
thing
and
just
say:
local
use.
A
A
A
B
B
C
C
C
D
A
But
I
do
know
that
feeling
of
like
when
I
when,
when
the
library
I
was
working
at
gave
these
many
years
ago,
oh
my
battery's
low
switch
to
KOA
there
was
this
spot
of
like
I've
got
a
question.
That's
not
so
stupid
that
I
won't
write
a
query
for
it,
but
it's
too
stupid
to
ask
anybody
else
to
write
a
query.
B
A
I,
don't
think
that
was
true,
but
it
was
very
much
how
I
felt
and
I
understand
that
on
the
flip
side,
when
I
was
working
at
Bywater
and
getting
report
requests
from
people
like
there
is
no
better
late
in
the
day
ticket
than
someone
wants
an
easy
report.
I
would
be
thrilled
to
write
that,
for
you,
that's
just
gonna
like
cap
my
day
off
so
good.
A
C
A
C
F
Well,
I'll
ask
another
question:
we're
just
getting
around
to
using
the
POS
in
koha
and
for
anybody
else.
That's
using
it.
Do
you
find
that
the
built-in
reports
or
adequate
for
tracking
all
of
your
transactions?
Does
anybody
have
any
special
reports
there's
they
are
using
and
if
so,
why
and
what
do
they
do?.
G
It
took
me
a
while
to
figure
out
how
to
make
the
report
work
and
I
had
to
put
a
ticket
into
buy
water
to
have
them
look
at
it
and
make
it
work
for
me.
So
I'm,
not
real
sure
I
can't
remember
what
we
did,
but
definitely,
if
you
need
to
know
you
know
whether
a
transaction
is
credit
or
cash,
then
that
wasn't
in
the
built-in
okay.
F
B
H
We
have
a
few
reports
per
request
by
one
of
our
libraries,
because
they're
they're
auditing
requires
a
little
bit
more
than
what
cohort
offers
I
mean.
We
use
the
POS
for
most
of
our
libraries
and
it
works.
Well,
it's
adequate
for
for
what
everybody
needs,
but
for
our
Washington
libraries
they
have
a
little
bit
more
stringent
guidelines.
They
have
to
follow,
so
they
have
to
account
for
every
single
penny
in
every
single
way.
Yeah
and
yeah
yeah
I
will
say
that
Kohan
does
not
track.
H
F
F
We
sell
so
many
different
things,
because
it's
not
just
you
know
like
earbuds,
we
have
pumpkins
and
we
have
a
pumpkin
patch,
every
October
as
a
fundraiser,
and
you
know
we
sell
all
these
weird
things
like
about
50
different
kinds
of
things
and
so
we're
having
to
make
sure
that
we're
you
know
getting
them
down
into
each
category
and
we
have
to
report
what
we
amounts
that
we
sell
to
both
the
foundation
and
friends
and
the
city.
So
yeah.
G
G
G
F
H
I
will
say
that
George
and
I
are
putting
out
a
video
in
the
near
future.
I,
don't
know
where
it
falls
online.
We
pre-reported
a
bunch
of
stuff,
but
we
do
have
a
video
on
the
the
formatting
of
the
staff
client
with
colors
and
a
little
bit
of
customization.
So
we've
got
that
coming
out
to
look
forward
to
but
George
put
out
some
code,
I
implemented
it
and
you
can
see
it
at
work.
H
H
I
did
customize
that
because
George
stuck
a
a
very
generic
looking
cohai
us
label
in
the
cornering,
I
thought
I
want
the
logo,
so
I
I
went
and
changed
that
and
then
I
I
went
ahead
and
customized
the
colors
in
there
too,
and
I
found
a
few
more
things
that
he
didn't
have
that
we
don't
even
have
in
the
video
that
needed
to
be
tweaked.
So
very,
very
nice.
H
If
you're
wanting
to
do
quick
changes,
it's
really
nice
for
making
quick
changes
to
the
overall
look
not
having
to
go
through
element
by
element.
He
did
a
lot
of
work,
I,
don't
know
if
you
had
contributed
to
that
Jason
or
or
what
I
know
that
you
did
with
some
of
the
focus
and
the
lines
around
the
the
search
field.
D
Yeah
I
did
the
initial
like
search
bar
modifications
which
are
above
I,
got
there
somewhere,
but
he
shared
what
he's
done.
It's
like
you're
a
crazy
amount
of
work,
but
it's
awesome
because
you
can
just
go
in
there
and
put
in
your
colors
and
then
it
themes
everything
out
to
match
your
your
organization.
I
just
pulled
up
the
call
us
demo
servers
that
looks
really
really
nice.
H
No,
that's
not
even
that's
not
even
in
the
video
yeah,
then
yeah
I
can
share
it
go
for
it,
but
you
know
I.
Think
overall,
you
know
that's
the
thing
that
I've
been
hearing
about
the
most
with
this
upgrade
is
you
know
the
new
look
everybody's
wanting
to
change
change
it
since
they
went
in
and
changed
the
colors.
H
It's
like:
okay,
but
yeah,
I,
I,
colorized,
the
buttons
and
tabs
and
things
to
are
kind
of
red,
white
and
bluish
I
think
it
looks
really
nice
yeah,
I
I,
particularly
don't
I,
don't
know,
I'm
I'm
a
little
on
the
fence
about
the
the
red,
because
I
I
don't
like
to
use
red
as
a
as
a
basic
color.
Just
because
it's
like.
D
H
D
E
H
H
Server
I
was
playing
around
with
something
and
I
replaced
the
logo
with
an
SVC
I
converted
our
our
logo,
which
is
just
one
color
to
SBC,
and
that
was
really
nice
because
you
don't
have
to
upload
a
graphic
anywhere,
but
with
the
kohai
US
logo.
If
I
try
to
do
that,
it
just
it
didn't,
monitor
them,
and
it's
like
I
want
the
color.
H
D
That's
an
issue
I
had
this
week,
so
I
have
like
some
of
my
assets
hosted
on
gitlab
and
gitlab
went
down,
so
my
OPAC
started
looking
real
junky
because
it's
like
the
images
broke
and
have
a
background.
That's
on
there
so
I
a
while
back
I
had
buy
water
set
it
up
so
that
we
could
upload
files
to
koha,
so
I
finally
went
in
and
uploaded
all
those
assets
to
the
server
itself
and
then
referenced
it
there.
D
H
Nobody
cares
about.
The
graphics
of
pill
has
down
yeah,
but
yeah
I
was
glad
when
we
were
able
to
upload
to
the
the
server,
because
yeah
I
started
moving
all
the
graphics
that
that
we
rely
on
in
Cohan
to
that,
and
it
makes
it
real
easy.
You
know
when
you
make
it
public
click
the
link
and
just
paste
it
in
the
source.
F
First
of
all,
I
don't
have
it
showing
multiple
covers.
I
took
away
the
the
scrolling
between
because
we're
just
using
synthetics,
something
like
that
and
then
I
I
somehow
made
like
the
container
of
where
the
image
goes
like
the
same
size
is
what
the
image
would
be,
and
so
it
doesn't
come
in
as
like
small
and
then
get
larger,
which
I
think
is
what
it
was
or
it
doesn't
come
in
and
then
like
shift
over
on
the
page,
and
when
I
did
that
things
started
going
faster
and
so
I
know.
F
H
Both
it's
on
in
on
the
staff
side,
I
I,
suspect
it's
the
new
mechanism
that
they're
using
to
display
the
covers
it's
taking
time.
If
you
have
multiple
images
and
we
do
have
to,
we
do
have
multiple
images,
because
some
synthetics
doesn't
provide
things
for
some
of
the
the
content
that
we
have
like
DVDs
and
also
you
know.
We
have
a
lot
of
things
that
we
provide
local
images
for
so
yeah.
H
Yeah
yeah
and
that's
that's
another
thing
is
I
I
wish
it
would
look
at
you
know,
and
maybe
it's
maybe
it
is,
and
that's
why
it's
taking
longer
it's
you
know
looking
at
the
size
of
the
images
and
having
to
resize
things
before
it
displays
it
or
what
I'm
not
sure,
because
I
I
do
notice
that,
prior
to
that,
synthetics
I
had
some
modifications
to
load
the
synthetics
image
at
a
different
size,
because
just
the
way
they
have
it
set
up
in
general,
didn't
do
it.
It
was
a
little
too
small.
B
H
D
I,
don't
we
don't
use
synthetics
at
all
and
I'm
noticing
on
my
test
server,
my
images
don't
load
in
the
detail.
View
at
all,
they
look
pretty
Snappy
in
the
search
results,
but
then
I
click
into
it.
It
gives
me
a
little
circle
in
a
box
and
then
it
goes
away.
So
that's
an
interesting
thing:
I
need
to
look
into.