FTP download software/app:

...

Once logged in to the ftp site, open eba:

...

• Select the most recent (i.eusu. a week’s worth) of Cambridge files

• Click download and look at note where the program is sending saving them

...

Cambridge University EBA processing

...

• After downloading files; log them into the tracker https://usu.app.box.com/file/1318202855178

• After downloading files; log them into the tracker

MarcEdit for Joining files

Use MarcEdit to join individual files

1. Tools,-->Marc Processing Tools-->MARCJoin:

   • Save file: navigate to your chosen folder for the future joined file; [give it an descriptive name]; Save

     • name example: CAMBRIDGE_BOOKS_ONLINE_EBCOLL_6000746_10202023-11082023

   • File(s) to join: navigate to folder containing your files: select all of them; Save

2. Click Process

...

Cambridge EBA edits

Unicode - Check MarcEditMarcEdit seems to have no problem converting to MARC8

Use MarcEdit to join individual files if desired: (Tools, Marc Processing Tools, MARCJoin).

• Detailed instructions here: Join two or more MARC files into one

Open in MarcEdit MarcBreaker:

• Open: navigate to joined file (.mrc)

• Save As: I give it the same name (will be in .mrk) and place

• I don’t mess with the other Encoding options, it doesn’t seem to have issues w/Unicode

...

• Go for it and Execute

• Note the number of records and record them and the joined file name in the tracker

• Click on Edit Records

MarcEdits

Replace; add prepend cambridge to 001

...

• Edit; -->Replace

  • Find: =001 ← 2 blank

  spaces for the indicators

  • spaces (or highlight =001 and 2 spaces in first record and copy/paste)

  • Replace: =001 cambridge

...

• • Replace all

• Quality Check: number modifications should match number of records in file

  • Also look at first record or 2 to check the edited 001 fields are still lined with the rest of the fields

Delete fields

...

• Tools-->Add/Delete Field):

...

Delete Field

037 655 949

...

975 976

...

Edit-->Find, and delete field if found

...

...

Edit-->Find Find: =533 Find All

533 538 583 773

• If not found, no need to open Add/Delete Field

...

• If found:

  • Tools-->Add/Delete Field

  • Field: ← whatever the field is

  • and Delete Field

Check for problems in field 830

• Check for any problematic 830s indicating other libraries' DDA & other vendors' programs, & if found, delete them

  • Such as Project MUSE

  • Delete if found, but leave regular series titles in

• Edit-->Find

  • Find: =830

• You can enlarge the Results window up/down and sideways:

...

• Check for any problems: look for local z subfields; plus extra URLs (for contents, title page), other library’s local data

• good example: =856 $uhttps://doi.org/10.1017/9781009347181 ← clean with nothing extra

...

If no problems show up, go on to 856 Edits

• 856 add |z subfield

  • Tools; Edit -->Edit subfield data:

  • Field: 856 *add Subfield: |z Field Data: [leave blank]

    • Replace with: Available online; click to view

  • New subfield only;

  • Replace Text

...

• 856 add prepend to |u https://library2.usu.edu/eval_dist/url856.php?url=

  • Tools; edit -->Edit subfield data:

  • Field: 856 Subfield: u Field Data: ^ (regex symbol meaning: insert in front)

  • Replace with: https://library2.usu.edu/eval_dist/url856.php?url=

    • Use regular expression, and

      • Remove Subfield code from scope (otherwise u will be pushed to the end)

      • Replace text

...

• Do a quick check that 856 fields still line up; and no digits (especially subfield letters) are misplaced

• Good idea to do File-->Save

Add field:

• Tools-->Add/Delete Field

• Field: 910 Field Data:

Check for errors/typos (Reports

...

-->MARCValidator)

• Fix simple errors by referring to Bib Formats and Standards or MARC21

...

File-->Save (if not already saved)

Compile into MARC

• File; Compile -->Compile into MARC; copy/paste name from Tracker w/added done or ready on end, if desired

...

Load into Sierra:

...