Results 1 to 7 of 7

Thread: Change how contacts are stored

  1. #1
    glennbtn is offline Loyal Member
    Join Date
    Dec 2009
    Location
    Worthing. UK
    Posts
    97
    Rep Power
    5

    Default Change how contacts are stored

    HI

    I have around 500 contacts which have been stored as last name, first name. I would like to store them the other way around. I have tried to export to csv which shows in the correct format, but when imported it's always done by last name, first name.

    Is there anyway I can change this. Currently running Zimbra enterprise V7

    Thanks

    Glenn

  2. #2
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,566
    Rep Power
    57

    Default

    Quote Originally Posted by glennbtn View Post
    Is there anyway I can change this. Currently running Zimbra enterprise V7
    You've posted this question in the Zimbra Desktop forum so my first question would be: what is "Zimbra enterprise V7" - there's no such product. Do you mean Zimbra Desktop or Zimbra Collaboration Server?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    glennbtn is offline Loyal Member
    Join Date
    Dec 2009
    Location
    Worthing. UK
    Posts
    97
    Rep Power
    5

    Default

    Oops Sorry. Should be in Zimbra Server

    Will try and work out how to move it

  4. #4
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,566
    Rep Power
    57

    Default

    Quote Originally Posted by glennbtn View Post
    Will try and work out how to move it
    You can't, I'll move it.

    After you've exported the contacts, have you deleted them from the account (and emptied the Trash) befopre importing them again?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  5. #5
    glennbtn is offline Loyal Member
    Join Date
    Dec 2009
    Location
    Worthing. UK
    Posts
    97
    Rep Power
    5

    Default

    Yes delete them all and cleared it out. Then imported but saved as last name, first name.

    There we no options at all regarding saving.

    Thanks

  6. #6
    storm's Avatar
    storm is online now Advanced Member
    Join Date
    May 2006
    Location
    London, UK
    Posts
    180
    Rep Power
    9

    Default

    When you exported the contacts, did you use the 'Account Contacts' type? That would be the best to use (it is the only type that save all data (except tags and photos). You should have a .csv file downloaded.

    1) Open the .csv file in a text editor or spreadsheet application.

    2) One should see a field column labelled 'fileAs'.

    3) Change the value for each contact - in the 'fileAs' column - to the desired number from the following list:

    (Blank) = Last, First
    1 = Last, First
    2 = First Last
    3 = Company
    4 = Last, First (Company)
    5 = First Last (Company)
    6 = Company (Last, First)
    7 = Company (First Last)
    8 = Custom - one must type: 8:<custom string>

    4) Import the resulting CSV file (as 'Account Contact' type).

    RELATED BUGS

    Unfortunately, Zimbra doesn't currently permit users to change the default fileAs setting.

    Vote for these bugs if they would help you:

    Allow user to change default fileAs value:
    https://bugzilla.zimbra.com/show_bug.cgi?id=8723

    Allow user to add custom fileAs string (when creating a contact):
    https://bugzilla.zimbra.com/show_bug.cgi?id=3218

    Add fileAs strings for Nickname and Company (Department).
    https://bugzilla.zimbra.com/show_bug.cgi?id=41681

    LOST DATA

    When exporting and importing two types of data are lost: tags and contact photos. I'm not aware of a convenient way to backup and restore contact photos, but you can preserve the tags:

    When importing one can add a field/column labelled 'Category' and include tag names there (separated by commas).

    When exporting one can export using 'Yahoo contacts' type - this will include contact tags (but exclude other information one may want).

    As a workaround, one could export both Yahoo-type and account-type and copy to the Category column from the Yahoo-type .csv file to the account-type file.
    Last edited by storm; 11-04-2011 at 08:02 AM. Reason: Clarity

  7. #7
    bujangrm's Avatar
    bujangrm is offline Starter Member
    Join Date
    Aug 2013
    Location
    Kuching Sarawak Malaysia
    Posts
    1
    Rep Power
    1

    Default

    Does the bug fixed?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 05-12-2008, 05:32 AM
  2. Importing Cardscan contacts through Outlook
    By mtense in forum Administrators
    Replies: 0
    Last Post: 03-04-2008, 07:20 PM
  3. Cannot delete Contacts
    By zzzzsg in forum Administrators
    Replies: 5
    Last Post: 05-09-2006, 01:50 PM
  4. 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
  •