Results 1 to 4 of 4

Thread: Query mysql DB user addressbooks

  1. #1
    Junior Member
    Join Date
    Oct 2014
    Posts
    4

    Query mysql DB user addressbooks

    Hi there,

    I am hoping someone might have done this before or can assist me in how to achieve this. Basically I am just looking for a mysql query that can extract the email addresses from all users on the Zarafa system's address books. My server is a standard Zarafa 7.1.11 setup with the standard mysql DB as backend.

    Thanks in advance for any assistance.

    Best,

    Keith

  2. #2
    Zarafa
    markb's Avatar
    Join Date
    Sep 2013
    Location
    Delft
    Posts
    124
    Hi Keith,

    We do not encourage the direct usage of the database.

    That being said this is probably something you could do in python with python-zarafa or in php with php-mapi.

    Good Luck

  3. #3
    Junior Member
    Join Date
    Oct 2014
    Posts
    4
    Ah! Thanks Mark, python-zarafa looks as if can do nicely. :-)

    Many thanks!

  4. #4
    Zarafa
    markb's Avatar
    Join Date
    Sep 2013
    Location
    Delft
    Posts
    124
    Hi Keith,

    Here is a little something to help you get started.

    This will create a csv stype dump for the contacts of the users.

    Good Luck
    Last edited by markb; 04-11-2014 at 09:23 AM. Reason: more sane code

Similar Threads

  1. Outlook doesn't use addresses in public addressbooks
    By smguenther in forum Outlook client
    Replies: 3
    Last Post: 08-05-2013, 02:27 PM
  2. [Resolved] MySQL query making big iowait
    By hlepesant in forum Installation and Configuration Archives
    Replies: 12
    Last Post: 11-04-2011, 08:24 AM
  3. Harware for Zarafa : Query
    By jjksaji in forum Installation and Configuration Archives
    Replies: 1
    Last Post: 12-10-2010, 07:25 AM
  4. Problem with query -> Check
    By in forum Z-Merge Development Archives
    Replies: 0
    Last Post: 05-03-2009, 02:25 PM
  5. Query to get all calendar entrys for a single user
    By thormanj in forum PHP Development Archives
    Replies: 1
    Last Post: 12-01-2009, 10:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •