Versions Compared

Version Old Version 13 New Version 14
Changes made by

Melanie Shaw

Melanie Shaw

Saved on

Key

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

Academic Complete from Proquest

...

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)

...

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

=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

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 table for deletes:

CAUTION special use for overlay and delete (.overlaytodelete)

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)

  1. deep breath: then click Delete Records

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

  •  

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

...