Variable Names for Schema File Based Account Upload

[Philip_Malmos1]

Hi,

I'm trying to upload accounts to our system through Schema FileBased uploads (.SAV file in to .CSV file). This is due to I'm trying to implement disconnected applications and there is no possibility to connect directly through API. Is there any documentation for which fields that can be used by Schema File Upload?

I found the following through trial-and-error:

ACCOUNTNAME,endpointname,status,customproperty4,created_on,LASTLOGINDATE

...and would like to read the documentation (if any) going forward.

e.g. LASTLOGINDATE:

I tried "Last Login Date" as that is the naming in the UI, but it didn't work.

I tried "last_login_date" as that worked when converting "Created On" to "created_one", but it didn't work.

I tried "lastlogondate" as that is the database name, in the Accounts table, but it didn't work.

Lastly, I tried lastlogindate and that finally worked.

Where can I see a list of variable names that can be used by a Schema File Upload.

Best regards,

Philip

[vivek9237]

@Philip_Malmos1 Have you tried LASTLOGONDATE?
Please refer this for account column names - Database Schema Reference (Accounts) 

[Philip_Malmos1]

Thanks for the reference to the database field names, but that was exactly my problem - they don't (always) match the field names used for Schema File Uploads.
LASTLOGONDATE (as in the database) does NOT work

LASTLOGINDATE does work

I am looking for a list like the one you link to, but that applies to Schema File Upload Variables.

[Manu269]

@Philip_Malmos1 

Uploading Accounts and Associated Entitlements Using Schema Upload can be found here : Uploading Accounts and Associated Entitlements Using Schema Upload (saviyntcloud.com)

Variables list : User and Account Attributes (saviyntcloud.com)

[Philip_Malmos1]

Hi Manish,

The Variables list is very interesting, but I believe it's wrong:

Under the account attributes I see "name", while the variable normally used is "accountname". I tried to use "name" instead, and this failed. When I changed it to "accountname" then it worked. I work with v. 24.3

Also, there are a bunch of other account attributes that aren't on the list, such as the ones I found during trial-and-error: "created_on" and "lastlogindate". Those are not mentioned on the list.

Do you know of any updated list with the correct variable names?

Regards,

Philip

[rushikeshvartak]

what are columns you need help ?

[Manu269]

@Philip_Malmos1 you can use below options in doc portal for more clarity:

@uthra_rahul can this be checked.

[This message has been edited by moderator to mask email address]

[Philip_Malmos1]

I need help with knowing what columns/variables that are available to be imported through Schema file upload.

Is it every account field that can be used as variable in the .SAV and .CSV file?

If yes, what are their respective variable name?

Will each field in the "Accounts" table in the database be a possible variable name for Schema Files?

[rushikeshvartak]

All columns in accounts table are possible

[Philip_Malmos1]

Hi,

Is there any documentation that resembles the below table that I have managed to build so far, that shows the difference in attribute names depending if they are from "Saviynt UI", "Database" or "Schema File Upload".

E.g.

Name != ACCOUNTNAME

LASTLOGONDATE != LASTLOGINDATE

What other differences are there?

Saviynt UI	Database	Schema File Upload
	ACCOUNTCLASS
	ACCOUNTCONFIG
	ACCOUNTID
	ACCOUNTKEY
	ACCOUNTTYPE
	APPLICENSETYPE
	ARSTASKKEY
	COMMENTS
Created On	CREATED_ON	CREATED_ON
	CREATOR
Custom Property XX	CUSTOMPROPERTYXX	CUSTOMPROPERTYXX
	DESCRIPTION
	DISPLAYNAME
	ENDPOINTKEY
	INCORRECTLOGONS
	JOBID
Last Login Date	LASTLOGONDATE	LASTLOGINDATE
	LASTPASSWORDCHANGE
	LOCKEDSTATE
Name	NAME	ACCOUNTNAME
	ORIG_ARSTASKKEY
	ORPHAN
	PASSWORDCHANGESTATUS
	PASSWORDLOCKDATE
	PRIVILEGED
	REFERENCED_ACCOUNTKEY
	REFERENCED_ACCOUNTNAME
	SAVIYNT_CONNECT_JOBID
	SAVIYNT_CONNECT_UPDATEDATE
	SAVLICENSETYPE
Status	STATUS	STATUS
	SYSTEMID
	TARGETLASTPASSWORDCHANGE
	TOTALUSAGE
	UPDATEDATE
	UPDATEUSER
	USERGROUP
	USERLOCK
Valid From	VALIDFROM	VALIDFROM
Valid Through	VALIDTHROUGH	VALIDTHROUGH

[rushikeshvartak]

1. PASSWORDLOCKDATE
   CUSTOMPROPERTY10
   CUSTOMPROPERTY12
   CUSTOMPROPERTY11
   CUSTOMPROPERTY18
   CUSTOMPROPERTY17
   CUSTOMPROPERTY19
   CUSTOMPROPERTY14
   CUSTOMPROPERTY13
   CUSTOMPROPERTY16
   CUSTOMPROPERTY15
   JOBID
   ACCOUNTID
   SAVLICENSETYPE
   UPDATEDATE
   PASSWORDCHANGESTATUS
   VALIDTHROUGH
   INCORRECTLOGONS
   LASTLOGONDATE
   REFERENCED_ACCOUNTKEY
   ACCOUNTCLASS
   PRIVILEGED
   NAME
   USERGROUP
   STATUS
   CUSTOMPROPERTY4
   CUSTOMPROPERTY5
   CUSTOMPROPERTY31
   SAVIYNTCONNECTUPDATEDATE
   CUSTOMPROPERTY2
   SYSTEMID
   CUSTOMPROPERTY3
   CUSTOMPROPERTY1
   CUSTOMPROPERTY30
   ARSTASK
   DISPLAYNAME
   REFERENCED_ACCOUNTNAME
   ACCOUNTTYPE
   DESCRIPTION
   LASTPASSWORDCHANGE
   APPLICENSETYPE
   CUSTOMPROPERTY8
   CUSTOMPROPERTY9
   USERLOCK
   CUSTOMPROPERTY6
   CUSTOMPROPERTY7
   CUSTOMPROPERTY21
   CUSTOMPROPERTY20
   CREATOR
   CUSTOMPROPERTY23
   COMMENTS
   CUSTOMPROPERTY22
   SAVIYNTCONNECTJOBID
   ENDPOINTKEY
   CUSTOMPROPERTY29
   CUSTOMPROPERTY28
   UPDATEUSER
   ORPHAN
   CUSTOMPROPERTY25
   CREATEDON
   CUSTOMPROPERTY24
   CUSTOMPROPERTY27
   CUSTOMPROPERTY26
   ACCOUNTCONFIG
   TOTALUSAGE
   VALIDFROM

[Philip_Malmos1]

I think I need to accept that there isn't such a list that I'm requesting, and that I need to build one on my own. From the list from @rushikeshvartak , I know that there are multiple attributes that would not work, as I have already tested them. E.g.:

LASTLOGONDATE needs to be LASTLOGINDATE

NAME needs to be ACCOUNTNAME

CREATEDON needs to be CREATED_ON

... maybe the other fields on your list are correct and would work for Schema File Upload, but I can't rely on that, sorry.

[jralexander137]

Did you ever happen to find this list? Or just compiling your own via trial and error?

[rushikeshvartak]

Its trail and error