Use this option to refresh bibliographic records currently in your catalogue with fresh MARC21 data from a chosen source. The import file will most likely be created locally by exporting a CSV file from your your catalogue.
There are a number of different configuration options you must choose when importing CSV files. The configuration options you choose determine the file requirements that must be met, including mandatory and optional data required for each record. Once you have chosen your import settings you should clickto check file specifications required for your chosen settings.
Create CSV Import File
Go to: Reports > Catalogue > Bibliographic Records
- Generate a list of bibliographic records to refresh.
- - export records to CSV. Note: You will have to schedule an overnight task if more than 1,000 records are being exported.
- Using Excel, edit the exported CSV file to remove all data columns except ISBN.
- Save this candidate file to use as the import file.
Import CSV Candidate File
Go to: Cataloguing > Imports > CSV
- Choose Import Format:
- Comma Separated (CSV) - choose this for files in CSV format. Note: CSV is recommended.
- Tab Separated (TSV) - choose this for files in Tab Separated format.
- - locate the candidate import file.
- Set CSV Content:
- Catalogue Only - your file only contains bibliographic data for books.below.
- Holdings Grouped By is not available.
- Existing ISBN/ISSN Treatment:
- Overwrite Existing Catalogue Record - if an ISBN/ISSN match is detected, overwrite the existing record with either data from the data source, i.e., the import file or the MARC21 data source (refer to Auto-Populate by ISBN below). Note: The title and media_type columns headers must be present in the CSV but the values for each isbn can empty, and any locally added metadata, e.g., local subject headings or genre, will be purged and replaced with data from the data source.
- Add Copy For New Records:
- No - do not create a holdings record.
- Auto-Populate by ISBN:
- If the message There are no z39.50 servers configured for cataloguing which support the ISBN use attribute is displayed and you want to auto-populate imported bibliographic records you must ensure the Z39.50 serve you intend to use is configured to check ISBN and ISSN in Configure > Integration > Z39.50 > edit Z39.50 server.
- - auto-populate the records in the catalogue with MARC21 data from the selected Z39.50 server. Note: The ISBN in the import file will be used to populate the bibliographic record.
- Z39.50 - use this data source for MARC21 updates. Note: This option is only available if Auto-Populate by ISBN is switched.
- Read Current Import Behaviour panel carefully to ensure the imported records will be allocated as you expect. Note: This is a generic message applying to all CSV imports that uses library language for all media type and dynamically draws its content from the current values on this page and the configuration settings in Configure > Settings > General.
- Batch and Rating Limit - these values should be left as default unless timing issues cause the Z39.50 import to fail.
- - proceed with the import. Note: This process imports the file and saves the new records immediately and cannot be easily reversed.
- - test the file to check for major errors. Note: This process simulates all aspects of the import without saving any data and potentially polluting your catalogue, allowing you to test the outcome of a normal import and offers the opportunity to correct reported data failures.
A summary report will display the results of the processing.