These procedures outline the process for two batch merge workflows that combine item level information collected in an Airtable base with existing OCLC records - as part of a large scale remediation project for Congressional Hearings.
Tools Needed
Sierra (local catalog)
Airtable
OCLC Connexion
MarcEdit
Excel
Quick Navigation
Batch Record Creation and Importing
This process will outline how to take the data from Airtable and merge with or create original records for OCLC. There are three processes used depending on the needs of the record:
Merge Overlay (Merge New Barcodes: Used for records where an existing OCLC record can be merged with the updated and verified Airtable table. Records overlay existing Sierra records.
Barcoded, Ready for New Cataloging: Used for records where an existing OCLC record can be merged with the updated and verified Airtable table info. Records are brought into Sierra as new records.
See also the separate workflow for setting OCLC holdings, for titles already fully cataloged in Sierra, but with no holdings showing in OCLC: Congressional Hearing Set OCLC Holdings Procedures
Congressional Hearings Merge Processes (New Barcodes, Update Sierra, Set Holdings)
General Brief to OCLC Merge Workflow
MarcEdit Brief record creation for merging: export from AirTable → Open in Excel spreadsheet and edit → use MarcEdit Tab Delimited Convertor to make brief MARC records (.mrk) → check/edit MarcEdit Brief Records → save for merging.
OCLC records batch-search and edit: change (OCoLC) prefix to * → copy entire OCLC# column → save in notepad → load notepad txt file in OCLC batch processor → point to empty OCLC local save file → run OCLC Batch Process search → export all searched records → convert OCLC file to MarcEdit mnemonic (.mrk) → delete certain fields → save for merging → Recopy the OCLC numbers with * prefix → Go back to OCLC and run the batch process to set holdings in OCLC.
Merge brief & OCLC batchsearched records together: batch edit → compile into MARC (.mrc) format → load into Sierra → make Create List of LOAD → global edit Item call numbers to 086 → DONE!
Changes needed for the two Batch Merge Processes
Preprocess:
Jen’s crew has checked for physical items, added barcodes, checked SuDoc numbers, and so on, in the spreadsheet & uploaded to Airtable.
Cheryl will delete MQ barcodes from Sierra before we bring in our Merged Batchload records.
Liz has created 949 fields for each item record in Airtable.
Various preprocessing will be run for items that lack a 001 or 035, or that have wrong OCLC numbers brough over from Sierra to the two Merge views.
949s for titles with multiple volumes will to be grouped to be added to a separate workflow.
Excel spreadsheet processing will remove excess columns, change 86 to 099, check for the usual errors, etc.
Brief records will be created/edited in MarcEdit:
OCLC # (OCLC Masterpiece change to 035 - match point for OCLC merge)
Title – for error resolution, only - will not be merged into OCLC bibs.
086 - taken from the first (home) column and change to 099 - our SUDOC number
Record #(Biblio) change to 907 - Sierra bib-number match point (needed only for merge & OVERLAY) - match point for Sierra import
949 - formed in Airtable - (will contain barcode-from Airtable and SUDOC - from Airtable; plus identical location codes, item type codes, etc.) – EXCEPTION: multivolume titles will be adding 949 during OCLC steps.
590 field for the Project Name
Batch Changes to OCLC record will be:
Change 049 from UUSA to UUSH.
General and very modest edits for the usual obvious errors.
Merge Brief bib into OCLC bibs:
035 OCLC Masterpiece
099 SUDOC
949
907 (for Overlay)
590 field for the Project Name.
Undergoing revision, please wait until finished
Detailed Procedures for New Barcodes, Update Sierra, Set holdings: (MERGE Overlay) workflow 1
For government documents which already have a record loaded in Sierra (usually from Marcive GPO), but needed a new barcode, we will use the barcode to make 949 item record field, put the Sierra bib# in a 907 for overlaying, and the SUDOC in a 099.
AirTable Extraction:
Go to AirTable Hearings 9-10:
Sign up for a certain section of SuDoc Y4 numbers
Batch Loader: you
Batch Load Status: In Progress
Fill in Batch Load Start Date and (if needed during the process) Notes.
Go to view: New barcodes, Update Sierra, Set holdings:
Flag any problems that need to returned for more work, checking etc. (incomplete, problem, etc.)
Download CSV file of items by clicking on the down arrow at the top menu, in one of two ways:
First filter by SUDOC stem (easily done by adding a filter of Sign up Name is exactly: [your name]--then delete just that filter when done downloading)
OR
Download entire set and delete other titles after opening file in Excel (probably too bulky to do).
Distinguish the download by changing the CSV name of Imported table-New barcodes, Update Sierra, Set holdings after downloading, something like this: Newbarcodes-Y4V2-HRG101-103.
Excel Column work:
Open Excel app first
Open; from PC; Desktop; All Files;
Then, navigate to the CSV file (such as Newbarcodes-Y4V2-HRG101-103); then choose Delimited; Next; click in Comma box, Next; choose Text, and Finish.
If you haven’t done so already by filtering to your SUDOC stem in Airtable, delete all but your chosen Y4 group rows from the spreadsheet. or copy/paste your chosen titles to another spreadsheet.
Delete all these columns in the spreadsheet:
The 3 sign up columns: Sign up Name, Batch Cataloging Status, Start Date
Final Source
Stem
Condition
Batch Cataloging Status
Record #(Item) - we don’t use this
86 (since we’ll be using the first SuDoc Call Number column)
OCLC Masterpiece will NOT be deleted: instead delete ANY other OCLC related numbers, including Field 001, OCLC Final for Melanie, Field 001 checked, etc
Sierra MQ barcode
Barcode added in inventory - make sure this is already in the MARC 949 - $ subfield column, then delete Barcode added in inventory
Volume (if multipart) - should be in another view
Editable SuDoc
Bib Record (linked) - we already have Record#(Biblo as 907)
Count of items on Bib
The remaining Columns should be:
SuDoc Call Number
OCLC Masterpiece - this will become our 035 field in the next step
Title - just for error checking, if needed
Record#(Biblio) – (for overlaying in Sierra)
MARC 949 - $ Subfield - first item record
Keep these specific columns and rename:
SuDoc Call Number change to 099a
Title to 245 - for error checking only
ADD a new Column:
Insert a column; in header name it: 590a
In first column add the text: Y4 Retrocataloging Project 2022
Pull down to fill the rest of the column cells.
Record #(Biblio) change to 907a
MARC 949 - $ Subfield to 949a
OCLC Masterpiece - first do these edits:
Insert 2 new columns to the left.
In the second column add an asterisk * to the header cell, and then pull down to fill in the rest of the column.
In the first column add the function:
=CONCATENATE(F1,G1) ← with F is asterisk column * G is OCLC Masterpiece
click return key:
First (header) cell should display *OCLC Masterpice
Pull down to populate the rest of the cells in the column with their concatenate functions.
Then Copy the entire *OCLC column, and Paste as Values in the same column.
Finally, delete * asterisk column and the unadorned OCLC Masterpiece column.
Change the new *OCLC Masterpiece column to 035a
Save the Excel New Barcodes file as Text (Tab Delimited)
I usually give it a new name, at this point (optional)
MarcEdit Conversion and Edits
Open MarcEdit; then Tools; Delimited Text Translator
Source File: [file name, such as: NewBarcodes-Y4Hearings-Y4-3]
Output File: [new name such as NewbarcodesY4HearingsOverBrief-Y4-3…]
Click Import File (formerly Next)
Manually enter in each column (fields) and map them to MARC fields
Use the Data Snapshot as a guide:
Use Select to pick each Data shapshot field
In Map To: type MARC tag+1st subfield;
Then Indicators;
(No terminal punctuation is needed for this project).
Then click Add Argument
Field for checking or error resolution in blue:
Field 5 035a Indicators: \\ no terminal punctuation
Field 0 099$a Indicators: \\ no terminal punctuation
Field 1 245$a Indicators: 10 no terminal punctuation
Field 2 590$a Indicators: \\ no terminal punctuation
Field 3 907$a Indicators: \\ no terminal punctuation
Field 4 949$a Indicators: \\ no terminal punctuation
Click Add Argument to enter each mapping. The MARC fields will show up in the Arguments preview:
you can right-click in the Add Argument box to Delete or Edit if there are any problems
you can also select one argument (or more) and use the blue circled arrows to move it up or down
Click Finish.
Edit the Brief Records in MarcEdit: --Melanie’s edits are made to HERE……….
In MarcEdit; open MarcEditor; Open, then navigate to the new MARC mnemonic (.mrk) file
You can doublecheck the mappings by looking over the first mock record in the file to see that the tags and mapping match.
Go to Reports; Field Count to make sure the number of records is correct
(records number should be the numbers of the 001, 035, & 245 field count; HOWEVER, the first mock record will be counted: so subtract 1 for the correct number)
Use Edit; Find; Replace to get rid of CSV double-quotes.
Find: " (one double quote)
Replace: (with nothing)
Replace all to clean up the entire file.
Then fix any 500 quoted notes (which were protected back in the spreadsheet by replacing their quotation marks with carets):
Find: ^ (inverted caret)
Replace: " (double quote)
Like so:
=500 \$aInstitution name listed as ^Utah State Agricultural College^ on the title page.
=500 \$aInstitution name listed as "Utah State Agricultural College" on the title page.
Then File; Save (it’s a good idea to do a save after each major edit).
Use Edit; Find on each field to check for errors
Check the subfield d’s in the 100 fields which often have problems:
Edit; Find: =100
Edit; Find; Replace
Find what: $d$e ← which won’t occur anywhere else in the records.
Replace with: ,$e ← [comma]$e
Edit; Find; Find All on =245 for each article (as below) to check for titles with articles that are missing a skip indicator. This is usually caught by MarcEdit, but sometimes…
=245 10$aA ← add a single [space] after each to avoid title words starting with 'A'
=245 10$aAn ← add a single [space] after each…
=245 10$aThe ← add a single [space] after each…
fix any articles found using Edit; Find; Replace:
Find: =245 10$aThe ← add a single [space]
Replace: =245 14$aThe ← add a single [space]
Add our local constant Data:
Field: 590, field text: \\$aThesis Remediation Project.
Field: 655 field text: \7$aAcademic theses$2lcgft
Field: 710 field text: 2\$aUtah State University.
Scroll down to look for egregious errors in our locally generated (variable and local constant data) fields, especially for our descriptive/searchable tags, but don’t get lost in the weeds.
Then Save the file of cleaned up brief records.
Batch-search Connexion with OCLC numbers:
In Excel and Notepad, create a text file of OCLC numbers for the batch search in OCLC Connexion.
If not already done, copy/paste OCLC numbers to a new column; replace (OCoLC) with * then name the column: OCLC batchsearch.
Select all the OCLC numbers; right-click; choose format cells; & change Category to text.
Copy and paste the cells in the OCLCbatchseach column to Notepad; save as text; with an easy to find title, in this format: OCLCnosOV-year
Note the number of *OCLC rows (records).
In Connexion, go to File; Local File Manager; choose an empty Local Save File path (or make a new one).
Do a search/return key to make sure there are no records lingering in there;
Delete any lingering records.
Go to Batch; Enter Bibliographic Search Keys; Import.
Navigate to your text file of *OCLC numbers, make sure the Default Index is: None, and click Open.
Always click Don’t Delete, when asked.
The text file should load into the Bibliographic Batch Search Window; click Save; then close window.
In Local File Manager; Set up Authorizations; add Authorization & Password; Save & Login.
Go to Batch; Process Batch;
make sure the empty Local Save File is still selected (if not, select it now).
Only Online Searches should be clicked.
Click OK;
The OCLC numbers should scroll down the view window, until all have been searched.
Finally, a Batch Search Report will appear; go down to the last save number in the report; it should equal the number of *OCLC row numbers that you wrote down earlier.
The Local Save File should have received all the records.
Go to Search; Local Save File; then hit Search, leaving the search box blank.
Select every record in the batch save file.
Export; name the export file, something like this: THESES-OCLCbatchsearchOver-year.
Open MarcEdit; click on MARC Tools icon; leave Select Operation as MarcBreaker;
Open (choose All Files): Theses-OCLCbatchsearchOver-year
Save As: Theses-OCLCbatchsearchOVER-year
Leave Default Character Encoding as MARC8
Click Execute; then click on Edit Records:
Edit; Find/Replace: =049 \$aUUSA to =049 \$aUUSP
Delete these fields which we will be replacing with our updated versions:
Tools; Add/Delete Fields, fill in the tag in Field; and leave Field Data blank; then click Delete Field:
Field: 100
Field: 245
Field: 260
Field: 264
Field: 300
Field: 502
Field: 520
For the following Fields, we will be deleting certain duplicate versions, using Add/Delete Fields:
Field: 655 Field Data: \7$aAcademic theses.$2lcgft
Field: 655 Field Data: \4$aAcademic theses.
check for other versions of 655 Academic theses headings to delete, but don’t remove FAST headings:
=655 \7$aAcademic theses.$2fast$0(OCoLC)fst01726453
Check that 504 fields have: Includes bibliographical references (and change any incorrect), but don’t add them where they are missing.
Jump to Record to fix incorrect text.
Save for Merge step.
Merge Brief file and OCLC batch-searched file records together.
Go to Tools, MARC Processing Tools, Merge Records, then navigate to the two files, as in this example:
Source file: Theses-OCLCbatchseach-year.mrk → (OCLC batch-searched/edited records)
Merge File: Theses-mergeOVERLAY-Brief-year.mrk → (brief records with our data)
Save file: Theses-mergedOVERLAY-year.mrk → (future file of merged records)
Record identifier: 035$a → (Important Matchpoint)
Click Next to begin selecting the fields to merge.
Select/type each field to be merged into the OCLC batch-searched file; click the Green arrow to select each:
049 UUSP
099 local call number
100 Author (our corrected version)
245 Title (ours)
264 RDA production date (ours)
300 Physical description (ours)
500 Department & transcribed note
502 RDA standardized thesis statement
520 Scrapped summary
590 Project name
655 Academic theses genre term
690 local subject strings
710 university
907 Sierra bib-number for overlay
949 automatic item record creation
Then click Next to do the merge.
Batch copy catalog the merged records in MarcEdit:
Reports; Field Count; to check the merge worked (001, 035, & 245 fields should match number of records);
Edit; Find; Find All various fields, search for egregious errors, etc.
Compile cleaned up merged files into MARC format: ThesesmergedOVERLAYdone-year.mrc
Load file into Sierra and track:
Use the first load table: LOAD/Overlay bibs & create items (.briefbiboverlay), and remember to click on “use review files”;
Do a Test load first; then if the test goes well; Load.
Go to Create Lists; Copy; find file, looking somewhat like this:
LOAD: inserted files for ThesesmergedOVERLAYdone-year (#) ← number of bib records loaded in parentheses
Click on a few records and make sure the records loaded properly.
Leave the Load list in Create Lists for later Global Edit in Sierra.
Return to the OVERLAY view in the Thesis Date Pull Airtable & record the Date Loaded in Sierra.
Report the Load for the Global Update step to the Batch Thesis Cataloger:
Send an email with the subject line: Global Update for Thesis Batch Load.
Give the name of the load in the body of the email, something like this:
I have just loaded ThesismergedOVERLAYdone-1926. It is ready to have the item records' call number tags changed from 090 to 099.
The item records will be changed from 090 to 099; after the global edit, and the Create Lists file will be removed.
Statistics for Merge Overlay Procedures
Report the total number of MARC records (not items) imported into Sierra during this process in the “MARC Batch-Modified” column in the “Statistics” Airtable base.
Done!
Detailed Procedures for New Barcodes, Ready for New Cataloging
Barcoded, Ready for New Cataloging
General Workflow:
MarcEdit original record creation: export AirTable records → Open in Excel spreadsheet and edit → use MarcEdit Tab Delimited Convertor to create MARC records (.mrk) → check/edit MarcEdit Brief Records → edit fixed fields to match variable fields as needed → compile into MARC (.mrc) format for importing into OCLC.
Import/Produce newly created MARC records in OCLC: without logging into OCLC → Run OCLC validation and fix errors as necessary → login to OCLC when done and update holdings → records will receive OCLC numbers → export records to desktop → import batch file into Sierra → Global edit Item Record call numbers to 099 → DONE.
MarcEdit additions to include for Original Record Process
049 – UUSH
086
33x fields
Detailed Procedures for Original workflow:
UNDERGOING REVISION: please wait before using
Spreadsheet manipulations:
Go to AirTable
Click on the Sign Up tab, Batch Loading view; and sign up for a thesis year.
Batch Loader: you
Batch Load Status: In Progress
Fill in Batch Load Start Date and (if needed during the process) Notes.
Go to Title List and the view: Original Batch Work
Choose just one year at a time to work on (if you don’t, individualized editing will be necessary later on).
Check all essential fields are filled:
Flag any problems (incomplete, problem, etc.)
Check for missing barcodes in 949s (do not select)
Download CSV file of items within a year, or download entire view and delete rows of other years later.
Open Excel; Open other workbooks; on Computer; Desktop; choose All Files; navigate to the CSV file (under title: Title list-Melanie - Original Batch Work, & Save as an Excel File with new name, (something explanatory like: Theses-Original-year).
Delete all but your chosen year in the spreadsheet, if not done before.
Remove any columns no longer needed for the MARC record:
Thesis (year-#-author), Batch Cataloging in Process, OCLC # (which will be empty), Batch Type, Date Loaded in Sierra, and Status
And keep these columns (all MARC fields):
099
100
245
264
300
500’s
502
690’s
all 949’s (including empties)
Save the Excel Original file as Text (Tab Delimited);
new name: Theses-Original-year.
Double quotation marks protection:
To separate and protect actual quoted notes from CSV escape symbols:
Click on the corner of the spreadsheet to select the entire file;
Go to Find and Select; then Replace;
Find what: " (double quote)
Replace with: ^ (inverted caret).
Save file.
Convert to a file of MARC records using MarcEdit with our AirTable data:
Open MarcEdit: Tools; Delimited Text Translator;
Source File: Theses-Original-year
Output File: [new name such as Theses-Original-MARC-year.mrk
Fixed Fields (Leader)
In the Options portion of the Delimited Text Translator, click on the blue Edit LDR/008:
For the Leader, make sure the dropdown says: Book.
While still in the LDR, change nam to ntm and Ia to Ki:
00000nam 2200000Ia 45e0
00000ntm 2200000Ki 45e0
t = manuscript monograph
K = OCLC minimal record (maybe should change to 7, the MARC21 equivalent as OCLC will be changing to that soon)
a = AACR2 to i=ISBD (used in combination with 040 rda code)
For the 008, copy & paste the blue 008 values into the 008 edit box (replacing year with the 4 digit year):
s9999\\\\xx\\\\\\000\0\und\d
syear\\\\xx\a\\\bm\\000\0\eng\d
Be extremely careful in the 008: it is really easy to accidently delete or add a digit, and then the entire file will have faulty 008 fields.
Click OK.
Click Next to begin the task of selecting each column/field and mapping it to MARC.
Select or type: MARC tag; 1st subfield; and Indicators; no end punctuation needed in this project.
099$a Indicators: \\ no terminal punctuation
100$a Indicators: 1\ no terminal punctuation
245$a Indicators: 10 no terminal punctuation
264$c Indicators: \0 no terminal punctuation
300$a Indicators: \\ no terminal punctuation
500$a Indicators: \\ no terminal punctuation
500$a Indicators: \\ no terminal punctuation
502$b Indicators: \\ no terminal punctuation
690$a Indicators: \\ no terminal punctuation
690$a Indicators: \\ no terminal punctuation
949$a Indicators: \\ no terminal punctuation no terminal punctuation
Click Add Argument to enter each mapping.
The MARC fields will show up in the Arguments preview; right-click to Delete or Edit.
Note that Calculate common nonfiling data is checked. This will automatically adjust the 245 indicators for A, An, or The in the first word of a title of a record.
Finish.
In MarcEdit; open MarcEditor; then find the new MARC mnemonic (.mrk) file
Use Reports; Field Count to make sure the number of records is correct (the first mock record will be counted; subtract 1 for the correct number)
Use Reports; MARCvalidator to check records have been entered correctly during the conversion process:
If errors are found; fix them, if it isn’t major, otherwise, go back and run the conversion again.
Use Edit; Find; Find: " (double quotes) for odd double quotes around entire text in fields where it is not called for.
Then use Edit; Find; Replace:
Find: "
Replace: (with nothing)
Replace all
Change ^ (caret) back into " (double quotes):
Find: ^ (caret)
Replace " (double quotes)
Replace all.
Use Edit; Find; Find All on each field to check for errors; then add local constant data:
Add 040, field text: \\$aUUS$beng$erda$cUUS
Add 049, field text: \\$aUUSP
Add 590 field text: \\$aThesis Remediation Project.
Add 655 field text: \7$aAcademic theses$2lcgft
Add 710 field text: 2\$aUtah State University.
Scroll down the MARC records and check for GAPS after adding all those fields (which will affect all records):
Once the the adds have gone through without major hiccups, run Reports; MARCValidator, to make sure all is well.
Next, add the 33x RDA format fields, but instead of adding them individually…
Add 336
Add 337
Add 338
Use the RDA Helper in Tools with everything except Add 336, 337, 338 deselected:
It’s a great time saver.
Change ^ (caret) back into “ (double quotes):
Find: ^ (caret)
Replace " (double quotes)
Replace all.
Edit fixed field 008 in first record, if 008 fields come through incorrectly:
This will only edit one record at a time and for that record all the other codes will need to be typed in.
Place cursor at the beginning of the first record, the click on Edit; Insert/Edit 008; and choose Book:
Edit all the values for these areas (leave the backslashes or zeroes in place for all others):
Type: t
Ills: a
Cont: bm
Srce: d
Lang: eng
Ctry: xx
Dates: year of production
Click OK
In order to fix all the other record's 008 fields; use Find/Replace with the old 008 fields copy/pasted from an unedited record in the Find box and the newly edited 008 on the first record in the Replace box.
Find: =008[old 008 data from unedited record]
Replace =008[newly edited data from edited record]
Look at the recently edited 008 fields by Edit; Find, and scan down the find screen to look for oddities, such as missing indicators or jagged lines showing too short 008s with missing codes.
Also, recheck edited fields by validating: Edit; MARCValidator and fix 008 errors.
Finally, delete the first mock record: Edit; Delete Records; By Range; and type in 1; then click OK:
And the mock record will disappear.
Scan through record for egregious errors in any other Fields, especially for descriptive/searchable tags; but try not get lost in the weeds.
Save the file of cleaned up records.
Compile into MARC: ThesesOriginalDONE-year.mrc
Import new original theses records into OCLC:
In OCLC Connexion:
First time: Set up the File; Local File Manager to create a new Local Save File path. If already created, skip this step.\
Configure the path; Close.
Each time: If the File Path has already been set up:
Any time you are ready to import new records into OCLC make sure there are no earlier records left in the save file:
F3 and return without inputting a search; then delete any bibs found.
In Connexion, but without logging in:
File; Import Records; navigate to record file in MARC21/MARC8.
Click on Import to Local Save File Bibliographic: should show the new File Path for the save file.
Click OK.
Connexion will immediately import the file into the Save File, but since you are not logged in the records will not yet receive OCLC record numbers. A Report with the Import results will pop up: it can be printed out (including as a PDF), if a record of the results will be needed.
Bring up the Connexion Save file with F3 and Return key without entering any search terms:
All of the records should be there in the Save file list and can be marked and/or previewed.
Delete the first “dummy” record that was created by Marcedit (the one containing empty fields); ignore if dummy record is not there.
Mark entire set of records in save file with Shift-Control.
Then Edit; Validate entire file:
Fix any errors, or if too many errors, delete entire saved records in OCLC save file, and go back to MarcEdit to fix the problems there; then, redo import with clean records.
After all records validate without errors in Connexion, take a quick check for punctuation errors of one or two bibs, and if all checks out, then:
Log into Connexion and mark entire set of records,
Then: Action; Holdings; Produce/Update Holdings
Each record should be assigned a new OCLC #
Mark and Export entire file to desktop.
Name the file of new records something memorable and easy to pick out of a list: ThesesOriginalDONE-year
Load file into Sierra:
Use the first load table; and remember to click on “use review files”; do a test load first; then if the test goes well; Load.
Go to Create Lists; Copy; find file, looking somewhat like this:
LOAD: inserted files for ThesesOriginal-MARC-year (6)
Click on a few records and make sure the records loaded properly.
Leave the Load list in Create Lists for later Global Edit in Sierra.
Return to the ORIGINAL view in the Thesis Date Pull Airtable & record the Date Loaded in Sierra.
Report the Load for Global Update step in Sierra, or, if just a handful of records, do the edits manually in the Createlist file:
Item Record: Call Number code from 090 to 099.
Done!
Statistics for Procedure 4
Because there is no need to pull items physically for Procedure 4 and the number of items barcoded and reviewed has already been recorded, there is no need to record statistics in the “Barcoding Tracking, Issues, and Stats” Airtable base. Only record statistics in the main “Statistics” Airtable base.
For every record in either of the Merge processes (with or without overlay), record the number in the “MARC Batch - Modified” column
For every record in the Original process, record the number in the “MARC Batch-Created records” column
Add Comment