(S) Load vendor file [ven]

This profile is for loading item records from vendors
The label in Data Exchange is (S) Load vendor file [ven]
On the Sierra server it is called m2btab.ven

Table of Contents

Details

Type of records loaded

Bib and item records will be created.

Match points

Match on 020$a first
If no match on 020$a check 022
If no match on 022 check 024

Code:

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

Overlay action

0 matches: Insert new bib
1 match: Attach record
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 the target 856 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: tabeb

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 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=ven;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="ven"
/^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 will set the CAT DATE to today on new or overlaid bib records.

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

856 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
.*~

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 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 - 582	n
583	NOT LOADED Action Note – used in Marmot item records, not bib records Often includes junk from other systems in OCLC
584 - 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 - 789	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 - 866	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 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 may not be accurate.
909 - 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	Item d	Move to 945 in item record, field group tag d
950 - 959	y
960 - 961	NOT LOADED Used for creating order records, not needed to live in bib records
962 - 987	y
988 - 989
990 - 994	y
995	m	Ignores incoming field and loads text “Loaded with m2btab.b in this month”
996	y
998	NOT LOADED
999	y

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-582||+|0|0|b|n|0|y|N|0|
#583||+|0|0|b|n|0|y|N|0|
584-589||+|0|0|b|n|0|y|N|0|
590||+|0|0|b|v|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|v|0|y|N|0|%map="m2bmap.art"
856||+|0|0|b|y|0|y|N|0|%map="m2bmap.not"
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|1|
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.ven 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 every 949 1 control field. Defualt item template is tapei. Settings from the template are overridden by the control field.

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||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||w|0|0|i|g|0|n|N|1|
/^949 1||f|0|0|i|n|0|n|N|1|

Top of page

(S) Load vendor file [ven]

Details

FIXED FIELDS

VARIABLE FIELDS

Related Documentation