Versions Compared

Old Version 23

changes.mady.by.user Lloyd Chittenden

Saved on

compared with

New Version Current

changes.mady.by.user Lloyd Chittenden

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Description

  • This is a load profile for loading MARC 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

Table of Contents
maxLevel3

...

...

Details

Expand
titleType of records loaded

Bib and item records will be loadedcreated.

Expand
titleMatch 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
titleOverlay action

0 matches: Insert new bib

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

2 matches: Reject

Code:

Code Block
|||0|0| | |0|n|G|0|@ov_action="c"
Expand
titleProtected fields

Fixed fields

  • SPEC’L USE

Variable fields (If data in both target and incoming field, retain both)

  • n 583

  • v 590

  • y 948

  • y 958

  • m 995

  • 8 HOLD

  • h LIB HAS

Variable fields (If data in both target and incoming field, keep target data only)

  • v 69[0-9]

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)

Expand
titleTemplates

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.

Image AddedImage Added

Code:

Code Block
/^999||o|0|20| | |0|n|G|0|#com="dflt"@dflt="tapeb,tapei"
Expand
titleInteractive 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

Info

Format:

Code Block

949

\\$a*recs=msc;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="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"
Expand
titleCAT DATE

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

Code Block
|||0|0| | |0|n|G|0|@cdate="y"
Expand
title001 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
Expand
title856 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
titleFields 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

y

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

t

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 -

997

y

999

y

Expand

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

titleMARC 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

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|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 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-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-784 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-937||+|0|0|b|y|0|y|N|0|
#938 NOT LOADED
939-947||+|0|0|b|y|0|y|N|0|
#948 NOT LOADED
949|945|+|0|0|i|d|0|y|N|0|
950-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.msc in this month
996-999||+|0|0|b|y|0|y|N|0|
Expand
titleItem 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
(

no idea what this is for

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
languagenone
|||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
 \1$z090$dPRE$cE842$b.D28 2003$eSUF$h13$i1050003456789$lculmb$mMESSAGE$t18

Top of page

Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.

cataloger
Page Properties
hiddentrue
Related Labels
labels
/^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|

Related Documentation

Page Properties
Filter by label (Content by label)
showLabelsfalse
cqllabel = "sierra" and label = "cataloging" and label in ( "cataloger" , "copy_cataloger" , "acquisitions_staff" , "metadata_staff" , "marc_record_loading" )

Top of page