MLN2 m2btab.oapi

  • This is a load profile used by the Sierra API for loading bibs, orders and invoices

  • This is not available in Data Exchange


Table of Contents

Details

Bib, item, and invoice records can be created

First: BIB UTIL

Second: ISBN (020)

This will first look for matches in any BIB UTIL field. If it does not find any matching BIB UTIL, then it will check ISBN in 020 tag.

Code:

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

0 matches: Insert new bib

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

2 matches: Insert new bib

Code:

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

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)

Bib: None

Item: None

There are no templates connected to this loader. It will default to the system default templates _b and _o if not given information for a field.

Code:

/^999||o|0|30| | |0|n|G|0|#com="dflt"@dflt=""

Interactive commands for bib fields are loaded with 999 rather than the standard 949

Element

Incoming

Element

Incoming

Bib Location

subfield a

Copies

subfield b

CAT DATE

subfield c

Audience

subfield d

Format

subfield e

BCODE3

subfield f

Language

subfield g

Country

subfield k

Format:

999 \\$a*recs=oapi;bn=bm;ct=01-18-2021;b1=m;b2=a;b3=-;la=spa;cy=cou;

Code:

/^999||a|0|30|b| |26|n|G|0|#com="bn" /^999||b|0|5|b| |27|n|G|0|#com="co" /^999||c|0|10|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"

This loader will not set the CAT DATE in the bib record, unless it is specified in a 999 command.

Code:

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

There is no processing of the 001 field. It will be loaded as is.

No special processing

FIXED FIELDS

Incoming

Output

Incoming

Output

008 Language

Bib LANG fixed field

008 Country

Bib 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

Incoming field

Output field group tag

Notes

001

o

No processing. Imports 001 as is.

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

NOT LOADED

020 - 023

i

 

024

v

 

025 - 027

y

 

028

v

 

029

NOT LOADED

030 - 034

y

 

035

o

 

036

NOT LOADED

037

y

 

038 - 039

NOT LOADED

040 - 050

y

 

051

NOT LOADED

052

y

 

053 - 059

NOT LOADED

060

y

 

061 - 069

NOT LOADED

070

y

 

071 - 073

NOT LOADED

074

v

 

075 - 081

NOT LOADED

082

y

 

085

NOT LOADED

086

g

 

087

NOT LOADED

088

y

 

089

NOT LOADED

090

y

 

091

NOT LOADED

092

y

 

093 - 096

NOT LOADED

097

y

 

098

NOT LOADED

099

y

 

100 - 111

a

Exclude subfield w

112 - 129

NOT LOADED

130

t

Exclude subfield w

131 - 209

NOT LOADED

210 - 214

u

 

215 - 221

NOT LOADED

222

y

 

223 - 228

NOT LOADED

229

u

 

230 - 239

NOT LOADED

240

t

Exclude subfield w

241 - 243

u

 

244

NOT LOADED

245

t

 

246

u

%map=("m2bmap.noperiod")

247

t

 

248 - 249

NOT LOADED

250

e

 

251 - 253

NOT LOADED

254 - 257

e

 

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

n

 

505

k

 

520

m

 

521 - 599

n

 

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

q

 

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

 

857 - 879

NOT LOADED

880

y

 

881

NOT LOADED

882 - 883

y

 

884 - 885

NOT LOADED

886

y

 

887 - 896

NOT LOADED

898

y

 

899

NOT LOADED

900 - 919

y

 

920

NOT LOADED

921 - 948

y

 

949

NOT LOADED

950 - 994

y

 

995

m

Ignores incoming field and loads text “Loaded with m2btab.oapi in this month”

996 - 998

y

 

999

NOT LOADED

008|| |35|3|b| |24|n|N|0|lang(b) 008|| |15|3|b| |89|n|N|0|country(b) 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| 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| 020-023||+|0|0|b|i|0|y|N|0| 024||+|0|0|b|v|0|y|N|0| 025-027||+|0|0|b|y|0|y|N|0| 028||ab|0|0|b|v|0|y|N|0| 030-034||+|0|0|b|y|0|y|N|0| 035||+|0|0|b|o|0|y|N|0| 037||+|0|0|b|y|0|y|N|0| 040-050||+|0|0|b|y|0|y|N|0| 052||+|0|0|b|y|0|y|N|0| 060||+|0|0|b|y|0|y|N|0| 070||+|0|0|b|y|0|y|N|0| 074||+|0|0|b|v|0|y|N|0| 082||+|0|0|b|y|0|y|N|0| 086||+|0|0|b|g|0|y|N|0| 088||+|0|0|b|y|0|y|N|0| 090||+|0|0|b|y|0|y|N|0| 092||+|0|0|b|y|0|y|N|0| 097||+|0|0|b|y|0|y|N|0| 099||+|0|0|b|y|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-214||+|0|0|b|u|0|y|N|0| 222||+|0|0|b|y|0|y|N|0| 229||+|0|0|b|u|0|y|N|0| 240||-w|0|0|b|u|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||+|0|0|b|u|0|y|N|0|%map=("m2bmap.noperiod") 247||+|0|0|b|t|0|y|N|0| 250||+|0|0|b|e|0|y|N|0| 254-257||+|0|0|b|e|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-504||+|0|0|b|n|0|y|N|0| 505||+|0|0|b|k|0|y|N|0| 506-519||+|0|0|b|n|0|y|N|0| 520||+|0|0|b|m|0|y|N|0| 521-599||+|0|0|b|n|0|y|N|0| 600-699||-w|0|0|b|d|0|y|N|0| 700-711||-w|0|0|b|b|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|q|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| 856||+|0|0|b|y|0|y|N|0| 880||+|0|0|b|y|0|y|N|0| 882-883||+|0|0|b|y|0|y|N|0| 886||+|0|0|b|y|0|y|N|0| 898||+|0|0|b|y|0|y|N|0| 900-909||+|0|0|b|y|0|y|N|0| 910||+|0|0|b|y|0|y|N|0| 911-919||+|0|0|b|y|0|y|N|0| 921-948||+|0|0|b|y|0|y|N|0| 950-994||+|0|0|b|y|0|y|N|0| |995|T|0|0|b|y|0|y|N|0| |aLoaded with m2btab.oapi in this month 996-998||+|0|0|b|y|0|y|N|0|

The load will create one order record for every record loaded. If there are no 960 fields it will use the information from the system default order template _o.

FIXED FIELDS

Incoming

Output

Incoming

Output

008 Language field

Order LANG field

008 Country field

Order COUNTRY field

960 $a

ACQ TYPE

960 $b

CLAIM

960 $c

CODE1

960 $d

CODE2

960 $e

CODE3

960 $f

CODE4

960 $g

FORMAT

960 $h

ORD NOTE

960 $i

ORD TYPE

960 $j

RACTION

960 $k

RLOC

960 $l

BLOC

960 $m

STATUS

960 $n

TLOC

960 $o

COPIES

960 $p

CDATE

960 $q

ODATE

960 $r

RDATE

960 $s

EPRICE

960 $t

LOCATION (Order)

960 $u

FUND

960 $v

VENDOR

960 $w

LANG

960 $x

COUNTRY

960 $y

VOLUME

VARIABLE FIELDS

Incoming field

Output

 

Incoming field

Output

 

020 $a

ISBN PICK

 

037 $a

ENTERED BY

 

961 $Ma i

IDENTITY

 

961 $b x

FOR. CURR.

 

961 $Mc n

NOTE

 

961 $Md z

INT. NOTE

 

961 $Me d

REF NOTE

 

961 $Mf s

RECOMMEND

 

961 $Mg q

VEN. ADDR.

 

961 $Mh v

VEN. NOTE

 

961 $Mi f

VEN. TITLE

 

961 $Mj a

ADDRESS

 

961 $Mk g

Tickler

 

961 $Ml r

REVIEWED

 

961 $Mm p

PUB REL DA

 

Format:

 

Code:

/^960||a|0|0|o| |1|n|N|1|acq type /^960||b|0|0|o| |4|n|N|1|claim /^960||c|0|0|o| |6|n|N|1|code1 /^960||d|0|0|o| |7|n|N|1|code2 /^960||e|0|0|o| |8|n|N|1|code3 /^960||f|0|0|o| |9|n|N|1|code4 /^960||g|0|0|o| |11|n|N|1|format /^960||h|0|0|o| |14|n|N|1|ord note /^960||i|0|0|o| |15|n|N|1|ord type /^960||j|0|0|o| |16|n|N|1|raction /^960||k|0|0|o| |18|n|N|1|rloc /^960||l|0|0|o| |19|n|N|1|bloc /^960||m|0|0|o| |20|n|N|1|status /^960||n|0|0|o| |21|n|N|1|tloc /^960||p|0|0|o| |3|n|N|1|cdate /^960||q|0|0|o| |13|n|N|1|odate /^960||r|0|0|o| |17|n|N|1|rdate #/^960||z|0|20|o| |0|n|N|1|%foreign /^960||s|0|0|o| |10|n|N|1|eprice /^960||t|0|0|o| |2|n|N|1|location /^960||o|0|0|o| |5|n|N|1|copies /^960||u|0|0|o| |12|n|N|1|fund /^960||v|0|0|o| |22|n|N|1|vendor /^960||w|0|0|o| |23|n|N|1|language /^960||x|0|0|o| |100|n|N|1|country /^960||y|0|0|o| |106|n|N|1|volume ##order record variable-length fields## #double-check varflds at site to make sure they match/exist /^020||a|0|0|o|b|0|n|N|1|PO info /^037||a|0|0|o|e|0|n|N|1|Ebook ID /^961||Ma|0|0|o|i|0|n|N|1|identity /^961||b|0|0|o|x|0|n|N|1|for curr /^961||Mc|0|0|o|n|0|n|N|1|note /^961||Md|0|0|o|z|0|n|N|1|int note /^961||Me|0|0|o|d|0|n|N|1|old order number /^961||Mf|0|0|o|s|0|n|N|1|selector /^961||Mg|0|0|o|q|0|n|N|1|ven addr /^961||Mh|0|0|o|v|0|n|N|1|ven note /^961||Mi|0|0|o|f|0|n|N|1|ven title /^961||Mj|0|0|o|a|0|n|N|1|paid note /^961||Mk|0|0|o|g|0|n|N|1|ship to /^961||Ml|0|0|o|r|0|n|N|1|requestor /^961||Mm|0|0|o|p|0|n|N|1|blanket po

Related Documentation

Top of page