Page Comparison

This profile is for loading order records from vendors
The label in Data Exchange is (K3) Load b & o, o & i match 020 & 001 [acq2acq3]
On the Sierra server it is called m2btab.acq2acq3

...

Anchor

	topofpage
	topofpage

Table of Contents

...

Expand

title	Match points

Match on the BIB UTIL number.

Code:

Code Block
/^999\|\|t\|0\|10\| \| \|0\|n\|G\|0\|#com="ov"@ov_tag="o"

Expand

title	Overlay action

0 matches: Insert new bib
1 match: match and attach
2 matches: Insert new bib

Code:

Code Block
\|\|\|0\|0\| \| \|0\|n\|G\|0\|@ov_action="a"

Expand

title	Protected fields

Variable (retain both incoming and target data)

Field group: h LIB HAS
Field group: k TOC DATA
- MARC tags: 970, 971
Field group: m LOAD NOTE
- MARC tags: 995
Field group: n NOTE
- MARC tags: 583, 972
Field group: y MISC
- MARC tags: 948, 958

Variable (retain only target data, ignore incoming data)

Field group: v LOCAL INFO
- MARC tags: 590, 690, 691, 856 (only if target field contains “|2pika”)

Fixed

none

Code:

Code Block
@ov_protect="b=V0123456789d(69.)hk(970,971)m(995)n(583,972)v(856:d)v(.9.)y(948,958)"

Expand

title	Templates

Bib: tapeb

Item: mdlholddum

Order: _o

The template settings only take effect if that field is not defined in any other way by the record load.

Templates only effect fixed fields when loading records with load profiles.

Prompting for fields does nothing when loading records with load profiles.

Code:

Code Block
/^999\|\|o\|0\|20\| \| \|0\|n\|G\|0\|#com="dflt"@dflt="tapeb,mdlholddum"

Expand

title	Interactive 949 // commands

These commands will override defaults in the bib record. 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

Info

Format:

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

Code:

Code Block

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

|||0|0| | |0|n|G|0|

:

Expand

title	CAT DATE

This load will not set the CAT DATE. Records should not get a CAT DATE until they get an item attached.

Code:

Code Block

Code Block
@cdate="n"

Expand

title	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.

If there is only a number with no prefix, the word “prefix” is added as a prefix.

Code:

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

m2bmap.:

Code Block

@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

...

Expand

title	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 Allows non-prefixed number in the 001.
002 - 007	y	The incoming 005 is retained. Sierra does not change a 005. It should reflect the date the record was last updated where ever the record came from.
008 - 009	y	Modifies 008 to add some fields from Leader, these fields returned to Leader on export
010	l
011	NOT LOADED
012	NOT LOADED – Only used by CONSER
013 - 018	y
019	o
020 - 024	i
025	y
026	NOT LOADED – Only used in rare book cataloging
027 - 028	i
029	NOT LOADED – OCLC uses this for non-OCLC control numbers
030 - 049	y
050 - 084	j
085	NOT LOADED – Synthesized Classification Number Components
086	g
087	NOT LOADED
088	j
089	NOT LOADED
090 - 099	j
100 - 111	a	Exclude subfield w
112 - 129	NOT LOADED
130	t	Exclude subfield w
131 - 209	NOT LOADED
210	y
211 - 222	u
223 -239	NOT LOADED
240	t	Exclude subfield w
241 - 243	u
244	NOT LOADED
245	t
246 - 247	u
248 - 249	NOT LOADED
250	e
251	NOT LOADED – Only used in rare book cataloging
252 - 253	NOT LOADED
254 - 257	y
258 - 259	NOT LOADED
260 - 262	p
263	y
264	p
265	y
266 - 269	NOT LOADED
270	p
271 - 299	NOT LOADED
300 - 399	r
400 - 490	s	Exclude subfield w
491 - 499	NOT LOADED
500 - 589	n
590	v	Local note
591 - 599	NOT LOADED
600 - 689	d	Exclude subfield w
690 - 691	v	Exclude subfield w - Local Subject
692 - 699	d	Exclude subfield w
700 - 711	b	Exclude subfield w
712 - 719	NOT LOADED
720	y	Exclude subfield w
721 - 729	NOT LOADED
730 - 740	u	Exclude subfield w
741 - 751	NOT LOADED
752 - 755	y
756 - 759	NOT LOADED
760 - 777	q
778 - 779	NOT LOADED
780	x
781 - 784	NOT LOADED
785	z
786	y
787	w
788 - 799	NOT LOADED
800 - 811	s	Exclude subfield w
812 - 829	NOT LOADED
830	s	Exclude subfield w
831 - 839	NOT LOADED
840	s	Exclude subfield w
841 - 855	y
856	y or v	856 loads into FGT v if the string “\|2pika” is present in the field. However, the field is protected so this would only load if there were not already a matching field in the record. If there is already a \|2pika field, then this will not load. Otherwise 856 loads into FGT y.
857 - 865	NOT LOADED
866	h
867 - 868	y
869 - 879	NOT LOADED
880	y
881-897	NOT LOADED
898	y
899	NOT LOADED
900 - 906	y
907 - 908	NOT LOADED Used to store Sierra record numbers when records are exported This would be confusing if these were loaded into the system and stored, they would be exported again, and mixed up with current numbers for attached records.
909 - 916	y
917	NOT LOADED Used by Marquis for the bib record number for matching
918 - 937	y
938	NOT LOADED Often filled with junk from other systems in OCLC
939 - 947	y
948	NOT LOADED Used to record our authority vendor loading information
949	LOT LOADED Used to create items, but this loaded load does not create items
950 - 957	y
958	NOT LOADED
959	y
960 - 961	NOT LOADED Used for creating order records, not needed to live in bib records
962 - 987	y
988 - 989	NOT LOADED
990 - 994	y
995	m	Inserts the text “Loaded with m2btab.acq2 in this month” Ignores any data incoming from the loaded record
996 - 999	y

Expand

title	Field Bib field loading code

Code Block

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|
#011#012-012013 NOT LOADED
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|
#026 NOT LOADED
027||+|0|0|b|i|0|y|N|0|
028||+|0|0|b|i|0|y|N|0|
#029 NOT LOADED
030-049||+|0|0|b|y|0|y|N|0|
050-084||+|0|0|b|j|0|y|N|0|
#085 NOT LOADED
086||+|0|0|b|g|0|y|N|0|
#087 NOT LOADED
088||+|0|0|b|j|0|y|N|0|
#089 NOT LOADED
090-099||+|0|0|b|j|0|y|N|0|
100-111||-w|0|0|b|a|0|y|N|0|
#112-129 NOT LOADED
130||-w|0|0|b|t|0|y|N|0|
#131-209 NOT LOADED
210||+|0|0|b|y|0|y|N|0|
211-222||+|0|0|b|u|0|y|N|0|
#223-239 NOT LOADED
240||-w|0|0|b|t|0|y|N|0|
241-243||+|0|0|b|u|0|y|N|0|
#244 NOT LOADED
245||+|0|0|b|t|0|y|N|0|%bracket="h"
246-247||+|0|0|b|u|0|y|N|0|
#248-249 NOT LOADED
250||+|0|0|b|e|0|y|N|0|
#251-253 NOT LOADED
254-257||+|0|0|b|y|0|y|N|0|
#258-259 NOT LOADED
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|
#266-269 NOT LOADED
270||+|0|0|b|p|0|y|N|0|
#271-299 NOT LOADED
300-399||+|0|0|b|r|0|y|N|0|
400-490||-w|0|0|b|s|0|y|N|0|
#491-499 NOT LOADED
500-589||+|0|0|b|n|0|y|N|0|
590||+|0|0|b|v|0|y|N|0|
#591-599 NOT LOADED
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|
#712-719 NOT LOADED
720||-w|0|0|b|y|0|y|N|0|
#721-729 NOT LOADED
730-740||-w|0|0|b|u|0|y|N|0|%bracket="h"
#741-751 NOT LOADED
752-755||+|0|0|b|y|0|y|N|0|
#756-759 NOT LOADED
760-777||+|0|0|b|q|0|y|N|0|
#778-779 NOT LOADED
780||+|0|0|b|x|0|y|N|0|
#781-758784 NOT LOADED
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|
#788-799 NOT LOADED
800-811||-w|0|0|b|s|0|y|N|0|
#812-829 NOT LOADED
830||-w|0|0|b|s|0|y|N|0|%bracket="h"
#831-839 NOT LOADED
840||-w|0|0|b|s|0|y|N|0|
841-855||+|0|0|b|y|0|y|N|0|
856||+|0|0|b|v|0|y|N|0|%map="m2bmap.art"
856||+|0|0|b|y|0|y|N|0|%map="m2bmap.not"
#857-865 NOT LOADED
866||+|0|0|b|h|0|y|N|0|
867-868||+|0|0|b|y|0|y|N|0|
#869-879 NOT LOADED
880||+|0|0|b|y|0|y|N|0|
#881-897 NOT LOADED
898||+|0|0|b|y|0|y|N|0|
#899 NOT LOADED
900-906||+|0|0|b|y|0|y|N|0|
#907-908 NOT LOADED
909-916||+|0|0|b|y|0|y|N|0|
#917 NOT LOADED
918-937||+|0|0|b|y|0|y|N|0|
#938 NOT LOADED
939-947||+|0|0|b|y|0|y|N|0|
#948-949 NOT LOADED
950-957||+|0|0|b|y|0|y|N|0|
#958 NOT LOADED
959||+|0|0|b|y|0|y|N|0|
#960-961 NOT LOADED
962-987||+|0|0|b|y|0|y|N|0|
#988-989 NOT LOADED
990-994||+|0|0|b|y|0|y|N|0|
|995|T|0|0|b|m|0|y|N|0|  |aLoaded with m2btab.acq2acq3 in this month
996-999||+|0|0|b|y|0|y|N|0|

...

Versions Compared

Old Version 1

New Version Current

Key

FIXED FIELDS

VARIABLE FIELDS