►
Description
Presenters:
- Fred King (MedStar Washington Hospital Center)
- Lauren Denny (Teamwork Library Consortium)
Slides:
- https://docs.google.com/presentation/d/19zFPtKTiDY6xmVlqiOEtCVKeykv5h9gB/edit?usp=sharing&ouid=106844837026229096502&rtpof=true&sd=true
A
A
A
B
A
A
You
may
have
figured
out.
This
is
not
a
cat,
it's
actually
our
smaller
dog
schooner
she's,
hiding
because
there's
a
thunderstorm.
She
is
50
pounds
of
Love,
exuberance
and
toenails,
and
occasionally,
if
you
look
at
my
arm,
there's
a
few
scars
occasionally
she
demonstrates
her
commitment
to
open
sores.
A
A
A
This
is
the
way
I
figured
out
how
to
do
it.
There
may
be
a
better
way.
You
might
be
able
to
use
a
hammer,
I
happen
to
have
a
wrench
handy
and
when
I
had
to
pound
in
some
nails,
but
you
probably
have
a
better
way.
This
is
the
way
I
can
do
it
and
regular
Expressions
would
do
all
sorts
of
wonderful
I,
don't
know
regular
expressions
all
right.
So
let
me
start
with
my
spreadsheet.
A
A
A
And
I
put
them
in
alphabetical
order
and
now
I
can
go
through
and
choose
the
ones
that
are
in
too
many
different
formats.
Andreas
McNeil
publishing
LLC.
Well,
there
should
be
a
comma
after
that,
as
barns,
Ampersand
or
and
Company
actually
Andrews
and
McBeal
Andrews
and
McNeil
Incorporated
Andrews
McNeil.
A
You
can
see
it's
not
really
typos.
It's
just.
The
publisher
has
gone
through
a
whole
lot
of
different
names,
and
you
can
do
this
with
any
column.
I
didn't
have
a
lot
of
duplicate
or
typos.
In
the
authors
when
I
was
doing
my
spreadsheet
I
had
some
abbreviations,
I've
bought
at
the
format,
dust
jacket
or
hardcover
or
torn
dust
jacket.
A
A
A
Actually
she
was
a
sort
of
a
co-author
and
proofreader
on
this,
but
you
know
not
everything
is
going
to
have
something
like
page
numbers.
A
lot
of
my
books
are
unpaginated,
though
I
went
through
and
gave
every
line,
P
space
p
period
and
then
looked
for
paragraph
return.
Space
p
period,
replace
it
paragraph
return
now.
The
only
ones
with
page
numbers
have
page
numbers.
A
Word
or
Excel
will
warn
you
sometimes
that
the
length
doesn't
match
what
you're
pasting
in
I
should
go
to
the
bottom
column.
Okay,
the
bottom
check
just
to
make
sure
you
really
built
in
suspenders
I,
am
create
new
column
and
paste
it
and
then
can
delete
the
old
one
learn.
Would
you
care
to
expound
upon
what
you
say
here.
B
I
add
a
column
beside
it
and
start
the
pattern
of
the
number
with
the
centimeters
and
adding
that
in
there
and
then
after
a
while
Excel
will
figure
out
what
I'm
doing
and
add
it
through
the
rest
of
the
column,
which
is
wonderful
and
great.
But
you
need
to
copy
and
paste
it
as
text,
because
Mark
edit
does
not
like
that
formula.
That's
creating
what
you
see
in
Excel
and
a
lot
of
times.
I!
A
A
But
now
comes
the
exciting
part.
This
is
our
larger
dog
Farley
and,
yes,
he
is
off
the
ground.
Actually,
this
is
the
part
where
I
start
using
the
converting
to
Mark
records.
So
it's
really
heavy
into
cataloging
jargon
and
I
realize
that
we
are
the
last
new
people
between
you
and
lunch.
So,
if
you're
getting
hungry-
and
you
don't
really
want
to
learn
Mark,
it's
okay,
you
can
leave
now
I'd,
like
a
few
of
you
to
stay
okay
when
I
put
in
my
original
tags.
A
A
Worked
for
me,
if
you
have
more
than
one
copy
in
the
book,
this
may
not
work.
I
wanted
to
put
the
item
specific
information,
All
In
952.,
and
if
you
don't
have
the
foggiest
idea
of
what
I'm
talking
about
go
to
this
address,
this
will
explain
Mark
tags
in
more
detail
than
you
could
possibly
ever
want.
A
A
A
A
This
will
not
your
first
go
through
is
probably
not
going
to
be
right,
but
that's
okay.
First
of
all,
if
you're
the
only
person
you're
Library
using
this
catalog,
it
doesn't
matter
as
much
as
you
think
you
do
also
you
can
go
back
and
change
them
later
and
remember.
I
said
you
couldn't
put
more
than
one
thing
in
952z,
which
is
public
note.
A
A
A
A
A
B
Sometimes
I
get
over
Adventure
adventurous
and
have
all
these
multiple
sheets
of
everything
that
I've
edited
in
the
same
Excel
file
instead
of
a
separate
one
and
I
have
to
remember.
Oh
I,
don't
want
that.
One
I
meant
this
one
to
convert
and
you
find
out
if
you're
on
the
right
sheet
or
not
when
you
get
to
the
screen,
because
your
headings
don't
match
what
you
want
it
to
match.
A
You
realize
that
this
we
designed
this,
so
that
would
work
the
first
time
this.
This
doesn't
happen
anyways.
Now
you
see
why
I
put
author
and
the
tag
in
the
first
two
rows
so
field
zero
I
want
to
map
to
700
a
and
I
want
to
put
in
an
indicator
actually
Lauren
wanted
to
put
in
the
indicators,
because
I
haven't
done
much
with
indicators.
B
A
A
A
And
Lauren
came
up
with
the
idea.
You
know
you
really
can
move
your
Excel
sheet
to
have
the
the
items
you
want
to
join
next
to
each
other
in
columns
wish
I
thought
of
that
and
afterwards
you
can
see,
there's
one
asterisk
front
of
that,
and
eventually
they
have
two
three
four
asterisks
anyway.
I've
put
in
all
my
data.
I
want
I
recommend
making
a
template
because
that
way,
next
time
you
do
this,
you
can
just
load
the
template.
A
A
A
B
The
Librarians
do
not
use
koha,
they
use
a
Google
form
which
converts
to
a
spreadsheet
and
then
I
add
their
books.
That
way,
I've
also
had
Librarians
or
volunteers,
not
Librarians,
I've
had
volunteers
to
help
me
catalog,
a
group
of
reprint
articles
that
were
in
filing
cabinets
and
I
did
not
want
to
teach
them
how
to
catalog
and
use
koha.
B
It
was
just
simpler
to
have
them
import
that
data
into
an
Excel,
spreadsheet
and
so
I
saved
the
template
so
that
every
time
I
would
get
a
spreadsheet
from
them,
which
could
be
a
month
later
or
two
months
later
or
three
months
later,
all
I
had
to
do
was
load.
The
template
back
in
I
didn't
have
to
go
through
the
whole
mapping.
The
fields
process
I
could
just
load
it.
It
convert
it
and
then
start
adding
or
editing
my
records
as
I
needed
to
which
saved
a
whole
lot
of
time.
B
The
problem
I've
run
into
is
remembering
which
template
goes
with,
which
project.
So
in
naming
your
template,
make
sure
that
it's
something?
That's
unique
enough
to
the
project
so
that
you
can
remember
oh
yeah,
that
belongs
with
what
I'm
doing
here,
instead
of
something
else,
otherwise
you're
going
to
have
to
either
start
all
over
again
or
load
every
template
individually.
To
remember
which
one
you
have
my
memory
doesn't
work
very
well.
Sometimes.
A
B
A
A
If
you
have
something
you've
uploaded
and
then
you
download
it
from
let's
say
export
data.
Mark
Mark
edit,
will
also
convert
from
MRC
to
MRK.
This
doesn't
really
belong
here.
It
doesn't
belong
anywhere
in
the
presentation,
but
Lauren
and
I
thought
we
should
mention
that
you
can
do
it
anyway,
was
to
be
on
the
safe
side.
B
You
want
to
add
Your
Mark
records,
you
have
to
be
an
MRK.
You
can
change
your
file
change
the
data
as
an
MRC
file,
so
if,
once
you
get
it
in
there,
you
remember.
Oh
yeah
I
wanted
everything
to
have
a
certain
field
with
information
in
it.
You
can
add
it
in
Mark,
edit
and
there's
other
videos
on
all
the
things
you
can
do
in
Mark
edit,
but
it
has
to
be
an
MRK
MRC.
A
A
A
A
A
What?
What?
If
you
want
to
add
that?
Well
until
next
time,
because
it's
discovered
a
lot
of
stuff
and
I
figure?
Most
of
you
are
half
asleep
anyway.
I
mean
this
is
the
third
day
of
the
conference.
But,
yes,
you
can
Mark.
Edit
will
do
you
know
batch
searching
and
you
can
convert
the
lccn
to
the
current
format,
search.
B
Have
fun
I
will
in
this
presentation
we
did
this
very
quickly.
It
does
not.
You
do
not
do
this
fast
I
mean
this
is
a
depending
on
how
many
fields
you
have
in
your
Spreadsheet
will
determine
on
how
long
it
will
take
you
the
for
me,
one
of
the
most
time
consuming
task
is
determining
which
Mark
field
I
want
to
use
for
my
column,
because
some
things
can
be
put
in
more
than
one
place,
and
so
that
and
I
don't
think.
A
Yes
and
you,
if
you
know
a
catalog
or
run
it
by
them,
I
ran
it
by
Heather
and
she's.
What
are
you
doing
with
the
actually?
She
works
for
a
Maritime
Museum
and
you
know
talks
like
a
sailor
at
times,
so
she
didn't
quite
say
it
that
way:
she's
going
to
be
holding
the
catalogings
meeting
later
this
afternoon,
I
hate
to
think
of
what
she's
gonna
talk
say
to
me.
Okay,
any
questions.
D
So
there's
somebody
Eugene
Espinoza
on
the
YouTube
chat,
saying
that
they
use
auto-generate
arguments
and
Mark
edit.
They
say
they
just
put
the
corresponding
fields
in
the
first
row
and
then
Mark
edit
uses
the
data
in
the
first
row
to
auto-generate
which
Fields
those
map
to
so
that's
just
a
comment.
It
looks
like
there's
a
question
right
here
in
the
room,
though,.
E
Well,
more
of
an
additional
resource
for
those
comfortable
with
the
command
line.
My
name
is
Rogan
I
work
for
equinox
and
I
often
run
into
this
task
in
migrations
and
in
the
Equinox
migration
repo
on
GitHub.
You
can
find
a
pearl
program
called
CSV
to
mark
that
does
the
same
sort
of
task
with
a
few
advantages,
including
being
able
to
automate
it.