05-22-2012 11:49 AM
We recently deleted 40k contacts from our ACT! database. Now, we have MANY empty companies (no contact linked to it) and we would like to remove them. Is there a way (or an addon) where this can be done all at once?
Any help appreciated.
Harlee
05-22-2012 03:38 PM
Hi harlee_m.
From my interpretation of what you wrote, from the contact detail view I would do a lookup of all contacts with no contacts and company exists.
Now I am assuming you are confident that you have deleted the contacts from companies and in fact the companies do not have any contacts. PLEASE do a backup before doing this.
After you do this lookup, you cn then delete every company that meets the criteria.
05-23-2012 07:01 AM
Thank you John! That sounds like what I need to do, but I don't quite understand the first search line you used (all contacts with no contacts) and I can't clearly see the attached image.
Could you please type out the search criteria, or attach a picture at a higher resolution? I would appreciate this greatly!!!
I think the second line was a search for Company field contains data (?)
I would appreciate any additional help. I predict I have about 6000 companies without contacts attached.
01-17-2014 09:45 AM
John,
Can you write out the query to find all companies that contain no contacts? I want to delete all the empty companies.
Wendell
01-17-2014 10:33 AM
Well, I guess I must have been thinking of a different solution.
I know you have a lot of entries, but with what comes with the program, I guess I would do a lookup of all companies and sort by company.
Then scroll down and look for companies without a contact next to it.
Every other formulae that I tried didn't address a company that exists and has both contacts names with and without data.
Again, make sure you do a backup before you try anything.
Hey ACT gurus, what am I missing? Is there a way?
The logic woud be:
Companies with data in the name field AND no contact with data in the name field.
05-16-2016 12:11 PM
The best solution would be to make the Contact count that displays in the bottom of the company detail view searchable. I would like to be able to deleted all Companies that have no contacts or have only 1 contact.
05-24-2016 07:21 AM - edited 05-24-2016 07:22 AM
We have a free add-on for this called ContactLess Companies.