Applies To:

GroupID 11

Business Scenario:

We want to import members to a group from an external data source using the GroupID portal.

More Information:

To import the membership for a group from an external data source, such as a CSV, TXT, XLSX, XLS, or XML file, GroupID offers the Import Group Membership wizard. The members you are looking to import must exist in Active Directory and can be resolved using a unique identifier. This is different from a database group where the connection to the external data source is persistent. A use case for a database group is when you have sensitive information in your database that you do not want to bring into your Active Directory, but you still want to build a criterion based on the information.


You must specify an external data source; the Import Group Membership wizard gets the list of members from it and imports them from the Active Directory into the group. For example, you have a list of Employee-IDs in a text file, and you want to add all Active Directory users with matched IDs to the membership of the group.

The process to import members is discussed in these steps:

  • Launch the GroupID portal and search for the Group you would like to import members into.
  • Navigate to the Members tab and click on the Import button to launch the Import Wizard.
  • On the Membership Lifecycle page, specify whether the imported members will remain in the group permanently or temporarily. Provide the following information and click Next:

    Select the Import member perpetually option to import the membership for the group permanently.
              Select the Import Members temporarily option to import the membership for the group temporarily. In case of temporary membership, select the membership duration from the Duration list:
    • 7 Days: to import the membership for 7 days starting today.
    • 30 Days: to import the membership for 30 days starting today.
    • 90 Days: to import the membership for 90 days starting today.
    • Custom: to import the membership for the period indicated in the From and To boxes. Members are added to the group on the date in the From box.


  • On the Data Source page, select and configure the data source that contains the objects to import to the group. You can choose between a Local File such as TXT, CSV, XLS, XLSX, and XML or an External Data Source such as SQL DB, ODBC, SCIM providers, etc.


  • If you select, External Data Source in the above step, on the next page, you will be required to provide an LDAP Criteria and an External Source in the Query Designer.


  • Click on the Query Designer button and provide the Data Source from where you would like to import the Membership. 


  • If you select Local File on the Data Source page as the source, simply upload the relevant file.


  • On the Import Options page, select the search option and map the data source fields to the Active Directory fields.
    • The wizard matches the values of the mapped fields to determine the objects to import.
    • From the Source field list, select the name of the field in the external data source to map to its equivalent Active Directory field.
    • From the Destination field list, select the name of the Active Directory field to map to the selected source field. The wizard imports memberships where values for both fields match.
            A screenshot of a computer<br><br>Description automatically generated
  • Click Next to Preview the objects returned for adding as group members.

  • Click Finish