Results 1 to 8 of 8

Thread: Direct Access to Contacts

  1. #1
    ronnyek is offline Senior Member
    Join Date
    Dec 2006
    Posts
    58
    Rep Power
    8

    Default Direct Access to Contacts

    Unfortunately we've found out after the fact that our contact import mangled most of the email addresses with some RFC encoding, and I was curious if I could modify files in the filesystem rather than trying to get all contacts for all accounts one by one via soap.

    Its a one time update to replace =2e with . etc.

  2. #2
    dkarp is offline Zimbra Employee
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    11

    Default

    Sorry, but contacts are not stored in the filesystem. They're in the database.
    Bugzilla - Wiki - Downloads - Before posting... Search!

  3. #3
    ronnyek is offline Senior Member
    Join Date
    Dec 2006
    Posts
    58
    Rep Power
    8

    Default

    in a place where I can manually update via a sql statement? Or in meta...

    eg,

    mboxgroup*.mailitems etc?

    I know common sense, would make too much sense... and being that way we've got to have 200k tables that dont represent objects in the application (like normal application designers would have gone about it)... theres got to be a way I can do this without having to go through all 3500 accounts * number of contacts one by one via soap.

  4. #4
    dkarp is offline Zimbra Employee
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    11

    Default

    Can you just delete all the contacts and then re-import?
    Bugzilla - Wiki - Downloads - Before posting... Search!

  5. #5
    ronnyek is offline Senior Member
    Join Date
    Dec 2006
    Posts
    58
    Rep Power
    8

    Default

    I dont have the pleasure of dealing with static or nonlive deployment, so no.. thats not an option, users have undoubtedly added/removed contacts since our go live etc... oh well

  6. #6
    dkarp is offline Zimbra Employee
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    11

    Default

    I'd still suggest going through the "front door" of the SOAP API. Editing the METADATA column of the MAIL_ITEM tables is difficult because the encoding for the column (BEncoding) encodes strings with a leading length, so in-place editing of incorrect values will not work unless the values' lengths remain identical.
    Bugzilla - Wiki - Downloads - Before posting... Search!

  7. #7
    Rich Graves is offline Outstanding Member
    Join Date
    Jan 2007
    Location
    Minnesota
    Posts
    718
    Rep Power
    9

    Default

    Could he delete where type=contact and timestamp<migration (preserving subsequent user adds/edits), and then reimport? Or would that lead to irreconcilable inconsistency with separately maintained metadata, like the count of items in the folder?

    I've got a far simpler issue; I'm migrating a legacy sub.example.com into example.com and want to purge all contacts like @sub.example.com.

  8. #8
    dkarp is offline Zimbra Employee
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    11

    Default

    Quote Originally Posted by Rich Graves View Post
    Could he delete where type=contact and timestamp<migration (preserving subsequent user adds/edits), and then reimport? Or would that lead to irreconcilable inconsistency with separately maintained metadata, like the count of items in the folder?
    Yeah, that'd probably work pretty well, though it'd lead to duplicate contacts (the edited version and the re-imported version) when a contact was edited. Still, that's the best straight-to-DB solution that's been suggested.

    Quote Originally Posted by Rich Graves View Post
    I've got a far simpler issue; I'm migrating a legacy sub.example.com into example.com and want to purge all contacts like @sub.example.com.
    Unfortunately, you're probably going to need to go through the front door for this. You can likely script zmmailbox for this purpose, though.
    Bugzilla - Wiki - Downloads - Before posting... Search!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Access Zimbra on port 443 via apache
    By CatiaL in forum Administrators
    Replies: 1
    Last Post: 06-15-2007, 02:11 AM
  2. Replies: 5
    Last Post: 03-01-2007, 03:20 AM
  3. Cannot delete Contacts
    By zzzzsg in forum Administrators
    Replies: 5
    Last Post: 05-09-2006, 01:50 PM
  4. Moving contacts to other folders.
    By McPringle in forum Users
    Replies: 3
    Last Post: 05-05-2006, 06:30 PM
  5. vbscript to convert Thunderbird contacts
    By zzzzsg in forum Administrators
    Replies: 0
    Last Post: 05-04-2006, 02:00 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
  •