Distribution list

[indu]

Can we add members to a distribution list from a .csv file (as CLI)

[chh]

You can import lists on the Zimbra server using

zmprov adlm dl@zimbraserver.com user@mail.com

Put that into a script and you are done.
You can use "zmprov rdlm" to easily remove mail addresses from the list as well.

Christian

[indu]

Thansk for the reply..
can i import a csv file as a whole into this script instead of typing addresses

[chh]

Hi,

I currently have no access to our script so I cannot copy it (and it is very simple still)

What it does is read 2 text files with an email address in each line.
One is for addresses to be added and one for those removed.
Theses addresses are simply used as arguments for the commands from my post above.

Christian

[uxbod]

why not just do :-

#!/bin/bash

while read X
do
  zmprov adlm dl@zimbraserver.com ${X}
done < file.csv

Dependant on how many fields are in your CSV file you may need to parse them first. So if two fields you could do :-

cat file.csv | awk -F, '{ print $1 }' | xargs -i zmprov adlm dl@zimbraserver.com {}

[indu]

Can you please tell me how to populate them to the zimbra?
is it like after creating a csv file with zmprov adlm dl@zimbraserver.com user@mail.com with each user on a new line & then populating the list to as zmprov <filename.csv???
Am sorry coz we are new to zimbra admin...

[chh]

Simply use the script from uxbox which will do what you need.

The csv file will look like that:

user1@mail.com
user2@mail.com
user@address.com

[indu]

Thanks chh,uxbod..
shall give a try ..