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)
...
load weekly file of new records first
then load delete file (deletes come in separately via email-->check that delete date is later than weekly new files)
will in be same files as the ebc Proquest discovery records
filename will have .f2 at end
001 will start with jstor
856 field will have: //www.jstor.org within link
also 710 with JSTOR
...
MARC8, not Unicode (make sure MarcEdit is set to 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 in Downloads (unless you want it on the Desktop)
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 Quality Check - number deleted varies |
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):
|
|
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 add 490 field titles for local ebook collections |
...
Replace provided prepend with our new one: | |
Prepend as provided by GOBI: | =856 40$uhttps://library.usu.edu/catlog/url856.php?url=https://www.jstor.org/stable/10.2307/jj.5590586$zAvailable online; click to view |
Our current version: Edit-->Replace | =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 into Find: | https://library.usu.edu/catlog/url856.php?url= |
copy/paste new into Replace: | https://library2.usu.edu/eval_dist/url856.php?url= |
Quality Check: | Number of replacements should match the number of records in the file |
...
Save
Compile into MARC-->I usually use the same name, but with Done added to end
Load into Sierra
...
-->Data Exchange
Load table: | BATCH Load YBP DDA discovery records (.ybpdda) |
Always select:Use Review Files | |
Always Test; look for problems, | and if none, then Load |
go to Create lists; Copy-->find Load
Most hooks were already supplied in these files
Check link in public view and encore
...
Open up one or two records and make sure they have items, check over the values, etc.
Most of our “hooks” have already been supplied by the vendor
Also, test one or two record URL’s in Encore or Public view
Track in Box spreadsheet: https://usu.app.box.com/file/1321317102096
Statistics: record as batch record load in Cataloger stats table
...
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 |
To remove proxy prepend; Find/Replace (no proxy prepend needed) | =856 40$uhttps://www.jstor.org/stable/10.2307/jj.5590586$zAvailable online; click to view |
| |
| (leave empty) |
| |
|
|
 | |
...
Using Edit-->Find to check for actual duplicates |
|---|
Find: Creators in the academic library  Jump to Record to look at each one (if desired) |
Can also do a general Find on each field; then sort the results (by clicking on the 1st column):    |
The “duplicates” in the file above all appear to be false (possibly MarcEdit has too broad criteria) |
...
Load Table: | BATCH Load YBP DDA discovery records (.ybpdda) |
Always checkmark: Use Review Files | |
Always Test; look for problems, | and if none, then Load |
Create lists-->Copy; find file
check hooks (most are already in supplied file)
Check url in public view and Encore
Finish recording in spreadsheet: https://usu.app.box.com/file/1321317102096
Clean up data exchange and create lists
Take stats for CAP
...
(file name as provided starts with dda; add ualc_ at the beginning for clarity)
Record source: YBP ftp | Name: ualc | Password: P#37sb | |
Records are in dda folder | ddaYYYYMMDDf1.mrc
| add ualc | ualc-ddaYYYYMMDDDf1.mrc
|
Record file name & number of records in tracker | |||
...
edit replace text in 856 | old version | ours |
Edit Subfield Data
| ualc-ebooks | usu |
edit subfield 856 z | Available online; click to view | |
 | Edit Subfield Data
| |
...
old version | our version | |
change 910 wording | =910 \\$aYBP DDA consortia | =910 \\$aUALC YBP DDA discovery record |
OR: | use Edit Subfield Data: |
|
 | ||
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 |
Create Lists-->Copy
Check hooks
Test link in OPAC and Encore
Finish recording in Tracking sheet: https://usu.app.box.com/file/1321317102096
Add to CAP stats: General Stacks-Batch-Modified
...