How to export global address list to csv file.

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
davidkillingsworth
Outstanding Member
Outstanding Member
Posts: 204
Joined: Sat Sep 13, 2014 2:26 am
ZCS/ZD Version: 8.8.15.GA.3829.UBUNTU14.64 -Patch 1

How to export global address list to csv file.

Postby davidkillingsworth » Fri Apr 20, 2012 2:57 am

Use the following steps to get GAL from CLI mode.
Login to CLI mode

su zimbra

zmprov -l gaa |less > gal.csv

Copy the gal.csv file


tirgil
Posts: 17
Joined: Sat Sep 13, 2014 2:33 am

How to export global address list to csv file.

Postby tirgil » Fri Apr 20, 2012 6:53 am

You can do it from admin panel.
Admin Interface > Accounts

and then just click search button with empty text :) when search result comes click download button.
regards

Capture.jpg

User avatar
ccelis5215
Outstanding Member
Outstanding Member
Posts: 609
Joined: Sat Sep 13, 2014 2:04 am
Location: Caracas - Venezuela
ZCS/ZD Version: 8.0.9.GA.6191.UBUNTU12.64 FOSS

How to export global address list to csv file.

Postby ccelis5215 » Fri Apr 20, 2012 7:14 am

If you want a list of accounts, it works.
But, you are no getting GAL data.
ccelis.
davidkillingsworth
Outstanding Member
Outstanding Member
Posts: 204
Joined: Sat Sep 13, 2014 2:26 am
ZCS/ZD Version: 8.8.15.GA.3829.UBUNTU14.64 -Patch 1

How to export global address list to csv file.

Postby davidkillingsworth » Mon Apr 23, 2012 5:19 am

[quote user="tirgil"]You can do it from admin panel.
Admin Interface > Accounts

and then just click search button with empty text :) when search result comes click download button.
regards[/QUOTE]
Thank You. That is a much easier method.
It solves my problem nicely.
limars
Posts: 4
Joined: Sat Sep 13, 2014 2:36 am

How to export global address list to csv file.

Postby limars » Mon May 21, 2012 3:07 am

[quote user="davidkillingsworth"]Use the following steps to get GAL from CLI mode.
Login to CLI mode

su zimbra

zmprov -l gaa |less > gal.csv

Copy the gal.csv file[/QUOTE]
hi, forgive me on this, dont know much on linux commands, is it

zmprov -l(small letter L)(space)gaa |(pipe)less > gal.csv (or is it ok for any other file name?)
i've tried this syntax

zmprov -l gaa less > 05202012.csv

-bash: 05202012.csv: Permission denied
does it mean i have no permission to create the file? any help on this, thanks.
limars
Posts: 4
Joined: Sat Sep 13, 2014 2:36 am

How to export global address list to csv file.

Postby limars » Mon May 21, 2012 3:10 am

oh sorry the command i've use is this
zmprov -l gaa | less > 05202012.csv
same error, permission denied
davidkillingsworth
Outstanding Member
Outstanding Member
Posts: 204
Joined: Sat Sep 13, 2014 2:26 am
ZCS/ZD Version: 8.8.15.GA.3829.UBUNTU14.64 -Patch 1

How to export global address list to csv file.

Postby davidkillingsworth » Mon May 21, 2012 3:19 am

Please see my post above. The much much easier method to do this is to go through the admin panel.

If">http://www.zimbra.com/forums/administrators/53907-how-export-global-address-list-csv-file-2.html#post240688
If
you still want to try and do it with the command line, you probably need to change to the Zimbra user first.
On Ubuntu:

$ sudo su - zimbra
limars
Posts: 4
Joined: Sat Sep 13, 2014 2:36 am

How to export global address list to csv file.

Postby limars » Mon May 21, 2012 4:31 am

I have also tried that, but when i click the download button it opens another window/tab with just a blank page without any error message displayed.
davidkillingsworth
Outstanding Member
Outstanding Member
Posts: 204
Joined: Sat Sep 13, 2014 2:26 am
ZCS/ZD Version: 8.8.15.GA.3829.UBUNTU14.64 -Patch 1

How to export global address list to csv file.

Postby davidkillingsworth » Mon May 21, 2012 5:02 am

Have you tried another, up-to-date browser such as Chrome/Firefox?
limars
Posts: 4
Joined: Sat Sep 13, 2014 2:36 am

How to export global address list to csv file.

Postby limars » Mon May 21, 2012 5:19 am

yup, tried ie, firefox and chrome, all latest versions. we're using Release 6.0.4_GA_2038.RHEL5_64_20091214192925 CentOS5_64 FOSS edition

Return to “Administrators”

Who is online

Users browsing this forum: No registered users and 6 guests