Created by Melanie Shaw
...
A-OCLC Connexion traditional bib record creation for each Serial Record Set by Congress bib,
B- Copy from Airtable 949 fields for item record creation,
...
E-Import into Sierra.
...
Full Workflow
A. Create
...
Record Set by Congress bibliographic records
Claim a numbered Congress in Congress Details tab in the Congressional Record Airtable base:
Note that each Congress includes the number of the Congress in the “Congress” column and the years for that Congress in the “Date Range” column. Both of these pieces of information will be needed for the subsequent steps
Create a new record in OCLC Connexion and apply the Constant Data named XXXXX.
In the fixed fields, fill in DtSt: s& the ending year in Dates
In the 245 & 246 fields, add the ordinal number from the Congress column and copy/paste its full dates for each (Copy from the Date Range column in the Congress Details tab in Airtable)
In the 260 $c add the end year
In the 300, add the number of volumes in the full set (found in the Number of Volumes column in the Congress Details tab)
...
Go to the “Present at USU” view in the Congressional Record tab, here: https://airtable.com/tblyEGJkFIYwnwkeu/viwUBYnJNn9Qik7vg?blocks=hide
The view will already have one filter in place: Where Barcode is not Empty.
Duplicate the view and rename the new view something memorable like: Barcoded Items 18th 949s, or just add filters to the Barcoded view, if you prefer.
Add this filter: Where Congress contains 18th
Scroll to the 949 column and select all its rows and Ctrl-C to copy.
Note that there are two 949 columns - one with the subfield $ and one with subfield ǂ. You will need to choose the appropriate column for the version of Connexion you are using.
Create a new field at the bottom of the bib record; then position cursor at the beginning of it and Ctrl-V
OCLC Connexion should recognize each return as a new field line for each copied cell.
Finally, if you added filters to the “Present at USU “ view, remove your filters, being extra sure to leave the first filter: Where Barcode is not Empty, in place when you finish.
...