11/03/2022 06:57 AM
Hello all,
We are doing entitlement mapping of 'accounts' to 'entitlements', we have already uploaded accounts and entitlements separately using schema imports.
There are two entitlement types, Groups and Roles. We are able to upload and map one entitlement type at a time. Is there a way that the Schema Import can map for both the entitlement types in single schema import job and SAV file?
Below are screenshots for SAV and CSV file we are using.
In this case only Role1 is getting mapped and not the Group1.
Thanks,
Akhil
Solved! Go to Solution.
11/03/2022 07:44 AM
You can do as below - Role & Study are 2 Entitlement Type
SAV file
SystemName=APP1
FileNameStartswith=APP1.csv
ENTITLEMENT_TYPE=Role,Study
DELETEACCOUNTENTITLEMENT=YES
OVERWRITE_USER_ASSIGNED=TRUE
ACCOUNT_NOT_IN_FILE_ACTION=NOACTION
IGNOREFIRSTLINE=TRUE
FILEIMPORTDELIMETER=,
SECURITYSYSTEM_NOT_AVAILABLE=NOACTION
ENDPOINT_NOT_AVAILABLE=NOACTION
ENT_TYPE_NOT_AVAILABLE=NOACTION
ENT_VAL_NOT_AVAILABLE=NOACTION
USERNAME,ACCOUNTNAME,endpointname,status,Role,Study
CSV File :
USERNAME,ACCOUNTNAME,endpointname,status,Entitlement,Study
aldhaheri,aldhaheri,APP1,1,Data Entry,CV
aagulnik,aagulnik,APP1,1,Project Owner,SJDatabase
aagulnik,aagulnik,APP1,1,PI,EVAT2
11/03/2022 08:39 AM
Hello Rushikesh, Thanks for the answer.
In your CSV file I don't understand the column 'Study' and what values do we have under that column. Ideally, we should be able to give some rows of 'Study' entitlement type and some rows of 'Role' type, and I'm unsure how we achieve that here?
Thanks,
Akhil
11/03/2022 09:53 AM
Import format is different vs schema import format hence it will look below
Column header does not matter
11/03/2022 09:55 PM
Thank you for the sample file, this works for multiple entitlement type schema import