Summary:
These instructions are for loading the Limimoc records that updated the Marcive monthly online records. These online updates are the only updates we receive from Marcive. The records are loaded by matching on the 001 in the marc records to the Instance OCLC # (marc 035) field. Nonmatches create an instance, holdings, and item records for the Library of Michigan location.
Lastly, a web form (https://codeprod.lib.msu.edu/scripts/wf1.php) is used to determine which FOLIO instances have only one holding record attached to the Limmic records. The records are uploaded through the web form to create a separate mrk list that finds the records that only have single holdings records in the file being loaded. The MarcEdit list that is created is run through CATMAN10. They match from the 035 in the marc records to the Instance OCLC # (marc 035) field. The CATMAN10 Job Profile does not have non-match criteria.
Edits to the MarcEdit file are done before the records are loaded into FOLIO.
- Open the MarcEdit file
- Add > “948 \\$a7fdel” string to all the records in the file in order to add Library of Michigan items and holdings if needed.
- Add > “948 \\$a7fdel” string to all the records in the file in order to add Library of Michigan items and holdings if needed.Substep b
- Tools > Add/Delete Fields
- Save changes.
-
- Compile File into an mrc file, or click on the Compile MARC image
- Save your mrk file to your desktop as an (*mrc) file.
- Name the mrc file the same as the mrk.
- The mrc file is ready to run through the Data Import, CATMAN9 job profile.
Back to top
FOLIO Data Import.
Back to top
Run the LIMIMOC file through MarcEdit to Compile the OCLC Numbers into a separate file.
- Open MarcEdit à choose “Tools” à Export… à Export Tab Delimited Records.
- Once the “Export Tab Delimited Records” popup opens.
- Insert the LIMIMOC (mrc) file in the first file path.
- Copy and paste the LIMIMIOC file address into the second file path changing the extension to txt.
- Click “Next”
- Select “001” from the Field box.
- Click “Add Field”
- Click “Export”
- Items have been exported > Close Tab Delimited box.
Back to top
Find and open the exported TXT file on your Desktop.
- Delete the first row that has “001.”
- Remove all double quotes by Find and Replace
- Save txt file and exit out.
Back to top
- Go to webform https://codeprod.lib.msu.edu/scripts/wf1.php
- Notate the file name which ends in csv. Ready to run the csv file through FOLIO Data Export appSubstep b
- Click “Browse” button to select the corrected TXT file from the previous step.
- Click “Upload file”
- Select option “Instances with Single Holding” in the dropdown.
- Click “Submit”
- Wait for the query process to finish (It may take a while depending on amount of OCLC numbers)
- When the process is done, a list of Instance UUIDs will be listed, then click “Download.”
- Substep c
Back to top
Go to FOLIO Data Export app.
- Upload the CSV file from the last step by clicking the “or choose file” button or dragging the CSV file into the “Drag and drop” box.
- Select “Default Instances Export Job Profile.”
- Choose “Instances” in the popup.
- Click “Run”
- Output MARC file will be shown appear on the top of the Data Export log
- Find the Excel spreadsheet (csv file).
- the file will label records that have duplicate OCLC records.
Image Added- Save this file naming it so that you know not to use the file with the dup labels. Name LIMIMIOC2104.OCLCDups.csv
- Remove (Dup?) from the end of the UUID number.
- Save file again.
Back to top
Record Ready to run against the second Job Profile (CATMAN10) to add MSU wbgov item and holdings.
- Click on Tools > Add/Delete Field > Field 948 > Field Data \\$awbgov) > Add > Save file > close out of MarcEdit
- Find he Single record mrk file.
- Look for updates, discarded, or error
- Compile the csv file to a mrc file.
- The csv excel file will show which records have duplicate records.
- Save the csv file that list records with duplicate records.
- FOLIO apps > select Data Import.
- Drag or drop the mrc file to start data import job.
- Select Job Profile “CATMAN10 – Load new Marcive monthly online recordrs – create holdings and item records for both MSU and LM.”
- Actions > RUN
- Wait for the report and then check that records have the wbgov holdings and item records with the designated electronic links and call numbers.
- Look for updates, discarded, or errors error records
Fix duplic
Back to top
Back to top