Skip to main content
Support - EBSCO Help

Holdings Management - Supported Column Headings for Upload/Download

This page details the supported columns for downloading or uploading your holdings in Holdings Management in EBSCOadmin.

You can enter the column headers manually or download a Microsoft® (MS) Excel spreadsheet with all the column headers already entered. The column headers are not case-sensitive.

You can use MS Excel to modify the list, but save the file as a tab-delimited text (.txt) file before you upload it. Be sure to save as a Unicode text (.txt) file when using world languages that upload in Unicode.

Following is a complete list of column headers:

KBID
  • A unique number that EBSCO creates and assigns to a title.

Title**
  • Resource or title name. (This column accepts Unicode.)

AlternateTitle

Upload only. Used for Matching Resources, for example:

  • Sound of Music
  • Sound of Music 25th anniversary
  • Sound of Music:video recording

PackageName**
  • The name of the package or database this title is included in.
  • On Publication Finder, the Source displays as a link (pointing to the URL entered in the URL column) under the title name.
  • If you do not want the Source to be a link, do not enter any information in the URL column.
  • 200 character maximum.

URL
  • On Publication Finder, the hyperlinked source will link to the URL included in this column.
  • 700 character maximum.
  • For trial accounts, URLs for managed titles are omitted from the download list.

ProxiedURL
  • The resource link with any proxy settings applied.
  • For trial accounts, URLs for managed titles are omitted from the download list.
  • EBSCO automatically generates this column; it cannot change.

Publisher
  • Use this field in your upload to add or update a Custom Resource's Publisher. 700-character maximum.

Edition
  • Use this field in your upload to add or update a Custom Resource's Edition.

Author
  • Use this field in your upload to add or update a Custom Resource's Author(s).

Editor
  • Use this field in your upload to add or update a Custom Resource's Editor(s).

Illustrator
  • Use this field in your upload to add or update a Custom Resource's Illustrator(s)

PrintISSN
  • EBSCO automatically enters and updates this column for managed resources and these values can not be overridden.
  • For custom resources, any format can be used in an upload file as long as character limit is not exceeded.

OnlineISSN
  • EBSCO automatically enters and updates this column for managed resources and these values cannot be overridden.
  • For custom resources, any format can be used in an upload file as long as character limit is not exceeded.

PrintISBN
  • EBSCO automatically enters and updates this column for managed resources and these values cannot be overridden.
  • For custom resources, any format can be used in an upload file as long as character limit is not exceeded.

OnlineISBN
  • EBSCO automatically enters and updates this column for managed resources and these values cannot be overridden.
  • For custom resources, any format can be used in an upload file as long as character limit is not exceeded.

DOI

Download

  • Managed Resource - EBSCO automatically enters and updates this column.
  • Custom Resource - Can display in the format uploaded previously.

Upload

  • Managed Resource - Cannot override EBSCO entered value.
  • Custom Resource - Supports any format you enter in your upload file as long as character limit is not exceeded.

PeerReviewed
  • Not case sensitive
  • If an EBSCO Managed Resource the value is ignored
  • If a Custom Resource the value is supported
  • Acceptable values: Y, N, No value entered
  • "Y" = classifies a title as Peer Reviewed
  • "N" = classifies a title as not Peer Reviewed
  • No value entered = classifies a title as not Peer-Reviewed
  • If column is not present then the title is classified as not Peer-Reviewed

ManagedCoverageBegin
  • EBSCO automatically enters and updates this column.
  • Contains the earliest coverage date in our records.

ManagedCoverageEnd
  • EBSCO automatically enters and updates this column.
  • Contains all coverage data including gaps.
  • If the title has no end date, to present displays on Publication Finder.

CustomCoverageBegin
  • Information for the beginning of the resource's coverage based on your institution's subscriptions.
  • Enter custom coverage for titles with coverage different than the default coverage or for titles with coverage not managed by EBSCO. Click here to see supported date formats.
  • Can apply to managed or custom titles. (This column accepts Unicode.)
  • If utilizing the A-to-Z link feature within EBSCOadmin, any dates entered within the CustomCoverage fields will apply to the Local Collection that populates into EBSCOadmin.
    Note: If you are using Microsoft Excel to enter custom coverage by upload, please ensure that Excel does not automatically format the dates to a type that is unreadable by EBSCO. Otherwise, your custom coverage will not be added. Dates prior to 1900 need to be entered as: YYYY-MM-DD.

CustomCoverageEnd
  • A 100-character free-form field that the institution's administrator enters and maintains.
  • Information for the end of the resource's coverage based on your institution's subscriptions.
  • Enter custom coverage for titles with coverage different than the default coverage or for titles with coverage not managed by EBSCO. Click here to see supported date formats.
  • Can apply to managed or custom titles. (This column accepts Unicode.)
  • Leaving this field blank causes the end date to display as "to present" on Publication Finder.
  • If utilizing the A-to-Z link feature within EBSCOadmin, any dates entered within the CustomCoverage fields will apply to the Local Collection that populates into EBSCOadmin.
    Note: If you are using Microsoft Excel to enter custom coverage by upload, please ensure that Excel does not automatically format the dates to a type that is unreadable by EBSCO. Otherwise, your custom coverage will not be added. Dates prior to 1900 need to be entered as: YYYY-MM-DD.

CoverageStatement
  • Use this field in your upload to specify coverage for Managed and Custom resources in dates and text.
  • Overrides all selected resource coverage statement values

Embargo
  • EBSCO automatically enters and updates this column.

CustomEmbargo
  • Use this field in your upload when uploading custom titles to enter embargo information.

Description
  • Use this field in your upload to add or update a description for your custom resources.

Discipline

  • This field denotes any Discipline a title has been assigned. Disciplines are subject-like categories assigned to titles to enable precision searching for end users.

 ResourceType
  • This field can be used on uploads for the publication type for your Custom Resources
  • If you attempt to upload a Resource Type that is not supported, the value is ignored and the upload is continued.

PackageContentType
  • Use this field to specify the type of content in your package.
  • This field can be left empty or include one of the following acceptable values: Aggregated Full Text, Abstract and Index, E-book, E-Journal, Print, unknown, Online Resource.

CreateCustom
  • Y if custom, N if managed. A null field in this column registers in the system as N.
  • When uploading a custom title, EBSCO first checks for a managed resource match or a custom resource match before creating the custom title.
  • If you are adding custom coverage information to a managed title, type N in this column or leave blank.
  • Leave blank if uncertain and EBSCO will attempt to match to our title database.

HideOnPublicationFinder
  • Titles that have a Y in this column are hidden from view in Publication Finder.
  • This field can be used to hide both custom and managed titles.

Delete
  • Titles that have a Y in this column are deleted during the upload process.
  • This will remove only the specific instance of the title. Instances of the title with different Sources would be deleted using their own rows.
  • This field can be used to delete both custom and managed titles.
  • If left blank, N is assumed.
    Note: You can also "delete" managed titles by de-selecting them in the Title Wizard.

OrderedThroughEBSCO
  • The column will contain Y if the title was ordered through EBSCO and N if the title was not ordered through EBSCO. All Custom titles will have a value of N because only managed titles are ordered through EBSCO.

IsCustom**
  • Y if custom title, N if managed (ordered through EBSCO).

PackageType
  • EBSCO automatically enters and updates this column.

AllowEbscoToAddNewTitles
  • EBSCO automatically enters and updates this column.

**Required for custom titles. Y in the CreateCustom column indicates a custom title.