►
From YouTube: System Admin Special Interest Group - 7/13/2021
Description
Chat logs:
00:00:00 Intro
00:23:49 Jason: https://docs.google.com/document/d/1PbdTPFPX2Bm3J7UBiT1MqEyqLdQ0_Orzf_Ak-oC4fAE/edit?usp=sharing
00:28:03 Jason: https://bywatersolutions.com/education/monday-minutes-offline-circulation-tool
00:48:26 Jason: https://bywatersolutions.com/education/to-log-or-not-to-log
00:49:20 Jason: https://wiki.koha-community.org/wiki/SQL_Reports_Library#action_logs
A
B
Yes,
I'm
puzzled
by
inventory
and
I
don't
have
enough
information
to
represent
a
coherent
picture
of
what
is
happening,
but
I
scanned
a
collection
and
with
my
trusty
barcode
scanner,
downloaded
the
barcodes
and
removed
a
and
the
b
from
the
beginning
and
end
and
then
put
it
into
inventory,
they're
about,
let's
say
80
to
90
barcodes
and
I
said
limits
to
popular
health
rating
and
every
single
one
of
them,
including
the
ones.
I
absolutely
knew
were
there,
because
I
just
scanned
them
came
up
with
not
scanned.
A
B
C
C
B
B
D
C
B
A
B
A
A
B
B
A
B
B
A
C
C
A
A
If
I
can
get
to
it,
but
basically
yeah,
if
you
run
a
report
on
everything
that
has
a
lasting
date
less
than
whenever
you
do,
the
upload
then
they'll
give
you
that
list
of
things
that
it
didn't
see
and
that
you
should
look
for,
but
it
seems
like
maybe
if
you're
sure
that
some
of
that
stuff
is
on
the
shelf.
But
it's
coming
up
on
that
inventory
report.
A
B
B
B
A
I'll
find
out
no,
so
this
one's
just
gonna
look
at
the
results
of
your
upload.
So
if
you
run
it
for
that
shelf
location
that
you
just
picked
the
popular
and
then
pick
the
date,
which
is
today's
date,
because
that's
the
date
of
your
upload,
then
it's
gonna
list
out
everything
that
it
thinks
you
should
have
scanned,
but
didn't
get
read
into
the
inventory
tool.
Okay,.
B
A
A
C
A
B
A
I've
never
used
it.
I
know
that
the
bywater
monday
minutes
was
on
the
offline
circulation
tool
this
week.
So
if
you
want
to
watch
that
one
okay,
that
might
get
you
up
to
speed
with
it,
we've
always
been
hesitant
to
use
it
just
because
it
had
problems
because
of
our
consortium.
You
know
or
too
big.
So
it
would
time
out
and
things
like
that,
so
we've
never
really
given
it
a
shot.
B
E
A
A
A
Let
me
close
my
email
that'll
be
safe,
all
right,
so
I've
been
working
on
this
idea
of
like
dashboards
for
recording.
So
I
I
came
up
with
this
one,
so
I
guess
to
back
up
a
little
we're
using
right
now,
just
an
external
table
full
of
reports
to
so
I
send
this
out
as
a
reminder.
Every
month
to
my
libraries
to
run
these
reports,
look
for
problems
resolve
them.
It's
kind
of
divided
out
into
cert,
cataloging
and
then
for
patrons.
A
A
So
I
just
took
that
table
that
we
normally
use
and
I've
been
trying
to
like
build
it
up
here
and
then
I'm
using
some
json
and
a
report
to
pull
in
the
values
directly
in
so
when
the
page
loads.
It
runs
the
report
and
then
gives
me
account
for
each
of
the
related
reports
and
then
I'm
also
using
some
emphasis
on
like.
Since
we
are
a
consortium.
A
We
always
have
to
be
mindful
that,
like
one
library
has
borrowed
something
from
another
library
and
you
need
to
focus
on
the
getting
those
items
back
first,
so
I
I
wanted
to
add
emphasis
on
that
sort
of
thing,
and
then
I
don't
have
it
set
up
yet.
But
you
can
see
the
the
url
down
there
that
it's
just
kind
of
a
empty
link,
but
my
my
goal
is
to
get
them
all
synced
up
with
separate
reports.
A
So
when
you
click
on
this
147,
it
brings
up
the
list
of
147
items
and
then
I've
got
things
divided
out
into
different
issue
areas
and
then
yeah.
So
my
plan
is
to
have
that
all
linked
up
and
then
yeah.
So
I
built
that
up
in
the
internet,
circulation
home
html
and
I
just
borrowed
that
whole
tabbed
business
from
from
one
of
the
w3
examples
pages
and
then
kind
of
tweaked
it
to
how
I
wanted
it,
and
then
it
used
a
little
javascript,
which
I
just
plopped
in
there
too
and
then
on.
A
A
You
can
see
that
the
the
spinny
icon
is
here
and
I've,
given
an
idea
of
oda
for
the
first
overdue
report
and
then
with
the
jquery
I'm
pulling
in
the
number
with
the
variable
and
then
I'm
replacing
that
icon
with
the
number
there
and
then
I
think
I
have
the
report
pull
up
here.
So
this
is
the
report
and
it's
just
a
bunch
of
a
bunch
of
nasty
sql.
A
A
I
guess
one
of
my
concerns
is
that
it's
gonna
like
be
detrimental
to
load
that
every
time
the
page
loads,
but
I
know
that
we
can
also
cache
reports,
so
I
may
just
have
it
update
like
once
a
day
or
once
every
12
hours
or
something
so
that
it's
not
running
a
report
anytime.
Someone
clicks
on
circulation.
A
But
I
thought
that
was
a
cleaner
way
to
kind
of
bring
the
issues
to
light,
and
hopefully
people
will.
My
librarians
will
pay
more
attention
to
that
kind
of
stuff.
If
it's
right
in
their
face,
that's
kind
of
my
goal
and
then
I
want
to
add
more
to
the
different
pages
so
of
course
circulation
on
the
circulation
page
cadillac
being
on
the
cataloging
page
on
the
reports
page,
I'm
thinking
I
can
right
now.
I've
got
like
quick
statistics
here.
A
I've
replaced
the
wizards
with
quick
statistics,
so
I'm
thinking
I
could
pull
out
the
monthly
data
and
just
have
it
displayed
below
and
have
it
load
automatically,
so
they
don't
have
to
actually
run
those
reports
to
get
their
monthly
information
yeah.
So
that's
the
project.
I've
been
currently
kind
of
focused
on
and
thought
I
would
share
and
I've
bored
fred
so
much
that
he
wandered
off.
A
Like
I
said,
my
only
worry
is
that
it's
gonna
like
put
too
much
load
on
the
system
running
because
it's
running
like
a
bunch
of
simultaneous
reports-
and
I
know
I've
been
discouraged
in
the
past
from
using
json
too
much
in
my
jquery,
but
I
think
it'll
be
okay.
It
loads
slower
on
my
test
server,
of
course.
So
I
I
guess
I'll
give
it
a
shot
and
if
I
crash
koha,
then
I
get
a
sticker
for
the
day.
A
A
A
D
A
A
A
A
A
Change
all
of
these
things,
so
if
I
wanted
it
to
just
be
on
display,
but
not
like
a
non-circulating
display,
then
I
could
change
the
item,
type
temporarily
to
doesn't
circulate
and
then
I
could
also
change
the
shelf
location
to
new
or
display.
I
think
we
have
a
display
so,
but
it
retains
the
old
value
as
well.
A
A
A
A
D
Yeah
we,
when
we
catalog
we
give.
We
have
item
types
that
are
like.
We
have
regular
fiction
and
we
have
we're
not
autumn
types
we
have
a
location
of
regular
fiction
and
a
location
of
new
fiction,
and
so
when
we
catalog
it
goes
to
new
fiction
and
it
gets
a
little
months
dot
on
it.
So
you
know
what
month
it
was
added
and
it
stays
that
way
for
like
a
year
and
then
staff
pull
off
the
things
after
they're
a
year
old
and
we
batch
update
whatever
we've
pulled
to
the
old
fiction
location.
D
A
Yeah
your
process
sounds
pretty
similar
to
ours,
so
it's
not
always
reflective
in
the
catalog,
where
it's
sitting,
and
I
think
that
this
like
we
don't.
We
can't
batch
things
really
because
we
we're
going
from
our
new
book
location
to
one
of
many
non
so
like
we'll
go
from
new
book
to
adult
fiction
or
new
book
to
adult
mystery.
That
kind
of
thing.
D
We
still
have
to
group
ours
so
like
we,
we
have
like
a
one-to-one
relationship,
so
we
have,
you
know
romance
and
new
romance
mystery
and
new
mystery,
and
you
know
chapter
books
and
new
chapter
books,
so
they
do
have
when
they
batch.
They
do
have
to
group
like
things
together.
Otherwise
they
would
miss
everything.
A
Yeah
yeah,
so
that's
that's
kind
of
our
problem.
Right
now
is,
since
we
don't
have
that
it
has
to
be
managed
one
at
a
time.
So
I
think
that
this
will
help
us
if
we
can
get
it
set
up,
because
then
they'll
have
a
list
of
everything
that
should
be
on
the
new
shelf
and
when
they're
ready
to
take
it
off
they
can
they
can
pull
the
card
over
and
just
hit,
remove
on
the
ones
that
need
taken
off,
and
then
they
don't
have
to
mess
with
cataloging
at
all.
A
D
A
E
A
So
I've
I
know
I've
had
not
great
luck
with
the
logs
either
we
we
had
only
been
keeping
information
for
like
a
month
and
we've
we've
stepped
that
up,
but
I
have
trouble
finding
information
same
same
as
you
like,
sometimes
I'll
end
up,
seeing
like
information
about
a
hold
in
the
cataloging
log.
Before
I
see
it
in
the
circlog,
I'm
I'm
not
sure
I
don't
use
them
that
much
does
anybody
else
have
more
experience
with
the
that.
D
E
A
A
Yeah-
and
we
don't-
I
don't
think
we
automatically
expire
holds,
and
we
don't.
I
don't
think
we
have
a
lot
of
libraries
using
that
or
patrons
even
using
that
where
they
set
a
not
needed
after
date.
So
I
don't
know
what
that
looks
like
in
the
logs.
My
guess
is:
it's
gonna
say
that
it's
a
intranet
or
maybe
I
don't
think
it's
going
to
say
that
the
opac
deleted
it,
because
it's
probably
like
a
cron
job,
that's
actually
deleting
it
automatically.
A
So
I
would
guess
that
it's
going
to
save
the
interfaces
is
the
internet
and
not
the
opec.
Even
though
it's
the
patrons
fall,
I
wonder
if
you
could,
is
it
not
needed
by
day
in
the
holds
table
like?
Is
it
stored
there
because
it
may
be
stored
in
the
old
holds
table
too?
So
you
could
run
a
query
on
like
a
deleted
hold
and
see
if
it
had
a
not
needed
by
date
set
possibly,
and
then
you
could
like
come
to
the
conclusion
that
the
patron
must
have
said
that
not
needed
by
date.
E
A
A
B
D
A
D
A
It
can
be
like
I've
got
access
to
the
backend
settings
for
their
account
and
there's
a
place
to
put
in
this
zip
connection
information
and
then
there's
a
checkbox
that
lets
you
require
sip
to
authenticate,
and
they
told
us
that
if
the
connection's
working
that
little
checkbox
will
light
up,
but
we
can't
get
the
box
to
light
up.
Even
though
I
I've
confirmed
that
the
zip
connection
works,
and
then
they
told
us
that
the
sip
login
needs
to
be
the
same
as
the
user
login
like
the
admin
user
login.