►
From YouTube: System Admin Special Interest Group - 10/14/2020
Description
Chat logs:
00:15:58 Brandi Ledferd: Hi all, I don't know if this is the correct group to ask this, but I came here to ask if anyone has been able to set up a direct SQL connection to their Koha data from a 3rd party reporting program. We are hosted so that's likely an issue. I asked Bywater and got no response.
00:16:10 Jason Robb: https://groups.google.com/a/koha-us.org/g/sysadmin/c/8KOnbKXOcvQ/m/T3xFjk33CgAJ
00:17:35 Brandi Ledferd: Thanks, I will pursue this with Bywater again. I am using Power BI.
00:18:24 Brandi Ledferd: Thank you!
00:19:57 Brandi Ledferd: Oh right...it's MY IP address.
00:38:56 George Williams: https://framabin.org/p/?4ead1017588bb60b#WP8rJhe5SPmh4ALC2wtHY/QfbJIdkscMr8YY3C0OC3o=
00:39:21 George Williams: Here's the SQL for the report I use to determine who "owns" a late fee
00:40:43 Barbara Johnson: Thanks George
00:45:26 Heather Hernandez: There's a Bywater blog post w/some OPAC & pub svcs features: https://bywatersolutions.com/education/20-05-opac-and-public-services-updates
00:48:21 jtate: Thanks for discussion. I have another meeting. Have a good day!
01:00:37 George Williams: RefundLostOnReturnControl
01:02:29 Heather Hernandez: I'm totally dependent on timeanddate.com for figuring out the times!
01:02:46 Heather Hernandez: I'll be watching a lot of recordings.:)
01:03:38 Heather Hernandez: Gotta run--thank you, everyone!
01:05:14 Brandi Ledferd: Goodbye. Thank you!
B
I
mean
we're
hosted.
I
saw
one
of
the
directors
from
my
consortium.
They
did
respond
to
that
and
say
basically
like
oh
yeah.
That's
a
good
point.
We
might
need
to
think
about
that
because
we
hadn't
really
thought
about
it,
but
yeah
like
we're
hosted
and
I
think
we
have
nightly
backups
or
weekly
backups
or
something
and
yeah.
That's
not
something
I
had
thought
about
before.
B
But
also,
I
think
they
only
keep,
I
don't
think
they
keep
very
far
in
the
backups,
because
I
know
a
couple
times:
we've
had
weird
things
happen
with
items
and
they've
tried
to
go
back
and
look
and
couldn't
find
anything,
but
it
was
definitely
something
that
happened
like
within
the
last
30
days,
so
they
might
only
keep
like
a
week
of
backups
for
us,
which
is
still
a
potential
problem.
But
honestly
by
the
time
we
got
us
like
subpoenaed,
it
probably
wouldn't
be
an
issue.
A
B
A
C
A
I
mean
I
intentionally
just
wipe
it
and
after
an
upgrade,
I
get
a
new
data
dump
from
them,
and
you
know
I'll.
I
will,
after
an
upgrade
then
I'll,
take
our
test
server
and
just
wipe
it
out
and
take
a
fresh
install
of
the
the
real
next
release
and
then
I'll
get
the
data
done
from
bywater
to
put
our
stuff
on
it
yeah
just
so.
I
keep
it
fresh
with
each
upgrade,
rather
than
doing
upgrading
my
choice.
C
D
A
A
D
A
B
In
the
chat
brandy
asked
about
setting
up
a
direct
sql
connection
to
their
cohort
data
from
a
third
party
reporting
program.
Yeah,
we
had
that
sort
of
here.
We
had
it
so
that
we
could
use
like
microsoft.
Access
to
do
some
stuff
and
bywater
did
have
to
like
white
list
an
ip
of
ours
to
make
that
happen.
B
D
You
know
requirement,
is
they
wanted?
They
didn't
want
the
purchase
suggestions
turned
on
because
they
wanted
to
handle
everything
by
paper,
and
so
I
wrote
a
thing
using
libreoffice
so
that
they
could
be
printed
out
on
paper
so
that
this
person
wouldn't
have
to
interact
with
the
computer,
which
was
just
stupid.
D
I
forget
the
name
of
it
as
like.
It's
like
sql
workbench,
I
think,
is
the
one
that's
made
by
mysql,
then
the
that
software
talks
to
the
odbc
connector,
which
connects
it
to
the
database
directly
and
the
thing
that
bywater
has
the.
If
you're
a
bywater
customer,
they
don't
allow
these
random
odbc
connections
to
the
database.
E
F
Our
upgrades
are
coming
up,
we'll
be
upgraded
to
version
20..
We
have
a
production
server
and
a
test
server.
Our
test
server
is
not
on
the
same
page
as
the
production
server,
and
I
would
like
to
sync
them,
but
I
wanted
to
know
if
they
can
be
set
to
sync
automatically
like
once
a
week
or
every
two
weeks
or.
F
I
submitted
a
help
desk
ticket
and
they
told
me
that
working
on
a
project
on
our
test
server,
we
are
adding
a
second
library.
We
have
another
division
that
has
a
library
and
so
we're
working
on
that
project
in
our
test
server
right
now,
and
so
I
don't
want
to
lose
that
data.
So
I
was
going
to
export
the
records
out
and
once
the
sync
was
done,
then
I
was
going
to
import
them
back
in,
but
I
didn't
know
if
it
was
if
it
could
be
automatically
synced
on
a
routine.
F
F
F
Version
well,
not
necessarily
on
the
same
version.
I
mean
they're
already
on
the
same
version,
but
it's
like
the
test.
Server
is
so
far
behind.
Well,
what's
on
the
production
server
so
like.
If
anybody,
if
I
want
to
try
to
play,
you
know
with
something
on
the
test
server,
but
it's
not!
Unless
that
server
is
in
production,
I
got
to
export
and
import,
and
all
that
I
was
just
kind
of
trying
to.
D
F
Okay,
well
I
mean
I
submitted
a
helpdesk
ticket,
they
told
me
they
would
sync
it
they
suggested
either
they
do
it
before
the
upgrade
or
after
the
upgrade
yeah.
But
I
just
replied
to
ask
about
the
you
know
the
project
that
we're
working
on.
You
know
once
I
import
them
back
in
and
then,
if
it's
on
a
routine
to
sink,
will
we
lose.
You
know
when
we
mess
that
up,
and
I
haven't
heard
back
from
anybody
yet,
and
so
I
thought,
since
I
was
in
this
session,
somebody
may
have
some
ideas.
D
D
D
H
A
B
F
A
Well-
and
I
guess
there
is
some
impact
say
your
fine
rule
currently
says
you
have
a
max
fine
of
five
five
dollars
for
a
particular
item.
I
know
you're,
not
charging
overdues,
but
just
let
me
go
through
this.
If
you
have
that
fine
rule
once
that
rule
is
gone,
when
it's
checked
back
in
it's
not
gonna
or
if
it
keeps
going
it's
just
going
to.
I
don't
know,
what's
going
to
happen
to
an
overdue,
if
you're
charging
with
the
max
fine
piece
of
that.
D
See
the
way
I
understand
it
is
you
know
when
you
check
something
out,
it
doesn't
know
what
rule
is
being
used.
There's
no
record
in
the
in
the
right
issues
table
that
says
this
is
the
rule
that
was
followed
when
we
checked
it
out
so
every
time.
My
other
question
yeah
every
time
you
every
time
something
happens
to
that
item
to
that
issue,
that
line
in
the
issues
table
where
it
has
to
go
back
and
check
the
rule.
D
It's
checking
the
rule
that
exists
right
now,
so
if
it
checks
the
rule
that
exists
right
now
and
it
and
that
rule
has
changed,
the
changes
are
going
to
apply.
So
if
you
go
in
and
and
you
know
when
you
renew
it,
it's
going
to
go
and
look
and
see
which
rule
applies
to
that
line
in
the
issues
table
right
now.
D
H
But
the
material
has
to
be
returned
between
february
1st
and
basically
october
1st,
and
we
want
to
go
back
and
forgive
those
fines,
because
our
city
council
made
it
effective
with
the
february
first
date,
but
then
everybody
before
that
that
accrued
any
fines.
They
were
covered
with
the
previous
policy,
so
we're
we're
set
going
forward
now
we're
working
on
the
kind
of
group
in
between,
and
we
didn't
know
that
one
thing
that
staff
had
said
is:
okay.
I
guess
we,
you
know
we
wipe
out
those
fines.
Do
we
like
they
never
existed?
H
C
D
A
D
Not
only
do
we
want
to
get
eliminate
fines
going
forward,
but
we
want
you
to
figure
out
which
fines,
which
are
just
late
fees,
on
the
patrons
that
we
have
now
paid
late
fees
owed
to
our
library
and
we
want
to
just
zero
those
out
and
I've
been
able
to
do
that.
A
couple
of
times
too,
I've
had
a
couple
of
libraries
that
have
done
that.
D
B
B
Directors
want
to
there's,
they
have
like
two
directors,
it's
weird
and
they
are
want
to
go,
find
free,
but
the
board
doesn't
want
to.
So
that's
what,
but
the
way
that
our
consortium
works.
They
are
going
to
see
a
large
fine,
a
large
drop
in
fine
revenue
anyway,
because
of
the
way
our
fine
rules
are
currently
set
up,
so
they
might
end
up
going
fine,
free
and
not
too
long
anyway,
once
the
board
figures
that
out.
D
B
D
Yeah
when
I
worked
there,
my
experience
was,
you
could
have
a
patron
in
front
of
you
and
that,
like
this
book
could
be
due
in
two
weeks.
This
one
could
be
doing
three
weeks.
This
one
could
be
due
in
28
days
and
this
one
could
be
doing
30
days
because
they
all
came
from
different
libraries
with
different
circulation
rules
and
the
rules
there
follow
the
library
that
owns
the
item,
not
the
library
where
you're
checking
out.
H
B
H
D
D
But
then,
if
you
go
back
far
enough
in
the
database,
there's
been
enough
changes
and
some
of
those
you
could
not
identify
where
the
item
had
been
checked
out,
and
so
it's
it's
like.
It's
like
a
it's
a
it's
like
got
a
union
and
some
sub
queries
in
it.
So
it's
really
a
convoluted
report
and
I
would
have
to
dig
it
up,
but
it's
but
the
advantage
is
you
know.
If
you've
just
got
one
library,
you
should
be
able
to
look
at
the
account
lines
and
see
which
ones
are
fines.
H
D
D
A
Yeah
we
intentionally
didn't
bother
because
once
something
was
overdue
for
I
think
60
days
they
just
automatically
got
charged
for
it,
and
then
we
have
you
know
we
have
got
those
cleaned
up,
but
we
wanted
to
have
those
bills
still
there
as
opposed
to
just
to
find
if
it
was
just
a
fine.
We
liked
the
idea
of
being
able
to
tell
people.
You
know
we're
waving
this
and.
C
A
G
Like
ed
michael,
thank
you
yes,
this.
This
is
daphna
from
mentally
friend,
ireland
and
we
use
it
quite
a
lot
in.
We
have
technical
universities
here
in
a
consortium
with
the
union
catalog
and
there
are
13
of
them
now
they
don't
all
use
it,
but
the
ones
who
use
it
like
they
say
it's
not
the
most
functional
rich
in
the
world,
but
it
does
work
for
them.
G
So
it
does
work
and
now
obviously
I'm
I'm
with
interleave.
So
I
only
know
on
the
support
side.
I
don't
know
the
practicalities
within
the
libraries
of
the
headaches
they
would
have
there,
but
I
think
it
would
certainly
be
very
well
worth
your
while,
if
you
get
even
one
other
library,
who's
interested
to
just
set
a
test
up
between
the
two
of
you
and
then
you
can
build
from
that.
A
G
And
now-
and
I
hope
the
ill
functionality
that
is
in
there
is
when
we
have
certain
things,
because
we
would
use
the
british
library
all
the
functionality,
for
that,
I
presume
is
not
in
the
standard
community.
We
use
and
we
work
a
lot
with
ptfs
europe.
So
we
would
collaborate.
So
you
know
that's
the
only
thing
I
would
say
to
you.
There
might
not
be
all
the
functionality
that
we
have,
but
it's
certainly
worth
investigating.
A
E
C
D
Jason
has
talked
about
us
setting
it
up
here
in
kansas
between
my
system
and
his
system
and
the
other
system
that
uses
coho
to
bypass
the
the
software
that
we
don't
like
that
the
state
uses
for
the
statewide
ill
system,
and
so,
but
we
haven't
done
anything
with
it,
but
that's
been
my
understanding
is
that
it's
it's
unique
to
cohan.
It
has
some
features
that
there's
some
there's
a
lot
of
tweaking
and
it's
still
an
early
development.
It's
still
there's
still
a
lot
of
changes
and
improvements
that
could
be
made
so.
A
D
F
A
C
H
C
D
I'm
about
to
set
it
up
on
our
test
server
for
a
meeting
that
we're
having
in
november,
so
that
a
couple
of
libraries
can
test
it.
We
have
a
one
library,
that's
going
to
continue
curbside
service,
even
though
they're
reopened
and
and
things
are
going
fairly
smoothly
there.
I
still
have
a
couple
of
libraries
that
haven't
reopened
yet
so
they
they've
come
up
with
a
plan
for
what
they're
doing
for
curbside,
but
that's
one
of
the
things
I'm
not
sure
what
it's
going
to
be
like
to
rebuild
this
and
keep
working
on
it.
A
A
C
But
yeah
we
I
set
it
up
and
we
had
some
circulation
staff,
look
at
it
and
they
said
right
now.
What
we're
doing
we
don't
have
the
the
numbers
to
justify.
But
if
we
do
have
to
close
down
it's
there
and
they
they
like
it
and
they
think
it's
going
to
be
easy
to
train
on
so
but
it
hasn't,
we
haven't
done
any
real
world
usage.
Yet.
A
A
C
So
that's
an
excellent
point.
We
actually
have
that
that
gremlin
too.
So
you
know,
I
think,
the
the
guy,
the
staffer
that
was
looking
at
it
he's
pretty
much
the
head
of
the
curbside
task
force
that
we
had,
and
I
hope
that
he
he'd
train
his
staff
to
look
at
all
the
material
before
he
does
the
batch
checkout.
But
mistakes
are
made.
So
that's
a
very
good.
A
A
First
of
all,
look
at
the
batch
checkout
page
and
see
if
there
was
anything
that
it
said,
didn't
check
out
for
one
reason
or
another,
but
then
go
back
to
the
main
checkout
page
and
see
if
there's
still
anything
waiting
that
wasn't
there
and
frequently
there's
something
there,
and
then
they
have
to
go
track.
That
item
down
the
other
problem
we
have
is
we
have
way
too
high.
Well,
I'm
not
going
to
say
that
we
have
a
very
high
limit
on
the
number
of
holds
people
can
place.
A
A
A
D
D
D
H
D
D
So
we
have
students
at
our
school
district
and
faculty
in
our
school
district
and
our
interlibrary
loan
accounts
never
get
billed,
but
the
way
that
it
works
for
everybody
else
is
all
the
other
patreon
categories.
If
something
is
overdue
for
more
than
45
days,
they
get
built
the
status
changes
to
lost
and
they
get
billed
for
it.
D
And
then
we
have
another
script
running
that
takes
those
lost
items
and
deletes
them
when
they've
been
marked
as
lost
for
more
than
13
months,
and
we've
got
all
the
notices
in
all
50
libraries,
all
51
libraries
set,
so
that
the
second
notice
goes
out
at
35
days
and
it
says
you're
going
to
be
billed
in
10
days
and
then
at
45
days
it
says
you're
being
billed
and
then
on
day
46.
They
are
billed
and
then
13
months
after
that.
The
item
is
deleted
from
the
catalog.
D
I
Ours
is
set
at
99
days,
but
it
also
doesn't
do
anything
like
because
we
have
lots
of
situations
where
a
patron
loses
another
library's
item.
So
the
the
decisions
were
made
before
I
came,
but
basically
we
don't
want
anything
charging
to
the
account
that
might
slip
through
the
cracks.
So
our
yeah
we're
not
using
that
functionality
as
well
as
we
probably
could.
D
D
A
We
were
seeing
lots
and
lots
of
material
coming
back
after
it
had
been
charged
to
the
to
the
patron.
They
would
just
return
it
and
what
was
happening
is
it
wasn't
automatically
being
removed
from
their
record
when
it
was
checked
in
you
know
what
I'm
saying
yet
had
to
go
in
there
and
write
off
those
fines.
A
Occasionally
what
will
happen
is
somebody
will
come
in
have
lost
it
pay
for
it.
A
week
later,
the
the
divorced
spouse
finds
it
drops
it
in
the
book
drop
and
all
of
a
sudden.
That
refund
is
there
and
we
have
to
clean
those
up
and
we
go
ahead
and
clean
those
up,
but
what
we
discovered
was
those
were
less.
It
was
less
staff
intensive
to
clean
that
up
than
it
was
to
clean
up
the
volume
of
of
long
overdue
fees
that
were
generated.
D
I
D
D
D
D
A
A
A
A
A
D
G
F
F
D
D
A
A
D
Whenever
we
turn
on
youtube
on
the
tv
when
we're
sitting
out
and
watch
tv
after
dinner,
if
we
put
on
youtube
it's
like
oh
there's,
another
video
from
bywater
from
that.
No
it's
the
monday
minutes
and
I'll
start
it.
My
wife
will
go
god
just
can't.
Just
not
you
know,
and
she
is
convinced,
there's
the
one
with
the
one
on
the
curbside
plug-in.