Deleting Accounts from import CSV

[PascalMontreuil]

Hello, in our SAVIYNT UAT environnement we are trying to delete 3 tests account that are causing use issues on our ImportAccount Job.  Is there a way to take those account and delete them via manual Import Account features in SAVIYNT in the Accounts sections?  Here a our bad accounts.  Even is those account are soft delete in the application side, connected application, we are not able to update those account to soft delete.

[rushikeshvartak · Accepted solution]

You can use import sheet. which will contains all accounts exists currently and dont add 3 accounts which needs to be suspended add tick below option while import

Or you can do using custom query

update accounts set name=concat(name,'-Deleted on-01-27-2023 00:00',status='SUSPENDED FROM IMPORT SERVICE' where accountkey in(1,2,3) limit 3

[PascalMontreuil]

Hello @rushikeshvartak thank you for this, the first part works, what does the Delete Account option do, those is delete completely those account in SAVINT?, If so it's the option we are looking for because in the application they have create fake account with ${ACCOUNT.NAME} and when we are running the job to importaccount it's trying to put those ${ACCOUNT.NAME}into a ${id} so it give us error and i want to juste remove them to fix the import on those account

[This post has been edited by a Moderator to remove sensitive information.]

[rushikeshvartak]

as per audit/GDPR concern.you can't delete any accounts. you can mark suspended only

[PascalMontreuil]

@rushikeshvartak it worked, THANK YOU for your great support