Data Cleanup Recommendations
Bibliographic, holdings, order and item data
Procedures in III | Procedures in Voyager | Notes | |
---|---|---|---|
|
| NOTE: 245 fields are required by Alma. Also check for empty 245 fields | |
| NOTE: These include links to ERM systems that will not transition to the Alma KB and to continuing resources such as locally stored documents or websites which will not be included in the Alma KB. Records with SFX 856 links but no SFX ID will also need to be addressed. | ||
|
Field Data Field Field data that is duplicated in the records, for example: b1000003 Indexed as Index and normalized index entry for the heading, for example: b1000003 From: Record number that contains the duplicate entry, for example: From: i110094222 The Physics of everyday phenomena : readings from Scientific American / with an introd. by Jearl Walker.
| NOTE: Headings Report duplicate checks according to the keys set in the Database Maintenance option New Bib Record: Duplicate check on fields | |
|
Field Data Field Field data that is duplicated in the records, for example: 110001376447 Indexed as Index and normalized index entry for the heading, for example: 110001376447 From: Record number that contains the duplicate entry, for example: From: i110094222 The Physics of everyday phenomena : readings from Scientific American / with an introd. by Jearl Walker.
| NOTE: This action applies only for those items that should circulate - Alma allows item records without barcodes to be migrated so having one is not a requirement. Items with duplicate barcodes that are imported into Alma will have the itemid appended to render them unique. NOTE: Headings Report duplicate checks according to the keys set in the Database Maintenance option Heading Report: Duplicate use Fields. Set “b” to enable search for duplicate barcodes | |
|
| ||
| NOTE: By default, Alma creates holding records during load from the Branch and Location values for each item, with the option of also using call no values to discriminate. Consolidation also provides a clearer display in Primo for these resources. | ||
|
| ||
| NOTE: This is necessary only if your library uses multiple OCLC symbols. This information is used to create the “HELD BY” information when publishing records for export to OCLC. | ||
|
| Possible fields of interest: 222, 240, 245, 246, 260 | |
| NOTE: Errors in these fields will affect sorting of results in Alma and Primo. | ||
|
| NOTE: These records should either have a barcode added in order to circulate or be deleted as "bad" records. May add additional lines to restrict search to item locations that are circulating to avoid adding journal or microform item records, for example. | |
|
| ||
| NOTE: In III systems, the 008 field is generated from various fixed-fields during export: See http://csdirect.iii.com/manual/gmil_lists_specify_criteria_spflds_bib.html for more details | ||
| |||
| |||
| |||
| |||
|
Statuses and Codes
| III Procedures | Voyager Procedures | Notes |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Old/Inconsistent Data
| III Procedures | Voyager Procedures | Notes |
Clean up and/or purge patron records that are inactive or expired and have no outstanding items, fines, fees, or other transactions. |
|
|
|
Clean up and/or purge patron records with fines, fees, or other transactions that are older than a certain date and/or less than a certain amount. |
|
|
|
Clean up and/or remove purchase orders that are old drafts or tests. |
|
|
|
Clean up and/or remove invoices that are old drafts or tests. |
|
|
|
Clean up standing orders and subscriptions that are old, should have been closed, or require investigation when active, but have been inactive for years. |
|
|
|
Clean up or standardize currency codes for vendors, funds, orders, or invoices that are not standard per the ISO standards for currency. |
|
|
|
Clean up or standardize country codes for patrons or vendors that are not standard per the ISO standards for countries. |
|
|
|
Locate and fix unnecessary field prestamps |
|
|
|
Locate and fix diacritic issues in record data |
|
|
|
Browse call number index to locate and fix bad/incorrect call numbers |
|
|
|
Browse barcode index to locate and fix bad barcodes |
|
|
|
Browse numeric indexes (OCLC, LCCN, ISN, etc.) to locate and fix incorrect values |
|
|
|
Locate and fix bad characters in volume fields |
|
|
|
Review MARC fields for incorrect subfield tags or indicator usage |
|
|
|
E-Resources and Package Resources
| III Procedures | Voyager Procedures | Notes |
Mark PDA BIB records clearly so that they can more easily be found in Alma and marked for PDA workflows in Alma and Primo post-migration. | |||
Use KB interface names for electronic interfaces to make use of the Community Zone in the best possible manner. |
| ||
Set up UStat – Customers who do not already use UStat for e-usage statistic reports can set it up prior to Alma and Primo implementation to benefit from its statistics and reporting capabilities from the beginning of Alma and Primo implementation. |
|
Patron, Vendor, library contacts
| III Procedures | Voyager Procedures | Notes |
Establish how name fields are stored (Last name, First Name, or First Name/Last Name) when names are entered in one field in the source ILS system. |
|
|
|
Locate and fix duplicate patron records |
|
|
|
Locate and fix patron records with missing data (email addresses, telephone number, address, etc.) |
|
|
|
Locate and address patron records missing barcode or name fields |
|
| NOTE: This may involve either adding the missing information or deleting these records. |
Locate and resolve existing “on-the-fly” records |
|
|
|
Authority records
| III Procedures | Voyager Procedures | Notes |
Identify local authority records, if relevant (keeping in mind the Alma CZ will have various national authorities automatically available globally). When relevant, these can be loaded post Go-Live using standard Alma loading tools. |
|
|
|
Find blind and duplicate authority records |
|
|
|
Find and fix invalid subject headings |
|
|
|
Locate and fix authority records missing 008 fields |
|
|
|
Locate and delete authority records lacking data |
|
|
|
Other
- Naming conventions
- Standardize how country information is entered such USA, U.S.A., United States, etc. for patron, vendor, and library contact information.
- Library and collection/location names
- Create/ensure unique collection/location names for each library that will be established in Alma and Primo