►
Description
Recorded during the Fresh Perspectives conference.
Chat logs:
07:23:44 Rebecca Coert - APL: I have a report question :)
07:25:31 Lisette Scheer: SELECT LEFT (fieldname, 5)
07:30:16 Carol Pham: Is there a SQL library for ACQ?
07:31:16 Carol Pham: Omg, I can't believe I missed these. Thank You!
07:39:40 Rebecca Coert - APL: If you use Tab Separated Text (second option) you can format those when importing in Excel.
07:40:34 Rebecca Coert - APL: I find it cleaner than CSV
07:40:48 Heather Hernandez (she/her): Oh, come on--Slow Koha-US Cleanup TV!!!
07:42:48 Bob Bennhoff: Gotta run and go explain how lost items work to one of our libraries
07:43:04 Jason: Thanks Bob!
07:43:04 George - laptop: See you later Bob
07:49:11 Rebecca Coert - APL: that's great! Is this on the wiki?
07:51:04 Rebecca Coert - APL: LOVE the warning triangle!
07:54:20 George - laptop: Warning triangle video: https://youtu.be/__9M-tKxGdI
07:54:40 Barbara Johnson: /*BEGIN Re-sort Invoice table in desc order - RT 56230 1.31.19 lg*/$(document).ready(function () { if (window.location.href.indexOf("invoices.pl") [rightangledbracket] -1) { $(window).load(function () { var table = $('#resultst').DataTable(); // Sort by column 2 and then re-draw table .order( [ 2, 'desc' ] ) .draw(); }); }});
08:00:54 Jason: $("td[id^= + value +]")
08:01:28 Rebecca Coert - APL: [adorable!]
08:02:51 George - laptop: [attribute^=value]
08:03:09 George - laptop: selects everything with the attribute starting with "value"
08:05:04 Wally DesChamps: You all are blowing my mind with this...and I am loving it! I wish I was as adept as you are. I'm looking forward to continuing to learn more!!!
08:05:59 Heather Hernandez (she/her): It shows the community in action--that there's always support and help!!
08:06:20 Wally DesChamps: @heather … yes, indeed!
08:08:47 Rebecca Coert - APL: These meetings are so helpful and informative! Thank you!
08:09:39 Heather Hernandez (she/her): Kitteh!! ❤️
08:10:50 Victor Zuniga: Any tips/lessons learned on upgrading from an older Koha version (16.05.02.000) to the latest one? I think I read somewhere MySQL was replaced for a different DB server. Anything I should be aware of with compatibility/Schema issues?
08:15:07 Victor Zuniga: Thanks George!
08:15:13 Victor Zuniga: Thanks everyone!!
A
It's
just
admin,
it's
kind
of
nice
too,
because
like
they're
not
super
far
apart,
but
they're
like
almost
two
weeks
apart,
so
it's
almost
like
me
and
jason
meet
twice
a
month
and
talk
about
a
lot
of
the
same
things,
and
sometimes
other
people
are
there
web
doves,
usually
like
me
and
jason,
and
barbara
and
lucas
and
megs
from
bywater,
or
at
least
one
of
them,
and
then
sis
admin.
We
meet
the
second
tuesday
of
the
month
at
8,
pacific
9,
now
10,
10,
central
11
eastern.
B
A
A
A
A
C
C
B
A
B
E
B
A
A
But
what
we
might
want
to
also
do
is
not
group,
and
can
we
select
count
left,
maybe
because
we
or
something
because
we
might
want
to
also
see
do
like
a
do
a
union
and
do
one?
That's
not
the
short,
zip
but
regular,
zip
code
and
group
that
way.
So
we
can
make
sure
that
there's
any
that
have
five
digits
or
the
extra
four
digits.
A
B
A
D
I
was
just
reading
on
the
screen.
I
do
want
to
give
a
shout
out
to
michael
and
george.
Both
I
had
a
question
yesterday
regarding
a
report
that
is
pretty
complex
and
michael,
showed
me
exactly
how
he
did
it
already
independently
and
then
george
sent
me
an
email
saying,
hey.
I
think
this
would
work
and
they
were
pretty
similar
and
in
the
meantime
it
all
worked
so
now
I
know
which
actor
has
blu-rays
that
circulate
the
most
at
each
branch.
A
A
A
A
That
would
have
to
be
like
very
small
skyriding,
because
there's
trees
right
outside
my
window,
so
there's
like
not
very
much
space
for
snare
anyway.
So
this
is
a
great
resource
in
general,
just
the
library
here.
What
I
will
often
do
is
come
find
something
that
is
related
to
what
I'm
working
on,
even
if
it's
like
a
more
basic
version
or
a
more
complicated
version,
because
you
can
always
like
copy
it
in
and
then
edit
it
like.
A
I
almost
always
have
to
add
a
branch
selector,
because
if
I'm
just
putting
reports
in
and
running
them
a
lot
of
times,
they
come
up
with
a
lot
more
data
than
we
want,
because
I
have
48
libraries
in
my
consortium
and
so
like,
especially
if
you're
doing
anything
but
like
counting,
if
there's
not
very
many
limiters
and
if
you've
got
a
fair
amount
of
records
or
patrons
good
to
make
sure
you're
putting
in
limiters.
So
you
don't
crash
your
system
or
slow
it
way
down.
A
B
A
A
Is
it
a
different
table?
Name
now,
and
you
can
ask
anyone,
because
also,
if
you're
trying
to
find
something
and
you're
like
this
report's,
not
working,
you
know
you
can
send
it
out,
and
one
of
us
will
come
back
and
say:
oh
they
changed
that
table
name
two
updates
ago.
You
need
to
use
this
instead,
so.
B
B
Usually
you're
gonna
run
into
that
with
cataloging
reports
when
you're
querying
marked
data,
because
that
that
was
one
of
the
big
table,
changes
and
you'll
you'll
know
because
you'll
be
querying
the
wrong
thing
and
the
error
will
say
something
about
metadata
or
I
don't
remember
what
the
old
field
name
is
versus
the
new
field
name
but,
and
I
somebody
may
have
gone
through
and
cleaned
up
the
reports
wiki
when
that
change
happened.
I'm
not
sure.
A
Also
with
fines,
the
last
few
updates
have
had
a
number
of
updates
to
like
account
lines,
tables
and
stuff,
and
so
a
lot
of
old
fine
reports
also
don't
work
without
a
little
tweaking,
so
those
are
kind
of
the
big
ones.
Oh,
and
one
thing
that's
nice,
too,
is
it's
got
some
nice
at
the
top.
Here
it's
got
like
some
tips
so
like
how
to
do
a
link.
A
This
will
select
the
biblio
number
and
the
title
and
make
a
link
to
the
title
which,
like
don't
work
well,
if
you're
downloading
the
report
in
excel
format
or
if
you're
emailing
the
report
to
yourself,
but
they
work
nicely
when
you're
running
it
in
the
system
and
then
you
can
also
do
all
sorts
of
things
like
link
to
a
borrower
number.
Here's
like
a
link
to
renew
a
patreon
I've
set
up
links
that
can
like
edit
certain
like
when
we
start
when
we
turned
on
self
registration
at
the
start
of
the
pandemic.
A
F
F
That's
a
great
question
I
mean
I
just
when
I
you
know
sometimes
I'll
bring
data
over,
and
so
it's
like.
Okay,
so
it
gets
in
there,
but
I
always
have
to
take
my
isbn
or
barcode.
Something
comes
over
and
it's
got,
you
know
a
dot
and
two
extra
zeros
and
it's
like
okay
yeah
every
single
time
I
do
this.
I
have
to
go
and
clean
that
up.
It
just
seems
like
if
there
was
some.
B
F
B
And
then
something
else
you
can
do
that
I
stole
from
george,
I
think
it's
put
in
some
like
concatenate
some
characters
around
your
barcode
in
the
report
and
that'll
cause
it
to
export
the
whole
barcode
instead
of
like
collapsing
it.
But
then
you
get
those
extra
characters
too.
He
may
have
better
strategies
for
that,
and
I
saw
I
saw
you
ed
he's
not
there
anymore.
B
B
One
thing
that
I've
been
doing
with
reports
is
grouping
grouping
things
with
authorized
values,
which
is
something
I
saw
was
that
mentioned
in
slack
at
some
point,
so
I've
created
authorized
value
categories
of
authorized
values
and
then
use
those
as
my
drop-downs,
which
has
been
interesting.
I
also
did
one
for
genres,
so
it's
actually.
I
think
it's
it's
been
a
minute,
but
the
filter
is
querying
on
the
the
subject
fields.
B
A
E
A
So
in
authorized
values
I
set
up
this
collection
code
report
authorized
value
which
is
used.
This
way
I
can
run
reports
or
like
most
of
what
we've
been
using
it
for
is
whedon
collection
so
that
they
can
run
a
report
for
all
of
our
non-fiction
is
in
like
we
have
all
these
sub
collection
codes.
You
know
j00
to
0.99,
so
that
we
can
run
reports
on
smaller
parts
of
the
collection
if
we
want
to,
but
it's
annoying
if
you
have
to
run
like
12
reports
to
do
all
the
adult
non-fiction.
A
A
These
are
all
collection,
codes
and
it'll
basically
do
if,
if
it's
from
any
of
those
like
ores
in
the
report-
and
so
we
have
all
of
these-
and
I
didn't
end
up
putting
descriptions
in
the
opac
because
it
turns
out
we're
not
using
them
in
the
opec.
So
it
doesn't
really
matter
so
then,
if
we
go
to
thanks
mom
see
you
later.
A
A
And
we
have
a
lot.
This
is
a
lot
going
on
so
that
we
can
do
a
lot
of
different
things
with
it.
Basically,
you
do
have
to
have
all
the
collections
filled
out,
but
you
can
just
set
them
all
to
the
same
one
then
and
then
it'll
work
it's
kind
of
a
messy
report
to
be
showing
off,
and
then
you
can
say,
oh,
but
we
don't
want
this
call
number
range
for
whatever
reason,
maybe
that's
more
for
some
of
the
kids
stuff,
because
we
don't
have
collections
like
our.
A
Oh
that's
interesting.
I
came
up
with
a
bunch
of
my
specific
way
and
cheap
stuff
that
might
be
because
of
the
percentages
I
put
in,
or
it
might
be
that
some
of
these
are
catalogued
from.
We
did
find
a
bunch
of
the
word
catalog
wrong
when
we
first
did
this,
and
so
that's
just
like
a
nice
way
to
be
able
to
do.
A
A
B
B
Christian
fiction
and
then
the
pipe
which
is
the
or
and
then
religious
fiction,
so
I've
grouped
those
into
a
category
I've
grouped
fantastic
and
fantasy,
and
the
fantasy
paranormal
has
occult
fiction.
So
I
was
looking
at
the
authorized
subject,
headings
and
seeing
what
was
in
our
system
and
what's
used
a
lot
to
develop
these
categories.
And
then
I
can
use
that
in
a
report
over
here
and
if.
D
B
Subject
which
I've
pulled
out
the
subject
here
from
the
from
the
650a,
I've
also
pulled
out
the
genre
from
the
655.
so
down
here
I
can
do
a
subject
which
is
this
are
like
and
then
on
this
one.
I
picked
horror
stories
as
my
filter,
so
it's
looking
either
in
the
subject
or
the
genre
for
horror
stories
and
giving
me,
and
then
I
I
have
some
other
filters.
So
my
collection
code
is
adult
books.
B
My
location
code
is
anything
and
my
branch
code
is
iola,
so
it's
giving
me
all
of
the
iola
adult
books
with
that
genre
and
I'm
using
that.
I
wrote
this
for
collection
development
purposes,
so
we've
got
collection
development
grants
that
we
get
the
system
give
out
to
our
libraries
and
they
have
to
kind
of
hone
in
on
a
specific
section
of
their
collection
that
they
want
to
improve.
So
they
can
use
this
report
to
go
to
a
certain
genre
that
they
want
to
develop.
B
So
when
you
run
it,
it
looks
like
this.
I
just
ran
it
beforehand
because
it's
a
little
slow,
but
you
can
pick
the
genre
from
that
list.
I
showed
you
the
collection
code
if
you
want
to
filter
by
that
and
shelf
locations.
If
you
want
to
filter
by
that-
and
this
is
also
using
those
all
filters-
we
were
talking
about
a
little
bit
earlier-
I
guess
you
can't
see
it
there
so
for
the
genre
I
don't
have
one,
but
for
collection
code,
I'm
using
the
colon
all.
So
I
can
have
the
all
options.
B
A
A
A
Sounds
good
so
help
us
linked
that
with
the
warning
triangle,
which
is
separate.
We've
had
that
at
least
on
our
test
server
for
a
while.
I
don't
remember
if
we
actually
have
it
on
production
yet
so
these
look
at
like
a
span,
the
damage
span.
Does
it
contain
our
damage
status,
give
it
a
label
and
then
replace
that
with
the
label,
and
so
we
also
have
to
set
some
css
for
that
and
those
are
bootstrap
labels.
So
they
only
have
a
few
options
for
colors,
but
you
can
change
the
background.
A
B
B
A
A
A
A
A
F
B
A
A
B
H
H
B
D
H
H
A
B
A
A
A
A
A
H
Nothing
is
more
motivating
than
going
into
making
a
minor
change
to
a
piece
of
jquery
and
then
breaking
everything
and
spending
like
the
next
40
minutes
frantically
trying
to
get
everything
to
work
exactly
the
same
way.
It
did
a
half
an
hour
ago,
and
this
is
why
you
have
test
servers
so
that
when
you
do
something
like
that,
you
can
go
good
god.
Why
didn't
I
try
that
in
the
test?
Server?
First.
H
You
know
I
work
with
so
many
people
in
the
past
that
have
tried
to
do
these
things
and
as
soon
as
they
come
to
a
roadblock
they
as
soon
as
they
hit
a
brick
wall,
they
say:
well,
that's
it!
I
can't
do
it
and
they
give
up
and
that's
my
secret
is.
I
just
keep
pounding
my
head
on
that
brick
wall
until
I
knock
a
hole
through
through
the
wall.
H
D
C
B
It
so
that
when
I'm
showing
you
something,
it
looks
different,
but
it's
really
the
same.
I
I
will
just
add
that
I'm
a
librarian,
I
have
a
biology
degree.
I
didn't
go
to
school
for
this,
so
I,
if
I
can
learn
it,
you
guys
can
too
it
just
takes
practice
and
once
you've
got
the
foundation
down,
then
you
get
to
really
start
playing.
B
I
think,
like
I
love
these
meetings
that
we're
having,
because
I'm
getting
so
many
ideas
like
at
the
consortium
say
we
were
talking
about
putting
like
a
my
library
search,
I'm
like
oh,
I
could
do
it
this
way.
This
way,
this
way
so
gets
me
excited
just
thinking
about
ways
to
create
efficiencies
in
our
systems.
A
This
is
how
you
do
that,
so
you
go
to
the
catalog.
This
is
christopher's
catalog.
I
just
go
to
their
actual
catalog
fairly
frequently
because
my
director
really
likes
it
she'll,
be
like
oh.
I
saw
this
thing.
They
did
and
I'll
be
like
our
thing.
Does
that
too
you
just
don't
look
at
the
staff
side,
cattle
or
you
only
look
at
the
staff
side
catalog,
so
you
didn't
know
that.
But
if
you
right
click
and
view
the
page
source,
it
has
everything
and
there's
kind
of
a
lot.
A
A
We
all
try
to
put
comments
and
we
highly
recommend
putting
comments
in.
If
you
do
this
slash
slash,
that
line
will
be
commented
out.
I
harvested
from
jason
a
couple
years
back,
putting
a
bunch
of
dashes
in
so
that
it
like
stands
out
more
that
it's
the
start
or
end
of
a
session
section,
which
is
interesting
because
none
of
the
jquery
he
wrote
here.
B
A
A
And
so
I
think
that
must
be
gone
because
I
added
a
bunch
of
stuff
before
we
deleted
stuff
last
year,
including
all
those
comments,
and
then
you
can
just
find
whatever
it
is
and
copy
it,
preferably
into
a
test
server
or
whatever,
and
then
thank
whoever
it
is.
When
you
have
it
working
and
say
christopher
thanks
for
telling
me
about
labels,
I
wouldn't
cut
the
code
off
your
website
and
then
it
turned
out
it
needed
css,
which
I
also
found
off
your
website.
But
only
after
asking
you
about
it.
B
B
B
A
Yep
victor
asked
any
tips.
Lessons
learned
on
upgrading
from
an
older
cohort
version
to
the
latest
one
I
think
I
read
somewhere.
My
sequel
was
replaced
with
from
a
different
database
server.
Anything
I
should
be
aware
of
with
compatibility
schema
issues.
Well,
there
have
been
a
number
of
table
updates.
We
talked
about
that
a
little
earlier,
so
a
lot
of
your
reports
might
die.
H
There
have
been
some
table-ish
table
updates.
I
think
what
what
victor
might
be
getting
at
is
that
a
lot
of
libraries
koha
is
generally
run
for
a
long
time.
The
database
was
my
sequel
and
then
there
is
a
fork
of
my
sequel
called
mariadb
and
at
some
point,
around
17
or
so
most
koha
libraries
started
moving
their
data
from
my
sequel
to
mariadb.
B
H
H
The
most
significant
area
in
the
I
guess,
the
nine
years
now
that
I've
been
using
the
most
significant
changes,
have
happened
to
the
account
account
lines,
because
koha
has
gone
through
a
major
renovation
in
how
it
handles
fines
and
lost
sight
and
replacement
any
money
that
you
build
at
the
patron.
That
whole
system
has
changed
dramatically
and
all
for
the
better.
In
the
last
nine
years,.