►
From YouTube: System Administration Special Interest Group - 1/11/22
Description
Chat logs:
00:13:46 Heather Hernandez (she/her): SELECT items.itemcallnumber AS CallNo, ExtractValue(metadata,'//controlfield[@tag="001"]/*') AS OCLCnumber,ExtractValue(metadata,'//datafield[@tag="245"]/*') AS Title,ExtractValue(metadata,'//datafield[@tag="300"]/*') AS PhysicalDesc FROM biblio_metadataLEFT JOIN items ON (biblio_metadata.biblionumber=items.biblionumber)WHERE items.homebranch ='SFMARITIME' AND items.location='HDD'ORDER BY LPAD(items.barcode,40,' '), biblio_metadata.biblionumber ASC
00:21:47 Jason Robb (SEKLS): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29792
00:26:52 Lisette: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29808
00:28:02 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27320
00:32:03 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26058
00:39:28 Heather Hernandez (she/her): "TwoFourSixEight…":)
00:42:26 Heather Hernandez (she/her): Oh Em Gee...Athena flashbacks...
A
A
B
B
Can
you
see
my
my
coho
okay,
so
I
I'm.
I
grabbed
this
report
from
either
the
wiki
or
mana
I'm.
I
don't
remember
which-
and
I'm
normally
so
good
about
crediting
that,
but
I
forgot
in
this
case
and
I'm
trying
to
tweak
it
but
also
learn
and
understand
what
it's
doing
it
works,
I'm
not
getting
any
errors.
B
B
A
C
A
A
D
D
But
since
there's
those
extra
things
in
there
and
it's
triggering
more
transfers
than
it
used
to
so
like
so
the
problem
we
were
having
was
or
we're
still
having
ongoing.
As
if
a
library
checks
in
an
item-
that's
not
theirs,
it
triggers
a
transfer
to
send
it
back
home
before.
If
they
checked
it
in
again,
it
would
keep
going
back
home
where
it
needed
to
go
now.
D
C
D
D
Definitely
so
anytime
there's
a
wrong
transfer.
Basically,
it
has
a
chance
for
us
to
kind
of
get
caught
up
so
what's
happening
in
the
catalog.
For
us
is
it's
showing
like
if
a
library
checks
in
an
item
twice
in
a
row
without
clicking
okay,
which
happens,
then
the
item
becomes
available
at
the
wrong
location,
which
is
no
bueno.
So
there
is
a
bug
and
a
patch
written
to
fix
that-
and
I
don't
have
that
handy,
but
I
can
put
it
in
the
chat.
D
A
Yeah
and
I'm
looking
at,
we
have
a
report
for
items
that
are
in
the
wrong
location,
showing
as
available,
which
didn't
come
up
that
frequently
before.
Usually,
if
someone
like
cancel
the
hold-
and
it
didn't
in
in
like
very
specific
ways
and
I'm
seeing
at
least
a
couple
of
our
branches
have
more
than
normal
amount,
moscow's
got
like
26.,
although
some
of
that
might
actually
be
from
stock
rotation
stuff
because
that's
all
audiobook
stuff.
So
that
might
be
things
that
got
pushed
forward
in
stock
rotation
and
haven't
been
pulled.
Yet.
D
C
A
A
A
A
So
items
weren't
moving
since
the
update
in
at
the
end
of
september
we're
early
adopters.
They
moved
a
little
bit
and
also
because
a
bunch
of
stuff
was
like
already
needing
to
get
sent
along
that
hadn't
been
pulled.
Yet
it
took
us
a
while
to
figure
out
that
things
just
weren't
moving,
so
stock
rotation
fails
to
advance
when
an
item
is
checked
out
from
the
branch.
That
is
the
next
stage.
A
A
A
F
F
For
well,
we've
used
it
for
our
oclc
records
and
then
I've
used
it
for
wanting
to
get
like
a
specific
group
of
records
that
I
want
to
take
in
to
mark
edit
and
do
something
there.
But
it's
not
a
whole.
I
type
it
maybe
like.
We
were
moving
our
graphic
novels
and
we
were
wanting
to
do
something,
and
I
think
there
was
a
subject
heading.
We
were
going
to
add
and
it
was
just
it
was
like.
Maybe
I
should
do
this
in
mark
edit
and.
C
F
C
D
A
C
A
C
This
is
a
I
just
wanted
to
see
if
anybody
had
any
if
it
had
run
into
any
problems
so
because
I
paid
for
it
and
I
plan
on
using
it
it'll
it'll,
it
won't
affect
passwords
that
already
exist.
It'll
only
affect
passwords
once
they're
changed,
but
I
wanted
to
know
if
anybody
had
any
issues
after
now
that
this
is
in
quahog.
That's.
The
next
thing
I
want
to
fund
is:
have
the
system
remember
previous
passwords
for
like
a
certain
length
of
time
and
that
you
can't
use
the
same
password
and.
C
So
I'm
I'm
just
curious
about
it,
because
I'm
you
know
we're
upgrading
on
saturday
and
that's
going
to
be
one
of
the
things
that
I
do
sunday
morning
is
set
that
so
that
new
passwords
are
I'm
I'm
making
them
14
characters,
long
and
complex,
with
uppercase,
lowercase
and
and
a
number
which
people
aren't
going
to
be
happy
about,
but
I'm
not
happy
with
passwords
that
are
like
2,
4,
6
8.
So
I've
been
happy.
I've
been
unhappy
for
a
long
time.
Now
it's
their
turn
to
be
unhappy.
D
A
A
Well,
after
a
number
of
times
of
them,
saying
that
me
saying
the
same
answer:
they've
stopped
asking
me
that
so
sometimes
when
we
have
a
new
person
who
it's
the
first
password
change,
they're
like
can't
you
make
it
something
easier
this
time
and
I'm
like
no
there's
so
much
patron
data
that
someone
could
have
if
they
had
access,
you
know
get
access
to
if
they
had
the
password
right.
So
no.
C
Then
I
feel
comfortable
in
giving
them
the
ability
to
change
those
passwords.
What
I
don't
want
and
ultimately
my
my
goal
is,
you
know
it's
nine
o'clock
sunday
morning
there
was
a
phone
call,
I'm
locked
out
of
my
account.
Can
you
can
you
log
in
and
and
reset
the
password
on,
my
account
for
somebody
in
in
one
of
our
libraries
and
that's
been
three
weekends
in
a
row
we've
had
at
least
one
saturday
or
sunday
phone
call
saying
you
know
I've
locked
out
of
my
account.
Can
you
just
make
it
two
four
six
eight?
C
No,
I,
since
you
called
me,
I'm
going
to
give
you
something.
That's
complicated,
I'm
going
to
give
you
a
line
from
a
shakespeare
sonnet
which
I've
done
that
or
you,
oh,
you
need
new
passwords
for
your
tech,
circ
and
director
accounts.
Okay.
Well,
I
was
listening
and
this
morning
on
the
radio
there
was
billy
joel,
followed
by
the
rolling
stones
followed
by
def
leppard
you're,
getting
a
line
from
each
one
of
those
is
going
to
be
a
line
from
a
different
song.
F
C
A
Yeah,
that's
the
other
thing
is
that
since
I
sent
off
set
almost
all
of
the
ones
for
later
county,
I
have,
I
know
what
they
are,
so
I
don't
have
to
reset
them.
When
they're,
when
someone's
like,
I
can't
figure
out
how
to
log
in
because
the
branch
manager
has
three
passwords
ago,
written
down
in
the
sub
binder.
C
C
C
Joined
in
over
the
christmas
holidays
in
1819,
so
they
their
first
day
on
quahog
was
january,
5th,
2019
and
they
and
in
2018
they
were
still
using
a
very
old
version
of
tlc
yeah
yeah
and
they
had
they
had
the
paper
manual
printed
in
a
notebook
and
and
all
the
the
screenshots
were
like.
Oh,
I
remember
that
from
windows
98
that
level
I
mean
everything
about
it,
looked
so
windows
98
and
it
just
didn't
work
anymore,
and
it
was
a
challenge
for
bywater
to.
A
A
A
A
A
D
D
G
D
C
If
the
notices
are
in
template
toolkit,
you
should
be
able
to
set
it
up
so
that,
if
the
reason
is
one
you
don't
want
to
send
a
notice
for
then
you
can
just
tell
it.
You
know
if
you
can
put
that
in
the
condition.
So,
if
notice
equal,
if
reason
equals
x,
then
then
leave
the
notice.
Blank
and
coha
will
not
send
a
blank
notice
if
you're
using
template
toolkit.
C
C
D
C
And
while
we
were
speaking
there,
I
got
an
email
that
says
one
of
my
libraries
is
closing
due
to
a
code
exposure.
So
that's
a
good
question
for
the
system
administrators.
What
do
you
guys
do
when
a
library
has
to
close?
Suddenly
I've
been
mostly
going
in
and
I
unfortunately
they
don't
say
how
long
they're
going
to
close
but
I'll
I'll
make
all
of
their
due
dates?
C
A
Yeah
we
have,
I
guess
one
of
our
libraries
was
closed
some
like
a
year
ago,
because
a
couple
of
people
got
it
like
fall
of
2020,
but
I
think
they
were
already
fine
free
and
we
hadn't
set
up
the
restrictions,
so
they
got
restricted
very
fast.
So
I
think
we
just
like
put
up
a
notice
and
turned
off
transfers
for
that
library,
because
we
were
also
still
doing
stuff
with
transfer
the
transfer
table
for
a
lot
of
our
thing
or
no,
we
had
we
were
using
the
holds
groups.
A
C
C
A
D
For
us
it's
a
little,
we
just
panic
and
then
cry
a
little
bit:
no
yeah.
We
we
push
forward
due
dates.
If
we
need
to,
I
set
them
closed
on
the
cohort
calendar
because,
usually
they
don't
think
about
that,
but
that
affects
our
holds
cue
generation.
Primarily,
if
they're
going
to
be
closed
for
an
extended
amount
of
time,
I
will
disable
their
ability
to
place
holds.
C
C
D
We
haven't
had
any
yet
I
got
an
email
this
morning,
but
they
said
they
weren't
positive,
but
I
did
have
a
library
that
closed
due
to
mold.
It
still
closed
recently-
and
I
have
another
one
where
they,
the
heat,
doesn't
work
in
their
building
so
they're
currently
closed,
but
yeah.
I'm
expecting
us
to
see
more
code
related
closures
soon,
given
the
current
situation,
but
maybe
not.
C
Yeah,
some
of
these
closures
are
because
they're
people
like
this
closure
that
I
just
got
the
email
about.
They
say
one
of
the
workers,
one
of
the
employees.
That's
there
every
day
has
been
exposed,
so
essentially
all
of
the
staff
have
been
exposed,
but
nobody's
been
confirmed
with
covid
yet,
and
then
there
are
other
libraries
and
they're
taking
this
as
a
precaution,
and
then
I
have
other
libraries
like
well
like
I
said
where
everybody
every
employee
has
cobit,
except
one
or
two,
so
you
know
it
tends
to
vary
one
of
the
libraries.
C
You
know
the
governor
of
kansas,
shut
down
everything
in
the
state
for
what
was
at
about
six
weeks
at
the
beginning
of
the
pandemic
in
march
or
april
of
2020,
and
we
had
one
library
that
stayed
open
the
whole
time.
It's
like
the
hell
with
the
governor,
we're
just
open
and
they
were
open
the
whole
time,
even
though
it
was
even
though
they
were
told
that
it
was
that
they
were
not
not
supposed
to
be.
I.