Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Variable Names for Schema File Based Account Upload

Philip_Malmos1
New Contributor II
New Contributor II

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

13 REPLIES 13

vivek9237
Regular Contributor
Regular Contributor

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

Regards,

Vivek Mohanty


If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

Philip_Malmos1
New Contributor II
New Contributor II

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
All-Star
All-Star

@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)

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Philip_Malmos1
New Contributor II
New Contributor II

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

what are columns you need help ?


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

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

Manu269_0-1712647375829.png

@uthra_rahul can this be checked.

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

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Philip_Malmos1
New Contributor II
New Contributor II

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?

All columns in accounts table are possible


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Philip_Malmos1
New Contributor II
New Contributor II

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 UIDatabaseSchema File Upload
 ACCOUNTCLASS 
 ACCOUNTCONFIG 
 ACCOUNTID 
 ACCOUNTKEY 
 ACCOUNTTYPE 
 APPLICENSETYPE 
 ARSTASKKEY 
 COMMENTS 
Created OnCREATED_ONCREATED_ON
 CREATOR 
Custom Property XXCUSTOMPROPERTYXXCUSTOMPROPERTYXX
 DESCRIPTION 
 DISPLAYNAME 
 ENDPOINTKEY 
 INCORRECTLOGONS 
 JOBID 
Last Login DateLASTLOGONDATELASTLOGINDATE
 LASTPASSWORDCHANGE 
 LOCKEDSTATE 
NameNAMEACCOUNTNAME
 ORIG_ARSTASKKEY 
 ORPHAN 
 PASSWORDCHANGESTATUS 
 PASSWORDLOCKDATE 
 PRIVILEGED 
 REFERENCED_ACCOUNTKEY 
 REFERENCED_ACCOUNTNAME 
 SAVIYNT_CONNECT_JOBID 
 SAVIYNT_CONNECT_UPDATEDATE 
 SAVLICENSETYPE 
StatusSTATUSSTATUS
 SYSTEMID 
 TARGETLASTPASSWORDCHANGE 
 TOTALUSAGE 
 UPDATEDATE 
 UPDATEUSER 
 USERGROUP 
 USERLOCK 
Valid FromVALIDFROMVALIDFROM
Valid ThroughVALIDTHROUGHVALIDTHROUGH

  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

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Philip_Malmos1
New Contributor II
New Contributor II

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.

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

Its trail and error


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.