Skip to main content
OCLC Support

Map titles from an alternate knowledge base supplier

Upload holdings from an alternate knowledge base supplier (Alma, EBSCO Full Text Finder, Serials Solutions, or SFX) to create collections in your knowledge base.

If you want to import all of your holdings from an Alternate knowledge base supplier, use the instructions on this page. Institutions may use services from multiple providers to provide access to their content and may want to maintain two knowledge bases, one through OCLC's knowledge base (Collection Manager) and one through another service provider. Collection Manager enables libraries to map their titles from other services like EBSCO, Serial Solutions, or SFX with their OCLC knowledge base. To map titles from an Alternate knowledge base supplier holdings file, the institution will need to export their knowledge base data from the other service and then import it using Collection Manager or via FTP.

 Note: If instead, you want to:

For more information, see Upload and download locations in Collection Manager.

Understand file processing options

Mapping Alternate knowledge base supplier files is one option for building your WorldCat knowledge base. Depending on your institution's collections, it might or might not save you time over adding the collections and the titles contained therein without using an Alternate knowledge base supplier file.

Overview:

The first step is to export a holdings file from your Alternate knowledge base supplier service. Before you export your data from an Alternate knowledge base supplier service, note the format requirements for uploading your file in WorldShare Collection Manager. The requirements might influence the options you choose in your Alternate knowledge base supplier administrative interface when you export your data.

The second step is to upload your file to your WorldCat knowledge base (Collection Manager).

Once you upload a file, contact OCLC Support to alert us. After the file is processed, a report will be available in Collection Manager, in the Activity History. The Alternate Knowledge Base Supplier Holdings report details which collections and titles within the collection from your Alternate knowledge base supplier were matched to your WorldCat knowledge base and other details.

You have the option to refresh your mapping as needed. We recommend that you allow two weeks from the time the file is submitted to allow for processing maintenance of your holdings in WorldCat. There is rarely a one-to-one parallel between providers. Therefore, mapping is an iterative and imperfect process. OCLC will map, review the results, identify new indexes to improve the results, and then map again.

Examine and choose a processing option

Examine the two options below and choose the option best suited for your institution:

Option 1: Default processing

Titles that have changed will be added and updated via the default process to map Alternate knowledge base supplier files. However, titles selected in your WorldCat knowledge base collections that are not present in the file will not be removed or deselected.

 Note: The process will not change titles in collections that are selected in full.

To use this process, simply continue the path outlined on this page.

Option 2: Replace processing

Libraries that choose replace processing typically plan to upload a file on a regular basis in order to keep their knowledge base data up-to-date and in parallel with their provider's data. Each time a holdings file is submitted, the system will add, update, and remove titles or data that has changed. Titles will be removed if they are no longer in your holdings.

 Note: If a title exists within a collection you have selected in full, the title will not be removed even if they are no longer in your holdings.

This option is only available for members who want to map holdings from one alternate service provider (Alma, EBSCO Full Text Finder, Serials Solutions, SFX, etc.). Replace processing cannot be configured if you want to map from two providers.

To initiate the process, send a request to OCLC Support. When you update the file in the future, you can do so without contacting us first.

Contact OCLC Support or visit Collection Manager office hours if you have questions.

Follow the instructions to export your holdings

Use one of the following sets of instructions to export your holdings from your Alternate knowledge base supplier. Make sure to download the file in the format specified in the instructions so you are able to upload your file.

Alma

To publish electronic holdings to OCLC:

  1. Create the set of electronic holdings that you want to synchronize with WorldCat. See Adding Logical Sets for instructions.
  2. Create a general publishing profile. See Publishing and Inventory Enrichment, and use the details provided in the following table to customize your profile configuration.

After you have downloaded and prepared a file from your existing knowledge base, you have two options to map the file:

  • Upload your holdings file via the WorldShare interface
  • Upload your holdings file via the FTP

Alma Profile Details for OCLC Electronic Holdings

  Parameter Description
  Profile name A unique profile name.
Profile description Use the description to further identify the publishing profile for OCLC electronic holdings.
Publishing Parameters Status Select Active.
Scheduling Select the schedule.
Email Notification Specify which users and email addresses will receive email notifications when the publishing profile has been completed.
Content Set name Select the set that you created for electronic publishing in Step 1.
Publish on Select Bibliographic level.
Output format Select MARC 21 Bibliographic
Publishing Protocol FTP, OAI, or Z39.50 Select the SFTP check box.
FTP configuration
  • SFTP Server=see OCLC SFTP data centers section on page 4
  • UserName=the one assigned to you by OCLC
  • Password=the one assigned to you by OCLC
  • Sub-directory=/xfer/wckb/in/data
Include all titles each time file is published Select the Include all titles each time file is published check box.
Disable file compression Select the Disable file compression check box.
Physical format Select XML.
Number of records in file Select One File.
Use default file name Select No.
File name Specify Alma_HOLDINGS_<registry_id>.xml where <registry_id> is your WorldCat Registry ID (also known as your OCLC Institution ID) for your library. If you have questions regarding your WorldCat Registry ID, contact OCLC Support.

Data Enrichment for OCLC Electronic Holdings

 Note: 

This is required.

Parameter Description
Add Electronic Portfolio Information Select this.
Repeatable field  866
Access URL subfield u
Link Resolver Base URL

Enter your link resolver base URL. 

Enter the base URL for the Primo service page redirect to the Alma Link Resolver using the following format and inserting your institution’s information where indicated:

http://<primo server host:port>/openurl/<primo institution_code>/<primo view_code>?

Collection Name subfield x
Coverage Statement subfield a
CZ Collection Identifier subfield  t
OCLC Electronic Publishing Profile- Data Enrichment Select Save.

EBSCO Full Text Finder

EBSCO Full Text Finder was previously known as EBSCO A-to-Z.

OCLC is able to map your library’s EBSCO Full Text Finder ebook holdings to titles and collections in the WorldCat knowledge base (access is via WorldShare Collection Manager). After you export a file from your Alternate knowledge base supplier, OCLC will iteratively match the file of your holdings to corresponding collections and titles that exist in the knowledge base. 

After you have downloaded and prepared a file from your existing knowledge base, you have two options to map the file:

  • Upload your holdings file via the WorldShare interface
  • Upload your holdings file via the FTP

Please contact OCLC Support if you need assistance.

See the Alternate Knowledge Base Supplier Holdings report when mapping completes to view details of how the collections and titles were mapped from the holdings file to your OCLC knowledge base.

Export holdings from EBSCO Full Text Finder list

Export your EBSCO Full Text Finder list holdings is done via the EBSCO site. To export:

  1. Access your holdings in EBSCO Full Text Finder Admin.
  2. Download your holdings and save as a Tab-delimited file. For instructions, see EBSCO’s Help for Downloading Your Holdings
  3. Use the following file name convention for your holdings data file prior to uploading:
    ebsco_HOLDINGS_[registry-id].txt

Serials Solutions

OCLC is able to map your library’s Serials Solutions holdings file to collections and titles in the WorldCat knowledge base (access is via WorldShare Collection Manager). After you export a file from your Alternate knowledge base supplier, OCLC will iteratively match the file of your holdings to corresponding collections and titles that exist in the knowledge base.

After you have downloaded and prepared a file from your existing knowledge base, you have two options to map the file:

  • Upload your holdings file via the WorldShare interface
  • Upload your holdings file via the FTP

See the Alternate Knowledge Base Supplier Holdings report when mapping completes to view details of how the collections and titles were mapped from the holdings file to your OCLC knowledge base.

Export a holdings file from Serials Solutions

To export your Serials Solutions holdings file you will need to access the Serials Solutions site. To export:

  • Access your library’s Serials Solutions Client Center.
  • From the Client Center, access the Data on Demand service.

Serials Solutions Client Center

  • From the Data on Demand menu, choose "Generate New Report"

Generate new report

  • On the Generate New Data on Demand Report screen, specify the following export settings:
    • UTF-8
    • CSV without Subjects
    • All Content
    • Do not select "Split File." Please make sure it is unchecked.

Serials Solutions Options

  • Click Save.
  • The report file will generate and be available to download shortly thereafter. The download process could take several minutes to complete, depending on the number of titles in your collection.

Use Excel to convert your CSV to a TXT file

Use Excel to convert your Comma Separated file (CSV) to a Tab Delimited file (txt). After downloading the CSV file from the SerSol platform:

  1. Open Microsoft Excel.
  2. Click on Data.
  3. Click on From Text (within the Get External Data area of the ribbon). An Import Text File box should appear.
  4. Navigate to your SerSol CSV file, select it, and click the button to import the file.
  5. A Text Import Wizard should open:
    1. Import Wizard Step 1: Choose the file type. If items in the text file are separated by tabs, colons, semicolons, spaces, or other characters, select Delimited. Click Next.
    2. Import Wizard Step 2: The Tab and Comma should be checked as the delimiter. Select the Quotation marks as text qualifier.
    3. Import Wizard Step 3: Use preview to see if the data import is correctly formatted. Click Finish button.
  6. Import into a new sheet, Save As Tab Delimited .txt with the file name SerSol_HOLDINGS_[registry-id].txt.

See the Microsoft Office documentation on the Text Import Wizard for help.

(Optional) Check if your file is correctly formatted

Open it with a text editor (Notepad on Windows or Text Edit on Mac). Make sure that quotations and commas no longer exist to separate and qualify the text. Only tabs should be separating the text.

  1. Open your .txt file in a text editor. For example, the Notepad application. (Notepad is available on a Windows machine, in the Accessories folder. Do NOT use a spreadsheet application like Microsoft Excel.)
  2. Complete the steps to Find and Replace. Your goal is to find all quotation marks/smart quotes/straight quotes/curly quotes (") and remove them, replace with nothing.

    For example, depending on your operating system and application, use Ctrl+ H or select Edit, Replace.
    Find and Replace
  3. Remember to use the following name convention for your holdings data file prior to uploading. Replace [registry-id] with your institution's registry ID:
    SerSol_HOLDINGS_[registry-id].txt
    SerSol_HOLDINGS_12345.txt

SFX

OCLC is able to map your library’s SFX file to collections and titles in the WorldCat knowledge base (access is via WorldShare Collection Manager). After you export a file from your Alternate knowledge base supplier, OCLC will iteratively match the file of your holdings to corresponding collections and titles that exist in the knowledge base.

After you have downloaded and prepared a file from your existing knowledge base, you have two options to map the file:

  • Upload your holdings file via the WorldShare interface
  • Upload your holdings file via the FTP

Since mapping can be a complex process, we recommend that users considering mapping an alternate knowledge base supplier holding file file to the WorldCat knowledge base contact OCLC Support to discuss mapping options before beginning the process.

See the Alternate Knowledge Base Supplier Holdings report when mapping completes to view details of how the collections and titles were mapped from the holdings file to your OCLC knowledge base.

Export a holdings file from SFX

To get started, export a holdings file from your SFX service.

  1. Log in to the SFX platform.
  2. Go to KBTools – Export Tool. Go to Advanced Export Profiles.
  3. Create an Export Profile.
  4. You must download your file in the correct format in order to upload your file. Output as an .xml file formatted as a single file that describes all of your available targets (for upload via FTP).
  5. Choose the desired collections for output.
  6. Save your profile and run the file.

Upload your file

After you have exported a file from your provider in the recommended file format, follow the instructions to upload your file (via the WorldShare interface or via FTP/SFTP):

Prepare your file for upload

File name

Use the following file name for your holdings file. Include the word HOLDINGS in all capital letters and then type an underscore, your institution's registry ID number, a dot, and the file extension:

[Supplier]_HOLDINGS_[registry_id].[extension]

Registry ID

Using the file name above, replace [registry-id] with your library's Registry ID or OCLC Institution ID.

To locate the Registry ID for your library,

File extension

Using the file name above, replace [extension] with the appropriate extension for your Alternate knowledge base supplier and upload method.

Serials Solutions and EBSCO files need to be in .txt format for upload via the WorldShare interface and via FTP:

[Supplier]_HOLDINGS_[registry_id].txt

SFX and Alma files for upload via FTP must be in the .xml format:

[Supplier]_HOLDINGS_[registry_id].xml

  Note that you should not attempt to change the file format/extension. Rather, it is important that the files were formatted correctly at the time of download from your Alternate knowledge base supplier.

Use the relevant option to upload your file

Use one of the options below. 

Important note: After you upload your file, you need to contact OCLC Support to alert us that a file is available for our review. Please include your institution name and Registry ID or file name.

Upload your file via file transfer protocol (FTP or SFTP) to OCLC's server

Gather your credentials

To upload your file via FTP, use your assigned FTP account to transfer your holdings file to OCLC. If your library does not have FTP credentials or cannot find them, please contact OCLC Support for assistance.

All libraries in regions outside of the United States must use Secure File Transfer Protocol (Secure FTP or SFTP) on port 22. Libraries in the U.S. can use SFTP on port 22 or use FTP on port 21. The data center associated with a library's account depends on the region in which they are located. Use the hostname for your region as shown in the table below:

all data centers regional hostnames port
United States Data Center filex-m1.oclc.org 22
European Data Center filex-r1.oclc.org 22
Australian Data Center filex-r2.oclc.org 22
Canadian Data Center filex-r3.oclc.org 22

Upload your file

To access the server, you may use an FTP client of your choice or command line.

FTP client

If you use an FTP client, adapt the information below as needed. See Exchange files with OCLC for an example of an FTP client. 

For WorldCat knowledge base collections, upload to the /xfer/wckb/in/data file exchange directory location.

Command line

  1. Using your institution's assigned username, enter the following command: sftp [username]@[data center]
  2. Enter your institution's assigned password
  3. Enter /xfer/cd/wckb/in/data to navigate to the directory folder
  4. To upload the files, enter the following sequence of commands:
  5. binary
  6. put [Supplier]_HOLDINGS_[registry_id].[extension]
  7. quit

For more information, see Exchange files with OCLC.

Contact OCLC to let us know you uploaded a file

Contact OCLC Support to let us know you have uploaded a file so we can work with the file for the best results.

In your message, please include:

  • Your institution name and
  • Your registry ID, or
  • Your file name

View Activity History reports

See Collection Manager Activity History for instructions on how to access your institution's activity history

Find details about Provider Holdings Feeds

After an upload of a holdings file from an alternative or third-party knowledge base, details about file processing will be available in approximately 1-2 days. 

  1. Navigate to Collection Manager Search.
  2. Choose Activity History as the Search Scope.
  3. Leave the search box blank. Leave My Institution's History selected.
  4. Click Search.
  5. At the top of the screen, select the Loads & Feeds filter. From the drop-down menu that appears, choose Alternative Knowledge Base Supplier Holdings File.
  6. Click Filter.
  7. In the search results, click the load or feed of interest to see details about the specific Alternative Knowledge Base Supplier Holdings File.
  8. Click on Title Changes.
    • To download a report, click on the Download Detailed Report button.

After an upload of a holdings file from an alternative or third-party knowledge base, details about file processing will be available in approximately 1-2 days.

Feed History page and reports

Once you open the activity, you will see a screen that shows the collections that were included in the file. Use the Download Reports drop-down to find reports. Three reports are available for download when relevant:

  • Collections Unmapped Report
  • Summary Report
  • Titles Unmapped Report

The reports contain information about the collections and titles that were included in the file upload and summarize the total number of mapped titles.

AH-akbshf.jpg

Title Changes page(s) and detailed reports

From the list of collections, clicking on Title Changes for each of the collections will bring you to a page that shows how titles were changed in that collection.

From each collection's Title Changes page, you can Download a detailed report.

The following columns in the Summary Report contain data about your library’s holdings file.

Column heading Definition
Collection name from source file The name of the collection as listed in the Alternate Knowledge Base Supplier Holdings File.
OCLC collection id mapped The Collection ID for the matched collection in the WorldCat knowledge base. If the OCLCId column is empty and the Size(Loaded) column is 0, no matching collection was found.
KB Supplier collection id A unique identifier for the collection in the Alternate Knowledge Base Supplier Holdings File.
No. of titles in source file The number of titles in the collection as listed in the Alternate Knowledge Base Supplier Holdings File.
No. of titles mapped   The number of titles selected for the matched collection in the WorldCat knowledge base. If the OCLCId column is empty and the Size(Loaded) column is “-“, no matching titles were found.
Has collection been mapped more than once? If set to true, the OCLC KB collection was mapped to several collections from the source file and exists in multiple lines within the Summary report.
Transaction

The action indicating how the collection was mapped. The possibilities are:

  • Select: indicates that we selected a subset of titles within the corresponding collection.
  • Covoverlay: indicates that we selected a subset of titles within the corresponding collection and made some customizations to coverage dates.

The following columns in the Collections Unmapped Report contain data about your library’s holdings file.

Column heading Definition
Registry id from file name Institution's Registry ID of the Alternate Knowledge Base Supplier Holdings File upload.
KB Supplier type KB supplier name for the Alternate Knowledge Base Supplier Holdings File.
Incoming FileName The name of the file of the Alternate Knowledge Base Supplier Holdings File upload.
Collection name from source file The name of the collection as listed in the Alternate Knowledge Base Supplier Holdings File.
Duplicate Collection in source file? If set to true, entries of the collection were duplicated within the Alternate Knowledge Base Supplier Holdings File.
No. of titles in source file The number of titles in the collection as listed in the Alternate Knowledge Base Supplier Holdings File.
No. of titles in source file which were not mapped The number of titles not mapped from the Alternate Knowledge Base Supplier Holdings File upload.

The Titles Unmapped Report contains all titles from collections unmapped in KBART format. For more information about these fields, please see KBART values.