Data extraction size and naming convention
The following is the default naming convention:
For example: centralu_bib_01_20120420.mrc, centralu_bib_02_20120420.mrc, centralu_bib_03_20120420.mrc, etc.
Ex Libris recommends a maximum of 200,000 records per MARC file, and 400,000 for other types of records (items, orders, etc).
All records in a single file must be homogenous – all of the lines in the file must have the same number of fields, and those fields must contain the same type of data. Additionally, all of the records must be delimited in the same manner, which is quotes and commas.
Locally defined fields in bib records and their purposes:
Sierra Bibliographic Data export:
Suppressed Bib records
Sierra Paid Order Data export
Sierra Open Order Data export
Sierra Paid Order Not Cataloged Data export
d – dup at annex (batch add a NOTES field to item) (ICODE2=d – dup at annex )
k – keep on campus (batch add a NOTE field to Item) (ICODE2=k - keep on campus )
n– transfer to Annex (batch add a NOTES field to item) (ICODE2=n - suppress)
q – transfer to Annex (batch add a NOTES field to item) (ICODE2=q - transfer to annex)
v – transfer to Annex (batch add a NOTES field to item) (ICODE2=v – Hay Vault)
975 NOT migrate.
Decision Process Documentation (Jan. 2021)
1. To extract Serials Solutions data on July 13 (Tuesday)
2. Clean the content based on test load cleanup list: https://docs.google.com/spreadsheets/d/1iTIljwTW-F3CboH3FYvsFsQ17OkrQS_TDdL1TD3mvs8/edit?usp=sharing
3. Finish and submit final data to Cathy by July 20 (Tuesday)
Brown University Library | Providence, RI 02912 | (401) 863-2165 | Contact | Comments | Library Feedback | Site Map