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

    Student Information Systems

    Translatable
    To configure a Student Information Systems (SIS) profile, you must have the following role:
    • General System Administrator
    Alma can export/import users to/from a Student Information System (SIS).
    To import users, the SIS must place a zip file containing an XML file with all the users into a defined S/FTP location. Alma fetches the file, parses the information, and uploads the users (of type External) according to the parameters defined in the SIS integration profile.
    • All primary and additional identifiers must be unique for users, including for the same user.
    • User data must be included in a zip file for import and synchronization purposes.
    • If you meet the “Could not parse file” error, try zipping XML files per their schema.

    You might want to export users to the SIS, for example users that owe the library money or have certain blocks. This enables the SIS to block these users from certain activities until they clear their outstanding obligations to the library.

    Background Information

    For a detailed overview of user management in Alma, see https://developers.exlibrisgroup.com/alma/integrations/user-management. Note that your external authentication system must be up and running before you can begin Alma implementation.
    For overview on user management and SIS integration, watch Creating and Updating User Records (5:06).

    Configuring an Integration Profile 

    To configure an integration profile to a Student Information Systems (SIS):
    1. On the Integration Profile List page (Configuration Menu > General > External Systems > Integration Profiles), select Add Integration Profile. The first page of the integration profile wizard appears.

      users_integration_profile_1_ux_newUI.png

      Users Integration Profile Wizard – Page 1
    2. On the first page of the wizard, enter the following information.
      1. Enter a code and name for the profile you are defining.
      2. From the Integration type drop-down list, select Users.
      3. From the S/FTP connection type drop-down list, select the name of the FTP connection that you previously defined.
      4. Indicate the type of SIS with which you are integrating (for Ex Libris’ informational purposes). Note that this is mandatory.
      5. Optionally, enter a description of the integration you are configuring.
      6. Select Next. The second page of the wizard appears.

        Integration Profile page_newUI.png

    3. On the second page of the wizard, enter the following information.
      Users Integration Profile Fields
      Section Field Description
      Import
      (used for the initial import of users. A record is not imported if a matching record is found. Manually run this once, or once per year. Afterwards, use the Synchronize section / job.)
      Active Whether the job is active. If the job is active, it will run according to the selected scheduling option. If it is inactive, it will not run.
      The job is called Users IMPORT using <integration profile name>.
      Record Type

      The type of user record to create in Alma: Contact, Public, or Staff.

      Each SIS profile loads one type of user (Staff or Public). To process a different user type, you need to define another SIS profile. If your institution has more than one type of user in a single SIS, it is recommended that you define the Record type in the profile as Public. This means that all the users will be created in Alma as public users. You can then use the user roles to differentiate between patrons and staff.

      For more information on selecting the record type, see https://developers.exlibrisgroup.com/alma/integrations/user-management/sis/synch.

      Input File Path A subdirectory of the path specified when creating the secure FTP connection (required). For example, if you enter Alma in the Sub-directory field during secure FTP connection configuration (note that it is mandatory to specify a value in this field) and you enter SIS_import in the Input file path field, the SIS files are imported from the Alma/SIS_import directory (under the root FTP directory).
      User XSD Version Select version 1 or 2. Note that 2 should be used. For detailed information about these versions, see https://developers.exlibrisgroup.com/alma/integrations/user-management/sis/synch.
      XSL Converter Select an XSL converter to process the Integration Profile XML files with XSL before placing them in the output location. Select Manage Converters to view and edit the converter. For details, see Integration XSL Converters.
      Create Sample File
      (available when editing an existing profile)
      Select an existing user and select Create Sample File to create a new user XML file from an existing user. This enables you to preview the way in which a user XML file should be structured.
      You can also view a sample XML file on https://developers.exlibrisgroup.com/alma/apis/xsd/external_sys_user.xsd
      Note that XML attributes are case-sensitive.
      Synchronize
      (used for ongoing synchronization of existing Alma users. Alma attempts to merge information if a matching record is found.)
      Active Whether the job is active. If the job is active, it will run according to the selected scheduling option. If it is inactive, it will not run.
      The job is called Users SYNCHRONIZE using <integration profile name>.
      Record Type

      The type of user record to create in Alma: Contact, Public, or Staff.

      Each SIS profile loads one type of user (Staff or Public). To process a different user type, you need to define another SIS profile. If your institution has more than one type of user in a single SIS, it is recommended that you define the Record type in the profile as Public. This means that all the users will be created in Alma as public users. You can then use the user roles to differentiate between patrons and staff.

      For more information on selecting the record type, see https://developers.exlibrisgroup.com/alma/integrations/user-management/sis/synch.

      Match ID Type The predefined unique identifier type in Alma to use as the identifier with which you want to match existing Alma users. For detailed information on match IDs, see https://developers.exlibrisgroup.com/alma/integrations/user-management/sis/synch.
      Synchronization Type Swap all, which means that all existing user records will be replaced by matching incoming user records. For detailed information on the synchronization workflow, see https://developers.exlibrisgroup.com/alma/integrations/user-management/sis/synch.
      Unmatched Record Whether Alma adds a new user record if it has failed to find a matching record, or rejects the incoming record if no match is found for it. By default, the records are added.
      Input File Path A subdirectory of the path specified when creating the secure FTP connection (required). For example, if you specified Alma in the Sub-directory field during secure FTP connection configuration (note that it is mandatory to specify a value in this field) and you enter SIS_import in the Input file path field, the SIS files are imported to the Alma/SIS_import directory (under the root FTP directory).
      Schedule If you select Not scheduled, the job runs only when you manually run it. For details, see the following sections Manually Importing/Exporting SIS Information and Manually Synchronizing SIS Information.
      The available scheduling options differ depending on your data center.
      User XSD Version Version 1 or 2. Note that version 2 should be used. For detailed information about these versions, see https://developers.exlibrisgroup.com/alma/integrations/user-management/sis/synch.
      XSL Converter Select an XSL converter to process the Integration Profile XML files with XSL before placing them in the output location. Select Manage Converters to view and edit the converter. For details, see Integration XSL Converters.
      Integration Profile Used For (Esploro only) Appears only if Esploro is enabled for your institution.

      Select one of the following:

      • User and Researchers – If you include both user and researcher information in your file.
      • Users only – If you include only user information (no researcher fields) in your file.
      • Researchers only – If you wish to add or update only the researcher information of the user. Note that each user must include the primary identifier of an existing Alma user and that other user information, if included in the file, will not be added or updated by the loader. You can load researcher identifiers as part of the Researchers Only option. For more information, see Adding Researchers.

      The synchronization is performed in swap all mode, which means that all of the existing information is replaced. If a field does not exist in the input file, it is deleted from the existing user or researcher. Therefore, the input file must always include all of the external information for the user or researcher, not only the updated fields.

      Select Researcher Fields To User (Esploro only) Appears only if Esploro is enabled for your institution.

      Select one of the following:

      • All Researcher Fields
      • Selected Researcher Fields – When selected, select one or more fields to update from the quick pick list that appears.
      Export User By Conditions
      (used to export users that should be blocked due to unpaid fines)

      Users exported include users with fines greater than the threshold and users with blocks, either based on the configured block types or all blocks if none are configured. If a user has fine greater than the threshold OR the user has a block, then the user will be exported.

      Active Whether or not the job is active. If the job is active, it runs according to the selected scheduling option. If it is inactive, it will not run.
      The job is called Users EXPORT using <integration profile name>.
      User ID Type See the above explanation for Match ID type.
      User Groups The user group(s) to which the users that you want to export belong. If no value is specified, users belonging to any of the configured user groups are exported.
      Block Types The previously defined block types (see Configuring Block Preferences) whose associated users you want to export. If no value is specified, users matching any of the configured block types are exported.
      Fine/Fee Age (days) The users (of the selected groups and with the selected block types) whose fines/fees are older than the stipulated number of days are exported. By default, this number is 0.
      Threshold Amount The users (of the selected groups and with the selected block types) whose fines/fees exceed the stipulated threshold are exported. By default, the threshold amount is 0.
      User with Active Loans Select this check box to include only users that have active loans.
      Active Loan Types When User with Active Loans is selected, this field appears. Users with active loans will be included in the export if the loan types match the loan types selected.
      Output File Path A subdirectory of the path specified when creating the S/FTP connection. For example, if you specified Alma in the Sub-directory field during S/FTP connection configuration and you enter SIS_export in the Output file path field, the SIS files are exported to the Alma/SIS_export directory (under the root FTP directory).
      Schedule If you select Not scheduled, the job runs only when you manually run it. For details, see the following sections Manually Importing/Exporting SIS Information and Manually Synchronizing SIS Information.
      The available scheduling options differ depending on your data center.
      Export Users
      (used to export old, inactive, or deleted users, or recently updated/created users - not for an ongoing full export of users)
      Active Whether the job is active. If the job is active, it runs according to the selected scheduling option. If it is inactive, it will not run.
      The job is called Users EXPORT_USERS using <integration profile name>.
      User Groups Select one or more user groups to identify the patron records to be considered for export.
      Days Since Creation Set a condition, in number of days, that identifies when to include a patron record in the export. This parameter indicates the number of days since the patron record was created in Alma. The patron record that meets this criterion must also be a member of one of the user groups selected in the User Groups parameter in order for the patron record to be exported.
      For example, if you specify 10 here, patron records that were created in the past 10 days are included in the export.
      Days Since Update Set a condition, in number of days, that identifies when to include a patron record in the export. This parameter indicates the number of days since the patron record was updated in Alma (see example in Days since creation). The patron record that meets this criterion must also be a member of one of the user groups selected in the User Groups parameter in order for the patron record to be exported.
      Days Since Deletion Set a condition, in number of days, that identifies when to include a patron record in the export. This parameter indicates the number of days since the patron record was deleted in Alma (see example in Days since creation). The patron record that meets this criterion must also be a member of one of the user groups selected in the User Groups parameter in order for the patron record to be exported.
      Output File Path A subdirectory of the path specified when creating the secure FTP connection. For example, if you specified Alma in the Sub-directory field during secure FTP connection configuration and you enter SIS_Export in the Output File Path field, the files are exported to the Alma/SIS_Export directory (under the root FTP directory).
      Schedule If you select Not scheduled, the job runs only when you manually run it. For details, see the following sections Manually Importing/Exporting SIS Information and Manually Synchronizing SIS Information.
      The available scheduling options differ depending on your data center.
      User XSD Version Version 1 or 2. Note that version 2 should be used. For detailed information about these versions, see https://developers.exlibrisgroup.com/alma/integrations/user-management/sis/synch.
      Online Import (Used to import users from a student management system)

      Not in use!

      Active Whether or not the function is active. If the function is active, a process accesses the student management system to fetch the user's information, if it exists. If the function is not active, the process will not run. The default is non-active.
      Base URL The host/port to which the API calls regarding the user changes will be sent. Mandatory if the Online import action is Active. Note that this should be a REST API which has user information in the format described on the Developer Network.
      User Name User name for the HTTP basic authentication credentials. Optional. If left empty, the requests will be sent without credentials.
      Password Password for the HTTP basic authentication credentials. Optional. If left empty, the requests will be sent without credentials.
    4. Select Save. The profile is saved. For information on the Contact Info tab when editing the profile, see Adding User Contact Information.
    When the Export Users job is run based on the integration profile you have created, the export process creates an XML file in the format that is used by the Import and Synchronize actions (refer to the Import section and Synchronize section defined under the Actions section on the Actions tab of the integration profile you saved). An XSL file may be used to alter the format. The XSL file is available and customizable in Customize Letters (see Configuring Alma Letters).

    Manually Importing/Exporting SIS Information

    To manually run and monitor an SIS import/export:
    When editing the profile, in the Import/Export section of the Actions tab, ensure that the Active radio button is selected and select Run.
    The job runs as soon as Alma can accommodate it. A file that is imported is marked so that it is not run again. If email notifications are enabled in Alma, you receive an email notification of an import and Alma sends notifications to the SIS of an export.
    To view the status of the job, the number of files processed, and other data, select Job history in the row actions list for the appropriate User profile on the Integration Profile List page.
    The status Completed Successfully does not mean that all files were imported or exported successfully. Rather, it means that the job completed without error.
    If you import a user whose primary identifier matches a primary identifier of one of the existing users, a User rejected on identifier event is generated.

     

    In the Users SYNCHRONIZE, Alma alerts only upon a fail rate of 5%. If the number of rejected users is less than 5% of the total number of processed users, the job will be marked as "Completed Successfully". 

    Manually Synchronizing SIS Information

    To manually run and monitor an SIS synchronization:
    When editing the profile, in the Synchronize section of the Actions tab, select Run.
    The synchronization job runs as soon as Alma can accommodate it. The file that is synchronized is marked so that it is not run again. If email notifications are enabled in Alma, you receive an email notification.
    To view the status of the job, the number of files processed, and other data, select Job history in the row actions list for the appropriate User profile on the Integration Profile List page.
    The status Completed Successfully does not mean that all files were synchronized successfully. Rather, it means that the job completed without error.
    If there is more than one file to be imported to Alma for synchronization, the files are read in the order that they are stored in the zip file. If a user appears more than once in the files, the first instance of the user will process. All of the user's remaining duplicate records will fail.
    For more information on the synchronization process, see https://developers.exlibrisgroup.com/alma/integrations/user-management/sis/synch.