Dear community,
due to a missformated csv file doing a bulk import, thousands of external organization were created... Is there a way to delete them easily or is the only solution to delete it one by one? Which would be a really really difficult and long job.
Thanks in advance for your help.
Kind regards,
N.
You could write a quick script using the External Contacts APIs to get the list of external orgs and then delete them.
Hello Tim Smith,
write a script from what tool?
Do you know if Genesys could solve this if I open a ticket in the customer care center?
I guess that they have tools to delete everything there?
Thanks in advance for your answer.
Kind regards.
Do you still have the csv file? You can reimport the file and delete the organizations that way.
Hello Lucie,
Yes I still have the CSV but don't get your point. If I import the exact same CSV through bulk import it won't delete the organizations.
What would be your suggestion?
Kind regards,
NT.
These are the instructions:
CSV
To indicate that you want a contact deleted, add the column {{Contact Deleted}} to the spreadsheet and an {{x}} to the row. For external orgs, do the same in the {{Account Deleted}} column. The entry will only be deleted if {{x}} is supplied, no other string (ex. {{yes}}, {{Deleted}}, {{go for it!}} ) will be accepted ) , though it is case insensitive and will ignore whitespace.
Cascading
When an external organization is deleted, contacts service will automatically delete contacts that belong to it. This behavior is unchanged.
Caveats
We do not guarantee precisely how the file is processed in terms of order, batching, etc. As a result, we do not specify what happens if you have multiple, conflicting entries within the same CSV. For example, if you have an external org defined 10 times, and 5 instances are flagged for deletion, we cannot guarantee whether that external org is deleted or not, and which contacts will be associated with it. Customers should have consistent values throughout their uploaded csv
Lucie,
first of all thanks for taking time to help me here 
I did try what you suggested to see if it works on little sampe but didn't worked.
Here is the schema that my CSV is following to add organizations through bulk import :
Contact Id,Contact First Name,Contact Last Name,Contact Title,Contact Work Phone,Contact Country Code,Account Id,Account Name
When I tried like this : Contact Id,Contact First Name,Contact Last Name,Contact Title,Contact Work Phone,Contact Country Code,Account Id,Account Name,Account Deleted
the organization was not removed.
Maybe I misunderstood what you explained?
Kind regards,
NT
Correct, an example CSV may look like:
|Contact Deleted ||Contact Id||Contact Name || Account Deleted || Account Id || Account Name||
| x |C1| Bob | | A1 | Akashi |
| |C2| Steve | x | A2 | Zayka |
Where account A2 would be deleted since there was an "x" in the Account Deleted column. Account A1 was not deleted since there was no "x" in the Account Deleted column.
Lucie,
it worked!
Amaizing, you saved my day
Kind regards,
NT.
Glad it helped!
This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.