SchemaAccountJob import fails with "ACCOUNTNAME and ENDPOINTNAME are mandatory in SAV file"

[taiyebur1]

I am trying to import the attached csv file accounts using SchemaAccountJob. It uses the pipe delimiter. However, it fails to import the accounts with the following error that says "ACCOUNTNAME and ENDPOINTNAME are mandatory in SAV file".

I am not sure what the issue is. I feel like the configuration is correct. Any help/advise would be appreciated.

CSV file and SAV file attached with the post.

[rushikeshvartak]

There is one extra line in end of sav file , please remove it

[taiyebur1]

Removed empty line. Same issue as before.

I wonder if it has something to do with the delimiter. I have worked on other SchemaAccountImport just today with comma and semicolon delimiter. They worked fine even with empty line at the end. Any ideas?

[rushikeshvartak]

Try with comma

[taiyebur1 · Accepted solution]

For whatever reason, it worked after removing ENT_TYPE_NOT_AVAILABLE, ENT_VAL_NOT_AVAILABLE and DELETEACCOUNTENTITLEMENT. Using comma didn't work either.

Important to note here is that this working config does create ENTTYPE and ENTVAL if they are not available.