Results 1 to 4 of 4

Thread: Users' address book

Hybrid View

  1. #1
    Join Date
    Nov 2006
    Posts
    52
    Rep Power
    8

    Question Users' address book

    Hey guys,

    Where do I look for a certain user's address book items? Like lets say I have a user's id 301 and/or account_id 1b7ffae4-366a-4746-82c8-cc65a4ec3aae. Where in the database do I look to see that user's address book emails? There are four tables in each user's mysql mailbox databases. Let's say the above user 301 with the databases name mailbox301 will have four tables:
    Code:
    appointment
    mail_item
    open_conversation
    tombstone
    Where to look?

    Thank you.

  2. #2
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    12

    Default Do you really want to do that?

    We don't suggest you do that. It's much, much, much more straightforward to get at the contact data in CSV or vCard format via the REST interface.

    However, if you really want to go straight to the database, the contact data is in the METADATA column of the MAIL_ITEM table. Contacts are rows for which TYPE = 6. To decode this data, convert to a string (the column data is in UTF-8) and then use the BEncoding decoder of your choice.
    Last edited by dkarp; 03-16-2007 at 01:51 PM.
    Bugzilla - Wiki - Downloads - Before posting... Search!

  3. #3
    Join Date
    Nov 2006
    Posts
    52
    Rep Power
    8

    Default

    What is REST interface?

  4. #4
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    12

    Default Please search first.

    You need to work with us here. There's a wiki and there's a large quantity of old threads in the forums. You need to look there before asking questions.

    Anyway, here's a good place to get started in the wiki.
    Bugzilla - Wiki - Downloads - Before posting... Search!

Similar Threads

  1. [SOLVED] Zimbra not syncing properly with Address Book and iCal
    By Colin Day in forum CalDAV / CardDAV / iSync
    Replies: 4
    Last Post: 07-13-2007, 08:52 AM
  2. syncing an address book between multiple users
    By rlustemberg in forum CalDAV / CardDAV / iSync
    Replies: 0
    Last Post: 06-22-2007, 03:55 AM
  3. Users not showing up in Address book
    By DanCody in forum Administrators
    Replies: 9
    Last Post: 04-18-2007, 12:56 PM
  4. Seeing other domain users in Address Book
    By moniker in forum Users
    Replies: 1
    Last Post: 03-08-2007, 01:49 PM

Posting Permissions

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