export account from Web Admin Panel

[buggz]

thanks , i managed to make it work,
the output is as below:

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

[rjwesten]

Why not just do this:

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

[doolilo]

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

hope this helps

[pperico]

#! /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