Versions Compared

Key

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

Scope: Deprecated, these profiles were for Voyager. Import Rules: This chart describes the "rules" associated with each of CUL's bulk import projects.

Note: Before running Bulk Import jobs, verify that MARC Character Set Mapping is set correctly for the records to be imported.

Contact: Jenn Colt  Gary Branch

Unit:  Batch Processing and Metadata Management

Date last updatedreviewed:09 08/2221/142019

Date of next review: July 2015  2020


ProjectRule NameRule CodeBib Dup ProfileLoc InfoLoad TypeItem Type

Mapping (See Note 8)

BarcodeLocations Used
ACLS RecordsACLSUpdateACLSUPDNetLibConditional

952 b

**

Bibs, MFHDs

* *

952 b

Table
Non-LC

* *  

976 p

serv,remo
Authorities Weekly UpdatesAuthMergeAUTHMERG AuthMerge None
Bibs/
Auths OnlyNoneNoneNoneN/A
Aux Amateurs
(Approvals)
AUXapprAUXAPPR Import Conditional

952 b

**

Bibs, MFHDs

* *

952 b

Table
Non-LCNoneOlin, Fine Arts, ILR,
Batch OPAC SuppressionBIBSuppress
(  See Note 3    
)
BIBSUP BIBReplace NoneBibs
/Auths
OnlyNoneNoneNoneN/A
Batch BIB UpdateBIBUpdateBIBUPD BIBReplace NoneBibs
/Auths
OnlyNoneNoneNoneN/A
Batch BIB Maintenance BIBMaintenance
(
  See Note 7   )
BIBMAINT BIBReplace None Bibs
/Auths
OnlyNone None None N/A
Batch BIB MaintenanceBBID Merge Only
(   See Note 7   )
001MERGBBID Merge OnlyNoneBibs OnlyNoneNoneNoneN/A
Batch BIB Maintenance035 Merge Only
(   See Note 7   )
035MERGMERGE ONLYNoneBibs OnlyNoneNoneNoneN/A
Cambeiro
(Approvals)
CambeiroCAMBEIRO Import Conditional

952 b

**

Bibs, MFHDs

* *

952 b

Table
Non-LCNoneOlin, Wason, Echols, Music, ILR, LTS Review, ILR (Annex), serv,remo
None
CasaliniCasaliniCASALINI Import Conditional

952 b

**

Bibs, MFHDs, POs

* *

952 b

Table
Non-LCNoneOlin
Casalini EnhancedCasaliniEnhancedCASPLUS Import Conditional

952 b

**

Bibs, MFHDs, POs

* *

952

9

52 b

Table
Non-LCNoneOlin, ILR, Fine Arts, Music, ILR (Annex)
Casalini
(Standing Orders)
CasaliniSOCASSO   Import
Conditional
Conditional

952 b

**

Bibs, MFHDs

* *

952 b

Table
Non-LCNoneOlin
CIS Microfiches (Project ceased)
(Multipart items)
CISMicro1
(See Note 3  
)
CIS1 Import Unconditional NoneBibs
/Auths
OnlyNoneNoneNoneN/A
CIS Microfiches (Project ceased)
(Single part items)
CISMicro2CIS2 Import Unconditional

952 b

**

Bibs, MFHDs

* *

952 b

Table
Non-LC

* *  

976 p

Law, Olin
CJK ApprovalsCJKapprCJKAPPR
Import Conditional
  Merge ONLY

952 b

**

Bibs, MFHDs, Items

* *

952 b

Table
LC (See Note 9)

* *  

976 p

(See Note 10)

Wason
CJK (OCLC)CJKIMPORTCJKIMP Overlay NoneBibs/Auths OnlyNoneNoneNoneN/A
CJK Original Script
(complete set of RLIN
records one time job)
CJKScriptCJKSCRIP CJKScriptMerge NoneBibs/Auths OnlyNoneNoneNoneN/A
Coutts Shelf-ReadyCoutts Shelf-ReadyCOUTTSR Import Conditional

852 b

**

Bibs, MFHDs, Items

**

852 b

Non-LC (See Note 9)

**

976 p

(See Note 2)

Mann, Olin, Math, Vet, Fine Arts, Music, ILR, Uris, JGSM, Hotel, Wason, Echols, South Asia, Asia (General), Ornithology
Create Bibs Suppressed ElectronicCreateBibsSuppressedElecCREASUPE Import Unconditional 952 bBibs, MFHDs

* *

952 b

Non-LCNoneserv,remo
Create Suppressed with ItemsCreate_Suppressed_ITCRESUPIT Import Unconditional 952 bBibs, MFHDs, Items

* *

952 b

Non-LC976 pOlin, Wason, Music Locked Press
CUL Digitization (Preliminary Records)CreateBibsSuppressedCREASUP Import Unconditional 952 bBibs, MFHDsNoneNon-LCNoneRMC, Olin
Early English Books OnlineEEBOEEBO Import Unconditional

952 b

**

Bibs, MFHDs

* *

952 b

Table
Non-LC

* *  

976 p

serv,remo; Wason
Eighteenth Century Collections OnlineECCOECCO NetLibMerge

952 b

**

Bibs, MFHDs

* *

952 b

Table
Non-LC

* *  

976 p

serv,remo
Electronic Import ConditionalElectronicImpCondELECCON Import Conditional

952 b

**

Bibs, MFHDs

* *

952 b

Table
Non-LCNoneserv,remo
Firm Orders (CTS)
akateem        

AmasFO
AmazonPatronDrivenBk

AmbasFO    


AndinosFO
ATCbooksFO
AuxAmateursFO
BachFO
BarloventoFO


BenFO


BerenFO

BlackwellsFO

BooksaroundFO
BooksMexFO

BooksMexFOBuscaFO

BokstudFO

BokstudFO   BouchalFO         BtsFO

BouchalFO
BTSFO
CambeiroFO
CasaliniFO

CasaliniFO     

CentroFO
CnpiecFO

CouttsFO 

CouttsFO CouttsPatronDrivenFO
CouttsUKFO

   DerexFO     ErasmusFO
FrontFO         GauntFO
HarrasowitzFO    IkdFO         InsLivreFO        


DerexFO
DKAFO
ErasmusFO
FrontFO
HarrasowitzFO
IkdFO
InsLivreFO
IsisFO
IturriagaFO
JapubtraFO
JerusalemFO

KennysFO         KinoFO           

KinoFO
Longleaf

MidwestFO
MippFO
NatarajFO

NewzexFO       

OlgaFO


PanmanFO   QingYinFO       RegulFO         RettaFO      SerbicaFO        SofiaFO       StatelibFO
TouzotFO   VanschkFO  WolinskiFO


PanmanFO
QingYinFO
RegulFO
RettaFO

SigvaldiFO
SerbicaFO
SofiaFO
StatelibFO
VanschkFO
WolinskiFO

WJBKSFO
YankeeFO

AKAT

AMASFO
AMAPDBFO

AMBASFO


ANDINOFO
ATCFO
AUXFO
BACHFO
BARLOVFO


BENFO


BERENFO

BLACKWFO

BKSAROFO
BOOKMXFO
BOKSFO
BOUCHFO
BTSFO
CAMBEFO
CASALINI
CENTROFO
CNPIECFO
COUTTSFO
COUPDBFO
COUTUKFO
DEREXFO
DKAFO
ERASMUS
FRONTFO

GAUNTFO


HARRASFO
IKDFO
INSLIVFO
ISISFO
ITURFO
JAPUBFO
JERUFO

KENNYSFO

KINOFO
LONGLEAF

MIDWESFO
MIPPFO
NATARJFO

NEWZEXFO

OLGAFO
PANMANFO
QINGFO
REGULFO
RETTAFO

SIGVALFO
SERBFO
SOFIAFO
STALIBFO

TOUZOTFO

VANSCHFO
WOLINFO

WJBOOKSFO
YANKEEFO

Import Conditional

952 b

**

Bibs, MFHDs, POs

* *

952 b

Table
Non-LCNoneOlin, Uris, Fine Arts, Music, Africana, JGSM, Hotel, Engineering, Echols, Phys Sci, Math, Vet, Mann, Entomology, Ornithology, RMC Iceland, Wason, South Asia, Olin Reference, Asia (General), Asia A/V
Harrassowitz
(Approvals)
HarrassowitzHARRASS Import Conditional

952 b

**

Bibs, MFHDs, POs

* *

952 b

Table
Non-LCNoneOlin, ILR, Fine Arts, Music, ILR (Annex)
Harrassowitz Full HarrassowitzFull HARRFULL Import Conditional

952 b

** 

Bibs, MFHDs, POs 

* *

952 b 

Non-LC
Table
 None Olin, ILR, Fine Arts, Music
Harrassowitz
(Standing Orders)
HarrassowitzSOHARRASSO Import Conditional

952 b

**

Bibs, MFHDs

* *

952 b

Table
Non-LCNoneFine Arts, ILR, Olin, Music
Hein Firm OrdersHeinFOHEINFO Import Conditional

952 b

**

Bibs, MFHDs, POs

* *

952 b

Table
Non-LCNone
IberbookIberbookIBERBOOKImport Conditional952 b * *Bibs,MFHDs,POs* * 952 bTableNoneISBN TestingISBNtest
ISBNTESTISBN TestingNoneBibs/Auths OnlyNoneNoneNone
Law, Law Reference, Law Technical Services, Law Reserve
IturriagaItturiagaITTUR2  Import Conditional

952 b

**

Bibs, MFHDs

* *

952 b

TableNoneLC Resource FileLCResourceFile
(See Note 2
)LCFILELCReplace
Non-LCNone
Bibs/Auths OnlyNoneNoneNone
Olin
Batchmatch
LC Resource File
(Vendor Records)
LCResourceFile
(See Note 2
)GENVENDAcq ConditionalNoneBibs/Auths OnlyNoneNoneNoneMARCadia
MARCadiaMARCADIA MARCadiaMerge NoneBibs
/Auths
OnlyNoneNoneNoneN/A
Marcive (
First Load
Updated records)MarciveMARCIVE MarciveMerge NoneBibs
/Auths
OnlyNoneNoneNoneN/A
Marcive (
Second Load
New)
Marcive2
MITCogNet
MARCIVE2
MITCN
MarciveMerge2
MIT Conditional NoneBibs/
Auths Only
MFHDs
NoneNoneNoneserv,remo
Merge001 Merge Only
001MERG BBID Merge Only
N/A Bibs Only N/A N/A  NoneN/A
 None
Merge035 Merge Only
035MERG Merge ONLY N/A
NA
Bibs OnlyN/A N/A  NoneN/A
Microform Analytics (with 952)MicroAnalytics
(
  See Note 4     )
MICRO Recon Conditional

952 b

**

Bibs, MFHDs

* *

952 b

Table
Non-LC
(See Note 6   )

* *  

976 p

Echols, Olin
Microform Analytics (with 947)MicroAnalytics2
( See Note 4    
)
MICRO2 Recon Conditional

947 l

**

Bibs, MFHDs

* *

947 l

Table
Non-LC
( See Note 6 )

* *  

976 p

Olin, Echols
MIT CogNetMITCogNetMITCN MIT Conditional

952 b

**

Bibs, MFHDs

* *

952 b

Table
Non-LC

* *  

976 p

Maps; serv,remo; Law
MIT CogNet SuppressionMITCogNetS
(
  See Note 3   )
MITCN2 MIT Conditional

952 b

**

Bibs, MFHDs

* *

952 b

Table
Non-LC

* *  

976 p

serv,remo
NetLibrary (Owned)NetLibrary1NETLIB1 NetLibMerge

952 b

**

Bibs, MFHDs

* *

952 b

Table
Non-LC

* *  

976 p

serv,remo
NetLibrary (Unowned)NetLibrary2
( See Note 5    
)
NETLIB2 NetLibConditional

952 b

**

Bibs, MFHDs

* *

952 b

Table
LC

* *  

976 p

serv,remo
NetLibrary (Unconditional)NetLibrary3 NETLIB3  Import Unconditional     

952 b

**

Bibs, MFHDs

* *

952 b

LC
TableNetLibMerge952 b
 

* *  

976 p

NY State Docs (Bulk Import, with BatchCat)NYStateDocs
(See Note 3
)NYDOCSRecon ConditionalNoneBibs/Auths OnlyNoneNoneNoneOxford Reference OnlineOxfordRefOnlineOXREF
serv,remo
Oxford Reference OnlineOxfordRefOnlineOXREF NetLibMerge

952 b

**

Bibs, MFHDs

* *

952 b

Non-LC

* *  

976 p

serv,remo
Proquest ebooksProquestUnconditionalPROQUN  Import Unconditional

952 b

**

Bibs, MFHDs, POs

**

952 bTable

952b

Non-LC

**

  

976 p

serv,remo
ProQuest UpdatesPQDUpdatesPQDUPD PQDMERGE NoneBibs/
Auths
MFHDs OnlyNoneNoneNoneN/A
Recon 1 (Bulk Import only)Recon1RECON1 Recon Conditional

947 l

**

Bibs, MFHDs, Items

* *

947 l

Table
  LC

* *  

947 y

Olin, Olin Room 301, Olin Room 305, Olin Room 401, Olin Room 404, Olin Room 405, Olin Room 601, Olin Room 604, Olin Room 605, Olin (Annex), Olin Storage, Olin Storage 2, Olin Reference, RMC, RMC Annex, RMC Reference, RMC History of Science, Maps
Recon 2 (Bulk Import, with BatchCat)Recon2
(See Note 3    
)
RECON2 Recon Conditional NoneBibs/Auths OnlyNoneNoneNoneN/A
Romanian Shelf ReadyRomanian_Shelf_ReadyROMANSR  Import Unconditional 952bBibs/MFHDs/Items


Olin, Uris, Fine Arts, Music, Africana, JGSM, Hotel, Engineering, Echols, Phys Sci, Math, Vet, Mann, Entomology, Ornithology, RMC Iceland, Wason, South Asia, Olin Reference, Asia (General), Asia A/V
Serial Solutions DeletesSerialSolutionsDelete
( See Note 3    
)
SERSOLD NetLibMergeNoneBibs
/Auths
OnlyNoneNoneNoneN/A
Serial Solutions (New)SerSolUnconditionalSERSOLUN   Import Unconditional  

952 b

**

Bibs, MFHDs

* *

952 b

TableNone
Non-LCNone
Serial Solutions Updates (Cornell Sleeks)SerSolUpdatesSERSOLSerSolMergeNoneBibs/Auths OnlyNoneNone
serv,remo; Echols (Annex)
Serial Solutions Updates (Full MARC)SerialSolutionsUpdates
SERSOLC
SERSOL NetLibMerge NoneBibs
/Auths
OnlyNoneNoneNoneN/A
Yankee
Coutts APPR (ceased)
YankeeYANKEE Import Conditional

952 b

**

Bibs, MFHDs

* *

952 b

Table
Non-LC

* *  

976 p

Olin

Anchor
Notes
Notes
Note 1: For all bulk import into the production database, owning library = cu
Note 2: Bulk import for the LC Resource File is done through the RD SysAdmin (owning library = resourcedb) If you click on the "Item Information" tab in Sys Admin, you can check the "Number all copies" radio button and enter "1" in the following field to automatically enter copy number "1" in records created.
Note 3: Check "Batch OPAC Suppress" box under "Rules" tab
Note 4: Choose "MARC Character Set Mapping" based on individual project
Note 5: NetLibrary1 and NetLibrary2 represent similar bulk import profiles, though their rules have sometimes varied.
Note 6: Choose default mapping location based on individual project
Note 7: Check "Leave OPAC Suppress Unchanged for Replaced and Merged Records" box under "Rules" tab.
Note 8: For codes in the "Mapping" column, "None" means that no holdings are created. For those marked "Non-LC," the location is taken from the 952$b and the textual call number is taken from the 952$h. For those marked "LC," the location is taken from the 952$b and the call number is taken from the 050$a and $b.
Note 9: Copies 852 $b, $k, $h, $i and $m to the MFHD.



Save

Save

Save

Save

Save

Save

Save

Save

SaveMapping Tables and Order Profiles