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 [EMAIL PROTECTED]
w phpgroupware.org
j [EMAIL PROTECTED]
sip [EMAIL PROTECTED]
_ ____ __ __
_ __ | |__ _ __ / ___|_ __ ___ _ _ _ _\ \ / /_ _ _ __ ___
| '_ \| '_ \| '_ \| | _| '__/ _ \| | | | '_ \ \ /\ / / _` | '__/ _ \
| |_) | | | | |_) | |_| | | | (_) | |_| | |_) \ V V / (_| | | | __/
| .__/|_| |_| .__/ \____|_| \___/ \__,_| .__/ \_/\_/ \__,_|_| \___|
|_| |_| |_|Web based collaboration platform
_______________________________________________
phpGroupWare-developers mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/phpgroupware-developers
