Academic Complete USU Ebook Central Proquest Workflow

https://usu.ebookcentral.proquest.com/libCentral/Login.aspx?r=needlogin

Collections Tab --> MARC Updates --> record set: Subscribed and/or Owned

Filename: yyyymmdd_111111_usu_Full or Express-MARC8_Add.mrc or _Delete.mrc

mshaw

BigBlue1888@

20230928_553783_usu_Add.csv

20230928_553783_usu_Full-MARC8_Add.mnc

20230928_553783_usu_Express-MARC8_Add.mrc

20230928_553783_usu_Delete.csv

20230928_553783_usu_Express-MARC8_Delete.mrc

Academic Complete (subscription) edits

Edits needed before loading Add files:

• Add ac before EBC in 001 to keep distinct from DDA discovery records

=001  acEBC1130287

• Find: =001 (plus 2 spaces)

• Replace: =001 ac

• delete 856 subfield z and then add our subfield z

• Trying to do in one step usually breaks the field

Available online; click to view

Edit Subfield:

• Field: 856 Subfield: z

• Delete Subfield checked

• Remove Text

Edit Subfield:

• Field: 856 Subfield: z

• Replace with: [our text]

• Replace text

• New subfield only checked

• delete 655 Electronic books

Add/Delete

• Field: 655

• Field Data: Electronic books

• Delete Field

• MARCValidator

• Compile into MARC

(load table adds 830 Academic Complete)

BATCH LOAD ebrary Academic Complete (.ebookcoll)

• Test; then Load

• Note # overlays in Tracker

• Create lists; Check markers

• Clean up files

• Finish recording in Tracker: https://usu.app.box.com/file/1321317102096

edits needed before loading Deletions:

•  replace EBC 001 with ebrary 001 copied from 035

  =001  ebrxxxx

•  create another file with ac in front of the EBC 001 to check for more recent matches

  =001  acEBCxxx

• BE CAREFUL to confirm that all matches are coebr and none are purchased DDA with ebr 001!!!