Is there a way to delete empty companies?

[harlee_m]

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

[jnpurdy]

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.

[harlee_m]

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.

[wbmcadoo]

John,

Can you write out the query to find all companies that contain no contacts?  I want to delete all the empty companies.

Wendell

[jnpurdy]

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. 

[mjmcpe]

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.

[gcavin]

We have a free add-on for this called ContactLess Companies.