Page Comparison

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

...

Anchor

	topofpage
	topofpage

Table of Contents

...

Expand

title	Type of records loaded

Bib and item records will be loadedcreated.

Expand

title	Match points

First: 020a

Second: 022

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

Code:

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

...

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.

Code:

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

m2bmap.sky:

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

FIXED FIELDS

VARIABLE FIELDS

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

Expand

title	Fields loaded

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

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

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

Expand

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

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

Expand

title	Field loading code:

Code Block

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:

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

Code Block
@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

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

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
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
011	NOT LOADED
013 - 018	y
019	o
020 - 024	i
025	y
026	NOT LOADED
027 - 028	i
029	NOT LOADED
030 - 049	y
050 - 084	j
085	NOT LOADED
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 - 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 - 599	NOT LOADED
600 - 689	d	Exclude subfield w
690 - 691	v	Exclude subfield w
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
909 - 937	y
938	NOT LOADED
939 - 947	y
948	NOT LOADED
949	Item d	Move to 945 in item record, FGT d
950 - 959	y
960 - 961	NOT LOADED
962 - 987	y
988 - 989	NOT LOADED
990 - 994	y
995	m	Ignores incoming field and loads text “Loaded with m2btab.msc in this month”
996 - 999	y

Expand

title	Field loading code:

Code Block

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|yo|0|y|N|0|%008%map="ym2bmap.sky"
010002-006||+%|0|0|b|ly|0|y|N|0|
013-018007||+%|0|0|b|y|0|y|N|0|
019008-009||+%|0|0|b|oy|0|y|N|0|
020-024%008="y"
010||+|0|0|b|il|0|y|N|0|
025
#011 NOT LOADED
013-018||+|0|0|b|y|0|y|N|0|
027019||+|0|0|b|io|0|y|N|0|
028020-024||+|0|0|b|i|0|y|N|0|
030-049025||+|0|0|b|y|0|y|N|0|
050-084#026 NOT LOADED
027||+|0|0|b|ji|0|y|N|0|
086028||+|0|0|b|gi|0|y|N|0|
088
#029 NOT LOADED
030-049||+|0|0|b|jy|0|y|N|0|
090050-099084||+|0|0|b|j|0|y|N|0|
100-111#085 NOT LOADED
086||-w+|0|0|b|ag|0|y|N|0|
130
#087 NOT LOADED
088||-w+|0|0|b|tj|0|y|N|0|
210
#089 NOT LOADED
090-099||+|0|0|b|yj|0|y|N|0|
211100-222111||+-w|0|0|b|ua|0|y|N|0|
240#112-129 NOT LOADED
130||-w|0|0|b|t|0|y|N|0|
241-243#131-209 NOT LOADED
210||+|0|0|b|uy|0|y|N|0|
245211-222||+|0|0|b|tu|0|y|N|0|%bracket="h"
246-247#223-239 NOT LOADED
240||+-w|0|0|b|ut|0|y|N|0|
250241-243||+|0|0|b|eu|0|y|N|0|
254-257
#244 NOT LOADED
245||+|0|0|b|yt|0|y|N|0|%bracket="h"
260246-262247||+|0|0|b|pu|0|y|N|0|
263#248-249 NOT LOADED
250||+|0|0|b|ye|0|y|N|0|
264
#251-253 NOT LOADED
254-257||+|0|0|b|py|0|y|N|0|
265#258-259 NOT LOADED
260-262||+|0|0|b|yp|0|y|N|0|
270263||+|0|0|b|py|0|y|N|0|
300-399264||+|0|0|b|rp|0|y|N|0|
400-490265||-w+|0|0|b|sy|0|y|N|0|
500-589#266-269 NOT LOADED
270||+|0|0|b|np|0|y|N|0|
600-689||-w#271-299 NOT LOADED
300-399||+|0|0|b|dr|0|y|N|0|
690400-691490||-w|0|0|b|vs|0|y|N|0|
692-699||-w#491-499 NOT LOADED
500-589||+|0|0|b|dn|0|y|N|0|
700-711
#590-599 NOT LOADED
600-689||-w|0|0|b|bd|0|y|N|0|
720690-691||-w|0|0|b|yv|0|y|N|0|
730692-740699||-w|0|0|b|ud|0|y|N|0|%bracket="h"
752700-755711||+-w|0|0|b|yb|0|y|N|0|
760-777#712-719 NOT LOADED
720||+-w|0|0|b|qy|0|y|N|0|
780||+0|
#721-729 NOT LOADED
730-740||-w|0|0|b|xu|0|y|N|0|
785%bracket="h"
#741-751 NOT LOADED
752-755||+|0|0|b|zy|0|y|N|0|
786
#756-759 NOT LOADED
760-777||+|0|0|b|yq|0|y|N|0|
787
#778-779 NOT LOADED
780||+|0|0|b|wx|0|y|N|0|
800-811#781-784 NOT LOADED
785||-w+|0|0|b|sz|0|y|N|0|
830786||-w+|0|0|b|sy|0|y|N|0|%bracket="h"
840787||-w+|0|0|b|sw|0|y|N|0|
841-855||+#788-799 NOT LOADED
800-811||-w|0|0|b|ys|0|y|N|0|
856#812-829 NOT LOADED
830||+-w|0|0|b|ys|0|y|N|1|
866||+0|%bracket="h"
#831-839 NOT LOADED
840||-w|0|0|b|hs|0|y|N|0|
867841-868855||+|0|0|b|y|0|y|N|0|
880856||+|0|0|b|yv|0|y|N|0|
898%map="m2bmap.art"
856||+|0|0|b|y|0|y|N|0|
900-906%map="m2bmap.not"
#857-865 NOT LOADED
866||+|0|0|b|yh|0|y|N|0|
#907867-908868||+|0|0|b|y|0|y|N|0|
909-937||+|0|0|b|y|0|y|N|0|
#938#869-879 NOT LOADED
880||+|0|0|b|y|0|y|N|0|
939-947#881-897 NOT LOADED
898||+|0|0|b|y|0|y|N|0|
#948#899 NOT LOADED
900-906||+|0|0|b|y|0|y|N|0|
949|945
#907-908 NOT LOADED
909-937||+|0|0|ib|dy|0|y|N|0|
950-959
#938 NOT LOADED
939-947||+|0|0|b|y|0|y|N|0|
#960-961|#948 NOT LOADED
949|945|+|0|0|bi|yd|0|y|N|0|
962950-987959||+|0|0|b|y|0|y|N|0|
#988-989
#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.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|

Expand

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

Info

Format:

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

Code:

Code Block

language	none

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

...

Versions Compared

Old Version 36

New Version Current

Key

FIXED FIELDS

VARIABLE FIELDS

FIXED FIELDS

VARIABLE FIELDS