Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Primo

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Primo
    3. Knowledge Articles
    4. Import XLS (Excel) into Mapping Table Fails

    Import XLS (Excel) into Mapping Table Fails

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Primo
    • Product Version: 4

    Problem Symptoms:
    Error received during import attempt "Excel file contains invalid data. Check organization data."

    Cause:
    * File contains wrong / additional data (organization, institution ID)
    Usually the problem is that a newly-added institution field is completely empty.
    * Possibly the file was exported from source or different server

    Resolution:
    Work should be done on the Target exported file rather than the Source exported Data:
    1. Export the current data from Target.
    2. Update the exported file with new data, confirming that the institution field contains a space.
    3. Import back into Primo.

    Additional Information

    1. The institution code appears blank, but must contain a 'space' in the field (although it is invisible, it is mandatory).

    2. To avoid common errors in mapping spreadsheets (*.xls) that result in ?Excel file contains invalid data check the following:

    * If loading the spreadsheet at the institution level (not the installation level); be sure that to have established the mapping table at the *installation* level, NOT the *institution? level
    * As per the above, the mapping should be uploaded to:
    Advanced Configuration > All Mapping Tables > ILS Library Codes > Owner: <institution>
    NOT Advanced Configuration > All Mapping Tables > ILS Library Codes > Owner: Installation (or OTB; out-of-the-box)
    * If loading at the Installation level, the institution column should be blank.
    * There should be NO space(s) after text in any cells
    * There should be NO duplicate data in the spreadsheet
    * The spreadsheet file extension should be *.xls, not *.xlsx
    * All the lines of the Excel spreadsheet have the row height set to a uniform height (e.g. 16.5) and the columns set to wrap text.

    Category: BO Configuration

    Subject: Code & Mapping Tables


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Implementation script for PRM-19795 of SP 4.6 execution failed
      • Importing Library Tags from Library Thing is heavy on system
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Community Content Type
      How To
      Content Type
      Knowledge Article
      Language
      English
      Product
      Primo
    2. Tags
      1. 4
      2. BO Configuration
      3. Code & mapping tables
      4. contype:kba
      5. Prod:Primo
      6. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved