01-27-2023 02:29 AM
Hi Experts ,
i have uploaded the accounts successfully using schema upload job but somehow the entitlements are not being uploaded , could you please suggest what's the issue ?
CSV file :
Solved! Go to Solution.
01-27-2023 03:06 AM
01-27-2023 03:21 AM - edited 01-27-2023 03:22 AM
Unfortunately, in my experience, the documentation is not great and the examples provided are full of inconsistencies, despite several documentation error reports.
In the last line of the SAV file, you specify the header. The header in the SAV file must match the header of the corresponding CSV file.
In your SAV file you have "ENTITLEMENT_TYPE=Groups", yet "Groups" does not feature in the header line. Try changing the "Role" column to "Group" (in both the SAV and CSV files) and make sure that column contains the names of the corresponding entitlement type.
As an example, we use the following SAV file for one of the applications:
SystemName=Payspace FileNameStartswith=PayspaceAccounts ENTITLEMENT_TYPE=Group DELETEACCOUNTENTITLEMENT=YES OVERWRITE_USER_ASSIGNED=TRUE ACCOUNT_NOT_IN_FILE_ACTION=NOACTION IGNOREFIRSTLINE=TRUE FILEIMPORTDELIMETER=, ACCOUNTNAME,DISPLAYNAME,endpointname,status,Group,customproperty2,customproperty3,customproperty4
Where the "Group" column contains the names of the entitlements of type "Group".
Similarly for the same application we have "Organization Unit" as another entitlement type and use the following SAV file to upload account and entitlement associations:
SystemName=Payspace FileNameStartswith=PayspaceOUAccounts ENTITLEMENT_TYPE=Organization Unit DELETEACCOUNTENTITLEMENT=NO OVERWRITE_USER_ASSIGNED=TRUE ACCOUNT_NOT_IN_FILE_ACTION=NOACTION IGNOREFIRSTLINE=TRUE FILEIMPORTDELIMETER=, ACCOUNTNAME,DISPLAYNAME,endpointname,status,Organization Unit
Where the "Organization Unit" column contains the name of the entitlement of type "Organization Unit"
Hope that helps.
01-27-2023 04:01 AM
01-27-2023 04:37 AM - edited 01-27-2023 04:40 AM
Apologies. For "entitlement name" I should have referred to "Entitlement Value", for example: