Versions Compared

Version Old Version 6 New Version 7
Changes made by

Melanie Shaw

Melanie Shaw

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

10/24/2023

...

Instructions for the Perpetual Collections

Additions files sometimes appear for the older purchased collections but spot checking always shows that the titles/records are already in Sierra.

So should be able to ignore any "additions" for American History in Video, Ethnographic Video Online, and North American Women's Letters and Diaries

Actual new additions show up for the 3 more recently purchased collections, so these do need to be edited and added to Sierra.

Remember to add records for the new collections:

Royal Shakespeare Company Collection

Royal Shakespeare Company Collection purchased for perpetual access Dec 2020

National Theatre Collection

The National Theatre Collection purchased for perpetual access Dec 2020

Broadway HD Collection

BroadwayHD Collection purchased for perpetual access Dec 2020

...

example of Additions split by collection:

additions-delta-Aug-2023--Sep-2023

open to see indivdual folders (several single mrc bib files

Academic Video Online/ Premium

1,594

American History in Video

127

spot-checked.  These are already in Sierra, not new.

Ethnographic Video Online/ Volume I

55

spot-checked.  These are already in Sierra, not new.

The Royal Shakespeare Company Collection

1

NEW title, add to Sierra

Editing Academic Video Online/Premium

Loader: LOAD Streaming Video can OVERLAY on bib # (.streamingvideo)

use MarcEdit to join individual MARC records into a file for editing and loading

:

Join two or more MARC files into one

markers/hooks:

  • bib 830:

  • item location:

  • item code 1

  • internal note:

  • AVON - Academic Video Online.

...

  • cocre (Online Academic Video Online (USU and USU Eastern))

...

  • 20

...

  • AVON - Academic Video Online subscription

...

Edits

Loader: LOAD Streaming Video can OVERLAY on bib # (.streamingvideo)

Editing AVON:

Unicode

001

check 001 and edit if straight digits only

add prepend of ASP

for additions and deletions: check 001 and edit if straight digits only

=001  99238610100971

add prepend of ASP

  • Find: =001 (with 2 spaces)

  • Replace: =001 ASP

=001  ASP99238610100971

830 add

Add Field

\0$aAVON - Academic Video Online.

856 - edit subfield

delete

provided subfield z

add |z

Available online; click to view.

add prepend

Edit subfield

Delete these fields:

  • 901

  • 905

  • 910

  • 941

  • 942

  • 943

  • 944

  • 945

  • 950

  • 980

  • 951

Add/edit with Global or Rapid update

Add/edit with Global Update or Rapid Update after loading with Streaming Video loader:
item location:
item code 1:
item internal note:

Loader: LOAD Streaming Video can OVERLAY on bib # (.streamingvideo)

Add/edit with Global Update or Rapid Update

item location:
item code 1:
item internal note:

cocre
20
AVON - Academic Video Online subscription

CSDirect says Rapid update can:
insert new non-MARC variable-length fields.
change the value of fixed-length fields.

See note below for possible problems

Note that a recent update had problems with overlay:

  • Many records loaded as new instead of being rejected on 001 match because of 001 changed, so no match even though it's the same record.

  • Did cleanup in this way: Using review file of today's 850 loaded new AVON records, exported into Excel the 024 fields.

  • Saved those values as text file in Brackets. In Create Lists, imported the file of 024 values using the Import Records function,

  • based on Index of "o Control Number." This resulted in a new review file of 634 records previously loaded into Sierra that also had new records loaded today.

  • Exported fields into Excel to verify all were AVON subscription records (bib 830, item code 1, item location)

  • Used Delete Records to delete the 634 previously loaded AVON records that were duplicated by newer records loaded today.