Use this import option when you have or can create a CSV or TSV file containing both the bibliographic or catalogue records for digital media stored on remote web servers. This includes eBook, eAudiobooks, videos, podcasts, PDF documents, and similar resources. The import file may have come from your supplier for new titles recently purchased, or the import file may have been created locally using your own resources.
There are a number of different configuration options you must choose when importing your CSV files. The 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 settings you should clickto check file specifications required for your settings.
Import Records - Bibliographic/Descriptive And Links Data
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.
Note: The minimum CSV/TSV columns for importing links using an ISBN are: isbn, url, site, section. The minimum CSV/TSV columns for importing links using a Catalogue ID: catalogue id, url, site, section, title, media type.
- Clickto locate the import file.
- Set CSV Content:
- Catalogue and Holdings - your file contains both bibliographic/descriptive data and holdings/copies data.
- Choose Holdings Grouped By:
- ISBN/ISSN - choose this option when each bibliographic record in the import file has a unique ISBN which the import process will use to align each holding/copy link record with its bibliographic record. Tip: If some records in the file do not have ISBN separate these records from the main file into a second file and process that second file using option 2 or 3 below.
- Title/Author/Media Type - choose this option when the bibliographic records in the import file do not have an ISBN and you want the import process to use title+author+media type as the unique key to align each holding/copy link record with its bibliographic record.
- Catalogue ID - choose this option when the bibliographic records in the import file do not have an ISBN and you want the import process to use a unique number or code you have created for each record in the file to align each holding/copy link record with its bibliographic record.
- Choose Existing ISBN/ISSN Treatment:
- Create New Catalogue Record - if an ISBN match is detected, ignore the match and create a new record. This may result in duplicate bibliographic records. Note: Use this option if you are trying to import separate records which have identical ISBNs in a Series, e.g., 9781784936457 - Science in action series - all these titles have the same ISBN.
- Overwrite Existing Catalogue Record - if an ISBN match is detected, overwrite the existing record with data in the import file.
- Skip Existing Catalogue Record - if an ISBN match is detected, leave the existing record unchanged and skip over the file record.
- Choose processing for Existing Barcode Treatment:
Note: Digital record links do not need nor have barcodes but you must inform the import process how to process the file.
- Create New Resource Without Barcode - choosing this option means the holding/copy link data in the import file will be imported and barcode will be ignored.
- Choose processing for Unrecognised Site or Section to one of the following:
- Skip Record - if either the site or the section for a holdings record in the import file is not defined for your catalogue, then the record will not be imported. Note: The site and section must be declared in the CSV import file and must match defined Sites and Sections at Config > Library > Site/Section prior to importing the file.
- Set Auto-Populate by ISBN:
Note: This setting only applies to eBook and eAudiobook imports.
- 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 Config > Integration > Z39.50 > edit Z39.50 server.
- - do not auto-populate the records. Note: The data in the import file will be used to populate the bibliographic record.
- - do auto-populate the records with MARC21 data from the selected Z39.50 server. Note: The ISBN in the import file will be used to populate the bibliographic record.
- 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 Config > 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.