User with Multiple Entitlements from Delimited File

[kyleduffyniq (Kyle Duffy)]

I have a delimited file that has users with their entitlements. Some of these users have multiple entitlements on the same source. When I upload the account list it scans all the users but does not add them to their multiple entitlements. It just seemingly picks one at random to add them to. I do not get any errors when importing accounts or entitlements, the users just don’t show up in their multiple entitlements for some reason.

Example:
Test User1 should be in both entitlement1 and read2 but after setting up the source and importing Accounts and Entitlements they only show up in read2
Account Schema File:

Entitlement Schema File:

[MVKR7T (Krishna Mummadi)]

Did you set the attribute as multi-valued in source account schema ?

[kjakubiak (Kamil Jakubiak)]

Did you configure merging in your delimited file configuration?

[kyleduffyniq (Kyle Duffy)]

Role is set to entitlement AND multi-valued on the Account Schema, yes

[kyleduffyniq (Kyle Duffy)]

Not seeing merging as any configuration option. I found an article discussing this and see the config option in IIQ but now in IDN. I looked in API and see merging is set to true on the Role attribute only. Screenshots of config options in IDN below and role info from API below that.

Role info from API:
“connectorAttributes”: {
“mergeColumns”: [
“Role”
],
“group.mergeRows”: true,
“group.delimiter”: “,”,
“test.mergeColumns”: null,
“mergeRows”: true,

[kyleduffyniq (Kyle Duffy)]

I found this issue! The users MUST be in order for the file to pick them all up. So I had to sort Login by A->Z and then re-upload and it captures everything correctly. I found the needed information here:

- [IdentityNow] Entitlements are missing from identities after delimited file...

“The CSV is not sorted by account ID. All entitlements for a single account ID must be listed together within the CSV. Otherwise, only a partial subset of the entitlements will be added to the identity.”