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

    Configuring Import Profiles for Primo VE

    Return to menu

    Adding a Discovery Import Profile

    An Import profile enables you to define an external data source, apply normalization rules, configure delivery links, and schedule the execution of the import profile job.

    During the import, the contents of any field must not exceed the maximum field size of 32,766 characters (which is set by Apache Solr). 

    To define an import profile for discovery:
    1. Open the Import Profiles page (Configuration Menu > Discovery > Loading External Data Sources > Discovery Import Profiles), which lists all the Discovery import profiles.

    2. Select Add New Profile to open the Import Profile Details page.

      DiscoveryImportProfile_Add_NewUI.png

      Import Profile - Choose Discovery Type (Step 1)
    3. Ensure that the Discovery option has been selected and then select Next.

      PVE_ImportProfileDetails.png

      Import Profile Details Page (Step 2 - Profile Details Tab)
    4. Specify the following fields and then select Next.

      Discovery Import Profile - Profile Details
      Field Description
      Profile Details

      Profile name (required)

      The unique profile name. After it has been defined, it cannot be changed. This name appears in the list of import profiles and also appears at the top of the page.

      Profile description

      A free text description of the profile that shows on the list of import profiles.

      Data Source Code (required)

      The unique code for the external data source in Primo VE. After it has been defined, it cannot be changed.

      Data Source Label

      Defines the name of the search scope for the external data source. 

      You must save and reopen new search profiles before you can use the Globe icon to translate this field.

      See Defining a Local Data Scope to create local data scopes for your external data source.

      PVE_DCS_ExtInvCnd.png

      Search Scope for External Data Sources

      File name patterns

      A file name pattern (such as *.xml) filters out records that do not conform to the pattern you specify. Use this when the FTP directory contains additional files that should not be imported.

      Alma looks for this pattern as a sub-string in the file name, exactly like a regular expression, except for two changes:

      • A period . matches only a period (as if you had entered \\.).

      • An asterisk * matches zero or more characters of any type (as if you had entered .*).

      Otherwise, use regular expressions.

      Ensure that the regular expression you use exactly matches only the files that you want to import. For example:

      • The following retrieves all files ending in ".xml" (without the quotes): .xml$

      • The following retrieves all files containing the string “yLk” (without the quotes): yLk

      • The following retrieves all files beginning with “YLK” (without the quotes): ^YLK

      • The following retrieves all files beginning with “YLK” (without the quotes) followed by a space: ^YLK\s

      • The following retrieves any file that contains at least one of the following words (without the quotes): “harry” or “potter” or “rowling”: \b(harry|potter|rowling)\b

      • The following retrieves any file that contains all the following words (without the quotes): “harry” and “potter” and “rowling”: (?=*?\bharry\b)(?=*?\bpotter\b)(?=*?\browling\b)

      Originating system (required)

      The type of system from which the records originated.

      When using the MARC21 Bibliographic source format, set this field to Other.

      Import protocol

      The protocol used to retrieve the file containing the records. The options are:

      • FTP – Retrieve by FTP. You must enter fields under Import Processing and FTP Information (see below).

      • Upload File/s – Upload the file from a local or network drive.

      • OAI (Repository and Authority profiles only) – Retrieve using OAI. You must define additional fields associated with the OAI server (see below).

      Physical source format

      The file format of the import file. The available options are:

      • XML

      • Binary – Used with MARC21 Bibliographic source format only.

      Source format

      The format of the source records in the import file. Ensure that you base your selection on the source format of the incoming records, not the physical format of the import file or OAI feed:

      • Dublin Core – Dublin Core records encoded in oai-dc format.

      • Generic XML – Generic XML records (including Dublin Core records encoded in oai-dc format).

      • MARC21 Bibliographic – MARC21 records encoded in XML or binary format. With this format, your source records must include either an 035.a or 001 field, which is used as the Source control number to identify the record.

      • UNIMARC Bibliographic – UNIMARC records encoded in XML or binary format. With this format, your source records must include either an 035.a or 001 field, which is used as the Source control number to identify the record.

      Target format

      The format in which to save the records in Primo VE. The available options are:

      • Dublin Core – Select this option if Source format is Dublin Core or Generic XML.

      • MARC21 Bibliographic – This option is selected for you if Source format is MARC21 Bibliographic.

      • UNIMARC Bibliographic – This option is selected for you if Source format is UNIMARC Bibliographic.

      Status

      The default is Active. Select Inactive if you do not want the import profile to be available for use at this time.

      Share with Network

      For consortia environments only, this parameter indicates whether the external resource is included in the 'Entire network' search scope and shared with other member institution's catalogs.

      Enabling/disabling this feature requires you to republish the external data source.

      File Splitter Parameters (Generic XML only)

      Root element tag

      The name of the first tag in the file before the list of the records to process (for example, ListRecords).

      Record elements tag

      The name of the tag representing the beginning of a record. A file may contain one or more records.

      XPath to the identifier tag

      The XPath to the identifier tag of the record. This should be the tag that contains the unique identifier for the record.

      XPath to the location of the deleted status

      The XPath to the location of the deleted status of the record. Default value for a record is: deleted = false.

      Delete record regular expression

      This regular expression is applied to the value found under the XPath to the location of the deleted status field. If the regular expression matches the value found, the record is marked as deleted.

      Scheduling

      Appears if you selected FTP or OAI. When the profile is scheduled, a Metadata Import job appears in the list of scheduled jobs in Alma. For more information on this job, see Viewing Scheduled Jobs and Viewing Running Jobs.

      Files to import

      Select All for all files found in the FTP location. Select New to select only those files that have not yet been imported.

      Scheduler status

      Whether the scheduling is active or inactive.

      Scheduler

      Select one of the scheduling options from the drop-down list. Times depend on your time zone and the server you are using.

      Email Notifications

      Which users and email addresses receive email notifications when the publishing profile completes. Opens the Email Notifications for Scheduled Jobs page. You can choose whether to send the notifications for successful jobs and/or jobs that contain errors.

      FTP Information

      Appears only if you selected FTP as the Import Protocol.

      Description

      A description of the FTP submission format that is defined in this section.

      Server/Port

      The IP address and port of the FTP server sending or receiving the files.

      Username/Password

      The username and password for logging on to the server that is sending or receiving the files.

      Input directory

      The path of the submission format’s input directory.

      Max. number of files

      Not in use. Accept the default value.

      Max file size/Size type

      Not in use. Accept the default value.

      FTP server secured

      Whether to use a secure FTP transfer (SFTP)

      FTP passive mode

      Whether to use FTP passive mode or not. This depends on the setting in your FTP server.

      Test Connection

      Select to run a test of the FTP connection

      OAI Details

      Appears only if you selected OAI as the Import Protocol. 

      OAI Base URL

      The OAI provider’s URL that is used to harvest the metadata from the OAI repository.

       

      Authentication

      Indicates whether the OAI server requires you to enter a username and password.

      Username

      The username if authentication is required to access the server.

      Password

      The password if authentication is required to access the server.

      Connect and Edit

      Select to refresh the page with the associated OAI fields after entering the base URL of the server and authentication information if necessary.

      Before saving an OAI import profile, you must first select this button to test the OAI connection when adding or updating fields in the OAI Details section.

      The following fields appear after you select Connect and Edit. This enables you to specify information specific to the OAI repository, which is provided by the OAI provider.

      Repository Name

      The name of the repository.

      Granularity

      Indicates the granularity of the repositories date stamp.

      Earliest Date Stamp

      The earliest that data exists in the OAI provider records.

      Admin's E-Mail

      The e-mail address of an administrator of the OAI repository.

      Metadata Prefix

      The metadata prefix from the OAI provider. Currently, Primo VE supports oai_dc and qdc formats.

      Set

      If selective harvesting by group is necessary, specify the set name.

      Identifier Prefix

      The shared prefix that appears before the actual unique record identifier when harvesting by the identifier.

      Harvest Start Date

      When submitting a new import job and after the job completes successfully, the Harvest Start Date is updated automatically with the job’s ending time.

      For contentDM harvests, it is recommended that you leave this field empty due to an issue with contentDM.

      Encode Date

      Whether the repository supports encoding dates.

      Encode data

      Whether the repository encodes the data.

      Open Test Page

      Select to test the OAI connection and flow. See Testing OAI Import Protocol Flow.

    5. In the Normalization tab, select a normalization rules process if this data source requires additional normalization. For more information, see Creating Normalization Processes for External Data Sources.

      PVE_ImportProfileDetails-Normalization.png

      Import Profile Details Page (Step 3 - Normalization Tab)
    6. Select Next.

    7. In the Delivery tab, configure the following types of delivery links in their respective sections:

      • Link to Resource – Displays digital resources that include a link to the digital repository file. This configuration provides unrestricted access to full text and displays the link to full text in both the View Online and Links section on the Full Display page. In addition, records of this type display the Available online status on the Brief Results page and are included with the Available online facet.

        When both this option and the Link to Resource - Other Statuses option are configured, the import uses only one configuration. For more details, see Link to Resource - Other Statuses.

      • Link to Resource - Other Statuses – Displays digital resources that may or may not include a link to the digital repository file. This configuration provides either restricted access to full text or no access to full text. When restricted access is given to the record, a link to full text appears in both the View Online and Links sections on the Full Display page. In addition, records of this type display one of the following restricted availability statuses on the Brief Results page: Not available online, Check for availability, Not available online + Check holdings, or Check for availability + Check holdings. For more information regarding these statuses, see Configuring Display Labels for Availability Statuses and Full Text Links.

        You can configure both the Link to Resource and Link to Resource - Other Statuses options, but the import uses only one option to create the link to full text and to determine which availability status appears for the external record. The following table shows which configuration is given preference when both are configured. If the conditions for the preferred configuration are not met, the import uses the other configuration option if its conditions are met.

        Link to Resource Link to Resource - Other Statuses Method Used to Create Link to Full Text
        Template Template If its conditions are met, use only the template from the Link to resource section.
        Template Static URL from source If its conditions are met, use only the static URL from the Link to resource - Other Statuses section.
        Static URL from source Template If its conditions are met, use only the static URL from the Link to resource section.
        Static URL from source Static URL from source If its conditions are met, use only the static URL from the Link to resource - Other Statuses section.
      • Link to Request – Displays physical records that are loaded from an external data source and includes a link to the source system for the physical item's delivery options. This type of link appears in the Links section on the Full Display page, and records with this type of link display the Check holdings status on the Brief Results page and are included with the Held by library facet.

      • Link to Thumbnail – Displays the thumbnails for resource type images.

        The link must return an image file of a valid type (such as .bmp, .png, .jpg, and so forth).

      PVE_DiscoveryImportProfile_LTR_OtherStatuses.png

      Import Profile Details Page (Step 4 - Delivery Tab)
      1. For each type of link (resource, request, and thumbnail), specify the following information:

        • Select the method used to create the delivery links:

          • Template – Select this option if it is necessary to generate the delivery links using a combination of static text and linking parameters, which include normalized data taken from the source record. In addition to the source record's ID ($$SourceRecordID), the linking parameters ($$LinkingParameter1 - $$LinkingParameter5) are defined in the Linking Parameters section.

          • Static URL from source – This method enables you to use the source record's static URL for delivery, which may be stored in a Dublin Core tag (such as dc:uri) or a MARC21 field.

        • For the Template method only, specify the relevant linking parameters and static text to build the delivery link in the Template field. For example:

          http://hdl.handle.net/$$LinkingParameter1
        • For the Static URL method only, enter the following fields:

          • Dublin core tag – (DC targets only) Specify the Dublin Core tag from which to retrieve the record's static URL.

          • Field, Ind1, Ind2, and Sub field – (MARC targets only) Specify the MARC field, matching indicators, and the MARC subfield from which to retrieve the record's static URL.

        • Link Label – For resource links only, specify the label that displays for all resource links in Primo VE. 

          You must save and reopen new search profiles before you can use the Globe icon to translate this field.

        • Create a link – This checkbox appears only for the for the Link to Resource - Other Statuses option. If you are using the Static URL method, you can omit the full text links in the record's full display by clearing this checkbox. There is no option to omit the full text links when using the Template method. 

      2. In the Linking Parameters section, edit each linking parameter that was assigned to a template above. The Edit Linking Parameter dialog box opens:

        EditLinkingParameterDialogBoxFilled.png

        Edit Linking Parameter Dialog Box
      3. Specify the following fields and then select Save.

        • Source Tag (DC only) - Search for and select the DC source tag from which to get the delivery URL.

        • Field, Ind1, Ind2, and Sub field (MARC only) - Search for and select the MARC field, matching indicators, and the MARC subfield from which to get the delivery URL.

        • Use source tag - Select one of the following options to indicate whether the tag must contain a specific value:

          • Always - No matching string is necessary. The value is always used.

          • Matching string - The value of the tag must match the string specified in the Matching String field.

          • Matching string using a regular expression - The value of the tag must match the result of the regular expression specified in the Matching string field.

        • Matching String - If matching is necessary, specify the string that you want to match.

        • Normalization source tag - Select one of the following options to indicate whether normalization is necessary before loading the value into Primo VE.

          • No normalization - No normalization is needed. The value of the tag is taken as is.

          • Normalization using a regular expression - A regular expression is used to extract part of the value before saving to Primo VE.

        • Normalization pattern - If you need to extract parts of the tag, use regex groups to capture the necessary parts, which are concatenated to form the returned value from the source tag. 

        The following configuration matches dc:identifier fields with values that begin only with http or https, and then concatenates the values extracted with groups part1 and part2. For example, if dc:identifier contained the URL https://knowledge.exlibrisgroup.com/part1=whatever&part2=_you_want, the returned value would be whatever_you_want.

        Field Value

        Source Tag

        dc:identifier

        Use source tag

        Matching string using a regular expression

        Matching String

        ^(?:http(s)?:\/\/).*

        Normalization source tag

        Normalization using a regular expression

        Normalization pattern

        .*part1=(.+)&part2=(.+)

    8. Select Save to save the import profile.

    Configuring Display Labels for Availability Statuses and Full Text Links

    The Calculated Availability Text Labels code table enables you to customize/translate the display labels used for restricted/unrestricted availability statuses and full text links. The following table lists the supported codes.

    Code Description
    Link to Resource - Other Statuses (Restricted): For more information, see the Link to Resource - Other Statuses option.

    delivery.code.ext_restrictedNoLink

    This code displays the following availability status label when there is no access to full text:

    Not available online

    delivery.code.ext_restrictedWithLink

    This code displays the following availability status label when there is restricted access to full text:

    Check for availability

    delivery.code.ext_restrictedNoLink_and_physical

    This code displays the following availability status label when there is no access to full text, but there may be access to physical inventory:

    Not available online + Check holdings

    delivery.code.ext_restrictedWithLink_and_physical

    This code displays the following availability status label when there is restricted access to full text, but there may be access to physical inventory:

    Check for availability + Check holdings

    delivery.code.ext_restrictedNoLabel

    This code displays the following label for full text links if no label is configured for restricted resources:

    Link to external resource

    Link to Resource (Unrestricted): For more information, see the Link to Resource option.

    delivery.code.ext_not_restricted

    This code displays the following availability status label when there is unrestricted access to full text:

    Available Online

    delivery.code.ext_not_restricted_and_physical

    This code displays the following availability status label when there is unrestricted access to full text, and there may be access to physical inventory:

    Available online + Check holdings

    Running a Discovery Import Profile

    Discovery import profiles enable you to import records from external sources or update records that you have already imported from an external source.

    • Because the import assigns a unique MMS ID to each record based on the specified identifier in the import profile, subsequent imports of the same record (regardless of the import profile used) updates the existing record and does not create a new record.

    • If records are imported with one discovery import profile and updated with a second discovery import profile, the search scope for those records are changed to reflect the data source code and label of the second discovery import profile. If you had created conditions for the original data source in a local data scope, they must be updated to reflect the change to the data source.

    To run a discovery import profile:

    1. Open the Import Profiles page (Configuration Menu > Discovery > Loading External Data Sources > Discovery Import Profiles), which lists all of the Discovery import profiles.

    2. From the list of profiles, select one of the following row actions for the external source:

      • Run – Execute this command the first time that you want to load external data into Primo. If you use this option to reload data, permalinks for the records are not retained.

      • Reload – This action enables you to reload all records from an external data source without having to reharvest files from the external data source. This is useful if you need to apply indexing changes to existing records.

      • Reload and Delete – This action enables you to reload existing data and retain the permalinks for each existing record. This option removes any records that are not included in the harvest or import files.

        For OAI, the records that are imported is based on the Harvest Start Date field. Any record that is harvested before that date is not included in the import. To import all records from the repository, clear the Harvest Start Date field.

    3. If you are loading records from files stored to your workstation, specify the files and select Submit. For example:

      PVE_LoadFiles_DiscoveryImport.png

      Select Files for Import
    4. On the Job History page, select Refresh to view the progress of the import. For example:

      PVE_Monitor_DiscoveryImport.png

      Monitor Discovery Import Profile
    • Was this article helpful?