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 ?
Savfile :
SystemName=Octopus
FileNameStartswith=Octopus
ENTITLEMENT_TYPE=Groups
DELETEACCOUNTENTITLEMENT=YES
OVERWRITE_USER_ASSIGNED=TRUE
ACCOUNT_NOT_IN_FILE_ACTION=SUSPEND
IGNOREFIRSTLINE=TRUE
FILEIMPORTDELIMETER=,
ENT_TYPE_NOT_AVAILABLE=CREATE
ENT_VAL_NOT_AVAILABLE=CREATE
ACCOUNTNAME,endpointname,entitlementname,Role,status,OWNERTYPE,OWNERUSER,OWNERRANK,OPERATION
CSV file :
ACCOUNTNAME | endpointname | entitlementname | Role | status | OWNERTYPE | OWNERUSER | OWNERRANK | OPERATION |
613826 | Octopus | Testingabc | IT Users | 1 | USER | adminaj | 1 | ADD |
615524 | Stark | Testingabc | IT Users | 1 | USER | adminaj | 1 | ADD |
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: