Re: [phpGroupWare-developers] deleting all contacts (was (no subject))

[Dave Hall]

On Fri, 2007-06-22 at 11:06 +0200, L. Mattera wrote:
> how can I eliminate all my contacts in a single step (if possible) 
> withouth deleting them one by one
> (I have imported in a wrong way and therefore all contacts appear to be 
> empty)
> thank you very much for your help

This is more a user list question, but i will answer it here.

The only way to currently do this is via database directly, it isn't
possible via the web gui.

The easiest way is to run TRUNCATE on each of the tables.

The tables you need to run it on are:

* phpgw_contact
* phpgw_contact_addr
* phpgw_contact_comm
* phpgw_contact_note
* phpgw_contact_org
* phpgw_contact_org_person
* phpgw_contact_others
* phpgw_contact_person

So you would run something like this for each one:

TRUNCATE phpgw_contact;

I would recommend that you back up your database first.

Cheers

Dave
-- 
Dave Hall (aka skwashd)
API Coordinator
phpGroupWare
e address@hidden
w phpgroupware.org
j address@hidden
sip address@hidden
       _            ____                    __        __             
 _ __ | |__  _ __  / ___|_ __ ___  _   _ _ _\ \      / /_ _ _ __ ___ 
| '_ \| '_ \| '_ \| |  _| '__/ _ \| | | | '_ \ \ /\ / / _` | '__/ _ \
| |_) | | | | |_) | |_| | | | (_) | |_| | |_) \ V  V / (_| | | |  __/
| .__/|_| |_| .__/ \____|_|  \___/ \__,_| .__/ \_/\_/ \__,_|_|  \___|
|_|         |_|                         |_|Web based collaboration platform