Academic Complete Proquest (monthly) USU ebookcentral workflow

Academic Complete from Proquest

10/19/2023-10/20/2023

Pulled onto separate workflow for major differences in workflow, but tracking is still found on spreadsheet shared with YBP jstor and proquest DDA files, here: https://usu.app.box.com/file/1321317102096 (Academic Complete tab)

Has its own load table: BATCH LOAD ebrary Academic Complete (.ebookcoll)

Download

Examples of downloaded files (add all download file names to tracker, including csv’s):

• 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

Editing Add files

2 of them Express and Full, load before Delete, (but both Adds: Full & Express, can be loaded in any order)

Academic Complete (subscription)
Edits needed before loading Add files:
Add ac before EBC in 001 to keep distinct from DDA discovery records Open	=001  acEBC1130287   Find: =001 (plus 2 spaces) Replace: =001 ac
delete 856 subfield z and then add our subfield z with: Trying to do this in one step usually breaks the field Open	Available online; click to view Edit Subfield (remove old): Field: 856 Subfield: z Delete Subfield checked Remove Text Edit Subfield (add new): 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
(load table adds 830 Academic Complete)
MARCValidator Compile into MARC

Load into Sierra

Delete Files process

Create two files in MarcEdit by renaming the file as you open them in MarcEditor

Edits for first file with 001 ebr:

Edits for Second file with acEBR

Load both Academic Complete delete files

Check for attached order records for each file before deletion!  (export order record # when exporting to check 910)

1. Go to Create lists; Copy; find Load Review file, as usual

2. Export:

   1. Line 1 Type: order o Field: Record Number 81

3. Name export files something like:

   • ACdelete1-orders-20231005

   • ACdelete2-orders2-20231005

4. Open exported file of order numbers in Excel; and if no order numbers show; then go forward with Deleting records

5. If there is an order, find the title in Create Lists and open to edit bib and item:

   1. [holding place for instructions on editing]

   2. Select edited title, then Remove from file (or whatever the command is for removing from the list)

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

• Start will bring in the records (you can double check some against Excel file, if uneasy about all this)

• Chose: Delete the listed Bibliographic record AND all attached records

  • (You should have already checked that there are no attached order records w/the export step)

3. deep breath: then click Delete Records

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

•  

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

Record everything in tracking: https://usu.app.box.com/file/1321317102096

4. Clean up Data Exchange