Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Empty columns in UserImport

HarishG
Regular Contributor
Regular Contributor

Hi,

If we are having first column as empty value in the import file, it is failing to import the record.

HarishG_1-1711628830613.png

 

HarishG_0-1711628816254.png

 

Is it normal behaviour ? or is it a bug??

Attached the import file for reference

Best regards,

Harish

 

9 REPLIES 9

rushikeshvartak
All-Star
All-Star

Keep username as first column


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

HarishG
Regular Contributor
Regular Contributor

Hi @rushikeshvartak ,

Thanks for the reply.

I have tried giving the username as first column. It still fails if the first column(username) is empty

HarishG_0-1711629390919.png

 

Above sheet is working in v24.3

use blank column as “”


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

HarishG
Regular Contributor
Regular Contributor

Thanks @rushikeshvartak ,

Ok, then it could be a bug in v23.11

I tried to use “” for blank cloumn. But its taking it as a value and creating user with username as “”

HarishG_0-1711630128177.png

HarishG_1-1711630135674.png

 

Sorry typo use ""


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

HarishG
Regular Contributor
Regular Contributor

Its not working if we use "" for empty value in first column - atleast in v23.11

HarishG_0-1711630662808.png

Import file data:

"username","customproperty1"
"","536374844"

Username can't be blank Please change values also 

rushikeshvartak_0-1711632470442.png

rushikeshvartak_1-1711632478030.png

 

as suggested 

rushikeshvartak_2-1711632580356.png

rushikeshvartak_3-1711632589301.png

 

 

 

 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

HarishG
Regular Contributor
Regular Contributor

Thanks @rushikeshvartak ,

Yes its works only if the first column value is not empty.

So, If we don’t get the username column in the import and if the first column value is empty, then the import fails?

 

Best regards

Harish

Yes its expected 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.