Use this option to import a CSV or TSV file containing only the bibliographic or catalogue records for the titles you wish to import. The import file may have come from your supplier for new titles recently purchased, or the import file may have been created locally by exporting data from your legacy library management system. 


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.


Import Records From A Publisher - Bibliographic Data Only


Go to: Cataloguing > Imports > CSV

  1. Choose Import Format:
    1. Comma Separated (CSV) - choose this for files in CSV format. Note: CSV is recommended.
    2. Tab Separated (TSV) - choose this for files in Tab Separated format.
  2. Clickto locate the import file.
  3. Set CSV Content:
    1. Catalogue Only - your file only contains bibliographic data for titles.
  4. Holdings Grouped By is not available.
  5. Existing ISBN/ISSN Treatment:
    1. Skip Existing Catalogue Record (default option) - if an ISBN/ISSN match is detected, leave the existing record unchanged.
    2. Create New Catalogue Record - if an ISBN/ISSN 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.
    3. 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: Any locally added metadata will be destroyed and replaced with data from the data source.
  6. Add Copy For New Records:
    1. No - do not create a holdings record.
    2. Yes - create a holdings record. Note: Use for an import file containing bibliographic records for either physical or digital resources when you want a holdings record created simultaneously, or for an import file containing a mix of bibliographic records for physical or digital resources.
    3. Digital Records Only - create a holdings record only if the bibliographic record is for a digital resource with a URL usually stored in the 856 MARC tag.
  7. Auto-Populate by ISBN:
    1. 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 server you intend to use is configured to check ISBN and ISSN in Configure > Integration > Z39.50 > edit Z39.50 server.
    2. - do not auto-populate the records with data from a MARC21 data source. Note: The data in the CSV import file will be used to populate the bibliographic record.
    3. - 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.
  8. Z39.50 - use this data source for MARC21 updates. Note: This option is only available if Auto-Populate by ISBN is switched.
  9. 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.
  10. Batch and Rating Limit - these values should be left as default unless timing issues cause the Z39.50 import to fail.
  11. Choose:
    1. - proceed with the import. Note: This process imports the file and saves the new records immediately and may be difficult to reverse.
    2. - 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.