Preparing MARC Holdings Records for WEST for editing via MarcEDIT
- Make bibliographic record changes manually in SIRSI:
- Edit 001 if needed
- Confirm that 022 is present, if needed
- Update Title Control # if needed
- If Date cataloged = NEVER, change to TODAY.
- Add 989 field (this is your identifier to create list of appropriate MHLD)
- Make a list of bibliographic records that include a 599 field for current issues. You'll use this to more quickly remove the duplicate 599 fields after the MHLD are loaded. [Instead of checking every record for them, you can just check the ones on your list.]
- Create MHLD for LSC if needed:
- Make Enc_Lvl = 4 (or 3, if appropriate for Silver records)
- Edit: 852 _1 |cLSC
- Copy over any LSC holdings in the MHLD for STACKS to the MHLD for LSC.
- Delete LSC 866 fields from the MHLD for STACKS.
- Split STACKS holdings at 2005 if relevant.
- If existing MHLD for LSC has duplicate 001 fields, print the existing MHLD. Then delete and recreate to remove the duplicate fields. Once you have re-entered the information, recycle your printout.
- If existing MHLD has Entrd = 000000, change to 950801.
- Once all manual edits are completed, have IT Sirsi staff member create a file listing all MHLD with:
- 852 |cLSC
- Attached to bibliographic records with: 989 WEST Silver year6 (or whatever label you're working on)
Ask him to include 022 and 035 from the associated bibliographic records in the file.
In MarcEdit:
- Open the file you want to edit in MarcEditor. If it is not already a .mrk file, you'll need to convert it from .mrc to .mrk using MARC Tools before opening in MarcEditor.
- To apply the repetitive fields: 583 (retention, completeness, condition) and 007, I created a Task. Before you apply the Task to your file, edit it first to make sure it says Silver, Gold, as appropriate and contains the correct 583 fields for the color.
- To edit the task, go to: Tools/Manage Tasks; select the WEST MHLD task and then click "Edit selected task list" and make the necessary changes (edit color text, add or remove 583 fields as appropriate).
- To apply the task to your file, go to: Tools/Assigned Tasks/Currently Available Tasks/WEST MHLD
- You'll need to do a merge file to add the |xWEST Cat.{#} #{Ulrich's No.} note to field 852. To do thi
- First create a mini set of MARC with control numbers. Our match point will be the 035 field.
- Copy columns A and B (Ulrich's number and SIRSI record number) from the Google docs spreadsheet for the group of records you're working with. Paste into a new spreadsheet. Do a search and replace to change 'o' to '(Sirsi) ' [Important: include a space after the final parenthesis!]
- Save as Tab Delimited Text (.txt)
- In MarcEdit, choose Delimited Text Translator (also under Add-ins).
- Source file is your tab delimited .txt
- Output to a filename of your choice
- Map each field to its appropriate field:
- 852$x for Ulrichs Number
- 035$a for SIRSI control number
- Run it.
- You should now have your mini set of MARC records with minimal information for merging purposes. Do take a quick look over to check that everything is there.
- To add the WEST Cat.{#} text, go to Tools/Edit Field Data and fill in the box as shown, using the appropriate Cat number:
- Then click "Process." and be sure to save your file.
- You should now have two sets of records, your mini set and your main set to which you want to add field 852.
- In the main MarcEdit window (NOT MarcEditor), choose Tools → Merge Records
- For Source File, select your main MARC records set
- For Merge File, select the mini MARC set you created
- Set your output file to your desired location and filename
- Choose record identifier, e.g. 035, to match on SIRSI Control number.
- Click on Next
- Choose Merge Selected Fields
- Select the field you want to import, e.g. 852
- Click on Next
This will add a second 852 to the record with the |xWEST Cat.{#} #{Ulrich's No.} note in it.
- To move the note up to the existing 852 and delete the extraneous one, do the following in MarcEditor:
- Choose Tools/Swap Field Data and fill out the dialog box as shown below:
- Click "Process."
- Save your file.
- In MarcEditor, choose File/Compile File Into MARC and save as a .mrc file. Notify Mang that file is available to be reloaded into SIRSI.