Versions Compared

Version Old Version 14 New Version Current
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

...

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.

...