Content

How to prepare a title list file for upload

Input File Specifications:

The input file must be a .csv file using commas as delimiters and saved with UTF-8 encoding.

The file has to be structured as follows:

  • Rows: Each row must represent an individual title.
  • Columns: Use columns for title identifiers (e.g., ISBN, ISSN, etc.).
  • Headers: The first row must contain the column headers described below.

Column headers:

  • The Title/Database column is not used for tagging, but it helps when reviewing tagging outcome.
  • The input file can include additional columns, CELUS will only work with those that it recognizes.
  • The columns containing title identifiers must use one of the Supported identifiers listed below (letter case does not matter). Columns with other headers (e.g., “Print_ISSN”, “Online_ISSN” or “ISSN-L”) are ignored.
  • Each cell may contain only one identifier. If a title has more identifiers, use separate columns (e.g., both ISSN and eISSN).
  • If you are tagging all titles with the same tag, select the tag in the upload dialog.
  • To apply different tags to individual titles, include the specific tag names in a column named Tag in your input file.
  • If you need to assign more than one tag to a single title, you must format your file using a separate row for each tag (unpivot columns if containing multiple tags). Also, ensure that the "Exclusive" checkbox is unselected in your Tag Class Management settings.

Note: When you upload a title list for tagging, titles are matched by identifiers alone: ISSN, eISSN, ISBN, DOI, proprietary ID or the CELUS title ID. The title name is ignored. An ISSN or eISSN in the list matches any title whose ISSN, eISSN or ISSN-L has that value. Each identifier is looked up separately, so one row in the list can match more than one title.

Examples of input files:

- without tags

- with tags

‍

Related Articles

Featured Articles