- Created by Lloyd Chittenden on Jan 06, 2022
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
Version 1 Current »
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
Bib and order records will be created.
Match on the BIB UTIL number.
Code:
/^999||t|0|10| | |0|n|G|0|#com="ov"@ov_tag="o"
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"
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, 972
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
none
Code:
@ov_protect="b=V0123456789d(69.)hk(970,971)m(995)n(583,972)v(856:d)v(.9.)y(948,958)"
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"
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=acq3;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="acq3" /^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"
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"
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
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
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 |
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 - 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 loaded 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 |
|
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|
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
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 |
|
|||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
Related Documentation
-
Page:OCLC Holdings Update Project (Marmot Knowledge Base)
-
Page:Exporting MARC files (Marmot Knowledge Base)
-
Page:(3) Load b & o records, match on 001 [acq3] (Marmot Knowledge Base)
-
Page:(K) Load b & o, match on i - 020 & 001 [acq2] (Marmot Knowledge Base)
-
Page:(X) Load file from Marquis macro 917 tag match [ing] (Marmot Knowledge Base)
-
Page:(S) Load vendor file [ven] (Marmot Knowledge Base)
-
Page:System Generated Review Files (Create Lists) (Marmot Knowledge Base)
-
Page:(L) Load an OCLC MARC file [b] (Marmot Knowledge Base)
-
Page:Dummy Records for On Order Bibs (Marmot Knowledge Base)
-
Page:Marmot Cataloging Standards (Marmot Knowledge Base)
-
Page:SkyRiver Install and Setup (Marmot Knowledge Base)
-
Page:Z39.50 Cataloging (Marmot Knowledge Base)
-
Page:Sierra Multi Window Mode Setting (Cataloging) (Marmot Knowledge Base)
-
Page:Record View Properties (Sierra Setup) (Marmot Knowledge Base)
-
Page:Z39.50 Cataloging - Video (Marmot Knowledge Base)
- No labels