(B) Load a non-OCLC MARC file [msc]

Description

This is a load profile for loading non-OCLC bibliographic MARC records
The label in Data Exchange is (B) Load a non-OCLC MARC file [msc]
On the Sierra server it is called m2btab.msc

Table of Contents

Details

Type of records loaded

Bib and item records will be created.

Match points

First: 020a

Second: 022

This will first look for matches in 020a. If it does not find any matching 020a fields, then it will check 022.

Code:

/^999||t|0|10| | |0|n|G|0|#com="ov"@ov_tag="i(020)v:i(022)i"

Overlay action

0 matches: Insert new bib

1 match: Attach item only (no overlay, insert 995)

2 matches: Reject

Code:

|||0|0| | |0|n|G|0|@ov_action="c"

Protected fields

All fields are protected because this loader will never overlay a bib

It will only insert a new bib or attach an item to an existing bib (and insert a 995)

Templates

Bib: tapeb

Item: tapei

These are the default templates in Marmot loaders. The template settings only take effect if that field is not defined in any other way by the record load.

Code:

/^999||o|0|20| | |0|n|G|0|#com="dflt"@dflt="tapeb,tapei"

Interactive 949 // commands

These commands will override defaults. This is rarely used.

recs = Load profile
bn = bib location
ct = Cat Date
b1 = Bib Lvl
b2 = Mat Type
b3 = Spec’l Use
la = Language
cy = Country

Format:

949 \\$a*recs=msc;bn=cu;ct=01-18-2021;b1=m;b2=a;b3=w;la=spa;cy=cou;

Code:

/^999||z|0|10| | |0|n|G|0|#com="recs"@recs="msc"
/^999||a|0|30|b| |26|n|N|0|#com="bn"
/^999||c|0|8|b| |28|n|N|0|#com="ct"
/^999||d|0|1|b| |29|n|N|0|#com="b1"
/^999||e|0|1|b| |30|n|N|0|#com="b2"
/^999||f|0|1|b| |31|n|N|0|#com="b3"
/^999||g|0|3|b| |24|n|N|0|#com="la"
/^999||k|0|3|b| |89|n|N|0|#com="cy"

CAT DATE

Will never change a CAT DATE because it will not overlay. If a new record is inserted because there are no matches, then it will set CAT DATE to today.

Code:

|||0|0| | |0|n|G|0|@cdate="y"

001 field processing

Processed by m2bmap.sky translation map.

This translation map removes OCLC prefixes from 001 field. Other prefixes are left in place. SkyRiver prefix is left in place.

Code:

001||%|0|0|b|o|0|y|N|0|%map="m2bmap.sky"

m2bmap.sky:

@case=true
@stop_on_map=true
^(001)$0ocl70*([1-9][0-9]*)$1|\0\1
^(001)$0ocm0*([1-9][0-9]*)$1|\0\1
^(001)$0ocn([1-9][0-9]*)$1|\0\1
^(001)$0on([1-9][0-9]*)$1|\0\1
^(001)$0( *[a-zA-Z].*)$1|\0\1
^(001)$0(.*)$1|\0prefix\1

Fields loaded

FIXED FIELDS

Incoming	Output
008 Language	LANG fixed field
008 Country	Country fixed field
Leader BLvl	Bib Lvl fixed field
Leader Type of Record	Mat Type fixed field

VARIABLE FIELDS

Incoming field	Output field group tag	Notes
001	o	OCLC prefix removed Other prefixes left in place
002 - 007	y	The incoming 005 is retained. Sierra does not change the 005. It should reflect the date the record was last updated where ever the record came from.
008	y	Modified to add some fields from Leader, these fields returned to Leader on export
009	y
010	l
013 - 018	y
019	o
020 - 024	i
025	y
027 - 028	i
030 - 049	y
050 - 084	j
086	g
088	j
090 - 099	j
100 - 111	a	Exclude subfield w
130	t	Exclude subfield w
210	y
211 - 222	u
240	t	Exclude subfield w
241 - 243	u
245	t
246 - 247	u
250	e
254 - 257	y
260 - 262	p
263	y
264	p
265	y
270	p
300 - 399	r
400 - 490	s	Exclude subfield w
500 - 589	n
600 - 689	d	Exclude subfield w
690 - 691	v	Exclude subfield w
692 - 699	d	Exclude subfield w
700 - 711	b	Exclude subfield w
720	y	Exclude subfield w
730 - 740	u	Exclude subfield w
752 - 755	y
760 - 777	q
780	x
785	z
786	y
787	w
800 - 811	s	Exclude subfield w
830	s	Exclude subfield w
840	s	Exclude subfield w
841 - 855	y
856	y
866	h
867 - 868	y
880	y
898	y
900 - 906	y
909 - 937	y
939 - 947	y
949	Item d	Move to 945 in item record, FGT d
950 - 959	y
962 - 987	y
990 - 994	y
995	m	Ignores incoming field and loads text “Loaded with m2btab.msc in this month”
996 - 997	y
999	y

MARC tags not loaded

	Notes
011
012	Only used by CONSER
026	Only used in rare book cataloging
029	OCLC uses this for non-OCLC control numbers
085	Synthesized Classification Number Components
087
089
112 - 129
131 - 209
223 - 239
244
248 - 249
251	Only used in rare book cataloging
252 - 253
258 - 259
266 - 269
271 - 299
491 - 499
590 - 599	Reserved for local notes
712 - 719
721 - 729
741 - 751
756 - 759
778 - 779
781 - 784
788 - 789
812 - 829
831 - 839
857 - 865
869 - 879
881 - 897
899
907 - 908	Used to store local record numbers when records are exported Can be confusing if these are loaded into the system and stored, they may be exported again and will not be accurate.
938	Often filled with junk from other local systems
948	Used to record our authority vendor loading information
960 - 961	Used for creating order records, not needed to live in bib records
988 - 989
998

Field loading code:

008|| |35|3|b| |24|n|N|0|lang(b)
008|| |15|3|b| |89|n|N|0|country
L|| |7|1|b| |29|n|N|0|bib lvl
L|| |6|1|b| |30|n|N|0|mat type
001||%|0|0|b|o|0|y|N|0|%map="m2bmap.sky"
002-006||%|0|0|b|y|0|y|N|0|
007||%|0|0|b|y|0|y|N|0|
008-009||%|0|0|b|y|0|y|N|0|%008="y"
010||+|0|0|b|l|0|y|N|0|
013-018||+|0|0|b|y|0|y|N|0|
019||+|0|0|b|o|0|y|N|0|
020-024||+|0|0|b|i|0|y|N|0|
025||+|0|0|b|y|0|y|N|0|
027||+|0|0|b|i|0|y|N|0|
028||+|0|0|b|i|0|y|N|0|
030-049||+|0|0|b|y|0|y|N|0|
050-084||+|0|0|b|j|0|y|N|0|
086||+|0|0|b|g|0|y|N|0|
088||+|0|0|b|j|0|y|N|0|
090-099||+|0|0|b|j|0|y|N|0|
100-111||-w|0|0|b|a|0|y|N|0|
130||-w|0|0|b|t|0|y|N|0|
210||+|0|0|b|y|0|y|N|0|
211-222||+|0|0|b|u|0|y|N|0|
240||-w|0|0|b|t|0|y|N|0|
241-243||+|0|0|b|u|0|y|N|0|
245||+|0|0|b|t|0|y|N|0|%bracket="h"
246-247||+|0|0|b|u|0|y|N|0|
250||+|0|0|b|e|0|y|N|0|
254-257||+|0|0|b|y|0|y|N|0|
260-262||+|0|0|b|p|0|y|N|0|
263||+|0|0|b|y|0|y|N|0|
264||+|0|0|b|p|0|y|N|0|
265||+|0|0|b|y|0|y|N|0|
270||+|0|0|b|p|0|y|N|0|
300-399||+|0|0|b|r|0|y|N|0|
400-490||-w|0|0|b|s|0|y|N|0|
500-589||+|0|0|b|n|0|y|N|0|
600-689||-w|0|0|b|d|0|y|N|0|
690-691||-w|0|0|b|v|0|y|N|0|
692-699||-w|0|0|b|d|0|y|N|0|
700-711||-w|0|0|b|b|0|y|N|0|
720||-w|0|0|b|y|0|y|N|0|
730-740||-w|0|0|b|u|0|y|N|0|%bracket="h"
752-755||+|0|0|b|y|0|y|N|0|
760-777||+|0|0|b|q|0|y|N|0|
780||+|0|0|b|x|0|y|N|0|
785||+|0|0|b|z|0|y|N|0|
786||+|0|0|b|y|0|y|N|0|
787||+|0|0|b|w|0|y|N|0|
800-811||-w|0|0|b|s|0|y|N|0|
830||-w|0|0|b|s|0|y|N|0|%bracket="h"
840||-w|0|0|b|s|0|y|N|0|
841-855||+|0|0|b|y|0|y|N|0|
856||+|0|0|b|y|0|y|N|1|
866||+|0|0|b|h|0|y|N|0|
867-868||+|0|0|b|y|0|y|N|0|
880||+|0|0|b|y|0|y|N|0|
898||+|0|0|b|y|0|y|N|0|
900-906||+|0|0|b|y|0|y|N|0|
#907-908||+|0|0|b|y|0|y|N|0|
909-937||+|0|0|b|y|0|y|N|0|
#938||+|0|0|b|y|0|y|N|0|
939-947||+|0|0|b|y|0|y|N|0|
#948||+|0|0|b|y|0|y|N|0|
949|945|+|0|0|i|d|0|y|N|0|
950-959||+|0|0|b|y|0|y|N|0|
#960-961||+|0|0|b|y|0|y|N|0|
962-987||+|0|0|b|y|0|y|N|0|
#988-989||+|0|0|b|y|0|y|N|0|
990-994||+|0|0|b|y|0|y|N|0|
|995|T|0|0|b|m|0|y|N|0|  |aLoaded with m2btab.msc in this month
996-997||+|0|0|b|y|0|y|N|0|
#998||+|0|0|b|y|0|y|N|0|
999||+|0|0|b|y|0|y|N|0|

Item records

The load will create one item record for each 949 1 field included in each MARC record.

Element	Incoming	Target
Call number MARC tag	subfield z	MARC tag
Call number prefix	subfield d	subfield d
Classification number	subfield a	subfield d
Cutter number	subfield b	subfield b
Call number suffix	subfield e or k	subfield e or k
Volume	subfield c	volume field
Local note	subfield f	variable local note
Copy number	subfield g	fixed copy number
Agency	subfield h	fixed agency number
Barcode	subfield i	variable barcode field
Price2	subfield j	variable price2 field (not currently used)
Location	subfield l	fixed item location field
Pop up circ message	subfield m	variable message field
Internal note	subfield n	variable internal note field
OPAC message	subfield o	fixed OPAC message field (only works in classic catalog)
Price	subfield p	fixed price field
Icode1	subfield q	fixed Icode1 field
Icode2	subfield r	fixed Icode2 field
Status	subfield s	fixed status field
Itype	subfield t	fixed Itype field
Item message	subfield u	fixed Imessage field
Owning location	subfield l	variable free text owning location field (not currently used)
eContent	subfield w	variable eContent field (used by Pika for electronic resources from Sierra, rarely used)

Format:

949 \1$z090$dPRE$cE842$b.D28 2003$eSUF$h13$i1050003456789$lculmb$mMESSAGE$t18

Code:

|||0|0| | |0|n|G|0|@link="i:1:949 1"
/^949 1|z|d:ab:ek|0|0|i|c|0|y|N|1|
/^949 1||c|0|0|i|v|0|n|N|1|#com="v"
/^949 1||f|0|0|i|n|0|n|N|1|
/^949 1||g|0|3|i| |58|n|N|1|#com="cop"
/^949 1||h|0|3|i| |127|n|N|1|#com="ag"
/^949 1||i|0|0|i|b|0|n|N|1|#com="i/a"@item
/^949 1||j|0|0|i|p|0|n|N|1|price2
/^949 1||l|0|5|i| |79|n|N|1|#com="loc"
/^949 1||m|0|0|i|m|0|n|N|1|
/^949 1||n|0|0|i|x|0|n|N|1|
/^949 1||o|0|1|i| |108|n|N|1|#com="om"
/^949 1||p|0|8|i| |62|n|N|1|#com="pr"
/^949 1||q|0|5|i| |59|n|N|1|#com="i1"
/^949 1||r|0|1|i| |60|n|N|1|#com="i2"
/^949 1||s|0|1|i| |88|n|N|1|#com="sta"
/^949 1||t|0|3|i| |61|n|N|1|#com="ty"
/^949 1||u|0|1|i| |97|n|N|1|#com="im"
/^949 1||v|0|0|i|l|0|n|N|1|
/^949 1||w|0|0|i|g|0|n|N|1|

(B) Load a non-OCLC MARC file [msc]

Details

FIXED FIELDS

VARIABLE FIELDS

Related Documentation