AVON and ASP workflows

10/24/2023

Purchased from Alexander Street Press

Records come in file folders, each holding multiple mrc records, each with only 1 record in it.

Collection	Access Type
Up to date as of Sept. 2023
Academic Video Online: Premium	Subscription	on going
American History in Video	Perpetual
BroadwayHD Collection	Perpetual	on going
Ethnographic Video Online: Volume I	Perpetual
National Theatre Collection	Perpetual	on going
North American Women's Letters and Diaries	Perpetual
The Royal Shakespeare Company Collection	Perpetual	on going

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

Downloading

Academic Video Online: Premium
http://adminportal.alexanderstreet.com
a092640	a09264008
MARC Records --> Monthly Changes
For Additions: checkmark "Split results by collection" and don't choose "Select collection"
For Deletes: do not choose either optional limit (doesn't work if you do)

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

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

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

markers/hooks:

Edits	UNICODE

001		check 001 and edit if straight digits only		for additions and deletions:
=001 99238610100971		add prepend of ASP		check 001 and edit if straight digits only
=001 ASP99238610100971				add prepend of ASP
830	add	\0$aAVON - Academic Video Online.
856	delete	provided subfield z
	add \|z	Available online; click to view.
	add prepend	Edit subfield	856 u ^b
		https://library2.usu.edu/eval_dist/url856.php?url=
			Replace text