How to export distribution list to .csv?

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

How to export distribution list to .csv?

Postby stock99 » Mon Jun 02, 2008 11:12 pm

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?

Postby uxbod » Tue Jun 03, 2008 1:21 am

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?

Postby nero » Tue Jun 03, 2008 7:31 pm

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?

Postby nero » Wed Jul 30, 2008 11:22 pm

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?

Postby mmorse » Thu Jul 31, 2008 12:49 am

Have a look at this thread:

http://www.zimbra.com/forums/etc/19968-solved-looking-reporting-output-names-alias-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?

Postby nero » Thu Jul 31, 2008 12:56 am

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

Return to “General Questions”

Who is online

Users browsing this forum: No registered users and 4 guests