| Import Rules Scope: 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: Jena Bakula Date last modified: 03/27/08 Date of next review: March 2009
| Project | Rule Name | Rule Code | Dup Profile | Loc Info | Load Type | Item Type | Mapping | Barcode | | ACLS Records | ACLSUpdate | ACLSUPD | NetLibConditional | 952 b * * | Bibs,MFHDs | * * 952 b | Table | * * 976 p | | Authorities Weekly Updates | AuthMerge | AUTHMERG | AuthMerge | None | Bibs/Auths Only | None | None | None | Aux Amateurs
(Approvals) | AUXappr | AUXAPPR | Import Conditional | 952 b * * | Bibs,MFHDs | * * 952 b | Table | None | | Batch OPAC Suppression | BIBSuppress
(See Note 3) | BIBSUP | BIBReplace | None | Bibs/Auths Only | None | None | None | | Batch BIB Update | BIBUpdate | BIBUPD | BIBReplace | None | Bibs/Auths Only | None | None | None | | Batch BIB Maintenance | BIBMaintenance
(See Note 7) | BIBMAINT | BIBReplace | None | Bibs/Auths Only | None | None | None | Cambeiro
(Approvals) | Cambeiro | CAMBEIRO | Import Conditional | 952 b * * | Bibs,MFHDs | * * 952 b | Table | None | | Casalini | Casalini | CASALINI | Import Conditional | 952 b * * | Bibs,MFHDs,POs | * * 952 b | Table | None | | Casalini Enhanced | CasaliniEnhanced | CASPLUS | Import Conditional | 952 b * * | Bibs,MFHDs,POs | * * 952 b | Table | None | Casalini
(Standing Orders) | CasaliniSO | CASSO | Import Conditional | 952 b * * | Bibs,MFHDs | * * 952 b | Table | None | CIS Microfiches
(Multipart items) | CISMicro1
(See Note 3) | CIS1 | Import Unconditional | None | Bibs/Auths Only | None | None | None | CIS Microfiches
(Single part items) | CISMicro2 | CIS2 | Import Unconditional | 952 b * * | Bibs,MFHDs | * * 952 b | Table | * * 976 p | | CJK (OCLC) | CJKIMPORT | CJKIMP | Overlay | None | Bibs/Auths Only | None | None | None | CJK Original Script
(complete set of RLIN
records) | CJKScript | CJKSCRIP | CJKScriptMerge | None | Bibs/Auths Only | None | None | None | | Early English Books Online | EEBO | EEBO | Import Unconditional | 952 b * * | Bibs,MFHDs | * * 952 b | Table | * * 976 p | | Eighteenth Century Collections Online | ECCO | ECCO | NetLibMerge | 952 b * * | Bibs,MFHDs | * * 952 b | Table | * * 976 p | | Firm Orders (CTS) | AandWFO
AmasFo
AndinosFO
AndrasFO
ArspolFO
AuxAmateursFO
BachFO
BarloventoFO
BenFO
BerenFO
BlackwellsFO
BooksMexFOBuscaFO
BokstudFO
BuscaFO
CambeiroFO
CasaliniFO
CouttsFO
CouttsUKFO
FrontFO
HarrasowitzFO
IberbookFO
IturriagaFO
JapubtraFO
JerusalemFO
KennysFO
NatarajFO
NedbookFO
NewzexFO
PanmanFO
RPSFO
TouzotFO
YankeeFO | AANDWFO
AMASFO
ANDINOFO
ANDRASFO
ARSPOLFO
AUXFO
BACHFO
BARLOVFO
BENFO
BERENFO
BLACKWFO
BOOKMXFO
BOKSFO
BUSCAFO
CAMBEFO
CASALINI
COUTTSFO
COUTUKFO
FRONTFO
HARRASFO
IBERFO
ITURFO
JAPUBFO
JERUFO
KENNYSFO
NATARJFO
NEDFO
NEWZEXFO
PANMANFO
RPSFO
TOUZOTFO
YANKEEFO | Import Conditional | 952 b * * | Bibs,MFHDs,POs | * * 952 b | Table | None | | Firm Orders (Mann) -SUSPENDED | AandWMFO
BachMFO
BenMFO
BksprMFO
BlackwellsM2FO
BlackwellsMFO
BooksmexMFO
CambeiroMFO
CasaliniMFO
CentroMFO
ChinapubMFO
ChopsonsMFO
CouttsMFO
CouttsniMFO
HarrasM2FO
HarrasMFO
JapubtraMFO
JointpubMFO
KubonMFO
LongwindMFO
NewzexMFO
PuvillMFO
RPSMFO
SelectMFO
ThoroldMFO
YankeeM3FO
YankeeMFO
YankeeMVFO | AANDWMFO
BACHMFO
BENMFO
BKSPRMFO
BLCKM2FO
BLCKMFO
BKSMXMFO
CAMBMFO
CASALMFO
CENTRMFO
CHINAMFO
CHOPSMFO
COUTTMFO
COUTNMFO
HARRM2FO
HARRMFO
JAPUBMFO
JOINTMFO
KUBONMFO
LONGWMFO
NEWZXMFO
PUVILMFO
RPSMFO
SELECMFO
THOROMFO
YANKM3FO
YANKMFO
YANKMVFO | Import Conditional | 952 b * * | Bibs,MFHDs,POs | * * 952 b | Table | None | Harrassowitz
(Approvals) | Harrassowitz | HARRASS | Import Conditional | 952 b * * | Bibs,MFHDs,POs | * * 952 b | Table | None | | Harrassowitz Full | HarrassowitzFull | HARRFULL | Import Conditional | 952 b * * | Bibs,MFHDs,POs | * * 952 b | Table | None | Harrassowitz
(Standing Orders) | HarrassowitzSO | HARRASSO | Import Conditional | 952 b * * | Bibs,MFHDs | * * 952 b | Table | None | | Hein Firm Orders | HeinFO | HEINFO | Import Conditional | 952 b * * | Bibs,MFHDs,POs | * * 952 b | Table | None | | Iberbook | Iberbook | IBERBOOK | Import Conditional | 952 b * * | Bibs,MFHDs,POs | * * 952 b | Table | None | | ISBN Testing | ISBNtest
| ISBNTEST | ISBN Testing | None | Bibs/Auths Only | None | None | None | | Iturriaga | Itturiaga | ITTUR2 | Import Conditional | 952 b * * | Bibs,MFHDs | * * 952 b | Table | None | | LC Resource File | LCResourceFile
(See Note 2) | LCFILE | LCReplace | None | Bibs/Auths Only | None | None | None | LC Resource File
(Vendor Records) | LCResourceFile
(See Note 2) | GENVEND | Acq Conditional | None | Bibs/Auths Only | None | None | None | | MARCadia | MARCadia | MARCADIA | MARCadiaMerge | None | Bibs/Auths Only | None | None | None | | Marcive (First Load) | Marcive | MARCIVE | MarciveMerge | None | Bibs/Auths Only | None | None | None | | Marcive (Second Load) | Marcive2 | MARCIVE2 | MarciveMerge2 | None | Bibs/Auths Only | None | None | None | | Microform Analytics (with 952) | MicroAnalytics
(See Note 4) | MICRO | Recon Conditional | 952 b * * | Bibs,MFHDs | * * 952 b | Table
(Note 6) | * * 976 p | | Microform Analytics (with 947) | MicroAnalytics2
(See Note 4) | MICRO2 | Recon Conditional | 947 l * * | Bibs,MFHDs | * * 947 l | Table
(Note 6) | * * 976 p | | MIT CogNet | MITCogNet | MITCN | MIT Conditional | 952 b * * | Bibs,MFHDs | * * 952 b | Table | * * 976 p | | MIT CogNet Suppression | MITCogNetS
(See Note 3) | MITCN2 | MIT Conditional | 952 b * * | Bibs,MFHDs | * * 952 b | Table | * * 976 p | | NetLibrary (Owned) | NetLibrary1 | NETLIB1 | NetLibMerge | 952 b * * | Bibs,MFHDs | * * 952 b | Table | * * 976 p | | NetLibrary (Unowned) | NetLibrary2
(See Note 5) | NETLIB2 | NetLibConditional | 952 b * * | Bibs,MFHDs | * * 952 b | Table | * * 976 p | | NetLibrary (Unconditional) | NetLibrary3 | NETLIB3 | Import Unconditional | 952 b * * | Bibs,MFHDs | * * 952 b | Table | * * 976 p | | NY State Docs (Bulk Import, with BatchCat) | NYStateDocs
(See Note 3) | NYDOCS | Recon Conditional | None | Bibs/Auths Only | None | None | None | | Oxford Reference Online | OxfordRefOnline | OXREF | NetLibMerge | 952 b * * | Bibs,MFHDs | * * 952 b | Table | * * 976 p | | ProQuest Updates | PQDUpdates | PQDUPD | PQDMERGE | None | Bibs/Auths Only | None | None | None | | Recon 1 (Bulk Import only) | Recon1 | RECON1 | Recon Conditional | 947 l * * | Bibs,MFHDs,Items | * * 947 l | Table | * * 947 y | | Recon 2 (Bulk Import, with BatchCat) | Recon2
(See Note 3) | RECON2 | Recon Conditional | None | Bibs/Auths Only | None | None | None | | Russian Press Service | RPS | RPS | Import Conditional | 952 b * * | Bibs,MFHDs,POs | * * 952 b | Table | None | | Serial Solutions Deletes | SerialSolutionsDelete
(See Note 3) | SERSOLD | NetLibMerge | None | Bibs/Auths Only | None | None | None | | Serial Solutions Updates (Cornell Sleeks) | SerSolUpdates | SERSOL | SerSolMerge | None | Bibs/Auths Only | None | None | None | | Serial Solutions Updates (Full MARC) | SerialSolutionsUpdates | SERSOLC | NetLibMerge | None | Bibs/Auths Only | None | None | None | | Yankee (Standard) | Yankee | YANKEE | Import Conditional | 952 b * * | Bibs,MFHDs | * * 952 b | Table | * * 976 p | | YankeeShelfReady | YankeeShelfReady | YANKSR | Import Conditional | 952 b * * | Bibs,MFHDs,Items | * * 952 b | Table | * * 976 p | 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)
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.
Mapping Tables and Order Profiles |
