Versions Compared

Version Old Version 106 New Version 107
Changes made by

Melanie Shaw

Melanie Shaw

Saved on

Key

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

10/6/2023

Open tracking spreadsheet here: https://usu.app.box.com/file/1321317102096

  • always copy/paste file name to tracker as part of the downloading process

Table of Contents

Downloading the files (both JSTOR and ProQuest)

...

YBP eDDA from JSTOR beginning April 1, 2021

Record source:  YBP ftp

ftp://ftp.ybp.com

Name:  utahstate

Password:  M&45rt

  1. Do not use MarcEdit to merge these files; their delete files need to be loaded in succession with these files in date order and come in a little bit irregularly (often, but not always monthly)

  2. load weekly files of new records first

  3. then load the delete file (check that delete date is after the last new file loaded, but before the next new)

  4. JSTOR will be in same files as the ebc Proquest discovery records, so get those at the same time

  5. filename will have .f2 at end

  6. 001 will start with jstor

  7. 856 field will have: //www.jstor.org within link

  8. also have 710 with JSTOR

...

MARC8, not Unicode (default for MarcEdit is MARC8)

  • Open MarcEdit-->MARC Tools-->navigate to file in Downloads (once Windows recognizes Marc files you can just double click on the file & MarcEdit will open it)-->name it the same thing (or save to another folder if desired)

  • click Execute:

    • record number of records that MarcEdit processed into mrk in the Tracking sheet (and use it as a quality check, while you go thru editing and loading)

  • Edit Records (to open MarcEditor)

...

Deletes:

delete 037 fields: Tools-->Add/Delete Field--> Field: 037--> Delete Field

  • Number of deletes will vary

  • File-->Save

Look for misleading series titles for other ebook collections in 830’s

check for 830s needing deletion such as  =830  \0$aBook collections on Project MUSE. (But don’t delete real series statements):

  1. Edit-->Find: =830, Find All,

  2. scroll down results to check for vendor-type 830’s

  1. If you find one; highlight it; and Jump to record

  2. Copy the text in the 830$a for pasting and deleting

  3. open Add/Delete Field;

    1. Field: 830 Field Data: [copied text]

    2. Delete Field

you can double check results (if any) by redoing the =830 find all

If unsure that an 830 is a real series title; Jump to record and look for a matching 490 series title; usually libraries will not (but sometimes will) add 490 field titles for local ebook collections

...

Replace provided prepend with our new one:

Prepend as provided by GOBI:

Our current version:

Edit-->Replace

=856  40$uhttps://library.usu.edu/catlog/url856.php?url=https://www.jstor.org/stable/10.2307/jj.5590586$zAvailable online; click to view

=856  40$uhttps://library2.usu.edu/eval_dist/url856.php?url=https://www.jstor.org/stable/10.2307/jj.5590586$zAvailable online; click to view

copy/paste old version into Find:

https://library.usu.edu/catlog/url856.php?url=

copy/paste new version into Replace:

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

Quality Check-->

File-->Save

Number of replacements should match the number of records in the file

...

  1. Save

  2. File-->Compile into MARC record --I use the same name for the mrc file, but with Done added to end

Load into Sierra-->Data Exchange-->Get PC-->find file-->.lfts-->Prep

--prep should have same number of records as in original file

Load table:

BATCH Load YBP DDA discovery records (.ybpdda)

Always select:Use Review Files

Always Test first; look for problems,

and if none, then Load

Quality Checking (no editing needed in Sierra for these files)

  • go to Create lists;

  • Copy-->find Load-->find Load-->Load: Inserted records for ddaebc20230329.f2-done ← in this format

...

  • Open up one or two records and check the items, check over the values, etc.

    • (Most of our “hooks” were already supplied by the vendor for these files)

    • Also, test one or two record URL’s in Encore or Public view

Final Recording and cleanup

  1. Track Finish tracking in Box spreadsheet: https://usu.app.box.com/file/1321317102096

  2. Clean up Create Lists and Data Exchange

  3. Statistics: record as batch Modified Batch record load in the Cataloger stats table

...

ProQuest YBP DDA discovery

...

Remember to record in tracker: https://usu.app.box.com/file/1321317102096

General rules:

  1. Do not use MarcEdit to merge the new files; their delete files need to be loaded concurrently in date order with the new, and come in a little bit irregularly (often, but not always, monthly)

  2. will be in same download file list as JSTOR, so download at the same time

  3. Will have .f1 at end of file

  4. 001 will start with ebc

  5. 856 will have: //ebookcentral.proquest.com

  6. also: 710 with ProQuest

...

Prepend as provided:

=856  40$uhttps://library.usu.edu/catlog/url856.php?url=https://www.jstor.org/stable/10.2307/jj.5590586$zAvailable online; click to view

No proxy prepend needed in this e collection, so we delete it

=856  40$uhttps://www.jstor.org/stable/10.2307/jj.5590586$zAvailable online; click to view

  1. Edit--Replace-->copy/paste prepend into Find:

https://library.usu.edu/catlog/url856.php?url=

  1. Replace:

(leave empty)

  1. Replace All

  • Quality Check-->

  • Find: =856 to make sure edited URL hasn’t been harmed

  • Edit-->Save

  • number of modifications should match number of records in file

  • $uhttps://ebookcentral.proquest.com/lib/USU/detail.action?docID=30769784$zAvailable online; click to view

...

Edit-->Find

Find: Creators in the academic library

Jump to Record to look at each one (if desired)

Can also Find each field; then sort the results by clicking on the 1st column header:

The “duplicates” in the file above all appear to be false (possibly the validator is set too broad)

  1. Edit-->Save

  2. File-->Compile File into MARC (with same name; I add Done to end)

Sierra load

...

-->FUNCTION-->Data Exchange--Get PC-->Find File-->.lfts-->prep

Load Table:

BATCH Load YBP DDA discovery records (.ybpdda)

Always checkmark:Use Review Files

Always Test; look for problems,

and if none, then Load

Quality Check (no edits needed in Sierra)

  • Create lists-->Copy; find file-->find file-->Yes

  • check records, look over hooks (most are already in supplied file)

    • Check url in public view and Encore

...

...

UALC consortial EBA

YBP eDDA from ProQuest Ebook Central

(file name as provided starts with dda; add ualc_ at the beginning for clarity)

Record source:  YBP ftp

ftp://ftp.ybp.com

Name:  ualc

Password:  P#37sb

Records are in dda folder

ddaYYYYMMDDf1.mrc

  • dda20230813.f1

add ualc

ualc-ddaYYYYMMDDDf1.mrc

  • ualc-dda20230813.f1

Record file name & number of records in tracker

...

edit replace text in 856

old version

ours

Edit Subfield Data

  • Field: 856 Subfield: u

  • Field Data: ualc-ebooks

  • Replace with: usu

  • Replace Text

ualc-ebooks

usu

edit subfield 856 z

Available online; click to view

Edit Subfield Data

  • Field: 856 Subfield: z

  • Replace with: Available online; click to view

  • Select New subfield only

...

old version

our version

change 910 wording

=910  \\$aYBP DDA consortia

=910  \\$aUALC YBP DDA discovery record

OR:

use Edit Subfield Data:

  • Field: 910 Subfield: a

  • Field Data: YBP DDA consortia

  • Replace with: UALC YBP DDA discovery record

  • Replace Text

check for 830s needing deletion such as:

=830  \0$aBook collections on Project MUSE.

...

Load table:

BATCH Load UALC YBP DDA discovery records (.ualcybpdda)

Select: Review Files

Test, then Load

...