►
From YouTube: Cataloging Special Interest Group - 4/1/2021
Description
Chat logs:
00:00 - Intro
00:17:40 Jason Robb: TrackClicks
00:17:44 Jason Robb: SELECT biblionumber, url, COUNT(1)FROM linktrackerGROUP BY biblionumber
00:17:59 Heather Hernandez (she/her): This is the part of the manual about that syspref: https://koha-community.org/manual/20.05/en/html/systempreferences.html?highlight=clicks#trackclicks
00:20:01 yuyan : Thank you, Jason and Heather for the info
00:20:34 Heather Hernandez (she/her): This report is great, Jason!!
00:25:22 Holly Cooper: are you thinking batch bib. record modification or batch item modification?
00:26:05 Bruce Metcalf: I'm thinking of direct, single record imports. Haven't learned batch processing yet.
00:26:37 Heather Hernandez (she/her): This is a PTFS video, https://youtu.be/8UItQHclmP4
00:27:19 Heather Hernandez (she/her): ...about batch editing w/the MARC modification templates.
00:33:35 Jason Robb: Here's the official repo link: https://gitlab.com/koha-community/Koha/-/tree/master/koha-tmpl/intranet-tmpl/prog/en/xsltThe Del952.xsl, Del995.xsl sheets should be able to be applied to records on import via Z39.50, those sheets are added in the admin area for each z-target
00:34:56 Heather Hernandez (she/her): https://youtu.be/pFFrYX_zKYI
00:37:14 Leanne Cooper: yes—our OCLC gateway acts up after an upgrade—needs to be reconnected
00:37:17 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17485
00:42:50 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26955
00:43:39 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26373
00:44:33 yuyan : Jason, I used your report to trackclicks, but I didn't get any result by running the report. Should I also add time periods to the report? what did I do wrong?
00:45:45 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26836
00:46:39 Jason Robb: I think the track clicks will only track clicks moving forward, so it won't have any results until a link is clicked. You can try clicking one in the OPAC then rerunning the report.
00:46:55 Barbara Johnson: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27363
00:53:45 Jason Robb: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28072
00:54:14 Holly Cooper: I was the same way when I started submitting bugs!
00:55:59 Heather Hernandez (she/her): Editing mana reports https://youtu.be/AVmw7f1hL8g
01:00:09 Heather Hernandez (she/her): Yes--"List of URL's from 856" is on the Koha report wiki!
01:14:19 Leanne Cooper: Thank you everyone!
A
B
So
only
two
two
months,
so
I
just
I
found
that
result.
The
data
was
like
amazing,
because
I,
when
we
first,
our
director
wants
to
track
actually
how
we
use
the
856
the
link
for
the
like
yearbook,
all
those
online
things.
We
have
those
electronic
resources
he
his
purpose
he's
a
is
any
way
we
can
track
in
koha
like
get
a
report
or
something
like
how
many
times
and
then
the
link
was
clicked.
B
So
koha
cannot
do
that
right
now,
so
they
said.
Maybe
you
can
try,
google
analytic
analytics,
so
I
we
just
so
that's
how
we
start.
Oh,
I
still
don't
know
how
to
use
to
track
conduct
tag
856
in
koha
in
in
the
opec,
but
at
least
I
can
get
a
general
idea
like
how
our
opec
be
used
so
that
that's
the
kind
of
surprise
by
products.
I
guess.
C
D
C
B
C
B
C
B
C
E
B
D
G
B
G
H
H
H
Well,
another
thing
that
had
come
up
before
we
started
recording
was
another
thing
that
you
young,
mentioned
that
in
using
the
duplicate
item
you
duplicate
an
item.
It's
also
duplicating
the
barcode,
which
then
has
to
be
edited.
Does
any
we
don't.
I
haven't
used
that
feature
much
since
upgrading
to
20.05.
H
B
B
Of
in
the
beginning
that
also
confused
me,
I
said:
what's
because
we
use
think
about
number.
Is
the
item
number
right?
Actually,
it's
a
different
thing
in
incoha,
barcode
number
in
cohort
was
like
p,
as
I
don't
know
what
he
called
a
p
stands
for
barcode
and
number.
Nine
was
a
koha
item
number,
which
every
kohake,
I
think
every
item
automatically
generate
the
number.
So
these
number,
when
I
for
instance,
I
open
one
of
the
item.
The
number
was
the
2
to
262
the
item
number
from
cohan.
B
Then
I
I
duplicate
this,
then
this
two
two
two
sixty
two
will
be
duplicate
to
the
next
one.
Then,
if
I
don't,
I
certainly
I'll
give
a
barcode
also
for
this
new
new
copy.
But
if
I
don't
get
rid
of
this
two
to
two
sixty
two
in
item
number,
which
once
I
see
they
will
say,
hey,
we
need
a
unique
item
number
so
once
I
get
rid
of
it,
then
the
the
system
will
automatically
generate
a
new
item
number
for
the
new
copy
I
create,
which
is,
is
correct.
B
G
Yeah,
this
is
off
my
pink
post-it
note.
When
I'm
importing
things,
it
will
often
import
a
lot
of
local
data
that
I
have
no
use
for
and
which
is
just
a
source
of
confusion,
and
I'd
also
like
to
insert
a
few
things
like
the
classification
source
and
in
our
own
code,
and
I'm
wondering
if
there
is
a
way
to
do
that,
to
omit
some
fields
from
being
imported
and
to
force
some
fields
into
particular
values.
H
B
Yeah,
I
think
here
well,
you
can
do
that.
I
think
I
did
that
I
think
set
up
a
template
or
something
like
that
which,
when
I
import
something
I
will
apply
that
template
they
will
take.
The
template
show
me
maybe
take
off
the
general
and,
for
instance,
I
took
of
like
0
42
off
and
few
feel
that
I
don't
need,
and
I
just
in
the
template
after
they
take
over
when
they
do
the
matching
and
they
get
rid
of
some.
B
Also
I
insert,
for
instance,
maybe
I
insert
notes
590
notes,
or
maybe
an
eight
fifty
yeah,
also
on
like
ebook,
eight
fifty
six,
for
instance,
for
a
nexus
digital
library
ebook.
I
will
add
the
notes
on
the
856
y
subfield
says:
click
carrying
the
edition
there
clinic
here
for
carrying
the
addition
of
this
title,
something
like
that.
So,
whatever
you
want
to
write
so
every
time
I
do
that
they
just
authenticate
once
and
use
that
template
they
automatically
will
get
rid
of
some
field
tag
and
add
some
tag
I
need
so.
B
B
C
It's
like
the
last
field
when
you're
setting
up
a
target
that
lets
you
transform
things,
and
I
can't
find
the
exact
link
to
it.
But
I
found
this
link,
which
is
someone
else's
gitlab,
but
the
the
style
sheet
is
there
and
it
talks
about
deleting
the
995
field
on
z,
39,
50
import,
so
that
that
may
be
also.
G
G
G
G
G
G
G
H
G
H
B
H
G
E
H
H
Well,
bruce
is
looking
for
that
system.
Preference
I'll
also
mention
the
one.
Other
question
that
I
had
gotten
ahead
of
time
is
kind
of
cis,
and
many
some
people
had
noticed
that,
after
upgrading
to
20.05,
they
had
to
do
a
lot
of
restarts,
especially
dealing
with
the
z
3950
gateways,
wondering
if
other
people
had
noticed
that
as
well.
C
C
I
I
put
a
bug
in
this
is
regarding
your
earlier
discussion
about
not
bringing
in
certain
fields
from
a
z39
import
and
that's
something
we
want
to,
because
we
get
all
kinds
of
gobbledygooks
and
we
have
to
strip
it
out
yeah.
So
I
started
a
ticket
with
bywater
and
we
got
into
the
excess
lt
when
you
can
transform
the
results
using
the
xslt
when
you
set
up
your
z39
server,
but
that
wasn't
really
doing
what
we
wanted,
and
I
think
I
remember
them
saying
that
was
really
more
for
authority
records
yeah.
I
And
then
I
remember
several
months
ago.
Ann
was
here
and
she
was
talking
about
things
and
it
sounded
like
whichever
group
is
over
there
in
new
zealand
that
they
were
already
sort
of
working
on
some
kind
of
a
development.
So
I
added
to
the
ticket-
and
I
asked
nick
if
he
could
look
into
that,
and
that
1745
ticket
is
what
he
came
back
with
and
said
that
you
know
that's
kind
of
out
there
being
looked
at,
but
it
I
don't
think
really
much
has
happened
on
it.
D
C
E
C
E
C
Now
let
me
find
the
right
tab
this
one
okay,
so
I
went
to
administration
mark
frameworks
and
then
I'm
just
in
my
default
framework,
I
navigated
to
the
952
subfield
and
then
it
looks
like
it's.
The
cn
browser
is
the
plugin
and
you
want
to
put
that
on
your
o,
which
is
your
call
number
field,
so
I'm
just
going
to
save
it
and
see
if
I
break
anything.
C
A
C
D
D
C
I
I've
probably
brought
some
of
these
bugs
up
before,
but
I
always
would
love
for
other
people
to
go
into
bugzilla
and
comment
on
them.
This
one
is
the
ability
to
rename
a
macro
you've
when
you've
created
it
and
then,
if
you
decide
well,
that's
not
really
what
I
want
to
call
it.
You
have
to
start
from
scratch
and
it
would
be
nice
to
be
able
to
just
rename
it.
I
We
have
some
certain
notes
that
are
brought
over
in
our
order
record
and
we
they're
in
marked
fields
that
we
don't
use,
but
they
they
come
over
specifically
in
those
fields,
and
we
know
to
look
for
them.
It's
kind
of
a
communication
from
the
selector
to
the
cataloger
they'll
disappear
when
we
overlay
the
record.
But
during
that
initial
part
it
would
be
helpful
to
be
able
to
sort
of
highlight
certain
things,
and
so
that's
that.
D
H
I
H
G
I
You
can
have
your
z39
targets
and
you,
when
you
set
them
up,
you
can
say
that
your
some
of
them
are
default.
You
can
do
that
if
you
want
to
so
they're
pre-selected,
but
when
you're
cataloging
you
could
maybe
not
find
what
you
need
from
those
pre-selected
targets,
so
you're
selecting
other
targets
and
those
would
stay
selected
throughout
until
you
went
in
and
unchecked
them,
and
that
was
helpful
to
us
because
I
don't
always
want
you
know.
Maybe
something
checked,
but
now
I'm
doing
spanish,
and
so
I
want
to
go
and
select.
I
You
know
a
couple
different
targets
that
I
don't
normally
use
and
those
would
be
retained
while
I'm
I'm
doing
that
cataloging,
but
after
the
2005
upgrade
every
time
you
select
something
new,
it
disappears
and
you
have
to
reselect
it
every
single
time
and
it's
just
a
real
time,
efficiency
problem
for
us,
so
that
one
we're
really
hoping
it
used
to
work,
and
I
think
in
the
beginning
they
said
well.
It
was
sort
of
like
intended
to
never
work
that
way.
I
I
C
Group,
I
guess
I
started
writing
a
bug.
I
I
don't
know
if
you
all
remember
way
back
when
I
was
like
hey
it'd,
be
great
if
the
targets
could
be
part
of
mana
kb
and
I
was
gonna
write
a
bug
and
I
never
did
so.
I
thought
maybe
we
could
walk
through
entering
that
bug
together.
So
everybody
sees
how
easy
that
is.
Yes,
so
let
me
share
my
screen
again
and
that
way
I
can
feel
more
confident
with
you
guys
like
backing
me.
H
H
C
E
C
If
I
were
filing
a
bug
that
I
found
on
my
system
and
I'm
running
2005,
I
would
definitely
leave
that
version
as
2005
just
so.
They
know
that
it
might
be
happening
in
my
version,
but
it's
not
happening
in
master,
and
then
I
wrote
some
verbage
here
already,
so
I'm
just
gonna
paste
that
in
and
if
you're
worried
about
duplicating
a
bug
ticket,
that's
don't
be
because
there's
people
that
go
through
and
de-duplicate
them
all
the
time,
and
it
does
give
you
some
like
options
here
to
check
against
to
see.
C
C
H
C
So
I'm
going
to
there's,
I
not
gonna,
prove
myself
for
typos,
I'm
just
gonna
hit
submit
a
bug
and,
and
there
we
go
so
it
added
the
bug
to
the
bug
tracker.
It
automatically
copied
me
on
it,
because
I'm
the
one
who
filed
the
bug
and
these
people
will
get
the
they'll
get
notified
that
the
bug
was
filed
and
then
they'll
sort
it
out
to
the
person
that
needs
to
see
it.
C
C
Yeah
and
it's
crazy
how
fast
some
sometimes
things
do
get
fixed
like
I
had
one
last
week
where
I
wanted
to
get
club
holds,
I
wanted
data
tables
added
somewhere
and
I'm
like
this
really
needs
to
happen
and
like
within
the
next
day.
It
had
been
patched
and
signed
off
by
someone
else.
So
if
you're
having
little
problems
that
you
think
that
you've
been
ignoring
because
you
are
nervous
about
filing
bugs,
don't
be
it
can
it
can
benefit
everyone
and
quickly.
G
G
G
H
H
H
B
C
A
A
H
C
H
No,
I
mean
it
really
is.
It
is
fun,
I
think,
especially
when
you
work
behind
the
scenes,
because
we're
all
here
to
make
our
resources
discoverable
so
that
and
since
in
cataloging
we
don't
typically
get
a
lot
of
interaction
with
users.
It's
one
way.
We
could
see
the
the
resources
we
can
see
directly.
The
resources
are
being.
H
B
B
C
E
A
C
I
C
I
I
And
so
I
kind
of
had
to
go
back
and-
and
you
know
recall
how
it
was
supposed
to
work.
So
I
had
to
go
back
and
watch
the
videos
and
realize
that
I
needed
to
be
able
to
get
both
have
a
direct
link
to
cloud
library,
but
have
one
that
was
that
login
to
cloud
library,
and
I
think
most
of
it's
working.
It's
just
some
style
things.
C
C
Pull
it
up
instead
of
giving
like
in
the
the
stuff,
like
you
were
talking
about,
placehold
checkout,
it's
just
got
can
underscore
wish
and
it's
just
text
and
then,
when
I
go
over
to
cloud
library
it
it
says
that
I
can
suggest
that
title
for
purchase,
but
we
don't
actually
own
it.
So
I
was
wondering
if
you'd
run
into
that.
C
And
then
on
the
staff
side
it
just
spins
like
it's
got
that
fetching
cloud
availability
and
it
just
doesn't
do
anything
I
might
have
to
open
a
ticket
and
see
if
nick
has
any
insight
on
that
it'd
be
good.
If
we
could
exclude
those
from
the
catalog,
because
I
think
it
might
confuse
people
it
confused
me,
so
I
may
be
able
to
just
hide
them.
C
C
C
C
It
it
like
faults,
the
can
wish
so
and
then,
if
I
go
actually
out
to
the
cloud
library
log
in
so
you
can
see
what
that
actually
looks
like
I
get.
This
suggest
the
library
button,
but
we
don't
actually
own
it,
and
that
may
be
just
something
like
our
whole
cloud.
Library
collection
is
managed
by
the
state
library,
so
that
may
be
something
they've
turned
on
that
you
don't
have
turned
on,
so
you
don't
have
to
worry
about
it.
E
E
C
I
C
F
F
It
sounds
fantastic,
so
we
actually
use
the
templates
for
three
purposes.
We
have
them,
set
up,
diff,
no
same
template,
so
we
we
use
templates
for
loading
records
through
the
through
the
ordinary
batch
process.
Although
we
have
that
automated
too,
and
then
we
use
the
same
templates
for
individual
z3950
loading
of
records
when
enough
cataloguers
need
to
do
that,
and
then
we
also
have
templates
set
up
to
use
when
we
extract
records
for
our
customers.
F
So
we
use
them
an
awful
lot
and
that's
one
of
the
things
that
I
wanted
to
ask
is:
are
there
any
gurus
out
there
that
that
are
real
experts
in
in
setting
and
creating
template
actions,
because
I've
got
a
lot
of
experience
of
doing
this
in
market
it?
But
kohar's
language
is
not
quite
the
same,
and
and
I'd
really
like
to
leverage
off
any
any
expertise
that
there
is
out
there.
C
F
H
H
J
F
So,
which
organization
are
you
with
anne?
I
work
for
wheeler's
book
supplies,
so
we're
a
vendor
that
supplies
shelf-ready
materials
to
public
libraries
throughout
new
zealand.
So
I
have
my
team
work
with
approximately
20
or
so
different
public
libraries
with
all
requiring
different
extra.
You
know
customizations
applied
to
their
records,
so
customization
is
something
that
we
have
to
do
an
awful
lot
of
yeah.
F
So
we
we
moved
to
acquiring
koha
to
make
the
what
which
we're
calling
our
koha
workspace
to
enable
that
that
whole
customization
process
to
work
a
lot
more
smoothly.
Then
the
process
of
extracting
stuff
from
oclc
joy,
joy
and
cataloging
on
oclc,
even
more
joy
like
so
not
and
and
then
applying
using
marketer
to
apply
transformations
and
then
extracting-
and
you
know
it's
so
what?
H
F
F
So
yeah
pretty
much.
I've
spent
the
last
year
defining
the
changes
that
we
needed
to
make
to
the
advanced
editor
and
then
getting
catalyst
in
new
zealand
to
write
them
and
apply
them
for
us,
and
that's
been
a
long
and
involved
and
really
complex
process.
And
I'm
not
something.
I
want
to
repeat
again.