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

How can we filter the data before importing a CSV into Saviynt?

Chirag_Gupta
New Contributor II
New Contributor II

How can we filter the data before importing a CSV into Saviynt? For instance, if the CSV contains various users with different user types (such as employees and contractors), and we only want to import users with "employee" as their user type, is there a method to accomplish this without manually modifying the CSV?

Thanks,

Chirag Gupta

3 REPLIES 3

Raghu
Honored Contributor
Honored Contributor

@Chirag_Gupta  We can't , before import , at the time export you can apply filter and get data wherever better apporch.

 


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

Chirag_Gupta
New Contributor II
New Contributor II

I came across a similar discussion where they recommended utilizing a pre-processor to accomplish this task. @Raghu 

Exclude particular value from "Employee type" in u... - Saviynt Forums - 13856

How can we employ a pre-processor to selectively filter out users before initiating the import process?

Thanks,

chirag

Hi @Chirag_Gupta ,

Inline-Preprocessor is the answer for your question.

Refer below documentation to prepare the code: 

Normalizing the Identity Data Using the User Import Preprocessor (saviyntcloud.com)

Solved: Re: User upload without creation - Saviynt Forums - 90730

Sample code to refer:

 

{
"ADDITIONALTABLES": {
"USERS": "SELECT username,COMPANYNAME,employeetype FROM USERS"
},
"COMPUTEDCOLUMNS": [
"employeetype"
],
"PREPROCESSQUERIES": [
"DELETE FROM NEWUSERDATA where NEWUSERDATA.employeetype!='Employee'"
]
}

 

Use this code in the user import before 'Upload and Preview':

PremMahadikar_0-1715162126581.png

If this answers your question, please consider selection Accept As Solutions and hit Kudos