Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

If you have user and group data you want to manage in EmpowerID, but that data is in an application that is not connected to EmpowerID – and for which you do not want to create a connector – you can do so by creating a "tracking-only" account store to represent that application in EmpowerID and then import the data from that application to the tracking-only account store in delimited flat file format.

...

Before importing users and groups, you need to do the following:

  1. Create a "tracking-only" account store in EmpowerID for the application containing the user and group data. This type of account store is internal to EmpowerID and is where EmpowerID places the user accounts and groups you import. This allows you to manage those accounts and groups from the representation of the application. For information on creating a tracking-only account store, see Creating Tracking-Only Applications.

  2. Have the user and group data you want to import in three separate delimited files:

    • one file for the user accounts

    • another for the groups

    • a third for the group memberships.

  3. Each file must have a certain number of fields that correspond to the EmpowerID object you are creating. These fields, listed by EmpowerID object type, are as follows: 

    • User Account:

      • Name, LogonName, FriendlyName

    • Group:

      • Name, LogonName, FriendlyName

    • Group Membership: 

      • AccountLogonName, GroupLogonName

These fields do not have to be named as such in the flat file. They must, however, be able to map to those fields in EmpowerID. Besides these fields, the flat files can have any number of additional fields. If a corresponding field exists in EmpowerID, map them when importing. If the fields do not have a corresponding field in EmpowerID, ignore them. This is all demonstrated below.

Import user accounts

  1. On the navbar, expand Single Sign-On and select Applications.

  2. Search for the "tracking-only" application to which you want to import user accounts and click the Display Name link for the application record returned to the grid.

...

  1. Image Added



    This directs your browser to the View One page for the application. Application View One pages allow you to view and manage the applications to which they relate.

...

  1. Image Added

  2. Select the Identities tab on the View One page for the application

...

  1. and then expand the Application Accounts (In Account Store or Linked Group) accordion.

...

  1. image-20241211-184055.pngImage Added

  2. Click Import Users From CSV.

    This initiates the Create Accounts From File workflow.

...

  1. image-20241211-183846.pngImage Added

  2. In the workflow form, enter the field delimiter for the flat file in the Delimiter field.

...

  1. The default is a comma.

  2. Click Browse and select the file with the user accounts you wish to import. Once you have selected a file, the Browse button is replaced with "File is Selected" text, and the Load CSV button

...

  1. is active.

  2. Click the Load CSV button.

...

  1. Image Added


    The form updates to display the data in the flat file. The column headers are shown in the text above the drop-downs, while the records are

...

  1. in the grid.

...

  1. Image Added

  2. Map each

...

  1. required

...

  1. field from the imported data to the appropriate EmpowerID account field. To do so, type the name of the required field in the drop-down below your related headers and then click the field to select it. For accounts, these fields are Name, LogonName, and FriendlyName.

    In our example, we have imported data with the account logon name listed under the Logon header. As this header does not match the Logon Name field for the component in EmpowerID, we need to map it before submitting the workflow. If the column headers in your flat file already match the required fields, you do not need to map them as the workflow does it for you. Additionally, if a field in the flat file does not have a corresponding account field in EmpowerID, the workflow ignores it. 

...

  1. Image Added


  2. Once you have completed your mapping, click Submit.

    After EmpowerID imports the users, you should see them in the accordion.

...

  1. Image Added


Import groups

  1. On the navbar, expand Single Sign-On and select Applications.

  2. Search for the "tracking-only" application to which you want to import user accounts and click the Display Name link for the application record returned to the grid.

...

  1. Image Added

    This directs your browser to the View One page for the application. Application View One pages allow you to view and manage the applications to which they relate.

...

  1. Image Added

  2. On the application's View One page

...

  1. , select the Identities tab and then expand the Application Groups (In Account Store or Linked Group) accordion.

...

  1. Image Added


  2. Click Import Groups From CSV.

    This initiates the Create Groups From File workflow.

...

  1. Image Added

  2. In the workflow form, enter the field delimiter for the flat file in the Delimiter field.

...

  1. The default is a comma.

  2. Click Browse and select the file with the groups you wish to import. Once you have selected a file, the Browse button is replaced with "File Selected" text, and the Load CSV button

...

  1. is activated.

  2. Click the Load CSV button.

...

  1. Image Added


    The form updates to display the data in the flat file. The column headers are shown in the text above the drop-downs, while the records are shown in the grid.

...

  1. Image Added

  2. Map each

...

  1. required

...

  1. field from the imported data to the appropriate EmpowerID account field. To do so, enter the name of the required field in the drop-down menu and then click the field to select it. For groups, these fields are Name, LogonName, and FriendlyName.

  2. As needed, map all other fields to their corresponding EmpowerID fields. If the column headers in your flat file already match the required fields, you do not need to map them as the workflow does it for you. Additionally, if a field in the flat file does not have a corresponding group field in EmpowerID, the workflow ignores it.

  3. Once you have completed your mapping, click Submit.

  4. After EmpowerID imports the group, click the Search button in the Application Groups accordion. You should see the newly imported group(s).

...

  1. Image Added

Import group memberships

  1. On the navbar, expand Single Sign-On and click Applications.

  2. Search for the "tracking-only" application to which you want to import group memberships

...

  1. . Click the record returned for the application, and then expand the Application Groups (In Account Store or Linked Group) accordion on the Application Details page.

...

  1. Image Added

  2. Click Import Group Members From CSV.

    This initiates the Create Group Accounts From File workflow.

...

  1. Image Added


  2. In the workflow form, enter the field delimiter for the flat file in the Delimiter field.

...

  1. The default is a comma.

  2. Click Browse and select the file with the user information you wish to import. Once you have selected a file, the Browse button is replaced with "File Selected" text, and the Load CSV button

...

  1. is activated.

  2. Click the Load CSV button.

...

  1. Image Added


    The form updates to display the data in the flat file. The column headers are shown in the text above the drop-downs, while the records are shown in the grid.

...

  1. Image Added

  2. Map each

...

  1. required

...

  1. field from the imported data to the appropriate EmpowerID account field. To do so, type the name of the required field in the drop-down and then click the field to select it. For group memberships, these fields are Account_LogonName for the user account

...

  1. and Group_LogonName for the group.

  2. Once you have completed your mapping, click Submit.

Verify Group Membership

After EmpowerID imports the group memberships, you can verify the accounts have been added to the groups by doing the following:

  1. Select the Group filter on the global search bar at the top of the page.

...

  1. Image Added

  2. Enter the name of a group whose membership you imported and then click the tile for that group.

    This directs your browser to the View page for the group.

...

  1. Image Added

  2. Expand the Group Members accordion.

    You should see the imported group member(s).

...

  1. Image Added

Insert excerpt
IL:External Stylesheet
IL:External Stylesheet
nopaneltrue