Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    360 Core: Library-Specific Holdings: Updating Your Library-Specific Holdings Database

    • Product: 360 Core Client Center

    How can I update my library-specific-holdings database in the Client Center?

    The following steps are used to change current holdings in, or add multiple holdings to, a library-specific database (also called library-managed holdings).

    1. Select either the Number of Titles link for your library-specific holdings database on the Data Management home page or the Titles link in the left-side navigation tree for the selected database on the Database Details page:


      Data Management Home Page


      Database Details Page
    2. If you want to edit a particular title, select the name of the title, and you'll go to the Holdings Details page for that title, where you can make your edits (including deleting a title/holding). If you want to change or add multiple holdings in bulk, continue with this procedure.

    3. On the Database Details page, select the Download Titles button in the right side of the header.


      Although some clients prefer to upload their own spreadsheets rather than first downloading the titles file from within the Client Center, this usually creates more problems than it solves, due to the specific formatting requirements of the changed titles file during upload. However, if you need to use your own spreadsheet, follow the instructions for creating an Excel template.

    4. Save this text file to your computer. The file is a text document with tab-delimited columns, where you can modify your data using any text editor. When you are done modifying the data, continue with the next step.

      Alternatively, if you prefer to enter your data in a spreadsheet, you can open a spreadsheet application, such as Microsoft Excel, and open your text file from within the application. (You may need to change the Files of type field to All Files to see the text file.)

      If you use Excel, it will start the Text Import Wizard. Accept all the default suggestions (such as it's a delimited file, importing from row 1, and the delimiter is a Tab), until you get to the step that allows you to select the data format for each column. Change the default for the first column -- Title -- to Text format. The remaining columns may stay as General:

      Excel Text Import Wizard

      When you add new titles to the file, each title gets its own row (line), with the different columns available for all the information about that title. The only column that must be filled is the Title column, and (if your library uses the 360 Core: eBooks service) the Type column. If you want your patrons to be able to click directly from a title to the resource itself, you'll also need to provide a Default URL.

      If you want to remove titles, delete the containing row.

      The Type column show up in the spreadsheet template unless you use the 360 Core: eBooks service. If you do use the eBooks service, the Type column should contain either "Journal" or "Book." If your library does not use the eBooks service, and you choose to create your own spreadsheet rather than use the templates provided, please do not include a column for Type as this will cause an error in the upload process.

      If you want to add titles with Chinese (Simplified or Traditional), Japanese, or Korean characters, you may use the two right-most columns (Language ID and Alphabetization) to indicate how the titles should be sorted. See Chinese, Japanese, and Korean Alphabetization in LMH Databases for details.

      If you choose to add dates in the Coverage Dates or Publication Dates columns, they must conform to the valid date formats, or link resolvers (like 360 Link) will not recognize the dates, and overlap analysis results will be inaccurate.

      After adding or removing titles, Save the file as a text document (.txt) again.

      If your file contains any titles that have non-Latin characters, you must save the file as a Unicode text document (.txt).

      Excel - Save As - Unicode Text

    5. On the Database Details page, click Upload Titles.

    6. Browse to the text file that you want to upload.

    7. Before uploading, notice that there is an Overwrite Existing checkbox below the File To Upload field. The box is selected by default, meaning your newly uploaded file will automatically overwrite any existing files. If you do not want it to overwrite, but rather be added to any existing files, uncheck this box.

      If you are deleting titles, make sure the box is checked.


    8. Once you have selected the file, click Upload on the right side of the header.


    9. In the pop-up dialog box, select OK to continue. Please note that this does not necessarily mean that the file has been successfully imported.

    10. Shortly following the pop-up message, you will receive an email message that lets you know whether the text file contains any errors. Proceed to the following procedure to view the details of the upload: Viewing Your Upload Status.

    • Date Created: 9-Feb-2014
    • Last Edited Date: 7-Jul-2022
    • Old Article Number: 7124