(K) Load b & o, match on i - 020 & 001 [acq2]

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

Table of Contents

Details

Type of records loaded

Bib and order records will be created.

Match points

Match on the BIB UTIL number, then 020a only if there are no BIB UTIL matches, then match on 024 if there is no 020 match.

If a BIB UTIL match is found 020a is ignored.

If a 020a match is found 024 is ignored.

Code:

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

Overlay action

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

Code:

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

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

SPEC’L USE

Code:

@ov_protect="b=V0123456789hk(970,971)m(995)n(583)v(590,69.,856:d)y(948,958)F31"

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:

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

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

Format:

949 \\$a*recs=acq2;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="acq2"
/^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"

CAT DATE

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

Code:

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

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:

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

m2bmap.:

@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

856 field processing

If the target record is in field group v LOCAL INFO and includes any of these strings:

|2pika
|2vufind
|2image
|2Pika
|2VuFind
|2Image

then the field is protected. No incoming 856 field with “|2pika” will load in that case.

All other 856 fields are not protected. They will be overlaid from the incoming record. If there is no 856 in the incoming record, they will be deleted from the target record.

Code:

856||+|0|0|b|v|0|y|N|0|%map="m2bmap.art"
856||+|0|0|b|y|0|y|N|0|%map="m2bmap.not"

m2bmap.art

@delimiter=~
@case=true
@stop_on_map=true
(.*|2pika.*)$0~\0
(.*|2vufind.*)$0~\0
(.*|2image.*)$0~\0
(.*|2Pika.*)$0~\0
(.*|2VuFind.*)$0~\0
(.*|2Image.*)$0~\0
.*~

m2bmap.not

@delimiter=~
@stop_on_map=true
@case=true
(.*|2pika.*)$0~
(.*|2vufind.*)$0~
(.*|2image.*)$0~
(.*|2Pika.*)$0~
(.*|2VuFind.*)$0~
(.*|2Image.*)$0~
(.*)$0~\0

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 Non-prefixed number will have “prefix” added.
002 - 007	y	13The 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 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

Field loading code

001||%|0|0|b|o|0|y|N|0|%map="m2bmap.sky"
002-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 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-758 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.acq2 in this month
996-999||+|0|0|b|y|0|y|N|0|

Item records

Every load will create one dummy item record based on the mdlholddum item template. There is no means to alter this dummy item.

Code:

|||0|0| | |0|n|G|0|@link="i:1:#1"
020||i|0|0|i|b|0|n|N|1|#com="i/a"@item

Order Records

Creates one order record with every load.

Order record data will be created based on the 960 and 961 fields.

Incoming field	Output field	Notes
960$a	ACQ TYPE
960$b	CLAIM
960$c	CODE1
960$d	CODE2
960$e	CODE3
960$f	CODE4
960$g	FORM
960$h	ORD NOTE
960$i	ORD TYPE
960$j	RACTION
960$k	RLOC
960$l	BLOC
960$m	STATUS
960$n	TLOC
960$p	CDATE
960$q	ODATE
960$r	RDATE
960$s	E PRICE
960$t	LOCATION
960$o	COPIES
960$u	FUND
960$v	VENDOR
960$w	LANG
960$x	SELECTOR
960$y	VOLUMES
020$a	ISBN PICK
961$a	IDENTITY
961$b	FOREIGN CURRENCY
961$c	NOTE
961$d	INT. NOTE
961$f	SELECTOR
961$g	VEN. ADDR.
961$h	VEN. NOTE
961$i	VEN. TITLE#
961$l	Blanket PO Number
961$p	Blanket PO Number

Order Record Code

|||0|0| | |0|n|G|0|@link="o:2:#1"
##order record fixed-length fields##
/^960||a|0|0|o| |1|n|N|2|acq type
/^960||b|0|0|o| |4|n|N|2|claim
/^960||c|0|0|o| |6|n|N|2|code1
/^960||d|0|0|o| |7|n|N|2|code2
/^960||e|0|0|o| |8|n|N|2|code3
/^960||f|0|0|o| |9|n|N|2|code4
/^960||g|0|0|o| |11|n|N|2|format
/^960||h|0|0|o| |14|n|N|2|ord note
/^960||i|0|0|o| |15|n|N|2|ord type
/^960||j|0|0|o| |16|n|N|2|raction
/^960||k|0|0|o| |18|n|N|2|rloc
/^960||l|0|0|o| |19|n|N|2|bloc
/^960||m|0|0|o| |20|n|N|2|status
/^960||n|0|0|o| |21|n|N|2|tloc
/^960||p|0|0|o| |3|n|N|2|cdate
/^960||q|0|0|o| |13|n|N|2|odate
/^960||r|0|0|o| |17|n|N|2|rdate
/^960||s|0|0|o| |10|n|N|2|eprice
/^960||t|0|0|o| |2|n|N|2|location
/^960||o|0|0|o| |5|n|N|2|copies
/^960||u|0|0|o| |12|n|N|2|fund
/^960||v|0|0|o| |22|n|N|2|vendor
/^960||w|0|0|o| |23|n|N|2|language
/^960||x|0|0|o| |100|n|N|2|selector
/^960||y|0|0|o| |106|n|N|2|volume
##order record variable-length fields##
/^020||a|0|0|o|b|0|n|N|2|PO info
/^961||a|0|0|o|i|0|n|N|2|identity
/^961||b|0|0|o|x|0|n|N|2|for curr
/^961||c|0|0|o|n|0|n|N|2|note
/^961||d|0|0|o|z|0|n|N|2|int note
/^961||f|0|0|o|s|0|n|N|2|selector
/^961||g|0|0|o|q|0|n|N|2|ven addr
/^961||h|0|0|o|v|0|n|N|2|ven note
/^961||i|0|0|o|f|0|n|N|2|ven title
/^961||l|0|0|o|p|0|n|N|2|blanket PO
/^961||p|0|0|o|p|0|n|N|2|blanket PO

Top of page

(K) Load b & o, match on i - 020 & 001 [acq2]

Details

FIXED FIELDS

VARIABLE FIELDS

Related Documentation