We receive three files from the 360 MARC Updates service each month: new records that have never been loaded, updates to records already loaded, records to delete from our system.
-
Retrieve records from the ProQuest FTP site using an FTP client such as FileZilla. Files for ebooks will be in the "360MARC-Monographs” folder.
-
Host: ftp.serialssolutions.com
-
Username: XXXXX
-
Password: XXXXX
-
-
Download the current month’s files. These will be labelled:
-
FiveCollegesOhio_Updates_mono_monographs_changed
-
FiveCollegesOhio_Updates_mono_monographs_deleted
-
FiveCollegesOhio_Updates_mono_monographs_new
-
New Records:
-
Using MarcEdit, add a note in the 910 field (e.g. “pq360-mono-20180813”)
-
Compile to Marc using UTF-8 file type.
-
In Sierra, go to Data Exchange
-
Select Process = Load records via locally created load profiles (local)
-
Click Get PC
-
Browse desktop to select the MARC file
-
Upload
-
When prompted to rename, remove the .mrc extension and select the .lfts extension from the dropdown menu
-
Click OK
-
-
Select the .lfts file and click Prep
-
Click Start
-
Select the .lmarc file and click Load
-
Select LOAD a NETLIB file
-
Check the NETLIB load profile for the following settings:
-
@ov_action=“d"
-
001 = as is
-
856 = as is
-
Make sure that the following line is NOT commented out - |||0|0| | |0|n|G|0|@link="i:1:949"
-
-
Click Test. Records should all be new records - no overlays.
-
Click Load.
-
Once complete, spot check a few of the records to verify that they look okay in the public view.
Updated Records:
-
Using MarcEdit, add a note in the 910 field (e.g. “pq360-mono-overlays-20180813”)
-
Compile to Marc using UTF-8 file type
-
In Sierra, go to Data Exchange
-
Select Process = Load records via locally created load profiles (local)
-
Click Get PC
-
Browse desktop to select the MARC file
-
Upload
-
When prompted to rename, remove the .mrc extension and select the .lfts extension from the dropdown menu
-
Click OK
-
-
Select the .lfts file and click Prep
-
Click Start
-
Select the .lmarc file and click Load
-
Select LOAD a NETLIB file
-
Check the NETLIB load profile for the following settings:
-
ov_action=“d” (we don’t want to create items on the first pass)
-
001 = as is
-
856 = as is
-
-
Click Test. Records should all be overlays. Items will not be created unless a record doesn’t overlay for some reason. Then, it should create an item.
-
Click “Use Review Files”.
-
Click Load.
-
Go to Create Lists.
-
Find an empty review file that can hold the number of bibs that were overlaid.
-
Select that row and click Copy.
-
Find the “Load: Overlaid…” file generated during the load, select it, and click OK.
-
When prompted to remove the review file, say Yes.
-
Find another empty review file large enough to hold the number of items associated with the records you just overlaid. We’re going to delete those items and replace them with those in the “update” file.
-
Select that row and click Search Records.
-
Name the file (e.g. 360 items to be deleted)
-
Store Record Type = Item
-
Instead of Range, select Review
-
In Review File, Select the “Load: Overlaid…” file you created above.
-
Do not add any search criteria. Just click Search.
-
This should result in a review file containing all item records attached to the bibs you overlaid above.
-
-
Go to Delete Records.
-
Select the review file of item records you created above and click Start.
-
Select “Delete the listed ITEM record ONLY"
-
Click Delete Records. Once complete, you will see a summary of successful deletions and errors if any.
-
Go back to Data Exchange.
-
Select the same .lmarc file and click Load
-
Select LOAD a NETLIB file
-
Check the NETLIB load profile for the following settings:
-
ov_action=“b"
-
001 = as is
-
856 = as is
-
-
Change Start Block to 1
-
Click Test. System should overlay bibs and insert new items (be sure items attach)
-
Click Load.
-
Once complete, spot check a few of the records to verify that they look okay in the public view.
Deleted Records:
-
In Sierra, go to Data Exchange
-
Select Process = Load records via locally created load profiles (local)
-
Click Get PC
-
Browse desktop to select the MARC file
-
Upload
-
When prompted to rename, remove the .mrc extension and select the .lfts extension from the dropdown menu
-
Click OK
-
-
Select the .lfts file and click Prep
-
Click Start
-
Select the .lmarc file and click Load
-
Select LOAD a NETLIB file
-
Check the NETLIB load profile for the following settings:
-
ov_action=“u”
-
We don’t want to insert any new records here (in case there are records in the delete file that, for some reason, don’t match to an existing record in our system). The “u” value in this field will cause the record to overlay only if there is a single match. If there are 0 matches, or more than 2 matches, the records are rejected.
-
-
001 = as is
-
856 = as is
-
Comment out this line - |||0|0| | |0|n|G|0|@link="i:1:949"
-
-
Click Test. Should be all overlays. No new bibs and items.
-
Click “Use Review Files"
-
Click Load.
-
Go to Create Lists.
-
Find an empty review file that can hold the number of bibs that were overlaid.
-
Select that row and click Copy.
-
Find the “Load: Overlaid…” file generated during the load, select it, and click OK.
-
When prompted to remove the review file, say Yes.
-
Go to Global Update.
-
Select the “Load: Overlaid…” review file generated above.
-
Click Search.
-
Click on Command Input > Change variable-length field
-
Uncheck “Use Displayed Field"
-
MARC Tag = 956
-
Click OK
-
We do this to see if there are any records that have local 956 fields. If there are, we don’t want to delete those. Once you’ve removed any of these records with local fields, move on to the next step.
-
If any 956 links are found, remove any 856 links
-
Review 956 links and ensure that there are corresponding item records (e.g. If a bib has a Kenyon link in the 956, it should also have a Kenyon item record) Add and/or delete item records, as appropriate.
-
Notify libraries of any order records that need to be moved/deleted
-
-
-
Click on Command Input > Change fixed-length field > OK
-
In Change Fixed-length Field box, enter the following:
-
Fixed-length field = 31 SUPPRESS
-
Find = <any>
-
Replace = y DELETE
-
-
Click OK
-
Click Preview and confirm that the SUPPRESS field for all records will be set to “y”.
-
Click Process.
-
When prompted for confirmation, click Yes.
-
Once complete, you will see a list of all successful changes and any errors if any.