Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: export account from Web Admin Panel

  1. #11
    buggz is offline Active Member
    Join Date
    Apr 2009
    Location
    Zimbabwe
    Posts
    27
    Rep Power
    6

    Default

    thanks , i managed to make it work,
    the output is as below:
    HTML Code:
    nkomazanas@mydomain.co.zw
    
    nkomazanas
    
    nkomazanas
    
    chirimumimbac@mydomain.co.zw
    
    chirimumimbac
    
    chirimumimbac
    thanks a lot, so i am now formatitng it in such a way that i can include commas .
    eg: chirimumimbac@mydomain.co.zw,chirimumimbac,chirimumimbac
    nkomazanas@mydomain.co.zw,nkomazanas,nkomazanas

    thanks

    buggz

  2. #12
    rjwesten is offline Junior Member
    Join Date
    Sep 2009
    Posts
    9
    Rep Power
    5

    Default

    Why not just do this:

    zmprov -l gaa -v | grep name | awk '{print $3}'

  3. #13
    doolilo is offline Starter Member
    Join Date
    Sep 2009
    Posts
    1
    Rep Power
    5

    Default tool for exporting accounts

    Simply log into the admin console, search using the following string (!(zimbraAccountStatus=*.*)) and then click on download to download to csv.

    hope this helps

  4. #14
    pperico is offline Starter Member
    Join Date
    Aug 2011
    Posts
    1
    Rep Power
    3

    Default Python code for export to csv

    #! /usr/bin/env python
    # this script requires you have extracted the file list with the zimbra CLI: zmprov -l gaa -v > /tmp/list. Plus the path in which you save the script has to be the same of the list file.
    elisa_file = open("/tmp/list","r")
    lista = []
    record = {}
    for row in elisa_file.readlines():
    if row.strip() == '':
    lista.append(record)
    record = {}
    if row[0] == '#':
    pass
    else:
    record.update({row[:row.find(':')]: row[row.find(':')+1:]})

    for x in lista:
    dato = ""
    if 'mail' in x: dato = dato + x['mail']
    if 'displayName' in x: dato = dato.strip("\n") + ',' + x['displayName']
    dato = dato.strip("\n")
    print dato

    -------
    To execute: python yourscript.py > yourexport.csv
    And now import in excel

Page 2 of 2 FirstFirst 12

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] my server stopped working???
    By cecil in forum Administrators
    Replies: 4
    Last Post: 04-20-2008, 08:07 AM
  2. installation error during ldap setup
    By ljramos in forum Installation
    Replies: 23
    Last Post: 08-10-2007, 10:48 PM
  3. unable to restart zimbra after reboot
    By droefs in forum Administrators
    Replies: 28
    Last Post: 04-16-2006, 02:33 PM
  4. Replies: 16
    Last Post: 01-05-2006, 09:55 AM
  5. After Succesfull Install, Cannot Start mta
    By bsimzer in forum Installation
    Replies: 26
    Last Post: 12-16-2005, 05:45 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
  •