How to export distribution list to .csv?

General discussion about Zimbra Desktop.
Post Reply
stock99
Posts: 22
Joined: Fri Sep 12, 2014 11:12 pm

How to export distribution list to .csv?

Post by stock99 »

Hi all,
Is there any way to export distribution list to .csv file? Sorry i am newbie in Zimbra. Maybe this question was posted on forum already but I couldn't find it. Thanks if anyone can enlighten me.
uxbod
Ambassador
Ambassador
Posts: 7811
Joined: Fri Sep 12, 2014 10:21 pm

How to export distribution list to .csv?

Post by uxbod »

Zmprov - Zimbra :: Wiki
su - zimbra

zmprov gdlm distribution@list.name
nero
Posts: 12
Joined: Fri Sep 12, 2014 11:33 pm

How to export distribution list to .csv?

Post by nero »

Thanks uxbod! stock99 is my friend and i was using his account to ask the question before. I have learn more on zmprov thanks to uxbod but i still can't quite get it export to an .csv file. I used the command line, the result i get is another distribution list. Can anyone provide an example of how to use :

zmprov gdlm distribution@list.name and where/how i output the file into .csv? I have check the zmprov help but it did not give me the info i needed.
nero
Posts: 12
Joined: Fri Sep 12, 2014 11:33 pm

How to export distribution list to .csv?

Post by nero »

Hi uxbod,
After some tweaking around, i found there is a way to export GAL to .txt file and save it later as .csv file. But this way is not from zimbra but thru outlook save as .txt file. Problem solved.....
mmorse
Ambassador
Ambassador
Posts: 6036
Joined: Fri Sep 12, 2014 10:24 pm

How to export distribution list to .csv?

Post by mmorse »

Have a look at this thread:

http://www.zimbra.com/forums/etc/19968- ... s-etc.html

(awk 'ORS=","' > file.csv is handy)
nero
Posts: 12
Joined: Fri Sep 12, 2014 11:33 pm

How to export distribution list to .csv?

Post by nero »

Yes this is what i am looking for. Thank You! :D


To print out the members for a given distribution list:

Code:
zmprov gdl dist-list@domain.com > dist-list.txt
Post Reply