Webtop Contacts export

Hi @wbilger,
I don’t know that it was ever possible to export a phonebook from the WebTop interface :wink:.
It is a feature that is present in currently low priority roadmaps.

If you want you can always export a category of contacts via postgres commands like this:

  1. access the webtop5 database:
    su - postgres -c 'psql webtop5'

  2. identify the category_id of the address book to be exported:
    select * from contacts.categories;

  • if you know the username that is the owner of the address book (eg: foo):
    select * from contacts.categories where user_id = 'foo';
  1. hypothesizing that the number of the address book to be exported is X and the CSV file is to be called ‘address_exported.csv’:

copy (select title,firstname,lastname,nickname,gender,company,function,work_address,work_city,work_state,work_postalcode,work_country,work_telephone,work_telephone2,work_fax,work_mobile,work_pager,work_email,assistant,assistant_telephone,department,manager,home_address,home_city,home_state,home_postalcode,home_country,home_telephone,home_telephone2,home_fax,home_mobile,home_pager,home_email,notes from contacts.contacts where category_id='X' and is_list='f' and revision_status != 'D') to '/tmp/address_exported.csv' delimiter ',' csv header;

  1. download the file /tmp/address_exported.csv

I hope it helps you :wink:

5 Likes