►
Description
Someone had a question, and guess what! We had an answer! Not only that, we had two! Join us as we go over 2 past episodes and provide some new content for one of our past hacks and a WordPress plugin we featured recently. There is always something new to learn with The Terrific Ever-Other-Thursday Training Videos.
Referenced code: https://wiki.koha-community.org/wiki/JQuery_Library#Add_database_placards_in_search_results_based_on_keywords_.28v20.x.29
Additional Resources: https://wordpress.org/plugins/library-bookshelves/
Music: https://www.bensound.com
A
Today
is
going
to
be
a
different
kind
of
day,
we're
doing
a
follow-up
on
a
couple,
different
topics
that
we've
done
in
the
past.
We've
had
some
questions
and
some
things
that
we
wanted
to
show
how
to
to
work
around
in
order
to
make
those
enhancements
work
better
for
you
and
have
so.
You
would
have
a
better
understanding
of
what
you
could
do
with
them.
A
B
I
can
say
specifically:
we
had
a
question
from
ed
veal
in
mckinney
texas,
about
episode
15,
which
is
called
jquery
and
css
placards,
and
then
the
other
one
is
a
follow-up
from
the
library
bookshelves
wordpress
plug-in.
It
was
an
issue
that
I
discovered
and
I
had
to
come
up
with
a
workaround
for
writing
the
report
to
get
the
isbns.
A
B
A
A
B
A
Code
right,
so
I
added
a
couple
variables.
I
added
one
for
the
placard
row,
the
first
instance
that
it
shows
up
and
then
a
second
row,
and
then
you
can
put
in
the
the
value
of
the
exact
location
that
you
want
to
show
up.
I
also
set
it
up
so
that
you
could
stick
in
a
zero
and
it
would
disable
that
particular
row.
A
So
I'm
going
to
pop
over
to
our
demo
site,
where
I
I
set
that
up
and
so
here's
those
two
variables.
We
have
a
placard
row
and
then
we
have
placard
second
row
and
I
have
that
set
up,
so
it
shows
in
the
second
location
and
the
fifth
location,
and
I
I
grabbed
the
information
from
our
site
so
that
I
would
have
images
and
variables
ready
to
use
rather
than
trying
to
reinvent
everything
for
the
demo.
A
A
So
here's
the
second
row
that
shows
up
and
then
my
or
excuse
me
excuse
me
row
two
is
the
first
instance
first
row
that
shows
up
and
then
row
five
was
the
second
time
so
one
two
three
four
five:
it's
not
numbered
with
the
rest
of
the
rows,
but
here's
where
the
second
instance
shows
up
and
if
we
go
back
and
look
at
that.
So
if
I,
if
I
like,
I
said
if
I
wanted
to
disable
a
row,
I
could
put
a
0
in
there.
A
B
A
So
this
is.
This
is
the
first
instance
of
that
that
placard
in
here
right
there.
It
is
so
it's
looking
for
a
row
and
because
I'm
using
a
before
statement
to
insert
that
placard
it's
using
a
subtraction
of
one
of
whatever
value,
because
I
wanted.
I
wanted
the
the
values
to
be
straightforward,
for
you
know,
person
plugging
in
those
values,
and
so
it's
doing
a
subtraction
here
from
that
to
get
the
correct
placement
in
that
before
the
next
section
is
checking
for
the
second
row
right
and
it's
logic
is
a
little
bit
different.
A
It
is
checking
to
make
sure
that
you
know,
of
course
the
table
exists,
but
then
it's
also
checking
to
make
sure
that
the
value
of
the
second
row
is
greater
than
zero,
because
zero
disables
and
then
it
also
is
making
sure
that
the
the
placement
exists.
You
know
if
you've
said
row
12.
Are
there
12
rows
for
it
to
insert
it?
So
if
it
doesn't
exist,
then
it's
not
going
to
place
that
placard
and
then
of
course,
here's
the
the
positioning
of
that
that
that
placard
with
that
value
minus
one
because
of
the
before.
A
A
B
B
From
we've
got
them
set
to
map
to
biblioitems.isbn
in
the
database,
and
we
have
many
items
that
have
multiple
isbns
and
so
when
they're
stored
in
that
table,
they're
stored
with
a
pipe
separating
them
right.
I've
also
got
issues
where
you
know.
We've
got
this
one,
whoever
downloaded
the
record
from
z3950,
didn't
clean
up
this
extra
data
in
here
that
says
hardcover.
So
this
isn't
just
a
number-
and
you
know
so
these
are
all
kind
of
a
little
bit
messed
up
yeah.
B
B
B
B
So
this
report
is
getting
me,
the
the
13
digit
isbn.
It's
got
the
10
digit
isbn.
It's
got
all
these
isbns
with
all
this
junk
daddy
in
it,
and
so
that's
why
you
know
I've
only
got
out
of
that
whole
list
of
isbns.
I've
only
got
two
that
are
a
single
10
digit
isbn
the
ultimate
desert
handbook
and
enter
the
enchanted,
which
are
you
know
the
two
things
that
actually
are
showing
up
in
my
bookshelf
wow.
So.
A
B
B
I'm
not
going
to
remember
the
number
for
it
now
here
we
go
bookshelves
test
report,
so
this
is
the
new
report
that
I
wrote
and
what
I
had
to
do
was
come
up
with
a
way
of
making
sure
that
the
data
I
get
from
the
isbn
field,
biblioitems.isbn
that
I'm
just
getting
a
10
digit
isbn,
which
involves,
and
I've
got
a
result.
You
know
you
can
see
right
here.
I've
got
now
a
list
of
a
whole
bunch
of
items
that
just
have
a
10
digit
isbn
and
the
trick
is
writing
the
report.
B
B
And
so
what
it's
doing
is,
like
I
said
those
the
when
you
have
multiple
isbns
in
biblio,
isbn
they're
going
to
be
separated
with
a
pipe,
and
so
what
this
first
line
is
doing.
Is
it's
saying
if,
if
biblio
items
we're
going
to
look
at
that
and
we're
going
to
find
the
first
pipe
and
we're
going
to
look
at
the
data
to
the
left
of
that?
And
if
that
data
is
10
digits
long,
then
we've
got
a
result
and
that's
all
I'm
going
to
look
at
is
that
first
10
10,
digit,
isbn
and.
B
B
If
you
got
more
than
ten
just
give
up,
because
if
there's
that
much
data
in
there,
then
you
you've
got
other
issues
going
on
than
just
trying
to
find
a
10
digit
isbn
we
do
have
like
I
said
you
know,
our
cataloging
is
not
academic,
cataloging,
it's
public
library,
cataloging.
So
a
lot
of
cases.
If
they're,
it's
not
unusual,
to
have
different
editions
on
the
same
bibliographic
record
and
sometimes
they
get
merged,
and
so
it's
not
uncommon.
A
B
Yeah
you
could
go,
you
know.
All
you
got
to
do
is
keep
adding
this
section,
the
section
at
the
end
and
just
upping
the
numbers
from
10
to
you
know
you
can
go
as
as
high
as
there
are
numbers,
and
so
that's
what
we're
doing
here
is
is
so
that
this
whole
set
here
is
just
trying
to
isolate
and
find
the
first
10
digit
isbn
in
that
in
that
field,
and
then
it.
B
B
Added
a
whole
bunch
of
where
clauses,
so
I
can
say
I've
got
a
placeholder
here
for
items
home
branch.
So
if
I
get
a
call
from
the
atchison
library
and
they
want
to
put
this
plug-in
on
their
on
their
website,
I
can
just
copy
and
paste
this
whole
report
and
change
this
wild
card
to
atchison
and
the
same
is
true:
I
can
go
through
well.
One
of
the
where
clauses
here
is.
If
the
biblio
number
there
has
to
be
data
in
that
biblio
items
isbn.
B
If,
if
I
don't
have
any
data
there,
then
I'm
not
even
going
to
examine
that
one
right,
but
I've
also
got
a
wild
card
here
as
a
placeholder
for
item
type,
one
for
location
and
one
for
collection
code,
and
then
I
added
not
for
loan
damaged,
item
lost
and
withdrawn.
I've
got.
I
decided,
I
didn't
want
this
bookshelves
report
to
be
showing
things
that
can't
be
loaned.
What
was
the
point
of
that?
B
So
I've
got
all
my
variables
there
set
so
that
if
the
item
can't
be
loaned,
it
just
won't
show
up,
and
then
the
very
last
thing
here
is.
If
I
get
to
the
end
of
this
whole
string-
and
I
don't
find
any
10-digit
numbers-
I've
got
the
ultimate
result.
If
there
are
no
10-digit.
Isbns
is
just
a
big
letter
x,
and
so
I'm
saying
don't
show
me
the
ones
that
have
an
x
there
there's
no
point
in
having
those.
B
B
B
B
B
Here's
the
the
way
that
I
structured
it,
so
I
just
got
rossville
I
took
out
that
wild
card
for
home
branch
and
put
in
rossville
item
type
his
book
and
location
is
adult,
and
this
is
the
rossville
website
and
down
here
at
the
bottom.
We've
got
these
two
bookshelves
that
are
right
front
and
center
on
their
home
page,
and
they
certainly
do
look
a
lot
better
than
they
would
if
there
was
only
like
two
results
there.
B
B
That,
if
you're,
if
you're,
going
to
try
to
use
the
amazon
cover
images,
you've
got
to
have
the
the
report
structured
so
that
it
will
actually
get
the
amazon
cover
images
right,
and
I
think
I
think
there
are
probably
a
lot
of
libraries
that
don't
have
the
synthetics
or
I
don't
remember
what
all
the
other
options
were.
There's
several
options
available
for
gathering
the
cover
images.
Aren't
there.
B
I
have
never
heard
of
cops
calibre,
o
p
d
s
chili
fresh,
you
know,
there's
all
these
different
options.
So
right
you
know
whatever
my
guess
would
be.
You
know
I
encountered
this
because
we're
getting
the
cover
images
from
amazon,
but
it's
possible
that
that
report
may
also
need
to
be
tweaked
if
you're,
if
you're
getting
them
from
some
of
these
others,
it
kind
of
depends
on
how
they're
configured
so.
B
B
There
was
also
just
a
tiny
bit
of
desperation
on
my
part
because,
like
I
said,
I
told
dan
and
robin
who
managed
these
wordpress
sites
for
all
our
libraries,
hey,
take
a
look
at
this
video
and
then
dan
looked
at
it
and
then,
like
two
days
later,
he
had
a
question
from
the
rossville
library.
We
would
like
to
do
something
and
then
dan
said
it's
just
like
that
thing.
George
had
me
watch
the
video
about
and
then.
B
A
Well,
george,
thank
you
very
much
for
for
sharing
that
information
and
ed.
Thank
you
for
asking
your
question.
If
you
have
more
questions,
feel
free
to
comment
in
our
videos,
we'll
try
to
keep
up
on
those
comments.
They
don't
come
through
very
often,
but
we
will
keep
an
eye
out
on
a
regular
basis
and
try
to
answer
those
questions
as
we
can.