importing required data through schema based import

[sairamya15]

Hi All,

We have requirement where client provide the large data file of a disconnected application, Can we use Schema upload to fetch only required columns from the file which are required for import and leave other columns untouched.

Also in the Data file provided by the clients does not contain exited employee data can we use ACCOUNT_NOT_IN_FILE_ACTION= SUSPEND

[Darshanjain]

Hi @sairamya15 

ACCOUNT_NOT_IN_FILE_ACTION= SUSPEND can be used , so All accounts which are not in file will get suspended.

On the second point- In the sav file mention the column names which are needed- it should be in the same order as csv file, the remaining columns even if kept are blank will not be considered in the import as its not present in sav file.

Thanks
Darshan

[sairamya15]

Hi @Darshanjain 

Thanks for the response.

On the second point- In the sav file mention the column names which are needed- it should be in the same order as csv file, the remaining columns even if kept are blank will not be considered in the import as its not present in sav file. -We got below error when column count is more in CSV File.

Please guide us.

2023-09-06T21:31:38+05:30-ecm-worker-services.ImportReqsysDataService-quartzScheduler_Worker-3-DEBUG-SAV file column count is greater or less than csv file column count

2023-09-06T21:31:38+05:30-ecm-worker-services.ImportReqsysDataService-quartzScheduler_Worker-3-DEBUG-ERROR-column-count-mismatch: Either Delimiter in schema and accounts file doesn't match or Number of attributes in schema and account file doesn't match

[Darshanjain]

Hi @sairamya15 

Can you pass them as blank column in sav file based on csv file columns

Thanks

Darshan

[sairamya15]

Hi @Darshanjain 

Here "Demo column" should be ignored even it is present in CSV file.

We are still getting the error and job is Failed. Please refer SAV file below

SystemName=XXXX
FileNameStartswith=Account
ENTITLEMENT_TYPE=Template,Roleid,Fncid,Frmname
DELETEACCOUNTENTITLEMENT=NO
OVERWRITE_USER_ASSIGNED=TRUE
ACCOUNT_NOT_IN_FILE_ACTION=NOACTION
IGNOREFIRSTLINE=TRUE
FILEIMPORTDELIMETER=,
SECURITYSYSTEM_NOT_AVAILABLE=NOACTION
ENDPOINT_NOT_AVAILABLE=NOACTION
ENT_TYPE_NOT_AVAILABLE=CREATE
ENT_VAL_NOT_AVAILABLE=CREATE
USERNAME,DISPLAYNAME,ACCOUNTNAME,endpointname,status,Template,Roleid,Fncid,Frmname,customproperty1,customproperty4

Headers in CSV file

USERNAME,DISPLAYNAME,ACCOUNTNAME,endpointname,status,Template,Roleid,Fncid,Frmname,customproperty1,customproperty4,Demo

[Darshanjain]

HI @sairamya15 

SAV file

ENT_VAL_NOT_AVAILABLE=CREATE
username,firstname,lastname,,

Headers in CSV file

username,firstname,lastname,location,displayname

Try like this and let me know.

Thanks

Darshan

[sairamya15]

HI @Darshanjain 

I have tried as you suggested but no luck same error message.

Sav File

ENT_VAL_NOT_AVAILABLE=CREATE
USERNAME,DISPLAYNAME,ACCOUNTNAME,endpointname,status,Template,Roleid,Fncid,Frmname,customproperty1,customproperty4,,

CSV File

[This message has been edited by moderator to mask PII from image]

[Darshanjain · Accepted solution]

Yeah think its due to the end its not taking the column, if you can modify the csv file and keep the last column as valid. and keep the demo & demo1 in the center in csv file and in savfile keep it empty and try it out.

If this doesnt work out then there is no way to achieve ur use case

Thanks

Darshan