Page Comparison

10/24/2023

...

...

Academic Video Online/Premium (AVON)

...

Unicode	Should be okay in MarcEdit
001	check 001 and edit if straight digits only		add prepend of ASP
=001  99238610100971	add prepend of ASP Find: =001 (with 2 typed spaces--no indicators) Replace: =001 ASP
=001  ASP99238610100971
830	Add Field	\0$aAVON - Academic Video Online.
856 - edit subfield data	delete	provided subfield z 856 z Delete Subfield checked Remove Text
	add |z	Available online; click to view. 856 z New subfield only checked Replace Text
	add prepend	Edit subfield 856  u  ^b https://library2.usu.edu/eval_dist/url856.php?url= Use regular expression & Remove subfield codes from scope, both checked
Delete these fields: 901 905 910 941 942 943 944 945 950 951 980		Add/Delete Fields tool
MARCValidator to make sure edits didn’t break file Compile into MARC with easy to retrieve name

Loading AVON

Note that a recent update had some 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.

Delete file procedure

...

001 field edits

...

check 001 and edit if straight digits only

...

add prepend of ASP

...

First 001 edit

...

=001  99238610100971

...

add prepend of ASP

• Find: =001 (with 2 typed spaces--no indicators)

• Replace: =001 ASP

...

=001  ASP99238610100971

...

Second 001 edit

...

=001 ASPASP3550547/marc

=001 ASP3550547/marc

...

Second edit for 001 fields that already had ASP prefix

• Find: =001 ASPASP

• Replace: =001 ASP

...

• use MARCValidator to look for 001 errors

• Compile into MARC

...

and to make sure records have no internal weirdness to interfere with the load

Load using CAUTION special use for overlay and delete (.overlaytodelete)

• test; load

• Createlists

• Check

Image Added

Perpetual access AVON Titles

We will receive an email from Gaby with attached order number link (login with our name/password)

• Titles selected for permanent access will be listed there (copy/paste to Note or Excel)

If records are already in Sierra:

Item record changes:
Item code 1 changed from 20 to 0
Location changed from cocre to coonl
Item internal note:
AVON - Academic Video Online purchased for perpetual access 20191210 <--(date of purchase)

Bib record changes:
Purchased add to end of 001
540:
USU institutional license held in perpetuity|5ULA
910 added:
AVON - Academic Video Online purchased for perpetual access 20191210 <--(date of purchase)

ASP perpetual collections

General information for ASP perpetual purchases

Royal Shakespeare Company Collection

The National Theatre Collection

BroadwayHD Collection

...

General edits for all 3 new perpetual collections

...

ASP Delete file procedure (includes AVON)

001 field edits	check 001 and edit if straight digits only		add prepend of ASP
First 001 edit
=001  99238610100971	add prepend of ASP Find: =001 (with 2 typed spaces--no indicators) Replace: =001 ASP Image Added
=001  ASP99238610100971
Second 001 edit
=001 ASPASP3550547/marc =001 ASP3550547/marc Image Added	Second edit for 001 fields that already had ASP prefix Find: =001 ASPASP Replace: =001 ASP Image Added
use MARCValidator to look for 001 errors		and to make sure records have no internal weirdness to interfere with the load
Compile into MARC

Load using CAUTION special use for overlay and delete (.overlaytodelete)

• test then load

• Create lists

• Check file for order records and/or 910s with perpetual/purchased notes; edit any with order or 910 purchased/perpetual notes, (test for access also); Remove them from the review list, then

• Go to FUNCTION Delete Records:

FUNCTION: Delete Records; Review Review file: Load: Overlaid records for [name of file]

• Start will bring in the records

• Image Added

  Important! Chose: Delete the listed Bibliographic record AND all attached records

  • (You should have already checked that there are no perpetual access markers before leaving create lists)

3. deep breath: then click Delete Records

• You will be asked: Are you sure sure sure?

• Image AddedImage Added

  Double check number of deletes, then Close

• And in Create Lists, the load files will disappear.

• Finish recording in tracking and clean up everything in Data Exchange & Create Lists review files (unless needed by someone else)

Okay that was the easy part.

For all the Delete file records that DID NOT overlay

Create a file of 024 numbers for each record in the delete file

The 024 numbers have the old-style ASP control numbers,

1. from the MarcEdit version of the deletes file, extract a list the 024s and titles for cross checking

Instructions are here:Extract a spreadsheet from MarcEdit batch file; then search numbers using Sierra Create Lists

2. Then go thru the review list check all the records in a new Create Lists file

   • The quickest method is to Import Records in Create Lists while choosing each of the ASP/Avon hooks and look for any in the spreadsheet that don’t match (and edit, then remove from review file)

...

Go to Function: Delete Records;

1. Review file: [find its name]

2. Click Start to bring in the files

3. double check these are the correct records and have the same number of records

4. Choose Delete the listed Bibliographic record AND all attached records

   • Are absolutely sure? Yes

   • The number of records deleted will pop up, with the same number of deletions

5. The create lists Review file will also disappear

There may be one or two titles left to delete manually.

1. if so, check them and delete them one by one, both bib and attached item

Finally finish recording that set, and clean up Data Exchange